Reply to thread

Message

<blockquote data-quote="Sean" data-source="post: 171371" data-attributes="member: 10142">[PHP]&lt;?php&nbsp;$mysqli = new mysqli();$mysqli-&gt;connect('localhost', 'root', 'PASSWORD', 'DATABASENAME');&nbsp;if ($result = $mysqli-&gt;query(&quot;SELECT * FROM `cms_settings`&quot;)) {&nbsp; &nbsp; while ($row = $result-&gt;fetch_object()) {&nbsp; &nbsp; &nbsp; &nbsp; if($row-&gt;maintenance === &quot;0&quot;) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;NOT IN MAINTENANCE&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // header('Location: LINK TO PLACE IF MAINTENANCE IS NOT ENABLED');&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;IN MAINTENANCE&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // header('Location: LINK TO PLACE IF MAINTENANCE IS ENABLED');&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}&nbsp;?&gt;[/PHP]&nbsp;1 = Maintenance Enabled0 = Maintenance Disabled&nbsp;This will work but you will need to change your database structure as your database is not set up correctly to do this properly.&nbsp;Here is what the database should look like : <a href="http://i.imgur.com/oH35U.png" target="_blank">http://i.imgur.com/oH35U.png</a></blockquote>

[QUOTE="Sean, post: 171371, member: 10142"] [PHP]<?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'); } } } ?>[/PHP] 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 : [URL]http://i.imgur.com/oH35U.png[/URL] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members