Flash, PHP and Access database

[Mike007]

Hi, all

I've got a question. I'm using a flash form with input text fields "NaamTxt" and "WoonplaatsTxt" and a submit button when it' s pressed it does post to a PHP page with the following code:

<?
$Naam=$HTTP_GET_VARS["NaamTxt"];
$Woonplaats=$HTTP_GET_VARS["WoonplaatsTxt"];
$db = 'C:\post\db.mdb';
$conn = new COM('ADODB.Connection');
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");
$sql="INSERT INTO Gegevens (Naam, Woonplaats) Values ('".str_replace("'","''",$Naam)."','".str_replace("'","''",$Woonplaats)."')";
$rs = $conn->Execute($sql);
?>
<?
$rs->Close();
$conn->Close();
?>

As you can see it stores it' s form data in an ACCESS database, but when the submit button is pressed an empty string is send to the database resulting in no data. The post works fine cause the autoincresement in the database adds an extra record (but an empty one 😕 )

Can anybody please help me out

[bastien]

assuming a windows server...try setting a DSN for the db and use that and ODBC to access the db...goto control file>adminstration>data sources and add a new one

then its much simpler to access the db

like this example

<?php

  // Program to test connecting to a Microsoft Access ODBC Data Source
  $connection = odbc_connect("dsnname", "username", "password");
  print "Connected to datasource<BR><BR>";

  if ($result = odbc_exec($connection, "SELECT * FROM postcard"))
    print "Command executed successfully<BR><BR>";
  else
    print "Error while executing command<BR><BR>";

  // Print results
  while(odbc_fetch_row($result))
    print odbc_result($result, 1) . "   " . odbc_result($result, 2) . "   " . odbc_result($result, 3) . "   " . odbc_result($result, 4) . "   " . odbc_result($result, 5) . "<BR>";

  odbc_close($connection);
  print "<BR>Connection closed.";

?>

if you're not dutch, you're not much

[Mike007]

I know but I prefer not using a DSN. I know the connection is working great because it adds a autonumber to the database. I think the it posts an empty string from the PHP page because because it doesn't know the variables $NaamTxt and $WoonplaatsTxt, but correct me if i'm wrong.

[bastien]

are you sure
1. the method is "GET" for the form?
2. the variables are spelled correctly?
3. the form is pointing at the right page?