Archive for the ‘web learning’ Category

CREATE MySQL How to create a database and tables at MySQL? The CREATE DATABASE statement is used to create a database in MySQL. Syntax CREATE DATABASE database_name   To learn more about SQL, please visit our SQL tutorial. To get PHP to execute the statement above we must use the mysql_query() function. This function is [...]

PHP MYSQL INTRODUCTION What Is MySQL?? MySQL is a database. The data in MySQL is stored in database objects called tables. A table is a collections of related data entries and it consists of columns and rows. Databases are useful when storing information categorically. A company may have a database with the following tables: “Employees”, [...]

PHP SECURE EMAIL PHP E-MAIL INJECTIONS First, look at the PHP code from the previous chapter: <html> <body> <?php if (isset($_REQUEST['email'])) //if “email” is filled out, send email { //send email $email = $_REQUEST['email'] ; $subject = $_REQUEST['subject'] ; $message = $_REQUEST['message'] ; mail(“someone@example.com”, “Subject: $subject”, $message, “From: $email” ); echo “Thank you for using [...]

PHP COOKIES   what is a COOKIE? A cookie is often used to identify a user. A cookie is a small file that the server embeds on the user’s computer. Each time the same computer requests a page with a browser, it will send the cookie too. With PHP, you can both create and retrieve [...]

HOW TO UPLOAD FILES??   Look at the following HTML form for uploading files: (create upload script) <?php if ($_FILES["file"]["error"] > 0) { echo “Error: ” . $_FILES["file"]["error"] . “<br />”; } else { echo “Upload: ” . $_FILES["file"]["name"] . “<br />”; echo “Type: ” . $_FILES["file"]["type"] . “<br />”; echo “Size: ” . ($_FILES["file"]["size"] [...]