[SOLVED] 'include' function not working amidst script

[xProteuSx]

Here is the problem:

 

If I use this, the script works:

 

<?php some miscellaneous code; ?><?php include="whatever.php";?><?php some miscellaneous code; ?>

 

However, if I do this it does not:

 

<?php

some miscellaneous code;

include="whatever.php";

some miscellaneous code;

?>

 

What the haps??

[rajivgonsalves]

your include syntax is wrong

 

include="whatever.php";

 

should be

 

include "whatever.php";

[xProteuSx]

Sorry.  I meant

 

include "whatever.php";

 

This doesn't work, even without the equal sign.

[rajivgonsalves]

post your code we cannot tell otherwise, there could be many reasons

[dg]

try this ......

include_once("file_name");

[xProteuSx]

This is the version with the include function commented out.  It works perfectly.

 

{

echo '<center>';

echo '<table width=\"400\">';

echo '<tr>';

echo '<tr height=3>';

echo '<td></td>';

echo '<tr>';

echo '<tr border=1>';

echo '<td bgcolor=#d0d0d0 width=120><font size=+2><center><b>Members List</b></center></font></td>';

echo '<tr>';

echo '<tr height=8>';

echo '<td></td>';

echo '<tr>';

echo '</table>';

echo '</center>';

 

//include "include/db.php";

 

mysql_connect('server','user','pass') or die ('Unable to connect to MySQL Server');

mysql_select_db('database') or die ('Unable to select DB');

 

$query = 'SELECT users_handle FROM users';

$result = mysql_query($query) or die ('Error in query: ' . mysql_error());

 

etc.

 

}

 

 

This is the version with the include function called up.  It does not work.

 

{

echo '<center>';

echo '<table width=\"400\">';

echo '<tr>';

echo '<tr height=3>';

echo '<td></td>';

echo '<tr>';

echo '<tr border=1>';

echo '<td bgcolor=#d0d0d0 width=120><font size=+2><center><b>Members List</b></center></font></td>';

echo '<tr>';

echo '<tr height=8>';

echo '<td></td>';

echo '<tr>';

echo '</table>';

echo '</center>';

 

include "include/db.php";

 

$query = 'SELECT users_handle FROM users';

$result = mysql_query($query) or die ('Error in query: ' . mysql_error());

 

etc.

 

}

 

Contents of db.php:

 

------------------------------------------------------------------------------------------------------

$server = "server";// Your MySQL Server (usually "localhost")               

$db_user = "username";// Your MySQL Username                                       

$db_pass = "password";// Your MySQL Password                                       

$database = "database";// Database Name

 

mysql_connect('$server','$db_user','$db_pass') or die ('Unable to connect to MySQL Server');

mysql_select_db('$database') or die ('Unable to select DB');

------------------------------------------------------------------------------------------------------

 

That's all ...

 

 

[xProteuSx]

include_once("file_name"); no worky!! 

[PHP_PhREEEk]

You have over 80 posts... please use BBCode code tags with a <?php at the top of each code snippet. That way we get color coded code that is easier to troubleshoot.

 

Please replace your db.php with this. run the script that includes db.php. Does "I died in db.php!" appear onscreen?

 

<?php
die("I died in db.php!");
$server = "server";// Your MySQL Server (usually "localhost")                 
$db_user = "username";// Your MySQL Username                                        
$db_pass = "password";// Your MySQL Password                                        
$database = "database";// Database Name

mysql_connect('$server','$db_user','$db_pass') or die ('Unable to connect to MySQL Server');
mysql_select_db('$database') or die ('Unable to select DB');
?>

 

PhREEEk

[rajivgonsalves]

lol PhREEEk you really love the die statement

[PHP_PhREEEk]

I love whatever gets the job done...

 

PhREEEk

[PFMaBiSmAd]

The include file does not contain <?php and ?> tags, so the contents of it is not parsed.

 

BTW: The pseudo code examples in the first post are not the same as what the actual two code examples are doing. No one would have been able to help you based on the information in the first post. The only way to get specific with what your code is or is not doing is if you post your actual code.

[xProteuSx]

Got it figured out ... Just had to change this:

 

mysql_connect('$server','$db_user','$db_pass') or die ('Unable to connect to MySQL Server');

mysql_select_db('$database') or die ('Unable to select DB');

 

To this:

 

mysql_connect($server,$db_user,$db_pass) or die ('Unable to connect to MySQL Server');

mysql_select_db($database) or die ('Unable to select DB');