Show DevBest [TuT]Maintenance Mysql/PHP[TuT]

[Li1M0ST3Rz]

How to make an Maintenance

Requirements:
- Xampp or webhost
- NotePad ++
- ME!

Now Starting:
Now lets go to mysql on my xampp

create a table name: maintenance and number of columns: 1 and press go!

then the table should load up.. now name: status type: INT & Default: 1(1 = on, 0 = off) and now save!

now lets start coding!

config.php:

<?php
mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
?>

on Index or header put this on top:

<?php
include 'config.php';
                $result = mysql_query("SELECT * FROM maintenance");
 
                while($row = mysql_fetch_array($result))
                if($row['status'] == 0):
                header("Location: ./maintenance.php");
        endif;
?>

then on Admin Panel create a Maintenance page, and add this:

<?php
if(isset($_GET['save'])): {
$status = $_POST['status'];
include './config.php';
$query = "UPDATE maintenance SET status='".  $status  ."'";
$result = mysql_query($query);
endif;
}
?>
<form name="status" action="maintenance.php?save" method="POST">
<div align="center"></div>
<tr><th>
<input type="text" name="status" />
<input type="submit" value="Now" name="submit"></th></tr>
</select>
</form>

Then there you had created a an index that lead to maintenance
now you have to make a maintenance at the root of the file!!

My SupremeCMS maintenance.php:

This code is in SupremeCMS
if it dont work add id on table and make it primary.
and fix this:

<?php
if(isset($_GET['save'])): {
$status = $_POST['status'];
include './config.php';
$query = "UPDATE maintenance SET status='".  $status  ."' WHERE id='1'";
$result = mysql_query($query);
endif;
}
?>
<form name="status" action="maintenance.php?save" method="POST">
<div align="center"></div>
<tr><th>
<input type="text" name="status" />
<input type="submit" value="Now" name="submit"></th></tr>
</select>
</form>

 

[DaLightz]

Nicely done young fella.

 

[Li1M0ST3Rz]

Nicely done young fella.

thanks plus some coders on hhere are asses wont help no one except for m0sta

 

[Macemore]

I like this, it's basically the same as the one I released, only using SQL. Nice job. I'd recommend coding a little login page too, nothing fancy, you can set the username & password as variables to make it even easier.

thanks plus some coders on hhere are asses wont help no one except for m0sta

I know you're referring to me, You asked for me to build your CMS with you, never asked for actual help.

 

[DaLightz]

I like this, it's basically the same as the one I released, only using SQL. Nice job. I'd recommend coding a little login page too, nothing fancy, you can set the username & password as variables to make it even easier.

Right right, or make it so rank4+ can avoid the maint.

 

[Li1M0ST3Rz]

I like this, it's basically the same as the one I released, only using SQL. Nice job. I'd recommend coding a little login page too, nothing fancy, you can set the username & password as variables to make it even easier.

Well then you never saw my CMS

 

[Macemore]

Well then you never saw my CMS

I was talking about this as a stand alone. Since not everyone wants to use your CMS

 

[DaLightz]

Well then you never saw my CMS

You should include the sql.
oftop: Your sig is gaaaaaaaaaaaaaaaaay.

 

[Li1M0ST3Rz]

Right right, or make it so rank4+ can avoid the maint.

i'll add that to it!

You should include the sql.
oftop: Your sig is gaaaaaaaaaaaaaaaaay.

i dont feel like changing it D:

 

[Ecko]

Why create a whole table for that? I see a table called settings already, should just add it in there.

 

[Li1M0ST3Rz]

Why create a whole table for that? I see a table called settings already, should just add it in there.

ehh are you blind? its not created yet until the 2nd picture.

 

[Ecko]

ehh are you blind? its not created yet until the 2nd picture.

Are you blind? There's a table called settings already. Alter that table to add a column for maintenance.

 

[Li1M0ST3Rz]

Are you blind? There's a table called settings already. Alter that table to add a column for maintenance.

well this is my tutorial i dont get told by someone who is new to DevBest.

 

[Ecko]

well this is my tutorial i dont get told by someone who is new to DevBest.

So being new to a particular forum is how you judge intellect? RastaLulz knows what type of access I have to his server, maybe you'd like to ask him about that.

 

[Li1M0ST3Rz]

So being new to a particular forum is how you judge intellect? RastaLulz knows what type of access I have to his server, maybe you'd like to ask him about that.

Btw off topic!