Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Using Ajax to download files is not considered to be a good idea. Instead, window.location = or document.location should be used.The 'window.location' has the following characteristics −JavaScript enabling is requiredIt doesn't need PHP.It helps show the content of the site, and redirects the user after a few seconds.Redirect can be dependent on any conditions such as −$success = 1 if ($success) { window.location.href = 'http://example.com'; }A variable named ‘success’ is assigned with the value of 1. When this condition is satisfied, the window.location is used.On running, the user is redirected to the website 'http://example.com'Read More
Let us create a custom function to validate date in MySQL −mysql> set global log_bin_trust_function_creators=1; Query OK, 0 rows affected (0.03 sec) mysql> delimiter // mysql> create function isValidDate(actualDate varchar(255)) returns int -> begin -> declare flag int; -> if (select length(date(actualDate)) IS NOT NULL ) then -> set flag = 1; -> else -> set flag = 0; -> end if; -> return flag; -> end -> // Query OK, 0 rows affected (0.11 sec) mysql> delimiter ;Case 1 −When parameter is null value i.e. the date to be ... Read More
The text inside a tag inside class="text" inside with class="main" can be obtained with the following code −Example$html = nodeValue)); }OutputThis will produce the following output −string ‘This is text 1’ (length=14) string ‘This is text 2' (length=14)
Set the column as BOOLEAN to display 0 and 1 values. Let us create a table −mysql> create table DemoTable2035 -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(20), -> isMarried boolean, -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (0.72 sec)Insert some records in the table using insert command −mysql> insert into DemoTable2035(Name, isMarried) values('Chris', true); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable2035(Name, isMarried) values('David', false); Query OK, 1 row affected (0.08 sec) mysql> insert into DemoTable2035(Name, isMarried) values('Bob', true); Query OK, 1 ... Read More
To declare a variable, use DECLARE in a MySQL stored procedure. Let us first create a table −mysql> create table DemoTable2034 -> ( -> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> StudentName varchar(20), -> StudentAge int -> ); Query OK, 0 rows affected (0.49 sec)Insert some records in the table using insert command −mysql> insert into DemoTable2034(StudentName, StudentAge) values('Chris', 23); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable2034(StudentName, StudentAge) values('David', 21); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable2034(StudentName, StudentAge) values('Robert', 25); Query OK, 1 row ... Read More
HTTP URLs can be used to behave like local files, with the help of PHP wrappers. The contents from a URL can be fetched through the file_get_contents() and it can be echoed. or read using the readfile function.Below is a sample code to do the same −$file = file_get_contents('http://example.com/'); echo $file;An alternative is demonstrated below −readfile('http://example.com/'); header('Content-type: text/xml'); //The correct MIME type has to be set before displaying the output.The asXML method also can be used. Below is a sample code −echo $xml->asXML(); or $xml->asXML('filename.xml'); //providing a name for the xml file.Read More
The below line of code can be used to display the header that the PHP code received via a browser −orExample$headers = getallheaders(); foreach($headers as $key=>$val){ echo $key . ': ' . $val . ''; }OutputThis will produce the following output −Host: www.websitename.com Content-Length: 180 Cache-Control: max-age=0 Origin: http://www.websitename.com Upgrade-Insecure-Requests: 1 Content-Type: application/x-www-form-urlencoded User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36 Accept: text/html, application/xhtml+xml, application/xml;q=0.9, image/webp, image/apng, */*;q=0.8, application/signed-exchange;v=b3;q=0.9 Referer: http://www.writephponline.com/ Accept-Encoding: gzip, deflate Accept-Language: en-GB, en-US;q=0.9, en;q=0.8 Cookie: _ga=GA1.2.118418268.1575911248; _gid=GA1.2.1794052867.1576852059Read More
For dynamic SQL query in a stored procedure, use the concept of PREPARE STATEMENT. Let us first create a table −mysql> create table DemoTable2033 -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Name varchar(20) -> ); Query OK, 0 rows affected (1.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable2033(Name) values('Chris'); Query OK, 1 row affected (0.85 sec) mysql> insert into DemoTable2033(Name) values('Bob'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable2033(Name) values('David'); Query OK, 1 row affected (0.24 sec) mysql> insert into ... Read More
The array_map function can be used to get the length and the max function can be used to get the length of the longest string.Below is a code sample for the same −$max_len = max(array_map('strlen', $array));Example Live Demo$array = array("a", "Ab", "abcd", "abcdfegh", "achn"); $max_len = max(array_map('strlen', $array)); echo $max_len;OutputThis will produce the following output −8
Two variables can’t be explicitly returned, they can be put in a list/array data structure and returned.Example Live Demofunction factors( $n ) { // An empty array is declared $fact = array(); // Loop through it for ( $i = 1; $i < $n; $i++) { // Check if i is the factor of // n, push into array if( $n % $i == 0 ) array_push( $fact, $i ); } // Return array return $fact; } // Declare a variable and initialize it $num = 12; // Function call $nFactors = factors($num); // Display the result echo 'Factors of ' . $num . ' are: '; foreach( $nFactors as $x ) { echo $x . ""; }OutputThis will produce the following output −Factors of 12 are: 1 2 3 4 6