php--mysqli操作
发布日期:2021-05-06 21:18:43 浏览次数:12 分类:技术文章

本文共 1417 字,大约阅读时间需要 4 分钟。

"; exit();}else{ echo "Host information:".mysqli_get_host_info($conn); mysqli_close($conn);}
"; exit();}else{ $sql = "create table tb_test(id int auto_increment primary key,testfield varchar(75) not null)"; $result = mysqli_query($conn,$sql); if($result === true) { echo "Talbe tb_test is created."."
"; } else { echo "could not create table:".mysqli_error($conn); } mysqli_close($conn);}
"; exit();}else{ $sql = "insert into tb_test(testfield) values('some value')"; $result = mysqli_query($conn,$sql); if($result === true) { echo " a record has been inserted."."
"; } else { echo "could not insert record.".mysqli_error($conn)."
"; } mysqli_close($conn);}
    Record Insertion Form    

"; exit(); } else { if(empty($_POST['testfield'])) { echo 'please fill right words.'."
"; return; } $clean_text =@mysqli_real_escape_string($conn,$_POST['testfield']); $sql = "insert into tb_test(testfield) values('$clean_text')"; $result = mysqli_query($conn,$sql); if($result === true) { echo 'insert ok.'."
"; } else { echo "could not insert record.".mysqli_error($conn); } mysqli_close($conn); }?>

 

上一篇:php--简单邮件列表的订阅与取消订阅
下一篇:php--既然MySQL支持事务,我必须随时使用事务吗?

发表评论

最新留言

能坚持,总会有不一样的收获!
[***.219.124.196]2025年03月24日 05时06分09秒