Does your host support mysqli and pdo by default? - GoFuckYourself.com

WalkerTR · 01-02-2013, 06:24 PM

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?

Killswitch · 01-02-2013, 07:02 PM

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.

u-Bob · 01-02-2013, 07:04 PM

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

BaldBishop · 01-03-2013, 05:33 AM

Dreamhost, Hostgator and Servage have PDO.

Klen · 01-03-2013, 06:15 AM

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

WalkerTR · 01-03-2013, 08:05 AM

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

Klen · 01-04-2013, 06:20 AM

Quote:

Originally Posted by WalkerTR

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

Why · 01-04-2013, 11:26 AM

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.

AndrewX · 01-04-2013, 01:17 PM

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.

u-Bob · 01-04-2013, 02:52 PM

Quote:

Originally Posted by KlenTelaris

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

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

WalkerTR · 01-04-2013, 03:45 PM

Quote:

Originally Posted by AndrewX

Both are available on the shared hosting servers and are also included with the default installs on our dedicated servers

Thank you.

WalkerTR · 01-04-2013, 03:48 PM

Quote:

Originally Posted by Why

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.

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.

AndrewX · 01-04-2013, 04:25 PM

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.

Killswitch · 01-04-2013, 04:41 PM

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

fris · 01-04-2013, 07:38 PM

it only takes a min or two to adjust the settings

01-02-2013, 06:24 PM	#1
WalkerTR Confirmed User Join Date: Jun 2006 Posts: 1,646	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? __________________ Blog Commenting Ninja: Special offer: $47.

01-02-2013, 07:02 PM	#2
Killswitch 👏 REVOLUTIONARY 👏 Industry Role: Join Date: Oct 2012 Posts: 2,326	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. __________________

01-03-2013, 05:33 AM	#4
BaldBishop Confirmed User Join Date: Jul 2005 Posts: 2,115	Dreamhost, Hostgator and Servage have PDO. __________________

01-03-2013, 08:05 AM	#6
WalkerTR Confirmed User Join Date: Jun 2006 Posts: 1,646	Thank you. I'm surprised no hosting companies have replied yet. __________________ Blog Commenting Ninja: Special offer: $47.

01-04-2013, 01:17 PM	#9
AndrewX Confirmed User Industry Role: Join Date: Jan 2004 Posts: 574	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. __________________ █ ► XenLayer - Paravirtualization Professionals since 2008 - [ICQ: 297820698] █ ► Reseller Hosting \| OpenVZ VPS \| XEN VPS \| Dedicated Servers Last edited by AndrewX; 01-04-2013 at 01:21 PM..

01-02-2013, 07:04 PM	#3
u-Bob there's no $$$ in porn Industry Role: Join Date: Jul 2005 Location: icq: 195./568.-230 (btw: not getting offline msgs) Posts: 33,063	Mojo didn't enable them by default, but all it takes is ticket and a few minutes.

01-03-2013, 06:15 AM	#5
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	It's not default on most hosts,but it is easy to enable it.

01-04-2013, 11:26 AM	#8
Why MFBA Industry Role: Join Date: Mar 2003 Location: PNW Posts: 7,230	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.

01-04-2013, 04:25 PM	#13
AndrewX Confirmed User Industry Role: Join Date: Jan 2004 Posts: 574	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. __________________ █ ► XenLayer - Paravirtualization Professionals since 2008 - [ICQ: 297820698] █ ► Reseller Hosting \| OpenVZ VPS \| XEN VPS \| Dedicated Servers Last edited by AndrewX; 01-04-2013 at 04:31 PM..

01-04-2013, 04:41 PM	#14
Killswitch 👏 REVOLUTIONARY 👏 Industry Role: Join Date: Oct 2012 Posts: 2,326	If your host doesn't allow PDO or MySQLi switch asap. __________________

01-04-2013, 07:38 PM	#15
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,359	it only takes a min or two to adjust the settings __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff