Does your host support mysqli and pdo by default?
 

How common are mysqli and PDO mysql? Do most hosts have them installed and enabled by default?

I'm learning PHP and I'm writing small scripts. Is it a good idea to use mysqli or pdo mysql in scripts I plan on selling?

If your host doesn't support mysqli or pdo then leave them immediately.

And yes you should use pdo. Mysqli if pdo is not available.

Mojo didn't enable them by default, but all it takes is ticket and a few minutes.

Dreamhost, Hostgator and Servage have PDO.

It's not default on most hosts,but it is easy to enable it.

Thank you. I'm surprised no hosting companies have replied yet.

Probably because this board is visited by sales reps,not tech people so there is chance how they dont have a clue what is mysqli and pdo :upsidedow

PDO and mysqli i believe are both technically add-ons, thus they would not be in a "normal" source build, that being said suhosin is also an add-on but is almost always present.

Both are available on the shared hosting servers and are also included with the default installs on our dedicated servers: http://main.xenlayer.com/phpinfo.php - it's also PHP 5.4 instead of 5.3, which outperforms it in almost every way.

Now on VPS servers we sometimes disable them to save resources. Same goes for Apache, we do custom Nginx configurations on smaller VPS accounts on request.

My first reaction was: how long until a rep replies that their servers come mysql installed :winkwink:

Thank you.

Seeing that most php tutorials now mention PDO or mysqli and that those addons are being recommended on PHP boards, I would have expected them to be present on modern systems.

PDO is not an extension (anymore) like mcrypt or gd, it's enabled by default in PHP now, it's part of the core. I think cPanel is pretty much the only control panel that explicitly disables it by default, but that's easy to change in WHM. People are using it more and more.

If your host doesn't allow PDO or MySQLi switch asap.

it only takes a min or two to adjust the settings