Connecting PHP to MySQL Database

In this tutorial, we will learn to connect a MySQL database to PHP by different methods. We will use the MariaDB which is a fork of MySQL throughout the tutorial. Note that, all the syntaxes, statements and codes given below are the same for MySQL as well as MariaDB. Therefore, you can choose either MySQL …

Connecting PHP to MySQL Database Read More »

MySQL Boolean Full-Text Searches

MySQL provides us with multiple methods for searching functionalities. The “LIKE” clause is supposed as the best searching method for easy and less complex use cases. For complex business logic, there are other alternative methods that are very effective, suitable, and easy to implement. In this tutorial, we will learn about the boolean full-text search …

MySQL Boolean Full-Text Searches Read More »

Update MySQL Table using NodeJS

In this tutorial, we will study how to update the records of the table using the Nodejs application. Update the table from NodeJS program To update the records in the table, the UPDATE statement will be used. We will update the table using the update.js file. The javascript code for the following is- Here we …

Update MySQL Table using NodeJS Read More »