php 类的写法

php 类的写法//Db.class.php
class Db {
    private $_dblink;
    public $result;
    public function __construct($host, $user, $password, $dbname, $charset = 'utf8') {
        try{
            if($this->_dblink = mysql_connect($host, $user, $password)) {
                if(mysql_select_db($dbname)) {
                    $this->query("SET NAMES " . $charset . " ;");
                } else {
                    throw new Exception(mysql_error());
                }
            } else {
                throw new Exception(mysql_error());
            }
        } catch (Exception $e) {
            die($e->getMessage());
        }
    }

    public function query($sql) {
        return $this->result = mysql_query($sql);
    }

    public function fetch() {
        return mysql_fetch_array($this->result);
    }

    public function fetchAll() {
        $rs = array();
        $rsAll = array();
        while($rs = mysql_fetch_array($this->result)) {
            $rsAll[] = $rs;
        }
        return $rsAll;
    }

    public function __destruct() {
        mysql_close($this->_dblink);
    }
}

复制PHP内容到剪贴板PHP代码:
//test.php
$db = new Db('localhost', 'root', '', 'hent_qxoa');
$db->query("SELECT * FROM qx_user ;");
var_dump($db->fetchAll());

 

php 广告点击统计代码,昨天晚上有几个IDC网想与本站合作放些广告,但是我想看看广告效果后想了就写了一个简单的广告统计代码了,这里只是等的统计不能IP限制或是恶心点击等等了.

先来创建数据库.

CREATE TABLE IF NOT EXISTS `ad_count` (
  `ad_id` int(8) NOT NULL auto_increment,
  `ad_hit` int(8) NOT NULL default '0',
  `ad_name` varchar(200) character set gb2312 default NULL,
  `ad_datetime` datetime default NULL,
  `ad_qq` varchar(15) character set gb2312 default NULL,
  `ad_url` varchar(900) character set gb2312 NOT NULL,
  `ad_price` int(8) NOT NULL,
  PRIMARY KEY  (`ad_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

数据创建好了我们就开始写程序了.数据连接我不不写了,

<?php
 require_once("......省了");
 $ad_id =get_value('ad_id','');这里下面有讲
 if(is_numeric( $ad_id ) ){
 
   $ad_select="select ad_id,ad_url from ad_count where ad_id='$ad_id' limit 1";
   
   $ad_update="Update ad_count set  ad_hit=ad_hit+1 where ad_id='$ad_id' limit 1";
   
   $ad_result=mysql_query($ad_select) or die('id error');
   
     if( mysql_num_rows( $ad_result) ){
     
       mysql_query($ad_update);
       
       $ad_rs=mysql_fetch_array($ad_result);
       
       header("location:".$ad_rs['ad_url']);
       
       mysql_free_result($ad_rs);
              
     }
 }

function htmltohtml($Str){
  $temp =str_replace(chr(13),'<br/>',$Str);
  $temp =str_replace('<','&lt;',$Str);
  $temp =str_replace('>','&gt;',$Str);
  $temp =addslashes($Str);
  return $temp;
 }
 function get_value($value,$para){ 
  return htmltohtml(empty($para)?(isset($_GET[$value])?$_GET[$value]:''):(isset($_POST[$value])?$_POST[$value]:''));
 }

然后我们再在要显示广告的地方如下写.

'<a href=/cp/ad_count.php?ad_id=2 target=_blank><img src=/ad_a/ad2.gif border=0 /></a>

就完了了,本站原创,转载请注明来原:  www.111cn.net
?>

<%
dim email
email=request.form("email")
if IsValidEmail(email) then
  if request("action")="退订" then
    response.redirect "del_email.asp?email="&email
  else
    response.redirect "add_email.asp?email="&email
  end if
else
  'response.write "无效的电子邮件格式，请按“后退”按钮，重填一个有效的Email"
  response.write"<SCRIPT language=JavaScript>alert('无效的电子邮件格式，请重填一个有效的Email！');"
  response.write"javascript:history.go(-1)</SCRIPT>"
end if

function IsValidEmail(email)
 dim names, name, i, c
 'Check for valid syntax in an email address.
 IsValidEmail = true
 names = Split(email, "@")
 if UBound(names) <> 1 then
   IsValidEmail = false
   exit function
 end if
 for each name in names
   if Len(name) <= 0 then
     IsValidEmail = false
     exit function
   end if
   for i = 1 to Len(name)
     c = Lcase(Mid(name, i, 1))
     if InStr("abcdefghijklmnopqrstuvwxyz_-.", c) <= 0 and not IsNumeric(c) then
       IsValidEmail = false
       exit function
     end if
   next
   if Left(name, 1) = "." or Right(name, 1) = "." then
      IsValidEmail = false
      exit function
   end if
 next
 if InStr(names(1), ".") <= 0 then
   IsValidEmail = false
   exit function
 end if
 i = Len(names(1)) - InStrRev(names(1), ".")
 if i <> 2 and i <> 3 then
   IsValidEmail = false
   exit function
 end if
 if InStr(email, "..") > 0 then
   IsValidEmail = false
 end if
end function
%>

模板 template.html :
复制PHP内容到剪贴板
PHP代码:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><%{title}%></title>
</head>
<body>
<%{content}%>
</body>
</html>

生成 generator.php :
复制PHP内容到剪贴板
PHP代码:

<?php
/*
** html静态页面生成模块
*/
$title = "cShare.ORG首页";
$content = "红绿蓝(cShare.ORG),开源软件及自由软件社区.专注于开源软件及自由软件领域,竭力推进中国开源软件及自由软件发展.为软件开发者提供开发平台,为用户带来优秀软件...";
$template = file_get_contents("template.html");  //读取模板
$template = str_replace("<%{title}%>", $title, $template);  //替换标记
$template = str_replace("<%{content}%>", $content, $template);
while(!file_exists("number.txt")) {  //如不存在编号文件,则创建一个并写入初始编号0
 file_put_contents("number.txt",0);
}
$html_number = file_get_contents("number.txt");
$html_number++;
file_put_contents("number.txt",$html_number);
$html_name = "{$html_number}.html";
file_put_contents($html_name, $template);  //生成静态页面
?>

<?php
$hostname = 'localhost';
$dbname = 'test';
$username = 'root';
$pw = 'vivian';
$sqlfile = 'gb.sql';
$sql = file_get_contents($sqlfile);
echo($dbname);
echo($sql);
$conn = mysql_connect($hostname,$username,$pw) or die("无法连接数据库");
mysql_select_db($dbname,$conn) or die("无法连接到数据库");
mysql_query($sql) or die(mysql_error());
?>

sql直接在数据库执行的时候是没有问题的，但是如果是使用php文件执行的话，需要去掉第一行的drop 语句。
sql执行的时候test数据库是空的，并没有gb_comments.

请问这个问题是怎么形成的啊？