Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once('config.php');
- require_once 'classes/BD.class.php';
- BD::conn();
- if(isset($_POST['user']) && $_POST['user'] != ""){
- $user = (int)$_POST['user'];
- $searchPhotos = BD::conn()->prepare("SELECT * FROM `photos` WHERE `id_user` = ? ORDER BY `id` DESC");
- $searchPhotos->execute(array($user));
- $resultPhotos = $searchPhotos->rowCount();
- $searchQtdFollowers = BD::conn()->prepare("SELECT id FROM `follows` WHERE `user` = ?");
- $searchQtdFollowers->execute(array($user));
- $resultFollowers = $searchQtdFollowers->rowCount();
- $searchQtdFollowing = BD::conn()->prepare("SELECT id FROM `follows` WHERE `follower` = ?");
- $searchQtdFollowing->execute(array($user));
- $resultFollowing = $searchQtdFollowing->rowCount();
- $array = array(
- "photos" => $resultPhotos,
- "followers" => $resultFollowers,
- "following" => $resultFollowing
- );
- $result[] = array_map("utf8_encode", $array);
- while($data = $searchPhotos->fetch(PDO::FETCH_ASSOC)){
- $array = array(
- "photo" => PATH.$data["photo"],
- "date_creation" => date('d/m/Y', strtotime($data["date_creation"]))
- );
- $result[] = array_map("utf8_encode", $array);
- }
- header('Content-type: application/json');
- echo json_encode($result);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement