Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 10 of 10
  1. #1
    New Coder
    Join Date
    Dec 2006
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    PHP upload error

    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?

    Thanks,
    A newbie PHP/MySQL chick

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,095
    Thanks
    11
    Thanked 101 Times in 99 Posts
    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.
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    New Coder
    Join Date
    Dec 2006
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

  • #4
    ess
    ess is offline
    Regular Coder
    Join Date
    Oct 2006
    Location
    United Kingdom
    Posts
    866
    Thanks
    7
    Thanked 30 Times in 29 Posts
    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.
    http://devzone.zend.com/manual/view/...xtensions.html

    Good luck.
    Ess

  • #5
    New Coder
    Join Date
    Dec 2006
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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)

  • #6
    New Coder
    Join Date
    Dec 2006
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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!
    Last edited by skullcats; 12-26-2006 at 01:35 PM.

  • #7
    ess
    ess is offline
    Regular Coder
    Join Date
    Oct 2006
    Location
    United Kingdom
    Posts
    866
    Thanks
    7
    Thanked 30 Times in 29 Posts
    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.
    Ess

  • #8
    ess
    ess is offline
    Regular Coder
    Join Date
    Oct 2006
    Location
    United Kingdom
    Posts
    866
    Thanks
    7
    Thanked 30 Times in 29 Posts
    By the way. You can install WAMP which comes with PHP5, MYSQL5, PHPMyAdmin, SQLite, SQLiteManager etc.

    The good thing about WAMP is that you can also install PHP4 and you can easily switch between the two any time you wish.

    Good luck.
    Ess

  • #9
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    Personally I prefer XAMPP. Its similar to WAMP but I think it has more features.
    ||||If you are getting paid to do a job, don't ask for help on it!||||

  • #10
    New Coder
    Join Date
    Dec 2006
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •