PHP-made BBS Super Classic

PHP made BBS Super Classic (full text here) Http://115.com/lb/5lbcqol0flze $DSN = "mysql:host=localhost;dbname= database name"; $DBH = new PDO ($dsn, ' User name ', ' Password ', array (pdo::attr_persistent = true)); $DBH, Query ("SET NAMES ' UTF8 ';"); $id =$_post[' id ']; $username = $_session[' username '];//get the relevant information of the reply person $sql = "SELECT * from user where username= ' $username '"; $result = mysql_query ($sql); $row = Mysql_fetch_array ($result); $row [' Score ']= $row [' Score ']+2; mysql_query ("Update user set score = '". $row [' Score ']. "' WHERE username = '". $row [' username ']. "'"; $content = $_post[' content '];//get information about replies $email = $row [' email ']; $date = Date ("y-m-d h:i:s"); $date =date ("y-m-d h:i"); Date_default_timezone_set ("Asia/shanghai"); $time = Date (' y-m-d h:m:s '); $y =date ("Y", Strtotime ($time)); $m =date ("M", Strtotime ($time)); $d =date ("D", Strtotime ($time)); $h =date ("H", Strtotime ($time)); $w =date ("W", Strtotime ($time)); $weekNumber =intval (Date (' W ')); $url = "http://api.map.baidu.com/geocoder?location={$weidu},{$jingdu}&output=json"; $json = Json_decode (file_get_contents ($url), TRUE); $a =file_get_contents ($url); $province = $json [' result '] [' addresscomponent '] [' Province ']; $city = $json [' result '] [' addresscomponent '] [' City ']; $sql = "INSERT into table name (article ID, content, name, time) VALUES (' $id ', ' $content ', ' $username ', Now ())"; $result =mysql_query ($sql); if ($dbh, query ($sql)) { Header ("Content-type:application/json"); $arr = Array (' status ' = ' OK '); echo Json_encode ($arr); } ?> Copy Code

