Help connecting php to a MS Access database

Hello all,

I am new to php and I can't seem to get some code to insert information into a Access database. I am running Apache 2.2 server with php 5.1.2 and on a Windows XP SP2 platform. Here is the code I am attempting to get running, if someone is intrested in helping a new php person out.

Expand|Select|Wrap|Line Numbers

 
<?php

$Fname = $_POST["name"];

$Fphone = $_POST["phone"];

$Fproblem = $_POST["problem"];

$Fdate = date("m/d/Y");

if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form

?>
 
<html>

<head>

<title>IT Issues</title>

</head>

<body bgcolor="#00FFFF" onLoad="self.focus();document.IssueAdd.name.focus()" >

<h1 align="center">Tuthill Transport Technologies</h1>

<hr>

<h2><i><font size="5" face="Arial">IT Trouble Report</font></i></h2>

<!-- Begin form code --> 
 
<tr>

<td width="100%" valign="top">

 <form name="IssueAdd" method="post" action="<?php echo $PHP_SELF;?>">

    <font size="3" face="Arial"> Name: <input type="text" name="name" tabindex=1 maxlength="20"></font> 

     <br>

    <font size="3" face="Arial"> Phone: <input type="text" name="phone" tabindex=2 maxlength="5"></font> 

</td>

</tr>
 
<tr>

<br>

<td width="100%" valign="top"> <br></td>

</tr>
 
<tr>

<td width="100%" valign="top">

    <font size="3" face="Arial">

    <q>Please give a summary of the problem, and any cause that you may know of.</q>

    </font> <br>    <textarea name="problem" tabindex=3 rows="10" cols="70"></textarea>

</td>

</tr>
 
<tr>

<br>

<td width="100%" valign="top"> <br></td>

</tr>
 
<tr>

<br>

<td width="100%" valign="top">

     <input type="submit" name="submit" tabindex=4 value="Submit Request">

</td>

</tr>
 
<tr>

<br>

<td width="100%" valign="top"> <br></td>

</tr>
 
</form> 

</body>

</html>

<?

} else {

echo "<b>Your request has been sent to the IT group as:</b><br/>";

echo "<br />";

echo "Contact name: ".$Fname." at ".$Fphone."<br />";

echo "<br />";

echo "To resolve: <br />";

echo $Fproblem." <br />";

echo "<br />";

echo "Submission Date: ";

//echo date("m/d/Y");

echo $Fdate;

echo "<br />";

echo "Submission Time ";

echo date("h:i:s");

echo "<br />";

echo "<br />";

echo "<br />";

echo "Thank You";
 
$db = 'C:\\xampp\\htdocs\\ITrequest\\PC_PROBLEMS.mdb';

$conn = new COM('ADODB.Connection') or exit('Cannot start ADO.');

//$con=odbc_connect("ITrequest","","") or exit('Cannot open with ODBC');

$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db") or exit('Cannot open with Jet.');

//$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db") or exit('Cannot open with driver.');

$sql = "INSERT INTO PROBLEMS(USER,phone,SUMMARY OF REPORT,date) VALUES('$Fuser','$Fphone','$Fproblem','$Fdate'])";

$rs = $conn->Execute($sql);
 
}

?>

As you can see I have made several attempts to connect with different drivers, but I have had no sucess with any.

Thank You

Oct 29 '07 #1

Subscribe Post Reply

3602

code green

1,726

Expert 1GB

Can you break the problem down a little more.
I am not sure if you mean the connection is failing or the INSERT query.
I have used the COM class to connect to Access before so I know it generates error messages (albeit not very helpful).
What errors are you getting?.
Can you connect via ODBC?

Oct 30 '07 #2

slb813

Yes,

I was able to connect using ODBC.

Thank You !!!

Oct 30 '07 #3

by: Daven Thrice | last post by:

Hi, I've converted the tables from an old Access application to MySql format. I then linked the tables into access using MyODBC and everything works great (on my computer). For now, I want to...

MySQL Database

Connecting to online database using local Enterprise Manager

by: John Morgan | last post by:

I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP...

Microsoft SQL Server

Help! My window application won't close.

by: Alpha | last post by:

I have a Window based application that shows up still running in the task manager when I close it. It reaches the "this.close" statement and then it stops at the "}" at the section of the...

C# / C Sharp

Any help here???

by: DavidS | last post by:

Have Visual Studio.NET installed on MS 2000 Professional OS laptop. No issue ever with web development and SQL connections. Purchased new laptop with XP Professional SP2!!!!!!!! & Visual...

ASP.NET

sqlserver connection - need help desperately!

by: peshekeedweller | last post by:

Using asp.net 1.1. vb.net 2003. I am trying to connect to a remote sql server 2000 on a virtual machine running windows 2000 server. I can connect through the server explorer in visual studio,...

ASP.NET

How to have multiple worker threads submit to one final processing queue? - HELP

by: James Radke | last post by:

Hello, I have a multithreaded windows NT service application (vb.net 2003) that I am working on (my first one), which reads a message queue and creates multiple threads to perform the processing...

Visual Basic .NET

Help connecting to remote Sql server

by: bill | last post by:

I am having difficulties connecting to a remote Sql server database in VB.net. Lets say my remote server is found at 255.255.255.255 and its name is MyServer. The database is called MyDatabase....

Visual Basic .NET

Help with Access Database and tables

by: George | last post by:

Hi all, I am trying to convert to vb.net from VB6 and I am haveing a major problem with connecting to an Access database and adding, updating, deleting data. This is what I usually use in vb6:...

Visual Basic .NET

WEB SITE PROJECT DEPLOYMENT ~ Help please??

by: Brad Isaacs | last post by:

I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am working with Login controls ASP.Configuration, I...

ASP.NET

HELP PLEASE ~ ???

by: Brad Isaacs | last post by:

I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am working with Login controls ASP.Configuration, I...

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Help connecting php to a MS Access database

Similar topics