View Full Version : PHP upload error

12-26-2006, 12:55 AM
Help! I installed MySql and PHP on my computer. When I try to connect to MySql through Dreamweaver, I get the following error:
Your PHP Server does not have the MySql Module loaded or you can't use the MySql_(p)connect functions. I did everything it said to do with the .ini file and I think my libmysql.dll file is in the right place...but not sure. PHP works with Dreamweaver when previewing in the browser, but I cannot get the MySQL connection working.

In another attempt, I converted the MySQL tables to .csv through Access and uploaded them to a live website with a database (I created the database tables first) that I set up to test. It has PHPMyAdmin and I can upload one table correctly - the one with only one field. All of the other tables error out with "Invalid Field Count in CSV Line 1"

Can anyone help with either...or both?

A newbie PHP/MySQL chick

12-26-2006, 03:05 AM
first off , create a page with just this in it..
<?php phpinfo();?>
view the page and scroll down to see if MySQL module is loaded and what version.

If you see no reference to MySQL, check that it is running ... ctl-alt-del should show MySQL in the process list, if not what version did you install ?

Your second problem is best solved by installing phpMyAdmin on your local server (since it will export in a valid format) .. but that will not work until you get MySQL working.

12-26-2006, 01:41 PM
MySQL is running and I can get into it to modify tables. However, I do get this message at the bottome of the php-info page you had me create:

PHP Warning: PHP Startup: Unable to load dynamic library './php_mbstring.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library './php_msql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library './php_mysql.dll' - The specified module could not be found. in Unknown on line 0

12-26-2006, 01:55 PM
I am not very sure as to why this could be a problem. That is to say:
1- php_mbstring.dll and php_mysql.dll files are damaged, or
2- you do not have these modules installed.

In either case, here is a good tutorial on how to install php extensions and modules on windows.

Good luck.

12-26-2006, 02:32 PM
Thanks! I went back through the .ini file and set the path for the extensions folder. That is what was missing. When I now run the php-info page I no longer am missing the module.

However, now when I try to connect I get the error message: MySQL Error #1045 Access denied for user root@localhost (using password: yes)

12-26-2006, 02:33 PM
Thanks for the tutorial - I solved the extensions problem.
Does anyone have an easy solution to install PHPMyAdmin? Seems pretty technical to me and I am a beginner!

12-26-2006, 02:45 PM
It is very easy to install phpMyAdmin. Here is a simple procedure to do so.
1-download the latest release from http://www.phpmyadmin.net/home_page/index.php
2- uncompress the package in your root directory (the one that you use for your website) and call it phpmyadmin
3- locate the file config.inc.php within phpmyadmin. If you cannot find it, go into libraries and copy config.default.php and paste it into phpmyadmin. You should now rename config.default.php to config.inc.php
4- locate this line ( $cfg['Servers'][$i]['password'] ) should be around line 73
5- add a password that you used for mysql if you have created any. Otherwise leave it blank.

That should do it. Now go to http://localhost/phpmyadmin in order to test your installation.

good luck.

12-26-2006, 02:49 PM
By the way. You can install WAMP (http://www.wampserver.com/en/)which comes with PHP5, MYSQL5, PHPMyAdmin, SQLite, SQLiteManager etc.

The good thing about WAMP (http://www.wampserver.com/en/)is that you can also install PHP4 and you can easily switch between the two any time you wish.

Good luck.

12-26-2006, 07:31 PM
Personally I prefer XAMPP (http://www.apachefriends.org/en/xampp.html). Its similar to WAMP but I think it has more features.

12-28-2006, 02:33 AM
Just restarted MySQL and now it is working great with PHP and Dreamweaver!
Thanks for all the help! I will install PHPMyAdmin soon too. Has anyone ever heard of Xoops? Any comments about it?