dongyaxiao5884 2018-02-06 16:38
浏览 52
已采纳

使用PDO和变量进行MySQL更新

I'm having a strange problem with php PDO and mysql. I read other examples here, but while I am learning MySQL with the PDO, I did not understand it and I could not solve it yet.

$name = $_POST[ "name" ];
$email = $_POST[ "email" ];
$telefone = $_POST[ "telefone" ];
$endereco = $_POST[ "endereco" ];
$numero = $_POST[ "numero" ];
$bairro = $_POST[ "bairro" ];
$cidade = $_POST[ "cidade" ];

$telefoneHash = make_hash( $telefone );

$PDO = db_connect();

//$PDO->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
//With this code it gives the error: 'Syntax error or access violation: 1064'
//Without it it does not give an error but does not perform the update

$PDO = $PDO->prepare( 'UPDATE users SET :name, :email, :telefone, :endereco, :numero, :bairro, :cidade WHERE email = :email' ); 

$PDO->bindValue( ':name', $_REQUEST[ 'name' ] );
$PDO->bindValue( ':email', $_REQUEST[ 'email' ] );
$PDO->bindValue( ':telefone', $telefoneHash );
$PDO->bindValue( ':endereco', $_REQUEST[ 'endereco' ] );
$PDO->bindValue( ':numero', $_REQUEST[ 'numero' ] );
$PDO->bindValue( ':bairro', $_REQUEST[ 'bairro' ] );
$PDO->bindValue( ':cidade', $_REQUEST[ 'cidade' ] );
$PDO->execute();

echo $PDO->rowCount() . " records UPDATED successfully";
  • 写回答

2条回答 默认 最新

  • du7999 2018-02-06 16:44
    关注

    The syntax for UPDATE with PDO is SET col=:col

    Using the column name, followed by the equal sign and the named placeholder.

    $PDO = $PDO->prepare( 'UPDATE users SET name = :name, email = :email, 
                           telefone = :telefone, endereco = :endereco, 
                           numero = :numero, bairro = :bairro, cidade = :cidade 
                           WHERE email = :email' ); 
    

    PDO error handling would have clearly shown you the errors:

    Use error reporting also.

    This assuming that the column names are of the same names that I used here.

    However and as stated, why use the $_REQUEST's? Just use the variables that you assigned in the POST arrays, and assuming that your form is using a post method.

    $PDO->bindValue(':name', $name);
    $PDO->bindValue(':email', $email);
    $PDO->bindValue(':telefone', $telefoneHash);
    $PDO->bindValue(':endereco', $telefone);
    $PDO->bindValue(':numero', $numero);
    $PDO->bindValue(':bairro', $bairro);
    $PDO->bindValue(':cidade', $cidade);
    $PDO->execute();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 开发一个小区生态的小程序
  • ¥15 MddBootstrapInitialize2失败
  • ¥15 LCD Flicker
  • ¥15 Spring MVC项目,访问不到相应的控制器方法
  • ¥15 esp32在micropython环境下使用ssl/tls连接mqtt服务器出现以下报错Connected on 192.168.154.223发生意外错误: 5无法连接到 MQTT 代理,如何解决?
  • ¥15 关于#genesiscsheel#的问题,如何解决?
  • ¥15 Android aidl for hal
  • ¥15 STM32CubeIDE下载程序报错
  • ¥15 微信好友如何转变为会员系统?(相关搜索:小程序)
  • ¥15 c# 直接使用c++ 类库文件