无法从sql中获取数据

Question

我正在尝试使移动修复管理的web应用程序到目前为止，我已经向MySQL提交数据，但是每当我尝试检索数据时都显示空白页，或者它给MySQL_num_rows（）期望参数1是资源错误

这里是我的代码

<?php 
    $connect = mysqli_connect('localhost','root','password','shopdata'); 
    if(mysqli_connect_errno($connect)){ 
echo 'FAILED'; 
} 
?> 

<?php 
    $result = mysqli_query($connect,"SELECT * FROM `jobsheets` "); 
?> 

<table width="1350" cellpadding=5 cellspacing=5 border=1> 
<tr> 
    <th>JOBSHEET NO.</th> 
    <th>CUSTOMER NAME</th> 
    <th>CUSTOMERS PH.</th> 
    <th>MOBILE BRAND</th> 
    <th>MODEL NAME</th> 
    <th>IMEI NO.</th> 
    <th>FAULT</th> 
    <th>BATEERY</th> 
    <th>BACKPANEL</th> 
    <th>CONDITION</th 
</tr> 
<?php 
If (mysql_num_rows($result) > 0) { 
    while ($row = mysql_fetch_array($result)) { 
?> 
    <tr> 
     <td><?php echo $row['job_number']; ?></td> 
     <td><?php echo $row['cust_name']; ?></td> 
     <td><?php echo $row['cust_mob']; ?></td> 
     <td><?php echo $row['mob_brand']; ?></td> 
     <td><?php echo $row['mob_name']; ?></td> 
     <td><?php echo $row['imei_number']; ?></td> 
     <td><?php echo $row['fault_name']; ?></td> 
     <td><?php echo $row['bat_status']; ?></td> 
     <td><?php echo $row['panel_status']; ?></td> 
     <td><?php echo $row['misc_note']; ?></td> 
    </tr> 

    </table> 
    <?php 
    } 
    } 
    ?>**strong text** 

Answer 1

不能结合mysql_和mysqli_功能。任何以mysql_开头的东西现在都被正式弃用了，所以你应该转向使用mysqli_或理想的PDO。

http://php.net/manual/en/book.mysqli.php

http://php.net/manual/en/book.pdo.php