Mysqli_fetch_assoc vs Mysqli_fetch_array [With Example]

mysqli_fetch_assoc() and mysqli_fetch_array() both are used to print result data of SQL query in PHP. Mysqli_fetch_assoc vs Mysqli_fetch_array has just a single difference in accessing resultant data. Difference between mysqli_fetch_assoc() and mysqli_fetch_array() The major difference between mysqli_fetch_assoc and mysqli_fetch_array is the output format of result data. mysqli_fetch_assoc returns data in an associative array and mysqli_fetch_array […]

How to Delete Database in MySQL

MySQL is a database server to manage relational databases. There are some methods to delete a database from the MySQL server. Here we are going to learn to delete a database via MySQL command line. You can use Microsoft cmd, Linux terminal or MAC terminal which one you are using. In this tutorial, we are […]

Prepared Statement in PHP With MySQLi

A prepared statement is one of the popular methods in PHP for database management. As a backend developer, it is necessary to learn about prepared statements in PHP. Here, we are going to see what is the prepared statement, what are the advantages and how to use it with examples. What is the prepared statement? […]