PHP从入门到能用（十一）PHP操作数据库（小型学生成绩管理系统demo实战）

【10-1】在student数据库下创建score数据表

score.sql

create table score(
	id int not null auto_increment,
	name char(255) not null,
	chinese int(4) not null,
	english int(4) not null,
	math int(4) not null,
	primary key(id)
);

【10-1】mysqli_connect()的用法

10-1.php

<?php
$link = mysqli_connect("localhost","root","","mydemo") or die("数据库连接失败".mysqli_connect_error());
echo "数据库连接成功！";
mysqli_set_charset($link,"utf8");

【10-2】 mysqli_select_db()的用法

<?php
$link = mysqli_connect("localhost","root","","mydemo") or die("数据库连接失败".mysqli_connect_error());
echo "数据库连接成功！";
$sql = mysqli_select_db($link,"test_student");
if($sql) echo"连接数据库成功！";
else echo "选择数据库失败！";
mysqli_set_chartset($link,"utf8");

【10-3】mysqli_query()的用法

<?php
include "10-1.php";
$sql = "select * from score";
$result = mysqli_query($link, $sql);
$n = mysqli_num_rows($result);
echo "查询到{
     $n}条记录";
$sql = "insert into score values(null,'张飞','100','100','100')";
echo $sql;
$result = mysqli_query($link, $sql);
if ($result) {
   
    echo "数据插入成功！";
} else {
   
    echo "数据插入失败！";
}

【10-4】mysqli_fetch_object()应用

include("10-1.php");
$sql = "select * from score order by id desc";
$data = mysqli_query($link , $sql);
echo '<table border="1"><caption>学生成绩浏览界面</caption><tr><td>姓名</td><td>语文</td><td>英文</td><td>数学</td></tr>';

while($output=mysqli_fetch_object($data)){
   
	echo "<tr>
	<td>{
     $output->id}</td>
	<td>{
     $output->name}</td>
	<td>{
     $output->chinese}</td>
	<td>{
     $output->english}</td>
	<td>{
     $output->