Topic: What is the proper way?

[Steve]

like shift the headers left so they alignb with the beginning of the data

[Mike]

Code: [Select]

th
{
  text-align: left;
}


[Steve]

oh duh me. You would think after all the months spent coding myspace layouts something like this would just occur to me.

[Steve]

No effect on it at all. Tried right for a test as well and no change.

[Steve]

Ok i got it working.

[Steve]

How can i pass information from a php file back to the referring html file? I take the input from the form, and pass it to the php file where the results are found and filtered, but then it needs to go back to the html to be printed out in the td. Would i just do it all in the html file?

Like i know i have seen php forms where they call themselves in the action but thats in a php file. IIRC i can run any php inside an html page by using <?php the code here?> like for example maybe action=" <?php call itsself here ?>"  ? I'm just not sure how to get the data results back to echoing them out in the td.

I'm also concerned that doing it all in the html file increases the discovery of directory's and table information with the view source. Not that you couldnt use VS, get the php target file, and then call it directly but it just seems "half ass"

[ober]

You really aren't getting the whole transfer data thing.

Set the action of the form to the same page.  Set your method to "post".  When you submit the form, the page will submit to itself and all the data will be in the $_POST array so you reference everything from $_POST['variable'].

You cannot execute php from a .html or .htm file unless the server is setup to parse those through the PHP engine.  You can combine HTML and PHP in the same page very easily.  Just jump in and out of the PHP tags.

I'm starting to get the feeling you're really not doing this right.

[Steve]

Set the action of the form to the same page.  Set your method to "post".  When you submit the form, the page will submit to itself and all the data will be in the $_POST array so you reference everything from $_POST['variable'].

Thats exactly what i was getting at. So i can do it this way, thanks

[Mike]

To go along with what ober said here is my general setup for pages:

Code: [Select]

<?php

/* Common Data */

if (isset($_REQUEST['submit']))
{
  /* Process */
  showresults();
  die;
}
showform();

function showform()
{
?>
<!-- Header stuff -->
<form action="file.php?submit" method="post">
<!-- Form Stuff -->
</form>
<!-- Footer Stuff -->
<?php
}

function showresults()
{
  /* Show the results */
}


[Steve]

Thats exactly what i did. Im bad at explaining what im trying to do but you and ober hit right on what i was trying to say. I have been going back and forth by jumping in and out of php tags. I just wasnt sure if i could post to itsself the way i wanted. Now im just trying to get the results to return properly i have something out of order or typod somewhere.

[Steve]

I wrote my own setup to take in a user supplied zip code, and radius, and then return the results based on that. I used a modified version of the google maps function in regards to finding results based on that input. Its flagging

Code: [Select]

while ($event = mysql_fetch_assoc($locresult))
So im thinking i did something wrong in the query. Im thinking i am wrong in the use of '>' and '<' but i have seen a few online done just like mine.

Code: [Select]

$locresult = sprintf("SELECT lat, lng FROM asa_registered_clubs WHERE lat < '$Highlat' AND Lat > '$Lowlat'
   AND lng > '$Lowlng' AND Longitude < '$Highlng'",
   mysql_real_escape_string($Highlat),
   mysql_real_escape_string($Lowlat),
   mysql_real_escape_string($$Lowlng),
   mysql_real_escape_string($Highlng));
Full code section:

Code: [Select]

<?php

$radius = $_GET["radiusSelect"];
$zip = $_GET["zip"];

$query = "SELECT zip FROM asa_registered_clubs WHERE zip='$zip'";
$result = mysql_query($query);

if (!$result)
die('Error');

$lat = $row['lat'];
$lng = $row['lng'];

$latRange = $radius / ((6076 / 5280) * 60);
$lngRange = $radius / (((cos($lat * 3.141592653589 / 180) * 6076.) / 5280.) * 60);

$Lowlat = $lat - $latRange;
$Highlat = $lat + $latRange;
$Lowlng = $lng - $lngRange;
$Highlnge = $lng + $lngRange;

$locresult = sprintf("SELECT lat, lng FROM asa_registered_clubs WHERE lat < '$Highlat' AND Lat > '$Lowlat' 
   AND lng > '$Lowlng' AND Longitude < '$Highlng'",
   mysql_real_escape_string($Highlat),
   mysql_real_escape_string($Lowlat),
   mysql_real_escape_string($$Lowlng),
   mysql_real_escape_string($Highlng)); 




if (mysql_num_rows($result) == 0)
{
echo '<div>No events</div>';
return;
}


echo '
<table>
<tr>
<th>When</th>
<th>Who</th>
<th>What</th>
<th>Where</th>
</tr>';


while ($event = mysql_fetch_assoc($locresult))
{
echo '
<tr>
<td>', $event['date'], ' ', $event['time'], '</td>
<td class="name">
', $event['clubgroupname'], '
<td class="event">
', $event['event'], '
<td class="where">
', $event['city'], ' 
</td>
</tr>';
}

echo '
</table>';

mysql_free_result($result);
mysql_free_result($locresult);
?>

[Perspective]

>AND Longitude < '$Highlng'",

should that be lng ?

[Steve]

man this might be the ugliest code i ever wrote i got fuckups all over this bitch.

Damn warning thingy. Yea thats one of many. i have GET instead of POST too.

[Steve]

Correcting the obvious errors and adding '@' to the while statement (like the google code) removed the errors but its not passing a result. Form is posting properly, im just missing something. I wanted to post updated code to show im completely retarded. Going to keep working at it till i figure it out.

Code: [Select]

<?php

$radius = $_POST["radiusSelect"];
$zip = $_POST["zip"];

$query = "SELECT zip FROM asa_registered_clubs WHERE zip='$zip'";
$result = mysql_query($query);

if (!$result)
die('Error');

$lat = $row['lat'];
$lng = $row['lng'];

$latRange = $radius / ((6076 / 5280) * 60);
$lngRange = $radius / (((cos($lat * 3.141592653589 / 180) * 6076.) / 5280.) * 60);

$Lowlat = $lat - $latRange;
$Highlat = $lat + $latRange;
$Lowlng = $lng - $lngRange;
$Highlnge = $lng + $lngRange;

$locresult = sprintf("SELECT lat, lng FROM asa_registered_clubs WHERE lat < '$Highlat' AND Lat > '$Lowlat' 
   AND lng > '$Lowlng' AND lng < '$Highlng'",
   mysql_real_escape_string($Highlat),
   mysql_real_escape_string($Lowlat),
   mysql_real_escape_string($$Lowlng),
   mysql_real_escape_string($Highlng)); 




if (mysql_num_rows($result) == 0)
{
echo '<div>No events</div>';
return;
}


echo '
<table>
<tr>
<th>When</th>
<th>Who</th>
<th>What</th>
<th>Where</th>
</tr>';


while ($event = @mysql_fetch_assoc($locresult))
{
echo '
<tr>
<td>', $event['date'], ' ', $event['time'], '</td>
<td class="name">
', $event['clubgroupname'], '
<td class="event">
', $event['event'], '
<td class="where">
', $event['city'], ' 
</td>
</tr>';
}

echo '
</table>';

mysql_free_result($result);
//mysql_free_result($locresult);
?>

[Steve]

My flow makes no sense at all. My select statement for the zip is pointless. I'm taking a radius and then trying to pull lat and lang based on a zip but that isnt going to give me a list of results within a radius. I'm just plain way off. I need to scrap all of this and start over.