File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/APPS/eKisan/API/GetNews.php
Back
<?php require_once('Connection.php'); $sql = "SELECT `news`.`news_img` AS 'IMG',`news`.`name_title` AS 'TITLE',`news`.`date` AS 'DATE',`news`.`link` AS 'LINK' FROM `news` ORDER BY `news`.`news_id` DESC"; $result = $con->query($sql); $News["News"] = array(); while($row = $result -> fetch_assoc()) { //echo $row['NAME']; $New = array(); $New = $row; array_push($News["News"],$New); } $con-> close(); $News["success"] = 1; echo json_encode($News); /* { "News": [ { "img": "https://assets-news-bcdn.dailyhunt.in/cmd/resize/400x400_80//fetchdata15/images/8d/9e/67/8d9e67e3690a8e8d892a72d123d3fab3.jpg", "title": "બટાકાનું વાવેતર વધવાના સંકેત : બિયારણના ભાવ બમણાં", "date": "29-03-2021", "link": "https://www.mygujarat1.com/potato-rate-today/" }, { "img": "https://assets-news-bcdn.dailyhunt.in/cmd/resize/400x400_80//fetchdata15/images/8d/9e/67/8d9e67e3690a8e8d892a72d123d3fab3.jpg", "title": "Hello", "date": "29-03-2021", "link": "https://www.mygujarat1.com/potato-rate-today/" }, { "img": "https://assets-news-bcdn.dailyhunt.in/cmd/resize/400x400_80//fetchdata15/images/8d/9e/67/8d9e67e3690a8e8d892a72d123d3fab3.jpg", "title": "બટાકાનું વાવેતર વધવાના સંકેત : બિયારણના ભાવ બમણાં", "date": "29-03-2021", "link": "https://www.mygujarat1.com/potato-rate-today/" }, { "img": "https://assets-news-bcdn.dailyhunt.in/cmd/resize/400x400_80//fetchdata15/images/8d/9e/67/8d9e67e3690a8e8d892a72d123d3fab3.jpg", "title": "બટાકાનું વાવેતર વધવાના સંકેત : બિયારણના ભાવ બમણાં", "date": "29-03-2021", "link": "https://www.mygujarat1.com/potato-rate-today/" }, { "img": "https://assets-news-bcdn.dailyhunt.in/cmd/resize/400x400_80//fetchdata15/images/8d/9e/67/8d9e67e3690a8e8d892a72d123d3fab3.jpg", "title": "બટાકાનું વાવેતર વધવાના સંકેત : બિયારણના ભાવ બમણાં", "date": "29-03-2021", "link": "https://www.mygujarat1.com/potato-rate-today/" } ], "success": 1 }*/ ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.08 |
proxy
|
phpinfo
|
Settings