PHP数据库链接-回显-代码

<?php
	$conn = mysqli_connect("localhost","root","","test","8806")
	 or die("connect fail:".mysqli_connect_error());
	 
	$sql = "select * from emp";
	
	$result = mysqli_query($conn,$sql); 
	
	while($emp=mysqli_fetch_assoc($result)){
		echo $emp["empno"]."&nbsp;&nbsp;".$emp["ename"];
		echo "<br>";
	}
	
	mysqli_free_result($result);
	mysqli_close($conn);
?>

---

<?php
	$conn = mysqli_connect("localhost","root","123456","test") or 
	die("connect fail:".mysqli_connect_error());
	
	$sql = "select * from emp";
	
	$result = mysqli_query($conn,$sql);
	
	echo "<table border=1 align=center width=300>";
	echo "<tr><th>empno</th><th>ename</th><th>job</th></tr>";
	while($emp=mysqli_fetch_assoc($result)){
		echo "<tr>";
		echo "<td>".$emp["empno"]."</td>".	"<td>".$emp["ename"]."</td>"
			."<td>".$emp["job"]."</td>";
		echo "</tr>";
	}
	
	
	echo "</table>";
	
?>

<?php
	$conn = mysqli_connect("localhost","root","123456","test") or 
	die("connect fail:".mysqli_connect_error());
	
	$sql = "insert into emp(empno,ename,job) values(null,'ddd','clerk')";
	
	$result = mysqli_query($conn,$sql);
	
	$rows = mysqli_affected_rows($conn);
	
	//验证是否成功
	if($result && $rows>0){
		echo "success";
	}
	
	mysqli_close($conn);
	
?>

---

<?php
	$conn = mysqli_connect("localhost","root","","test","8806") or 
	die("connect fail:".mysqli_connect_error());
	
	
	// 查询10号部门的人员信息
//	$depno = 30;
//	$sql = "select * from emp where deptno=$depno";

	$job = "CLERK";
	$sql = "select * from emp where job = '{$job}' ";
	
	$result = mysqli_query($conn,$sql);
	echo "<table border=1 align=center width=300>";
	echo "<tr><th>empno</th><th>ename</th><th>job</th></tr>";
	while($emp=mysqli_fetch_assoc($result)){
		echo "<tr>";
		echo "<td>".$emp["empno"]."</td>".	"<td>".$emp["ename"]."</td>"
			."<td>".$emp["job"]."</td>";
		echo "</tr>";
	}
	
	echo "</table>";
	
	mysqli_free_result($result);
	mysqli_close($conn);

?>

<?php
	$empno = $_GET["empno"];
	$ename = $_GET["ename"];
	$job = $_GET["job"];
	
	$conn = mysqli_connect("localhost","root","","test","8806") or 
	die("connect fail:".mysqli_connect_error());
	
	$sql = "update emp set ename='$ename',job='$job' where empno = $empno";
	
	$result = mysqli_query($conn,$sql);
	
	if($result){
		echo "<script>alert('success');window.location.href='show.php';</script>";
	}else{
		echo "<script>alert('fail');window.location.href='show.php';</script>";
	}
	
	mysqli_close($conn);
?>

<?php
	$empno = $_GET["empno"];
	//echo $empno;
	$conn = mysqli_connect("localhost","root","","test","8806") or 
	die("connect fail:".mysqli_connect_error());
	$sql = "select * from emp where empno= $empno";
	
	$result = mysqli_query($conn,$sql);
	
	$emp=mysqli_fetch_assoc($result);
	
	mysqli_free_result($result);
	mysqli_close($conn);
	
?>
 	<!--数据的回显-->
	<form action="update_ok.php" method="get">
		empno: <input type="text" name="empno" value="<?php echo $emp['empno'] ?>" /> <br>
		ename: <input type="text" name="ename" value="<?php echo $emp['ename'] ?>"/> <br>
		job: <input type="text" name="job" value="<?php echo $emp['job'] ?>"/> <br>
		<input type="submit" value="save" />	
	</form>

<?php
	$conn = mysqli_connect("localhost","root","","test","8806") or 
	die("connect fail:".mysqli_connect_error());
	
	
	$sql = "select * from emp ";
	
	$result = mysqli_query($conn,$sql);
	echo "<table border=1 align=center width=300>";
	echo "<tr><th>empno</th><th>ename</th><th>job</th><th>operation</th></tr>";
	while($emp=mysqli_fetch_assoc($result)){
		echo "<tr>";
		echo "<td>".$emp["empno"]."</td>".	"<td>".$emp["ename"]."</td>"
			."<td>".$emp["job"]."</td>";
		$empno= $emp["empno"];	
		echo "<td><a href='update.php?empno=$empno'>update</a></td>";	
	}
	
	echo "</table>";
	
	mysqli_free_result($result);
	mysqli_close($conn);
?>