Posts Tagged with 'PHP-MySQL'

Chart.JS | Draw Bar chart from server data using MySQL, Ajax, and PHP This example shows how to draw a bar chart with data from the database server.  FILE STRUCTURE At the end of this …

Last updated 4 years, 10 months ago | 10328 views

Tags:- HTML JQuery JavaScript PHP Chart Ajax PHP-MySQL

SQL | IN operator with PHP Array In this article we will use PHP Array with SQL IN operator. SQL IN operator allows us to specify multiple values in where clause. So in this article …

Last updated 5 years, 5 months ago | 2338 views

Tags:- PHP PHP-MySQL

MySQL | Find last insert id in the table By using the MySQL function mysqli_insert_id() we can retrieve the last inserted id in the database table.   <?php $con = mysqli_connect("localhost","user_name","user_password","db_name"); if (mysqli_connect_errno()) { echo …

Last updated 5 years, 7 months ago | 1897 views

Tags:- PHP PHP-MySQL

PHP | Find the number of rows in a result set Bellow code is use for the same $sql = "SELECT * FROM table1"; $result = mysql_query($sql, $db_link); $num_rows = mysql_num_rows($result); echo $num_rows;  

Last updated 6 years, 1 month ago | 1800 views

Tags:- PHP PHP-MySQL

There are 5 different types of storage engine present in MySql. MyISAM Heap Merge INNO DB ISAM MyISAM is the default storage engine for MySQL

Last updated 6 years, 1 month ago | 1821 views

Tags:- MySQL PHP-MySQL

PHP-MYSQL |  mysqli_fetch_assoc() VS  mysqli_fetch_array() mysqli_fetch_assoc() function fetch a result row as an associative array where as mysqli_fetch_array() function fetch a result row as an associative array, a numeric array, or both.       mysqli_fetch_assoc() The mysqli_fetch_assoc() …

Last updated 6 years, 1 month ago | 5795 views

Tags:- PHP PHP-MySQL

PHP-MYSQL |  Fetch Recoards From MySql table There are 4 ways: mysqli_fetch_row() - Get a result row as an enumerated array mysqli_fetch_array() - Fetch a result row as an associative array, a numeric array, or both mysqli_fetch_object() …

Last updated 6 years, 1 month ago | 8515 views

Tags:- PHP PHP-MySQL

PHP-MySQL | Transaction with commit and rollback try { // First of all, let's begin a transaction $db->beginTransaction(); // A set of queries; if one fails, an exception should be thrown which we are handling at …

Last updated 6 years, 1 month ago | 1240 views

Tags:- PHP PHP-MySQL