SELECT statement is used to select data from the database.
Syntax SELECT column_name (s) FROM table_name
Note: SQL statements are case insensitive. SELECT and select equivalent.
In order for PHP to execute the above statement, we must use the mysql_query () function. This function is used to send queries or commands to MySQL.
example
The following example picks all the data stored in the "Person" table (the * character selects all the data in the table):
<? php $ con = mysql_connect ("localhost", "peter", "abc123"); if ($ con) {die ('Could not connect:'. mysql_error ());} mysql_select_db ("my_db", $ ; $ result = mysql_query ("SELECT * FROM person"); while ($ row = mysql_fetch_array ($ result)) {echo $ row ['FirstName']. "". $ row ['LastName']; echo " <br /> ";} mysql_close ($ con);?>
The above example 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 subsequent call to the mysql_fetch_array () function will return the next row in the recordset. The while loop statement loops through all the records in the recordset. To output the value of each row, we use PHP's $ row variables ($ row ['FirstName'] and $ row ['LastName']).
Output of the above code:
Peter Griffin Glenn Quagmire Show results in an HTML table
The following example selects the same data as above, but will display the data in an HTML form:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.