[PHP-DB] Re: Interbase INSERTION error?

[Walter van der Velden]

hey all.. 

I really don't get why I am getting this error.. Can somebody help me
out? what does a parse error mean?
Error:
Parse error: parse error in /home/httpd/html/test/php-test/CVzenden.php
on line 35

CVzenden.php:

$conn=ibase_connect("localhost:/home/httpd/html/test/php-test/CV.gdb",
"SYSDBA", "masterkey"); 

if (!$conn) { 
  echo "Accesso Denied! $back";
  exit; 

  } 

$query="insert into PERSOON values 
('0','$TITELVOOR','$ROEPNAAM','$VOORNAAM','$INITIALEN','$TUSSENVOEG','$ACHTERNAAM',
'$TITELACHTER','$GESLACHT','$BURGSTAAT','$GEBOORTEDATUM','$GEBOORTEPLAATS','$NATIONALITEIT','$STRAAT','$HUISNR',
'$POSTCODE','$PLAATSNAAM','$PROVINCIE','$LAND','$TELPRIVE','$TELWERK','$MOBIEL','$FAX','$BESCHIKBAAR','$EMAIL','NOW','NOW');";
$result=ibase_query($conn,$query); 
  if (!$result) {
 echo "Error. Can't insert the record with the query: $query!
 $back"; 
 exit; 
 }
 echo "brbrRecord saved: $name $back";
 ibase_close($conn); ?
 
You forgot to tell Interbase into which fields te values should be inserted.
Example: $query="insert into PERSOON(roepnaam,achternaam) 
values($ROEPNAAM,$ACHTERNAAM);

Re: [PHP-DB] Re: Interbase INSERTION error?

[Sean Finkel]

Technically, he shouldn't have to list the fields he is inserting into if he
is inserting into the fields in order. Unless that's some funky Interbase
requirement.

A parse error is usually a PHP syntactical error. Can you post the whole of
line "35" so we can see? :)



---
Sean Finkel - [EMAIL PROTECTED]
|H|eretik - Pain in the ass for Clan |H|avoc -
http://www.webdrenalin.com/ubbcgi/
Webmaster - Rabid Wolf .:: Food For Your Brain ::. -
http://www.rabid-wolf.com
Lead Programmer - Data Admin and Data Lib - http://dadmin.sourceforge.net

---
- Original Message -
From: "Walter van der Velden" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 14, 2001 2:29 PM
Subject: [PHP-DB] Re: Interbase INSERTION error?


hey all..

I really don't get why I am getting this error.. Can somebody help me
out? what does a parse error mean?
Error:
Parse error: parse error in /home/httpd/html/test/php-test/CVzenden.php
on line 35

CVzenden.php:

$conn=ibase_connect("localhost:/home/httpd/html/test/php-test/CV.gdb",
"SYSDBA", "masterkey");

if (!$conn) {
  echo "Accesso Denied! $back";
  exit;

  }

$query="insert into PERSOON values
('0','$TITELVOOR','$ROEPNAAM','$VOORNAAM','$INITIALEN','$TUSSENVOEG','$ACHTE
RNAAM',
'$TITELACHTER','$GESLACHT','$BURGSTAAT','$GEBOORTEDATUM','$GEBOORTEPLAATS'
,'$NATIONALITEIT','$STRAAT','$HUISNR',
'$POSTCODE','$PLAATSNAAM','$PROVINCIE','$LAND','$TELPRIVE','$TELWERK','$MO
BIEL','$FAX','$BESCHIKBAAR','$EMAIL','NOW','NOW');";
$result=ibase_query($conn,$query);
  if (!$result) {
 echo "Error. Can't insert the record with the query: $query!
 $back";
 exit;
 }
 echo "brbrRecord saved: $name $back";
 ibase_close($conn); ?

You forgot to tell Interbase into which fields te values should be inserted.
Example: $query="insert into PERSOON(roepnaam,achternaam)
values($ROEPNAAM,$ACHTERNAAM);



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]