The CMS (#8) PHP

Base · #1 (**permalink**) 04-04-2007, 09:05 PM

Ok so as promised this is one of the last CMS tutorials.

All we have left after this is the template system, and allthough thats going to be a fun one, and going to be a lengthly one, we have but a few tutorials left together!

As allways

Start off with adding to our installer.

If your not using our PHP installer, and your using somthing else, then you will need this code:

Code:

CREATE TABLE `shoutbox` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`message` longtext NOT NULL,
`time` text NOT NULL,
PRIMARY KEY  (`id`)
);

If your using our PHP installer then add the following code to our install.php

PHP Code:


			
mysql_query("CREATE TABLE `shoutbox` (
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`message` longtext NOT NULL,
`time` text NOT NULL,
PRIMARY KEY  (`id`)
);")
 or die(mysql_error());  
    echo "Shoutbox table created";
    echo "<br><br>";

Ok, so now we have the tables in place, we need to slap down some code.

Now shoutboxes are pretty much exactly the same as guestbooks.

So if you have read my guestbook tutorial, none of this will shock you.

PHP Code:


			
<?php
include("../../includes/connect.php");
if($_POST['submit']) {

$name = $_POST['name'];
$message = $_POST['message'];

   //use the PHP date function for the time
   $time= date("h:ia d/j/y");
   
   // inserting it into the shoutbox table which we made in the mysql statements before
   $result=MYSQL_QUERY("INSERT INTO shoutbox (id,name,message,time)".
      "VALUES ('','$name', '$message','$time')");
} else {

$result = mysql_query("select * from shoutbox order by id desc limit 5");

//the while loop
while($row=mysql_fetch_array($result))
{        
   //getting each variable from the table
   echo $row['name'];
   echo "<br>";
   echo $row['message'];
   echo "<br>";
   echo "<br>";
}

?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<INPUT TYPE='TEXT' value='Name' NAME='name' SIZE=30 maxlength='100'>
<br>
<textarea name="message" cols="30" rows="5">message</textarea>
<br>
<input type="submit" name="submit" value="submit">
</form>
<?php } ?>

As allways in these tutorials aparently, i have repeatedly gone over this code before.

$time= date("h:ia d/j/y");

Gets the time/date

$result = mysql_query("select * from shoutbox order by id desc limit 5");

Selects all from the shoutbox with the limit of 5, orderd by ID.

echo $row['name'];
echo "<br>";
echo "$row['message'];
echo "<br>";
echo "<br>";

Is repeated untill the table is empty

Ok, so save that in this directory:

http://www.yourdomain.com/admin/shoutbox/index.php

save it as that.

i.e. save it as the file index.php in your shoutbox directory.

Right then, now we move onto our edit-shoutbox.php inside our admin directory.

PHP Code:


			
<?php
session_start();
if($login_username=="") {
Header("Location: login.php");
} else {

include("../includes/connect.php");

// including the connect file for the database.

// If the user has posted to edit then:
if($_POST['edit']) {

// Get variables.
$id = $_POST['id'];
$name = $_POST['name'];
$message = $_POST['message'];


// Run the re-edited stuff through HTML charicters
$name = htmlspecialchars($name);
$comment = htmlspecialchars($comment);

// Put our query into a variable.

$query = "UPDATE shoutbox SET name = '$name', message = '$message' WHERE ID = '$id'";

$result = mysql_query($query) or die(mysql_error());
echo "<center><strong>Shoutbox post modified.</strong></center>";
// Otherwise
} else {

$query = "SELECT * FROM shoutbox ORDER BY ID DESC";

$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
extract($row);
?>

<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<table align="center">
<tr>
  <td align="right">Name:</td>
  <td><input name="name" type="text" id="name" value="<?php echo "$name"; ?>" maxlength="250" /></td></tr>
<tr>
  <td align="right">Comment:</td><td><textarea name="message" cols="50" rows="10" id="message"><?php echo "$message"; ?></textarea></td></tr>

<tr><td> </td><td><input type="hidden" name="id" value="<?php echo "$id"; ?>" /><input type="submit" name="edit" value="Modify" /><input type="reset" name="reset" value="Reset" />
    <input name="del" type="submit" id="del" value="Delete" /></td></tr>
</table>
</form>

<?php
}

if($_POST['del']) {
$query = "DELETE FROM shoutbox WHERE ID = '$id'";
//Execute the query.
$result = mysql_query($query) or die(mysql_error());
echo "The post has been deleted";
header("Refresh: 2; edit-shoutbox.php");
}
}
?>

Now usually i would go through this line by line, BUT!

I'm not going too.

The observant amoung you will notice that this is dammed near exactly the same code as our edit guestbook posts page.

So there is no point me explaining it twice.

If you do requre an explanation of it.

Please click here.

Many thanks, and once again i hope you learned!

Cheers

Base

Willyke · #2 (**permalink**) 04-04-2007, 11:08 PM

Like all the other parts, good job and well-explained!

Just a little beauty mistakes (not really a mistake but you'll get my point

)

Quote:

Originally Posted by Base

PHP Code:


			
//the while loop

while($row=mysql_fetch_array($result))

{        

   //getting each variable from the table

   echo "".$row['name']."";

   echo "<br>";

   echo "".$row['message']."";

   echo "<br>";

   echo "<br>";

}