Include Error

nabimomo

I created common.php which creates the page array. When I click on one of the links that are created by the array, I keep receiving the parse error message for the line following the Body section under home.php file. What am I missing or doing wrong? Any help would be much appreciated.

common.php:

<?php
$db = mysql_connect("localhost", "", "_");
mysql_select_db("dbfile",$db)
OR die("Error: could not select database!");

$result = mysql_query("SELECT IDNum, page, url, description FROM dbtable", $db);
while ($row = mysql_fetch_array($result))
{
echo '<b><a href="home.php?page='
. $row['page'] . '">' . $row['description'] . '</a></b><br>';
}
?>

home.php is:

<? include('common.php'); ?>

<!===== Header =====>
<? include('header.php'); ?>

<!====== Body ======>
<? include(' . $row['url'] . '); ?>

<!===== Footer =====>
<? include('footer.php'); ?>

sachindesarda

<!====== Body ======>
$my_include=$row['url'] ;
<? include($my_include); ?>

philipolson

You really need to know why you get this error, and here are some examples:

// INVALID
$str = ' . $foo . ';

// VALID
$str = 'foo';

// VALID
$str = '' . $foo . '';

// VALID
$there = 'll';
$str = 'he' . $there . 'o';
print $str; // hello

// VALID
include ($row['url']);

// VALID
include 'a' . 'b' . 'c' . 'd.php'; // abcd.php

// INVALID
include ' . 'a' . 'b' . 'c' . 'd.php' . ';

I hope you see why. include takes on a string, you giving it some sort of invalid syntax. It all comes down to you understanding what a string is and how to use them, read this:

http://www.php.net/types.string

Also, be sure $row['url'] is available to wherever you're using it as I don't see you using it inside the loop. It may not be what you desire it to be outside the loop but who knows, only you know your code :-)

nabimomo

Thank you philipolson for the examples. I got it work with the 3rd example. You are right about needing to know why I got the error so I can avoid it the next time.