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 '[]'; } } }