creating my own blog

saltedm8 · #1 Sep 14th, 2007, 17:28

i am trying to create my own blog, but i am very stuck

what i need to do is to have a text box filled in ( much like the form i am filling to type this message - but i do know how to install tinymce ) , then saved to the database and then put on my webpage when called up, but i also want to limit the amount of blogs on one page so it goes onto another, lets say 5 blogs per page

sorry for putting in such a big request, i know its a bit more than a little question ( creating the database etc ) i could break it up, but it would only be posted at a later date anyway

please help or point me in the right direction, i have searched everywhere to find the answers with no luck

thank you

Daniel · #2 Sep 14th, 2007, 17:31

why not use wordpress?

karinne · #3 Sep 14th, 2007, 17:44

The whole ... limit on how many blogs needs to be display should be done through you query to MySQL ... sort of like

Code: Select all

$select = mysql_query("select * from blogs order by someID desc limit 5");

saltedm8 · #4 Sep 14th, 2007, 17:57

daniel, your missing the point, i want to make my own as a learning curve

thank you kerinne
i still have no idea on - from form to database to web page though

karinne · #5 Sep 14th, 2007, 18:34

Well in short (very short) ... from form to db would be something like

PHP: Select all


<html>
<head>.....</head>
<body>

<?
if ($_POST['submit'];) {
  $blog = $_POST['blog'];
  $title = $_POST['title'];

  $insert = mysql_query ("insert into blogs (blog, title) values ('$blog', '$title')");
}
?>


<form action="<? $_SERVER['PHP_SELF'] ?>" method="post">
Title: <input type="text" name="title">
Blog: <textarea name="blog" cols="4" rows="5"></textarea>
<input type="submit" name="submit" value="submit">
</form>

</body>
</html>

From database to site

PHP: Select all


<html>
<head>.....</head>
<body>

<?
 $select = mysql_query ("select * from blogs order by blogID desc limit 5");

while ($row=mysql_fetch_array($select))  {
   echo '<h2>'. $row['title'].'</h2>'"\n";
   echo $blog;
}
?>

</body>
</html>

Something like that

1840dsgn · #6 Sep 14th, 2007, 18:36

Saltedm8 you really need to do some more basic PHP stuff before you try and develop a blog engine.

If you can't pull data from a database then this is going to be way to steep of a learning curve. Start learning the basics first.

karinne · #7 Sep 14th, 2007, 18:38

Yes ... I agree with Mike tho ... Go get a good php book and start learning it

saltedm8 · #8 Sep 14th, 2007, 18:55

i have, php&mysql for DUMMIES

i have also tryed others, so i thorght the only way to learn would be to throw myself into the deep end, thats how i learn't html, phpbb and css, worked for me then and i am hoping it will work for me now

saltedm8 · #9 Sep 14th, 2007, 18:59

this is what i have right now,

Code: Select all

<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
$db  = 'CREATE DATABASE saltyblog';
$result = mysql_query($db);
mysql_select_db('saltyblog') or die('Cannot select database'); 
  
mysql_close($link);
?>

i now need to create the tables, how ?

karinne · #10 Sep 14th, 2007, 19:01

Why don't you just create them manually through phpMyAdmin or something like that?

saltedm8 · #11 Sep 14th, 2007, 19:11

its the learning curve thing again, sorry

1840dsgn · #12 Sep 14th, 2007, 19:19

exactly at this rate we will be making your blog engine for you by telling you everything you need to know.

Go learn the basics - one of which is creating tables in mySQL - and learn how to code PHp before you jump into creating a complex program like this.

alexgeek · #13 Sep 16th, 2007, 18:41

Quote:

Originally Posted by saltedm8

this is what i have right now,

Code: Select all

<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
$db  = 'CREATE DATABASE saltyblog';
$result = mysql_query($db);
mysql_select_db('saltyblog') or die('Cannot select database'); 
  
mysql_close($link);
?>

i now need to create the tables, how ?

It's not gunna be a learning curve if just ask us how to do something every time you get stuck
read your book to get the grips or some online tutorials (tizag, w3schools etc.)

silverscribbles · #14 Sep 18th, 2007, 15:40

theres a "build a blog" tutorial @ http://www.codegrrl.com

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Blog	unitedcraig	Website Planning	5	Feb 20th, 2008 11:48
Creating a CMS and Blog...	marSoul	Website Planning	12	Jan 3rd, 2008 00:56
Creating a blog?	thewebkid	Starting Out	16	Dec 20th, 2007 14:57
Blog Rep	alexgeek	Webforumz Suggestions and Feedback	2	Oct 13th, 2007 19:52
Need suggestions in creating a blog site	jram	Website Planning	11	Oct 8th, 2007 17:43

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
creating my own blog