Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > Microsoft Access Development
Reload this Page

PHP and Access Database!

Discuss PHP and Access Database! in the Microsoft Access Development forum on Dev Articles.
PHP and Access Database! Microsoft Access Development forum to discuss problems and solutions with this popular DBMS. Use Access to build and modify database tables, or full-featured applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old September 21st, 2002, 04:12 PM
neutcomp neutcomp is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Sep 2002
Location: The Netherlands
Posts: 24 neutcomp User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 50 sec
Reputation Power: 0
Send a message via ICQ to neutcomp
Question 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
Reply With Quote
  #2  
Old September 21st, 2002, 11:33 PM
Ben Rowe
Guest
Dev Articles Newbie (0 - 499 posts)
  
Posts: n/a  
Time spent in forums:
Reputation Power:
i dont know if you cant connect to an access database with php???
Reply With Quote
  #3  
Old September 22nd, 2002, 01:10 AM
confuxion confuxion is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2002
Location: Burlington, VT
Posts: 28 confuxion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.
Reply With Quote
  #4  
Old September 22nd, 2002, 03:16 AM
neutcomp neutcomp is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Sep 2002
Location: The Netherlands
Posts: 24 neutcomp User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 50 sec
Reputation Power: 0
Send a message via ICQ to neutcomp
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
Reply With Quote
  #5  
Old September 22nd, 2002, 03:35 AM
confuxion confuxion is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2002
Location: Burlington, VT
Posts: 28 confuxion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.
Reply With Quote
  #6  
Old September 22nd, 2002, 11:26 AM
FrankieShakes FrankieShakes is offline
Frank The Tank!
Dev Articles Beginner (1000 - 1499 posts)
  
Join Date: Jun 2002
Location: Toronto, Canada
Posts: 1,246 FrankieShakes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Send a message via ICQ to FrankieShakes Send a message via MSN to FrankieShakes
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
Reply With Quote
  #7  
Old September 22nd, 2002, 07:06 PM
Ben Rowe
Guest
Dev Articles Newbie (0 - 499 posts)
  
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.
Reply With Quote
  #8  
Old September 22nd, 2002, 07:17 PM
wAr-AnGeL wAr-AnGeL is offline
Forum Security
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2002
Location: Behind You
Posts: 479 wAr-AnGeL User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 50 sec
Reputation Power: 7
Send a message via ICQ to wAr-AnGeL Send a message via AIM to wAr-AnGeL
lol ya, probably. mysql all the way
__________________




"Only Linux users see the end of crashes."
- Pl4t0
Reply With Quote
  #9  
Old September 22nd, 2002, 07:32 PM
FrankieShakes FrankieShakes is offline
Frank The Tank!
Dev Articles Beginner (1000 - 1499 posts)
  
Join Date: Jun 2002
Location: Toronto, Canada
Posts: 1,246 FrankieShakes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Send a message via ICQ to FrankieShakes Send a message via MSN to FrankieShakes
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!
Reply With Quote
  #10  
Old September 22nd, 2002, 09:34 PM
Ben Rowe
Guest
Dev Articles Newbie (0 - 499 posts)
  
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
Reply With Quote
  #11  
Old September 22nd, 2002, 09:58 PM
confuxion confuxion is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2002
Location: Burlington, VT
Posts: 28 confuxion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.
Reply With Quote
  #12  
Old September 24th, 2002, 05:49 PM
FrankieShakes FrankieShakes is offline
Frank The Tank!
Dev Articles Beginner (1000 - 1499 posts)
  
Join Date: Jun 2002
Location: Toronto, Canada
Posts: 1,246 FrankieShakes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Send a message via ICQ to FrankieShakes Send a message via MSN to FrankieShakes
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.
Reply With Quote
  #13  
Old September 24th, 2002, 06:55 PM
confuxion confuxion is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2002
Location: Burlington, VT
Posts: 28 confuxion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Point taken

Yeah, the price issue. Yet another reason to go w/ MySQL, indeed.
Reply With Quote
  #14  
Old September 24th, 2002, 09:13 PM
ejbe99 ejbe99 is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: May 2002
Posts: 43 ejbe99 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 40 sec
Reputation Power: 7
Guys - MySQL = good for speed. But it's definitely not the best!
Reply With Quote
  #15  
Old September 24th, 2002, 11:26 PM
confuxion confuxion is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Aug 2002
Location: Burlington, VT
Posts: 28 confuxion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
elaborate, please
So what is, if you don't mind me asking
Reply With Quote
  #16  
Old September 25th, 2002, 03:09 AM
neutcomp neutcomp is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Sep 2002
Location: The Netherlands
Posts: 24 neutcomp User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 50 sec
Reputation Power: 0
Send a message via ICQ to neutcomp
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
Reply With Quote
  #17  
Old September 25th, 2002, 03:22 PM
FrankieShakes FrankieShakes is offline
Frank The Tank!
Dev Articles Beginner (1000 - 1499 posts)
  
Join Date: Jun 2002
Location: Toronto, Canada
Posts: 1,246 FrankieShakes User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Send a message via ICQ to FrankieShakes Send a message via MSN to FrankieShakes
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?
Reply With Quote