楼主把你的那个db_mysql.php贴出来,不然的话,没办法看出什么问题
解决方案 »
- 数据显示Resource id #4
- 我想学PHP,但是不知道如何下手,请高手指导!多谢
- 请问使用正则匹配后,如何保留换行?
- AJAX中文乱码PHP完美解决(IE和Firefox兼容)
- 急!!!!PHP+mysql 2级联动下拉
- 谁知道这个技术??adodb+smarty+myClass 结合-数据类的智能操作
- 有个北京的工作机会,对PHP+MySQL感兴趣的来看下吧
- 我想问怎样才能让页面显示记录时,显示交替的背景颜色呢
- 超难问题
- 怎样弹出没有菜单,工具栏,地址栏的IE 窗口!!!
- 请问,用perl编写cgi,在一个表单中实现文件上传和复选择列表的方法?
- 请问,如何利用PERL将生成的表格以excel图表的形式嵌套在浏览器中显示.
所以在
require "db_mysql.php";
之前应该
define('IN_DISCUZ', TRUE);
变成:<?php
define('IN_DISCUZ', TRUE);
require "db_mysql.php";
$db = new db;
$fdb = new db;
$chcdb="acc";
$fdb->connect($dbhost, $dbuser, $dbpw, $chcdb, $pconnect);
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$fs=$fdb->query("SELECT name,key FROM user where FUserName='acc'");
$info = $fdb->fetch_array($fs);
$query=$db->query("SELECT username,id FROM member WHERE username = 'acc'");
$member = $db->fetch_array($query);
echo $info[name]."<br>";
echo $member['id'];
?>
if(!defined('IN_DISCUZ')) {
exit('Access Denied');
}
if(!defined('IN_DISCUZ')) {
exit('Access Denied');
}
下面是内容:
class dbstuff {
var $querynum = 0; function connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect = 0) {
if($pconnect) {
if(!@mysql_pconnect($dbhost, $dbuser, $dbpw)) {
exit('Can not connect to MySQL server');
}
} else {
if(!@mysql_connect($dbhost, $dbuser, $dbpw)) {
exit('Can not connect to MySQL server');
}
} mysql_select_db($dbname);
} 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, $silence = 0) {
$query = mysql_query($sql);
if(!$query && !$silence) {
$this->halt('MySQL Query Error', $sql);
}
$this->querynum++;
return $query;
}
function query_first($query_string) {
$query_id = $this->query($query_string);
$returnarray=$this->fetch_array($query_id);
$this->free_result($query_id);
return $returnarray;
}
function unbuffered_query($sql, $silence = 0) {
$func_unbuffered_query = @function_exists('mysql_unbuffered_query') ? 'mysql_unbuffered_query' : 'mysql_query';
$query = $func_unbuffered_query($sql);
if(!$query && !$silence) {
$this->halt('MySQL Query Error', $sql);
}
$this->querynum++;
return $query;
} function affected_rows() {
return mysql_affected_rows();
} function error() {
return mysql_error();
} function errno() {
return mysql_errno();
} function result($query, $row) {
$query = @mysql_result($query, $row);
return $query;
} function num_rows($query) {
$query = mysql_num_rows($query);
return $query;
} function num_fields($query) {
return mysql_num_fields($query);
} function free_result($query) {
return mysql_free_result($query);
} function insert_id() {
$id = mysql_insert_id();
return $id;
} function fetch_row($query) {
$query = mysql_fetch_row($query);
return $query;
} function close() {
return mysql_close();
}
}
$db = new db;
$fdb = new db;
是对的,,因为我已经把类改名为db了,
你的代码不全。
数据库相关变量定义没有贴出,如果为远程连接MYSQL请查看是否有权限
$dbuser = 'acc';
$dbpw = '*********';
$dbname = 'test';
$pconnect = 1;
我已经试过了,一样的.
帐号测试可以连接,acc和root有一样的权限的,,可以对所有数据库操作.
require "db_mysql.php";
$db = new db;
$fdb = new db;
$chcdb="acc";
$db->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
$query=$db->query("SELECT username,id FROM member WHERE username = 'acc'");
$member = $db->fetch_array($query);
echo $member['id'];