????$conn?=?new?mysqli($serverName,?$MYSQLUserName,?$MYSQLPwd);
????$sql?=?"use?WA";
????if($conn->query($sql)){
????}???else{
????????if($conn->error?==?"Unknown?database?'wa'"){
????????????$sqlCreateDatabase?=?"create?database?WA;";
????????????$sqlCreateDatabase?.=?"alter?database?WA?character?set?utf8;";
????????????$conn->multi_query($sqlCreateDatabase);
????????????$sqlCreateTable?=?"create?table?userInfo(
?????????????????id?smallint?unsigned?primary?key?auto_increment,
?????????????????userName?varchar(30),
?????????????????pwd?varchar(6)
?????????????);";
?????????????if($conn->query($sqlCreateTable)){
????????????????echo("success");
?????????????}??else{
????????????????echo($conn->error);
?????????????}
????????}
????}數(shù)據(jù)庫(kù)WA成功創(chuàng)建,字符集也修改了。但數(shù)據(jù)表沒(méi)能創(chuàng)建成功。報(bào)錯(cuò):Commands out of sync; you can't run this command now百度了下沒(méi)找到解決方法,說(shuō)是得先清空結(jié)果集,試了下也沒(méi)成功。請(qǐng)大神幫忙。錯(cuò)誤明顯是從第14行開(kāi)始的。在14行前面應(yīng)該是要釋放一下什么東西,請(qǐng)問(wèn)這個(gè)東西要怎么釋放。
php Mysql語(yǔ)句出錯(cuò)
慕先生4543078
2017-05-09 15:47:33