Creating your own blog - Page 2 - Webmaster Forums UK SEO SEM Webmaster Community Forum

#11 (**permalink**) 05-03-2007, 04:50 AM

OK, time to create a script that will add our posts to the database.
For now, we'll call it administration.php
And this is the source:

PHP Code:


			
<?php



include ("config.php");

if ($HTTP_POST_VARS['add']) {

  $title=$HTTP_POST_VARS['title'];

  $text=$HTTP_POST_VARS['text'];

  $sql ="INSERT INTO blog (title, text) VALUES ('$title', '$text')";

  $result=mysql_query($sql);

  if ($result) echo "<b>New post added!</b>";

  else echo "<b>Could not post!</b>";

  }

?>



<HTML>

    <HEAD>

        <TITLE><?php echo $sitename; ?> Admin CP</TITLE>

    </HEAD>

    <BODY>

        <H1>Add a new post</H1>

        <form method="POST" action="administration.php">

        <b>Title:</b><br>

        <input type="text" name="title"><br>

        <b>Entry:</b><br>

        <textarea cols="60" rows="6" name="text"></textarea><br>

        <input type="submit" name="add" value="Add">

        </form>

    </BODY>

</HTML>



<?php



mysql_close();



?>

Again, this is a very simple piece of code. It features a submit form and a small script to add posts.
In the first part we include the config.php file again. And then we tell the script that if the form has been submitted it should get the title and the text that was submitted and we insert it into the database.
If it's OK we output a success message and if something went wrong we print out an error message.
The rest is simple HTML (with a dynamic title according to the config.php file) and a form that submits the title and the text of the post.
At the end we close the connection to the database.
That's it! Note that your "Admin CP" isn't protected at all at this stage so anyone who knows the URL to it can add data. But we aren't concerned about this at this stage. We'll mess with security later.

#12 (**permalink**) 05-03-2007, 05:12 AM

Well, now that the phase 1 of designing our own blog is finished here's the live demo:

This is the blog itself:
http://forums.ukwebmasterworld.com/b...l/01/index.php

And this is the Admin CP (it has been disabled to prevent spam but you can at least see what it looks like):
http://forums.ukwebmasterworld.com/b...nistration.php

I know it's nothing fancy but why kill ourselves designing something that isn't finished?

Next lesson will include some CSS (so your retinas don't burn from looking at this site) and we'll be adding some new functions. Expect it in a couple of days (maybe even tomorrow).

Oh, almost forgot. Here's the link so you can download the source code we've created so far:
Download!

Bisje · #13 (**permalink**) 05-13-2007, 02:11 PM

Hi Melkior,

Don't want to put pressure on you, far from that, but I was wondering if you intend to continue this tutorial.

I found it simple and clear (just what I need

) until now and I surely hope you will continue with it.

Thanks for the job so far :armada34:

#14 (**permalink**) 05-14-2007, 07:49 PM

I'm glad you like it Eric!

Yes, I'll continue with this tutorial, tomorrow. I had some issues that detained me in continuing this tutorial.

Now that I'm free again I will continue and speed up the pace a little bit.

Thanks for your patience!

Bisje · #15 (**permalink**) 05-14-2007, 08:08 PM

Great, I'm looking forward reading you

lala · #16 (**permalink**) 05-16-2007, 08:40 PM

Melkior,

Cannot wait for you next post. Thank you for your valuable contributions. If we would not have nice chaps like you we really would be lost in the dark;-)

lala

#17 (**permalink**) 05-17-2007, 02:47 PM

Well, as you know we're working on a competition called POSTFest and it's tomorrow so just a little more patience and after the POSTFest is finished and the winner is announced I'll continue this tutorial.

lala · #18 (**permalink**) 05-17-2007, 11:29 PM

Can you tell me your secret how you manage to do all this? It is amazing how much you contribute to the UKWebmasterWorld and and and. Wish I would have the same skills... Well done!!!!!!

lala

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating and running a discussion forum	temi	Webmaster Tips and Tricks	39	06-19-2008 07:20 AM
Tips for creating better website	temi	Webmaster Tips and Tricks	11	03-21-2008 01:25 AM
Creating a custom page in vBulletin	melkior_inactive	Forum Software	3	01-18-2008 10:14 AM
PR4 Real Estate - blog posts for sale - one year old blog	stock_post	Other Advertisements (Ads spaces such as banner, blogs and articles)	1	08-23-2007 08:44 AM
Creating Banners	gkd_uk	General Webmaster Talk	1	05-26-2007 11:36 AM