SQL Update statement
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 …
How to redirect a page in PHP?
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 …
How to get an AWS KMS Key description in python with boto3
Python | Get an AWS KMS Key description in python with boto3 The describe_key() function is used to get the key description. It takes KeyArn and returns a dictionary having KeyMetadata. These are some necessary items …
what is list in php?
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 …
What is robots.txt file?
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 …
How can we repair a MySQL table?
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 …
Find nth largest salary from employees table?
By using following query we can find out the nth largest salary from employees table. SELECT salary FROM `employees` ORDER BY salary DESC LIMIT 1 OFFSET n-1 In the above query n is replaced by …
How to send mail in PHP ?
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 …
what is Cross-site scripting?
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 …
What is access specifiers in php?
PHP | Access specifiers An access specifier is a code element that is used to determine which part of the program is allowed to access a particular variable or other information. There are three …
How can we optimize a table?
OPTIMIZE command is use for optimize a table. OPTIMIZE TABLE `users`
Accessing CodeIgniter Super Object from External PHP Script (Outside CodeIgniter)
Accessing CodeIgniter Super Object from External PHP Script (Outside CodeIgniter) Sometimes, you may need to access CodeIgniter's core features — such as models, libraries, or configuration — from a standalone PHP script that’s not within …
What is the maximum size of a file that can be uploaded using PHP and how can we change this?
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 …
Sort an array of arrays by date in PHP
PHP | Sort an array of arrays by date in PHP Here a situation in which we have to sort an array of the array by date. An array of arrays is a multidimensional array in …
What are default session time in PHP?
PHP | What are default session times in PHP? By default, session variables last until the user closes the browser or leaves the site otherwise most of the server terminates the session variable if you …