PHP Command line script
| From: | Nathaniel Hall | Date: | Tue, 01 May 2007 20:13:07 +0000 |
| Subject: | PHP Command line script | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-254208@lists.php.net to get a copy of this message | ||
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