Redirect to url depending on database info

[adamjones]

Hi.

 

I have this code;

 

<?php
$DB_Server = 'localhost';
$DB_Username = 'wowdream_db';
$DB_Password = 'pass'; 
$DB_Name = 'wowdream_db';

$DB_Conn = @mysql_connect($DB_Server, $DB_Username, $DB_Password) OR die('MySQL error: '.mysql_error());

@mysql_select_db($DB_Name) OR die('MySQL error: '.mysql_error());

$DB_Query = @mysql_query("SELECT * FROM `theme`") OR die('MySQL error: '.mysql_error()); 

while ($data = mysql_fetch_array($DB_Query)) {

$data['theme'] = nl2br($data['theme']);

header("location:{$data['theme']}/");
}
?>

 

It's meant to redirect to 'whatever_the_theme_is/', but it isn't redirecting.

 

Can anyone help?

[Maq]

Please echo out your $data['theme'] to make sure it's the correct path.  Also, do you have display errors turned on?

[rhodesa]

first, there shouldn't be a WHILE loop. you should only do one location redirect. can you describe what you are trying to accomplish? random theme? user can set their theme?

 

second, i don't see the reason for this:

$data['theme'] = nl2br($data['theme']);

 

last, change this:

header("location:{$data['theme']}/");

to this

print ("location:{$data['theme']}/");
exit;

and post the output

[Maq]

You also have:

 

SELECT * FROM `theme`;

 

which is always going to grab the first style.  If you want a random theme or the user to chose it you need to have something like:

 

SELECT theme_style FROM theme WHERE theme = $user_choice;

 

Please put error reporting on by putting the following at the top of your script:

 

ini_set ("display_errors", "1");
error_reporting(E_ALL);

[adamjones]

It's so admins can set a theme in the admin panel, eg: christmas, easter, etc..

 

...and the output is:  location:/

[Maq]

So is this from a drop down menu or something?  How do you pass this variable to this page?  What's the output when you print out $data['theme']?  We need more information...

[adamjones]

@ Maq:  Notice: Undefined variable: data in /home/wowdream/public_html/index.php on line 17

 

which is this line:

 

print ("location:{$data['theme']}/");

 

[Maq]

@ Maq:  Notice: Undefined variable: data in /home/wowdream/public_html/index.php on line 17

 

Does this field exist in your table?

[adamjones]

My table structure is;

 

CREATE TABLE IF NOT EXISTS `theme` (

  `theme` varchar(65) NOT NULL default 'christmas',

  PRIMARY KEY  (`theme`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

...if that helps?

[rhodesa]

then there must be no rows in the table? how do you manage your table? phpMyAdmin? can you double check there is at least one row in that table and there is a value in the theme column for it?

[adamjones]

Hi.

 

Yes, there is a row called theme, with is the primary row, and in it 'christmas'.

 

Adam.

[rhodesa]

well, can you post a dump of the table, so i can load it up and test the code?