Home > Backend Development > PHP Tutorial > 初学者 问下PHP取出MYSQL数据,然后倒置顺序

初学者 问下PHP取出MYSQL数据,然后倒置顺序

WBOY
Release: 2016-06-13 12:14:31
Original
1057 people have browsed it

菜鸟 问下PHP取出MYSQL数据,然后倒置顺序
mysql数据


php代码:

$res_ip = mysql_query("select * from ip  order by id DESC limit 0,5");<br />while($row_ip = mysql_fetch_array($res_ip)){<br />    $ip_ip[] = intval($row_ip['ip']);<br />	$time_ip[] = date($row_ip['time']);<br />}<br />$data_ip = array(array("name"=>"IP流量","data"=>$ip_ip));<br />$data_ip = json_encode($data_ip);<br />$times_ip = json_encode($time_ip);<br />$times_ip = str_replace('2015-', '', $times_ip);
Copy after login


结果:
["01-25","01-25","01-24","01-23","01-22"]
Copy after login

[{"name":"IP\u6d41\u91cf","data":[12632220,12735020,127350,2213488,2348888]}]
Copy after login


想要的效果:
["01-22","01-23","01-24","01-25","01-26"]
Copy after login

[{"name":"IP\u6d41\u91cf","data":[2348888,2213488,127350,12735020,12632220]}]
Copy after login


说明: 就是相当于 把取出的最新5条数据,倒置过来。正常的取出来的5条最新数据是:5 4 3 2 1. 想要的是 1 2 3 4 5。 5 是最新的数据。

致谢!
------解决思路----------------------
id desc 改成 id asc 是不行的!
id desc 的本意是取最新数据,而 id asc 是取最旧的数据
要用 array_reverse 转置数组
$data_ip = array(array("name"=>"IP流量","data"=> array_reverse($ip_ip)));<br />$data_ip = json_encode($data_ip);<br />$times_ip = json_encode(array_reverse($time_ip));<br />$times_ip = str_replace('2015-', '', $times_ip);<br />
Copy after login

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template