global $dbi; $now = date( "M, d Y @ h:i a" ); sql_query( "insert into jones_blog_comment values( null, '$blog_entry_id', '$name', '$email', '$subject', '$body', '$now' )", $dbi ); Header( "Location: blog.php?cmd=readAll&id=$blog_entry_id" ); } set_error_handler("myErrorHandler"); if( isSet( $_GET['cmd'] ) ) $cmd = $_GET['cmd']; else if( isSet( $_POST['cmd'] ) ) $cmd = $_POST['cmd']; else $cmd = ""; switch( $cmd ) { case "viewCategory": viewCategory( $_GET['id'] ); break; case "readAll": readAll( $_GET['id'] ); break; case "postComment": postComment( $_POST['blog_entry_id'], $_POST['name'], $_POST['email'], $_POST['subject'], $_POST['body'] ); break; default: main( ); break; } ?>
<?php include "functions.php"; readAll(); include "includes/headear.php"; ?> <div class="container"> <div class="row"> <div class="col-md-12"> <h1>READ</h1> <?php while ($row = mysqli_fetch_assoc($result)) { ?> <pre> <?php print_r($row); ?> </pre> <?php } ?> </div>
} echo insertNoti($from, $fname, $to, $msg, $type, $post_id, $extra); break; case "read": // http://armymax.com/api/noti/noti.php?a=list&user_id=22 $notiId = $_REQUEST["noti_id"]; echo read($notiId); break; case "readAll": $userId = $_REQUEST["user_id"]; if (isset($_REQUEST["timestamp"])) { $timestamp = $_REQUEST["timestamp"]; } else { $timestamp = now(); } echo readAll($userId, $timestamp); break; case "delete": // http://armymax.com/api/noti/noti.php?a=list&user_id=22 $notiId = $_REQUEST["noti_id"]; echo deleteNoti($notiId); break; } } function read($notiId) { $db = notiDbConnect(); $sql = "UPDATE message SET readed = 1 WHERE id = {$notiId}"; $res = $db->query($sql); if ($res) { return json_encode(array('status' => "1"));