Category Archives: MySQL
Dynamic image slider using Twitter Bootstrap & PHP with MySQL
I have received many requests from my readers to create image slider with admin where they can edit images and update text, so in this tutorial I am going to show you how to create image slider to get images, title and description from database and slide images. Using twitter bootstrap I have created a very simple and easy to understand slider and PHP & MySQL for dynamic option.
[ Read More ]
How to use PDO database connection in PHP
As we all know that in PHP 5.5 MySQL is deprecated and we have to move new extensions like MyQLi or PDO (PHP Data Objects) for database integration, we have already publish an article on How to use MySQLi_connect PHP and this article will explain you how to connect with MySQL database using PDO connection and we explain very few things in this tutorial like database connection, insert, delete, update and select queries with prepare statement, multiple insert and error handling.
[ Read More ]
How to create Advanced Pagination in PHP & MySQL with jQuery
We have already created 2 pagination[1][2] articles for PHP Developers and this one is the advanced version of pagination with "..." many readers requested me to make it with these dots, so today I am going to write this article on advance pagination with jQuery and show you how to show small list of numbers with dots in between.
[ Read More ]
How to create forget password recovery procedure in PHP
Few days ago we post and tutorial on login and signup procedure and today i am going to write an other element of that login procedure for PHP Developers which is recover your password using email verification with encrypted key.
[ Read More ]
How to manage international languages in MySQL database
If you are making a web site where multiple languages used like Arabic, French, Hindi or Urdu then your MySQL database default settings is not valid to do that to insert all languages in database. If you insert data in your database and database is not configured as i am going to show you in this tutorial then your data will be look like ????? and you lost your data.
[ Read More ]
How to use MySQLi_connect in PHP
As you all knows that MySQLi is improved PHP extension of MySQL which is introduced in PHP 5. MySQL is deprecated in PHP 5.5 will be removed in future. We have millions of applications using PHP MySQL and needs to be updated on MySQLi or PDO (PHP Data Objects is also a new extension you can use to use in your applications). So today i am going to give you a very simple integration guide of MySQLi how to connect to a database, how to run a query and insert records etc hope you love this article.
[ Read More ]
How to create pagination in PHP and MySQL with AJAX
I have wrote an article on pagination with a simple class and many users like it and download it so now i have decided to write its and updated version with AJAX.In this article i am going to explain you how to create pagination in PHP & MySQL with AJAX for your websites.Pagination is a very important part in your websites reporting and this article will help you to create it very very simple.
[ Read More ]
