The Tutorials in this series are created in XAMPP 5.5.19 on Ubuntu 14.04. PHP: Hypertext Preprocessor" is a widely-used Open Source general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. Read more
Foss : PHP and MySQL - English
Outline: Arrays An array stores multiple values in one single variable. Numeric array - An array with a numeric index. Associative array - An array where each ID key is associated with..
Outline: Multi-Dimensional Arrays In a multidimensional array, each element in the main array can also be an array. And each element in the sub-array can be an array, and so on.
Outline: Loops - While Statement The while loop executes a block of code while a condition is true. while (condition) { code to be executed; }
Outline: Loops - Do-While Statement The do...while statement will always execute the block of code once, it will then check the condition, and repeat the loop while the condition is true..
Outline: Loops - For Statement The for loop is used when you know in advance how many times the script should run. Syntax: for (init; condition; increment) { code to be ..
Outline: Loops - Foreach Statement The foreach loop is used to loop through arrays. foreach ($array as $value) { code to be executed; }
Outline: Functions (Basic) To keep the script from being executed when the page loads, you can put it into a function. A function will be executed by a call to the function. You may ca..
Outline: Functions (Advanced) We can also pass parameters to functions during both the declaration and calling time. function functionName($param1,$param2); //during function call. fun..
Outline: GET Variable The built-in $_GET function is used to collect values from a form sent with method="get". Information sent from a form with the GET method is visible to everyone (..
Outline: POST Variable The built-in $_POST function is used to collect values from a form sent with method="post". Information sent from a form with the POST method is invisible to othe..
Outline: Embedding PHP We can embed our PHP code anywhere in the webpage, by enclosing our script within the <?php...... //SCRIPT.......?>
Outline: Common Way to Display HTML We can also use the HTML Code within the PHP Script. Almost each of the HTML Tags can be used within a PHP Script.
Outline: Common Errors (Part 1) Learn how to spot errors and how to fix them Common Parse errors Parse errors due to missing comma or semicolon Parse errors due to not ending single o..
Outline: Common Errors (Part 2) Parse error due to missing or extra brackets Matching brackets during complex mathematical operations Purpose and usefulness of correct indentation Err..
Outline: Common Errors (Part 3) "Cannot modify header information - headers already sent by..." errors when using header() function Using ob_start() to turn on output buffering "Failed..
Outline: MySQL (Part 1) An Introduction to the PHPMyAdmin Interface. Creating a New Database Creating a new Table and entering the value of the field with the requisite datatype. SQL ..
Outline: MySQL (Part 2) Connecting to the database and inserting dummy data into the database. mysql_connect("server_addr", "username", "password") - Connect to the Database Server with..
Outline: MySQL (Part 3) Writing some data into the database (INSERT and UPDATE Queries). mysql_query('TYPE_HERE_YOUR_MYSQL_QUERY') - This function is used to run specific queries on our..
Outline: MySQL (Part 4) Getting data from the database table and displaying it. SELECT QUERY - SELECT * FROM table_name WHERE att1='abc' // Query returns the value from the database whe..
Outline: MySQL (Part 5) mysql_fetch_assoc — Fetch a result row as an associative array. array mysql_fetch_assoc ( resource $result ) //Returns an associative array that corresponds to t..