以下为我工作:
我必须指出,您不能将其$postedOn = Now();
用作发布当前时间/日期的变量。需要将其输入为VALUES
IE: VALUES(:videoId,:username,Now())";
请注意,我用作$pdo
连接变量。
<?PHP
$MysqL_hostname = 'xxx';
$MysqL_username = 'xxx';
$MysqL_password = 'xxx';
$MysqL_dbname = 'xxx';
try {
$pdo= new PDO("MysqL:host=$MysqL_hostname;dbname=$MysqL_dbname", $MysqL_username, $MysqL_password);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
exit( $e->getMessage() );
}
$sql = "SELECT MAX(videoId) AS videoId FROM videoinfo";
$stmt = $pdo->prepare($sql);
$stmt -> execute(array());
$record = $stmt->fetch();
$videoID = $record['videoId'];
// var_dump($videoID);
$username = $_POST['submitter'];
try {
$sql = "INSERT INTO adminposts
(videoId,username,postedOn)
VALUES(:videoId,:username,Now())";
$stmt = $pdo -> prepare($sql);
$stmt -> execute(array(":videoId"=> $videoID,":username"=> $username));
}
catch(PDOException $e){
// $result = "Sorry, an error occurred while editing the database.";
// will print a message of the actual error should there be one
print $e->getMessage();
}