insert data into database

Anon

Hi all,
I am new to PHP.I got one error while insertting the data into database using odbc.
Error is:
Parse error: parse error in c:\program files\apache group\apache\htdocs\data5.php on line 13

can anyone help me?

code is:

Thanks,
Leela

rrijnders

Well, I haven't worked very much with odbc (earlier experiences were too traumatic), but if the SQL is standard, your sql should look more like:

$sql = "INSERT INTO some_table (field_name1, field_name2, field_name3) VALUES ($sno, '$name', $marks)";

I couldn't tell from your sql what the name of the table was you are inserting the data into, or what the name of the fields are that you are putting the data into.

Also, not that I used single quotes around the string data because I am already using double qotes to delimit the string assignment ($sql="").

HTH

-- Rich Rijnders
-- Irvine, CA US

Anon

Hi Richard,
Thank you.
I tried what you said but could not insert data into Access database,could please check again.First let me know this odbc_exec() one 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 ,
Leela

Anon

instead of this:
$sql=odbc_exec($db,"insert into stu (sno,name,marks)values("+"+$sno+","+"'"+$name+"'"+","+$marks+")");

do this:
$sql=odbc_exec($db,"insert into stu (sno,name,marks)values('$sno','$name','$marks'");

only use single quotes in sql statements
in php, concatenate with . (full stop)

rrijnders

Try putting your sql into a seperate variable and watch your use of single and double quotes; only string data need single qotes around them. Also, use a "period/decimal" to concatenate, not a "+" sign.

Try cutting and pasting this into your code block:

$sno=67;
$name="leela";
$marks=890;
$sqlstring = ""insert into stu (sno,name,marks) values($sno, '$name', $marks);
$sql=odbc_exec($db, $sqlstring);
odbc_autocommit($sql);

HTH

-- Rich Rijnders
-- Irvine, CA US