按最新订单

Question

I do not know php coding, I have one android application which using php as backend service with json. It is fetching latest images as last added first, but for category images, its showing randomly. I am trying to sort category image also as last added image must first, If you are expert, Please help me for solve puzzle.

MY API for fetch images is like below

<?php
include ("includes/connection.php");
include ("purchase.php");
if (purchase_status() == false) {
    echo "<p>Sorry, we are unable to verify your purchase.</p>";
    exit ;
} else {
    if (isset($_GET['cat_id'])) {
        $cat_id = $_GET['cat_id'];
        $cat_img_res = mysql_query('SELECT * FROM tbl_category WHERE cid=\'' . $cat_id . '\'');
        $cat_img_row = mysql_fetch_assoc($cat_img_res);
        $cid = $cat_img_row['cid'];
        $cat_nm = $cat_img_row['category_name'];
        $files = array();
        $dir = opendir(dirname(realpath(__FILE__)) . '/categories/' . $cat_img_row['category_name'] . '/');
        while ($file = readdir($dir)) {
            if ($file == '.' || $file == '..') {
                continue;
            }
            $allimages[] = $file;
        }
        $total_arr = array_merge((array)$cat_nm, (array)$allimages);
        sort($total_arr);
        foreach ($total_arr as $key => $file) {

            if ($key != count($total_arr) - 1) {
                $array['HDwallpaper'][] = array('images' => $file, 'cat_name' => $cat_nm, 'cid' => $cid);
            }
        }
        echo stripslashes(json_encode($array));
    } else if (isset($_GET['latest'])) {
        $limit = $_GET['latest'];
        $query = "SELECT tbl_gallery.image,tbl_category.category_name FROM tbl_gallery
            LEFT JOIN tbl_category ON tbl_gallery.cat_id= tbl_category.cid 
            ORDER BY tbl_gallery.id DESC LIMIT $limit";
        $resouter = mysql_query($query);
        $set = array();
        $total_records = mysql_numrows($resouter);
        if ($total_records >= 1) {
            while ($link = mysql_fetch_array($resouter, MYSQL_ASSOC)) {
                $set['HDwallpaper'][] = $link;
            }
        }
        echo $val = str_replace('\\/', '/', json_encode($set));
    } else {
        $query = "SELECT cid,category_name,category_image FROM tbl_category";
        $resouter = mysql_query($query);
        $set = array();
        $total_records = mysql_numrows($resouter);
        if ($total_records >= 1) {
            while ($link = mysql_fetch_array($resouter, MYSQL_ASSOC)) {
                $set['HDwallpaper'][] = $link;
            }
        }
        echo $val = str_replace('\\/', '/', json_encode($set));
    }
}
?>

Answer 1

just user the mysql query in php as follows:

mysql_query("SELECT * FROM tbl_category WHERE cid='".$cat_id."' ORDER BY cid DESC");

if you have stored the time of upload the data then this is perfect way to get the latest uploaded images as follows:

mysql_query("SELECT * FROM tbl_category WHERE cid='".$cat_id."' ORDER BY uploaded_time DESC");