1. PHP-obtain MySQL database query result rows mysql database download 64-bit SQL database instance download SQL database patch download

Mysql database: 1. PHP-obtain the number of rows of MySQL database query results: First, define a database interface function, which can be stored separately as a php page and on another php page, first, you must use the include function to include

First, you need to define a database interface function, which can be stored separately as a php page.

II

On another php page, you must first useInclude functionIncluding the above php page, that is, you must ensure that the above interface functions can be correctly called

  Query ("SELECT * FROM t_order WHERE seller_id = '". $ seller_id. "'"); // query data echo $ result-> num_rows; // Number of output rows}?>

You can call the defined function to display the number of rows in the SQL query result.$result = $conn->query("SELECT * FROM t_order WHERE seller_id= '". $seller_id."' ");Query and query databasest_sellerTableseller_idEqual$seller_idAnd assign the result set$resultAnd then use$result->num_rowsNumber of rows that can obtain the query result.echoOutput Display

'). AddClass ('pre-numbering '). hide (); $ (this ). addClass ('Has-numbering '). parent (). append ($ numbering); for (I = 1; I <= lines; I ++) {$ numbering. append ($ ('

'). Text (I) ;}; $ numbering. fadeIn (1700) ;}) ;}; script

The above describes 1. PHP-the number of rows that obtain the MySQL database query results, including the Mysql database content. I hope my friends who are interested in the PHP Tutorial will be helpful.