Change page based on MySQL result

[NSA]

Hello all,

Is there a way to get a page to change based on a MySQL query?

For instance...
If an entry for "is_maintenance" is set to 1 to display a maintenance page

While if it's set to 0 to display a separate page, the home page.

Thanks.

 

[LeCeejay]

From what I can guess is it'd be something like this;
*Connect to you Database*
$maintenance = *Run a query to select the collum which is "is_maintenance"*

if $maintenance == 1
{
redirect thing or w.e
}
else
{
your page
}

Or something, idk

 

[NSA]

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("joshwelford", $con);
 
$result = mysql_query("SELECT `value` FROM `cms_settings` WHERE `id` = 'site_closed'");
$row = mysql_fetch_row($result);
$read = $row;
if($read = "eefef"){
    echo "YES";
}
while($row = mysql_fetch_array($result))
  {
  $value = $result;
  }
 
mysql_close($con);
?>

Is this right?

Regardless of what $read is it always seems to echo "Yes"

 

[LeCeejay]

The reason it says "yes" all the time is because you've stated no "else" from what I see, but I may be blind.

However, from my basic knowledge in PHP, I would assume that should work.

 

[NSA]

Still doesn't seem to be working, I added an elseif and an else, I also tried adding "==" instead of "=".

 

[LeCeejay]

<?php[/FONT]
[FONT=Consolas]$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("joshwelford", $con);
 
$result = mysql_query("SELECT * FROM `cms_settings` WHERE `id` = 'site_closed'");
$row = mysql_fetch_row($result);
$read = $row;
if($read = "eefef"){
    echo "YES";
}
while($row = mysql_fetch_array($result))
  {
  $value = $result;
  }
 
mysql_close($con);
?>

Try that, may I ask why you have "$read = "eefef"? Is it not "1" and "0"?[/php][/FONT]

 

[NSA]

Still nothing :/
I was testing to see if it put "YES" regardless of what the value was.

 

[Sean]

<?php
 
$mysqli = new mysqli();
$mysqli->connect('localhost', 'root', 'PASSWORD', 'DATABASENAME');
 
if ($result = $mysqli->query("SELECT * FROM `cms_settings`")) {
    while ($row = $result->fetch_object()) {
        if($row->maintenance === "0") {
            echo "NOT IN MAINTENANCE";
            // header('Location: LINK TO PLACE IF MAINTENANCE IS NOT ENABLED');
        }
        else {
            echo "IN MAINTENANCE";
            // header('Location: LINK TO PLACE IF MAINTENANCE IS ENABLED');
        }
    }
}
 
?>

1 = Maintenance Enabled
0 = Maintenance Disabled

This will work but you will need to change your database structure as your database is not set up correctly to do this properly.

Here is what the database should look like :

You must be registered for see links

 

[NSA]

I have done exactly what you have done, tried this on multiple web servers including IIS and it still returns "In Maintenance" even when the entry is set to 0.

 

[Kaz]

I have done exactly what you have done, tried this on multiple web servers including IIS and it still returns "In Maintenance" even when the entry is set to 0.

Try changing the 0 & 1 to yes and no?

 

[NSA]

Ugh, still nothing

 

[TesoMayn]

What Sean posted should work, if it's not, then there is something wrong on your end.

 

[Kaz]

What Sean posted should work, if it's not, then there is something wrong on your end.

Sean has posted mysqli when Western is using just mysql.
Western have you changed it to suit your server needs? if you have just copied seans code then it will not work

 

[NSA]

Sorry you have to excuse me, I'm not great with MySQL let alone MySQLi... I changed the database etc... and added the details but that's it.

 

[Kaz]

Sorry you have to excuse me, I'm not great with MySQL let alone MySQLi... I changed the database etc... and added the details but that's it.

Have you changed Seans code from Mysqli to MySQL? if not, then obviously it wont work

 

[NSA]

Well I have no idea how to do so, nevermind I'll just scrap it. Thanks for the help. 
Nevermind I got it working!