Revision: 44267
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at April 8, 2011 21:30 by JonnySnip3r
Initial Code
<?php
// Connect to the server::
mysql_connect('localhost','jonno','password')
or die('Sorry, an error occurred when connecting to the server.');
// Select the database::
mysql_select_db('carl_forum')
or die ('Sorry, an error occurred when select the database.');
if(isset($_POST['post']) && !empty($_POST['post_title']) && !empty($_POST['post_body']))
{
// Set up and clean our variables
$title = strip_tags(mysql_real_escape_string($_POST['post_title']));
$body = strip_tags(mysql_real_escape_string($_POST['post_body']));
$sql = "INSERT INTO posts VALUES (NULL,'$title','$body')";
if(mysql_query($sql))
{
echo 'Thanks! you have made a post!';
}
else
{
echo 'Damn! it failed to post.' . mysql_error();
}
}
?>
<html>
<head>
<title>Carl's Forum</title>
</head>
<body>
<?php
$sql = "SELECT * FROM posts ORDER BY post_id DESC";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) :
?>
<h1><?php echo $row['post_title']; ?></h1>
<p><?php echo $row['post_body']; ?></p>
<?php endwhile; ?>
<form method='post' action='#'>
<input type='text' name='post_title' /><br />
<textarea name='post_body' rows='10' cols='50'></textarea><br />
<input type='submit' name='post' value='Post' />
</form>
</body>
</html>
Initial URL
Initial Description
Just a simple php insert script.
Initial Title
Simple Database Insert
Initial Tags
database, sql, php, simple
Initial Language
PHP