View of Data
The view level provides the “ view of data ” to the users and hides the irrelevant details such as data relationship, database schema, constraints, security, etc. from the user and helps in easy and efficient user-database interaction. Benefits of a Database View There are many benefits to using views. Which are:- Enforce Business Rules – Use views to d…
Read more
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
Social Plugin