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]