son Posted February 7, 2013 Share Posted February 7, 2013 Hi there,Silly question but is MySQLi extension something different to a MySQLi database? I am asking as a new host provides php5 on package we selected. This should normally offer the MySQLi extension. As far as I know it should contain extension since version 4.1. However, host said in correspondence that for a MySQLi database you would need to a different package. Am I now getting here totally confused? Son Link to comment Share on other sites More sharing options...
Ingolme Posted February 7, 2013 Share Posted February 7, 2013 I haven't head of a "MySQLi" database before. PHP's mysqli extension connects to MySQL databases. Link to comment Share on other sites More sharing options...
justsomeguy Posted February 7, 2013 Share Posted February 7, 2013 mysqli supports more of the advanced features that later versions of MySQL have, the older mysql extension doesn't support all of the features. Both extensions connect to the same database. mysqli is designed to work with MySQL 4.1.13 or newer, or 5.0.7 or newer. Link to comment Share on other sites More sharing options...
son Posted February 7, 2013 Author Share Posted February 7, 2013 This is what I thought. So, if host says they have php5, but no mysqli possible this does not make much sense, does it? Son Link to comment Share on other sites More sharing options...
justsomeguy Posted February 7, 2013 Share Posted February 7, 2013 It just means they haven't enabled that extension. Maybe they have a really old version of MySQL, I'm not sure why they wouldn't upgrade that though. It's free to use. Link to comment Share on other sites More sharing options...
callumacrae Posted February 7, 2013 Share Posted February 7, 2013 Ask them to enable it for you. Ask them why not. Change hosting provider. Link to comment Share on other sites More sharing options...
son Posted February 8, 2013 Author Share Posted February 8, 2013 Ok. Got you. They might have php5, but an old version of mysql and this is why they cannot enable mysqli. Do you know from which mysql version onwards mysqli would work? They say that they have mysql 5 and as far as I know we are now around 5.6.sth... Son Link to comment Share on other sites More sharing options...
justsomeguy Posted February 8, 2013 Share Posted February 8, 2013 I wrote that in post 3, you can see the requirements in the PHP manual for the mysqli extension. http://www.php.net/manual/en/mysqli.requirements.php Link to comment Share on other sites More sharing options...
son Posted February 11, 2013 Author Share Posted February 11, 2013 Thanks for this. I also was just now able to see their phpinfo() and it shows: mysqli MysqlI Support enabled Client API library version 5.1.66 Active Persistent Links 0 Inactive Persistent Links 0 Active Links 0 Client API header version 5.1.49 MYSQLI_SOCKET /path/to/mysqld.sock This is looking fine to me. Or is there anything else I would need to check? Think the guys at this huge host might simply not know all the features they offer. Still a bit strange they said it is not possible as this is not selling their product well... Thanks,Son Link to comment Share on other sites More sharing options...
justsomeguy Posted February 11, 2013 Share Posted February 11, 2013 Yeah that's fine, it's enabled. That type of thing happens sometimes, there are even people at the company I work for who will quote "new" features to clients for things that the software already does. Link to comment Share on other sites More sharing options...
son Posted February 12, 2013 Author Share Posted February 12, 2013 Guess I ought to take things with a pinch of salt from now on... Thanks for your help:-) Son Link to comment Share on other sites More sharing options...
Nico Posted March 13, 2013 Share Posted March 13, 2013 You might want to take a look at PDO as well. I think it's much nicer. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now