Re: MS Access via OBDC
| From: | Nike | Date: | Wed, 24 May 2000 09:51:22 +0000 |
| Subject: | Re: MS Access via OBDC | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-405@lists.php.net to get a copy of this message | ||
Hello LittleGuru,
Wednesday, May 24, 2000, 4:18:31 AM, you wrote:
L> Hello There!
L> I am an ASP developer and is my second day in the PHP world. I want to
L> connect to my MS Access database using ODBC driver in PHP. Can anyone please
L> give me just an example of how to connect to an Access database and insert a
L> record.
The simplest way is to use ODBC DSN as Access DB alias and SQL "INSERT"
construct.
$id = odbc_connect($dsn,$dsn_user,$dsn_pass);
$query = "insert into $you_db ($field1, $field2,$field3,...) values
($value1,$value2,...)";
$result = odbc_exec($id, $query);
Best regards,
Nike mailto:nike@sendmail.ru