Should ssp.class.php work with Oracle?
Should ssp.class.php work with Oracle?
PhilJones
Posts: 10Questions: 2Answers: 0
Hi
Should ssp.class.php work with Oracle? My understanding is that PDO is pretty interchangeable, are there any MySQL specific functions and such in ssp.class.php that I need to convert?
$db = @new PDO(
"mysql:host={$sql_details['host']};dbname={$sql_details['db']}",
$sql_details['user'],
$sql_details['pass'],
array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION )
);
guess this can be changed to a Oracle PDO string.
This discussion has been closed.
Answers
No - the default SSP class uses a MySQL specific option (
SQL_CALC_FOUND_ROWS
) which would need to be replaced.You are correct that PDO is fairly interchangable, but it doesn't account for differences in the SQL methods and syntax for each database.
Allan