PHP and Access Database!

Dev Articles Community Forums Sponsor:

September 21st, 2002, 04:12 PM

neutcomp

Registered User

Join Date: Sep 2002

Location: The Netherlands

Posts: 24

Time spent in forums: 1 m 15 sec
Reputation Power: 0

PHP and Access Database!

Hello,

I have a website build with PHP and I have a Access database.

How can I make a connection to this database and how can I get information out of it?

Not just like mysql_connect($host, $name, $pass)
Or mysql_query("select * from people where id='1' ")

thanxx for the help!

Cya
Bjorn

September 21st, 2002, 11:33 PM

Ben Rowe

Guest

Posts: n/a
Time spent in forums:
Reputation Power:

i dont know if you cant connect to an access database with php???

September 22nd, 2002, 01:10 AM

confuxion

Junior Member

Join Date: Aug 2002

Location: Burlington, VT

Posts: 28

Time spent in forums: < 1 sec
Reputation Power: 0

no can do

Recently went through the headache of trying to do it and had no success. Don't think there is a way - at least not one that I know of.

September 22nd, 2002, 03:16 AM

neutcomp

Registered User

Join Date: Sep 2002

Location: The Netherlands

Posts: 24

Time spent in forums: 1 m 15 sec
Reputation Power: 0

Oke but maby It is possible to include a ASP file into PHP orsomething?

I cant imagine that such sophisicated language cannot make a connection to a access database!

Cya
Bjorn

September 22nd, 2002, 03:35 AM

confuxion

Junior Member

Join Date: Aug 2002

Location: Burlington, VT

Posts: 28

Time spent in forums: < 1 sec
Reputation Power: 0

I agree. You'd think it would be relatively easy. Maybe there is a way - hopefully someone will reply w/ better news.

September 22nd, 2002, 11:26 AM

FrankieShakes

Frank The Tank!

Dev Articles Beginner (1000 - 1499 posts)

Join Date: Jun 2002

Location: Toronto, Canada

Posts: 1,246

Time spent in forums: < 1 sec
Reputation Power: 9

Neutcomp,

Take a look here... You can use Access, you'll just need to use an ODBC driver.

Hope that helps!

__________________
____________________________________________
Developer Shed Weekly Writer | DevArticles Forum Moderator
Build Your Own KlipFolio Klip With PHP
FrankManno.com - Under Construction
Design Interactive Group - Under Construction

September 22nd, 2002, 07:06 PM

Ben Rowe

Guest

Posts: n/a
Time spent in forums:
Reputation Power:

Quote:

I cant imagine that such sophisicated language cannot make a connection to a access database!

Hmm, maybe the guys at php realised that access is a pretty ****ty database and decided not to implement it.

September 22nd, 2002, 07:17 PM

wAr-AnGeL

Forum Security

Join Date: Apr 2002

Location: Behind You

Posts: 479

Time spent in forums: 6 m 50 sec
Reputation Power: 8

lol ya, probably. mysql all the way

__________________

"Only Linux users see the end of crashes."
- Pl4t0

September 22nd, 2002, 07:32 PM

FrankieShakes

Frank The Tank!

Join Date: Jun 2002

Location: Toronto, Canada

Posts: 1,246

Time spent in forums: < 1 sec
Reputation Power: 9

Quote:

Originally posted by Ben Rowe

Hmm, maybe the guys at php realised that access is a pretty ****ty database and decided not to implement it.

Hehehe... Well put! But seriously, Access isn't really a development database... It's uses are more for organization and for personal use.

Think about it, it's packaged with MS Office!

#10

September 22nd, 2002, 09:34 PM

Ben Rowe

Guest

Posts: n/a
Time spent in forums:
Reputation Power:

also when it comes to relational databases, acess would be at the bottom of the list. Im learning asp at the moment, and the book im reading, basically says access suxs balls, and thats putting it in a nice way

#11

September 22nd, 2002, 09:58 PM

confuxion

Junior Member

Join Date: Aug 2002

Location: Burlington, VT

Posts: 28

Time spent in forums: < 1 sec
Reputation Power: 0

easy fellas..

Hey, I couldn't agree w/ you guys more about the deficits Access presents when doing more sophisticated projects. But lets have a little more objectivity here, ah? As web developers, we all may be faced w/ such a situation where either the client implicitly requests this 'dreaded' scenario, or some other mitigating circumstance that may actually force us to explore the notion of making PHP and Access shake hands. Isn't that inclusive of the ultimate goals for open source programming? The ability to break down the proprietary walls built by the would-be software monopolies. Food for thought.

#12

September 24th, 2002, 05:49 PM

FrankieShakes

Frank The Tank!

Join Date: Jun 2002

Location: Toronto, Canada

Posts: 1,246

Time spent in forums: < 1 sec
Reputation Power: 9

Confuxion,

I couldn't agree with you more... But these are just personal preferences that I'm sure most of us have (whether they be the same or not)...

The fact of the matter is that when it comes down to it, you would want to use the best tools to get the job done. If a client requests Access, then by all means you would have to use it. But there are circumstances where informing the client of a better and more efficient product may get the job done sooner, and will reduce costs in the long run. Besides, the alternative may be a low-cost or no-cose (MySQL) solution.

#13

September 24th, 2002, 06:55 PM

confuxion

Junior Member

Join Date: Aug 2002

Location: Burlington, VT

Posts: 28

Time spent in forums: < 1 sec
Reputation Power: 0

Point taken

Yeah, the price issue. Yet another reason to go w/ MySQL, indeed.

#14

September 24th, 2002, 09:13 PM

ejbe99

Contributing User

Join Date: May 2002

Posts: 43

Time spent in forums: 4 m 40 sec
Reputation Power: 8

Guys - MySQL = good for speed. But it's definitely not the best!

#15

September 24th, 2002, 11:26 PM

confuxion

Junior Member

Join Date: Aug 2002

Location: Burlington, VT

Posts: 28

Time spent in forums: < 1 sec
Reputation Power: 0

elaborate, please

So what is, if you don't mind me asking

#16

September 25th, 2002, 03:09 AM

neutcomp

Registered User

Join Date: Sep 2002

Location: The Netherlands

Posts: 24

Time spent in forums: 1 m 15 sec
Reputation Power: 0

Hold!

Oke back to the topic!

PHP Code:


		
			
<?

if (!$conn = new COM("ADODB.Connection"))

exit("Unable to create an ADODB connection<br>");



$strConn = "DRIVER={Microsoft Access Driver (*.mdb)},DBQ=d:\www\thevictory.nl\database\victory  .mdb;", "", ""; 



$conn->open($strConn); 

$conn->Close();



//Do something here!



$conn = null;

?>

This is what I thought it would be. Yes there is no password on it. :-)

Error:
Parse error: parse error in d:\www\thevictory.nl\www\asp\connectie.php on line 12

I also tried this!

PHP Code:


		
			
 $strConn = "DRIVER={Microsoft Access Driver (*.mdb)},DBQ=d:\www\thevictory.nl\database\victory  .mdb;";

Error:
Warning: Invoke() failed: Exception occurred. in d:\www\thevictory.nl\www\asp\connectie.php on line 14

There is NO DSN connection.

Thanxx
Bjorn

#17

September 25th, 2002, 03:22 PM

FrankieShakes

Frank The Tank!

Join Date: Jun 2002

Location: Toronto, Canada

Posts: 1,246

Time spent in forums: < 1 sec
Reputation Power: 9

Quote:

Originally posted by ejbe99
Guys - MySQL = good for speed. But it's definitely not the best!

Not sure if it's the best... I haven't used many other database systems... In fact, we're starting to use Oracle, but I haven't had much experience with it yet.

As for the best database, I think it all comes down to preference and project requirements.

What would you say is the best, if one exists?

#18

September 25th, 2002, 03:25 PM

FrankieShakes

Frank The Tank!

Join Date: Jun 2002

Location: Toronto, Canada

Posts: 1,246

Time spent in forums: < 1 sec
Reputation Power: 9

Re: Hold!

Quote:

Originally posted by neutcomp
Oke back to the topic!

PHP Code:

$strConn = "DRIVER={Microsoft Access Driver (*.mdb)},DBQ=d:\www\thevictory.nl\database\victory .mdb;", "", "";

Bjorn,

Try this:

PHP Code:


		
			
 $strConn = "'DRIVER={Microsoft Access Driver(*.mdb)},DBQ=d:\www\thevictory.nl\database\v  ictory.mdb;','',''";

Try using single quotes.. Other wise try using the concatenation symbol "." to join each part of the connection string.

#19

June 20th, 2005, 12:19 PM

rewen

Registered User

Join Date: Jun 2005

Posts: 1

Time spent in forums: 5 m
Reputation Power: 0

Google ;)

PHP Code:


		
			
<?

$conn = new COM("ADODB.Connection") or die("Cannot start ADO"); 



// Connection string.

$conn->Open("Provider=Microsoft,.Jet.OLEDB.4.0; Data Source=C:\\inetpub\\wwwroot\\php\\mydb.mdb");



// SQL statement to build recordset.

$rs = $conn->Execute("SELECT myfield FROM mytable");



// Display all the values in the records set

while (!$rs->EOF) { 

    echo "Value: ". $rs->Fields("myfield")->value . "<br>\n";

    $rs->MoveNext();

} 

$rs->Close(); 

?>

Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > PHP and Access Database!

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Free IT White Papers!

Create the Optimal Architecture for your Critical Applications
Warburton's the largest independently owned bakery in the UK faced a number of difficult challenges in providing the most robust yet efficient IT infrastructure for their organization's success. IBM's services combined with their xSeries servers created the perfect platform for their SAP environment with sufficient flexibility, and did so in very time effective fashion.
Request Your Free Technology Downloads!

Five Best Practices for Deploying a Successful Service-Oriented Architecture
This white paper describes the benefits you can expect with SOA, and how IBM can help take your business there.
Request Your Free Technology Downloads!

Gartner Magic Quadrant for Application Delivery Controllers
Gartner summarizes its view on Application Delivery Controllers, evaluates strengths and weaknesses of solutions, and provides Magic Quadrant reporting for a quick comparison across all vendors. Learn from Gartner how you can benefit from an all-in-one device like Citrix NetScaler that delivers the highest levels of availability, performance and security.
Request Your Free Technology Downloads!

Knowledge is Power
What you don't know can hurt you, and is likely costing you money and increasing your security risks during an era of scarce resources. This white paper proposes six key strategies that enterprise security managers can use to improve their network defense posture.
Request Your Free Technology Downloads!

Rationalizing the Multi-Tool Environment
The rationalized multi-tool approach is flexible, scalable and cost effective. It provides the necessary input to the IT service management business processes. It preserves prior investments in monitoring tools, empowers technologists to select the best tools with which to do their jobs, and enhances effective response to incidents.
Request Your Free Technology Downloads!

More Free IT White Papers!