php显示所有mysql记录，只显示一行

Question

php to display all mysql records, shows only one row. Please can anyone help me with this?

PHP CODE:

require_once('dbConnect.php');

$sql = "SELECT vendorID,joint_name,vendor_contact,vendor_name,vendor_place,joint_lat,joint_long,vendor_profile_pic,time_in,time_out,days_in,date FROM vendor ORDER BY vendorID desc ";

$r = mysqli_query($con,$sql);

$res = mysqli_fetch_array($r);

$result = array();

array_push($result,array(
                "joint_name"=>$res['joint_name'],
                "vendor_contact"=>$res['vendor_contact'],
                "vendor_name"=>$res['vendor_name'],
                "vendor_place"=>$res['vendor_place'],
                "joint_lat"=>$res['joint_lat'],
                "joint_long"=>$res['joint_long'],
                "vendor_profile_pic"=>$res['vendor_profile_pic'],
                "time_in"=>$res['time_in'],
                "Ttime_out"=>$res['time_out'],
                "days_in"=>$res['days_in'],
                "date"=>$res['date']                

         )
         );

echo json_encode(array("result"=>$result));
mysqli_close($con);

"
RESULT:
"
{"result":[{"joint_name":null,"vendor_contact":null,"vendor_name":null,"vendor_place":null,"joint_lat":null,"joint_long":null,"vendor_profile_pic":null,"time_in":null,"Ttime_out":null,"days_in":null,"date":null}]}

Answer 1

Try This

while($res = mysqli_fetch_array($r)){
    array_push($result,array(
            "joint_name"=>$res['joint_name'],
            "vendor_contact"=>$res['vendor_contact'],
            "vendor_name"=>$res['vendor_name'],
            "vendor_place"=>$res['vendor_place'],
            "joint_lat"=>$res['joint_lat'],
            "joint_long"=>$res['joint_long'],
            "vendor_profile_pic"=>$res['vendor_profile_pic'],
            "time_in"=>$res['time_in'],
            "Ttime_out"=>$res['time_out'],
            "days_in"=>$res['days_in'],
            "date"=>$res['date']                

     )
     );
}