[RESOLVED] mysqli - any converting sources back to mysql?

christillis

Hi all,

I've been reading up on mysqli and found out the unpleasant way that my hosting only provides mysql!

Are there any resources that convert commands/functions from one to the other? It appears that just adding or removing an 'i' doesn't cut the mustards.

Looking forward to some comments!

Cheers,
Chris

laserlight

Why not request that mysqli be provided by your host?

christillis

laserlight;10879692 wrote:
Why not request that mysqli be provided by your host?

I've tried that sadly - they said that it's up to the cpanel people to decide when to upgrade 🙁

laserlight

I've tried that sadly - they said that it's up to the cpanel people to decide when to upgrade

It sounds like they are lazy: cPanel should have nothing to do with this. Worse still, they might be incompetent, thinking that they must drop MySQL support in order to provide MySQLi support, thus affecting their cPanel installations, when actually they can run both extensions simultaneously.

Could you post their response?

christillis

Hmm, they're normally very helpful. Here's the emails:

ME (Question): "Sorry about this, another little question. is it easy for you to upgrade mysql to 4.1.3 or beyond (not 5 though!)???

I only ask cos the manual I'm using uses that format and I'll confuse meself by having to convert all the time. I've tried swapping 'i' phrases for non 'i' ones and that doesn't shake the mustard."

THEM (Answer): "Sorry but currently i would have to say no as cpanel forces the use of either 4.1+ or 5.0+, you don't get a choice as to what the + is,
currently the server is running "4.1.22" the only way it will get to 4.1.3+ is when cpanel (the company) decides to update
the version."

THanks for your help on this

christillis

...actually, he did say 4 or 5 versions...so perhaps I should bite the bullet and go for 5? 😕

laserlight

hmm... sounds like you have misinterpreted their answer, though the answer was a little strange. They are talking about MySQL version. Unlike the MySQL extension, the MySQLi extension allows you to use MySQL 4.1+ functionality not present in earlier versions of MySQL.

Now, you asked if "is it easy for you to upgrade mysql to 4.1.3 or beyond (not 5 though!)". The answer given says that cPanel requires MySQL 4.1 or 5.0, and that you do not get a choice of which. Furthermore, the currently installed version of MySQL is 4.1.22.

The thing is, you want the version of MySQL to be "4.1.3 or beyond". 4.1.22 is the latest version of MySQL that meets your requirement, so ironically the answer, despite being an apology, tells you precisely what you want to hear!

What it does not say is whether the MySQLi extension is installed, so to conclude from your correspondence that it is not installed is jumping to conclusions.

christillis

Firstly, may I just say thank you laserlight, you're being very helpful to someone who should just read a manual and keep himself to himself!

I'm afraid I wasn't aware that 'i' was an extension, I've emailed the hosting company to verify if I have it or not. In the meantime I checked the 'php info' page and it does appear that mysqli is enabled...

Configure Command
'./configure' '--with-apxs=/usr/local/apache/bin/apxs' '--prefix=/usr/local' '--with-xml' '--enable-bcmath' '--enable-calendar' '--with-curl' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--enable-exif' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--with-iconv' '--with-imap=/usr/local/imap-2004g' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt' '--with-mhash' '--enable-magic-quotes' '--with-mysqli' '--with-mysql=/usr' '--with-openssl' '--enable-discard-path' '--with-pear' '--with-pspell' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--enable-versioning' '--enable-wddx' '--with-xmlrpc' '--with-zip' '--with-zlib'

i'm just going to do a script test to verify.

I also apologise for not using my brain matter and figuring out that 4.1.3 is 'older' than 3.1.22 (blush).

I'll update soon (and probably tack on 'resolved').

Thank you laserlight 'thumbup'.

laserlight

I also apologise for not using my brain matter and figuring out that 4.1.3 is 'older' than 3.1.22 (blush).

Heh, I think the tech support person made the same mistake 🙂

christillis

laserlight;10879709 wrote:
Heh, I think the tech support person made the same mistake 🙂

😃 I would have to agree!:p

christillis

Here's an update - I asked my hosting co. to give me mysqli extensions and he's done this. It works!:

I placed a .htaccess file in the folder where you are running that code

with the contents
############################################
AddHandler application/x-httpd-php5 .php .php4 .php3 .phtml
##############################################

which makes Apache use PHP5 for that folder, and it appears to be working now so i presume the
code you are using is specific to PHP5

Thanks again for phpbuilders cheeky but helpful 'lasernight' 😉