PHP Command line script

From: 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

« previous php.general (#254208) next »