php连接mysql，数据CRUD操作

最新推荐文章于 2024-09-14 17:41:03 发布

weixin_30367169

最新推荐文章于 2024-09-14 17:41:03 发布

阅读量105

点赞数

文章标签： php 数据库

原文链接：http://www.cnblogs.com/2016-zck/p/9232773.html

版权

插入数据

<?php
    $name = $_GET['username'];
$sex = $_GET['sex'];
$hobby = $_GET['hobby'];
$address = $_GET['address'];
$remark = $_GET['remark'];

$conn = mysqli_connect("localhost","root","root","exercise");
if ($conn){
$sql = "INSERT INTO info(姓名,性别,爱好,家庭住址,备注) VALUES ('$name','$sex','$hobby','$address','$remark')";
if (mysqli_query($conn,$sql) === true) {
echo "新纪录插入成功";
 } else {
echo "新剧路插入失败".mysqli_error($conn);
 }
mysqli_close($conn);
 }else{
die("连接数据库失败：" . mysqli_error());
 }
?>

遍历表中所有数据

 $conn = mysqli_connect("localhost","root","root","exercise");
if ($conn){ 
          $result=mysqli_query($conn,"select * from info");
 while($myrow=mysqli_fetch_row($result)) {
echo "<tr><td>$myrow[0]</td><td>$myrow[1]</td><td>$myrow[2]</td><td>$myrow[3]</td>
 <td>$myrow[4]</td><td><a href='#'>修改</a>&nbsp<a href='#'>删除</a></td></tr>";
 }
mysqli_close($conn);
 }else{
die("连接数据库失败：" . mysqli_error());
 }