 |
|
จากตัวอย่างโค้ดครับ
<?
$objConnect = mysql_connect("127.0.0.1","root","1111") or die("Error Connect to Database");
$objDB = mysql_select_db("atsinfo");
$sql="SELECT * FROM realtime where GVin ='70-4822'";
mysql_query("SET NAMES UTF8");
$query = mysql_query($sql);
$totalrecord = mysql_num_rows($query);
$i=0;
$lat="";
$long="";
$name="";
While ($row=mysql_fetch_array($query)){
$i++;
if($i==$totalrecord){
$lat.= "\"".$row['GLat']."\"";
$long.= "\"".$row['GLon']."\"";
$gvin.= "\"".$row['GVin']."\"";
$gspeed.= "\"".$row['GSpd']."\"";
$gtime.= "\"".$row['GTime']."\"";
$ghead.= "\"".$row['GHead']."\"";
$gpip.= "\"".$row['GGPIP']."\"";
}else{
$lat.= "\"".$row['GLat']."\",";
$long.= "\"".$row['GLon']."\",";
$gvin.= "\"".$row['GVin']."\",";
$gspeed.= "\"".$row['GSpd']."\",";
$gtime.= "\"".$row['GTime']."\",";
$ghead.= "\"".$row['GHead']."\",";
$gpip.= "\"".$row['GGPIP']."\",";
}
}
?>
<? echo ($lat); ?><br/>
<? echo ($long); ?><br/>
<? echo ($ghead); ?><br/>
<?
for($a=1;$a <= $totalrecord;$a++)
{
if (($gpip[$a] & 1)==0)
{
$IGN[i]=false;
$MyStatus[i]=1;
$MyEvent[i]="จอดดับเครื่อง";
$Color[i]="Red";
}else
{
$IGN[i]=true;
if ($gspeed[$a]>0)
{
$MyStatus[i]=3;
$MyEvent[i]="กำลังวิ่ง";
$Color[i]="Green";
}else
{
$MyStatus[i]=2;
$MyEvent[i]="จอดติดเครื่อง";
$Color[i]="Yellow";
}
if (($ghead[$a]>=0)&&($ghead[$a]<=15)){
$MyIDX[i]="0";
}else if (($ghead[$a]>15)&&($ghead[$a]<=30)){
$MyIDX[i]="1";
}else if (($ghead[$a]>30)&&($ghead[$a]<=45)){
$MyIDX[i]="2";
}else if (($ghead[$a]>45)&&($ghead[$a]<=60)){
$MyIDX[i]="3";
}else if(($ghead[$a]>60)&&($ghead[$a]<=75)){
$MyIDX[i]="4";
}else if (($ghead[$a]>75)&&($ghead[$a]<=90)){
$MyIDX[i]="5";
}else if (($ghead[$a]>90)&&($ghead[$a]<=105)){
$MyIDX[i]="6";
}else if (($ghead[$a]>105)&&($ghead[$a]<=120)){
$MyIDX[i]="7";
}else if (($ghead[$a]>120)&&($ghead[$a]<=135)){
$MyIDX[i]="8";
}else if(($ghead[$a]>135)&&($ghead[$a]<=150)){
$MyIDX[i]="9";
}else if (($ghead[$a]>150)&&($ghead[$a]<=165)){
$MyIDX[i]="10";
}else if (($ghead[$a]>165)&&($ghead[$a]<=180)){
$MyIDX[i]="11";
}else if (($ghead[$a]>180)&&($ghead[$a]<=195)){
$MyIDX[i]="12";
}else if (($ghead[$a]>195)&&($ghead[$a]<=210)){
$MyIDX[i]="13";
}else if(($ghead[$a]>210)&&($ghead[$a]<=225)){
$MyIDX[i]="14";
}else if (($ghead[$a]>225)&&($ghead[$a]<=240)){
$MyIDX[i]="15";
}else if (($ghead[$a]>240)&&($ghead[$a]<=255)){
$MyIDX[i]="16";
}else if (($ghead[$a]>255)&&($ghead[$a]<=270)){
$MyIDX[i]="17";
}else if (($ghead[$a]>270)&&($ghead[$a]<=285)){
$MyIDX[i]="18";
}else if (($ghead[$a]>285)&&($ghead[$a]<=300)){
$MyIDX[i]="19";
}else if (($ghead[$a]>300)&&($ghead[$a]<=315)){
$MyIDX[i]="20";
}else if (($ghead[$a]>315)&&($ghead[$a]<=330)){
$MyIDX[i]="21";
}else if (($ghead[$a]>330)&&($ghead[$a]<=345)){
$MyIDX[i]="22";
}else if ($ghead[$a]>345){
$MyIDX[i]="23";
}
$MyFile[i] = "Png/$Color[i]$MyIDX[i].png";
}
echo "\"".$MyStatus[i]."\",";
echo "\"".$MyEvent[i]."\",";
echo "\"".$Color[i]."\",";
echo "\"".$MyIDX[i]."\",";
echo "\"".$MyFile[i]."\",";
ผลออกมาคือค่า ทุกอย่างตรงตามที่คิวรี่ออก แต่ค่าตรงMyIDX[i] กลับเป็นศูนย์หมดเลยอะครับ
ตรง $MyFile[i] ผลที่แสดงออกมา ก็ซ้ำกันครับ
ไม่รู้ว่าผมแทนอักขระ หรือไวยากรณ์ผิดตรงไหนครับ รบกวนผุ้รู้ช่วยทีครับ ขอบคุณเป็นอย่างสูงครับ
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2010-12-17 00:22:11 |
By :
moobin29 |
View :
1164 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
