MYSQL/SQLite

[scitech]

I cannot connect to mySQL ( I have tryed and tryed what is the correct syntax?) ,phpinfo() gives support for SQLite but not MySQL, is this what the problem is?

 

[sleipnir214]

Yes.

The two products are not related.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[litton1]

go to the directory (don’t know if you are on win or Linux eg win go to the mysql/bin) on the command line then if there is no pass to get in type

mysql -u myusername
use test

if there is a password to get in type

mysql -u myusername -p
# u will enter password when prompted
use test

Binary Intelligence, true or false?

 

[litton1]

sorry didn’t know that!!

Binary Intelligence, true or false?

 

[scitech]

Thanks
sleipnir214
How do I get PHP support for MYSQL?, downloaded version 5.4 what else to do
Mysql works fine from CMD

 

[sleipnir214]

On what platform are you intending to run PHP?

And what did you download from where? Neither MySQL nor PHP is in version 5.4


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[scitech]

Sorry PHP from phpinfo()5.0.4, installed with 6.0.4.exe(php site
MySql 4.1.11 win 32,(mysql site) all to run on my OS of WinXP sp2. I'm new to XP and all these programs, but I've read through the stuff I can find and I should be able to connect, with a version of the mysql_connect() function.
I keep on getting unknown function mysql_connect() errormsg,
I have tryed all the different syntax I have found on the web, always the same errormsg, maybe I missed the correct one!.
but I don't have MYsql in the phpinfo() list!!! only SQLite.
dazed&confused again!

 

[sleipnir214]

If PHP tells you that the function is not available, then you can take its word for it. No amount of syntax tweaking is going to change that.

To the best of my knowledge, you must use the mysqli_*() Improved MySQL family of functions with 4.1.11. Are those functions available?

MySQL connectivity on Win32 is available through the use of extension libraries. Have you installed those in your php.ini?


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[scitech]

Thanks
I have enabled the php_mysql.dll in the php.ini file,I have also read that I should do the same for libmysql.dll, but this is not in the list in the php.ini file, nor is mysqli.dll, can I just add them to the list?
I have also changed the paths so now when I load phpinfo() ,it cannot find the files, but it is looking. The Path I have entered is C:\PHP, the only dll file in here is php5ts.dll, so where are the dll files?,I've been to php.net and the downloads section and the link just takes me to manual pages and nothing to download am I looking in the right place?
Light is on the Horizon

 

[scitech]

I have found the dll files, went back and downloaded the win32 binary zip file and there they were!!!!
Now if I can unscramble my brain I'll see if I get get it to work now!!!!!!!
Thank you