|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
This will do the job :
$host="host.xxx.yyy.nl"; $user="user"; $passwd="xxxxx"; mysql_connect ($host,$user,$passwd); mysql_select_db (database); |
|
#3
|
|||
|
|||
|
ruler i think that's not what he needs
Class.forName("org.gjt.mm.mysql.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://MyDomain.com/MyDomain_com?user=MyUsername&password=MyPassword" ); but u better use Connection con = DriverManager.getConnection("jdbc:mysql://MyDomain.com/MyDomain_com","MyUsername","MyPassword"); the first one would be ok with mysql, but not with all of RDBMS, for example the first one doesn't work with PostreSql thant's all u have the connection <Slash> |
![]() |
| Viewing: Dev Shed Forums > Programming Languages > Java Help > JDBC and MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|