HOME | basics of HTML | basics of PHP | neobux | onbux | readbud | templates |
| |||||||||||
PHP MySQL Select
PHP MySQL SelectThe SELECT statement is used to select data from a database. Select Data From a Database TableThe SELECT statement is used to select data from a database. Syntax
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 used to send a query or command to a MySQL connection. ExampleThe following example selects all the data stored in the "Persons" table (The * character selects all the data in the table):
The example above stores the data returned by the mysql_query() function in the $result variable. Next, we use the mysql_fetch_array() function to return the first row from the recordset as an array. Each call to mysql_fetch_array() returns the next row in the recordset. The while loop loops through all the records in the recordset. To print the value of each row, we use the PHP $row variable ($row['FirstName'] and $row['LastName']). The output of the code above will be:
Display the Result in an HTML TableThe following example selects the same data as the example above, but will display the data in an HTML table:
The output of the code above will be:
|
|||||||||||
© 2011 d4download.orgfree, All Rights Reserved.
Design created by diljith d4download veriosn 2.0
HOME | basics of HTML | basics of PHP | neobux | onbux | readbud | templates |