/**
* 字符串截取函數(shù) 自動(dòng)清除網(wǎng)頁(yè)標(biāo)簽
**/
Function str_cut($string, $length = 80, $etc = '...', $code = 'UTF-8')
{
$string = strip_tags(preg_replace('!\s+!', $string, ' '));
if ($length == 0)
return '';
if ($code == 'UTF-8') {
$pa = "/[\x01-\x7f]|[\xc2-\xdf][\x80-\xbf]|\xe0[\xa0-\xbf][\x80-\xbf]|[\xe1-\xef][\x80-\xbf][\x80-\xbf]|\xf0[\x90-\xbf][\x80-\xbf][\x80-\xbf]|[\xf1-\xf7][\x80-\xbf][\x80-\xbf][\x80-\xbf]/";
}
else {
$pa = "/[\x01-\x7f]|[\xa1-\xff][\xa1-\xff]/";
}
preg_match_all($pa, $string, $t_string);
if (count($t_string[0]) > $length)
return join('', array_slice($t_string[0], 0, $length)) . $etc;
return join('', array_slice($t_string[0], 0, $length));
}
中山php|最優(yōu)網(wǎng)絡(luò) :中山做網(wǎng)站 中山php建站
最優(yōu)良人
php字符串截取函數(shù),自動(dòng)清除網(wǎng)頁(yè)標(biāo)簽
在線(xiàn)客服代碼,qq,msn,skype,淘寶旺旺,阿里巴巴貿(mào)易通,雅虎通
1.QQ在線(xiàn)咨詢(xún)代碼
(qq在線(xiàn)交談代碼/qq在線(xiàn)客服代碼/qq在線(xiàn)狀態(tài)代碼/qq在線(xiàn)客服代碼)
(將66757924換成你的號(hào)碼,site后面換成你的網(wǎng)站就可以了)
<a target="blank" href="http://wpa.qq.com/msgrd?V=1&Uin=66757924&Site=服務(wù)易& Menu=yes"><img border="0" SRC=http://wpa.qq.com/pa?p=1:66757924:6 alt="點(diǎn)擊這里給我發(fā)消息" align="absmiddle"></a>
2.MSN在線(xiàn)咨詢(xún)代碼
用的時(shí)候把[郵件地址]寫(xiě)成你的MSN賬號(hào),不要方括號(hào),用鏈接即可,如
<a target="blank" href="msnim:chat?contact=sliang@zui88.com">MSN在線(xiàn)客服</a>
3.skype在線(xiàn)狀態(tài)代碼生成
將yisung換成你的skype ID就可以了,需要在skype個(gè)人賬戶(hù)里設(shè)置對(duì)任何人顯示狀態(tài)
<a target="blank" href="skype:mengsajewel?call"><img src=http://mystatus.skype.com/smallclassic/yisung style="border: none;" alt="Call me!" /></a>
更多的skype在線(xiàn)狀態(tài)代碼生成樣式,請(qǐng)查看skype的官方網(wǎng)站
http://www.skype.com/share/buttons/
4.淘寶旺旺
<a target="_blank" ><img border="0" src="http://amos1.taobao.com/online.ww?v=你的旺旺名=1" alt="點(diǎn)擊這里發(fā)taobao旺旺消息" /></a>
5.阿里貿(mào)易通
chqllm改成你的ID就行了,還有ALT改成你的內(nèi)容
<a target=_blank ><img border=0 src="http://scs1.sh1.china.alibaba.com/online.atc?v=1&uid=chqllm&s=2" alt="最優(yōu)工作室" align="absmiddle"></a>
6.雅虎通
<a target=_blank href=http://edit.yahoo.com/config/send_webmesg?.target=你的雅虎通號(hào)碼& amp;.src=pg><img border=0 align=absmiddle src=http://opi.yahoo.com/online?u=你的雅虎通號(hào)碼&m=g&t=2 alt=雅虎通在線(xiàn)狀態(tài) title=給我發(fā)送雅虎通消息></a>
php清空某個(gè)目錄的方法
以下代碼可以清空多層的目錄結(jié)構(gòu):
function del_dir($dir){
{
if (!$dir) { return ; }
$cacheDir = $dir;
$dh = opendir($cacheDir);
while ( $file = readdir($dh) ) {
if (($file == '.') || ($file == '..')) { continue; }
if (file_exists( $cacheDir .'/'.$file)) {
if(is_dir( $cacheDir .'/'.$file)){
del_dir($cacheDir .'/'.$file);
}elseif (!unlink($cacheDir .'/'. $file)) {
//刪除完操作
}
}
}
}
}
phpmyadmin導(dǎo)出的sql如何通過(guò)php導(dǎo)入
以下函數(shù)可以直接把從phpmyadmin導(dǎo)出的sql文件直接通過(guò)php插入數(shù)據(jù)庫(kù):
//$file表示通過(guò)讀取sql文件返回的字符串,比如$file2=file_get_contents('db.sql');
function import($file2){
$Db = new Db();
$file2=explode("\n",$file2);//將文件內(nèi)容按行讀入到數(shù)組
$c1=count($file2);
for($j=0;$j<$c1;$j++)
{
$ck=substr($file2[$j],0,4);//取每行的前4個(gè)字符
if( ereg("#",$ck)||ereg("--",$ck) )//去掉注釋
{
continue;
}
$arr[]=$file2[$j];//將去掉注釋的文件內(nèi)容按行讀入數(shù)組$arr,數(shù)組每個(gè)元素對(duì)應(yīng)一行
}
$read=implode("\n",$arr); //重新組織文件內(nèi)容到一個(gè)字符串,(按照原來(lái)分好的一行一行的)
$sql=str_replace("\r",'',$read);//去掉"\r(回車(chē)符)"
$detail=explode(";\n",$sql);
//將經(jīng)上述整理過(guò)的文件內(nèi)容再次按一條完整的sql語(yǔ)句(以;和\n分隔)導(dǎo)入到數(shù)組$detail,
//此時(shí)數(shù)組detail的每個(gè)元素對(duì)應(yīng)一條完整的sql語(yǔ)句
$count=count($detail);
for($i=0;$i<$count;$i++)
{
$sql=str_replace("\r",'',$detail[$i]);//去掉每行sql中的回車(chē)符
$sql=str_replace("\n",'',$sql);//去掉換行符
$sql=trim($sql);//去掉前后空格
//現(xiàn)在的$sql
$Db->query($sql);
}
}
php date函數(shù)的時(shí)區(qū)問(wèn)題,輸出時(shí)間有誤
問(wèn)題:echo date('o-m-j H:i'); 輸出結(jié)果與本地時(shí)間相差8小時(shí)。
原因:時(shí)區(qū)未正確設(shè)置。
兩種解決方法:
1.加入date_default_timezone_set('Asia/Shanghai');
2. 修改php.ini
[Date]
; Defines the default timezone used by the date functions
date.timezone = PRC 注:PRC為中化人民共和國(guó)
php使用mail函數(shù)發(fā)送郵件,解決亂碼問(wèn)題
$to = 'sales@zui88.com';
$subject = "=?UTF-8?B?".base64_encode('網(wǎng)站收到一個(gè)新信息')."?=";
$message = "
用戶(hù)姓名:{$_POST['name']}\n
用戶(hù)郵箱:{$_POST['email']}\n
用戶(hù)電話(huà):{$_POST['contact']}\n
留言?xún)?nèi)容:{$_POST['content']}
";
$headers = 'From: webmaster@zui88.com' . "\r\n" .
'Reply-To: webmaster@zui88.com' . "\r\n" .
'X-Mailer: PHP/' . phpversion();
$headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";
mail($to, $subject, $message, $headers);
移植方便的php數(shù)據(jù)庫(kù)操作類(lèi),建表增刪改查
<?php
/**
*
* 數(shù)據(jù)操作類(lèi)
* @author Xiaoqiang
* @link //
* @copyright Xiaoqiang
* @version Svn $Id$
* @package
*/
class Db {
var $links;
// 構(gòu)造函數(shù),初始化數(shù)據(jù)庫(kù)(主機(jī),用戶(hù)名,密碼,數(shù)據(jù)庫(kù)名)
function __construct() {
$this->links = mysql_connect(DB_HOST, DB_USER, DB_PWD);
if(DEBUG){
mysql_select_db(DB_NAME) or die('ERROR:'.mysql_error());
}
else{
mysql_select_db(DB_NAME);
}
$char_sql = "SET NAMES '" . CHARSET . "'";
$this->query($char_sql);
}
/**
* ****************** 操作 ******************
*/
/**
* 增刪改查操作方法
* 輸入sql語(yǔ)句
* 返回布爾值或結(jié)果集$row
*/
function query($sql) {
if(DEBUG){
$render = mysql_query($sql) or die('query ERROR:'.mysql_error()."<br>sql語(yǔ)句出錯(cuò):" . $sql);
return $render;
}
else{
return mysql_query($sql);
}
}
/**
* 計(jì)算行數(shù)方法
* 輸入
* 結(jié)果數(shù)組
*/
function count($table,$condition='1') {
$sql = "select count(*) from `".DB_PREFIX.$table."` where $condition";
$result = $this->select($sql);
return $result[0]['count(*)'];
}
/**
* 原始的sql語(yǔ)句查操作方法
* 輸入sql語(yǔ)句
* 結(jié)果數(shù)組
*/
function select($sql) {
$row = $this->query($sql);
$results = array();
while($arr = $this->fetch($row)){
$results[] = $arr;
}
//$this->free_result($row);
return $results;
}
/**
* 檢查某字段是否存在某值
* @param 輸入表名.字段,值
* @return id 或者 false
**/
function check_exists($table,$val){
$render = false;
$tab = explode('.',$table);
if($tab['1'] && $tab['1']!='id'){
$fields = $tab['1'];
$table = "{$tab[0]}.id,{$fields}";
}
else{
$fields = 'id';
$table = $tab[0].".id";
}
$condition = "`$fields` = '{$val}'";
$detail = $this->read($table,$condition);
if($detail[$fields]){
$render = $detail['id'];
}
return $render;
}
/**
* 查詢(xún)多條數(shù)據(jù)方法
* 輸入表名.字段,字段;查詢(xún)條件,條數(shù)
* 如果條件是數(shù)組,則進(jìn)入高級(jí)搜索模式
* 返回結(jié)果數(shù)組
*/
function readall($table,$condition='1',$limit='') {
$tab = explode('.',$table);
$table = $tab['0'];
if($tab['1']){
$fields = $tab['1'];
$fields_array =explode(',',$fields);
$fields = '';
foreach( $fields_array as $one){
$fields .= "`$one`,";
}
$fields = rtrim($fields,',');
}
else{
$fields = '*';
}
if(is_array($condition)){
$condition = $this->parse_condition($condition);
}
$sql = "select $fields from `".DB_PREFIX.$table."` where $condition";
if($limit)$sql .= " limit $limit";
return $this->select($sql);
}
/**
* 查詢(xún)單條數(shù)據(jù)方法
* 輸入表名.字段,字段;查詢(xún)條件
* 返回結(jié)果數(shù)組
*/
function read($table,$condition='1') {
$render = $this ->readall($table,$condition,1);
return $render[0];
}
/**
* 修改數(shù)據(jù)方法
* 輸入表名,插入數(shù)據(jù)array('字段'=>'值'),條件
* 返回布爾值
*/
function update($table,$data,$condition ) {
$set = '';
foreach( $data as $key=>$val){
$set .= "`$key` = '".$val."',";
}
$set = rtrim($set,',');
if(is_array($condition)){
$condition = $this->parse_condition($condition);
}
$sql = "update `".DB_PREFIX.$table."` set $set where $condition";
return $this->query($sql);
}
/**
* 插入數(shù)據(jù)方法
* 輸入表名,數(shù)據(jù)array('字段'=>'值')
* 返回布爾
*/
function insert($table,$data) {
$fields = array();
$values = array();
foreach( $data as $key=> $val){
if(is_array($val)){
$_values = array();
$_fields = array();
foreach( $val as $k=> $v){
$_fields[]= "`$k`";
$_values[]= "'{$v}'";
}
$fields = $_fields;
$values[] = '('.implode(',',$_values).')';
}
else{
$fields[] = "`$key`";
$values[] = "'{$val}'";
}
}
$fields = implode(',',$fields);
$values = implode(',',$values);
$sql = "insert into `".DB_PREFIX.$table."` ($fields) values($values)";
return $this->query($sql);
}
/**
* 刪除數(shù)據(jù)方法
* 輸入表名,條件
* 返回bool
*/
function delete($table,$condition) {
if(empty($condition)){
die('條件不能為空');
}
if(is_array($condition)){
$condition = $this->parse_condition($condition);
}
$sql = "delete from `".DB_PREFIX.$table."` where $condition";
return $this->query($sql);
}
/**
* 解析條件的函數(shù)
* @param 條件數(shù)組
* <code>
$arr[] = "`id`==0";
$arr[] = "`id`==5";
$arr['id'] = "5";
$arr['or'][] = "`id`!=2";
$arr['or'][] = "`id`!=1";
$arr['or'][] = "`id`!=2";
$arr['groups'][]='id';
$arr['orders']['id']='asc';
$arr['orders']['td']='DESC';
* </code>
* @return str
**/
function parse_condition($condition){
$and = '1';
$or = '0';
$groups = array();
$orders = array();
foreach( $condition as $key=>$val){
if(is_numeric($key)){
$and .= " and $val";
}
elseif(strtolower($key)== 'or'){
//處理or條件
if(is_array($val)){
foreach( $val as $k=>$v){
if(is_numeric($k)){
$or .= " or {$v}";
}
elseif(is_array($v)){
$v = implode(',',$v);
$or .= " or `$k` in ($v)";
}else{
$or .= " or `$k='{$v}'";
}
}
}else{
$or .= " or $val'";
}
}
elseif(strtolower($key)== 'groups'){
//處理group by
foreach( $val as $k=>$v){
$groups[] = $v;
}
}elseif(strtolower($key)== 'orders'){
//處理order by
foreach( $val as $k=>$v){
$orders[] = $k.' '.$v;
}
}else{
if(is_array($val)){
$val = implode(',',$val);
$and .= " and `$key` in ($val)";
}else{
$and .= " and `$key`='{$val}'";
}
}
}
if($and!='1' && $or!='0')$where = $and.' or '.$or;
elseif($and!='1') $where = $and;
elseif($or!='0') $where = $or;
if($groups)$where .= " group by ".implode(',',$groups);
if($orders)$where .= " order by ".implode(',',$orders);
$where = str_replace('1 and','',str_replace('0 or','',$where));
return $where;
}
/**
* 鎖表方法
* 輸入表名,鎖定類(lèi)型,r or w 寫(xiě)鎖要放在讀鎖前面
* 返回bool
*/
function lock($table,$type='r') {
if($type=='r'){
$type = 'READ';
}
else{
$type = 'WRITE';
}
$sql = "lock table `".DB_PREFIX.$table."` $type";
return $this->query($sql);
}
/**
* 解鎖表方法
*
* 返回bool
*/
function unlock( ) {
$sql = "unlock tables";
return $this->query($sql);
}
/**
* 結(jié)果集放入數(shù)組方法
* 返回?cái)?shù)組,指針下移
*/
function fetch($row) {
return mysql_fetch_array($row,MYSQL_ASSOC);
}
/**
* 計(jì)算結(jié)果集行數(shù)方法
* 輸入$row
* 返回行數(shù)
*/
function num_rows($row) {
return mysql_num_rows($row);
}
/**
* 計(jì)算結(jié)果集列數(shù)方法
* 輸入$row
* 返回列數(shù)
*/
function num_fields($row) {
return mysql_num_fields($row);
}
/**
* 釋放result結(jié)果集內(nèi)存
* 返回布爾值
*/
function free_result($row) {
return mysql_free_result($row);
}
/**
* 查看指定表的字段名
* 輸入表名
* 返回全部字段名數(shù)組
*/
function list_fields($table) {
$fields = mysql_list_fields(DB_NAME, DB_PREFIX.$table, $this->links);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
$row[$i] = mysql_field_name($fields, $i);
}
return $row;
}
/**
* 查看數(shù)據(jù)庫(kù)版本方法
*/
function version() {
return mysql_get_server_info();
}
/**
* 插入時(shí)查看插入ID
*/
function insert_id() {
return mysql_insert_id();
}
/**
* 分頁(yè)方法
*/
function page($table,$condition='1',$pagesize=20,$id='page') {
$page = $_GET[$id];
if(!$page)$page= 0 ;
elseif(!is_numeric($page))die('分頁(yè)出錯(cuò)');
//查找結(jié)果集
$p = $page * $pagesize;
$limit = $p.",".$pagesize;
$results = $this->readall($table,$condition,$limit);
//取得結(jié)果集行數(shù)
$num = $this->count($table,$condition);
//定義最后頁(yè) $maxpage
if ($num % $pagesize) {
$maxpage = (int) ($num / $pagesize +1);
} else
$maxpage = $num / $pagesize;
if(STATICS){
//從服務(wù)器端取得url信息
if($_GET[$id] === null){
$_SERVER["REQUEST_URI"] = str_replace('index.php','',$_SERVER["REQUEST_URI"]);
$_SESSION[$id] = str_replace('.html','',$_SERVER["REQUEST_URI"],$count);
$_SESSION[$id] = $count?$_SESSION[$id] :$_SESSION[$id].'index';
if(!sizeof($_GET))$_SESSION[$id].="-htm";
}
$str = "<div class=pg style=padding-top:25px;><a href=$_SESSION[$id]-".$id."-0.html>First</a> ";
if($page)$str .= "<a href=$_SESSION[$id]-".$id."-".($page-1).".html>Previous</a> ";
if($page-3>=0)$str .="<a href=$_SESSION[$id]-".$id."-".($page-3).".html>".($page-2)."</a> ";
if($page-2>=0)$str .="<a href=$_SESSION[$id]-".$id."-".($page-2).".html>".($page-1)."</a> ";
if($page-1>=0)$str .="<a href=$_SESSION[$id]-".$id."-".($page-1).".html>".$page."</a> ";
if($page < $maxpage)$str .=($page+1)." ";
if($page+1 < $maxpage)$str .="<a href=$_SESSION[$id]-".$id."-".($page+1).".html>".($page+2)."</a> ";
if($page+2 < $maxpage)$str .="<a href=$_SESSION[$id]-".$id."-".($page+2).".html>".($page+3)."</a> ";
if($page+3 < $maxpage)$str .="<a href=$_SESSION[$id]-".$id."-".($page+3).".html>".($page+4)."</a> ";
if($page+1 < $maxpage)$str .="<a href=$_SESSION[$id]-".$id."-".($page+1).".html>Next</a> ";
if(!$maxpage)$maxpage=1;
$str .="<a href=$_SESSION[$id]-".$id."-".($maxpage-1).".html>Last</a> <a href=javascript:;> ".($page+1)."/".$maxpage."Total</a> </div>";
}
else{
//從服務(wù)器端取得url信息
if($_GET[$id] === null){
$_SESSION[$id] = $_SERVER["REQUEST_URI"];
if(!sizeof($_GET))$_SESSION[$id].="?p=1";
}
$str = "<div class=pg style=padding-top:25px;><a href=$_SESSION[$id]&".$id."=0>First</a> ";
if($page)$str .= "<a href=$_SESSION[$id]&".$id."=".($page-1).">Previous</a> ";
if($page-3>=0)$str .="<a href=$_SESSION[$id]&".$id."=".($page-3).">".($page-2)."</a> ";
if($page-2>=0)$str .="<a href=$_SESSION[$id]&".$id."=".($page-2).">".($page-1)."</a> ";
if($page-1>=0)$str .="<a href=$_SESSION[$id]&".$id."=".($page-1).">".$page."</a> ";
if($page < $maxpage)$str .=($page+1)." ";
if($page+1 < $maxpage)$str .="<a href=$_SESSION[$id]&".$id."=".($page+1).">".($page+2)."</a> ";
if($page+2 < $maxpage)$str .="<a href=$_SESSION[$id]&".$id."=".($page+2).">".($page+3)."</a> ";
if($page+3 < $maxpage)$str .="<a href=$_SESSION[$id]&".$id."=".($page+3).">".($page+4)."</a> ";
if($page+1 < $maxpage)$str .="<a href=$_SESSION[$id]&".$id."=".($page+1).">Next</a> ";
if(!$maxpage)$maxpage=1;
$str .="<a href=$_SESSION[$id]&".$id."=".($maxpage-1).">Last</a> <a href=javascript:;> ".($page+1)."/".$maxpage."Total</a> </div>";
}
return array($results,$str);
}
/**
* 左連接多表查詢(xún)
* @param
* @return
**/
function leftjoin($left,$right,$on,$condition,$limit=1){
$left = explode('.',$left);
$right = explode('.',$right);
$left['0'] = "`".DB_PREFIX.$left['0']."`";
$right['0'] = "`".DB_PREFIX.$right['0']."`";
if($left['1'] || $right['1']){
$fields = '';
if(!empty($left['1'])){
$_field = explode(',',$left['1']);
foreach( $_field as $one){
$fields.=$left['0'].'.`'.$one."`,";
}
}
if(!empty($right['1'])){
$_field = explode(',',$right['1']);
foreach( $_field as $one){
$fields.=$right['0'].".`".$one."`,";
}
}
$fields = rtrim($fields,',');
}
else{
$fields = '*';
}
$on = str_replace('\2',$right[0],str_replace('\1',$left[0],$on));
$condition = str_replace('\2',$right[0],str_replace('\1',$left[0],$condition));
$sql = "SELECT {$fields} FROM {$left[0]} LEFT JOIN {$right[0]} ON ( {$on} ) WHERE ( {$condition} ) LIMIT {$limit} ";
$query = $this->query($sql);
$field_num = mysql_num_fields($query);
while($arr = mysql_fetch_array($query,MYSQL_NUM)){
$_arr = array();
for( $i=0 ; $i<$field_num ; $i++ ){
$table = str_replace(DB_PREFIX,'',mysql_field_table($query, $i));
$field = mysql_field_name($query, $i);
$_arr[$table.'.'.$field] = $arr[$i];
}
$array[]=$_arr;
}
$array=$limit==1?$arrat[0]:$array;
return $array;
}
/**
* 用于創(chuàng)建一個(gè)表結(jié)構(gòu)
* @param 表名,結(jié)構(gòu) array(字段,格式,注釋) 表注釋 索引array(字段,字段) 全文搜索(字段,字段)
* @return 打印
**/
function createTable($tablename,$data,$comment='',$key='',$fulltext=''){
$_key='';
$_type = '';
$_fulltext = '';
$tablename = DB_PREFIX.$tablename;
$sql = "CREATE TABLE IF NOT EXISTS `$tablename` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT 'ID',
";
foreach( $data as $one){
switch($one[1]){
case '':
$_type = 'varchar(255)';
break;
case 'tinyint':
$_type = 'tinyint(1)';
break;
case 'time':
$_type = 'int(10)';
break;
default:
if(strpos($one[1],'.')!==false){
$_type = explode('.',$one[1]);
$_type = $_type[0].'('.$_type[1].')';
}
else{
$_type = $one[1];
}
break;
}
$sql.="`{$one[0]}` $_type NOT NULL COMMENT '{$one[2]}',
";
}
if(!empty($key)){
foreach( $key as $one){
$_key.="KEY `$one` (`$one`),
";
}
}
if(!empty($fulltext)){
foreach( $fulltext as $one){
$_key.="FULLTEXT `$one` (`$one`),
";
}
}
$sql.= $_key.$_fulltext."PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=".CHARSET." COMMENT '$comment';
";
if(!$_GET[sure]){
if(empty($_GET)){
$url = '?sure=1';
}
else{
$url = $_SERVER["REQUEST_URI"].'&sure=1';
}
echo "即將執(zhí)行以下建表操作:<br><pre>$sql<a href=$url>確定</a></pre>";
}
elseif($_GET[sure] && $this->query($sql)){
echo "完成操作";
}
else{
echo "操作失?。?lt;br>><pre>$sql</pre>";
}
exit;
}
};
//實(shí)例
define("DB_HOST", 'localhost');
define("DB_USER", 'root');
define("DB_PWD", '');
define("DB_NAME", "test");
define("DB_PREFIX", "test_");
define('CHARSET', 'gbk'); // 編碼
define("GEBUG", 1);
//建表
$Db=new Db();
$data[] = array('title','','標(biāo)題');
$data[] = array('open','tinyint.1','是否公開(kāi)');
$data[] = array('keyword','','關(guān)鍵詞');
$data[] = array('content','text','內(nèi)容');
$data[] = array('created','time','時(shí)間');
//$Db->createTable('article',$data,'文章表');
//增刪改查
$data['title']='t';
$data['keyword']='k';
$Db->insert('article',$data);
$num = $Db->read('article.id','1 order by id desc');
$data['created'] = mktime()+$num['id'];
$Db->update('article',$data,"`id` =2");
$Db->delete('article',"`id` =3");
?>
php采集程序,提取網(wǎng)頁(yè)超鏈接,郵箱或其他特定內(nèi)容
以下代碼從上一篇文章修改而來(lái),專(zhuān)門(mén)用于提取網(wǎng)頁(yè)所有超鏈接,郵箱或其他特定內(nèi)容
<?php
function fetch_urlpage_contents($url){
$c=file_get_contents($url);
return $c;
}
//獲取匹配內(nèi)容
function fetch_match_contents($begin,$end,$c)
{
$begin=change_match_string($begin);
$end=change_match_string($end);
$p = "#{$begin}(.*){$end}#iU";//i表示忽略大小寫(xiě),U禁止貪婪匹配
if(preg_match_all($p,$c,$rs))
{
return $rs;}
else { return "";}
}//轉(zhuǎn)義正則表達(dá)式字符串
function change_match_string($str){
//注意,以下只是簡(jiǎn)單轉(zhuǎn)義
$old=array("/","$",'?');
$new=array("\/","\$",'\?');
$str=str_replace($old,$new,$str);
return $str;
}
//采集網(wǎng)頁(yè)
function pick($url,$ft,$th)
{
$c=fetch_urlpage_contents($url);
foreach($ft as $key => $value)
{
$rs[$key]=fetch_match_contents($value["begin"],$value["end"],$c);
if(is_array($th[$key]))
{ foreach($th[$key] as $old => $new)
{
$rs[$key]=str_replace($old,$new,$rs[$key]);
}
}
}
return $rs;
}
$url="http://www.dgkai.cn"; //要采集的地址
$ft["a"]["begin"]='<a'; //截取的開(kāi)始點(diǎn)<br />
$ft["a"]["end"]='>'; //截取的結(jié)束點(diǎn)
$rs=pick($url,$ft,$th); //開(kāi)始采集
print_r($rs["a"]);
?>
php小偷程序,簡(jiǎn)單的php采集代碼
<?php
function fetch_urlpage_contents($url){
$c=file_get_contents($url);
return $c;
}
//獲取匹配內(nèi)容
function fetch_match_contents($begin,$end,$c)
{
$begin=change_match_string($begin);
$end=change_match_string($end);
$p = "{$begin}(.*){$end}";
if(eregi($p,$c,$rs))
{
return $rs[1];}
else { return "";}
}//轉(zhuǎn)義正則表達(dá)式字符串
function change_match_string($str){
//注意,以下只是簡(jiǎn)單轉(zhuǎn)義
//$old=array("/","$");
//$new=array("\/","\$");
$str=str_replace($old,$new,$str);
return $str;
}
//采集網(wǎng)頁(yè)
function pick($url,$ft,$th)
{
$c=fetch_urlpage_contents($url);
foreach($ft as $key => $value)
{
$rs[$key]=fetch_match_contents($value["begin"],$value["end"],$c);
if(is_array($th[$key]))
{ foreach($th[$key] as $old => $new)
{
$rs[$key]=str_replace($old,$new,$rs[$key]);
}
}
}
return $rs;
}
$url="http://www.dgkai.cn"; //要采集的地址
$ft["title"]["begin"]="<title>"; //截取的開(kāi)始點(diǎn)
$ft["title"]["end"]="</title>"; //截取的結(jié)束點(diǎn)
$th["title"]["中山"]="廣東"; //截取部分的替換
$ft["body"]["begin"]="<body>"; //截取的開(kāi)始點(diǎn)
$ft["body"]["end"]="</body>"; //截取的結(jié)束點(diǎn)
$th["body"]["中山"]="廣東"; //截取部分的替換
$rs=pick($url,$ft,$th); //開(kāi)始采集
echo $rs["title"];
echo $rs["body"]; //輸出
?>
文字圖片向上滾動(dòng)的JS代碼
<div id="demo">
<div id="demo1">
<ul>
<li>
文字圖片內(nèi)容
</li>
</ul>
</div>
<div id="demo2"></div>
<script type="text/javascript">
var speed=10;
var FGDemo=document.getElementById('demo');
var FGDemo1=document.getElementById('demo1');
var FGDemo2=document.getElementById('demo2');
FGDemo2.innerHTML=FGDemo1.innerHTML
function Marquee1(){
if(FGDemo2.offsetHeight-FGDemo.scrollTop<=0)
FGDemo.scrollTop-=FGDemo1.offsetHeight
else{
FGDemo.scrollTop++
}
}
var MyMar1=setInterval(Marquee1,speed)
FGDemo.onmouseover=function() {clearInterval(MyMar1)}
FGDemo.onmouseout=function() {MyMar1=setInterval(Marquee1,speed)}
</script>
</div>