ASP TO PHP

[Anon]

Anybody can help me converting this ASP code to PHP ?!?

<%
Set connection=server.createobject("ADODB.connection")
connection.open "DRIVER={Client Access ODBC Driver (32-bit)};System=10.200.0.110;UID=Randak;PWD=Animal"
%>

<%
count = 0
sql1 = "SELECT V62BPCSF.MBM.BPROD, V62BPCSF.IIM.IPROD, V62BPCSF.IIM.IDESC FROM V62BPCSF.MBM INNER JOIN V62BPCSF.IIM ON V62BPCSF.MBM.BCHLD = V62BPCSF.IIM.IPROD WHERE (((V62BPCSF.MBM.BPROD)='P0200763A4'))"

Set request1= connection.execute(sql1)
%>

[Anon]

There is an article here @ phpbuilder.com about interfacing with an MS Access database trhough PHP's ODBC capabilities:

http://www.phpbuilder.com/columns/siddarth20000228.php3

It seems that you have already got the DB and the DSN setup... If not, read the tutorial... As for the code.... Something like this should do the trick (Althought I didn't test it out):

$dsn = odbc_connect('10.200.0.110','Randak','Animal') or die("Could not connect to DSN.");

$count = 0;
$query = odbc_exec($dsn,"SELECT V62BPCSF.MBM.BPROD, V62BPCSF.IIM.IPROD, V62BPCSF.IIM.IDESC FROM V62BPCSF.MBM INNER JOIN V62BPCSF.IIM ON V62BPCSF.MBM.BCHLD = V62BPCSF.IIM.IPROD WHERE (((V62BPCSF.MBM.BPROD)='P0200763A4'))") or die("Database Query Failed");
$result = odbc_fetch_array($query);

Now, $result should contain the fields you queried for in an associative array (BPROD, IPROD, and IDESC far as I can see).

Also, you can find more PHP ODBC info here @ the manual:

http://www.php.net/manual/en/ref.odbc.php

-Josh