This article illustrates a simple way to parse mysqli query results in PHP. Share to everyone for your reference, specific as follows:
You can put the results of a query into an object or array:
1. Put the results of the query into the object:
$sql = "Select Name,brief from Cars";
$result =mysqli->query ($sql);
while ($row = $result->fetch_object ())
{
echo $row->name;
echo $row->brief;
}
2. Put the array:
$sql = "Select Name,brief from Cars";
$result =mysqli->query ($sql);
while ($row = $result->fetch_array ())
{
echo $row [0];//$row [' name '];
echo $row [1];
}
More about PHP Interested readers can view the site topics: "PHP+MYSQLI Database Programming Skills Summary", "PHP based on PDO Operation Database Skills summary", "PHP operation and operator Usage Summary", "PHP Network Programming Skills Summary", " Introduction to PHP object-oriented programming, "PHP string (String) Usage Summary", "Php+mysql Database Operations Introduction Tutorial" and "PHP Common database Operation tips Summary"
I hope this article will help you with the PHP program design.