function get_recent_post_listing($num_posts)
{
$con = connect_db('uedwardn_droll');
$query = "SELECT post_id, DATE_FORMAT(timestamp, '%e %b %Y') as date";
$query .= ", subject FROM posts ORDER BY `timestamp`";
$query .= " DESC LIMIT 0,{$num_posts};";
$result = mysqli_query($con, $query);
$err = mysqli_error($con);
if ($err) {
echo $err;
exit(0);
}
return result2json($result);
}
<?php
require_once '../../common/php/db.php';
$TABLE_NAME = 'sources';
$DB_NAME = 'uedwardn_clips';
# Get a connection to the database
$conn = connect_db($DB_NAME);
# These are the variables expected via POST
$posted_var_names = array('id');
# Get the POST variables
$posted_vars = get_vars($posted_var_names);
# Make an sql insert statement
$sql = get_sql_select_query($conn, $TABLE_NAME, $posted_vars);
# Query the db
$result = mysqli_query($conn, $sql);
if ($err = mysqli_error($conn)) {
echo '{"success":false, "error":"' . $sql . '"}';
} else {
echo result2json($result);
}
?>
function poll($room, $client_id, $type, $last_msg_timestamp)
{
$query = "SELECT * FROM signals WHERE room_id='{$room}' ";
$query .= " AND client_id<>'{$client_id}'";
$query .= " AND `timestamp`>='{$last_msg_timestamp}'";
if ($type != '') {
$query .= "\tAND type<>{$type}";
}
$query .= " ORDER BY signal_id ASC";
$db_link = db_connect();
$result = mysqli_query($db_link, $query);
$error = mysqli_error($db_link);
if ($error) {
echo $error;
} else {
if (mysqli_num_rows($result)) {
echo result2json($result);
} else {
echo '[]';
}
}
}
