Example #1
0
 function blogsave($recv2)
 {
     $checknumber = array('id' => null);
     if ($recv2['blogtitle'] == null || $recv2['blogcontents'] == null) {
         $checknumber = array('id' => '41');
         return $checknumber;
     }
     $con = mysql_connect(SAE_MYSQL_HOST_M . ':' . SAE_MYSQL_PORT, SAE_MYSQL_USER, SAE_MYSQL_PASS);
     if (!$con) {
         die('Could not connect:' . mysql_error());
     }
     mysql_query("set names utf8");
     mysql_select_db(SAE_MYSQL_DB, $con);
     $usr = $_SESSION['username'];
     $search = new scnublog();
     $usrname = $search->searchusername();
     $time = date('Y/m/d h:i:s', time());
     $sql = "insert into blog(email,username,blogtitle,blogcontents,time) values('{$usr}','{$usrname}','{$recv2['blogtitle']}','{$recv2['blogcontents']}','{$time}')";
     if (!mysql_query($sql, $con)) {
         mysql_close($con);
         die('Error:' . mysql_error);
     }
     mysql_close($con);
     $checknumber = array('id' => '42');
     return $checknumber;
 }