Category Archives: MySQL
How to Integrate live search in PHP and MySQL with jQuery
I have received many requests from my readers for live search in PHP and MySQL with jQuery, so today i have decided to write a tutorial how to integrate live search in PHP and MySQL with jQuery. Searching is one of the most required feature in web sites and if it will be live searching it will show you fast result on page. In this tutorial we will create a database and a table insert records and start searching in it.
[ Read More ]
Mysql Stored Procedure in PHP
Are you making stored procedures if not please have a look at this.
Stored procedures can help to improve web applications and reduce database requests traffic. This post explains you how to make procedures and decrease database requests.
[ Read More ]
jQuery Fullcalendar Integration with Bootstrap, PHP & MySQL
Recently I have used this plugin in an application and faced some issues to integrate it with bootstrap so I don't want my readers to waste time in integration in this tutorial you will get a fullcalendar working with bootstrap, PHP & MySQL. We are doing some basic operations like add event, edit event and delete event.
[ Read More ]
Create Like & Unlike System in PHP MySQL and jQuery [Improved]
![Create Like & Unlike System in PHP MySQL and jQuery [Improved]](https://images.phpgang.com/2013/12/like-unlike-php-mysql.png)
We have created a like and unlike script on our readers request we received many users feedback they face problems in counter etc. Now I have fixed all bugs and created its improved version with multiple like unlike on single page and for products and improve some JavaScript and CSS so I hope you like it.
[ Read More ]
How to login with LinkedIn oAuth2 in PHP and MySQL
LinkedIn is a business oriented social networking platform and used for professional networking. We create a tutorial on login with LinkedIn oAuth which is not working properly and difficult to configure for developers, after receiving many complains from readers am writing this new tutorial on LinkedIn oAuth2 its super easy to integrate with your website in few simple steps.
[ 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 ]
Stored procedures in PHP and MySQL
Today, a majority of databases support stored procedures. A stored procedure is simply a set of SQL instructions that perform a particular task which is stored in the database to help associated programming languages and database engine retrieve it anytime. Stored procedures are a great way to increase the performance and reduce network traffic. They usually accept input parameters and can be used by different clients over the network.
[ Read More ]
