calabiyau Posted February 14, 2007 Share Posted February 14, 2007 I'm making a blog where I can type into a text area, submit the form and process it by inserting it into my database. Problem is if my blog entry has any apostrophe's in it it stops the query from processing. Anyone can tell me why it is doing this and what to change to stop it from happening? include('../connections.php'); //soft string is the text area variable posted $softstring = $_POST['softstring']; $new_page = $_POST['new_page']; $query = "INSERT INTO ".$new_page." VALUES (' ','$softstring')"; if (mysql_query($query, $connect)) { echo "<p>code inserted into".$new_page."</p>"; } Link to comment https://forums.phpfreaks.com/topic/38395-solved-commas-in-text-area-breaking-my-queries/ Share on other sites More sharing options...
Jessica Posted February 14, 2007 Share Posted February 14, 2007 http://php.net/mysql_real_escape_string Link to comment https://forums.phpfreaks.com/topic/38395-solved-commas-in-text-area-breaking-my-queries/#findComment-184114 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.