php链接mysql进行增删改查

编辑过程首先打开wampserver选择

打开的文件夹内新建php文件，编写代码

//p.php
<?php
	//display_errors=off;
	$conn = mysql_connect("localhost","root","");
	$sql = "create database week12;";
	mysql_query($sql, $conn);
	mysql_select_db("week12",$conn);
	$sql1="create table lab8(
			country varchar(20),
			area varchar(20),
			school varchar(20));";
	mysql_query($sql1, $conn);
	$sql="insert into lab8 values('china','guangdong','sysu');";
	mysql_query($sql, $conn);
	$sql1="insert into lab8 values('america','california','ucla');";
	mysql_query($sql1, $conn);
	$sql="update lab8 set school='ucb' where school='ucla';";
	mysql_query($sql, $conn);
	$sql="delete from lab8 where school='ucb';";
	mysql_query($sql, $conn);
	?>

保存，在网页输入网址http://localhost/p.php得到结果

若是更改了端口则需要(以8088为例)http://localhost:8088/p.php