answersLogoWhite

0


Best Answer

Something I never thought about doing before, but this is possible.

First, you must make sure that your PHP installation has ODBC capabilities. If it does not. see http://php.net/odbc

You must use PHP's ODBC commands. I have never worked with these, you I cannot help you any further. I would recommend a mySQL database. It's simpler and more widely used in the field of web design. I could help you with that instead.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you use an Access database with PHP?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a database in PHP?

Database = Where you save your data (ex: if a user fill your registration form, entered data should be saved somewhere, that's database) Usually in PHP we use MySQL Database.


information on online access training.?

http://apex.vtc.com/access-2010.php is great place for you. You can get video tutorials for only 30$. You have also many free demos for Introduction , Database Basics and Database Design Basics.


Why to use use MYSQL with PHP and not anyother database?

You can connect any DB via PHP if you have database specific database extensions defined. LAMPP stack refer to 'Linux Apache Mysql PHP Perl'. Hence this stack is famous for php development as it include all the needed components for web development. Mysql is preferred mostly because it's extension is added by default in XAMPP or WAMPP stack.


How do you handle database in php?

Please refer link. The presentation gives complete understanding of how to deal with database (Mysql) with php.


How do you close a MySQL database connection using PHP?

To close your MySQL database connection you need to use the mysql_close() function. Please see the example below: <?php mysql_close(); ?> If your connection data is stored in a variable you would close the connection like this instead: <?php mysql_close($db_conn); ?> That's useful for if you're using more than one database connection in a PHP script.


How do you delete data from a MySQL database using PHP?

To delete data from your MySQL database you need to use the mysql_query() function. Please see the example below: <?php mysql_query("DELETE FROM table_name WHERE field_name = 44"); ?>


What proportion of websites are dynamic say php?

A possible use case for dynamic content via PHP may be:page content (add content to a database and fetch it with PHP)news (news entries from a database or a file are read and put out to the user)forumsfaqjust to name a few


How do you escape database queries with PHP?

Use mysql_real_escape_string(), after you've connected to your database. If that function doesn't work, use mysql_escape_string() or addslashes(). Never leave your database input vulnerable to attack.


Where can you find some php scripts that support postgresql?

Use PDO (PHP DATA OBJECTS) to write your queries. They include support most major database


What is 2 tier architecture in PHP?

Client-Server model is a form of 2 Tier architecture in PHP. With use of database it becomes a 3 Tier architecture


Is Access a database software application?

Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.Microsoft Access is a database.


How do you retrieve username and password from sql database to HTML web page?

You would need to use PHP