# MySQL-Front 3.2 (Build 6.2)/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET 'gbk' */;# Host: 127.0.0.1 Database: subcode
# ------------------------------------------------------
# Server version 5.0.27-community-nt-log#
# Table structure for table soft_type
#DROP TABLE IF EXISTS `soft_type`;
CREATE TABLE `soft_type` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL,
`type` char(200) NOT NULL,
`EnglishType` varchar(255) default NULL,
`roue_id` varchar(255) NOT NULL,
`roue_char` mediumtext NOT NULL,
`orderID` bigint(11) default NULL,
`Levels` int(4) default '1' COMMENT '层次',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=gbk;#
# Dumping data for table soft_type
#INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (1,0,'中国','China','0:1','中国',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (2,0,'英国','English','0:2','英国',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (3,0,'美国','United','0:3','美国',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (5,0,'中文类别','英文类别','0:5','中文类别',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (6,2,'伦敦','London','0:2:6','英国:伦敦',3,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (7,2,'泰吾士','TWS','0:2:7','英国:泰吾士',1,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (8,7,'泰吾士子','TWs-sub','0:2:7:8','英国:泰吾士:泰吾士子',1,3);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (9,0,'加拿大','Canada','0:9','加拿大',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (10,0,'中文类别','China Code','0:10','中文类别',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (11,2,'伯明翰','Birmingham','0:2:11','英国:伯明翰',4,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (12,2,'曼彻斯特','Manchester ','0:2:12','英国:曼彻斯特',2,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (13,2,'英国11','11','0:2:13','英国:英国11',5,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (14,3,'纽约','','0:3:14','美国:纽约',1,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (15,3,'华盛顿','','0:3:15','美国:华盛顿',2,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (16,3,'美国city','','0:3:16','美国:美国city',3,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (17,16,'美国citySub','','0:3:16:17','美国:美国city:美国citySub',1,3);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (18,17,'美国citySub sub','','0:3:16:17:18','美国:美国city:美国citySub:美国citySub sub',1,4);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (19,8,'泰吾士子 sub','','0:2:7:8:19','英国:泰吾士:泰吾士子:泰吾士子 sub',1,4);/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET CHARACTER SET 'gbk' */;# Host: 127.0.0.1 Database: subcode
# ------------------------------------------------------
# Server version 5.0.27-community-nt-log#
# Table structure for table soft_type
#DROP TABLE IF EXISTS `soft_type`;
CREATE TABLE `soft_type` (
`id` int(11) NOT NULL auto_increment,
`uid` int(11) NOT NULL,
`type` char(200) NOT NULL,
`EnglishType` varchar(255) default NULL,
`roue_id` varchar(255) NOT NULL,
`roue_char` mediumtext NOT NULL,
`orderID` bigint(11) default NULL,
`Levels` int(4) default '1' COMMENT '层次',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=gbk;#
# Dumping data for table soft_type
#INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (1,0,'中国','China','0:1','中国',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (2,0,'英国','English','0:2','英国',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (3,0,'美国','United','0:3','美国',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (5,0,'中文类别','英文类别','0:5','中文类别',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (6,2,'伦敦','London','0:2:6','英国:伦敦',3,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (7,2,'泰吾士','TWS','0:2:7','英国:泰吾士',1,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (8,7,'泰吾士子','TWs-sub','0:2:7:8','英国:泰吾士:泰吾士子',1,3);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (9,0,'加拿大','Canada','0:9','加拿大',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (10,0,'中文类别','China Code','0:10','中文类别',1,1);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (11,2,'伯明翰','Birmingham','0:2:11','英国:伯明翰',4,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (12,2,'曼彻斯特','Manchester ','0:2:12','英国:曼彻斯特',2,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (13,2,'英国11','11','0:2:13','英国:英国11',5,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (14,3,'纽约','','0:3:14','美国:纽约',1,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (15,3,'华盛顿','','0:3:15','美国:华盛顿',2,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (16,3,'美国city','','0:3:16','美国:美国city',3,2);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (17,16,'美国citySub','','0:3:16:17','美国:美国city:美国citySub',1,3);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (18,17,'美国citySub sub','','0:3:16:17:18','美国:美国city:美国citySub:美国citySub sub',1,4);
INSERT INTO `soft_type` (`id`,`uid`,`type`,`EnglishType`,`roue_id`,`roue_char`,`orderID`,`Levels`) VALUES (19,8,'泰吾士子 sub','','0:2:7:8:19','英国:泰吾士:泰吾士子:泰吾士子 sub',1,4);/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
{
global $host,$user,$pass,$database;
$conn=@mysql_connect( $host, $user, $pass) or die("连接失败!".mysql_error());
@mysql_select_db($database,$conn) or die("数据库加载指失败!");
//@mysql_query("set names gbk");
@mysql_query("SET CHARACTER SET gbk") or die("字符集设置失败");
$result = @mysql_query($query) or die("查询失败!".mysql_error()) ;
@mysql_close($conn);
return $result;
}
*/class dbClass{ //开始数据库类
var $username;
var $password;
var $database;
var $hostname;
var $link;
var $result;
/* function dbClass($username,$password,$database,$hostname="localhost"){
$this->username=$username;
$this->password=$password;
$this->database=$database;
$this->hostname=$hostname;
}
*/
function connect(){ //这个函数用于连接数据库
if (!$this->link)
{
//数据源
$this->link=mysql_connect(db_hostname,db_username,db_password) or die("无法链接Mysql");
mysql_select_db(db_database) or die ("数据库载入失败!");
}
//if(!$this->link=mysql_connect($this->hostname,$this->username,$this->password))
//$this->halt("Sorry,can not connect to database");
if($this->version() > '4.1') {
global $dbcharset,$charset;
if(!$dbcharset && in_array(strtolower($charset), array('gbk', 'big5', 'utf-8'))) {
$dbcharset = str_replace('-', '', $charset);
}
//echo $dbcharset;
if($dbcharset) {
$dbcharset='gbk';//暂时加上
//echo $dbcharset;
mysql_query("SET character_set_connection=$dbcharset, character_set_results=$dbcharset, character_set_client=binary");
}
}
if($this->version() > '5.0.1') {
mysql_query("SET sql_mode=''");
} return $this->link;
//echo $this->link;
}
/*
function select(){ //这个函数用于选择数据库
mysql_select_db($this->database,$this->link) ;
}
*/
function Rsquery($sql){ //这个函数用于送出查询语句并返回结果,常用。
if($this->result=mysql_query($sql,$this->link)) return $this->result;
else {
echo $this->halt("SQL语句错误: <font color=red>$sql</font><br><br>错误信息: ".mysql_error());
return false;
}
} /*
以下函数用于从结果取回数组,一般与 while()
循环、$db->Rsquery($sql) 配合使用,例如:
$result=Rsquery("select * from mytable");
while($row=$db->getarray($result)){
echo "$row[id] ";
}
*/
function getarray($result){
return @mysql_fetch_array($result);
} /*
以下函数用于取得SQL查询的第一行,一般用于查询符合条件的行是否存在,例如:
用户从表单提交的用户名$username、密码$password是否在用户表“user”中,并返回其相应的数组:
if($user=$db->getfirst("select * from user where username='$username' and password='$password' "))
echo "欢迎 $username ,您的ID是 $user[id] 。";
else
echo "用户名或密码错误!";
*/
function getfirst($sql){
return @mysql_fetch_array($this->Rsquery($sql));
} /*
以下函数返回符合查询条件的总行数,例如用于分页的计算等要用到,例如:
$totlerows=$db->getcount("select * from mytable");
echo "共有 $totlerows 条信息。";
*/
function getcount($sql){
return @mysql_num_rows($this->Rsquery($sql));
} /*
以下函数用于更新数据库,例如用户更改密码:
$db->update("update user set password='$new_password' where userid='$userid' ");
*/
function update($sql){
return $this->Rsquery($sql);
$this->close();
}
//用于SELECT 的查询
function selectdb($query)
{ // $result = mysql_query("SELECT id, name FROM mytable");
$result = mysql_query($query,$this->link) or die("查询失败!".mysql_error()) ;
while ($row = mysql_fetch_array($result,MYSQL_BOTH)) {
// printf ("ID: %s Name: %s", $row[0], $row["userName"]);
$output[] = $row;
}
@mysql_free_result($result);
$this->close;
return $output;
}
//删除数据
/*
以下函数用于向数据库插入一行,例如添加一个用户:
$db->insert("insert into user (userid,username,password) values (null,'$username','$password')");
*/
function insert($sql){
return $this->Rsquery($sql);
$this->close();
} function getid(){ //这个函数用于取得刚插入行的id
return mysql_insert_id();
} function num_rows($query) {//返回结果集中行的数目
$query = mysql_num_rows($query);
return $query;
}
//记录增加的条数
function affected_rows($sql) {//得到 MySQL 最后操作影响的列数
//insert 或Update 函数
// if($type==1){
$query = mysql_affected_rows($sql);
// }else{
// $query = mysql_affected_rows($this->update($sql));
// }
return $query;
}
function num_fields($query) {//取得结果集中字段的数目
return mysql_num_fields($query);
}
function free_result($query) {
return mysql_free_result($query);
}
function version() {
return mysql_get_server_info();
} function close() {
return mysql_close();
} function halt($message = '') {
return $message;
}
/*
public function __destruct(){
return mysql_close();
}
*/}
/*$db=new dbClass("$db_username","$db_password","$db_database","$db_hostname");
$db->connect();
$db->select();
$db=new dbClass(db_username,db_password,db_database,db_hostname);
*/$db=new dbClass();
$db->connect();
?>