Simple Insert of Form Data into Access

SeenGee

Can anyone tell me what the basic syntax is to insert form data into an access database from PHP. I've only worked with MySQL before, i'm, able to connect to the access db but i can't insert anything.

Thanks.

dalecosp

How are you connecting in the first place?

SeenGee

with this (odbc.php)

<?

$odbc = odbc_connect ('TestDB', 'root', '') or die( "Could Not Connect to ODBC Database!");

if (function_exists(odbc_fetch_array))
return;

function odbc_fetch_array($result, $rownumber=-1) {
	if (PHP_VERSION > "4.1") {
		if ($rownumber < 0) {
			odbc_fetch_into($result, $rs);
		} else {
			odbc_fetch_into($result, $rs, $rownumber);
		}
	} else {
		odbc_fetch_into($result, $rownumber, $rs);
	}

$rs_assoc = Array();

foreach ($rs as $key => $value) {
	$rs_assoc[odbc_field_name($result, $key+1)] = $value;
}
return $rs_assoc;
}
?>

and this to query the db(query.php):

<?
include 'odbc.php';

$query = odbc_exec($odbc, "SELECT * FROM Customers") or die (odbc_errormsg());
while($row = odbc_fetch_array($query)){
	echo "Customer First Name: ".$row['customer_first_name']."<br />";
	echo "Customer Last Name: ".$row['customer_last_name']."<br />";
	echo "Customer Email: ".$row['email_address']."<br />";
	echo "<hr />";
}

odbc_close($odbc);


?>

tekky

how about.....

http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=MS+ACCESS+INSERT

searching for things can be quite easy, enjoyable, and entertaining.... especially when you find your answers in minutes by yourself rather than waiting for someone else to tell them to you....

SeenGee

cheers for the help, this is only for asp though which i've never worked with.

tekky

the query example shown in that example is an ADO MS ACCESS QUERY, just because you are connecting with ASP or PHP, does not change the QUERY needed to be sent to ACCESS

SeenGee

this is where i am now, odbc.php is still the same, query.php is now like this:


<?
include 'odbc.php';

$query = odbc_exec($odbc, "SELECT * FROM Customers") or die (odbc_errormsg());
while($row = odbc_fetch_array($query)){
	echo "Customer First Name: ".$row['customer_first_name']."<br />";
	echo "Customer Last Name: ".$row['customer_last_name']."<br />";
	echo "Customer Email: ".$row['email_address']."<br />";
	echo "<hr />";
}

echo " 
    <FORM NAME = \"AccessInterface\" METHOD=post ACTION=\"DataAccess.php\"> 
    Please enter the details you wish to be inserted into the Access Database.<br> 
    First Name:<input name=\"customer_first_name\" TYPE=\"text\" SIZE=\"25\"><br> 
    Last Name:<input name=\"customer_last_name\" TYPE=\"text\" SIZE=\"25\"><br> 
    Phone Number: <input name=\"email_address\" TYPE=\"text\" SIZE=\"25\"><br> 
    <INPUT type=\"Submit\"> 
    </form> 
    "; 



odbc_close($odbc);


?>

and DataAccess.php looks like this:

<?php 
$customer_first_name=$_POST['customer_first_name'];
$customer_last_name=$_POST['customer_last_name'];
$email_address=$_POST['email_address'];

include 'odbc.php';
{

$query = odbc_exec($odbc, "SELECT * FROM Customers") or die (odbc_errormsg());
$sql = "Insert Into Customers Values ('$customer_first_name', '$customer_last_name', '$email_address')"; 
$result_set = odbc_exec ($odbc, $sql);

if (!$result_set)
{
echo "<h1>Insert Failed</h1>";
exit;
}
}

odbc_close($odbc); 



?>

but i'm getting this error message:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same., SQL state 21S01 in SQLExecDirect in c:\phpdev\www\public\databases\source\dataaccess.php on line 11

Insert Failed

tekky

I would think access requies this format

INSERT INTO table (column1, column2) VALUES ('value1', 'value2')

SeenGee

i've got it sorted, thanks for your help, if you're interested i changed DataAccess.php to this:

<?php 
$customer_first_name=$_POST['customer_first_name']; 
$customer_last_name=$_POST['customer_last_name']; 
$email_address=$_POST['email_address']; 

include 'odbc.php'; 


$sql = "Insert Into Customers (customer_first_name, 
 customer_last_name, email_address) Values 
   ('$customer_first_name', '$customer_last_name', '$email_address')"; 
   $result_set = odbc_exec ($odbc, $sql); 

   if (!$result_set) 
   { 
   echo "<h1>Insert Failed</h1>"; 
   exit; 
   } 


odbc_close($odbc); 
?>

SeenGee

was testing it on localhost before using an apache/php bundle. put it online and i'm getting this error message:

Notice: Use of undefined constant odbc_fetch_array - assumed 'odbc_fetch_array' in d:\websites\habi322219\www\source\odbc.php on line 5