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

    Join Date
    Aug 2000
    Location
    City, State, US
    Posts
    6
    Rep Power
    0
    I have hosted my website with A company that uses MySQL.
    I tried to connect to my database using the usual php script
    ....
    <?php
    mysql_connect (localhost, MyUserName, MyPassword);

    mysql_select_db (MyDatabse);
    mysql_query ("INSERT INTO addressbook (fname, lname)VALUES 'fname', 'lastname')
    ");
    print ("Thanks for submitting your name.");
    ?>

    Obviously I substituted the values MyUser name .... with my settings.


    I emailed my webshsting company and I was told that they use JDBC Connection !!! And I should insert the following string:


    "jdbc:mysql://MyDomain.com/MyDomain_com?user=MyUsername&password=MyPassword"

    Can Any one tell me how could I connect to MySQL using this connection string?
    Where should I insert it?
    Can any one rewrite the php script above so that it connects using JDBC...

    Any help would be appreciated very much.
    Thank you all
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 1999
    Posts
    119
    Rep Power
    16
    wrong group, but I think you'd replace the localhost part with that line...

Similar Threads

  1. My SQL/PHP problem
    By Sewer Rat in forum PHP Development
    Replies: 8
    Last Post: August 6th, 2003, 09:53 AM
  2. Password protecting an SQL/PHP script
    By jstone35 in forum PHP Development
    Replies: 3
    Last Post: March 31st, 2003, 01:04 PM

IMN logo majestic logo threadwatch logo seochat tools logo