mysql系统数据表如何回显,如何从数据库回显表行（PHP）

i want to echo out everything from a particular query. If echo $res I only get one of the strings. If I change the 2nd mysql_result argument I can get the 2nd, 2rd etc but what I want is all of them, echoed out one after the other. How can I turn a mysql result into something I can use?

I tried:

$query="SELECT * FROM MY_TABLE";

$results = mysql_query($query);

$res = mysql_result($results, 0);

while ($res->fetchInto($row)) {

echo "

$row[0]\n";

}

解决方案$sql = "SELECT * FROM MY_TABLE";

$result = mysqli_query($conn, $sql); // First parameter is just return of "mysqli_connect()" function

echo "
";

echo "

while ($row = mysqli_fetch_assoc($result)) { // Important line !!! Check summary get row on array ..

echo "

";

foreach ($row as $field => $value) { // I you want you can right this line like this: foreach($row as $value) {

echo "

" . $value . ""; // I just did not use "htmlspecialchars()" function.

}

echo "

";

}

echo "

";