Главная » Ссылки с тэгом "mysql"

Ссылки с тэгом "mysql" 

Визуальное представление работы команды JOIN языка SQL

В очень простой форме (собственно в виде примеров в картинках) показано как работают различные JOIN'ы в SQL.

I thought Ligaya Turmelle's post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams didn't quite match the SQL join syntax reality in my testing.

I love the concept, though, so let's see if we can make it work. Assume we have the following two tables. Table A is on the left, and Table B is on the right. We'll populate them with four records each.

Читать полностью
Теги: mysql, sql, программирование, уроки, шпаргалки,

Оптимизация работы Yii-приложений

Performance of Web applications is affected by many factors. Database access, file system operations, network bandwidth are all potential affecting factors. Yii has tried in every aspect to reduce the performance impact caused by the framework. But still, there are many places in the user application that can be improved to boost performance.

Читать полностью
Теги: faq, mysql, php, yii, программирование,

5 Steps to secure your PHP powered website

Unfortunately there will always be some one out there on the world wide web who will attempt to break any thing they can find on the Internet so you owe it to your visitors/members to ensure nothing malicious is being hidden on your site and there info isn't being stolen. In this article i will cover 5 important steps you need to take to make sure your web site's secure.

Читать полностью
Теги: mysql, php, безопасность, программирование,

Welcome to Lion PHP Framework

Lion is an emerging open source PHP framework for creating rich web applications as a combination of the most valuable features and patterns taken from the development community.

This PHP framework is the perfect balance between rapid development, scalability and performance, meaning that it has been specially designed for people who need to reduce engineering efforts, people who need scalable architectures to maintain as well as people who need a thin-layer PHP framework to increase the performance as much as possible.

Читать полностью
Теги: cms, mysql, php, sql, фрэймворки,

Using PHP/MySQL with Google Maps

This tutorial is intended for developers who are familiar with PHP/MySQL, and want to learn how to use Google Maps with a MySQL database. After completing this tutorial, you will have a Google Map based off a database of places. The map will differentiate between two types of places—restaurants and bars — by giving their markers distinguishing icons. An info window with name and address information will display above a marker when clicked.

Читать полностью
Теги: api, mysql, php, sql, сервисы, уроки,

Simple PHP PDO Wrapper : light, static, easy

A few days ago, I was looking for a PDO wrapper to work with a small PHP application. I’ve searched around and found fractalizer’s PDO wrapper nearest to my purpose. Then I just wrote my wrapper on the shadow of his one.

Let’s see what’s inside and how it works.


  1. Easy to use.
  2. Works with MySQL and Sqlite.
  3. All pubic functions works statically.
  4. Connection string created internally. 

Читать полностью
Теги: mysql, php, программирование, халява,

Тьма сниппетов для вэб-разработчиков

Большая коллекция сниппетов (готовых к использованию кусков кода) для вэб-разработчиков.

Читать полностью
Теги: ajax, css, html, javascript, mysql, php, sql, программирование,

dbForge Studio for MySQL

Отличнейший бесплатный инструмент для администрирования баз данных и не только. Жаль, что нет версии под линукс 

Читать полностью
Теги: mysql, sql, утилиты,

Bookmark and Share
Страницы: 1
Просто совет
Два месяца бесплатного использования VPS-сервера с 20Гб SSD на борту. Интересует?
Тогда жми сюда.
Follow TanitaCMS in Twitter