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
In this tutorial we will create walker class. This class will load results by executing given SQL query and then create multidimensional array that will have entries in right position. Let’s say that you have this data in your database.
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
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
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
If you ever had a bank account you are familiar with TAN-s (Transaction Authentication Number). What we will do today, is create user login using that kind of system. This will be just simple overview how to do it so you can create more complex and secure login systems. You need to have basic knowledge about classes, HTML, CSS and AJAX because I will not explain in depth what I do. Read the rest
This tutorial cover some of basics about jQuery and AJAX. We will build AJAX form submit where we will have 1 field. If we lave it blank and submit our form, we will get error message. If we fill it with some data we will get that text. We will also add some loader image.
Read the rest
Today web programmers have big problems with spam comments. There are a lot of tutorials about captchas and how to implement them, so I will not cover it here (I can do it f next tutorial if you wish). Anyway, I will show you some other methods that are good. Note that none of them is not 100% secure.
Read the rest
In this tutorial I’ll show you how to create a script that will create graphs. Those graphs will contain information about your files, their extensions and their size. We will use Google and their API for creating graphs. So lets start.
Read the rest
When writing tutorials you want that they are seen by a lot of people. For that i use 7 internet pages where i publish links to them. Process is simple. Write few information, provide post url, press submit button and your tutorial is in their database. I’ll write something about for 3 of them because they have a lot of visitors.
Read the rest