How to make multiple MySQL connections from PHP

The code below is working for one if statement but not giving results for another else if and it is showing the 'flights' table in first query but after another condition not display the other table named 'isb to muree'

$from =  isset($_POST['from'])?$_POST['from']:'';
 $To = isset($_POST['To'])?$_POST['To']:'';


 if( $from =='Islamabad'){
     if($To == 'Lahore'){


$db_host = 'localhost';
$db_user = 'root';

$database = 'homedb';
//$table = 'flights';


if (!mysql_connect($db_host, $db_user))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");
$result = mysql_query("SELECT * FROM flights");
if (!$result) {
    die("Query to show fields from table failed");
}




$fields_num = mysql_num_fields($result);

echo "
Table: 'flights'
";
echo "";


while($row = mysql_fetch_row($result))
{

    echo "";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "";

    echo "\n";
}
}


else if( $from =='Islamabad'){
     if($To == 'murree'){
if (!mysql_connect($db_host, $db_user))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

$result = mysql_query("SELECT * FROM 'isb to murree'");

if (!$result) {
    die("Query to show fields from table failed");
}
$fields_num = mysql_num_fields($result);

echo "
Table: 'isb to murree'
";
echo "
$cell
";


while($row = mysql_fetch_row($result))

{
    echo "";

    // $row is array... foreach( .. ) puts every element
    // of $row to $cell variable
    foreach($row as $cell)
        echo "";

    echo "\n";


}
}
}
}


mysqli_close($con);
?>

 
Answer
 


You should move the database connection variables to the top of your code (so they are outside of the if statement)

$db_host = 'localhost';
$db_user = 'root';
$database = 'homedb';

    


Subscribe to:
Post Comments (Atom)



c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...









analysis - Were parts of The Dark Knight Rises a commentary on the
Occupy movement? - Movies & TV
A fair amount of the second act of The Dark Knight Rises  has a class warfare plotline.  This is foreshadowed in the trailers with Selina Ky...





Detect whether a Python string is a number or a letter
        How can I detect either numbers or letters in a string? I am aware you use the ASCII codes, but what functions take advantage of the...





javascript - Create multidimensional array from string
          I want to create an options array from a string. How can i create an array as {     width : 100,     height : 200 } from a string ...















Search This Blog



$cell