i get this error. how to solve this error?

0
votes

Warning : odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'to'., SQL state 37000 in SQLExecDirect in C:\xampp\htdocs\lendkarma\dashboard\viewpost.php

<?php
if($userconnection)
    {
       $sql_result="INSERT into blogs_new(empid,blog_title,status,blog_author) VALUES ($empid,$title,$a,$status,$author)";
       echo $sql_result;
       $res=odbc_exec($userconnection,$sql_result);
     // $res = odbc_prepare($userdatabase,"INSERT INTO t_blogs (empid,blog_title,blog_content,status,blog_author) VALUES ($empid,$title,$a,$status,$author)");
    }
    else
    {
       echo "connection error";
    }
?>
2
phpsql-server
<?phpif($userconnection) { $sql_result="INSERT into blogs_new(empid,blog_title,status,blog_author) VALUES ($empid,$title,$a,$status,$author)"; echo $sql_result; $res=odbc_exec($userconnection,$sql_result); // $res = odbc_prepare($userdatabase,"INSERT INTO t_blogs (empid,blog_title,blog_content,status,blog_author) VALUES ($empid,$title,$a,$status,$author)"); } else { echo "connection error"; } ?> - Binny Yogesh Sg

2 Answers

0
votes

I think you should add some apostrophe around your string type of value in your sql query string. Something like this.

$sql_result="INSERT into blogs_new(empid,blog_title,status,blog_author) VALUES ('".$empid."','".$title."','".$a."','".$status."','".$author."')";
0
votes

Your values need quotes around them:

$sql_result="INSERT into blogs_new(empid,blog_title,status,blog_author) VALUES ('$empid','$title','$a','$status','$author')";