Insert table data inconsistent

cdc5205

I have a blog type of site and in the admin area I have just a simple html form that will submit a title, the text entry and date to MySQL database. My problem is sometimes after pressing submit the data isn't shown on my page where it's suppose to. But other times it is, I go back to the home page, do ctrl+refresh and still doesn’t update. I then go into phpmyadmin and see if its there and its not. So I go back and enter an entry that’s shorter in length it shows up. So I assumed it was to long. I then just enter the same thing in phpmyadmin for the entry and it worked fine. Any help would be appreciated

my input.php: (it has more code under this that lists all the stuff in the database, it all works fine thats why i'm including db.php, but it doesn't effect whats being POSTed to process.php, at least I dont think so.

<? include 'db.php'; 
include 'checklogin.php';?>
<body>

<form name="form1" method="post" action="process.php">
  <p>
    date:
    <input name="date" type="text" id="date" value="<?php echo date("F j,Y");?>">
</p>
  <p>
    title:
    <input name="title" type="text" id="title">
  </p>
  <p>    <textarea name="entry" cols="64" rows="10" id="entry"></textarea>
</p>
  <p>
    <input type="submit" name="Submit" value="Submit">
</p>
</form>

Process.php:

<?
include 'db.php';
$title=$_POST['title']; $entry=$_POST['entry']; $date=$_POST['date']; 
mysql_query ("INSERT INTO data (date, title, entry) VALUES ('$date','$title','$entry')");
mysql_close($link);
?>
<p>Submited fine. </p>
<p><a href="../blog.php">go to blog</a> </p>

Thank you.

Houdini

You need to see if your queries are working by adding die statement with a message to your queires like you are only showing one actual query which is ("INSERT INTO data (date, title, entry) VALUES ('$date','$title','$entry)"); you need to rewrite it and the other queries with error checking till you can see why what appears to be valid sql actually does what it is supposed to so in the case of the only query you are showing rewrite it as

mysql_query("INSERT INTO data (date, title, entry) VALUES ('$date','$title','$entry)")
  or die("Could not execute query, MySQL said ".mysql_error());

There should be at lease two other queries one that connects to the database server and one that selects the database that MySQL is going to work with, but apparently that is in your db.php but it is not shown and you should have the same error checking to see if you are actually opening a connection with MySQL and selecting a database.

cdc5205

Thank you, It never crossed my mind to put the die statement on it. But it returned an error and what the problem was, when I would type the entry it would contain an apostrophe and sometimes it wouldn't therefore it was dying when it contained one. I got a mysql syntax error where there was at " 'm ". So I went back to my entry and go rid of all contractions and it posted fine. Is there a way I can post apostrophes?

Houdini

You need to use addslashes() for stuff like O'Reilly or O'Henry and silly things like that then when you return them use stripslashes() this way wether they are their or not it won't cause these kinds of errors.

Opps edited had the addslashes and stripslashes backwards add then when inserting data that might contain them and strip them when you want to display them.

cdc5205

Alright, thanks a lot. Probably a newbie question, sorry.