这个PHP代码在做什么？ [英] What is this php code doing?

问题描述

你好，有人可以提前向我解释代码!!

[PHP]

<？php

$ temp = " ;;


$ sqlconnect = mysql_connect（" localhost"，" hyperian_tr ack"，" __ munged __"）;

if（！ $ sqlconnect）

die（mysql_error（））;

mysql_select_db（" hyperian_track"，$ sqlconnect）;



if（$ _ GET [''postal'']））


$ postalcode = substr（$ _ GET [''postal'']，0,2）; //将从0位置返回2个字符


$ resultpostal = mysql_query（" SELECT startlat，endlat，startlng，endlng FROM zones

WHERE districtno = $邮递区号"）; //获取startlat，endlat，startlng，endlng of location


while（$ row = mysql_fetch_array（$ resultpostal））

{

$ temp [] = $ row; //将每条记录存储在一个数组中

}



$ resultname = mysql_query（" SELECT uname FROM location，district

WHERE location.lat< districts.startlat AND location.lat> districts.endlat AND location.lng< districts.startlng

AND location.lng>区.endlng"）;


while（$ row = mysql_fetch_array（$ resultname））

{

$ temp [] = $ row;

}



foreach（$ temp as $ key => $ extract）

$ reportname = $ reportname。$ key。" ="。$ extract。"&";


echo''& reportname&'';

} // if循环结束



mysql_close（$ con）;




[/ PHP]

解决方案

temp ="" ;;

sqlconnect = mysql_connect（" localhost"，" hyperian_tr ack"，" __ munged __& ;）;

if（！

sqlconnect）

die（mysql_error（））;

mysql_select_db（" hyperian_track"，

Hello can somebody explain the code to me thx in advance!!
[PHP]
<?php
$temp="";

$sqlconnect=mysql_connect("localhost","hyperian_tr ack","__munged__");
if(!$sqlconnect)
die(mysql_error());
mysql_select_db("hyperian_track", $sqlconnect);


if($_GET[''postal'']))

$postalcode=substr($_GET[''postal''],0,2); //will return from 0 position 2 characters

$resultpostal=mysql_query("SELECT startlat,endlat,startlng,endlng FROM districts
WHERE districtno = $postalcode"); //get startlat,endlat,startlng,endlng of location

while($row = mysql_fetch_array($resultpostal))
{
$temp[]=$row; // store each record in an array
}



$resultname=mysql_query("SELECT uname FROM location,districts
WHERE location.lat < districts.startlat AND location.lat > districts.endlat AND location.lng < districts.startlng
AND location.lng > districts.endlng");

while($row = mysql_fetch_array($resultname))
{
$temp[]=$row;
}



foreach($temp as $key=>$extract)
$reportname=$reportname.$key."=".$extract."&";

echo ''&reportname&'';
}//end of if loops



mysql_close($con);



[/PHP]

解决方案

temp="";

sqlconnect=mysql_connect("localhost","hyperian_tr ack","__munged__");
if(!

sqlconnect)
die(mysql_error());
mysql_select_db("hyperian_track",

这篇关于这个PHP代码在做什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！