第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號(hào)安全,請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定

$sql=<<<EOF .... EOF;中,輸入sql語句,同時(shí)插入三條記錄,如想把密碼用md5加密,要如何做呢?

$sql=<<<EOF

INSERT user (username,password,email) VALUES("傅1", "'.md5('fhfjy').'","fhfjy@126.com"),

("傅2", "'.md5('fhfjy').'","fhfjy@126.com"),

("傅3", "'.md5('fhfjy').'","fhfjy@126.com")

EOF;

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

插入后,去數(shù)據(jù)庫里看到的密碼是: ?'.md5('fhfjy').' ? 這樣的!

正在回答

5 回答

用變量替代只能

^-^...

0 回復(fù) 有任何疑惑可以回復(fù)我~
#1

UFO2015

什么意思?
2016-04-09 回復(fù) 有任何疑惑可以回復(fù)我~
#2

UFO2015 回復(fù) UFO2015

$str = md5("Shanghai"); echo ("Shanghai:".$str."<br/>");
2016-04-09 回復(fù) 有任何疑惑可以回復(fù)我~
<?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","u01@ufo.xyz"),
?????????????("u02","{$md51}","u02@ufo.xyz"),
?????????????("u03","$md52","u03@ufo.xyz");
EOF;
????echo?"{$sql}<br/>";
????$res?=?$pdo->exec($sql);
????var_dump($res);
????echo?"<br/>";

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


??>

http://img1.sycdn.imooc.com//570881f60001ec8906600242.jpg

0 回復(fù) 有任何疑惑可以回復(fù)我~

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

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

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

google:

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


1 回復(fù) 有任何疑惑可以回復(fù)我~

<?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);

?>

0 回復(fù) 有任何疑惑可以回復(fù)我~

Parse error: syntax error, unexpected '<<' (T_SL) in G:\wwwRoot\php\pdo_md5.php on line 5


0 回復(fù) 有任何疑惑可以回復(fù)我~

舉報(bào)

0/150
提交
取消

$sql=<<<EOF .... EOF;中,輸入sql語句,同時(shí)插入三條記錄,如想把密碼用md5加密,要如何做呢?

我要回答 關(guān)注問題
微信客服

購課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)