Personal Blog for Users

Posted on Friday 8th June 2007 at 04:24 AM

MCP

On the RMB user system. I would like this feature. But I don't know how to make it. Could someone help me?

Posted on Friday 8th June 2007 at 05:11 AM

SkillMaster
SkillMaster's Avatar

What features would it need?

Posted on Friday 8th June 2007 at 06:53 AM

MCP

It would look like so:

Title
Body

That is it. On the viewing of the person's profile it shows either their latest blog or a link to it. Or a link saying "View my Blog" or something along those lines.

Posted on Friday 8th June 2007 at 10:33 PM

SkillMaster
SkillMaster's Avatar

ill whip one up now. k

Posted on Friday 8th June 2007 at 10:58 PM

SkillMaster
SkillMaster's Avatar

members.php

Code

        Blogs:<br>";

$fetch = mysql_query("SELECT * FROM `blog` WHERE `username` = '$user[username]'");

while($blog = mysql_fetch_array($fetch))

{

echo("- <a href='blog.php?title=$blog[title]'>$blog[title]</a><br>");

}

echo "

after

Code

        Sex: $user[sex]<br>

Age: $user[age]

make a new file called blog.php

PHP Code

<?php 
session_start();
include ("config.php"); 
if ($logged[username])
{
switch($_GET[page])
{
default:
$title = ("$_GET[title]");
$fetch = mysql_query("SELECT * FROM `blog` WHERE `title` = '$title'");
$blog = mysql_fetch_array($fetch);
if ($logged[username] == $blog[username])
{
echo ("<a href='?page=addblog'>Add blog</a>");
}
else
{
echo("<b>$blog[title]</b><br>$blog[message]");
}
break;
 
case 'addblog': 
echo ("
<form method='POST' action='?page=insertblog'> 
<table width='100%'> 
<tr>
<td align='right' width='25%'>Title</td> 
<td align='left'> 
<input size='25' name='title'></td> 
</tr> 
<tr>
<td align='right' width='25%'>Message</td> 
<td align='left'> 
<textarea cols='30' rows='10' name='message'></textarea></td> 
</tr>
<tr> 
<td align='center'></td> 
<td align='left'> 
<input type='submit' name='submit' value='New Blog'></td> 
</tr> 
</table> 
</form>  
");
break;
 
case 'insertblog':
$title = htmlspecialchars($_POST[title]);
$message = htmlspecialchars($_POST[message]);
$insert = mysql_query("INSERT INTO `forum_category` (`name`, `message`, `username`) VALUES ('$category', '$message', '$logged[username]')");
echo ("New Blog Created.");
break;
}
}
?>

Posted on Friday 8th June 2007 at 10:58 PM

SkillMaster
SkillMaster's Avatar

Code

        CREATE TABLE `blog` (

  `id` int(10) NOT NULL auto_increment,

  `title` varchar(225) NOT NULL default '',

  `message` varchar(225) NOT NULL default '',

  `username` varchar(225) NOT NULL default '',

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

thats the mysql code

Posted on Friday 8th June 2007 at 11:02 PM

SkillMaster
SkillMaster's Avatar

Thats basic you can modify it make it better post as a tut if you like.

Posted on Saturday 9th June 2007 at 02:31 AM

MCP

All I get with this is a blank page.

Below is my code.

PHP Code

<?php 
session_start();
include ("config.php"); 
if ($logged[username])
{
switch($_GET[page])
{
default:
$title = ("$_GET[title]");
$fetch = mysql_query("SELECT * FROM `blog` WHERE `title` = '$title'");
$blog = mysql_fetch_array($fetch);
if ($logged[username] == $blog[username])
{
echo ("<a href='?page=addblog'>Add blog</a>");
}
else
{
echo("<b>$blog[title]</b><br>$blog[message]");
}
break;
 
case 'addblog': 
echo ("
<form method='POST' action='?page=insertblog'> 
<table width='100%'> 
<tr>
  <td align='left' width='13%'>Title</td> 
  <td width='87%' align='left'><input size='25' name='title'></td> 
</tr> 
<tr>
  <td align='left' width='13%'>Body</td> 
  <td align='left'><textarea cols='30' rows='10' name='message'></textarea></td> 
</tr>
<tr>
  <td colspan='2'><left><input type='submit' name='submit' value='Post Blog'></left></td>
</tr>
</table></form> 
");
break;
 
case 'insertblog':
$title = htmlspecialchars($_POST[title]);
$message = htmlspecialchars($_POST[message]);
$insert = mysql_query("INSERT INTO `forum_category` (`name`, `message`, `username`) VALUES ('$category', '$message', '$logged[username]')");
echo ("New Blog Created.");
break;
}
}
?>

Posted on Friday 22nd June 2007 at 10:03 AM

dtnet

Its the same for me

Posted on Friday 13th July 2007 at 03:12 AM

MCP

Hey Skillmaster any way to get this working, please?