PHP mysql_query()函数用于在表中插入记录。从PHP 5.5开始,不推荐使用 mysql_query()函数。现在建议使用两种替代方法之一。
<?php $host = 'localhost:3306'; $user = ''; $pass = ''; $dbname = 'test'; $conn = mysqli_connect($host, $user, $pass,$dbname); if(!$conn){ die('Could not connect: '.mysqli_connect_error()); } echo 'Connected successfully<br/>'; $sql = 'INSERT INTO emp4(name,salary) VALUES ("sonoo", 9000)'; if(mysqli_query($conn, $sql)){ echo "Record inserted successfully"; }else{ echo "Could not insert record: ". mysqli_error($conn); } mysqli_close($conn); ?>
输出:
链接:https://www.learnfk.comhttps://www.learnfk.com/php/php-mysql-insert.html
来源:LearnFk无涯教程网
Connected successfully Record inserted successfully
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)