Category Archives: MySQL
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 ]
How to Search in MySQL using full-text indexing in PHP
Hello friends after a long time today I am going to write a post on few of my readers request on How to quick Search in MySQL using full-text indexing in PHP. Many developers make a big mistake during searching from MySQL use wildcard queries "LIKE %string%" which is a very slow query to search records so today we are going to learn full-text indexing search and its hundreds or thousands of times fast then wildcard wildcard queries.
[ Read More ]
