PHP to MS Access help. thanks.?
-
Hi, I have php document on a server. This document should connect to a MS Access database and store a record. I cannot get it to work. How do I get the php to send the data into the access database? Thanks.
-
Answer:
first you need to make sure your PHP server has the correct modules to connect to Access. Be sure that you have the ODBC module. The look at the site below for a quick tutorial.
WYSIWYG at Yahoo! Answers Visit the source
Other answers
PHP doesn't have native MS Access capabilities, but it does have ODBC capability, which is almost the same thing. It'll just be a bit of a performance hit. In any case, you have to create a DSN (Control Panel -> Administrative Tools -> Datasources) Then you'd use the built in PHP ODBC functions (odbc_connect, odbc_exec) to work with the datasource.
use SQL command to connect, write, read and execute MS db.
....
mind showing your existing code? it basically works with sql statements but im guessing you have more problems than that also access is bullshit, if you are learning php i suggest you scrap the access and use mysql instead, in real world programming almost nobody uses access, certainly not for websites(where php is mainly used)
Related Q & A:
- How to convert my SQL query to MS Access query?Best solution by Stack Overflow
- How to store data in php and get data from php?Best solution by Stack Overflow
- Why cant i view my contacts display image? please help if you know ,thanks?Best solution by Yahoo! Answers
- How do i scan something? First time using a scaner and i dont think im doing it right. help. thanks?Best solution by Yahoo! Answers
- I can't access my e-mail account. Please help.Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.