Database Connectivity

[stringfield]

I recently purchased server space with godaddy.com and they do not allow you to connect to mysql databases remotley, which means that I have to use php to connect to the database instead of dreamweaver. However, they offer no support or real inscructions on how to connect to their database. Can anyone tell me how to use php to connets to a remote mysql database that resides on the companies server.

[notaloser]

im pretty sure godaddy provides a control pannel and phpmyadmin, which will allow you to connect to your databases.

[stringfield]

I set everything up in the control panel, but I am just used to filling in the database username and password through dreamweaver. Even when I change the php file in the connections folder that dreamweaver creates, it is not working. GoDaddy does not allow you to use dreamweaver to connect to its databases. The only support they have for databases is this one comment. I dont know what this script does.

This example describes using PHP to connect to a MySQL Database on a Linux hosting account.
<?php
//Sample Database Connection Syntax for PHP and MySQL.

//Connect To Database
$hostname="mysql.secureserver.net";
$username="your_dbusername";
$password="your_dbpassword";
$dbname="your_dbusername";
$usertable="your_tablename";
$yourfield = "your_field";
mysql_connect($hostname,$username, $password);
mysql_select_db($dbname);

Check If Record Exists

$query = "SELECT * FROM $usertable";

$result = mysql_query($query);

if($result)
{
while($row = mysql_fetch_array($result))
{
$name = $row["$yourfield"];
echo "Name: ".$name."
";
}
}
?>

[Houdini]

You need to have the information that goes into this script with values that you should have been given. Your information will go into the " and "marks.

$hostname="mysql.secureserver.net";//usually localhost but ask godaddy
$username="your_dbusername";//the username you login to the control panel with
$password="your_dbpassword";//the password you use for godaddy
$dbname="your_dbusername";//the database name godaddy assigned to you
$usertable="your_tablename";//these are created by your
$yourfield = "your_field";//this is created by you