db4free.net MySQL connect error....

[surf5502]

i just started using MySQL and this is my frist program... i ve read numerous things on how to connect and i think i followed them all... and this is what i ended up with:

[color=orange]//connect to MySQL Database and add information into it[/color]
[color=blue]$username = "bchs";
$password = "mattward";
$database = "bchssurvey";
$hostaddr = "db4free.net:3307";

mysql_connect($hostaddr,$username,$password);
@mysql_select_db($database) or die("Error: Database not available. Please try again later.");

$query = "INSERT INTO survey VALUES('','$type','$isHomePage','$vstAthlet','$vstLinks','$vstEdline','$vstFacul','$vstLaptop','$vstPres','$vstPrinc','$vstCal','$eForms','$sMap','$bRSS','$facWS','$facClub','$facClubWS','$facCon','$facPic','$facEdline1','$facEdline2','$facEdline3','$facEdline4','$facEdline5','$aEdline','$chEdline','$announce','$eFac','$eFindFac','$stuHandouts','$stuWebteam','$stuWebteamN','$stuWebteamH','$otherWB','$conceptHP','$conceptCP','$conceptLike','$conceptNoLike','$comments')";

mysql_query($query);
mysql_close();
[/color]

any ideas of what i did wrong? i am actually programming an online survey for my school website (i am the new webmaster)... any questions about what i am trying to do please ask

i really need this thing to work asap

thanks everyone

[Hypnos]

You need to post the error.

[surf5502]

well besides the fact that the loading.... thing goes on for like 10 minutes... it then goes:


[color=blue]Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'db4free.net' (36) in /home/bchs/bchs-web/data/survey/finalize.php on line 10
Error: Database not available. Please try again later.[/color]


and thats my error for ya

[surf5502]

might this have anything to do with it?

[color=blue]Used PHP extensions: mysqli[/color]

it was on my PHPMyAdmin page...

[mainewoods]

you did know that mysql is usually installed on port '3306' and '3307' is what you meant to code?
[code]$hostaddr = "db4free.net:3307";[/code]

[surf5502]

this server runs it on both actually... i dont know i tried both and neither worked

will the mysqli make a difference? or is it like the same thing?

[surf5502]

ok so i got bored and re-coded it to MySQLi:

[color=blue]//connect to MySQL Database and add information into it
$username = "bchs";
$password = "mattward";
$database = "bchssurvey";
$hostaddr = "db4free.net:3306";

$connection = mysqli_connect($hostaddr,$username,$password,$database) or die("Error: Database not available. Please try again later.");
$query = "INSERT INTO survey VALUES('','$type','$isHomePage','$vstAthlet','$vstLinks','$vstEdline','$vstFacul','$vstLaptop','$vstPres','$vstPrinc','$vstCal','$eForms','$sMap','$bRSS','$facWS','$facClub','$facClubWS','$facCon','$facPic','$facEdline1','$facEdline2','$facEdline3','$facEdline4','$facEdline5','$aEdline','$chEdline','$announce','$eFac','$eFindFac','$stuHandouts','$stuWebteam','$stuWebteamN','$stuWebteamH','$otherWB','$conceptHP','$conceptCP','$conceptLike','$conceptNoLike','$comments')";
$result = mysqli_query($connection,$query);
mysqli_free_result($result);
mysqli_close($connection);[/color]

ok still doesnt work but different error now!
[color=red]
Fatal error: Call to undefined function mysqli_connect() in /home/bchs/bchs-web/data/survey/finalize.php on line 10[/color]

[mainewoods]

just try the mysql_connect with 3306

[surf5502]

going backwards...
[color=red]
Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/bchs/bchs-web/data/survey/finalize.php on line 10
Error: Database not available. Please try again later.[/color]

[surf5502]

oh ya i fixed it....

ignore this thread