论坛风格切换切换到宽版
  • 919阅读
  • 0回复

继续溜达!无事发呆! [复制链接]

上一主题 下一主题
 
只看楼主 倒序阅读 使用道具 楼主  发表于: 2009-03-04
建议开通WAP站点,去域名管理建立WAP子域。然后绑定网站跟目录下的/WAP目录,然后做如下代码编译! XVKfl3'%  
XVKfl3'%  
下为WAP跟目录,可设置名为/wap/index.php XVKfl3'%  
XVKfl3'%  
  1. <?php
  2. include_once './source/templet.php';
  3. include_once './common.php';
  4. login();
  5. ?>
XVKfl3'%  
XVKfl3'%  
下为WAP站点数据库调用链接代码,可设置名字为/wap/db.class.php XVKfl3'%  
XVKfl3'%  
  1. <?php
  2. /*
  3.     [UCenter] (C)2001-2009 Comsenz Inc.
  4.     This is NOT a freeware, use is subject to license terms
  5.     $Id: db.class.php 753 2008-11-14 06:48:25Z cnteacher $
  6. */
  7. /**
  8.     CREATE TABLE `sqlcache` (
  9.                 `sqlid` char(6) NOT NULL default '',
  10.                 `data` char(100) NOT NULL,
  11.                 `expiry` int(10) unsigned NOT NULL,
  12.                 PRIMARY KEY  (`sqlid`),
  13.                 KEY(expiry)
  14.                ) Type=MyISAM
  15. */
  16. class DBAccess {
  17.     
  18.     var $querynum = 0;
  19.     var $link;
  20.     var $histories;
  21.     var $dbhost="localhost";
  22.     var $dbuser="root";
  23.     var $dbpw="pw";
  24.     var $dbname="name";
  25.     var $pconnect=0;
  26.     var $tablepre;
  27.     var $time=0;
  28.     var $goneaway = 5;
  29.     
  30.     function __construct(){
  31.     
  32.         $this -> link = @mysql_connect ($this -> dbhost,$this -> dbuser, $this -> dbpw);    
  33.         
  34.         mysql_select_db($this -> dbname,$this->link);
  35.         
  36.         mysql_query("SET NAMES utf8");
  37.     
  38.     
  39.     }
  40.     function fetch_array($query, $result_type = MYSQL_ASSOC) {
  41.         return mysql_fetch_array($query, $result_type);
  42.     }
  43.     function result_first($sql) {
  44.         $query = $this->query($sql);
  45.         return $this->result($query, 0);
  46.     }
  47.     function fetch_first($sql) {
  48.         $query = $this->query($sql);
  49.         return $this->fetch_array($query);
  50.     }
  51.     function fetch_all($sql, $id = '') {
  52.         $arr = array();
  53.         $query = $this->query($sql);
  54.         while($data = $this->fetch_array($query)) {
  55.             $id ? $arr[$data[$id]] = $data : $arr[] = $data;
  56.         }
  57.         return $arr;
  58.     }
  59.     function cache_gc() {
  60.         $this->query("DELETE FROM {$this->tablepre}sqlcaches WHERE expiry<$this->time");
  61.     }
  62.     function query($sql, $type = '', $cachetime = FALSE) {
  63.         $func = $type == 'UNBUFFERED' && @function_exists('mysql_unbuffered_query') ? 'mysql_unbuffered_query' : 'mysql_query';
  64.         if(!($query = $func($sql, $this->link)) && $type != 'SILENT') {
  65.             $this->halt('MySQL Query Error', $sql);
  66.         }
  67.         $this->querynum++;
  68.         $this->histories[] = $sql;
  69.         return $query;
  70.     }
  71.     function affected_rows() {
  72.         return mysql_affected_rows($this->link);
  73.     }
  74.     function error() {
  75.         return (($this->link) ? mysql_error($this->link) : mysql_error());
  76.     }
  77.     function errno() {
  78.         return intval(($this->link) ? mysql_errno($this->link) : mysql_errno());
  79.     }
  80.     function result($query, $row) {
  81.         $query = @mysql_result($query, $row);
  82.         return $query;
  83.     }
  84.     function num_rows($query) {
  85.         $query = mysql_num_rows($query);
  86.         return $query;
  87.     }
  88.     function num_fields($query) {
  89.         return mysql_num_fields($query);
  90.     }
  91.     function free_result($query) {
  92.         return mysql_free_result($query);
  93.     }
  94.     function insert_id() {
  95.         return ($id = mysql_insert_id($this->link)) >= 0 ? $id : $this->result($this->query("SELECT last_insert_id()"), 0);
  96.     }
  97.     function fetch_row($query) {
  98.         $query = mysql_fetch_row($query);
  99.         return $query;
  100.     }
  101.     function fetch_fields($query) {
  102.         return mysql_fetch_field($query);
  103.     }
  104.     function version() {
  105.         return mysql_get_server_info($this->link);
  106.     }
  107.     function close() {
  108.         return mysql_close($this->link);
  109.     }
  110.     function halt($message = '', $sql = '') {
  111.         $error = mysql_error();
  112.         $errorno = mysql_errno();
  113.         if($errorno == 2006 && $this->goneaway-- > 0) {
  114.             $this->connect($this->dbhost, $this->dbuser, $this->dbpw, $this->dbname, $this->dbcharset, $this->pconnect, $this->tablepre, $this->time);
  115.             $this->query($sql);
  116.         } else {
  117.             $s = '<b>Error:</b>'.$error.'<br />';
  118.             $s .= '<b>Errno:</b>'.$errorno.'<br />';
  119.             $s .= '<b>SQL:</b>:'.$sql;
  120.             exit($s);
  121.         }
  122.     }
  123.     
  124.     function __destruct(){
  125.     
  126.     @mysql_close($this->link);
  127.     
  128.     }
  129. }
  130. ?>
XVKfl3'%  
XVKfl3'%  
上面代码中 XVKfl3'%  
  1. private $dbhost= 'localhost';//服务器地址
  2. private $dbuser= 'yonghuming';//用户
  3. private $dbpw= 'mima'; //密码
  4. private $dbname= 'shujuku';//数据库
XVKfl3'%  
按网站数据库自行修改! XVKfl3'%  
XVKfl3'%  
下为WAP站点名称配置文件: XVKfl3'%  
XVKfl3'%  
  1. <?php
  2. include_once 'db.class.php';
  3. //公共信息
  4. global $tabletitle,$uc,$db,$pagelines,$_username,$_title,$_address,$_abb;
  5. $tabletitle="uchome_";//表名前缀
  6. $uc="uc_";//ucenter表名前缀
  7. $_address="www.cnsky.cc";//uch访问网址
  8. $_abb="中国天空-移动空间";//网站名称
  9. $pagelines=5;//每次分页显示条数
  10. $db=new DBAccess();
  11. ?>
XVKfl3'%  
XVKfl3'%  
剩下的就你自己写吧,直接调用就可了!要么等晚点我有时间在来写!待续! XVKfl3'%  
记得评分! XVKfl3'%  
XVKfl3'%  
注意:这个是WAP站格式,使用正常浏览器无法打开显示,只有使用手机中的浏览器使用GPRS网络才可访问!
快速回复
限100 字节
如果您提交过一次失败了,可以用”恢复数据”来恢复帖子内容
 
上一个 下一个