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

Edit XML

I had an idea about creating tutorial that will cover manipulating XML in PHP. The idea was to create some software that will use XML as a database. But then I realized that it will take me to much writing (about 100 pages) so I may create some video tutorials later. But since I’ve got a lot of requests where readers asked from me to create some tutorial about editing XML so I decided to create simple tutorial.

Read the rest

Enable E-mail In PHP – Win

This will be a quick tutorial that will show you how to enable e-mail function in PHP on Windows.

Read the rest

PHP DomDocument Tutorial

This will be a quick tutorial that will show you how to use PHP’s DOMDocument to parse your XML so you do not have to use XML parser. In this tutorial you’ll see how to loop through your XML file and how to extract some specific data. For this, we will use XML file that is available on w3school.com.

Read the rest

PHP Confirm Registration Link

This will be quick tutorial on how you can implement confirm registration link into your PHP application. This will not be anything fancy, just simple HTML and PHP to show you how this work and one way how it can be implemented.

Read the rest

AJAX Multi-Level Comments

In this tutorial we will create multi level comments. You must have seen comments on youtube and that they have levels depending on who replied to who. That’s exactly what we will build.

Read the rest

Permissions Using Bitwise

This will be a quick tutorial on how to use bitwise operators in PHP to create permissions control. Some of next tutorials will cover how to implement it in application and how to use database to store permissions for users. Now some basics.

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