MySQL 从带有 PDO 的 SELECT 插入

2021-12-26 00:00:00 sql insert php mysql pdo

我在使用 PHP PDO 从 SELECT 查询中插入 INSERT 时有一个奇怪的行为.直接在 MySQL 中测试查询效果很好，我插入了我的行:

I have a strange behaviour using PHP PDO for a INSERT from a SELECT query. Testing the query directly in MySQL it works well, I get my row inserted :

INSERT INTO sessionid (enc_id, enc_pass, enc_date) 
SELECT AES_ENCRYPT(username, 'aeskey'), AES_ENCRYPT(pwd, 'aeskey'), 
DATE_ADD(NOW(), INTERVAL 15 SECOND) FROM users WHERE username = 'a_user_name';

但是使用 PDO，我为每个用户一次插入一行(279 行)......这是 PHP :

But using PDO, I have one row per user inserted at once (279 rows) .... Here is the PHP :

$sql_enc = '
    INSERT INTO sessionid (enc_id, enc_pass, enc_date) 
        (SELECT AES_ENCRYPT(username, :aeskey), AES_ENCRYPT(pwd, :aeskey), DATE_ADD(NOW(), INTERVAL 15 SECOND) FROM users WHERE username = :username)
';
$res_enc = $pdo->prepare($sql_enc);
$res_enc->bindParam(':aeskey', $aeskey);
$res_enc->bindParam(':username', $username);
$res_enc->bindParam(':pwd', $username);
$res_enc->execute();
$res_enc = null;

我错过了什么?我几乎可以肯定它什么都不是，但不能让它插入那一行.

What am I missing? I'm almost sure it's nothing but can't make it insert that single row.

谢谢.

法比恩.

推荐答案

这不是可能的问题，而是您在代码的密码字段中输入了用户名.在您的查询中，您在那里插入 aeskey.这是我能发现的唯一区别.

Not that it is the probable problem, but you put a username in the password field in your code. In your query you insert the aeskey there. It is the only difference I can spot.

相关文章