Upload Images With MySQL

Intro

Ok, let’s continue with tutorial requests. This tutorial will cover uploading images to MySQL database. It will not be classic tutorial where I write everything and go through each step, but it will be more like some tips.

Read the rest

Multi-Language Site

It’s been a while since I last posted something because I was very busy. So let’s do something useful now. Reader Tien Phuong requested a tutorial about multi-language sites and how to create them so now I’ll try to show you one way. We’ll use database to store our translations and languages. So let’s start.

Read the rest

Sql Queries Cache

This will be intermediate tutorial about caching SQL query results. We will use interface to make support for extending available ways of caching your results. We will create cache that will use MySQL database and flat text files to store cache.

Read the rest

MySQL Quite Complex Queries

I’ve read an article about database design. It’s very simple but I try to design my databases/tables following that article. But there is one thing that is also important. You need to design your tables and their relations so that you can get almost everything your need with as much queries as possible. This is a part that MySQL-s complex queries are very useful. In two last jobs that I did I needed to optimize script as much as possible. One project is a plugin for WordPress that I’m currently working on. When ever I do something I give my best to do it right and I really try to design relations and queries very good. Here are some examples of queries that I needed.

Read the rest