Category Archives: MySQLi
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 Price Range Slider in jQuery & PHP with MySQL
I have received many requests from my readers to create a price range slider, this article going to solve there problems so basically I used jQuery UI to perform this tutorial base which is jQuery and created a PHP and MySQL settings for ease of PHP Programmers so let see how it works and how to configure it in your websites. Mostly Developers use this slider in eCommerce sites where people can search products with price range.
[ Read More ]
How to create Like & Unlike System in PHP MySQL and jQuery
I have received many requests from my users to write an article on like and dislike with PHP and MySQL so today I am going to give a tutorial on like and unlike in PHP and MySQLi its very use full for your websites to get users review on pages on stories any many more.
[ Read More ]
How to create Login and Signup System in PHP
Received many request from php web developer for very basic article to create login and signup page in php. This article is totally for php developers who is very new in programming. In this tutorial I have created 2 forms for login and signup with code download and a demo.
[ 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 ]
Stop using PHP MySQL extension and start using MySQLi or PDO
Nowadays, PHP have several database extensions. In the past, there was only the MySQL extension. Later, MySQLi extension appeared. It enabled developers to write more neat and maintainable code. It had also the power of object-oriented and it was more secure and strongly recommended in its days. Now, we have PDO that literally has it all.
[ Read More ]
How to read Excel file & Insert data into MySQL Database using PHP
I have received many requests from my readers to write tutorial on Excel file import in MySQL database, so today I am going to give you this tutorial on how to read excel file and insert data into MySQL DB using PHP. I have used a php library php-excel-reader its a very simple and easy to understand library to get excel data in your MySQL database. You can also print data in same excel format in HTML and display on browser.
[ Read More ]
