Need help Connecting to MYSQL

majolee

Please visit this and answer why this happens?

Help needed urgently..

bastien

🙂

nemonoman

Looks like you're attempting a remote connect (your PHP code is on one server, the DB on a different server). Many MySQL DBAs set up to refuse to remote connections.

majolee

the code is::
$host = "www.machostingsearch.com";
$username = "uname";
$password = "pwd";
mysql_connect($host,$username,$password) or die ("Problem connecting to DataBase");
echo("connected");
$result = mysql_db_query("search", "select * from search_item_master") or die("Recordset Query Failed");
echo("open record");
while($r=mysql_fetch_array($result))
{
echo "$r[1] $r[0] <BR>";
}
echo("complete");

Here is the code ..

Also the URL now has been changed to www.machostingsearch.com/majolee/test.php

It is still not working...

nemonoman

If the db is on the same server as your PHP use $host= "localhost" instead of www.machostingsearch.com.

If it's on a different server, I'm not sure you'll be able to connect without a long discussion with your hosts' technical support folks about getting them to accept remote connections.

majolee

I got things working..

The problem was host name..

Which in this case should be used as "localhost"

Thanks for your posts..

majolee

Hey nemonoman I never refreshed that you have replied..but I got the same thing clicked..when I tried on different pointer..

Great to have buddies like you though..

Thanks for posts..

I need cost estimation help on one project...Can you say what it would cost in $ or GBP to develop a site like http://www.bingofantasy.com/,http://www.bingotropic.com/,http://www.kiwibingo.com/ with support of www.bingoworks.com