After reading through various threads on this issue, I still haven't found a solution that incorporates php variables.
I am trying to retrieve the first 100 new records after a specific date from my database, but I'm struggling to make it work.
$connStr =
'odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};' .
'Dbq='.$ini_project['general']['document_location'].';';
$dbh = new PDO($connStr);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$time = strtotime('6-8-2017 21:52:00');
$date = date('j-n-Y H:i:s',$time);
$sql1 = "SELECT TOP 100 * FROM `$table_name $table_number` WHERE Systeemtijd > `$date`";
$result = $dbh->query($sql1);
while($row = $result->fetch()) {
print_r($row);
}
I can successfully select records based on another field in the table (WHERE value > 200 for example), but I'm facing issues when attempting to filter based on the date column in the table. I have also tried without `` and using:
$sql1 = "SELECT TOP 100 * FROM `$table_name $table_number` WHERE Systeemtijd > DATE `$date`";
However, all attempts result in the same error message:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 0 [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Systeemtijd > 6-8-2017 21:52:00'. (SQLPrepare[0] at ext\pdo_odbc\odbc_driver.c:206)' in C:\Bitnami\wampstack-5.6.30-1\apache2\htdocs\php7\DataBuilt\Larissa_Connector\data_uploader.php:65 Stack trace: #0 C:\Bitnami\wampstack-5.6.30-1\apache2\htdocs\php7\DataBuilt\Larissa_Connector\data_uploader.php(65): PDO->query('SELECT TOP 100 ...') #1 {main} thrown in C:\Bitnami\wampstack-5.6.30-1\apache2\htdocs\php7\DataBuilt\Larissa_Connector\data_uploader.php on line 65