Connection to MySQL using ODBC driver in PHP code

Question

I have a simple code for selecting data using MySQl and PHP. Here it is:

<?php
require_once 'login.php' ;

$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if (!$db_server) die ("Unable to connect to MySQL: " . mysql_error());

mysql_select_db($db_database)
or die("Unable to choose DB: " . mysql_error());

$query = "SELECT * FROM bank";
$result = mysql_query($query);
if (!$result) die ("Failed with connection to DB: " . mysql_error());
$rows = mysql_num_rows($result);
for ($j=0; $j < $rows; ++$j) { 
$row = mysql_fetch_row($result);
echo 'MFO: '   . $row[0] . '<br/>';
echo 'NAME: '  . $row[1] . '<br/>';
echo 'STATE: ' . $row[2] . '<br/><br/>';
}   
?>

But i have to use ODBC driver instead of standard integrated driver. I've read a lot of information but haven't find anything , so maybe someone help what should i add or rewrite in this code for using ODBC ?

René Höhle · Accepted Answer · 2013-09-29 21:11:26Z

1

There are a lot of odbc functions in PHP.

http://php.net/manual/en/function.odbc-connect.php

You can connect with this functions to mysql and other databases. In the commments on php.net you can find some examples how to connect to MySQL.

http://www.mysql.de/products/connector/

Here you can find an ODBC driver for MySQL.

answered Sep 29, 2013 at 21:11

René Höhle

27.4k22 gold badges78 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kostya Cherno Over a year ago

I've downloaded it actually. I guess i have to do something with DSN.

Collectives™ on Stack Overflow

Connection to MySQL using ODBC driver in PHP code

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related