Subscribe
Tutorial search

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 !

Sort by:
“Who Is Online” Widget With PHP, MySQL & jQuery
“Who Is Online” Widget With PHP, MySQL & jQuery
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:
“Who Is Online” Widget With PHP, MySQL & jQuery
“Who Is Online” Widget With PHP, MySQL & jQuery
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:
Memcached in PHP
Memcached in PHP
Tutorial on how to install and use Memcached in PHP featuring implementation and usage.
Difficulty:
Wordpress Backup and Restore-Folders and Database-Video Tutorials
Wordpress Backup and Restore-Folders and Database-Video Tutorials
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:
Custom query string in CakePHP
Custom query string in CakePHP
This is CakePHP tutorial is about query function. Use your own query string instead of find function.
Difficulty:
An introduction to Databases in general
An introduction to Databases in general
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:
An alternative to ORDER BY RAND() for MySQL
An alternative to ORDER BY RAND() for MySQL
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:
Extracting a random row from sql database
Extracting a random row from sql database
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:
How to escape variables with PHP PEAR DB with bound placeholders
How to escape variables with PHP PEAR DB with bound placeholders
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:
Make a Client Area Part 1
Make a Client Area Part 1
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:
Record locking in Web applications
Record locking in Web applications
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:
Debugging MySQL issues in PHP
Debugging MySQL issues in PHP
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:
dynamic website part 2
dynamic website part 2
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:
Create an In-Place Editing System: One Step Further
Create an In-Place Editing System: One Step Further
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:
Creating a Blogging system (part 1)
Creating a Blogging system (part 1)
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