[0312]_AI/API_表示リストを新規id降順に表示する★

[0312]
表示リストを新規id降順に表示する

***********************
<基本形>
***********************
$sql2 = ‘SELECT * FROM vision_t_20170821 ORDER BY id DESC’;
***********************

対応済みURL
【1】Google Cloud Vision
/php_photo_20170318

http://dasudasu.sakura.ne.jp/php_photo_20170318/20170823_list.php

$sql2 = ‘SELECT * FROM vision_t_20170821’;

$sql2 = ‘SELECT * FROM vision_t_20170821 ORDER BY id DESC’;

【2】Emotion(Azure)・・失礼これはこのままでOKだった、変更不要
/var/www/html/photo_check_20170731

http://153.126.154.106/photo_check_20170731/20170809_rank_test.php

$sql3 = ‘SELECT rank FROM emo_list_rank WHERE (id = (select MAX( id ) from emo_list))’;

$sql3 = ‘SELECT rank FROM emo_list_rank WHERE (id = (select MAX( id ) from emo_list)) ORDER BY id DESC’;

【3】Google OCR・・・OK!
/var/www/html/OCR_20170820

http://153.126.154.106/OCR_20170820/20170821_list.php

$sql4 = ‘select * from OCR_t_20170821’;

$sql4 = ‘select * from OCR_t_20170821 ORDER BY id DESC’;

以上