Informix SQL Question

[r00tsec]

Just wondering if there were any migration gurus out there. Trying to migrate from an Informix databse to SQL and need to change some of the PHP code

$dbh = DB::connect ($dsn, false);

$sites = get_site_codes();

$sql  = "select distinct abc_code from abc_master ";
$sql .= "where abc_status='A' ";
$sql .= "order by abc_code";
$res = $dbh->query($sql);
while ($row = $res->fetchRow()) {
	$abccode[$row[0]] = $row[0];
}

what would need to be changed in files such as these to switch to my_sql etc. 😕

[kimachi_com]

There are a number of PHP classes which abstract the database from the SQL query. Using such a class means you can program the application logic in a databse neutral sort of a way. Then if your client moves to Oracle or MS SQL 2000 or whatever you keep the same code and change the class config.