MySQL structure and syntax
MySQL structure and syntax MySQL is a relational database system, stores bits of information in separate areas and links those areas together. Store virtually anything in a database example:- address book, product catalog. MySQL Structure MySQL allows separating information into tables or “areas of pertinent information.” In non-relational database systems,…
Read more
PHP download file script
PHP download file script Download those particular files on which the user has clicked. (It means download the files dynamically not a static file) PHP download file features: The file name, which is passed via the query string, is sanitized by using the PHP function preg_replace() and filter_var() To make the script safer, use the PHP function pathinfo() t…
Read more
Working with File Uploads in PHP
Working with File Uploads in PHP A PHP script can be used with an HTML form to allow users to upload files to the server. Initially, files are uploaded into a temporary directory and then relocated to a target destination by a PHP script. Information in the phpinfo.php page describes the temporary directory that is used for file uploads as upload_tmp_…
Read more
Redirecting the User in PHP
Redirecting the User in PHP PHP redirect mechanism is used to navigate the user from one page to another without clicking any hyperlinks. It should be done in the background. For example, in the payment gateway, the redirect should automatically be taken place to notify the URL using PHP script. PHP provides predefined function, named header(),for URL red…
Read more
Combining HTML and PHP Code on a Single Page
Combining HTML and PHP Code on a Single Page Write PHP code with HTML code on a single page as on hard copy. More flexibility to write the entire page dynamically. For this use a PHP_SELF variable is in the action field of the <form> tag. The action field of the FORM instructs where to submit the form data when the user presses the “submit” button. Th…
Read more
Accessing Form Input with User-Defined Arrays or Working with PHP and arrays of data
Accessing Form Input with User-Defined Arrays or Working with PHP and arrays of data Supergloabal variable is a pre-defined associative array created by PHP that holds all input data submitted to a PHP script via the GET or POST method. One can have arrays created in $_GET / $_POST by using a square-bracket syntax when specifying the name attribute for…
Read more
Looping and counting in string
Looping and counting in string Iteration through the characters of a string. The function count takes a string as its parameter. The for statement iterates through each character in the string and checks if the character is equal to the value of Char. If so, the counting variable, count, is incremented by one. When all characters have been processed, the c…
Read more
String comparison
String comparison is performed using the characters in both strings. The characters in both strings are compared one by one. When different characters are found then their Unicode value is compared. The character with lower Unicode value is considered to be smaller so all the uppercase letters come before all the lowercase letters. Example :- fruit1 = …
Read more
String slices
String slices Python slicing is a sub-string of the given string from start to end. The slice object is used to slice a given sequence (string, bytes, tuple, list or range) or any object which supports sequence protocol (implements __getitem__() and __len__() method). slice() Constructor The syntax of slice() : slice(stop) · slice(start, stop…
Read more
Social Plugin