php制作的bbs超经典

php制作的bbs超经典(全文在这里)http://115.com/lb/5lbcqol0flze

1. $dsn = "mysql:host=localhost;dbname=数据库名";
2. $dbh = new PDO($dsn, '用户名', '密码', array(PDO::ATTR_PERSISTENT => true));
3. $dbh -> query("SET NAMES 'utf8'; ");
5. $id=$_POST['id'];
6. $username = $_SESSION['username']; //获取回帖人的相关信息
7. $sql = "select * from user where username= '$username'";
8. $result = mysql_query($sql);
9. $row = mysql_fetch_array($result);
10. $row['score']=$row['score']+2;
11. mysql_query("update user set score = '".$row['score']."' where username ='".$row['username']."'");
14. $content = $_POST['content'];//获取回帖的相关信息
15. //$email = $row['email'];
16. $date = date("Y-m-d H:i:s");
18. $date=date("y-m-d H:i");
19. date_default_timezone_set("Asia/Shanghai");
20. $time = date('Y-m-d H:m:s');
21. $y=date("Y",strtotime($time));
22. $m=date("m",strtotime($time));
23. $d=date("d",strtotime($time));
24. $h=date("H",strtotime($time));
25. $w=date("w",strtotime($time));
26. //$weekNumber=intval(date('W'));
27. //$url = "http://api.map.baidu.com/geocoder?location={$weidu},{$jingdu}&output=json";
28. //$json = json_decode(file_get_contents($url), TRUE);
29. //$a=file_get_contents($url);
30. //$province = $json['result']['addressComponent']['province'];
31. //$city = $json['result']['addressComponent']['city'];
32. $sql=" insert into 表名(文章ID,内容, 名字, 时间)values('$id', '$content', '$username', now())";
33. //$result=mysql_query($sql);
34. if ($dbh -> query($sql)) {
35. header("Content-Type:Application/json");
36. $arr = array('status' => 'ok');
37. echo json_encode($arr);
38. }
39. ?>

复制代码