Parse error on code
Posted: Wed Nov 16, 2011 10:28 am
Getting a parse error on line 11. I don't see the error. Any assistance woul be appreaciated.
Sparkie$data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('CP1251'); $data->read('c:\www\test.xlsx');
$conn = mysql_connect("hostname"," username",""); mysql_select_db("list",$conn);
for ($x = 2; $x < = count($data->sheets[0]["cells"]); $x++) { $name = $data->sheets[0]["cells"][$x][1]; $extension = $data->sheets[0]["cells"][$x][ 2]; $email = $data->sheets[0]["cells"][$x][3]; $sql = "INSERT INTO test (name,extension,email) VALUES ('$name',$extension,'$email')"; echo $sql."\n"; mysql_query($sql); }
?>
[/syntax]
Sparkie
Code: Select all
<?php require_once 'reader.php'; [syntax=php]$conn = mysql_connect("hostname"," username",""); mysql_select_db("list",$conn);
for ($x = 2; $x < = count($data->sheets[0]["cells"]); $x++) { $name = $data->sheets[0]["cells"][$x][1]; $extension = $data->sheets[0]["cells"][$x][ 2]; $email = $data->sheets[0]["cells"][$x][3]; $sql = "INSERT INTO test (name,extension,email) VALUES ('$name',$extension,'$email')"; echo $sql."\n"; mysql_query($sql); }
?>
[/syntax]