Thread: PHP & mySQL

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    4
    Rep Power
    0
    Hopefully someone can help !
    Have sucessfully set up php on 2 machines
    1) Win98 / Omnihttpd server
    2) Win2K

    Installed on both machines mySql and then the problem ;
    Win98 machine

    Call to unsupported or undefined function mysql_connect

    I am also getting this error when I try to connect to my mySQL db. Both php, mySQL and my web server (Omni] are working separately but php won't talk to mySQL (I've started the mySQL deamon too).

    Win2K machine

    Installed, got PHP running locally, try mySQL and from the command prompt

    C:>cd c:mysqlbin

    C:mysqlbin>mysqld-shareware

    C:mysqlbin>mysql
    ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

    Or from IE php page

    Data from the table

    Warning: MySQL Connection Failed: Can't connect to MySQL server on localhost (10061) in C:Inetpubwwwroothtdocsdatabaseindex.php on line 14
    My Message - Problem connecting to Database

    Any help appreciated cos I'm slowly banging my head against the wall !
  2. #2
  3. No Profile Picture
    PHP Programmer
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    31
    Rep Power
    15
    Are you sure you have uncommented the mysql line in php3.ini?

    ;Windows Extensions
    extension=php3_mysql.dll <--- THIS ONE!
    ;extension=php3_calendar.dll
    ;extension=php3_dbase.dll
    ;extension=php3_gd.dll
    ;extension=php3_dbm.dll
    ;extension=php3_mssql.dll
    ;extension=php3_zlib.dll
    ;extension=php3_filepro.dll

    ....
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    4
    Rep Power
    0
    yep done that !
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Location
    Den Laeghe Landen
    Posts
    107
    Rep Power
    15
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by Soup:
    yep done that ![/quote]
    It's not the PHP connection that is failing; MySQL itself is not up and running yet.
    It's very easy, at the commandprompt within your mysql/bin directory, type:
    > mysqld
    (i believe it's as easy as that, if you still experience problems, i can check at my home-pc, for possible further parameters)

    Suc6!

    ------------------
    --
    <WARNING: signature has NULL-value>

Similar Threads

  1. Check MySQL Version thru PHP
    By wolftrap1 in forum PHP Development
    Replies: 2
    Last Post: February 11th, 2004, 08:51 PM
  2. Replies: 5
    Last Post: February 11th, 2004, 02:18 AM
  3. Replies: 0
    Last Post: January 30th, 2004, 01:22 PM
  4. PHP 5 (MYSQL vs. SQLite)
    By ignition in forum PHP Development
    Replies: 1
    Last Post: January 23rd, 2004, 12:13 PM
  5. PHP Reconfig with mysql...
    By Legendary Fox in forum PHP Development
    Replies: 3
    Last Post: January 22nd, 2004, 11:46 PM

IMN logo majestic logo threadwatch logo seochat tools logo