SQL Update statement The UPDATE statement is used to update the records of an existing table in a database. We can update single as well as multiple columns using SQL update statement. The basic syntax …

PHP | magic function In PHP all functions start with __ names are magical functions. Magical functions always live in a PHP class. The definition of the magical function is defined by the programmer itself. …

Send mail in PHP The mail() function allows you to send emails directly from a script. mail(to,subject,message,headers,parameters);   Description of parameters to Required. Specifies the receiver's email id subject Required. Specifies the subject of the …

PHP | Redirect PHP header() function is used to redirect a page to another page. It supplies raw HTTP headers to the browser and redirects it to another location. The redirection script should be at …

SQL | Foreign Key A foreign key is a key used to link two tables.    A Primary key of a table is used as a foreign key for the other table. The primary key …

PHP | How to avoid errors in PHP? We can use PHP inbuilt function error_reporting(0) to avoid all errors in PHP file. <?php error_reporting(0); ?>  

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 …

Cross-site scripting (XSS) Cross-site scripting (XSS) is a type of computer security vulnerability typically found in web applications. XSS enables attackers to inject client-side script into web pages viewed by other users. A cross-site scripting …

PHP | Check data type in php | gettype() | var_dump() By using gettype() function we can check the data type of a variable. we can also use var_dump() function for the same.   gettype() <?php echo …

List  List is a language construct and is similar to an array. It is used to assign a list of variables in one operation. If you are using PHP 5, then the list values start …

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

PHP |  date() function By using the PHP date() function we can find the current date and time. <?php echo date(“d-m-Y”); //This will print today date. echo date (“d-m-Y h:i:s”) // This will print today’s date …

MySQL | What is the best collation to use for MySQL? Mostly we use: utf8_general_ci utf8_unicode_ci utf8_general_ci is used for fast sorting but it is less accurate whereas utf8_unicode_ci is used for better accuracy but …

Googlebot | What is a robots.txt file? A robots.txt is a simple text file that can be created by a notepad editor. This file is used for search engines, which provide instructions to search engines on how …

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 …