Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

mysqli extensions

Asked Modified Viewed 3,408 times
B
brianhall
B
  • Junior Member, joined since
  • Contributed 20 posts on the community forums.
  • Started 8 threads in the forums
  • Started this discussions
asked
Junior Member

can php-fusion use mysqli extensions. I can't really make any changes without it affecting the mail server for domains hosted on the same server.

which files contain the mysql statements. could someone list which files contain them.

Then I can work my way through changing the syntax of the statements to use mysqli.

Many Thanks
Brian
0 replies

8 posts

B
brianhall
B
  • Junior Member, joined since
  • Contributed 20 posts on the community forums.
  • Started 8 threads in the forums
  • Started this discussions
answered
Junior Member

Hey, me again
Dont mean to be pushy but is there anyone who could help with the above problem..
Having to use a free webhosting company rather than my own http://www.hdotcom.net to run php-fusion, and am running out of space with the free one.

So any help would be great
Many Thanks
Brian
Edited by brianhall on 10-10-2006 17:08,
0 replies
B
bbene
B
bbene 10
Ben Benesh
Support Team Member
  • Member, joined since
  • Contributed 74 posts on the community forums.
  • Started 1 thread in the forums
answered
Member

If I rember correctly, it should work with the mysqli extensions. I think that it is the other way around and will not work without them on PHP 5.
0 replies
B
brianhall
B
  • Junior Member, joined since
  • Contributed 20 posts on the community forums.
  • Started 8 threads in the forums
  • Started this discussions
answered
Junior Member

the mysql server and web server have been configured with mysqli extnesions and not the other lesser ones
0 replies
M
mpkossen
M
  • Senior Member, joined since
  • Contributed 267 posts on the community forums.
  • Started 4 threads in the forums
answered
Senior Member

But as he said, it works with PHP5, which utilises MySQLi extensions.

What's the exact problem, because I don't quite understand.
0 replies
B
brianhall
B
  • Junior Member, joined since
  • Contributed 20 posts on the community forums.
  • Started 8 threads in the forums
  • Started this discussions
answered
Junior Member

The server is currently using PHP5 and has been since the start of this year.

The problem is that in all the the files I look at relate to PHP Fusion, they only reference the mysql extensions, where I would expect to see the MySQLi extensions, or even both depending on how clever the script was.

I could manually go through the files and locate where these are and then change them to the MySQLi extensions however this could take some time.

PHP5 can be configured to use either MySQL or MySQLi extensions, the MySQLi extensions are better, safer and more secure to use.

If any support forum members can tel me where to find all MySQL statements, then i can look at the problem.

Brian
0 replies
M
mpkossen
M
  • Senior Member, joined since
  • Contributed 267 posts on the community forums.
  • Started 4 threads in the forums
answered
Senior Member

Look in maincore.php, that's where all the query functions are.

I have PHP5 with both mysql and mysqli, that's probably why I thought everything should work fine. I'm not even sure if somebody has explicitely tested this current version with mysqli extensions...
0 replies
B
brianhall
B
  • Junior Member, joined since
  • Contributed 20 posts on the community forums.
  • Started 8 threads in the forums
  • Started this discussions
answered
Junior Member

Thanks.

I edited the maincore.php, made some progress. I now get a mysql error where i didnt get anything before, apart from a blank page, so am getting one step closer..

I have Attached the edited file, if anyone can see what am missing it would be a great help.

Many Thanks
Brian
0 replies
— 10 months later —
B
brianhall
B
  • Junior Member, joined since
  • Contributed 20 posts on the community forums.
  • Started 8 threads in the forums
  • Started this discussions
answered
Junior Member

Just an update on one of my early post, thought i'd just reply how i got it working, just in case others have the same problem i was getting.

Essentially I am now using the latest version of PHP and I compiled it
with both sets of mysql extension. The original mysql (which seems to be
used by most people even though both MySQL and PHP both recomment you
don't) and the mysqli. MySQLi is the supposed improved version but from
what I have read not many people think you get much of a gain by using it.

I was doing what PHP and MySQL were telling everyone else to do just no
one else seems to be listening.

Cheers
Brian
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 8 posts
  • Votes 0 votes
  • Topic users 3 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet