Cable Forum

Cable Forum (https://www.cableforum.uk/board/index.php)
-   General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)
-   -   any PHP,Phpmyadmin and mysql experts here? (https://www.cableforum.uk/board/showthread.php?t=33645609)

Graham M 10-02-2009 22:33

Re: any PHP,Phpmyadmin and mysql experts here?
 
Try taking the username and password out of the quote marks

Kymmy 10-02-2009 22:44

Re: any PHP,Phpmyadmin and mysql experts here?
 
Try resetting your mysql root password then try again

http://dev.mysql.com/doc/refman/5.0/...rmissions.html

funkyCable 10-02-2009 22:55

Re: any PHP,Phpmyadmin and mysql experts here?
 
Thanks Graham, I removed the username and password. It now comes up with the username and password whcih I put in and it has logged me in.


Thanks for your all help everybody.

ADMIN : Maybe we should have a coding space on the forum?

---------- Post added at 21:55 ---------- Previous post was at 21:49 ----------

Just one last thing can you store pictures in an mysql. I know you can in ORACLE you can store the pictures as BLOBs. I have loads of images on my c: drive I would like to store in mysql DB.
I'm hoping I can get PHP to insert them into a table for me.

Paul 10-02-2009 22:59

Re: any PHP,Phpmyadmin and mysql experts here?
 
Yes you can.

Perhaps you should read the mysql documentation. :)

---------- Post added at 21:59 ---------- Previous post was at 21:59 ----------

FYI - vbulletin runs on PHP/MYSQL

Graham M 10-02-2009 23:26

Re: any PHP,Phpmyadmin and mysql experts here?
 
For pictures to be stored into a database they generally need to be converted from binary data to some sort of text format, generally they are encoded (like in an email) which tends to increase the size of the file somewhat! You'd be much better leaving the pictures where they are.

Paul 11-02-2009 00:54

Re: any PHP,Phpmyadmin and mysql experts here?
 
No conversion is needed in mysql, they are stored as binary data in blob fields.


All times are GMT +1. The time now is 13:29.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum