<?php
/**
* This is an example code that shows how you can save Handsontable data on server using PHP with PDO (SQLite).
* This code is not intended to be maximally efficient nor safe. It is for demonstrational purposes only.
* Changes and more examples in different languages are welcome.
*
* Copyright 2012, Marcin Warpechowski
* Licensed under the MIT license.
* http://github.com/handsontable/handsontable/
*/
require_once 'functions.php';
try {
//open the database
$db = getConnection();
createCarsTable($db);
$colMap = array(0 => 'manufacturer', 1 => 'year', 2 => 'price');
if (isset($_POST['changes']) && $_POST['changes']) {
foreach ($_POST['changes'] as $change) {
$rowId = $change[0] + 1;
$colId = $change[1];
$newVal = $change[3];
if (!isset($colMap[$colId])) {
echo "\n spadam";
continue;
}
$select = $db->prepare('SELECT id FROM cars WHERE id=? LIMIT 1');
$select->execute(array($rowId));
if ($row = $select->fetch()) {
$query = $db->prepare('UPDATE cars SET `' . $colMap[$colId] . '` = :newVal WHERE id = :id');
} else {
function resetCarsTable($db)
{
dropCarsTable($db);
createCarsTable($db);
loadDefaultCars($db);
}
