Form to retrieve data is not working.

[leftseater93]

<fieldset>
       <legend>Retrieve a Flight Plan</legend>
       Flight Number: <input name="fltnum" maxlength="8" type="text"/><em>(AFA/####) or (PAY/####)</em><br />
       <p align="center"><input type="submit" align="center" value="Retrieve this Flight Plan" /></p>
       </fieldset>
       </form>
       <?php

        if (isset($_POST['submit'])) {

        //connect to the database
        $con = mysql_connect('mysql7.**********.com', 'a*****n', 'T*****9');
        if (!con)
        {
            die('Could not connect: ' . mysql_error());
        }

        mysql_select_db("a*****d", $con);

        $query = "SELECT * FROM fltplans WHERE fltnum = '$fltnum'";
        $result = mysql_query($query) or die('error getting data');

        echo "<table border='1'><tr><th>Flight Number</th></tr><tr><th>Departure ICAO</th><th>Departure Airport</th></tr>";

        while($row = mysql_fetch_array($result))
        {
            echo "<tr><td>";
            echo $row['fltnum'];
            echo "</td><td>";
            echo $row['dep'];
            echo "</td><td>";
            echo $row['depname'];
            echo "</td></tr>";
        }
        echo "</table>";
        }
   ?>

I don't get any errors. It just does nothing.

Try it yourself

www.afafpd.netii.net/db/database.php

Use AFA/120 as the serch term

[Weedpacket]

Where is $fltnum defined?

[sneakyimp]

Yeah you refer to $fltnum in your query without ever defining it.

You also run all your database commands without checking to see if they even work. You should check the result of every database command to see if it worked rather than just assuming it works.

[leftseater93]

Thank You to everybody who reply but I edited the code to output something a little bit more simpler. But of course I made the same mistake and I dont know how to fix it. Plz help:

<?php
            //If the submit butten is pressed then submit this form
            if(isset($_POST['submit'])) {
            //connect to the database
            $con = mysql_connect('host', 'user', 'pass');
            if (!con)
            {
                die('Could not connect: ' . mysql_error());
            }
            //connect to the database
            mysql_select_db("a5263571_fpd", $con);


        $query = "SELECT * FROM fltplans WHERE fltnum = '$fltnum'";
        $result = mysql_query($query) or die('error getting data');

        while($row = mysql_fetch_array($result))
        {                
           $fltnum = $row['fltnum'];
           $dep = $row['dep'];
           $depname = $row['depname'];
           $arr = $row['arr'];
           $arrname = $row['arrname'];
           $cat = $row['cat'];
           $flttime = $row['flttime'];
           $fltplan = $row['fltplan'];
           $comment = $row['comment'];

        echo "Here is you flight plan as requested. Thank You for using the AFAFPD";
        echo "Flight Number: $fltnum";
        echo "Departure ICAO: $dep Departure Airport: $depname";
        echo "Arrival ICAO: $arr Arrival Airport: $arrname";
        echo "Category: $cat &nbsp Estimated Flight Time: $flttime";
        echo "Flight Plan:";
        echo "$fltplan";
        echo "$comment";
        }}
?>

[dagon]

perhaps you need to add:

$fltnum=mysql_real_escape_string($_POST[fltnum]);

[traq]

in your original post, you show (part of?) the html form:

<input type="submit" align="center" value="Retrieve this Flight Plan" />

...your submit button is not named, so:

isset($_POST['submit'])

will always be false, and nothing will happen.

if that is the submit button you're looking for, change it to:

<input name="submit" type="submit" align="center" value="Retrieve this Flight Plan" />

also, in addition to the $fltnum issue mentioned above, you check for your DB connection like so:

$con = mysql_connect('mysql7.**********.com', 'a*****n', 'T*****9');
if(!con)
// forgot the $ !
if(!$con)

[sneakyimp]

This line looks like a problem:

	$query = "SELECT * FROM fltplans WHERE fltnum = '$fltnum'";

As Weedpacket and I pointed out originally, you refer to a variable $fltnum without having defined it it. It's going to be empty and likely will cause an error.

[leftseater93]

sneakyimp;10993888 wrote:

This line looks like a problem:

	$query = "SELECT * FROM fltplans WHERE fltnum = '$fltnum'";

As Weedpacket and I pointed out originally, you refer to a variable $fltnum without having defined it it. It's going to be empty and likely will cause an error.

So how do I define it?

[sneakyimp]

That's up to you. Here's one way:

$fltnum = "some value";

If you don't know what a variable is, you should probably do some basic php tutorials first.

[leftseater93]

Disregard.

Thank You for all your help. It is much appreciated.

Happy New Year