<?php?>
header("content-type:text/html;charset=utf-8");
require_once 'config/config.php';
require_once 'functions/mysql.func.php';
$link = connect3();
$table = "student";
$totalRows = getTotalRows($link, $table);
$sumPage = ceil($totalRows/$pageSize);
$query = "select * from student";
$rows = fetchAll($link, $query);
print_r($rows);
?>
这是文件1代码,文件名profile.php,根目录下的,引用路径是没错的,路径前加上./也是报错HTTP ERROR 500,甚至把所有代码删除只留下
<?php
require_once 'config/1.php';
?>
引一个空的文件也报错HTTP ERROR 500
<?php
require_once '../functions/mysql.func.php';
require_once '../config/config.php';
header("content-type:text/html;charset=utf-8");
$link = connect3();
$page = $_GET['page']?$_GET['page']:1;
$pageSize = 5;
$offSet = ($page-1)*5;
$table = "student";
$totalRows = getTotalRows($link, $table);
$sumPage = ceil($totalRows/$pageSize);
$query = "select * from student";
$rows = fetchAll($link, $query);
?>
这是文件2的代码,文件名layout-index.php,在Student目录下,运行代码是正常的
<?php
$config = array(
'host'=>'localhost',
'user'=>'3hnyuta29i222',
'password'=>'yijia888',
'charset'=>'utf8',
'dbName'=>'3hnyuta29i222'
);
define('DB_HOST','localhost');
define('DB_USER','3huyuta21i212');
define('DB_PWD','******');
define('DB_CHARSET','utf8');
define('DB_DBNAME','3huyuta21i212');
>
这是引用的config.php文件代码
function connect3(){
$link = mysqli_connect ( DB_HOST, DB_USER, DB_PWD ) or die ( '数据库连接失败<br/>ERROR ' . mysqli_connect_errno () . ':' . mysqli_connect_error () );
mysqli_set_charset ( $link, DB_CHARSET );
mysqli_select_db ( $link, DB_DBNAME ) or die ( '指定数据库打开失败<br/>ERROR ' . mysqli_errno ( $link ) . ':' . mysqli_error ( $link ) );
return $link;
}
function insert($link,$data,$table){
$keys = join ( ',', array_keys ( $data ) );
$vals = "'" . join ( "','", array_values ( $data ) ) . "'";
$query = "INSERT {$table}({$keys}) VALUES({$vals})";
$res = mysqli_query ( $link, $query );
if ($res) {
return mysqli_insert_id ( $link );
} else {
return false;
}
}
function update($link, $data, $table, $where = null) {
foreach ( $data as $key => $val ) {
$set .= "{$key}='{$val}',";
}
$set = trim ( $set, ',' );
$where = $where == null ? '' : ' WHERE ' . $where;
$query = "UPDATE {$table} SET {$set} {$where}";
$res = mysqli_query ( $link, $query );
if ($res) {
return mysqli_affected_rows ( $link );
} else {
return false;
}
}
function delete($link, $table, $where = null) {
$where = $where ? ' WHERE ' . $where : '';
$query = "DELETE FROM {$table} {$where}";
$res = mysqli_query ( $link, $query );
if ($res) {
return mysqli_affected_rows ( $link );
} else {
return false;
}
}
function fetchOne($link, $query, $result_type = MYSQLI_ASSOC) {
$result = mysqli_query ( $link, $query );
if ($result && mysqli_num_rows ( $result ) > 0) {
$row = mysqli_fetch_array ( $result, $result_type );
return $row;
} else {
return false;
}
}
function fetchAll($link, $query, $result_type = MYSQLI_ASSOC) {
$result = mysqli_query ( $link, $query );
if ($result && mysqli_num_rows ( $result ) > 0) {
while ( $row = mysqli_fetch_array ( $result, $result_type ) ) {
$rows [] = $row;
}
return $rows;
} else {
return false;
}
}
function getTotalRows($link, $table) {
$query = "SELECT COUNT(*) AS totalRows FROM {$table}";
$result = mysqli_query ( $link, $query );
if ($result && mysqli_num_rows ( $result ) == 1) {
$row = mysqli_fetch_assoc ( $result );
return $row ['totalRows'];
} else {
return false;
}
}
function getResultRows($link, $query) {
$result = mysqli_query ( $link, $query );
if ($result) {
return mysqli_num_rows ( $result );
} else {
return false;
}
}
function getServerInfo($link) {
return mysqli_get_server_info ( $link );
}
function getClientInfo($link) {
return mysqli_get_client_info ( $link );
}
function getHostInfo($link){
return mysqli_get_host_info($link);
}
function getProtoInfo($link) {
return mysqli_get_proto_info ( $link );
}
这是引用的mysql.func.php文件代码
```