来源:    发布时间: 2013-11-07

<?php
class link_mysql{
private $host,$uid,$pwd,$db,$link,$res;
function link_mysql($_host,$_uid,$_pwd,$_db){
$this->host = $_host;
$this->uid = $_uid;
$this->pwd = $_pwd;
$this->db = $_db;
$this->link = mysql_connect($this->host,$this->uid,$this->pwd);
mysql_select_db($this->db,$this->link);
}
function exec_sql($sql){
//if you use insert sentence,then you must open your link;
$res = mysql_query($sql);
return $res;
}
}
$obj_link = new link_mysql('localhost','***','***','website');
$res = $obj_link->exec_sql("select * from userinfo");
$str = "[";
while($rows = mysql_fetch_assoc($res)){
$str = $str."{name:$rows[name],password:$rows[password],age:$rows[age]},";
}
$str = rtrim($str,',') ."]";
echo $str;
?>

    

    来源:    发布时间: 2013-11-07

<?php
$str = rtrim('article_list.html', '.html');
echo $str;

echo '<br />';

$str = rtrim('article_index.html', '.html');
echo $str;

echo '<br />';

$str = rtrim('articleABCT.html', '.html');
echo $str;

echo '<br />';
?>

    

    来源:    发布时间: 2013-11-07

<?php
$link = mysql_connect('localhost', 'sms', 'sms');
mysql_select_db('sms', $link);
mysql_query("set names utf8");
$sql = "
SELECT phone,chang, msg, linkid, mo_time FROM tables '";

$result = mysql_query($sql,$link);
$array = array();
while($row = mysql_fetch_array($result)){


$linkid = $row['phone'].date("YmdHis", strtotime($row['mo_time']));
$str = "SPNUM=".$row['chang']."&MOBILE=".$row['phone']."&CONTENT=".urlencode($row['msg'])."&MOTIME=".urlencode($row['mo_time'])."&LINKID=".$linkid;

$url = "www.baidu.com?".$str;
$array[] = $url;
//var_dump($url); 这里使用curl访问，只能访问一条随后就中断了，只能在上面存放到数组中
/*$result = file_get_contents($url);
var_dump($result);*/
/*$ch = curl_init($url);
curl_setopt($ch, CURLOPT_TIMEOUT, 40);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$result = curl_exec($ch);
// 4. 释放curl句柄
curl_close($ch);*/
}
//var_dump($array);
//这里使用foreach循环执行curl命令
foreach ($array as $url) {
var_dump($url);
$ch = curl_init($url);
curl_setopt($ch, CURLOPT_TIMEOUT, 40);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$result = curl_exec($ch);
// 4. 释放curl句柄
curl_close($ch);
var_dump($result);
}