mysqli and mysql not working
Posted by: toiletcleaner (---.neo.res.rr.com)
Date: July 28, 2010 05:00PM

I have been trying to insert data into my database using php and when I go to submit the information I get this fatal error message: Call to undefined function mysql_connect(). And before this I was trying to use the mysqli extension and It was throwing similar fatal errors. I checked my php.ini file and mysql and mysqli extension show that they are available. I have tried all that I know so any help is greatly appreciated.

Thank You

Options: ReplyQuote
Re: mysqli and mysql not working
Posted by: yfastud (Moderator)
Date: July 28, 2010 05:10PM

did you setup db account?

To setup DB account, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: mysqli and mysql not working
Posted by: toiletcleaner (---.neo.res.rr.com)
Date: July 28, 2010 09:00PM

yfastud, I am using the generic localhost with root no password and the database i'm using is uploaded. I'm using root because I just want to test out entering information into the db table. I have set up users before but I didn't set up root, it was already done by installing wamp. As I stated before, I have checked all the paths and directories and everything seems to be fine on that end. The mysql and mysqli.dll files are in there proper place, but for some reason when I try to use either of them they just don't work.

Options: ReplyQuote
Re: mysqli and mysql not working
Posted by: toumimi (---.44.75-86.rev.gaoland.net)
Date: July 28, 2010 10:18PM

You should check your logs (apache, php and mysql from wamp menu).

Then, you should use phpinfo to see if your modules are loading or not, and their configuration.

Florian

WampServer Patch (Screenshots)
Topic EN : www.wampserver.com
Topic FR : www.wampserver.com

Options: ReplyQuote
Re: mysqli and mysql not working
Posted by: toiletcleaner (---.neo.res.rr.com)
Date: July 31, 2010 02:56AM

I am going to do that, but what exactly am I looking for inside of these logs? Is there any reason that there is no php error log? Could that be the issue?

Options: ReplyQuote
Re: mysqli and mysql not working
Posted by: ianphillips (---.as43234.net)
Date: August 25, 2010 12:29AM

Did you get it working as i am getting a similar Fatal error

Options: ReplyQuote
Re: mysqli and mysql not working
Posted by: stevenmartin99 (109.79.70.---)
Date: August 25, 2010 12:39AM

There is no php log because >> [www.wampserver.com]

the PHP log file has been desactivated since it creates a bug with the phpinfo() function.



Are you sure the WampServer Icon is White? If its yellow then Wamps Mysql is not running.. Maybe another Mysql is installed.. happens all the time.

If it is White... Connect in the console.. left click wamp>mysql>mysql console

Press Enter and see if that works

commands such as

show databases;
use (DBNAME);
view tables;
select * from (TABLENAME);

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 08/25/2010 12:41AM by stevenmartin99.

Options: ReplyQuote


Sorry, only registered users may post in this forum.