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