请教前辈关于ARRAY()的疑问 while(list($key,$val)=each($rs)) { $data3y[] = $val;} 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $query=@mssql_query("SELECT MYDB123 FROM TABLE123 WHERE (TA002 = '940401') " );while(list($datay[]) = mssql_fetch_row($query)); /********************** 用这样的方式不行 ~@_@~ ***************/$query=@mssql_query("SELECT MYDB123 FROM TABLE123 WHERE (TA002 = '940401')" );$rs = mssql_fetch_row($query);while(list($data3y[]) = mssql_fetch_row($query)); [0] => 79.9 [1] => 69.1 [2] => 72.9 [3] => 81.7 [4] => 66.4 [5] => 71.6 [6] => 71.0 /********************* 用这样的方式可以 -_-!! *********************/$data3y =array(68.4,23.5,23.0,44,67,87,90) ; [0] => 68.4 [1] => 23.5 [2] => 23.0 [3] => 44 [4] => 67 [5] => 87 [6] => 90/***********************************************到底为什么????????? 肯定可以直接赋值的 $data3y = $rs把两个变量打印出来看看print_r($data3y);print_r($rs); 小弟也将图拷贝下来了不过要传到哪里啊…没地方放-_-...<?php// 数据资料$servername="127.0.0.1"; /*** MS SQL DB ***/$username="oscar";$password="abcdefg";$dbname="MYDB";$conn=mssql_connect($servername,$username,$password);mssql_select_db($dbname);$query=@mssql_query("SELECT MYDB123 FROM TABLE123 WHERE (TA002 = '940401') " );$rs = mssql_fetch_row($query);while(list($data3y[]) = mssql_fetch_row($query));$datay =array(68,23,23,44,67,87,90,23,44,55,32,54,38,90,100,112,121,98,95,87,90,23,44,55,32,54,38,33,43) ; //红点ECHO "=================================== Var Debug Star ==================================="; Ob_Start(); Session_Start(); Echo "<pre>"; Echo "本页得到的_ARRAY变数有:"; Print_R($data3y); Print_R($datay); ?>=================================== Var Debug Star ===================================本页得到的_ARRAY变数有:Array( [0] => 79.9 [1] => 69.1 [2] => 72.9 [3] => 81.7 [4] => 66.4 [5] => 71.6 [6] => 71.0 [7] => 81.0 [8] => 74.0 [9] => 74.7 [10] => 73.5 [11] => 71.4 [12] => 71.1 [13] => 70.3 [14] => 67.3 [15] => 65.4 [16] => 67.1 [17] => 73.5 [18] => 68.7 [19] => 69.3 [20] => 66.7 [21] => 60.3 [22] => 62.0 [23] => 68.8 [24] => 73.2 [25] => 72.3 [26] => 68.8 [27] => 69.6 [28] => 70 [29] => 72.3 [30] => 64 [31] => 89.2 [32] => 64 [33] => 66.3 [34] => 69 [35] => 62.1 [36] => 63.3 [37] => 71.4 [38] => 69.4 [39] => 71 [40] => 76.1 [41] => 79.5 [42] => 65.4 [43] => 68.4 [44] => )Array( [0] => 68 [1] => 23 [2] => 23 [3] => 44 [4] => 67 [5] => 87 [6] => 90 [7] => 23 [8] => 44 [9] => 55 [10] => 32 [11] => 54 [12] => 38 [13] => 90 [14] => 100 [15] => 112 [16] => 121 [17] => 98 [18] => 95 [19] => 87 [20] => 90 [21] => 23 [22] => 44 [23] => 55 [24] => 32 [25] => 54 [26] => 38 [27] => 33 [28] => 43) 喔!!我终于发现了问题所在,数据库中的字段属性原先是CHAR把它改成Float或Int就能够解决问题。希望未来有使用jpgraph-1.17的朋友要注意,但是数组中有分字符串或数值吗???那如果不改数据库的属性,而要从PHP下手的话又该如何将数组中的值强迫改成数值(Float)呢??? 自己推while(list($data3yTemp[]) =mssql_fetch_row($query));foreach ( $data3yTemp as $keyn => $val ){ $data3y[] =(float) $val ; } 输出XML时大于小于号问题 各位大大,能推荐些好书么? PHP显示MSSQL时间,显示不正确怎么办? 求推荐SEO优化知名站点、技术文章及书! 懂LINUX的过来看看: 怎么建一个svn用户? 代码安全隐患(散分) 求iconv的替代函数 ob_end_clean 出错了,求教!!! 关于网站制作方面的英语文章 gd库的问题 我想找个PHP的SESSION实现的购物车的类 请问日期问题
while(list($datay[]) = mssql_fetch_row($query));
/********************** 用这样的方式不行 ~@_@~ ***************/
$query=@mssql_query("SELECT MYDB123 FROM TABLE123 WHERE (TA002 = '940401')" );
$rs = mssql_fetch_row($query);
while(list($data3y[]) = mssql_fetch_row($query)); [0] => 79.9
[1] => 69.1
[2] => 72.9
[3] => 81.7
[4] => 66.4
[5] => 71.6
[6] => 71.0
/********************* 用这样的方式可以 -_-!! *********************/
$data3y =array(68.4,23.5,23.0,44,67,87,90) ;
[0] => 68.4
[1] => 23.5
[2] => 23.0
[3] => 44
[4] => 67
[5] => 87
[6] => 90
/***********************************************
到底为什么?????????
把两个变量打印出来看看
print_r($data3y);
print_r($rs);
$servername="127.0.0.1"; /*** MS SQL DB ***/
$username="oscar";
$password="abcdefg";
$dbname="MYDB";
$conn=mssql_connect($servername,$username,$password);
mssql_select_db($dbname);
$query=@mssql_query("SELECT MYDB123 FROM TABLE123 WHERE (TA002 = '940401') " );
$rs = mssql_fetch_row($query);while(list($data3y[]) = mssql_fetch_row($query));$datay =array(68,23,23,44,67,87,90,23,44,55,32,54,38,90,100,112,121,98,95,87,90,23,44,55,32,54,38,33,43) ; //红点
ECHO "=================================== Var Debug Star ===================================";
Ob_Start();
Session_Start();
Echo "<pre>";
Echo "本页得到的_ARRAY变数有:";
Print_R($data3y);
Print_R($datay);
?>=================================== Var Debug Star ===================================
本页得到的_ARRAY变数有:Array
(
[0] => 79.9
[1] => 69.1
[2] => 72.9
[3] => 81.7
[4] => 66.4
[5] => 71.6
[6] => 71.0
[7] => 81.0
[8] => 74.0
[9] => 74.7
[10] => 73.5
[11] => 71.4
[12] => 71.1
[13] => 70.3
[14] => 67.3
[15] => 65.4
[16] => 67.1
[17] => 73.5
[18] => 68.7
[19] => 69.3
[20] => 66.7
[21] => 60.3
[22] => 62.0
[23] => 68.8
[24] => 73.2
[25] => 72.3
[26] => 68.8
[27] => 69.6
[28] => 70
[29] => 72.3
[30] => 64
[31] => 89.2
[32] => 64
[33] => 66.3
[34] => 69
[35] => 62.1
[36] => 63.3
[37] => 71.4
[38] => 69.4
[39] => 71
[40] => 76.1
[41] => 79.5
[42] => 65.4
[43] => 68.4
[44] =>
)
Array
(
[0] => 68
[1] => 23
[2] => 23
[3] => 44
[4] => 67
[5] => 87
[6] => 90
[7] => 23
[8] => 44
[9] => 55
[10] => 32
[11] => 54
[12] => 38
[13] => 90
[14] => 100
[15] => 112
[16] => 121
[17] => 98
[18] => 95
[19] => 87
[20] => 90
[21] => 23
[22] => 44
[23] => 55
[24] => 32
[25] => 54
[26] => 38
[27] => 33
[28] => 43
)
我终于发现了问题所在,数据库中的字段属性原先是CHAR把它改成Float或Int就能够解决问题。
希望未来有使用jpgraph-1.17的朋友要注意,但是数组中有分字符串或数值吗???
那如果不改数据库的属性,而要从PHP下手的话又该如何将数组中的值强迫改成数值(Float)呢???
while(list($data3yTemp[]) =mssql_fetch_row($query));
foreach ( $data3yTemp as $keyn => $val )
{ $data3y[] =(float) $val ; }