MySQL Host=mysql3.000webhost.com
MySQL Database = a9230817_test
MySQL User = a9230817_nahid
password = ***********
while I am trying to connect to my Database through DREAMEAVER, I am getting the following message -
" an unidentified error has occured"..........................................DO YOU KNOW WHY??????????????
Please help
Kind regards,
Saif
where I am doing wrong????
Moderator: General Moderators
Re: where I am doing wrong????
can you give the full code
oh and you should censor your sql username and password even the host
or you will get hacked
oh and you should censor your sql username and password even the host
or you will get hacked
Re: where I am doing wrong????
you know when you try to connect through Dreamweaver, you dont really need any code first. you have to just connect, ain;t I right????????
however, I have also tried with the following code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?
// hostname or ip of server
$servername='mysql3.000webhost.com';
// username and password to log onto db server
$dbusername='a9230817_nahid';
$dbpassword='********';
// name of database
$dbname='a9230817_test';
////////////// Do not edit below/////////
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
?>
</body>
</html>
however, I have also tried with the following code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?
// hostname or ip of server
$servername='mysql3.000webhost.com';
// username and password to log onto db server
$dbusername='a9230817_nahid';
$dbpassword='********';
// name of database
$dbname='a9230817_test';
////////////// Do not edit below/////////
connecttodb($servername,$dbname,$dbusername,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
global $link;
$link=mysql_connect ("$servername","$dbuser","$dbpassword");
if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
}
?>
</body>
</html>
wpsd2006 wrote:can you give the full code
oh and you should censor your sql username and password even the host
or you will get hacked
Re: where I am doing wrong????
Make sure all your info is right. (check with your host)
God bless.
God bless.
Re: where I am doing wrong????
I have already done it..
I have also checked with 4 other servers and still getting the same error msg....
any idea??????????
I have also checked with 4 other servers and still getting the same error msg....
any idea??????????
Re: where I am doing wrong????
hey guys...I have managed to crack the deal...I had to use Remote view instead of Local view to see it connected....thanks