If I had to choose between MS SQL Server or or mysql, which would you recommend? I prefer nested subqueries, triggers, procedures etc supported by SQL Server but am completely unfamiliar with any problems that may be accociated with using Microsoft's product and PHP.
Ideally, I would use Oracle but it is probably outside of our budget.
- matt
Bastien Koert wrote:
Here is a basic connect script. I would stringly recommend against using access, use mysql instead.
<HTML> <HEAD> </HEAD>
<BODY>
<?php
// Program to test connecting to a Microsoft Access ODBC Data Source $connection = odbc_connect("postcard", "", ""); print "Connected to datasource<BR><BR>";
if ($result = odbc_exec($connection, "SELECT * FROM postcard")) print "Command executed successfully<BR><BR>"; else print "Error while executing command<BR><BR>";
// Print results
while(odbc_fetch_row($result))
print odbc_result($result, 1) . " " . odbc_result($result, 2) . " " . odbc_result($result, 3) . " " . odbc_result($result, 4) . " " . odbc_result($result, 5) . "<BR>";
odbc_close($connection); print "<BR>Connection closed.";
?>
</BODY> </HTML>
bastien
From: Matthew Perry <mwperry@xxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx Subject: microsoft access Date: Thu, 30 Sep 2004 21:28:48 -0500
Does anyone know of a good online source for using php and microsoft access. I don't want to have to use asp.
Thank you for your time.
Matthew Perry
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
MSN® Calendar keeps you organized and takes the effort out of scheduling get-togethers. http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php