一些小东西有时候可能用得上!
1.得到客户端IP地址
function getip(){
if (! empty($_SERVER["HTTP_X_FORWARDED_FOR"])){ //使用代理的情况
$tip = split(",", $_SERVER["HTTP_X_FORWARDED_FOR"]);
$cip = $tip[0];
}
else
$cip = $_SERVER["REMOTE_ADDR"];[
return dechex(ip2long($cip));
}
2.session控制的函数
function session_begin(){
global $userid, $sid, $ip, $session, $db, $islogin;
$ip = getip();
/* 短期而言,系统默认需要支持cookie. */
if (!isset($_COOKIE['userid'])) return false;
else $userid = $_COOKIE['userid'];
if (!isset($_COOKIE['sid'])) return false;
else $sid = $_COOKIE['sid'];
/* 以上返回false意味着用户没有登陆,页面将跳转至首页(登陆页). */
$query = "SELECT * FROM user WHERE nickname = '$userid'";
$result = $db->sql_query($query);
if ($row = $db->sql_fetchrow($result)){
if ($row['sid'] != $sid) return false; /* cookie传送的sid和数据库保存的不吻合 */
if ($row['lastloginip'] != $ip) return false; /* IP不吻合 */
/* 是否要考虑 session的过期 问题呢? */
}
else return false; /* 没有这个userid */
$session = $row;
// $session[''] = $row[''];
unset($row);
$islogin = true;
return true;
}
/* bool session_end(int $userid, string $sid) */
function sesssion_end($userid, $sid){
return true;
}
3.做选美的投票程序
header("Refresh:0;url=./"); //一秒刷新
?>
<script>alert('<?php <BR>require_once('mysql.php'); <BR>require_once('functions.php'); <BR>$db = new sql_db('localhost','root','','selectmm'); <BR>$user_id = $_GET['user_id']; <BR>$ip = getip(); <BR>$deltime = time()-3600; //减去一小时 <BR>$sql = "delete from vote where time <$deltime"; //删除掉过期的数据 <BR>$db->sql_query($sql); <br><br>$sql = "select ip from vote where ip='$ip' and user_id='$user_id'"; //查看一小时内是否投过 <BR>$linkid=$db->sql_query($sql) or die(mysql_error()); <BR>$count=$db->sql_affectedrows(); <BR>if($count) <BR>{ <BR>echo "您已经投过票了！"; <BR>} <BR>else <BR>{ <BR>$sql = "update user set vote_count=vote_count+1 WHERE user_id='$user_id'"; <BR>$db->sql_query($sql); <BR>$count=$db->sql_affectedrows(); <BR>if($count) <BR>{ <BR> echo "投票成功！"; <BR> $sql = "insert into vote (`ip`,`user_id`,`time`) values ('$ip','$user_id','".time()."')";//投票成功就插入一条记录。 <BR> $db->sql_query($sql); <br><br>} <BR>else <BR>{ <BR> echo "投票失败！"; <BR>} <br><br>} <BR>?>'); <BR>//history.back(); <BR></script>
4.smarty的搜索程序
require_once('mysql.php');
$db = new sql_db('localhost','root','','selectmm');
require_once('functions.php');
require_once('session.php');
session_begin();
require('./Libs/Smarty.class.php');
$smarty = new Smarty;
$title = "首页";
$smarty->assign("islogin",$islogin);
$smarty->assign("title",$title);
$age=$_GET['age'];
$arr=explode(',',$age);
$y=date('Y');
$md=date('-m-d');
$begin=($y-$arr[1]).$md;
$end=($y-$arr[0]).$md;
$sql="select p.* from pic_info p,user u where p.user_id=u.user_id and u.birthday between '$begin' and '$end' group by u.user_id";
$link=$db->sql_query($sql) or die(mysql_error());
$row = $db->sql_fetchrowset($link);
$db->sql_freeresult();
$smarty->assign("pic",$row);
$smarty->display('index.tpl.htm');
?>
5.注册程序
require('mysql.php');
$str=new sql_db('localhost','root','','selectmm');
$METHOD = $_POST;
if (isset($METHOD['nickname']) && $METHOD['nickname'] != '') $nickname = $METHOD['nickname'];
else { echo "<script>alert("用户昵称不能为空.")</script>"; echo "<script>location="register.php"</script>"; }
if (isset($METHOD['password']) && strlen($METHOD['password'])>=6) $password = $METHOD['password'];
else { echo "<script>alert("密码至少6位")</script>"; echo ""; }
$password2 = $METHOD['password2'];
if ($password != $password2)
{ echo "<script>alert("两次输入密码不一致")</script>"; echo "<script>location="register.php"</script>"; }
if (isset($METHOD['name']) && $METHOD['name'] != '') $name = $METHOD['name'];
else { echo "<script>alert("用户名不能为空.")</script>"; echo "<script>location="register.php"</script>"; }
$birthday=$METHOD['Year'].$METHOD['Month'].$METHOD['Day'];
$stature = $METHOD['stature'];
$astrology = $METHOD['astrology'];
$bloodtype = $METHOD['bloodtype'];
$goodat = $METHOD['goodat'];
$work = $METHOD['work'];
$educate = $METHOD['educate'];
$homeplace = $METHOD['homeplace'];
$address = $METHOD['address'];
$tel = $METHOD['tel'];
$qq = $METHOD['qq'];
if (isset($METHOD['email']) && $METHOD['email'] != '') $email = $METHOD['email'];
else { echo "<script>alert("Email不能为空")</script>"; echo "<script>location="register.php"</script>"; }
if (!eregi("^[0-9a-z.-_]+@[0-9a-z.]+.[a-z]$",$email)) { echo "<script>alert("电子邮件格式不合法")</script>"; echo "<script>location="register.php"</script>"; }
$dian =$METHOD['dian'];
if (isset($METHOD['myself']) && $METHOD['myself'] != '') $myself = $METHOD['myself'];
else { echo "<script>alert("用.....不能为空")</script>"; echo "<script>location="register.php"</script>"; }
if(isset($METHOD['enounce'])&& $METHOD['enounce']!='')$enounce = $METHOD['enounce'];
else { echo "<script>alert(".....不能为空")</script>"; echo "<script>location="register.php"</script>"; }
$query = "SELECT * FROM user WHERE nickname ='$nickname' or email='$email'";
$result = $str->sql_query($query)or die(mysql_error()); ;
if ($row = $str->sql_fetchrow($result))
{ echo "<script>alert("对不起，该用户已经注册")</script>"; echo "<script>location="register.php"</script>"; }
$password = md5($password);
$query = "INSERT INTO `user` (`nickname`,`password`,`name`,`birthday`,`astrology`,`bloodtype`,`stature`,`goodat`,`work`,`educate`,`homeplace`,`address`,`tel`,`email`,`qq`,`dian`,`myself`,`enounce`) VALUES('$nickname','$password','$name','$birthday','$astrology','$bloodtype','$stature','$goodat','$work','$educate','$homeplace','$address','$tel','$email','$qq','$dian','$myself','$enounce')";
if($str->sql_query($query))
$str->sql_close();
echo "<script>alert("恭喜你，注册成功")</script>";
echo "<script>location="login.php"</script>";
?>
6.提交参数 JS控制
echo "
