Go4Expert

Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   PHP in DSN Less Conection Database Ms-Access (http://www.go4expert.com/forums/php-dsn-conection-database-ms-access-t18280/)

itsys 1Jul2009 13:32

PHP in DSN Less Conection Database Ms-Access
 
PHP Code:

<?php

//create an instance of the  ADO connection object
$conn = new COM ("ADODB.Connection")
  or die(
"Cannot start ADO");

//define connection string, specify database driver
$connStr "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= C:\\wamp\\www\\test1\\database\\directorydb.mdb";
  
$conn->open($connStr); //Open the connection to the database

//declare the SQL statement that will query the database
$query "SELECT Category FROM tblCategories";

//execute the SQL statement and return records
$rs $conn->execute($query);

$num_columns $rs->Fields->Count();
echo 
$num_columns "<br>";

for (
$i=0$i $num_columns$i++) {
    
$fld[$i] = $rs->Fields($i);
}

echo 
"<table>";

while (!
$rs->EOF)  //carry on looping through while there are records
{
    echo 
"<tr>";
    for (
$i=0$i $num_columns$i++) {
        echo 
"<td>" $fld[$i]->value "</td>";
    }
    echo 
"</tr>";
    
$rs->MoveNext(); //move on to the next record
}


echo 
"</table>";

//close the connection and recordset objects freeing up resources
$rs->Close();
$conn->Close();

$rs null;
$conn null;
?>


itsys 1Jul2009 13:35

Re: PHP in DSN Less Conection Database Ms-Access
 
I have Create DSN Less Connection. Data Source= C:\\wamp\\www\\test1\\database\\directorydb.mdb";
I have give the full path data base. When the uplode appliction on server. what changes the path
Thanaks

shabbir 1Jul2009 14:06

Re: PHP in DSN Less Conection Database Ms-Access
 
Use Code blocks for Code snippets in posts and also confine links to signatures only


All times are GMT +5.5. The time now is 17:46.