没有错误消息，但所有数据都无法导入

Question

i want to import data from an excel file to phpmyadmin. i use library excel_reader2. when i click the import button there is no error message but all data fail to import.

here is my code

<?php

include "excel_reader2.php";

mysql_connect("dbHost", "dbUser", "dbPass");
mysql_select_db("dbname");

$data = new Spreadsheet_Excel_Reader($_FILES['userfile']['tmp_name']);

$baris = $data->rowcount($sheet_index=0);

$success = 0;
$fail = 0;

for ($i=2; $i<=$row; $i++)
{
$id = $id->val($i, 1);
$name = $name->val($i, 2);
$address = $address->val($i, 3);

$query = "INSERT INTO student VALUES ('$id', '$name', '$address')";
$result = mysql_query($query);

 if ($result) $success++;
 else $fail++;
}

echo "<h3>Import data finished</h3>";
echo "<p>Sum of success data : ".$success."<br>";
echo "Sum of fail data : ".$fail."</p>";
?>

and here is the result in my browser

Import data finished Sum of success data : 0 Sum of fail data : 100

Please, somebody help me.. Big thanks..

Answer 1

Maybe are you wrong when you get your datas from the excel. You may try that:

$id = $data->val($i, 1);
$name = $data->val($i, 2);
$address = $data->val($i, 3);

You start from i=2 and var baris is never used