安装时数据库出现的有关问题

安装时数据库出现的问题

/*----------------------------------------------------
[dzsw] includes/db_mysql.php

----------------------------------------------------*/

$tables = array('admins','admingroups','area','usergroups','settings','styles','specials','shipping','shipping_fee','templates','classes','manufacturers','products','reviews','orders','orders_total','orders_products','orders_history','payment','payment_a','customers','address_book','news','gbook','gbook_class','links','source','ptoc');
foreach($tables as $tablename) {
${'table_'.$tablename} = $table_pre.$tablename;
}
unset($tablename);

Class DB {
var $query_num = 0;
var $dbhost = '';
var $dbname = '';
var $multipage = '';

function DB($dbhost, $dbuser, $dbpw, $dbname, $pconnect = 0 ) {
$this->dbhost = $dbhost;
$this->dbname = $dbname;
$this->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect );
}

function __get($name){
return $this->$name;
}

function __set($name, $value){
$this->$name = $value;
}

function connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect) {
if($pconnect) {
if([email protected]_pconnect($dbhost, $dbuser, $dbpw)) {
$this->halt('Unable to connect the MySQL server.');
}
}else {
if([email protected]_connect($dbhost, $dbuser, $dbpw)) {
$this->halt('Unable to connect the MySQL server.');
}
}

$this->charset_db();

if($this->version() > '5.0') {
mysql_query("SET sql_mode=''");
}
if($dbname){
mysql_select_db($dbname);
}
}

function charset_db() {
global $charset;
$charset = "gbk";mysql_query("SET NAMES gbk");
/*
* if($this->version() * return true;
* }
* if(defined('CHARSET_DB') && CHARSET_DB == '' && in_array(strtolower($charset), array('gb2312', 'gbk', 'big5', 'utf-8'))) {
* $dbcharset = str_replace('-', '', $charset);
* }else{
* $dbcharset = CHARSET_DB;
* }
* if($dbcharset) {
* //mysql_query("SET character_set_results = NULL");
*
* }
*/
}

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, $method = '') {

if($method=='ub' && @function_exists('mysql_unbuffered_query')){
$query = mysql_unbuffered_query($sql);
}else{
if(!($query = mysql_query($sql)) && $method != 'noshow') {
$this->halt('MySQL Query Error', $sql);
}
}

$this->querynum++;
return $query;
}

function get_one($sql)
{
$query = $this->query($sql);
$result =& mysql_fetch_array($query, MYSQL_ASSOC);
return $result;
}

function perform($table, $data, $action = 'insert', $parameters = '')
{
reset($data);
if ($action == 'insert' || $action == 'replace' )
{
$space=$query_1=$query_2='';
foreach($data as $key=>$val)
{
$query_1.=$space.$key;
$query_2.=$space.'\''.$val.'\'';
$space=', ';
}
$query = $action.' into ' . $table . ' ('.$query_1.') values ('.$query_2.')';
return $this->query($query);
}
elseif ($action == 'update')
{
$query = 'update ' . $table . ' set ';
$space='';
foreach($data as $key=>$val)
{
$query .= $space.$key . '= \'' . $val. '\'';
$space=', ';
}
$query .=' where ' . $parameters.' ';
return $this->query($query,'ub');
}
}

/*
$sql_array = array(
'page' => 'page',
'num' => 'num',
'link' => 'link',

'sql_count' => 'COUNT(*) as count',
'sql_select' => '*',
'sql_from' => 'from',
'sql_where' => '',
'sql_pam' => '',
);
*/
function query_list($sql_array){
$page = $sql_array['page'] ? $sql_array['page'] : '1';
$startlimit = ($page - 1) * $sql_array['num'];

$sql_array['sql_where'] = $sql_array['sql_where'] != '' ? " where ".$sql_array['sql_where'] : '';

$query = $this->query("SELECT COUNT(*) as count FROM ".$sql_array['sql_from']." ".$sql_array['sql_where']." ".$sql_array['sql_pam']['group_by']);
$query_count = $this->num_rows($query);

$this->multipage = s_multi($query_count, $sql_array['num'], $page, $sql_array['link']);

$sql_array['sql_select'] = $sql_array['sql_select'] ? $sql_array['sql_select'] : '*';
$sql_strings = "SELECT ".$sql_array['sql_select']." FROM ".$sql_array['sql_from']." ".$sql_array['sql_where']." ".$sql_array['sql_pam']['group_by']." ".$sql_array['sql_pam']['order_by'];

$sql_strings .= " LIMIT $startlimit, ".$sql_array['num'];

$query = $this->query($sql_strings);
$query_list = array();
while($query_data = $this->fetch_array($query)){
$query_list[] = $query_data;
}
return $query_list;
}

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();
}

function version()
{
return mysql_get_server_info();
}

function halt($message = '', $sql = '')
{
include DIR_dzsw.'includes/db_mysql_error.php';
}
}

?>


这是安装时的提示



Time： 2015-1-18 15:17:37

Script: /dzsw/

SQL: select orders_id from dzsw_orders where date_purchased
Error: Table 'dzsw_web.dzsw_orders' doesn't exist

Errno: 1146

各位帮忙看看，谢谢
------解决思路----------------------
Error: Table 'dzsw_web.dzsw_orders' doesn't exist
表 dzsw_web.dzsw_orders不存在
------解决思路----------------------
先看看你的 dzsw_web 是否有建表权限

再看看你的 SQL 文件里是否制定了库名，如果指定了，则改成你的库名
如果是这样的话，你的这个项目毛病一定是很多的
------解决思路----------------------
你直接在数据库管理工具中创建一下，如果还是提示表不存在的话，那我就不知道为什么了。
------解决思路----------------------
建议创建表的时候先加一句，drop table if exists

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系[e-mail]核实处理。

相关文章

相关视频

---

• 关于中英数字混的字串符分割问题_PHP教程
• PHP＋TEXT留言本(三)_PHP教程
• 应用PHP标签模板实现什么任务_PHP教程
• php入门教程 精简版_PHP教程
• 安装时数据库出现的有关问题

• jquery 的安装
• jQuery 第一个jquery程序
• jQuery juery与原生js 的区别
• jQuery 对象与 DOM 对象之间的转换
• jQuery 基础选择器(一)