Question

我有一个接待点。我可以把我的发言与我的发言联系起来,但关于插入器的发言似乎奏效。现在,我已经界定了这些数值,但我计划使用从上页的表格中提取的定额备用金。

<?php

/*** mysql hostname ***/
$hostname =  xxx.xxx.xxx.xxx ;

/*** mysql username ***/
$username =  pressgym_admin ;

/*** mysql password ***/
$password =  ******* ;  <-started out on purpose

try {
$dbh = new PDO("mysql:host=$hostname;dbname=pressgym_press", $username, $password);
/*** echo a message saying we have connected ***/
$qry = $dbh->prepare( INSERT INTO contact (Name, Email Address, Message, Date) VALUES (?, ?, ?, ? );
$qry->execute(array( Brandon ,  [email protected] ,  test message ,  3.12.12 ));

echo  entry succesfull ;

}
catch(PDOException $e)
{
echo $e->getMessage();
}
?>

   describe contact;
   Name varchar(255)    NO  PRI     
   EmailAddress varchar(255)    NO          
   Message  longtext    NO          
   Date varchar(255)    YES

Answer 1

页: 1 指挥有错误:

qry = $dbh->prepare( INSERT INTO contact (Name, Email Address, Message, Date) VALUES (?, ?, ?), ? );

应当:

qry = $dbh->prepare( INSERT INTO contact (Name, `Email Address`, Message, Date) VALUES (?, ?, ?, ?) );

Answer 2

页: 1 下表

$qry = $dbh->prepare( INSERT INTO contact (Name, Email Address, Message, Date) VALUES(?, ?, ?), ? );

应当:

$qry = $dbh->prepare( INSERT INTO contact (Name, Email Address, Message, Date) VALUES (?, ?, ?, ?) );

Update:

页: 1 电子邮件地址中有一个空间越轨,它就使用了适当的引号,如像识别号。

INSERT INTO contact (Name, `Email Address`, Message, Date) VALUES (?, ?, ?, ?)

友情链接