PHP 增删改查

最新推荐文章于 2023-09-21 09:05:04 发布

枯树逢春><

最新推荐文章于 2023-09-21 09:05:04 发布

阅读量1.7k

点赞数 3

文章标签： php 开发语言后端

本文链接：https://blog.csdn.net/chengxumangki/article/details/122026407

版权

使用的这个软件

1.连接数据库

<?php
		 $coon=new mysqli("localhost","root","123456","hougd");
		 if($coon->connect_error)
		 echo "连接成功";
		 die("连接失败".$coon->connect_error);
 
		?>

2.增加

        <?php
		include("linksql.php");
		$add="inset into new1(table,content) 
		values('qwerty','qasedfdssddsd')";
		if($coon->query($add))
		echo "插入成功";
		else
		echo "插入失败".$coon->error;
		conn->close();
		header("location:linksql.php");
		?>

3.删除

        <?php
		include("linksql.php");
		$delet=("delete from new1 where id='1'");
		if($coon->query($delet))
		echo "删除成功";
		else
		echo "删除失败".$coon->error;
		$coon->close();	
		header("location:linksql.php");
		?>

4.更新

	    <?php
		include("linksql.php");
		$ta=$_POST[""];
		$co=$_POST[""];
		$upd=("update new1 set table'$ta',content'$co' where id='1'");
		if($coon->query($upd))
		echo "更新成功";
		else
		echo "更新失败".$coon->error;
		$coon->close();
		header("location:linksql.php");
		?>

5.连接，插入的另一个形式

        <?php
		include("linksql.php");
		// $sql="SELECT name FROM table1";
		$result=$conn->query("SELECT * FROM news1");
		// $result=$conn->query($sql);
		$data=$result->fetch_all();
		foreach($data as $v)
		echo $v[1]."<br />",$v[2]."<br />";



 
		$addi=$coon->prepare("inset into new1(table,content) values(?,?)");
		$addi->bind_param("ss",$ta,$co);
		$ta=$_POST[];
		$co=$_POST[];
		$addi->execute();
		echo "插入成功";
		$addi->close();
		$coon->close();
		?>