MySQLi |
Veteran
|
Are you absolutely sure mysqli is enabled?
Running a base install of PHPEd 5.8, its not enabled for me when I do a Ctrl + F9 with phpinfo(). Also, just to make sure you know, mysql and mysqli are 2 different things. |
||||||||||||
|
mySQLi |
|
As far as I can check it seems to be enabled, unless there is some other hidden settings that I am not aware of, enabling the extension should have been the only thing I needed to do. Also, I could have swear that the first test I made was working (I wrote a function using mySQLi, consuming some data from the DB), and it was working. Then I started working on another function, that did not work. From that point on I started to track back, up to the code sample I gave earlier, and I keep having the same message now. Because I needed to move on, I used mySQL functions instead, but I am very curious to try to understand why it is not working now, and how to fix it.
Do you have any suggestions to help me checking if indeed it is properly installed? Thanks |
||||||||||||
|
Re: MySQLi |
Veteran
|
Your phpinfo() output will tell you without any doubt whether mysqli is indeed enabled. You should see a mysqli heading together with all the mysqli directives. |
||||||||||||||
_________________ |
mySQLi |
|
I found it out at the end of the day. I was testing this behavior on two different machines one Vista Ultimate 64, and one Windows 7 Ultimate 64. I have noticed that if I am running as an Administrator, it does indeed work as intended, and phpinfo ends up displaying the informations for the mySQLi extension. However when running with a restricted account, none of the changes made in php.ini file seems to be taken in consideration [maybe only after a reboot, but I am not sure yet.
I will continue to investigate and post later on if I find a way to work with a restricted account without ill side effect. Right now however a workaround exists under Vista and/or 7, work with and administrative account. |
||||||||||||
|
Veteran
|
Hmm, are you restarting PHPEd's server after you change the php.ini file?
After opening a preview window for a PHP file, you should see a globe icon in your taskbar. Right click it and click "Stop server". Make your php.ini changes, then Start server. |
||||||||||||
|
|
Yes I was generally stoping and restarting the processes including debugger and listener after any changes. Because the php file is installed under C:\Program Files, any modification (notably activating extension) could be done only with an administrative account. However when running as a non administrative account, the modifications were not taken in consideration thus I was still using the default configuration for which the extension is not activated.
However I must admit that the behavior is inconsistent somehow and confusing. Now however I can enable/disable the extension at will on the vista box, I will check later if it is possible to do the same with the windows 7 box later. |
||||||||||||
|
Site Admin
|
That's correct and an expected behaviour. You can not change php.ini under restricted account. You can not change ANY files in %PROGRAMFILES% directory being logged under restricted account. Other sensitive directories are protected too. That's the restriction in MS terms. Please read your OS manuals for further details. |
||||||||||||||
_________________ The PHP IDE team |
MySQLi |
|
||
Content © NuSphere Corp., PHP IDE team
Powered by phpBB © phpBB Group, Design by phpBBStyles.com | Styles Database.
Powered by
Powered by phpBB © phpBB Group, Design by phpBBStyles.com | Styles Database.
Powered by