                        課程
                    
                        /后端開發
                        
                            /PHP
                        
                        /PDO—數據庫抽象層

$sql=<<<EOF .... EOF;中，輸入sql語句，同時插入三條記錄，如想把密碼用md5加密，要如何做呢？

$sql=<<<EOF

INSERT user (username,password,email) VALUES("傅1", "'.md5('fhfjy').'","[email protected]"),

("傅2", "'.md5('fhfjy').'","[email protected]"),

("傅3", "'.md5('fhfjy').'","[email protected]")

EOF;

================================

插入后，去數據庫里看到的密碼是: ?'.md5('fhfjy').' ? 這樣的！

奉化奔騰JAVA

2015-03-12

源自：PDO—數據庫抽象層 2-2

關注問題我要回答

3175

操作

收起

5 回答

King
2015-03-15

用變量替代只能

^-^...

0 回復有任何疑惑可以回復我~

收起回答

UFO2015

什么意思？

2016-04-09 回復有任何疑惑可以回復我~

UFO2015 回復 UFO2015

$str = md5("Shanghai"); echo ("Shanghai:".$str."<br/>");

2016-04-09 回復有任何疑惑可以回復我~

UFO2015
2016-04-09

<?php?
//PDO
try{
????//?$pdo?=?new?PDO('mysql:host=localhost;dbname=test',?'root',?'123456',?options)
????$pdo?=?new?PDO('mysql:host=localhost;dbname=test',?'root',?'123456');
????$sql?=?<<<?EOF
???????????CREATE?TABLE?IF?NOT?EXISTS?users(
???????????id?INT?UNSIGNED?AUTO_INCREMENT?KEY,
???????????username?VARCHAR(32)?NOT?NULL?UNIQUE,
???????????password?CHAR(255)?NOT?NULL,
???????????email?VARCHAR(255)?NOT?NULL
???????????);
EOF;
????$res?=?$pdo->exec($sql);
????var_dump($res);
????echo?"exec()???".$res.":?0?<br/>";
????//?define('pwd',?'pdw0001',?case_insensitive);
????$pwd?=?"pwd&md5";
????$pwd1?=?"pwd@md51";
????$pwd2?=?"pwd$md52";
????$salt?=?"salt_md5";

????$md5?=?crypt($pwd,?$salt);
????echo?"md5:{$md5}<br/>";
????$md51?=?crypt($pwd1,?$salt);
????echo?"md5:{$md51}<br/>";
????$md52?=?crypt($pwd2,?$salt);
????echo?"md5:{$md52}<br/>";

????$str?=?md5("Shanghai");
????echo?("Shanghai:".$str."<br/>");

????$sql?=?<<<?EOF
?????????????INSERT?users(username,password,email)?
?????????????VALUES?("u01","$md5","[email protected]"),
?????????????("u02","{$md51}","[email protected]"),
?????????????("u03","$md52","[email protected]");
EOF;
????echo?"{$sql}<br/>";
????$res?=?$pdo->exec($sql);
????var_dump($res);
????echo?"<br/>";

????echo?"exec()???".$res.":?0?<br/>";
}catch(PDOException?$e){
????echo?($e->getMessage());
}


??>

0 回復有任何疑惑可以回復我~

收起回答

UFO2015
2016-04-09

http://www.xianlaiwan.cn/qadetail/131282?t=158630#id_158630

$sql = <<<EOF
INSERT user(username,passwd) VALUES("u01","'.md5()'"),("u02","'.md5('pwd').'"),("u03","'.md5()'");
EOF;

EOF;// EOF; 結束符要頂格寫（前面不可以有空格?。?/p>

google：

http://stackoverflow.com/questions/20931450/parse-error-syntax-error-unexpected-t-sl

1 回復有任何疑惑可以回復我~

收起回答

UFO2015
2016-04-09

<?php
// PDO
try{
?? ?$pdo = new PDO("mysql:host=localhost;dbname=test", 'root', '');
?? ?$sql = <<< EOF
?? ?INSERT user(username,passwd) VALUES("u01","'.md5()'"),("u02","'.md5('pwd').'"),("u03","'.md5()'");
?? ?EOF;
??? $result = $pdo->exec($sql);
}catch(PDOException $e){
?? ?echo $e->getMessage();
}

//To print a list of all the drivers that PDO currently supports, use the following code:

$xxx = var_dump(PDO::getAvailableDrivers());
echo ($xxx);

?>