Php implements a common function instance for reading data from a database table to an array, Array Function
The example in this article describes php's function for reading data from database tables to arrays. Share it with you for your reference. The specific analysis is as follows:
This function does not care about the table structure. You only need to specify the table name, structure, and query conditions to perform common query operations on the table.
Function listmytablerows ($ table, $ name, $ field, $ where, $ textID) {// Connect to the database and query executionconnect (); $ SQL = "select * from ". $ table. "". $ where. "order ". $ field; $ Req = mysql_query ($ SQL); $ Res = mysql_num_rows ($ req);?> <Select name = "<? Php echo $ name;?> "Id =" <? Php echo $ textID;?> "> <Option value =" ">____ </option> <? Php // We do a loop that will read the information for each recordwhile ($ data = mysql_fetch_array ($ res) {// We display the information from the current record?> <Option value = "<? Php echo $ data ['id'];?> "> <? Php echo $ data [$ field];?> </Option> <? Php }?> </Select> <? Php }?>
I hope this article will help you with php programming.