function addChat($d, $ip, $token) { //are they someone who should be able to do this? (check token, ip, etc) //split $d - would probably hold null if just looking for latest chat, $userId|$message if a new message... (split like we are doing in game) return addNewChat($d); }
<?php function addNewChat($post) { mysql_connect("devweb2014.cis.strath.ac.uk", "rnb12162", "consista"); mysql_select_db("rnb12162") or die(mysql_error()); mysql_query("INSERT INTO chat (message)\n VALUES ('{$post}')") or die(mysql_error()); header('Location: chat.html'); } function test_data($data) { // Make a connection $conn = mysql_connect("devweb2014.cis.strath.ac.uk", "rnb12162", "consista"); // Selecting Database $db = mysql_select_db("rnb12162") or die(mysql_error()); $data = trim($data); $data = stripslashes($data); $data = mysql_real_escape_string($data); $data = htmlspecialchars($data); return $data; } $post = test_data($_POST['message']); addNewChat($post); ?>