MySQL Retrieval Problem Pt2

inulled

$query = mysql_query("SELECT ThemeDashboardURL, ThemeStartpageURL FROM theme_repository") or die (" Database Failure");

$while($row = mysql_fetch_row($query)) {
if (isset($_SESSION['username']) && ($_SESSION['username'] !=1)) {
$dashboard = "\$_SERVER\[\"DOCUMENT_ROOT\"\]\$row\[\"ThemeDashboardURL\"]";
$startpage = "\$_SERVER\[\"DOCUMENT_ROOT\"\]\$row\[\"ThemeStartpageURL\"\]"
include($dashboard);
} else {
include($startpage);
}
}

The error I'm getting now is:

Warning include($_SERVER["DOCUMENT_ROOT"]$row["ThemeDashboardURL"]) [function.include]: failed to open stream: Invalid arugments in.....

Warning: include() [function.include]: Failed opening '$_SERVER["DOCUMENT_ROOT"]$row["ThemeDashboardURL"] for inclusion (include_path='.;......) in ..... on ..

Any help?

bradgrafelman

What do you expect this variable:

$dashboard = "\$_SERVER\[\"DOCUMENT_ROOT\"\]\$row\[\"ThemeDashboardURL\"]";

to contain?

As the error message shows, you're escaping the dollar signs so that they appear in the string as literals - no variable interpolation is being done. See the manual page for a [man]string[/man] to see how that should be written.

inulled

In one of my other posts somebody commented with this:

include($_SERVER['DOCUMENT_ROOT'] . '/'.$row['ThemeDashboardURL']);
} else {
include($_SERVER['DOCUMENT_ROOT'].'/'.$row['ThemeStartpageURL']);
}
}

This seems to work but now I get this error:

Notice: Undefined index: ThemeStartpageURL in C:\Web Server\htdocs\Drupia\bootstrap.php on line 55

Warning: include(C:\Web Server\htdocs) [function.include]: failed to open stream: Permission denied in C:\Web Server\htdocs\Drupia\bootstrap.php on line 55

Warning: include() [function.include]: Failed opening 'C:/Web Server/htdocs/' for inclusion (include_path='.;C:\Web Server\php\PEAR') in C:\Web Server\htdocs\Drupia\bootstrap.php on line 55

Got any clues? I think the permission denial might be part of the php.ini file... But I don't know for sure

bradgrafelman

inulled wrote:
In one of my other posts

... which begs the question: Why are you creating multiple threads for the same issue(s)? (Which begs the answer: You shouldn't, hence why I've locked the other thread.)

As for the errors, start at the top; you're referencing an invalid array index 'ThemeStartpageURL'.

inulled

$query = mysql_query("SELECT ThemeDashboardURL, ThemeStartpageURL FROM theme_repository") or die("Failure");
while($row = mysql_fetch_array($query))
{
if (isset($_SESSION['username']) && ($_SESSION['username'])) { // user is logged in
include($_SERVER['PATH_TRANSLATED'] . '/'.$row['ThemeDashboardURL']);
} else {
include($_SERVER['PATH_TRANSLATED'].'/'.$row['ThemeStartpageURL']);
} 
}
}

what I changed was: mysql_fetch_row to: mysql_fetch_array. and changed: $SERVER['DOCUMENT_ROOT'] to: $SERVER['PATH_TRANSLATED']