Does datatables require the PDO mysqli driver to function?

Does datatables require the PDO mysqli driver to function?

david-giorgidavid-giorgi Posts: 5Questions: 2Answers: 0
edited November 2019 in General

We have a legacy Opencart project that we are migrating to custom admin. The Opencart mysqli connection string is working all ok (driver: mysqli). However when we try to use datatables we get : "could not find driver" error (The PHP phpinfo() on AWS/EC2 only lists sqlite and no mysql under PDO drivers). Many thanks for any pointers to resolve.

This question has an accepted answers - jump to answer

Answers

  • david-giorgidavid-giorgi Posts: 5Questions: 2Answers: 0

    ..my mistake the title of this question should be: "Does datatables require the PDO mysqli driver to function?" (I could not edit from my account)

  • allanallan Posts: 61,439Questions: 1Answers: 10,053 Site admin
    Answer ✓

    Yes, our libraries use PDO, so the MySQL PDO driver is required if you want to use the libraries with MySQL.

    You can use phpinfo to find out what PDO drivers you have installed (search for pdo on the generated page).

    Allan

  • david-giorgidavid-giorgi Posts: 5Questions: 2Answers: 0

    Thanks, Allan :) If possible please amend the typo in my title so others can find your answer.

This discussion has been closed.