How to use this logic to apply to my code?

[Rocky86]

need help with this code currently I understand abit of what this code is doing but I need to make use of the same logic to send my data to actionscripts so how do I do it?

This is the code logic:
[PHP]
<?php

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

$fetched=mysql_query("SELECT * FROM location");

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

$names=sizeof($temp);
$report="total=$names&";

foreach($temp as $list)

$report.="name".$names--."=".$list."&";


echo $report;

mysql_close($con);


?>
[/PHP]

As you can see this part of the code is reallx confusing: $report.="name".$names--."=".$list."&"; but I want to do the same method so how do I do it in my code I need the uid and uname to be send to actionscript below is my code currently:
[PHP]
<?php
$temp="";




$sqlconnect=mysql_connect("localhost","hyperian_tr ack","gsmtrack");
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 location.uname,location.uid FROM location,districts WHERE districts.districtno = '".$postalcode."' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");

if($row = mysql_fetch_array($resultpostal))
{
$temp[]=$row[uid];
$temp1[]=$row[uname];
}



foreach($temp as $result)
$report.="

foreach($temp1 as $result)
$report.="

echo $report;



}//end of if loops



mysql_close($con);

[/PHP]

My code I created 2 temp to take in the uid and uname but how do I continue from this part here to send it to actionscripts?

foreach($temp as $result)
$report.="

foreach($temp1 as $result)
$report.="

echo $report;

[ronnil]

Your code is only supposed to print out 1 users information, is that correct?

your code would look like

$report = 'uid=' . $result[0] . '&uname=' . $result[1];

this will print out: uid=1&uname=somename

[Rocky86]

Your code is only supposed to print out 1 users information, is that correct?

your code would look like

$report = 'uid=' . $result[0] . '&uname=' . $result[1];

this will print out: uid=1&uname=somename

Yes it should just print out 1 users information so my code I edited it like that iszit correct do I need to make any changes?

[PHP]
<?php
$temp="";




$sqlconnect=mysql_connect("localhost","hyperian_tr ack","gsmtrack");
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 location.uname,location.uid FROM location,districts WHERE districts.districtno = '".$postalcode."' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");

if($row = mysql_fetch_array($resultpostal))
{
$temp[]=$row[uid];
$temp1[]=$row[uname];
}



foreach($temp as $result)
foreach($temp1 as $result)

$report ='uid='.$result[0].'&uname='.$result[1];



echo $report;



}//end of if loops



mysql_close($con);


[/PHP]

[Rocky86]

Is anyone around to help?

[Rocky86]

Is it reallx no one??????????

[dafodil]

I can't understand what's so hard about that, you are just trying to concatenate them.

I noticed your always asking us to explain this part of the code, when the code is really not that hard to understand. Maybe its time to learn them right? Logic is not taught its learned.
Are you always copying your code?

[Rocky86]

Why is my uname and uid undefined when I run the output on actionscriptS? It should show the uname and uid but instead it show me undefined anyone noe?
my code:

PHP Code:
[PHP]
<?php

$sqlconnect=mysql_connect("localhost","hyperian_tr ack","gsmtrack");
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 location.uname,location.uid FROM location,districts WHERE districts.districtno = '".$postalcode."' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");
if($row = mysql_fetch_array($resultpostal))
{
$temp[]=$row[uid];
$temp1[]=$row[uname];
}

foreach($temp as $result)
$report ='uid'."=".$result."&";
foreach($temp1 as $result1)
$report ='uname'."=".$result1."&";

echo $report;
mysql_close($con);


}
?>
[/PHP]

[dafodil]

$temp[]=$row[uid];
 $temp1[]=$row[uname];
 

check that part of your code...

You are trying to retrieve $row[uid] and $row[uname].
That should be a numeric value. It should go something like $row[0] and $row[1]. Make sure that $row is an array first. check arrays in php at http://w3schools.com/php/php_arrays.asp

I advice you not to copy code. How can you learn by that. Copy them if you really understand them. That's an advice its up to you if you want to learn.

[Rocky86]

$temp[]=$row[uid];
 $temp1[]=$row[uname];
 

check that part of your code...

You are trying to retrieve $row[uid] and $row[uname].
That should be a numeric value. It should go something like $row[0] and $row[1]. Make sure that $row is an array first. check arrays in php at http://w3schools.com/php/php_arrays.asp

I advice you not to copy code. How can you learn by that. Copy them if you really understand them. That's an advice its up to you if you want to learn.

thx for the advice I only want to extact out the uname and uid from the array that is stored inside the variable $temp[] except I reallx gt no idea how to go about it doing that

[dafodil]

PHP Code:
[PHP]
<?php

$sqlconnect=mysql_connect("localhost","hyperian_tr ack","gsmtrack");
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 location.uname,location.uid FROM location,districts WHERE districts.districtno = '".$postalcode."' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");

$counterx=0;
while($row=mysql_fetch_array($resultpostal)){
foreach($row as $col_value){
$temp[$counterx]=$col_value;
$counterx++;
}

$report ='uid'."=".$temp[0]."&";
$report .='uname'."=".$temp[1]."&";



echo $report;
mysql_close($con);


}
?>
[/PHP][/quote]

edit it to fit to your problem. I gave the code already.....

[Rocky86]

PHP Code:
[PHP]
<?php

$sqlconnect=mysql_connect("localhost","hyperian_tr ack","gsmtrack");
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 location.uname,location.uid FROM location,districts WHERE districts.districtno = '".$postalcode."' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");

$counterx=0;
while($row=mysql_fetch_array($resultpostal)){
foreach($row as $col_value){
$temp[$counterx]=$col_value;
$counterx++;
}

$report ='uid'."=".$temp[0]."&";
$report .='uname'."=".$temp[1]."&";



echo $report;
mysql_close($con);


}
?>
[/PHP]

edit it to fit to your problem. I gave the code already.....[/quote]

Thank alot for your help !!!

[Rocky86]

dafodil mind if I ask why do you create a counter? $counterx=0;

[kovik]

dafodil mind if I ask why do you create a counter? $counterx=0;

Looks like it'd normalize the temporary array into a normal numerical array, but there are array functions that could simplify that a lot. However, seeing as you're always asking questions about the code, adding in a bunch of array functions would be counter-productive.

[Rocky86]

Correct me If I am wrong basically this code is
[PHP]
$counterx=0;
while($row=mysql_fetch_array($resultpostal)){
foreach($row as $col_value){
$temp[$counterx]=$col_value;
$counterx++;
}

$report.='uid'."=".$temp[0]."&";
$report.='uname'."=".$temp[1]."&"

[/PHP]

Creating a counterx first then store the whole $resultpostal inside row then foreach row as $col_value then the counterx will + 1 if there is a value to be store inside the $temp that mean in my case it will just increment 2 time as I only select the uid and uname correct?

Then bottom is sending the uid and uname to the actionscript erm am I correct?
Just trying to learn this code thx

[dafodil]

Correct me If I am wrong basically this code is
[PHP]
$counterx=0;
while($row=mysql_fetch_array($resultpostal)){
foreach($row as $col_value){
$temp[$counterx]=$col_value;
$counterx++;
}

$report.='uid'."=".$temp[0]."&";
$report.='uname'."=".$temp[1]."&"

[/PHP]

Creating a counterx first then store the whole $resultpostal inside row then foreach row as $col_value then the counterx will + 1 if there is a value to be store inside the $temp that mean in my case it will just increment 2 time as I only select the uid and uname correct?

Then bottom is sending the uid and uname to the actionscript erm am I correct?
Just trying to learn this code thx

Yes you can increment it only 2 times...
And remember when you want to retrieve what you had stored in
$temp[$counterx], you'll have to call it like this $temp[0] or $temp[1] beacuse it started with zero and incremented.
I'm glad that it helped you.

[Rocky86]

Yes you can increment it only 2 times...
And remember when you want to retrieve what you had stored in
$temp[$counterx], you'll have to call it like this $temp[0] or $temp[1] beacuse it started with zero and incremented.
I'm glad that it helped you.

Thank alot for your wonderful help thx thx

[Rocky86]

Guy need some help again basically this code right is returning my actionscript undefined value:
[PHP]
if($_GET['postal']))

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

$resultpostal=mysql_query("SELECT location.uname,location.uid FROM location,districts WHERE districts.districtno ='$postalcode' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");

[/PHP]

Mean that it is quite unable to get the postal code from actionscripts?
Then I did another test run like that


[PHP]
$resultpostal=mysql_query("SELECT location.uname,location.uid FROM location,districts WHERE districts.districtno ='56'AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");


[/PHP]

I change to districtno=56 and it does return me the uname but the problem is how come the top part the GET POSTAL section code always return me undefined value iszit something wrong with the GET method?

[Rocky86]

Anyone around to help?

[kovik]

You're code is really making less and less sense. What does "if($_GET['postal']))" do? Why are there two ending parentheses? Why aren't you using isset()?

[Rocky86]

You're code is really making less and less sense. What does "if($_GET['postal']))" do? Why are there two ending parentheses? Why aren't you using isset()?

I use the GET postal is to get the input postal code by the user from actionscripts and use php to extact out the first 2 value you mean something is wrong with the way I get the postal from acitonscriptS?

[Rocky86]

I don't think I can use the isset() function because I am taking a pass value from the actionscript and the isset() only works with variables as passing anything else will result in a parse error

[kovik]

I don't think I can use the isset() function because I am taking a pass value from the actionscript and the isset() only works with variables as passing anything else will result in a parse error

What? The PURPOSE of isset() is to check and see if the variable exists or not. Do you think that $_GET is not a variable?

[pbmods]

Heya, Rocky.

What do you want your code to do? Give an example.
What is your code doing that you don't want it to do? Give an example.
What is your code *not* doing that it is supposed to? Give an example.

[Rocky86]

Heya, Rocky.

What do you want your code to do? Give an example.
What is your code doing that you don't want it to do? Give an example.
What is your code *not* doing that it is supposed to? Give an example.

I want my code to be able to GET the postal from actionscript, the postal is a user input in actionscripts

My code is unable to GET the postal from the actionscripts

My code is suppoosed to get the postal number example 560894 and in PHP it will extact out the first 2 number which is 56 and store it inside a variable to compare it in the SQL statement and show the record that matches the 56 .

[kovik]

I want my code to be able to GET the postal from actionscript, the postal is a user input in actionscripts

My code is unable to GET the postal from the actionscripts

My code is suppoosed to get the postal number example 560894 and in PHP it will extact out the first 2 number which is 56 and store it inside a variable to compare it in the SQL statement and show the record that matches the 56 .

And in your ActionScript, you send this data through the URL?

[Rocky86]

And in your ActionScript, you send this data through the URL?

No is not throught URL is through PHP

My actionscripts:

postalOut.postal=assign.postal.text;
var postalOut:LoadVars = new LoadVars();
postalOut.sendAndLoad(passingurl, postalIn, "POST");
 

My PHP:
[PHP]
$postalno=substr($_POST['postal'],0,2);
$resultpostal=mysql_query("SELECT location.uname,location.uid FROM location,districts WHERE districts.districtno ='$postalno' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");

[/PHP]

I try both the GET and POST method it does not seen to work

[kovik]

I haven't done anything in ActionScript in a while... Try sending the variables to this test script and get the data:

[php]echo 'GET: ' . print_r($_GET, true) . "\n\n" . 'POST: ' . print_r($_POST, true);[/php]

That should show you if the requests are going through the way you think they are.

[Rocky86]

I haven't done anything in ActionScript in a while... Try sending the variables to this test script and get the data:

[php]echo 'GET: ' . print_r($_GET, true) . "\n\n" . 'POST: ' . print_r($_POST, true);[/php]

That should show you if the requests are going through the way you think they are.

Just want to know is this the correct way to put in a variable in SQL statement?
[PHP]
$postalno=$_GET["postal"];
$resultpostal=mysql_query("SELECT location.uname,location.uid FROM location,districts WHERE districts.districtno ='".$postalno."' AND
location.lat BETWEEN districts.startlat AND districts.endlat AND location.lng BETWEEN districts.startlng AND districts.endlng");
[/PHP]


WHERE districts.districtno ='".$postalno."'
or
WHERE districts.districtno ='$postalno'

[kovik]

WHERE districts.districtno ='".$postalno."'
or
WHERE districts.districtno ='$postalno'

Those are the exact same thing.

[pbmods]

Heya, Rocky.

Check out this document.