wss在php7中会出现无法正常使用的情况,跟踪代码发现是mysql扩展导致的新版本的php中无法再使用老的mysql扩展转而采用了mysqli
由此得出解决方案如下,使用mysqli方法替换其中的mysql方法
添加一个文件修改一处代码即可解决问题
奉上代码
<?php
//config/tank_config.php中
error_reporting(0);
$hostname_tankdb = "192.168.1.254"; //database host
$database_tankdb = "wss"; //database name
$username_tankdb = "root"; //mysql user name
$password_tankdb = "mysql"; //mysql password
$port_tankdb = 3306;
require_once 'config/replace_func.php';//添加上这句
$tankdb = mysql_connect($hostname_tankdb, $username_tankdb, $password_tankdb) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_query("set names 'utf8'");
require "function.class.php";
$language = "cn";
$advsearch = get_item( 'advsearch' );
$outofdate = get_item( 'outofdate' ) ;
?>
<?php require "multilingual/language_$language".".php"; ?>
新加文件replace_func.php
<?php
/**
* @auth bruce
* @date 2016-11-18
*/
if( !function_exists( 'mysql_connect' ))
{
// mysql_connect($hostname_tankdb, $username_tankdb, $password_tankdb)
function mysql_connect( $host, $username, $password )
{
return mysqli_connect( $host, $username, $password );
}
}
if( !function_exists( 'mysql_error' ))
{
function mysql_error()
{
global $tankdb;
return mysqli_error( $tankdb );
}
}
if( !function_exists( 'mysql_query' ))
{
function mysql_query( $query, $link = null )
{
if( !$link )
{
global $tankdb;
$link = $tankdb;
}
return mysqli_query( $link, $query );
}
}
if( !function_exists( 'mysql_select_db' ))
{
function mysql_select_db( $dbName, $link )
{
mysqli_select_db( $link, $dbName );
}
}
if( !function_exists( 'mysql_insert_id') )
{
function mysql_insert_id()
{
global $tankdb;
return mysqli_insert_id( $tankdb );
}
}
if( !function_exists( 'mysql_num_rows') )
{
function mysql_num_rows( $result )
{
return mysqli_num_rows( $result );
}
}
if( !function_exists( 'mysql_fetch_assoc') )
{
function mysql_fetch_assoc( $result )
{
return mysqli_fetch_assoc( $result );
}
}
if( !function_exists( 'mysql_fetch_array') )
{
function mysql_fetch_array( $result, $resultType = MYSQLI_ASSOC )
{
return mysqli_fetch_array( $result, $resultType );
}
}
if( !function_exists( 'mysql_free_result') )
{
function mysql_free_result( $result )
{
return mysqli_free_result( $result );
}
}
if( !function_exists( 'mysql_real_escape_string') )
{
function mysql_real_escape_string( $result, $link = null )
{
if( !$link )
{
global $tankdb;
$link = $tankdb;
}
return mysqli_real_escape_string( $link, $result);
}
}
if( !function_exists( 'mysql_escape_string') )
{
function mysql_escape_string( $result )
{
global $tankdb;
return mysqli_escape_string( $tankdb, $result );
}
}
if( !function_exists( 'mysql_data_seek') )
{
function mysql_data_seek( $result, $row_number )
{
mysqli_data_seek($result, $row_number );
}
}
if (!function_exists('mysql_result'))
{
function mysql_result( $result, $number, $field = 0 )
{
mysqli_data_seek( $result, $number );
$row = mysqli_fetch_array( $result );
return $row[ $field ];
}
}
另:我们在使用mysqli代替mysql的过程中会出现筛选与查找无法正常进行的情况(跨年或是不限年筛选),我们只需要对wss源代码进行全文搜索之后到3000-13-31然后全部替换为3000-12-31即可