如何在PHP中获取列所有行数据？ [英] How fetch column all rows data in PHP?

问题描述

我正在尝试获取列所有行数据，我也成功完成但总是错过我的行数据为什么？



我尝试过什么：

I am trying to fetch column all rows data and i also do it successfully but always missing my to row data why?

What I have tried:

 <?php
 
  
    include "../pages/connect.php";
    $query = "SELECT * FROM gallery";
    $result = mysql_query($query) or die('Error, query failed');
    $row = mysql_fetch_assoc($result);
    //$filePath = $row['image_name'];
    //$filePath1 = $row['image_path'];
     $filePath2 = $row['path_name'];
   // $path = $filePath1 . $filePath;  

    //$path = $filePath1."1492234583".$filePath;

    //echo $filePath1 . $filePath;
 while ($row=mysql_fetch_array($result))
{
    $filePath2 = $row['path_name'];
    echo $filePath2;
    
    //echo  '<img src=" ../doctorlogin/' . $filePath2 . '"  height="150" widht="150"/>';

    echo "<br>";
    

}
  // echo $filePath2;
    //echo $path;



    
   //echo  '<img src=" ../doctorlogin/' . $filePath2 . '"  height="200" widht="200"/>';



    ?>

始终无法获取第一行。尽快帮助我。谢谢

always unable to fetch first row. Help me asap. Thanks

推荐答案

query =SELECT * FROM gallery;

query = "SELECT * FROM gallery";

result = mysql_query（

result = mysql_query(

query）或die（'Error，query failed'）;

query) or die('Error, query failed');

这篇关于如何在PHP中获取列所有行数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！