Need a little help here. My code not working

[pote86]

Below is my code and I do not know what is wrong with it ... It did not show any error and all 'echo' no result at all. Any help I get will be very much appreciated.

<?php
require_once 'Excel/reader.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('CP1251');
$data->read('sample.xls');
 
$conn = mysql_connect("localhost","root","");
$link = mysql_select_db("asiaone",$conn);
 
for ($x = 9; $x <= count($data->sheets[0]["cells"]); $x++) {
    
    $sn = $data->sheets[0]["cells"][$x][1];
    echo $sn;
    
    $invoiceno = $data->sheets[0]["cells"][$x][2];
    //echo $invoiceno."</br>";
    
    $invoicedate = $data->sheets[0]["cells"][$x][3];
    //echo $invoicedate."</br>";
    
    $customername = $data->sheets[0]["cells"][$x][4];
    //echo $customername."</br>";
    
    $code = $data->sheets[0]["cells"][$x][5];
    //echo $code."</br>";
    
    $suminsured = $data->sheets[0]["cells"][$x][6];
    //echo $suminsured."</br>";
    
    $code2 = $data->sheets[0]["cells"][$x][7];
    //echo $code2."</br>";
    
    $premiumbeforegst = $data->sheets[0]["cells"][$x][8];
    //echo $premiumbeforegst."</br>";
    
    $gst = $data->sheets[0]["cells"][$x][9];
    //echo $gst."</br>";
    
    $premiumaftergst = $data->sheets[0]["cells"][$x][10];
    //echo $premiumaftergst."</br>";
    
    $commissionpercent = $data->sheets[0]["cells"][$x][11];
    //echo $commissionpercent."</br>";
    
    $commissionamount = $data->sheets[0]["cells"][$x][12];
    //echo $commissionamount."</br>";
    
    $payableto = $data->sheets[0]["cells"][$x][13];
    //echo $payableto."</br>";
    
    $commissionamount2 = $data->sheets[0]["cells"][$x][14];
    //echo $commissionamount2."</br>";
    
    $insuredname = $data->sheets[0]["cells"][$x][15];
    //echo $insuredname."</br>";
    
    $policyno = $data->sheets[0]["cells"][$x][16];
    //echo $policyno."</br>";
    
    $typeofpolicy = $data->sheets[0]["cells"][$x][17];
    //echo $typeofpolicy."</br>";
    
    $periodofcover = $data->sheets[0]["cells"][$x][18];
    //echo $periodofcover."</br>";
    
    $voucherno = $data->sheets[0]["cells"][$x][19];
    //echo $voucherno."</br>";
    
    $customerpaymentdate = $data->sheets[0]["cells"][$x][20];
    //echo $customerpaymentdate."</br>";
    
    
    
    $sql = "INSERT INTO test_import_excel (S/N, InvoiceNo, InvoiceDate, CustomerName, Code, SumInsured, Code2, PremiumBeforeGST, GST, PremiumAfterGST, CommissionPercent,CommissionAmount, PayableTo, CommissionAmount2, InsuredName, PolicyNo, TypeOfPolicy, PeriodOfCover, VoucherNo, CustomerPaymentDate) VALUES ('$sn', '$invoiceno', '$invoicedate', '$customername', '$code', '$suminsured', '$code2', '$premiumbeforegst', '$gst', '$premiumaftergst', '$commissionpercent', '$commissionamount', '$payableto', '$commissionamount2', '$insuredname', '$policyno', '$typeofpolicy', '$periodofcover', '$voucherno', '$customerpaymentdate');";
    
    //echo $sql."\n";
    //mysql_query($sql);
}
?>

[NogDog]

Try adding this to the very beginning of your code:

<?php
ini_set('display_errors', true); // set to false in production version
error_reporting(E_ALL);
// rest of code...
?>