overpost

Untitled

Apr 2nd, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. <?
  2. header('Content-Type: application/json');
  3. include($_SERVER['DOCUMENT_ROOT'].'/connect.php');
  4.  
  5. //News all_count
  6. $ncount = $mysqli->query("SELECT COUNT(*) as count FROM `notices`");
  7. while($count_row = $ncount->fetch_array()) { $newsCount = $count_row['0']; }
  8. //Конец news all_count
  9.  
  10. //News
  11. $news2 = $mysqli->query("SELECT * FROM notices ORDER BY `id` DESC LIMIT ".$_GET['count']."");
  12. while($news_rows = $news2->fetch_array()) {
  13. $newsID .= ','.$news_rows['id'];
  14. $newsHEADER .= ','.$news_rows['note'];
  15. $newsNEWS .= ';'.$news_rows['note_full'];
  16. }
  17. //Конец news
  18. $newsIDs = explode(",", $newsID);
  19. $newsHEADERs = explode(",", $newsHEADER);
  20. $newsNEWSS = explode(";", $newsNEWS);
  21. $newsID_1 = array_splice($newsIDs,1);
  22. $newsHEADER_1 = array_splice($newsHEADERs,1);
  23. $newsNEWS_1 = array_splice($newsNEWSS,1);
  24.  
  25.  
  26. $arr = $newsID_1;
  27. //News
  28. $news2 = $mysqli->query("SELECT * FROM notices ORDER BY id DESC LIMIT ".$_GET['count']."");
  29.  
  30.  
  31. while($news_rows = $news2->fetch_array()) {
  32. $test .= '<br>{"id":"'.$news_rows['id'].'","head":"'.$news_rows['note'].'","full":"'.$news_rows['note_full'].'"}';
  33.  
  34. }
  35.  
  36. echo '{"response":['; echo $test; echo '}]}',JSON_UNESCAPED_UNICODE;
  37. ?>
Advertisement
Add Comment
Please, Sign In to add comment