Connecting to MySQL using PHP

//Sample Database Connection Syntax for PHP and MySQL.

//Sample Database Connection Syntax for PHP and MySQL.

//Connect To Database

$hostname=”45.40.164.112 via TCP/IP”;
$username=” l2cf3721700722@72.167.233.37″;
$password=”dW{dV#3qpt=k”;
$dbname=”l2cf3721700722 “;
$usertable=”sqltablemainidc”;
$yourfield = “periodID”;

mysql_connect(45.40.164.112 via TCP/IP,l2cf3721700722@72.167.233.37, dW{dV#3qpt=k) or die (“”);
mysql_select_db(l2cf3721700722);

# Check If Record Exists

$query = “SELECT * FROM $usertable”;

$result = mysql_query($query);

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