insert Access database

Anon

Hi every one,

I tried but could not insert data into Access database,could please help any one .
Can I use this function odbc_exec() is for insert data into database?

my table name is stu.
Datasourcename is test1.

Parse error: parse error in c:\program files\apache group\apache\htdocs\data5.php on line 13

my code is

Thank you ,
sankar

Anon

try . as the concatenation operator. the whole concatenation looks weird 😉

crowezr

It looks like you may want to try to simplify your sql command by eliminating the + signs. Also, I find it easier to develop the sql command as a separate variable. For instance:

$insert = "INSERT INTO stu(sno,name,marks) VALUES('$sno','$name','$marks') ";
$sql = odbc_exec($db, $insert);

One other thing that may be causing the problem is when you are connecting to the database, you don't need "DSN=test1". It should be just:
$db = odbc_connect("test1", "","");

Hope this helps!