t.cn网址缩短PHP源码
<?phpfunction weibo_url($site){ $url = 'http://service.weibo.com/share/share.php?url='.urlencode($site).'&title=ířÖˇťńČĄ&pic=&appkey='; set_time_limit(0); sleep(0.5); $ch = curl_init(); curl_setopt($ch, CURLOPT_USERAG...
SQLITE 创建唯一索引不重复
号码字段为唯一索引不重复项PRAGMA foreign_keys = false;DROP TABLE IF EXISTS "DBTABLE";CREATE TABLE "DBTABLE" ( "ID" integer PRIMARY KEY AUTOINCREMENT, "号码" string(15) NOT NULL, "密码" string(15) NOT NULL);CREATE UNIQUE INDEX "号码"ON "DBTABLE" ( "号码" ASC);PRAGMA foreign_keys = true;
jquery 外部调用 typecho 文章列表
在线小工具推荐 $(document).ready(function(){ $.get("http://www.cha128.com/index.php/xxxxx/posts",function(data,status){ // alert("数据: " + data + "\n状态: " + status); //json格式 var param = [data]; //设置参数值 if(param.length>0){ // alert(param[0].st...
js弹窗设备检测报告
var u = navigator.userAgent, app = navigator.appVersion; var isAndroid = u.indexOf('Android') > -1 || u.indexOf('Linux') > -1 || u.indexOf('Adr') > -1; //android终端或者uc浏览器 var isiOS = !!u.match(/\(i[^;]+;( U;)? CPU.+Mac OS X/); //ios终端 if (isAndroid==true){ alert('欢迎您使用安卓设备登陆本网站');} else if (isiO...
access 数据库查看重复记录，删除重复记录select语句
//查看所有保留最大IDselect * from [表名] where [字段ID] not in(select min([字段ID]) from [表名] group by [去重的字段])//查看所有保留最小IDselect * from [表名] where [字段ID] not in(select max([字段ID]) from [表名] group by [去重的字段])//统计每一个重复记录条数//SELECT [去重的字段],Count() FROM [[表名]] GROUP BY [[去重的字段]] HAVING Count()>1;//所有重复记录保留最小I...
sqlite 删除表中重复数据
sqlite 删除表中重复数据（亲测可用）例子：表名 Paper 。通过字段PaperID查找重复数据。 1 --查询某表中重复的数据方法1 select * from Paper group by PaperID having count(*)>1; 方法2 SELECT 去重字段FROM 表名 tempTable WHERE (tempTable.去重字段) IN ( SELECT 去重字段 FROM 表名 GROUP BY 去重字段 HAVING count(*)>= 2 OR...
php获取目录下的所有文件
/获取目录下的所有文件[$dir] 文件夹路径 /function deepScanDir($dir) {$fileArr = array (); $dirArr = array (); $dir = rtrim($dir, '//'); if (is_dir($dir)) { $dirHandle = opendir($dir); while (false !== ($fileName = readdir($dirHandle))) { $subFile = $dir . DIRECTORY_SEPARATOR . $fileName; ...
PHP正确获取客户端IP地址
目前主流的函数方法：<?phpfunction getIp(){if ($_SERVER["HTTP_CLIENT_IP"] && strcasecmp($_SERVER["HTTP_CLIENT_IP"], "unknown")) { $ip = $_SERVER["HTTP_CLIENT_IP"]; } else { if ($_SERVER["HTTP_X_FORWARDED_FOR"] && strcasecmp($_SERVE...
PHP 发送get、post请求的6种方法简明总结
方法1：用file_get_contents 以get方式获取内容：<?php$url='http://www.51growup.com/';$html = file_get_contents($url);echo $html;方法2: 用fopen打开url, 以get方式获取内容：<?php$fp = fopen($url, 'r');stream_get_meta_data($fp);while(!feof($fp)) {$result .= fgets($fp, 1024);}echo "url body: $result";fclose($fp);方法3：用file...
