I am attempting to run a script that will run from the command line
nightly to update a field in a database. I already created a script
that would access the database and insert most of the information when a
webpage is visited and I had no problems with it. The command line
script appears to fail on the prepare. I have echo'ed the SQL statement
to the screen, copied it, and run it on the MySQL server with no
problems. Any ideas?
<?php
$mysqli = new mysqli('localhost', 'root', 'abc123', 'mydb');
if (mysqli_connect_errno()) {
echo "Unable to connect to database.\n";
exit;
} else {
$login = date('m\-d\-Y');
if ($logout = $mysqli->prepare("UPDATE `mydb`.`authlog`
SET `logout` = ? WHERE `login` LIKE '$login%'")) { // <--- Will not go
any further than here, even when hard coding the information.
$logout->bind_param("s", date('m\-d\-Y\TH\:i\:s'));
$logout->execute();
$logout->close();
}
}
$mysqli->close();
?>
--
Nathaniel Hall, GSEC GCFW GCIA GCIH GCFA
Spider Security
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
