php连接数据库

1.数据的添加

<?php
$con=mysqli_connect("localhost:3306","root","bwcx130313");
if (!mysqli_select_db($con,"student")) {
	echo "连接失败".mysqli_connect_error();
	exit;
}
else echo"连接成功";
$q="insert into score values('20160611025','9222550','95')";
mysqli_query($con,"set names utf8");
if (mysqli_query($con,$q)) {
	echo "加入";
}
else {
	echo "失败";
}

?>

2.数据的查询

<?php
$con=mysqli_connect("localhost:3306","root","bwcx130313");
if (!mysqli_select_db($con,"student")) {
	echo "连接失败".mysqli_connect_error();
	exit;
}
else echo"连接成功";
//mysqli_query($con,"set names utf8");
$q="select stuID,courseID,score from score where stuID=20160511021";
$result = mysqli_query($con,$q);
if ($result) {
	echo "信息查询成功<br>";
	$p=mysqli_fetch_array($result,MYSQLI_BOTH);
	if ($p) {
	echo "学生id.".$p[0]."<br>";
	echo "课程id.".$p[1]."<br>";
	echo "得分.".$p[2]."<br>";
}
else {
	echo "信息不存在";
}


}
else {
	echo "信息查询失败";
}

?>

<?php
$con=mysqli_connect("localhost:3306","root","bwcx130313");
if (!mysqli_select_db($con,"student")) {
	echo "连接失败".mysqli_connect_error();
	exit;
}
else echo"连接成功";
//mysqli_query($con,"set names utf8");
$q="select * from score";
$result = mysqli_query($con,$q);
if ($result) {
	echo "总数查询成功<br>";
	$p=mysqli_num_rows($result);
	echo "总数为".$p;
}
else {
	echo "信息查询失败";
}

?>

<?php
$con=mysqli_connect("localhost:3306","root","bwcx130313");
if (!mysqli_select_db($con,"student")) {
	echo "连接失败".mysqli_connect_error();
	exit;
}
else echo"连接成功";
//mysqli_query($con,"set names utf8");
$q="select * from score";
$result = mysqli_query($con,$q);
if ($result) {
	echo "查询成功<br>";
	if (mysqli_data_seek($result,2)) {
	$p=mysqli_fetch_array($result,MYSQLI_BOTH);
	echo "2.1:".$p[0]."<br>";
    echo "2.2:".$p[1]."<br>";
}
else echo "定位失败";
	
}
else {
	echo "查询失败";
}

?>

3.数据的修改

<?php
$con=mysqli_connect("localhost:3306","root","bwcx130313");
if (!mysqli_select_db($con,"student")) {
	echo "连接失败".mysqli_connect_error();
	exit;
}
else echo"连接成功";
//mysqli_query($con,"set names utf8");
$q="update score set score='55' where score='95'";
if (mysqli_query($con,$q)) {
	echo "修改成功";
}
else {
    echo "修改失败";
}
?>

4.数据的删除

<?php
$con=mysqli_connect("localhost:3306","root","bwcx130313");
if (!mysqli_select_db($con,"student")) {
	echo "连接失败".mysqli_connect_error();
	exit;
}
else echo"连接成功";
//mysqli_query($con,"set names utf8");
$q="delete from score  where score='55'";
if (mysqli_query($con,$q)) {
	echo "修改成功";
}
else {
    echo "修改失败";
}
?>

5.关于MySQL服务器的连接

<?php
$con=mysqli_connect("localhost:3306","root","bwcx130313");
if (!mysqli_select_db($con,"student")) {
	echo "连接失败".mysqli_connect_error();
	exit;
}
else echo"连接成功";
//mysqli_query($con,"set names utf8");
if (mysqli_close($con)) {
	echo "成功关闭";
}
else {
    echo "关闭失败";
}
?>