Jump to content


Photo

Problems with blogging script adding blank space to database.


  • Please log in to reply
2 replies to this topic

#1 neverbelieve

neverbelieve
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 03 April 2006 - 10:23 PM

I have tried everything I can't find the problem, therefore I'm hoping some kind experts can point out the problem. ;)

Essentially, I have written a simple PHP script that takes the data from a form and puts it in a MySQL database. My host got hacked recently and therefore I lost it. Upon re-adding the tables and such and re-uploading the code, it now posts with no errors to the database but the fields are blank (except the date) and I have no idea whether this has come from a mistake in the coding, writing of the databases (do the fields need specific settings to accept text data other than changing the type field to TEXT) or something else out of my control? I add the form code and form processing code below to see if anyone notices anything particularly odd!

<form action="processform.php" method="post">
<textarea cols=50 rows=1 name="titleof"></textarea>
<textarea cols=50 rows=20 name="blogcontents">Blog Here!</textarea>
<input type="submit" value="Post It" align="center">
</form>

<?php
include("URL"); 
$connection = mysql_connect($blah,$blah,$blah)
          or die ("Couldn't connect to the database.");
$db = mysql_select_db($database)
          or die ("Couldn't select the database.");
$today = date("Y-m-d");
$query = "INSERT INTO EdBlog ( DateField, CommentField, TitleField) VALUES
        ('$today','$blogcontents','$titleof')";
$result = mysql_query($query)
    or die ("Couldn't add the blog.");
?>


#2 ToonMariner

ToonMariner
  • Members
  • PipPipPip
  • Advanced Member
  • 3,342 posts
  • LocationNewcastle upon Tyne, UK

Posted 03 April 2006 - 10:34 PM

First check you table - make sure there are no other fields that MUST have a value inserted (those fields that should NOT be null buit have no default value.)

It maybe simply be that register globals is off (as it should be) if so you must reference teh posted data 'properly'.....As your post uses the post method...
<?php
$query = "INSERT INTO EdBlog ( DateField, CommentField, TitleField) VALUES
        ('$today','" . $_POST['blogcontents'] . "','" . $_POST['titleof'] . "')";
?>
I use concatenation in strings just because I find it easier to locate those vars that are relevant....



follow me on twitter @PHPsycho

#3 neverbelieve

neverbelieve
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 03 April 2006 - 11:18 PM

And indeed it was something simple I'd overlooked - the latter solved all problems. What an obvious mistake to make. Thanks for the help, much appreciated!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users