function get_from_url($config)
{
global $debug;
// try to get the url
$url = 'http://search.twitter.com/search.json?rpp=100&q=' . urlencode($config['twitter']['search']);
if (isset($config['twitter']['since_id'])) {
$url .= '&since_id=' . $config['twitter']['since_id'];
}
if ($debug) {
echo $url . "\n";
}
if ($debug === true) {
return test_data();
}
$json = '';
$handle = fopen($url, 'r');
// check to make sure the URL didn't fail for some reason
if ($handle) {
while (!feof($handle)) {
// loop through and build the XML file
$json .= fread($handle, 1024);
}
// clean-up the file pointers
fclose($handle);
} else {
// fopen failed for some reason!!!
exit('There was an error fetching the URL');
}
if ($json == '') {
// the XML is blank, nothing was pulled from the URL!!!
exit('There was an error fetching the XML!');
}
return $json;
}
<?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);
?>
