Should ssp.class.php work with Oracle?

Should ssp.class.php work with Oracle?

PhilJonesPhilJones 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.

Answers

  • allanallan Posts: 63,791Questions: 1Answers: 10,513 Site admin

    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

This discussion has been closed.