PHP，MYSQL while 循环只显示最后一条记录 - PHP,MYSQL while loop only displays the last record

PHP,MYSQL while loop only displays the last record

我的代码是 -

$dbhost = 'localhost';    
$dbuser = 'root';    
$dbpass = '';  
$dbname = 'moviefone';    
$con = mysql_connect($dbhost, $dbuser, $dbpass);  
mysql_select_db($dbname, $con);    
// Check connection    
if (mysqli_connect_errno()) {  
    echo "Failed to connect to MySQL: " . mysqli_connect_error();    
}    
$data = mysql_query("SELECT * FROM new_hindi") or die(mysql_error());
$info=NULL;
while ($row = mysql_fetch_array($data)){
    $info=$row;
}
?>

我的问题是循环仅显示"new_hindi"表中的最后一条记录。

每次迭代时，都会覆盖$info变量。您必须将行添加到数组$info。

$dbhost = 'localhost';    
$dbuser = 'root';    
$dbpass = '';  
$dbname = 'moviefone';    
$con = mysql_connect($dbhost, $dbuser, $dbpass);  
mysql_select_db($dbname, $con);    
// Check connection    
if (mysqli_connect_errno()) {  
    echo "Failed to connect to MySQL: " . mysqli_connect_error();    
}    
$data = mysql_query("SELECT * FROM new_hindi") or die(mysql_error());
$info=array();
while ($row = mysql_fetch_array($data)){
    $info[]=$row;
}
?>