Mixing PDO and MySQL Functions?

Question

On the existing system its use old MySQL functions.. I would like to replace it all to PDO but it would take a long time and a lot of testing.

Is it possible to mix PDO and MySQL Functions on the existing system? For example new pages/php files will use PDO... All the old files will still use old MySQL for time being and will be replaced slowly as system will continue to update..

+1 for making the effort to switch to pdo. – Spudley Sep 23 '12 at 11:33 — Spudley, Sep 23 '12 at 11:33

score 3 · Accepted Answer · edited May 23 '17 at 11:43

3

Yes, it is perfectly fine to use both at the same time. Keep in mind, though, that you would need a seperate connection for either type and beware of the implications that arise from such an approach.

edited May 23 '17 at 11:43

Community

1
1

answered Sep 23 '12 at 11:26

aefxx

24,835
6
45
55

score 1 · Answer 2 · edited Sep 23 '12 at 11:48

I am new to SO but I have faced this problem too. Many people find it troublesome to switch from mysql_* to PDO.
In my case I was using a separate connection.php that stored functions to connect to database and returned the handle

function connect() 
{ 
    $cn = mysql_connect("localhost","username","pass" );
    $select = mysql_select_db("dbname", $cn);
    return($cn);
}

//For PDO
function pdoconnect()
{
    $db="";
    try
    {
        $db=new PDO("mysql:host=localhost;dbname=dbname", "username", "pass");
        $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }
    catch (PDOException $er)
    {
        print("errr".$er."<br />");
        return(1);
    }
    return($db);
}

while for old functions I used $cn=connect();.
I switched to $cn=pdoconnect(); for new ones.

This worked because I was already using connect.php in old files as well.

When you replaced `$cn=connect();` I switched to `$cn=pdoconnect();` - you still have to replace `mysql_query()` to PDO `prepare()`, `execute()` functions right? — I'll-Be-Back, Sep 23 '12 at 11:35
You clearly are a very experienced programmer, I would be more than glad to know new ways — geekman, Sep 23 '12 at 11:48

Mixing PDO and MySQL Functions?

2 Answers2

Linked