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;
?>
本文链接:http://www.cnblogs.com/xtyang/p/3207422.html,转载请注明。
效果:
PHP代码
Header('Content-type: image/png;Charset:utf-8'); //声明图片
$im = imagecreate(400,200);
//get color.
$bg = imagecolorallocate($im,0,0,0);
$red = imagecolorallocate($im,255,0,255);
$white = imagecolorallocate($im,255,255,255);
$arrowX = array(394,97,399,100,394,103);
$arrowY = array(197,5,200,0,203,5);
//画曲线
for($i=0;$i<380;$i+=0.1){
$x = $i/20;
$y = sin($x);
$y = 100 + 40*$y;
imagesetpixel($im,$i+10,$y,$red);
}
//画X轴和Y轴
imageline($im,0,100,394,100,$white);
imageline($im,200,5,200,200,$white);
//画坐标title
imagestring($im,4,350,110,'XShaft',$white);
//画箭头
imagefilledpolygon($im,$arrowX,3,$white);
imagefilledpolygon($im,$arrowY,3,$white);
imagepng($im);
imagedestroy($im);
?>
本文链接:http://www.cnblogs.com/xtyang/p/3208495.html,转载请注明。
<?php
$discuz_url = 'http://127.0.0.1/discuz/';//论坛地址
$login_url = $discuz_url .'logging.php?action=login';//登录页地址
$post_fields = array();
//以下两项不需要修改
$post_fields['loginfield'] = 'username';
$post_fields['loginsubmit'] = 'true';
//用户名和密码,必须填写
$post_fields['username'] = 'tianxin';
$post_fields['password'] = '111111';
//安全提问
$post_fields['questionid'] = 0;
$post_fields['answer'] = '';
//@todo验证码
$post_fields['seccodeverify'] = '';
//获取表单FORMHASH
$ch = curl_init($login_url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$contents = curl_exec($ch);
curl_close($ch);
preg_match('/<input\s*type="hidden"\s*name="formhash"\s*value="(.*?)"\s*\/>/i', $contents, $matches);
if(!empty($matches)) {
$formhash = $matches[1];
} else {
die('Not found the forumhash.');
}
//POST数据,获取COOKIE,cookie文件放在网站的temp目录下
$cookie_file = tempnam('./temp','cookie');
$ch = curl_init($login_url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post_fields);
curl_setopt($ch, CURLOPT_COOKIEJAR, $cookie_file);
curl_exec($ch);
curl_close($ch);
//取到了关键的cookie文件就可以带着cookie文件去模拟发帖,fid为论坛的栏目ID
$send_url = $discuz_url."post.php?action=newthread&fid=2";
$ch = curl_init($send_url);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_COOKIEFILE, $cookie_file);
$contents = curl_exec($ch);
curl_close($ch);
//这里的hash码和登陆窗口的hash码的正则不太一样,这里的hidden多了一个id属性
preg_match('/<input\s*type="hidden"\s*name="formhash"\s*id="formhash"\s*value="(.*?)"\s*\/>/i', $contents, $matches);
if(!empty($matches)) {
$formhash = $matches[1];
} else {
die('Not found the forumhash.');
}
$post_data = array();
//帖子标题
$post_data['subject'] = 'test2';
//帖子内容
$post_data['message'] = 'test2';
$post_data['topicsubmit'] = "yes";
$post_data['extra'] = '';
//帖子标签
$post_data['tags'] = 'test';
//帖子的hash码,这个非常关键!假如缺少这个hash码,discuz会警告你来路的页面不正确
$post_data['formhash']=$formhash;
$ch = curl_init($send_url);
curl_setopt($ch, CURLOPT_REFERER, $send_url); //伪装REFERER
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 0);
curl_setopt($ch, CURLOPT_COOKIEFILE, $cookie_file);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post_data);
$contents = curl_exec($ch);
curl_close($ch);
//清理cookie文件
unlink($cookie_file);
?>
本文链接:http://www.cnblogs.com/top5/p/3208700.html,转载请注明。