Access db's via PHP

ginga

Okie dokie,
can anyone do me a favour and tell me how to connect to and output data from an access database with php.

Ive had a look for tutorials and what not but all i can find is connecting to and inputting data, whereas i need to output it onto a page 😃

help plz thx 🙂

flipis

You need a dsn under Windows. I assume you know how to do that. (Init-Control Panel-Data Origins)

After, use this:

$Connection = odbc_connect("dsn_name","user","password");

I recommend you not to set up a user and password at the beginning. Experiment with ODBC functions.

http://www.php.net/odbc

Hope this helps

fLIPIS

ginga

yeah ive setup dsn correctly, its just the code side im unsure about,
thanks muchly 🙂

a tutorial would be greatly received 😃

flipis

Well...

I don't have the time to write a tut (i should, as a matter of fact), but i can give some sample code. Here it goes:

<?
$Conn = odbc_connect("dsn","","");
$Query = odbc_query($Conn,"SELECT field FROM table WHERE id = 1");

/
Now, just one BIG problem. odbc_num_rows doesn't work (not because of PHP, but because of Microsoft way of doing things)
Use odbc_fetch_row for iterating through results.
/

$result = odbc_result($Query,"field");
echo $result;
?>

Hope this helps

fLIPIS

ginga

perfect mate
thankyou alot 🙂

ginga

Okay i tried and got a lovely error that i have no idea about 🙂

this is my code

-- CODE --
<?
$Conn = odbc_connect("intranet","","");
$Query = odbc_query($Conn,"SELECT id, surname, firstname, department, extention, mobile FROM phonelist ORDER BY $phonesort ASC");
while (list($id, $surname, $firstname, $department, $extention, $mobile) = odbc_fetch_row($Query))
{
?>
<tr>
<td style="border-left-width: 1; border-right-width: 1; border-top-style: dashed; border-top-width: 1; border-bottom-width: 1">
<? echo("$surname"); ?></td>
<td style="border-left-width: 1; border-right-width: 1; border-top-style: dashed; border-top-width: 1; border-bottom-width: 1">
<? echo("$firstname"); ?></td>
<td style="border-left-width: 1; border-right-width: 1; border-top-style: dashed; border-top-width: 1; border-bottom-width: 1">
<? echo("$department"); ?></td>
<td style="border-left-width: 1; border-right-width: 1; border-top-style: dashed; border-top-width: 1; border-bottom-width: 1">
<? echo("$extention"); ?></td>
<td style="border-left-width: 1; border-right-width: 1; border-top-style: dashed; border-top-width: 1; border-bottom-width: 1">
<? echo("$mobile"); ?></td>
</tr>
<?
}
?>
-- CODE --

and i got this Error

-- ERROR --

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\intranet\phonelist.php on line 36

Fatal error: Call to undefined function: odbc_query() in C:\intranet\phonelist.php on line 37

-- ERROR --

Help? 🙁

anyone wanna debug my code? 🙂

</n00b>

flipis

Welcome to the wonderful world of Microsoft ODBC controllers. The only thing i can say to you is this:

I spent 1 month coding a simple script to get data from Access and put it into MySQL.

You're gonna get more error codes like that, for sure. Mess round with it, tweak it, and you'll find the solution.

Oh, if you want to, send me ALL of the code ALONG with the db (delete private data), and i'll set it up on my machine and give you the solution.

fLIPIS

ginga

okies
u got icq or msn or somethign i can dcc it across ? 🙂