Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $postID = $_REQUEST['pIdPost'];
- $result = mysqli_query($con,
- "SELECT
- comments.IdPost, comments.IdUser,
- comments.Comment AS Comment , users.UserImage ,
- users.Username , DATE_FORMAT(comments.CommentDate, '%d/%m/%Y %H:%i:%s') AS cDate
- FROM comments, users
- WHERE
- comments.IdPost = '$postID'
- AND
- users.IdUser = comments.IdUser ")or die('Errant Query:');
- while($row = mysqli_fetch_assoc($result))
- {
- $output[]=$row;
- }
- header('content-type: application/json; charset=utf-8');
- print(json_encode($output, JSON_UNESCAPED_UNICODE));
- //print(json_encode($output));
- mysqli_close($con);
- [{"IdPost":"2",
- "IdUser":"5",
- "Comment":"Me 3",
- "UserImage":"images/defaultUser.png",
- "Username":"Mia",
- "CommentDate":"16/11/2014 00:01:05"}]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement