the+mysql+extension_解决Deprecated: mysql_connect(): The mysql extension is deprecated and will be rem...

谁能帮我吗

926/07/2015 下午 8:475楼

能帮我改改吗？

exec($sql) )return array();

if( ! mysql_num_rows($result) )return array();

$rows = array();

while($rows[] = mysql_fetch_array($result,MYSQL_ASSOC)){}

mysql_free_result($result);

array_pop($rows);

return $rows;

}

public function newinsertid()

{

return mysql_insert_id($this->conn);

}

public function showtables($tables)

{

return mysql_num_rows(mysql_query(“show tables like ‘%”.$tables.”%'”,$this->conn));

}

public function setlimit($sql, $limit)

{

return $sql. ” LIMIT {$limit}”;

}

public function exec($sql)

{

$this->arrSql[] = $sql;

if( $result = mysql_query($sql, $this->conn) ){

return $result;

}else{

if(mysql_error()!=”){

syError(“{$sql}执行错误: ” . mysql_error());

}else{

return TRUE;

}

}

}

public function affected_rows()

{

return mysql_affected_rows($this->conn);

}

public function getTable($tbl_name)

{

return $this->getArray(“DESCRIBE {$tbl_name}”);

}

public function __construct($dbConfig)

{

$linkfunction = ( TRUE == $dbConfig[‘persistent’] ) ? ‘mysql_pconnect’ : ‘mysql_connect’;

$this->conn = $linkfunction($dbConfig[‘host’].”:”.$dbConfig[‘port’], $dbConfig[‘login’], $dbConfig[‘password’]);

if(!$this->conn || !mysql_select_db($dbConfig[‘database’], $this->conn)){

echo ‘数据库无法链接，如果您是第一次使用，请先执行安装程序网润科技建站程序 m.cqbaidu.com‘;exit;

}

$this->exec(“SET NAMES UTF8”);

if($this->version() > ‘5.0.1’) {

$this->exec(“set sql_mode=””);

}

}

public function version() {

return mysql_get_server_info($this->conn);

}

public function __val_escape($value) {

return ‘\”.$value.’\”;

}

public function __destruct()

{

if( TRUE != $GLOBALS[‘G_DY’][‘db’][‘persistent’] )@mysql_close($this->conn);

}

}