1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| function insertDatabase($file){
updateBackorder($file);
require_once 'Classes/PHPExcel/IOFactory.php';
$objPHPExcel = PHPExcel_IOFactory::load($file);
$sheet = $objPHPExcel->getSheet(0);
$con = mysqli_connect("localhost","interns","eFEntZrfPWPGHUGe","test_reporting");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: ".mysqli_connect_error();
}
else {
echo 'Connected with phpMyAdmin.';
$rows = array();
foreach ($sheet->getRowIterator() as $row) {
$i = 0;
$data = array();
foreach ($row->getCellIterator() as $cell) {
$data[$i] = $cell->getValue();
$i++;
if($i == 8) {
array_push($rows, $data);
$i = 0;
}
}
}
}
foreach ($rows as $row) {
$pord = $row[0];
$sku = $row[1];
$product_name = $row[2];
$qty = $row[3];
$order_created_at = $row[4];
$kwos = $row[5];
$expected_delivery_date = $row[6];
$alternative = $row[7];
$sql = "INSERT INTO vow_backorders (pord, sku, product_name, qty, order_created_at, kwos, expected_delivery_date, alternative) VALUES ('$pord', '$sku', '$product_name', '$qty', '$order_created_at', '$kwos', '$expected_delivery_date', '$alternative')";
$result = $con->query($sql);
if($result) {
echo $order_created_at.'<br/>';
echo ' Send.';
}
}
} |
Partager