Displaying Data From A Drop Down List php

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • rose merry
    New Member
    • May 2015
    • 14
    #1

    Displaying Data From A Drop Down List php

    I'm trying hard with displaying details from a selected option in a drop down list for my project.

    I have a two dropdown list which is populated from a MYSQLi query. I want the user to select an option from two drop down list and the values associated pulled from the database table and displayed to the user.

    The dynamically populated drop down list is for "destinatio n" of routes(Table Name) and "arrival"(f rom routea table) when a user selects a destination and arrival from the drop down list I want the record of that another table(schedule) to be to be displayed.

    The code below is for dynamically populating the drop down list. The user clicks the button and goes on the next page which should create a table with the results. There is Error in my code......plz check this


    Choose Deparature :


    Code:
    	  <form action="" method="POST">
	  
        <p>
          <select name="departure">
            <option value="" selected="selected">-- Choose destination --</option>
             <option value="ABBOTTABAD">ABBOTTABAD</option>
              <option value="AHMED PUR EAST">AHMED PUR EAST</option>
              <option value="CHINIOT">CHINIOT</option>
              <option value="DASKA">DASKA</option>
          </select>
        </p>
        <p>Choose Arrival: </p>
        <p>
          
           <!--<form action="" method="POST"> -->
           <select name="arrival">
             <option value="" selected="selected">-- Choose Arrival --</option>
              <option value="DASKA">DASKA</option>
               <option value="CHINIOT">CHINIOT</option>
               <option value="AHMED PUR EAST">AHMED PUR EAST</option>
               <option value="ABBOTTABAD">ABBOTTABAD</option>
                    <option value="LAHORE">LAHORE</option>
           </select>
         </p>
        <p>   </br>
          <input name="submit" type="submit" value="Submit" />
          </p>
	  </form>

    <table width="754" border="1" id="table">

     <tr><th bgcolor="#00CCCC">Departure</th>
     <th bgcolor="#00CCCC">Arrival</th>
     <th bgcolor="#00CCCC">Departure time</th>
     <th bgcolor="#00CCCC">Arrival time</th>
	 <th bgcolor="#00CCCC">Fare</th>
	 <th bgcolor="#00CCCC">Bus type</th>
	 <th bgcolor="#00CCCC">Total seats</th>
	 <th bgcolor="#00CCCC">Status</th>

   </tr>
        <?php 
        mysql_connect('localhost','root',"") or die('Error1 '.mysql_error());

        mysql_select_db("bus_reservation1 (1)") or die('error2'.mysql_error());


          if($_SERVER['REQUEST_METHOD'] =='POST')
		  
		  //if(isset($_POST['Submit']))
     { 
	 $dep=$_POST['departure'];
	 $loc=$_POST['arrival'];
         $query="SELECT * FROM schedule WHERE Departure= '" . $dep . "' AND Arrival= '".$loc."' ";
		
		 
		 
         $run=mysql_query($query);
         $numrow = mysql_num_rows($run);


        while($row=mysql_fetch_array($run)){
                echo "<tr>
                        <td bgcolor='#87a310'>".$row['Departure']."</td>
                        <td bgcolor='#87a310'>".$row['Arrival']."</td>
                        <td bgcolor='#87a310'>".$row['Departure_time']."</td>
                        <td bgcolor='#87a310'>".$row['Arrival_time']."</td>
						<td bgcolor='#87a310'>".$row['Fare']."</td>
						<td bgcolor='#87a310'>".$row['Bus_type']."</td>
						<td bgcolor='#87a310'>".$row['Total Seats']."</td>
						<td bgcolor='#87a310'>".$row['Status']."</td>
					
                    </tr>"; 
            }
   
    }
    ?>
    </table>
    Last edited by Rabbit; May 31 '15, 04:32 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
    Tags: None
    • computerfox
      Contributor
      • Mar 2010
      • 276
      #2
      Hi Rose and welcome to Bytes.
      First, please use the code tags to indicate posted code.

      Looks like you were missing a bracket.
      Code:
      <form action="" method="POST">
<p>
<select name="departure">
<option value="" selected="selected">-- Choose destination --</option>
<option value="ABBOTTABAD">ABBOTTABAD</option>
<option value="AHMED PUR EAST">AHMED PUR EAST</option>
<option value="CHINIOT">CHINIOT</option>
<option value="DASKA">DASKA</option>
</select>
</p>
<p>Choose Arrival: </p>
<p>
<select name="arrival">
<option value="" selected="selected">-- Choose Arrival --</option>
<option value="DASKA">DASKA</option>
<option value="CHINIOT">CHINIOT</option>
<option value="AHMED PUR EAST">AHMED PUR EAST</option>
<option value="ABBOTTABAD">ABBOTTABAD</option>
<option value="LAHORE">LAHORE</option>
</select>
</p>
<p> </br>
<input name="submit" type="submit" value="Submit" />
</p>
</form>
<table width="754" border="1" id="table">
 <tr>
  <th bgcolor="#00CCCC">Departure</th>
  <th bgcolor="#00CCCC">Arrival</th>
  <th bgcolor="#00CCCC">Departure time</th>
  <th bgcolor="#00CCCC">Arrival time</th>
  <th bgcolor="#00CCCC">Fare</th>
  <th bgcolor="#00CCCC">Bus type</th>
  <th bgcolor="#00CCCC">Total seats</th>
  <th bgcolor="#00CCCC">Status</th>
 </tr>
<?php
 mysql_connect('localhost','root',"") or die('Error1 '.mysql_error());
 mysql_select_db("bus_reservation1 (1)") or die('error2'.mysql_error());
 if($_SERVER['REQUEST_METHOD'] =='POST'){
  $dep=$_POST['departure'];
  $loc=$_POST['arrival'];
  $query="SELECT * FROM schedule WHERE Departure= '$dep' AND Arrival= '.$loc'";
  $run=mysql_query($query);
  $numrow = mysql_num_rows($run);
  while($row=mysql_fetch_array($run)){
   echo "<tr>
   <td bgcolor='#87a310'>".$row['Departure']."</td>
   <td bgcolor='#87a310'>".$row['Arrival']."</td>
   <td bgcolor='#87a310'>".$row['Departure_time']."</td>
   <td bgcolor='#87a310'>".$row['Arrival_time']."</td>
   <td bgcolor='#87a310'>".$row['Fare']."</td>
   <td bgcolor='#87a310'>".$row['Bus_type']."</td>
   <td bgcolor='#87a310'>".$row['Total Seats']."</td>
   <td bgcolor='#87a310'>".$row['Status']."</td>
   </tr>";
  }
 }
?>
</table>

        Comment

        • rose merry
          New Member
          • May 2015
          • 14
          #3
          sorry i forgot it.......

            Comment

            • computerfox
              Contributor
              • Mar 2010
              • 276
              #4
              It happens....
              It's usually the tiny details (either a bracket or semicolon).
              Please mark the other post as the answer. Thank you.

                Comment

                • rose merry
                  New Member
                  • May 2015
                  • 14
                  #5
                  Code:
                  <form action="" method="POST">
	  
        <p>
          <select name="departure">
            <option value="" selected="selected">-- Choose destination --</option>
             <option value="ABBOTTABAD">ABBOTTABAD</option>
              <option value="AHMED PUR EAST">AHMED PUR EAST</option>
              <option value="CHINIOT">CHINIOT</option>
              <option value="DASKA">DASKA</option>
          </select>
        </p>
        <p>Choose Arrival: </p>
        <p>
          
           <!--<form action="" method="POST"> -->
           <select name="arrival">
             <option value="" selected="selected">-- Choose Arrival --</option>
              <option value="DASKA">DASKA</option>
               <option value="CHINIOT">CHINIOT</option>
               <option value="AHMED PUR EAST">AHMED PUR EAST</option>
               <option value="ABBOTTABAD">ABBOTTABAD</option>
                    <option value="LAHORE">LAHORE</option>
           </select>
         </p>
        <p>   </br>
          <input name="submit" type="submit" value="Submit" />
          </p>
	  </form>

    <table width="754" border="1" id="table">

     <tr><th bgcolor="#00CCCC">Departure</th>
     <th bgcolor="#00CCCC">Arrival</th>
     <th bgcolor="#00CCCC">Departure time</th>
     <th bgcolor="#00CCCC">Arrival time</th>
	 <th bgcolor="#00CCCC">Fare</th>
	 <th bgcolor="#00CCCC">Bus type</th>
	 <th bgcolor="#00CCCC">Total seats</th>
	 <th bgcolor="#00CCCC">Status</th>

   </tr>
        <?php 
        mysql_connect('localhost','root',"") or die('Error1 '.mysql_error());

        mysql_select_db("bus_reservation1 (1)") or die('error2'.mysql_error());


          if($_SERVER['REQUEST_METHOD'] =='POST')
		  
		  //if(isset($_POST['Submit']))
     { 
	 $dep=$_POST['departure'];
	 $loc=$_POST['arrival'];
         $query="SELECT * FROM schedule WHERE Departure= '" . $dep . "' AND Arrival= '".$loc."' ";
		
		 
		 
         $run=mysql_query($query);
         $numrow = mysql_num_rows($run);


        while($row=mysql_fetch_array($run)){
                echo "<tr>
                        <td bgcolor='#87a310'>".$row['Departure']."</td>
                        <td bgcolor='#87a310'>".$row['Arrival']."</td>
                        <td bgcolor='#87a310'>".$row['Departure_time']."</td>
                        <td bgcolor='#87a310'>".$row['Arrival_time']."</td>
						<td bgcolor='#87a310'>".$row['Fare']."</td>
						<td bgcolor='#87a310'>".$row['Bus_type']."</td>
						<td bgcolor='#87a310'>".$row['Total Seats']."</td>
						<td bgcolor='#87a310'>".$row['Status']."</td>
					
                    </tr>"; 
            }
   
    }
    ?>
    </table>
                  Last edited by Rabbit; Jun 1 '15, 03:51 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data. Second warning.

                    Comment

                    • rose merry
                      New Member
                      • May 2015
                      • 14
                      #6
                      DROP DOWN LIST CODE


                      Code:
                      <!DOCTYPE>
<html>
<head>
<title>Update Data</title>
</head>
<body>
<form name="form_update" method="post" action="update_test.php">
<?php
$con=mysqli_connect("localhost","root","","ismat_db");
//============== check connection
if(mysqli_errno($con))
{
    echo "Can't Connect to mySQL:".mysqli_connect_error();
}
else
{
    echo "Connected to mySQL</br>";
}
//=============================
//This creates the drop down box
echo "<select name= 'FirstName'>";
echo '<option value="">'.'--- Please Select Person ---'.'</option>';
//$query=mysqli_query($con,"SELECT id,FirstName FROM persons");
$query = mysqli_query($con,"SELECT FirstName FROM persons");
$query_display = mysqli_query($con,"SELECT * FROM persons");
while($row=mysqli_fetch_array($query))
{
    echo "<option value='". $row['id']."'>".$row['FirstName']
 .'</option>';
}
echo '</select>';
?> <input type="submit" name="submit" value="Submit"/>
</form>
<br/><br/>
<a href="main.html"> Go back to Main Page </a>
</body>
</html>
                      Last edited by Rabbit; Jun 1 '15, 03:51 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data. Second warning.

                        Comment

                        • rose merry
                          New Member
                          • May 2015
                          • 14
                          #7
                          Display View CodE


                          Code:
                          <!DOCTYPE>
<html>
<head>
<title>Update Data</title>
</head>
<body>
<!--<table>
<tr>
    <td align="center"> From Database </td>
</tr>
<tr>
    <td>
        <table border="1">
            <tr>
                <td>First Name</td>
                <td>Last Name </td>
                <td> Gender </td>
                <td> Subject </td>
                <td> Hobbies </td>
            </tr>
-->
<?php 
$con=mysqli_connect("localhost","root","","ismat_db");
if(mysqli_errno($con))
{
    echo "Can't Connect to mySQL:".mysqli_connect_error();
}
//$name = mysqli_real_escape_string($con,$_POST['select']);
//  $fetch = mysqli_query($con,"SELECT * FROM persons WHERE FirstName='".$name."'");
//  $row_display=mysqli_fetch_assoc($fetch);
if(isset($_POST['FirstName']))
{
$name = $_POST['FirstName'];
//$name = mysqli_real_escape_string($con,$_POST['select']);
//$fetch = "SELECT * FROM persons WHERE FirstName = '".$name."'";
//$fetch="SELECT 'Firstname' FROM persons WHERE Firstname = '".$name."'";
$fetch="SELECT Firstname FROM persons WHERE Firstname = '".$name."'";
$result = mysqli_query($con,$fetch);
if(!$result)
{
echo "Error:".(mysqli_error($con));
}
//display the table
echo '<table border="1">'.'<tr>'.'<td align="center">'. 'From Database'. '</td>'.'</tr>';
echo '<tr>'.'<td>'.'<table border="1">'.'<tr>'.'<td>'.'First Name'.'</td>'.'<td>'.'Last Name'.'</td>'.'<td>'. 'Gender' .'</td>'.'<td>'. 'Subject'. '</td>'.'<td>'. 'Hobbies' .'</td>'.'</tr>';
//while($data = mysqli_fetch_row($fetch))
while($data=mysqli_fetch_row($result))  
    {
    echo ("<tr><td>$data[0]</td><td>$data[1]</td><td>$data[2]</td><td>$data[3]</td><td>$data[4]</td></tr>");
    }
echo '</table>'.'</td>'.'</tr>'.'</table>';
}
?>
<!--</table>
</td>
</tr>
</table>-->
<br/>
<a href="update.php"> Go back to Main Page </a>
</body>
</html>
                          Last edited by Rabbit; Jun 1 '15, 03:51 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data. Second warning.

                            Comment

                            • rose merry
                              New Member
                              • May 2015
                              • 14
                              #8
                              Here data is fetch from same table ......but i want to fetch data from another table......base d on FIRSTNAME selected.....

                                Comment

                                • computerfox
                                  Contributor
                                  • Mar 2010
                                  • 276
                                  #9
                                  Please use code tags.
                                  Try changing the table name?

                                  FYI:

                                  Code:
                                  mysql_query("select* from persons where firstname='$firstname'");
                                  would get you all the data from persons based on the first name.

                                  Also, for the possible future, please make the additional questions separate threads.

                                    Comment

                                    Previous template Next
                                    Working...