ODBC php
Jeg skal connecte til en access database via php men jeg for flg. fejl:Warning: SQL error: , SQL state 00000 in SQLConnect in c:\inetpub\wwwroot\php\volds\volds\adodb\adodb-odbc.inc.php on line 65
<?php
include "common/common_db.inc";
include('adodb/adodb.inc.php'); # load code common to ADODB
function start1()
{
htmlheader();
type();
htmlfooter();
}
function indsaetpost($typeid='')
{
$tablename = "type";
$conn = &ADONewConnection('access'); # create a connection
$conn->Connect('bolig'); # connect to MS-Access, bolig db
if ($conn) {
$typeid = addslashes($typeid);
$typeid = htmlspecialchars($typeid);
$sql1 = "insert into $tablename values ('$typeid')";
$rs = &$conn->Execute($sql1);
if (!$rs) echo "insert lykkedes ikke";
} else echo "ingen connection";
}
switch($knap) {
case "Submit":
indsaetpost($typeid);
start1();
break;
case "Afslut":
header("Location: http://www.jubii.dk");
break;
default:
start1();
}
?>
Hvad er der galt?
