Parse error: syntax error, unexpected ';', expecting ']' in C:\xampp\htdocs\eazyR\eazy\sites\erp\ajaxify\excel.php on line 37

Question

Please help... am working on a form within as html page that export my SQL table to excel and download it. but i have been experience error

Anythime i click the Export to excel button it keep taking me to a new page instead of export data to excel. Below is my form and the excel.php script

Form

<form method="post" action="sites/erp/ajaxify/excel.php">
    <div id="content">
        <div class="col-md-4 col-md-offset-4 text-center">
                <div class="form-group">
                    <button id="exportbtn" class="btn btn-lg btn-success btn-block">  Export to Excel </button>
                </div>  
        </div>
    </div>
</form>

and the Excel.php

if(isset($_REQUEST['tablename']) && isset($_REQUEST['keyy'])){
$tablename = use_if_sent('tablename');
$result = $ez_db->query("SELECT `firstname`, 'lastname', 'email', 'gender', 'user_group', 'phone', status' FROM 'signup'");
 if(mysql_num_rows($result) > 0)
{
        $output .= '
        <table class="table" bordered="1">  
            <tr>  
                <th>First name</th>
                <th>Lastname</th>
                <th>Email</th>
                <th>Gender</th>
                <th>Department</th>
                <th>Phone</th>
                <th>Status</th>
            </tr>
        ';
        while($row = mysql_fetch_array($result))
        {
           $output .= '
            <tr>  
                <td>'.$row["firstname".'</td>  
                <td>'.$row["lastname"].'</td>  
                <td>'.$row["email"].'</td>  
                <td>'.$row["gender"].'</td>  
                <td>'.$row["user_group"].'</td>
                <td>'.$row["phone"].'</td>
                <td>'.$row["status"].'</td>
            </tr>
           ';
        }
      $output .= '</table>';
      header('Content-Type: application/xls');
      header('Content-Disposition: attachment; filename=download.xls');
      echo $output;
    }  
}
?>

`'.$row["firstname".'` - now what’s missing here, eagle-eye …? — misorude, Oct 22 '18 at 09:58
please correct it this code: '.$row["firstname".' to this '.$row["firstname"].' — TrickStar, Oct 22 '18 at 09:59
Compare that line with the next line, `'.$row["lastname"].'` - now what is the structural difference here? And keep in mind, that the error message already told you it was expecting a `]` somewhere, but didn’t find it … — misorude, Oct 22 '18 at 10:00
This can hardly be your whole script, because in PHP there is no built-in function named `use_if_sent`. — misorude, Oct 22 '18 at 10:08
Please have a read of https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-back-ticks-in-mysql — Nigel Ren, Oct 22 '18 at 10:09

score -1 · Accepted Answer · answered Oct 22 '18 at 10:00

-1

Please correct it this code:

<td>'.$row["firstname".'</td>

To this :

<td>'.$row["firstname"].'</td>

answered Oct 22 '18 at 10:00

TrickStar

229
4
19

Thanks i did that and its now opening a blank page. – Hakeem Salimon Oct 22 '18 at 10:05
So please first check whether your $result contain values or not. – TrickStar Oct 22 '18 at 10:09
How do i do that sir? – Hakeem Salimon Oct 22 '18 at 10:22

Rumaiz Mohomed · Answer 2 · 2018-10-22T10:56:32.253

-1

In Excel.php

<td>'.$row["firstname".'</td>

should change as

<td>'.$row["firstname"].'</td>

You missed to close the square brace ].

And you are not doing excel export here. You are setting Content Type to application\xls to html content. This will not export excel.

See Excel export tutorial to get an idea of excel export.

Change your html code to this.

    <form method="post" action="sites/erp/ajaxify/excel.php" target="exportExcelFrame">
    <div id="content">
        <div class="col-md-4 col-md-offset-4 text-center">
                <div class="form-group">
                    <button id="exportbtn" class="btn btn-lg btn-success btn-block">  Export to Excel </button>
                </div>  
        </div>
    </div>
</form>
<iframe style="display:none;" id="exportExcelFrame" name="exportExcelFrame"></iframe>

edited Oct 22 '18 at 10:56

answered Oct 22 '18 at 10:02

Rumaiz Mohomed

23
6

Thanks i did that and its now opening a blank page. – Hakeem Salimon Oct 22 '18 at 10:04
becuase You are setting Respone Content Type to application/xls. Set Content Type to text/plain – Rumaiz Mohomed Oct 22 '18 at 10:24
i did but am still getting same response , i changed to header('Content-Type: text/plain'); – Hakeem Salimon Oct 22 '18 at 10:30
remove this two lines header('Content-Type: application/xls'); header('Content-Disposition: attachment; filename=download.xls'); – Rumaiz Mohomed Oct 22 '18 at 10:36
This will give you html output. Got to https://www.sitepoint.com/generate-excel-files-charts-phpexcel/ and this page will show you how to export to excel. – Rumaiz Mohomed Oct 22 '18 at 10:37
line remove and am still been redirected to http://localhost/eazyR/eazy/sites/erp/ajaxify/excel.php – Hakeem Salimon Oct 22 '18 at 10:38
set button type to button. . – Rumaiz Mohomed Oct 22 '18 at 10:50
This will not redirect. But you must first update Excel.php to generate excel file. Currently it seems not. I will update the answer. – Rumaiz Mohomed Oct 22 '18 at 10:53

Parse error: syntax error, unexpected ';', expecting ']' in C:\xampp\htdocs\eazyR\eazy\sites\erp\ajaxify\excel.php on line 37

2 Answers2