How to make multiple MySQL connections from PHP

Question

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'

<?php

$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 "<h1>Table: 'flights'</h1>";
echo "<table border='1'><tr>";


while($row = mysql_fetch_row($result))
{
    echo "<tr>";

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

    echo "</tr>\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 "<h1>Table: 'isb to murree'</h1>";
echo "<table border='1'><tr>";


while($row = mysql_fetch_row($result))
{
    echo "<tr>";

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

    echo "</tr>\n";

}
}
}
}


mysqli_close($con);
?>

score 2 · Answer 1 · edited May 23 '17 at 11:57

Enclose the table name in backticks (`) instead of single quotes ('):

SELECT * FROM `isb to murree`

To avoid this and other problems in the future, always enclose schema, table, and column names in backticks to distinquish them from data and MySQL keywords. Consider using table names without spaces for easier handling.

As Fred noted, your code is using two database APIs: mysql_* and mysqli_* . In general, the two do not mix well. Consider upgrading all of your code to use mysqli_* or PDO. See Deprecated features in PHP 5.5.x and Why are PHP's mysql_ functions deprecated? for mysql_* deprecation notes.

+1 Yes, indeed. Just an added note, OP is mixing APIs with `mysqli_close($con);` — Funk Forty Niner, Aug 26 '14 at 19:47

score 0 · Accepted Answer · answered Aug 26 '14 at 19:56

0

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';

answered Aug 26 '14 at 19:56

Billy

165
6

yes now its working for the three elseif conditions but not for the 4th one..syntax is same . what should be the problem?? @billy – user3909877 Aug 27 '14 at 18:38
Double check your if statements. – Billy Aug 27 '14 at 19:25
And check your inputs, murree is lowercase where Lahore is title case. – Billy Aug 27 '14 at 19:29
yess they are okay.. elseif ( $from =='Lahore'){ if($To == 'Islamabad'){ @billy – user3909877 Aug 27 '14 at 19:41
in this part its diverted now from Lahore to Islamabad... @billy – user3909877 Aug 27 '14 at 19:45

How to make multiple MySQL connections from PHP

2 Answers2