Author: Exforsys

PHP Tutorial : PHP & MySQL In this PHP Tutorial you will learn about PHP and MySQL – Connecting to MySQL, Closing a connection, Selecting a database, Executing a query, Inserting data and Retrieving data. Connecting to MySQL: To connect to MySQL database server, use the function mysql_connect(). mysql_connect() takes three string arguments, the hostname, the username, and the password. mysql_connect() returns an integer represents the connection index if the connection is successful, or returns false if the connection fails. Example: <?php $con = mysql_connect(“localhost”, “john”, “smith”); echo $con; ?> Closing… Read More

PHP Tutorials – Forms   In the PHP Tutorial you will learn about PHP Forms – Predefined variables, Reading input from forms and Using hidden fields to save state.  Predefined variables: PHP has several predefined variables called superglobals. Superglobals are always present and available in any PHP script. The superglobals are arrays of other variables. PHP superglobals that work with forms: • $_GET contains any variables provided to a script through the GET method. • $_POST contains any variables provided to a script through the POST method. • $_FILES contains… Read More

File manipulation (Part-2) In this PHP Tutorial you will learn the 2nd Part of File Manipulation Reading lines from a file, Reading arbitrary amounts of data from a file, Writing to a file, Creating directories, Removing a directory and Opening a directory for reading. Reading lines from a file: To read a line from an open file, you can use fgets(). fgets() requires the file resource returned from fopen() as an argument. You may also pass fgets() an integer as a second argument. The integer argument specifies the number of… Read More

PHP Tutorials – File manipulation (Part 1) In the PHP Tutorial You will learn about File manipulation (Part 1) – Checking file existence, A file or directory, Determining file size, Creating and deleting files and Opening a file for writing, reading, or appending. Checking file existence: You can test for the existence of a file with the file_exists() function. file_exists() takes one element, which is a string representing an absolute or relative path to a file that might or might not be there. If the file is found, file_exists() returns… Read More

PHP Tutorials – Arrays (Part 2) In this PHP Tutorial you will learn Arrays (Part 2) – Looping with foreach( ), Sorting arrays and Using Multidimensional Arrays. Looping with foreach( ): The easiest way to iterate through each element of an array is with foreach( ). The foreach( ) construct lets you run a code block once for each element in an array. Example: $fruits = array(‘apple’, ‘banana’, ‘orange’); print “<table>\n”; foreach ($fruits as $fruit) { print “<tr><td>$fruit</td></tr>\n”; } print ‘</table>’; This will print: <table> <tr><td>apple</td></tr> <tr><td>banana</td></tr> <tr><td>orange</td></tr> </table> if you want… Read More