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 "关闭失败";
}
?>