File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/backup2609/APPS/eKisan/API/GetVideos.php
Back
<?php require_once('Connection.php'); $sql = "SELECT `video`.`video_img` AS 'IMG',`video`.`Video_title` AS 'TITLE',`video`.`Video_link` AS 'LINK' FROM `video` ORDER BY `video`.`video_id` DESC"; $result = $con->query($sql); $Videos["Videos"] = array(); while($row = $result -> fetch_assoc()) { //echo $row['NAME']; $Video = array(); $Video = $row; array_push($Videos["Videos"],$Video); } $con-> close(); $salahs["success"] = 1; echo json_encode($Videos); /* { "Videos": [ { "img": "https://i.ytimg.com/vi/OHVosN8uoUg/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDZ04tW9i2owtAWOjgkR429a2U6Og", "title": "🌾31/03/2021 commodity prices | aaj na bajar bhav | Rajkot Market yard na bajar bhav | Rajkot", "date": "31-03-2021", "link": "https://youtu.be/OHVosN8uoUg" }, { "img": "https://i.ytimg.com/vi/OHVosN8uoUg/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDZ04tW9i2owtAWOjgkR429a2U6Og", "title": "🌾31/03/2021 commodity prices | aaj na bajar bhav | Rajkot Market yard na bajar bhav | Rajkot", "date": "31-03-2021", "link": "https://youtu.be/OHVosN8uoUg" }, { "img": "https://i.ytimg.com/vi/OHVosN8uoUg/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDZ04tW9i2owtAWOjgkR429a2U6Og", "title": "🌾31/03/2021 commodity prices | aaj na bajar bhav | Rajkot Market yard na bajar bhav | Rajkot", "date": "31-03-2021", "link": "https://youtu.be/OHVosN8uoUg" }, { "img": "https://i.ytimg.com/vi/OHVosN8uoUg/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDZ04tW9i2owtAWOjgkR429a2U6Og", "title": "🌾31/03/2021 commodity prices | aaj na bajar bhav | Rajkot Market yard na bajar bhav | Rajkot", "date": "31-03-2021", "link": "https://youtu.be/OHVosN8uoUg" }, { "img": "https://i.ytimg.com/vi/OHVosN8uoUg/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLDZ04tW9i2owtAWOjgkR429a2U6Og", "title": "🌾31/03/2021 commodity prices | aaj na bajar bhav | Rajkot Market yard na bajar bhav | Rajkot", "date": "31-03-2021", "link": "https://youtu.be/OHVosN8uoUg" } ], "success": 1 } */ ?>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.06 |
proxy
|
phpinfo
|
Settings