Connection to mysql database (adapt file dreamweaver)

[jabahoeoe]

hey,

I'm totaly noob in working with databases.
at this moment I'm testing my site and database, on my local wamp-server.
everything works fine.
Dreamweaver created a file

connections/ecards.php

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_ecards = "localhost";
$database_ecards = "ecards";
$username_ecards = "xxxx";
$password_ecards = "xxxx";
$ecards = mysql_pconnect($hostname_ecards, $username_ecards, $password_ecards) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

Now I uploaded my site to http://timds.x10hosting.com/
I edited my connectionfile:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_ecards = "[COLOR=red]localhost[/COLOR]";
$database_ecards = "[COLOR=red]timds_ecards[/COLOR]";
$username_ecards = "[COLOR=red]timds_xxxx[/COLOR]";
$password_ecards = "[COLOR=red]xxxx[/COLOR]";
$ecards = mysql_[COLOR=red]c[/COLOR]onnect($hostname_ecards, $username_ecards, $password_ecards) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

while surfing site (when it comes to connect the database...) I get:
No database selected



I hope someone can halp me

tim d.s.

 

[Alejandro]

Yes, you need to select a db after connecting to the mysql server. In order to do so add the following line after the mysql_connect() function:

mysql_select_db('DATABASE');

 

[jabahoeoe]

Thanks for your fast reply Alejandro,

so it must be ???

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_ecards = "localhost";
$database_ecards = "timds_ecards";
$username_ecards = "timds_xxxx";
$password_ecards = "xxxx";
$ecards = mysql_connect($hostname_ecards, $username_ecards, $password_ecards) or trigger_error(mysql_error(),E_USER_ERROR); 
mysql_select_db('timds_ecards');
?>

does not work

 

[Corey]

Did you create the database, create a user, then assign the user to the database with permissions?