PHP | What are cookies in PHP? A cookie is a small piece of information store by the browser on the client location and sent to the server with every request. It stores a limited amount …

Last updated 5 years, 6 months ago | 1129 views

Tags:- PHP

PHP | The maximum size of a file that can be uploaded using PHP The default maximum size of a file that can be uploaded using PHP is 2MB. upload_max_filesize = 2M; and we can …

Last updated 5 years, 6 months ago | 1307 views

Tags:- PHP

PHP | max_execution_time directive in php.ini file By changing the value of  max_execution_time in the php.ini file max_execution_time = 30; // in second   By default, the maximum execution time for PHP scripts is set to …

Last updated 5 years, 6 months ago | 1224 views

Tags:- PHP

OPTIMIZE command is use for optimize a table. OPTIMIZE TABLE `users`  

Last updated 5 years, 6 months ago | 1275 views

Tags:- SQL

MySQL |  Increase the speed of a MySQL select query For increasing the speed of a query we have to do a couple of things First of all instead of using select * from table1, use …

Last updated 5 years, 6 months ago | 1267 views

Tags:- MySQL

MySQL | Repair Table REPAIR command is used for repair a MySQL table REPAIR TABLE users We can also specify Quick and Extended after the table name REPAIR TABLE users QUICK If we specify Quick then MySQL will …

Last updated 5 years, 6 months ago | 1322 views

Tags:- MySQL

Bellow code is used for the same $date1 = date(‘Y-m-d’); $date2 = ‘2006-08-15’; $days = (strtotime($date1) – strtotime($date2)) / (60 * 60 * 24); echo $days;  

Last updated 5 years, 6 months ago | 977 views

Tags:- PHP

DATEDIFF function is use for finding the number of days between two given dates using MySQL DATEDIFF(‘2018-03-07′,’2017-01-01’)  

Last updated 5 years, 6 months ago | 926 views

Tags:- 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 5 years, 6 months ago | 1263 views

Tags:- PHP PHP-MySQL

MySQL | Find the number of rows in a table We can use the below query to count the number of rows in a table >SELECT COUNT(*) FROM table_name;  

Last updated 5 years, 6 months ago | 1308 views

Tags:- MySQL

Predefined classes in PHP are: Directory stdClass __PHP_Incomplete_Class exception php_user_filter

Last updated 5 years, 6 months ago | 1789 views

Tags:- PHP

PHP | Count number of elements in an array There are two ways to find the number of elements in an array: 1. sizeof($arr), This function is an alias of count() echo sizeof($arr); 2. count($arr) echo …

Last updated 5 years, 6 months ago | 1222 views

Tags:- PHP

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 5 years, 6 months ago | 1285 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 5 years, 6 months ago | 5103 views

Tags:- PHP PHP-MySQL

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

Last updated 5 years, 6 months ago | 3480 views

Tags:- PHP