PHP & access

denis · Guest

how do i use php and access database for a website,where can i seekl info bout it.sample code etc

lostboy · Joined: 02 May 2004 Posts: 6033 Location: toronto, canada

have you worked this out yet? The basics are ODBC and setting a dsn for the access db...

ddwebguru · Joined: 16 Jul 2008 Posts: 195 Location: India

You have to define the path for your database from administrative tool of your computer,then you will be able to link.

nilapsa · Joined: 16 Feb 2010 Posts: 1

The php is most often used to create dynamic websites ans projects include forums or communities organizers, project management tools, calendars, shopping carts, mailing lists, and all sorts of useful applications. And the php is server side scripting language such as ASP and JSP. Thank you for sharing this useful information with us.

lahmanwokard · Joined: 15 Feb 2010 Posts: 4 Location: london

Hello denis
An ODBC simple Example to access Database to your website
The following example shows how to first create a database connection, then a result-set, and then display the data in an HTML table.

Connecting to an ODBC
The odbc_exec() function is used to execute an SQL statement.
Example
$conn=odbc_connect('northwind','','');
$sql="SELECT * FROM customers";
$rs=odbc_exec($conn,$sql);

<html>
<body><?php
$conn=odbc_connect('northwind','','');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM customers";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
echo "<table><tr>";
echo "<th>Companyname</th>";
echo "<th>Contactname</th></tr>";
while (odbc_fetch_row($rs))
{
$compname=odbc_result($rs,"CompanyName");
$conname=odbc_result($rs,"ContactName");
echo "<tr><td>$compname</td>";
echo "<td>$conname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?></body>
</html>
Hope it will useful for you.

StephenHarry · Joined: 17 May 2010 Posts: 2

Thanks for sharing the code by which we can learn the database connectivity.

vipin kumar · Joined: 05 Apr 2010 Posts: 26

can we use php easily?

lostboy · Joined: 02 May 2004 Posts: 6033 Location: toronto, canada

Paul Daniel · Joined: 12 May 2010 Posts: 63

Hi
Refer this link

http://www.astahost.com/info.php/Connecting-Ms-Access-Php-Odbc_t12828.html