WebHostingPeople

WebHostingPeople
Establishing a Connection to a MySQL Database with PHP on Linux Hosting

There’s following a pattern code for connecting to a MySQL database utilizing PHP. //Pattern Database Connection Syntax for PHP and MySQL. //Join To Database$hostname=”mysql.secureserver.web”;$username=”your_dbusername”;$password=”your_dbpassword”;$dbname=”your_dbusername”;$usertable=”your_tablename”;$yourfield = “your_field”;$connection = mysql_connect($hostname, $username, $password);mysql_select_db($dbname, $connection); # Examine If Report Exists $question = “SELECT * FROM $usertable”; $outcome = mysql_query($question); if($outcome){whereas($row = mysql_fetch_array($outcome)){$title = $row[“$yourfield”];echo “Identify: “.$title.”“;}}?>