bastiam / php-excel-reader2

Automatically exported from code.google.com/p/php-excel-reader2
0 stars 0 forks source link

transfer data from a spreadsheet into a database issue #12

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
transfer data from a spreadsheet into a database:

<?php
// include class file
include 'reader.php';

// initialize reader object
$excel = new Spreadsheet_Excel_Reader();

// read spreadsheet data
$excel->read('book.xls');

// attempt a connection
try {
   $pdo = new PDO('mysql:dbname=test;host=localhost', 'root', '');
} catch (PDOException $e) {
   die("ERROR: Could not connect: " . $e->getMessage());
}

// iterate over spreadsheet rows and columns
// convert into INSERT query
$sql = "INSERT INTO data (country, sales) VALUES (?, ?)";
if ($stmt = $pdo->prepare($sql)) {
  $x=2;
  while($x<=$excel->sheets[0]['numRows']) {
    $stmt->bindParam(1, $excel->sheets[0]['cells'][$x][1]);
    $stmt->bindParam(2, $excel->sheets[0]['cells'][$x][2]);
    if (!$stmt->execute()) {
      echo "ERROR: Could not execute query: $sql. " . print_r($pdo->errorInfo());
    }  
    $x++;
  }
} else {
  echo "ERROR: Could not prepare query: $sql. " . print_r($pdo->errorInfo());
}

// close connection
unset($pdo);
?>

I have this error:

Deprecated: Assigning the return value of new by reference is deprecated in 
C:\wamp\www\Nouveau dossier 
(4)\php-excel-reader-2.21\php-excel-reader-2.21\Excel\reader.php on line 124

Please help me;

Original issue reported on code.google.com by jesoufi...@gmail.com on 30 Jul 2010 at 9:50

GoogleCodeExporter commented 8 years ago
So do I, I just download source code, but I can't run it, because I got error: 
Deprecated: Assigning the return value of new by reference is deprecated in 
C:\wamp\www\payroll\reader.php on line 124

please help me

Original comment by sonp...@gmail.com on 27 Aug 2010 at 3:52

GoogleCodeExporter commented 8 years ago
sign:

Deprecated: Assigning the return value of new by reference is deprecated in 
C:\xampp\htdocs\Excel\reader.php 

Original comment by mathias....@googlemail.com on 6 Feb 2012 at 9:43