# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

# *** default location during install, and will be replaced if you

# *** upgrade to a newer version of MySQL.

[client]

default-character-set = utf8mb4

[mysql]

default-character-set = utf8mb4

[mysqld]

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_bin

init_connect='SET NAMES utf8mb4'

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

basedir = D:\搜狗高速下载\mysql-8.0.16-winx64   //这里是你自己安装mysql的文件地址

datadir = D:\MySQL\Database                    //用来存放数据库文件的地址，自己要新建一个哟

port = 3306                                    //端口号默认不用修改

# server_id = .....

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

join_buffer_size = 128M

sort_buffer_size = 16M

read_rnd_buffer_size = 16M

sql_mode=NO_EN

<?php

//设定字符集

header('Content-Type:text/html;charset=utf-8');

//开启调试模式

define('DB_DEBUG',true);

//加载数据库操作函数库

require '.\lib\db_function.php';

//初始化数据库

$link = db_init(array(

    'host' => '127.0.0.1', //主机名

    'user' => 'root',      //用户名

    'password' => '123456',//密码

    'dbname' => 'stumanager',  //数据库

    'charset' => 'utf8'    //字符集

)); 

//接收GET变量

function input_get($name){

    return isset($_GET[$name]) ? $_GET[$name] : '';

}

//接收POST变量

function input_post($name){

    return isset($_POST[$name]) ? $_POST[$name] : '';

}

/**

 * 对字符串数据进行过滤

 * @param string $data 待转义字符串

 * @return string 转义后的字符串

 */

function filter($data,$func=array('trim','htmlspecialchars')){

    foreach($func as $v){

        //调用可变函数过滤数据

        $data = $v((string)$data);

    }

    return $data;

}

/**

 * JavaScript弹窗并返回

 */

function alert_back($msg){

    echo "<script>alert('$msg');history.back();</script>";

    exit;

}

#加载PHP模块

LoadModule php5_module "D:/php-5.4.28/php5apache2_2.dll"

AddType application/x-httpd-php . php

PHPIniDir "D:/php-5.4.28"