Exporting MySQL database to Excel

Question

Now am trying to export MySQL database to Excel sheet and I am using PHP/MySQL to preform that and every time I get this error I've tried everything but I can't find a solutions for this case

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in staff/export.php on line 9

And here's the export.php

<?php  
//export.php  
$connect = mysqli_connect("localhost", "user", "password, "dbname");
$output = '';
if(isset($_POST["export"]))
{
 $query = "SELECT * FROM tbl_customer";
 $result = mysqli_query($connect, $query);
 if(mysqli_num_rows($result) > 0)
 {
  $output .= '
   <table class="table" bordered="1">  
<tr><th>Id</th><th>Customer name</th><th>Agent name</th><th>Phone Number</th><th>Email</th><th>Brand Name</th><th>Field</th><th>Website</th><th>comments</th></tr>
  ';
  while($row = mysqli_fetch_array($result))
  {
   $output .= '
    <tr>  
                         <td>'.$row["Id"].'</td>  
                         <td>'.$row["Customer name<"].'</td>  
                         <td>'.$row["Agent name"].'</td>  
       <td>'.$row["Phone Number"].'</td>  
       <td>'.$row["Email"].'</td>
              <td>'.$row["Brand Namel"].'</td>
        <td>'.$row["Field"].'</td>
        <td>'.$row["Website"].'</td>
         <td>'.$row["comments"].'</td>
                    </tr>
   ';
  }
  $output .= '</table>';
  header('Content-Type: application/xls');
  header('Content-Disposition: attachment; filename=download.xls');
  echo $output;
 }
}
?>

unusual to want to include HTML table elements in an Excel spreadsheet... — Professor Abronsius, Jan 29 '20 at 13:52
All looks good to me, check your mysql table name is correct. — udit rawat, Jan 31 '20 at 13:25
somehow your query getting broke and as per your code only possibility is your mysql table name is incorrect. — udit rawat, Jan 31 '20 at 13:31

score 0 · Answer 1 · answered Jan 29 '20 at 13:44

0

The $result variable is probably false.. meaning that you query is wrong (if you misspelled the table name or something).. or your connection is not established.

use debugger (or var_dump(), print_r().. but use debugger) to find out what are the values stored in $connect and $result variable and you'll probably figure out what went wrong.

answered Jan 29 '20 at 13:44

Milan Pasic

26
5

i just check and the table name was incorrect so i fixed it but now it exports an excel sheet without anything but table rows inside – Mahmoud Azzazy Jan 29 '20 at 13:49
like I said.. use debugger.. don't write code blindly, or at least check every line (print the results and check them), see what is happening in your code. all the best :) – Milan Pasic Jan 29 '20 at 13:55

score -1 · Accepted Answer · answered Jan 29 '20 at 13:59

-1

Answer:

Everything seems fine with your code.

$query = "SELECT * FROM tbl_customer";

Please check the table name as everything else looks fine to me.

$result = mysqli_query($connect, $query);

print_r($result); and verify the output.

answered Jan 29 '20 at 13:59

Zeeshan Eqbal

245
2
11

Exporting MySQL database to Excel

2 Answers2

Answer: