Tools, FAQ, Tutorials:
Looping through Returning Rows from a Query in PHP
How To Query Tables and Loop through the Returning Rows in PHP?
✍: FYIcenter.com
The best way to query tables and loop through the returning rows is to run the SELECT statement with the catch the mysql_query() function, catch the returning object as a result set, and loop through the result with the mysql_fetch_assoc() function in a while loop as shown in the following sample PHP script:
<?php include "mysql_connection.php"; $sql = "SELECT id, url, time FROM fyi_links"; $rs = mysql_query($sql, $con); while ($row = mysql_fetch_assoc($rs)) { print($row['id'].", ".$row['url'].", ".$row['time']."\n"); } mysql_free_result($rs); mysql_close($con); ?>
Using mysql_fetch_assoc() is better than other fetch functions, because it allows you to access field values by field names. If you run this script, you will see all rows from the fyi_links table are printed on the screen:
101, dev.fyicenter.com, 2006-02-26 22:29:02 102, dba.fyicenter.com, 2006-02-26 22:29:02 1101, dev.fyicenter.com, 2006-02-26 22:29:02 1102, dba.fyicenter.com, 2006-02-26 22:29:02
⇒ Updating Existing Rows in PHP
⇐ What Is a Result Set Object in PHP
2016-10-19, 1536🔥, 0💬
Popular Posts:
How to install "The Windows SDK version 8.1"? I need to build my Visual Studio C++ applications. If ...
dev.FYIcenter.com is a Website for software developer looking for software development technologies,...
How to dump (or encode, serialize) a Python object into a JSON string using json.dumps()? The json.d...
How To Merge Cells in a Column? If you want to merge multiple cells vertically in a row, you need to...
How to register and get an application ID from Azure AD? The first step to use Azure AD is to regist...