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:
MySQL Backups Done Easily
MySQL Backups Done Easily
One thing that comes up a lot on sites like Stackoverflow and the like is how to backup MySQL databases.The first answer is usually use mysqldump. This is all fine and good, till you start to want to dump multiple databases. You can do this all in one like using the –all-databases option however this makes restoring a single database an issue, since you have to parse out the parts you want which can be a pain.
Difficulty:
Export MySQL to CSV (Excel) using php
Export MySQL to CSV (Excel) using php
Export MySQL to CSV (Excel) using php complete code available.Just copy and paste it.Make sure your customize the mysql table according to your requirement.
Difficulty:
Fix Too many connections mysql_connect
Fix Too many connections mysql_connect
If you get a Too many connections error when you try to connect to the mysq server, then it clearly means that all available connections are in use.
Difficulty:
Why you Should be using PHP’s PDO for Database Access
Why you Should be using PHP’s PDO for Database Access
Many PHP programmers learned how to access databases by using either the mysql or mysqli extensions. Since PHP 5.1, there’s been a better way. PHP Data Objects (PDO) provide methods for prepared statements and working with objects that will make you far more productive!
Difficulty:
Making Unlimited Dynamic Sub-Categories
Making Unlimited Dynamic Sub-Categories
how to make unlimited dynamic sub-categories in multiple forms
Difficulty:
Creating MySQL Tables with PHP
Creating MySQL Tables with PHP
Learn how to create MySQL tables using PHP programming language.
Difficulty:
Inserting Posts Into Database
Inserting Posts Into Database
Learn how to insert posts into mysql database using PHP programming language.
Difficulty:
Get Posts From Database And Display Them
Get Posts From Database And Display Them
Learn how to get posts from MySQL database and how to display them.
Difficulty:
Listing MySQL Over Multiple Pages in PHP
Listing MySQL Over Multiple Pages in PHP
Easy way to break up MySQL records over multiple pages using only PHP and MySQL and no other technologies. Generates page numbers and linkages on the fly.
Difficulty:
PHP & MongoDB Sitting in a Tree: Part 1
PHP & MongoDB Sitting in a Tree: Part 1
The first part in a series of tutorials about using MongoDB with PHP.
Difficulty:
Building a live news blogging system in php. Spiced with HTML5, CSS3 and jQuery [part V]
Building a live news blogging system in php. Spiced with HTML5, CSS3 and jQuery [part V]
A series of tutorials on building a live news blogging system. Developed using HTML5, CSS3, jQuery for front end and php and jsp for backend.
Difficulty:
An Easy Guide to Mysql Integration
An Easy Guide to Mysql Integration
Learn how to successfully integrate MySQL with PHP.
Difficulty:
How to connect to a MySQL database
How to connect to a MySQL database
This simple tutorial shows you how to connect to a MySQL database server and select a database.
Difficulty:
PHP Ajax Shoutbox Tutorial
PHP Ajax Shoutbox Tutorial
In this tutorial we will create a simple PHP shoutbox with Ajax based messaging. It will ask the user to choose a nickname and then allow him/her to use it (no registration and password will be required).
Difficulty:
Building a live news blogging system in php. Spiced with HTML5, CSS3 and jQuery [part III]
Building a live news blogging system in php. Spiced with HTML5, CSS3 and jQuery [part III]
A series of tutorials on building a live news blogging system. Developed using HTML5, CSS3, jQuery, XML for front end and php and jsp for backend. In this third part we create methods to add new news items to our database.
Difficulty:
Total Tutorials in Category: 276