Page 1 of 1

Help linking to my Access database

Posted: Mon May 07, 2007 1:26 pm
by mattonline
i'm very much lost now, i've been researching all day and come to nother lol.

Site: http://0q6.com/index.asp

What i want is, when a user inputs the domain in the 'domain text box' e.g. expiringdomain.com i want it to store in a Access database When the user clicks a submit button. What code will i need to make this work

Access database name: Dropcatcher
Access Table: Domains
Filed: Domains - i want the domain to be stored in this field.

Descriptive subjects

Posted: Mon May 07, 2007 1:36 pm
by RobertGonzalez
Please use a more descriptive title, according to our forum rules:
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.
As it relates to connecting to a database, that is covered in just about every tutorial there is on PHP. Connecting to a MySQL database would use either the mysql_* family of functions or the mysqli_* family of functions. Connecting to Access would require using ODBC functions.

You could also look into using PDO for a universal database abstraction interface.

Posted: Mon May 07, 2007 3:43 pm
by mattonline
Ok didn';t read them, changed the title and updated my whole thread, i now want to store the files in Access

Posted: Mon May 07, 2007 4:48 pm
by RobertGonzalez
odbc_connect()

Start with this one. See if you can connect. You may need to set up a DSN and connect using that.