Posted By

JonnySnip3r on 04/08/11

Tagged

Versions (?)

Last Edited at 04/08/11 09:30pm

Statistics

Viewed 588 times

Favorited by 0 user(s)

Related snippets

Simple Database Insert

/ Published in: PHP

Just a simple php insert script.

Highlighted TextExpand

<?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>

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.