Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
URL decoding can be done using the built-in 'urldecode' function. This returns the encoded data.Syntax of urldecode functionstring urldecode($input)It takes a single parameter ($input) which is the URL that is to be decoded. Returns the decoded string provided the decoding was successful −Example Live Demo In the above lines of the code, the ‘urldecode’ function takes in the raw (encoded string) and returns the decoded value of the string.OutputThis will produce the following output −https://medium.com/
If we know that the current encoding is ASCII, the 'iconv' function can be used to convert ASCII to UTF-8. The original string can be passed as a parameter to the iconv function to encode it to UTF-8.Example Live DemoA string with special characters is assigned to ‘str’ variable. This is passed to the ‘iconv’ function, with the encoding that it currently is in, and the encoding to which it needs to be converted to.OutputThis will produce the following output −Original :ábrêcWtë Plain :�br�cWt�Another method is to detect the encoding and then converting it to an appropriate encoding −Example Live Demo$string = ... Read More
For this, use the concept of LEFT() function. Let us first create a table −mysql> create table DemoTable2036 -> ( -> FirstLetter varchar(20), -> Title varchar(20) -> ); Query OK, 0 rows affected (1.01 sec)Insert some records in the table using insert command −mysql> insert into DemoTable2036(Title) values('Chris'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable2036(Title) values('John'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable2036(Title) values('Adam'); Query OK, 1 row affected (0.15 sec)Display all records from the table using select statement −mysql> select *from DemoTable2036;This will produce the ... Read More
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