CODEWITHSUNDEEP
phpsqlinsert-query
sachin
sachin

Reputation: 23

SQL syntax error in php for long paragraph

i am getting SQL syntax error for long paragraph but same code is working fine for short line text. i have attached screen shot of error.!

below is my insert query code. waiting for your response.

    <?php
include('config.php'); 

if(isset($_POST['add']))
{
   echo $name=$_POST['name'];
   $description=$_POST['description'];
   $status=$_POST['status'];
   $image=$_FILES['image']['name'];
  if(isset($_FILES['image']['name']))
        {
    move_uploaded_file($_FILES['image']['tmp_name'],"gallery_files//".$_FILES['image']['name']);
    echo $image=$_FILES['image']['name'];
    }

    echo $sql="INSERT INTO test(name,description,image,status)VALUES('$name','$description','$image','$status')";
   $r=mysql_query($sql) or die(mysql_error()); 
    echo "<script>window.location = 'product.php'</script>";
    }
?>

Upvotes: 0

Views: 673

Answers (1)

Jenz
Jenz

Reputation: 8369

Your content probably contains quote characters, which you need to escape. You can use PHP function mysql_real_escape_string() which escapes special characters in a string for use in an SQL statement.

Try with:

$description = mysql_real_escape_string($_POST['description']);

Also make sure that the datatype is text or longtext which is used for storing large pieces of string data.

Upvotes: 1

Related Questions