Help With Php Mysql

[R3v07v3R]

Hi I am trying to pull data from a MySQL table but it keeps returning some of the PHP code instead of the results.

 

 

<?


$db_server = '127.0.0.1';
$db_usr = 'user123';
$db_pass = '123456';
$db_database = 'test';


$con = mysql_connect($db_server, $db_usr, $db_pass, $db_database);


if (!$con)
{
die('Could not connect: ' . mysql_error());
}


$query = "SELECT * FROM bookings WHERE `booking_start` <= NOW( ) ORDER BY booking_start";


$result = mysql_query($query);


echo mysql_error();
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$bookingnum = $row['booking_num'];
$servernum = $row['server_num'];
$usrnum = $row['usr_num'];
$start = $row['booking_start'];
$end = $row['booking_end'];
$creation = $row['booking_made'];


echo " <div>
bookingnum: $bookingnum<br />
servernum: $servernum<br />
usrnum: $usrnum<br />
start: $start<br />
end: $end<br />
creation: $creation<br />
</div>
";
}


mysql_close($con);


?>

 

So please tell me if I am missing something, but this is what my query returns.

 

 

and this is what the MySQL table looks like.

 

[Manixat]

Unfortunately you are working in a .html document which obviously cannot parse php

[MDCode]

Unfortunately you are working in a .html document which obviously cannot parse php

 

Not necessarily. A server can be configured to .html being able to parse php

 

Hi I am trying to pull data from a MySQL table but it keeps returning some of the PHP code instead of the results.

 

 

<?


$db_server = '127.0.0.1';
$db_usr = 'user123';
$db_pass = '123456';
$db_database = 'test';


$con = mysql_connect($db_server, $db_usr, $db_pass, $db_database);


if (!$con)
{
die('Could not connect: ' . mysql_error());
}


$query = "SELECT * FROM bookings WHERE `booking_start` <= NOW( ) ORDER BY booking_start";


$result = mysql_query($query);


echo mysql_error();
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$bookingnum = $row['booking_num'];
$servernum = $row['server_num'];
$usrnum = $row['usr_num'];
$start = $row['booking_start'];
$end = $row['booking_end'];
$creation = $row['booking_made'];


echo " <div>
bookingnum: $bookingnum<br />
servernum: $servernum<br />
usrnum: $usrnum<br />
start: $start<br />
end: $end<br />
creation: $creation<br />
</div>
";
}


mysql_close($con);


?>

 

<? is used for a document that contains only php nothing else. switch to <?php

[Manixat]

Unfortunately you are working in a .html document which obviously cannot parse php

 

???

[MDCode]

Yes, a server can be configured to parse php in a .html file. Also, if it were a .html file unable to be parsed, then everything would be displayed not just under the while loop

[Manixat]

<? is used for a document that contains only php nothing else. switch to <?php[/font]

 

And make sure your file's extension is .php and you're running it on a server

[R3v07v3R]

Not necessarily. A server can be configured to .html being able to parse php

 

 

 

<? is used for a document that contains only php nothing else. switch to <?php

 

That worked perfectly, thank you.

I never knew that made a difference.

[MDCode]

Completely untrue, php documents can contain html as well as javascript etc.

 

<? is used for only php documents while <?php is correct for documents containing more than php (their echoed html)

[Pikachu2000]

<? works only with the short_open_tag directive set to On. <?php works regardless of the setting. HTML has nothing to do with it.