Subscribe
Tutorial search
Cool Stuff
How would you like to MASTER graphic design by next week?
Click here to find out how
Photoshop Templates
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
PHP Tutorials
Tutorials
Stuff
Affiliates
PHP Database Tutorials
We hope that you will enjoy our PHP Database tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own PHP Database tutorial to our site. Thank you !
We are making a “Who is online” widget with PHP, MySQL & jQuery. It will display the number of visitors, currently viewing your site, and a list of countries they are from in a slide out panel.
Difficulty: 


We are making a “Who is online” widget with PHP, MySQL & jQuery. It will display the number of visitors, currently viewing your site, and a list of countries they are from in a slide out panel.
Difficulty: 


Tutorial on how to install and use Memcached in PHP featuring implementation and usage.
Difficulty: 


As my blog grown fast and well, I was getting worry about safety of the blog. I had been doing many security techniques but at last I found that there is no best method to protect my blog other than taking backups. Yes. What ever you could do to protect your site, hackers able to broke your techniques.
Difficulty: 


This is CakePHP tutorial is about query function. Use your own query string instead of find function.
Difficulty: 


Developers often use the handy features included with databases to create solutions in PHP for what ever needs to be satisfied. Databases have functions like quickly matching data to Identifications, searching large sums of data, holding user information and much more that developers can utilize. There are many ways to use a database, or in this case, to interface with a database. Most databases use a rough standard of a Structured Querying Language, which is like code that the SQL server or app
Difficulty: 


I've posted previously about how to randomly order a resultset with MySQL using RAND() but the issue with RAND() is it will be inefficient on large tables because each row needs to have the random number calculated before the resultset can be ordered. This post looks at an alternative which requires two queries but will be much more efficient for large tables.
Difficulty: 


Many sites need to get some random values from the database, for example to show a random imagine, quote or in case of online stores to show random products.
Difficulty: 


A week ago I looked at how to escape a string for use with a SQL query using the PHP PEAR DB escapeSimple function. This is useful for embedding a variable directly into a SQL query string but it can be a lot easier to use bound placeholders instead and let PEAR DB do all the escaping.
Difficulty: 


A few days ago, I created a poll to see how many freelancers actually had a client area for their site. Surprisingly, I found out that only 23% of them had one so I decided to to write a tutorial for you guys. Even if you are a newbie to PHP or don’t need a client area, read this tutorial as it would help you improve your PHP skills.
Difficulty: 


In this article we describe how to implement record locking in web applications. Because of the stateless nature of HTTP, you cannot really know whether the user left the page or is still looking at your site. We used the lock confirmation technique combined with lock expiration to solve this problem.
Difficulty: 


Possibly the most common issue users have with PHP is working with MySQL. When a query fails, many users don't know where to begin debugging. This guide outlines my debugging procedure.
Difficulty: 


Part 2 of the "dynamic website" tutorial serie. In this part we will create a basic database and query this database to display the articles. We'll then implement a very simpel but kick ass pagination.
Difficulty: 


A few months ago, you learned how to create an in-place editing system. Today, we'll take things a step further as we create a simple backend, which will allow our website to remember the changes that we've made.
Difficulty: 


Create your own Blogging System (a simplified version of Wordpress) using PHP and MySQL. Learn how to sanitize your entries using mysql_real_escape_string function and learn how to add the blog posts to your database.
Difficulty: 

Total Tutorials in Category: 258
