能帮写个mysql db_sql连接类吗 <?php class hq_online extends db_sql{ var $Host="localhost"; var $Database="hq"; var $User="root"; var $password=""; } 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 google上很多, 自己下个来用 可以看看我写的类queryphp 简单 MVC ORM框架---------------------------------------------http://topic.csdn.net/u/20100310/11/62a60067-b3da-4dee-9d6a-f1baeb2f3f33.html <?php/* * 数据库链接方法 mysql->connect * */class mysql{ function connect($dbhost, $dbuser, $dbpw, $dbname = '',$dbcharset='') { if(!@mysql_connect($dbhost, $dbuser, $dbpw)) { $this->show('Can not connect to MySQL server'); } if($dbname) { $this->select_db($dbname); } if($this->version() > '4.1') { if($dbcharset) { $this->query("SET NAMES '".$dbcharset."'"); } } } function select_db($dbname) { return mysql_select_db($dbname); } function fetch_array($query, $result_type = MYSQL_ASSOC) { return @mysql_fetch_array($query, $result_type); } function query($sql, $type = '') { // $sqlt="<script language=javascript>alert('非法ID 或 输入脚本有错误 KeBeKe.com 友情提醒');history.go(-1);</script>"; if(!($query = mysql_query($sql))) $this->show($sqlt, $sql); return $query; } function affected_rows() { return mysql_affected_rows(); } function result($query, $row) { return mysql_result($query, $row); } function num_rows($query) { return @mysql_num_rows($query); } function num_fields($query) { return mysql_num_fields($query); } function free_result($query) { return mysql_free_result($query); } function insert_id() { return mysql_insert_id(); } function fetch_row($query) { return mysql_fetch_row($query); } function version() { return mysql_get_server_info(); } function close() { return mysql_close(); } function show($message = '', $sql = '') { if(!$sql) echo $message; else echo $message.'<br>'.$sql; }}/**-------------* 获取客户端IP*-------------*/ function get_ip() { if (isset($_SERVER)) { if (isset($_SERVER[HTTP_X_FORWARDED_FOR])) { $realip = $_SERVER[HTTP_X_FORWARDED_FOR]; } elseif (isset($_SERVER[HTTP_CLIENT_IP])) { $realip = $_SERVER[HTTP_CLIENT_IP]; } else { $realip = $_SERVER[REMOTE_ADDR]; } } else { if (getenv("HTTP_X_FORWARDED_FOR")) { $realip = getenv( "HTTP_X_FORWARDED_FOR"); } elseif (getenv("HTTP_CLIENT_IP")) { $realip = getenv("HTTP_CLIENT_IP"); } else { $realip = getenv("REMOTE_ADDR"); } } return $realip; }/* * ---------------- * 操作完成的提示页面 Alan * ---------------- */ function get_show($url,$cont){ header("Location:../msage.php?url=$url&cont=$cont"); return; } function get_selected($type){ if($type==1){ $alan='selected'; } return $alan; }?> $link = mysql_connection("localhost","sa","") or die("Connection Exception",mysql_error()); 我有一个LOGIN.PHP的文件,登录时被人明文记录到TXT文件中是怎么做到的? PHP查询,结果怎样按时间分组显示? 希望通过大家的参与得到更多的结果 刚学php,请问下面这个数据库操作类怎么调用? php js问题 投票问题! 天津或北京附近地区PHP程序员联系单! 在php中如何实现自动注销 怪事啦! 为什么上传, 上传gif就可以, 上传txt就不行? 如何使用PHP输出数据的简单问题?急! php 读取 blob 乱码 blob中存的是普通文本,有中文 php 如何防止同个页面表单重复提交?
---------------------------------------------
http://topic.csdn.net/u/20100310/11/62a60067-b3da-4dee-9d6a-f1baeb2f3f33.html
<?php
/*
* 数据库链接方法 mysql->connect
*
*/
class mysql{
function connect($dbhost, $dbuser, $dbpw, $dbname = '',$dbcharset='') {
if(!@mysql_connect($dbhost, $dbuser, $dbpw)) {
$this->show('Can not connect to MySQL server');
}
if($dbname) {
$this->select_db($dbname);
}
if($this->version() > '4.1') {
if($dbcharset) {
$this->query("SET NAMES '".$dbcharset."'");
}
}
} function select_db($dbname) {
return mysql_select_db($dbname);
} function fetch_array($query, $result_type = MYSQL_ASSOC) {
return @mysql_fetch_array($query, $result_type);
} function query($sql, $type = '') {
// $sqlt="<script language=javascript>alert('非法ID 或 输入脚本有错误 KeBeKe.com 友情提醒');history.go(-1);</script>";
if(!($query = mysql_query($sql))) $this->show($sqlt, $sql);
return $query;
} function affected_rows() {
return mysql_affected_rows();
} function result($query, $row) {
return mysql_result($query, $row);
} function num_rows($query) {
return @mysql_num_rows($query);
} function num_fields($query) {
return mysql_num_fields($query);
} function free_result($query) {
return mysql_free_result($query);
} function insert_id() {
return mysql_insert_id();
} function fetch_row($query) {
return mysql_fetch_row($query);
} function version() {
return mysql_get_server_info();
} function close() {
return mysql_close();
} function show($message = '', $sql = '') {
if(!$sql) echo $message;
else echo $message.'<br>'.$sql;
}
}/*
*-------------
* 获取客户端IP
*-------------
*/
function get_ip() {
if (isset($_SERVER)) {
if (isset($_SERVER[HTTP_X_FORWARDED_FOR])) {
$realip = $_SERVER[HTTP_X_FORWARDED_FOR];
} elseif (isset($_SERVER[HTTP_CLIENT_IP])) {
$realip = $_SERVER[HTTP_CLIENT_IP];
} else {
$realip = $_SERVER[REMOTE_ADDR];
}
} else {
if (getenv("HTTP_X_FORWARDED_FOR")) {
$realip = getenv( "HTTP_X_FORWARDED_FOR");
} elseif (getenv("HTTP_CLIENT_IP")) {
$realip = getenv("HTTP_CLIENT_IP");
} else {
$realip = getenv("REMOTE_ADDR");
}
}
return $realip;
}/*
* ----------------
* 操作完成的提示页面 Alan
* ----------------
*/
function get_show($url,$cont){
header("Location:../msage.php?url=$url&cont=$cont");
return;
} function get_selected($type){
if($type==1){
$alan='selected';
}
return $alan;
}?>