添加管理員失敗
/** ?*?插入操作 ?*?$table:表明 ?*?$array:數組 ?*/ function?insert($table,$array){ ????$link?=?connect(); ????$keys?=?join(",",?array_keys($array)); ????$vals?=?"'".join("','",array_values($array))."'";??//這里注意拼接 ????$sqli?=?"insert?{$table}($keys)?values({$vals})"; ????var_dump($sqli); ????mysqli_query($link,?$sqli); ????return?mysqli_insert_id($link); } function?addAdmin(){ ????$arr?=?$_POST; ????$arr['password']?=?md5($_POST['password']); //?????$mes?=?insert("shop_admin",?$arr); //?????????var_dump($mes); //?????????print_r($mes); ????if?(insert("shop_admin",?$arr)){ ????????$mes?=?"添加成功!<br/><a?href='addAdmin.php'>繼續添加</a>|<a?href='listAdmin.php'>查看管理員</a>"; ????}else?{ ????????$mes?=?"添加失敗!<br/><a?href='addAdmin.php'>重新添加</a>"; ????} ????return?$mes; } <?php require_once?'../include.php'; header("content-type:text/html;charset=utf-8"); $act=$_REQUEST['act']; if($act?==?"logout"){ ????//注銷 ????logout(); }elseif?($act?==?"addAdmin"){ ????//添加管理員 ????$mes?=?addAdmin(); } ?> <!DOCTYPE?html> <html> <head> <meta?charset="UTF-8"> <title></title> </head> <body> <?php ????if?($mes){ ????????echo?$mes; ????}else?{ ????????echo?"操作失??!"; ????} ?> </body> </html>
請問一下哪里出錯了嗎,找不出哪里的原因
2017-03-19
sqli?=?"insert?{$table} ($keys)?values ({$vals})"; 注意空格