PHP Tutorial

Download Java SE 8.

PHP Program Examples - PHP code with MySQL database connection

PHP code with MySQL database connection

Establishes the connection with mysql database, executes database sql queries and parses the results in PHP program.

$servername = "SERVER";
$username = "USERNAME";
$password = "PASSWORD";
$db = "DATABASE_NAME";

$conn = new mysqli($servername, $username, $password, $db);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
//echo "Connected successfully";
$conn->query ("set character_set_results='utf8'");   

$result= $conn->query("SELECT * FROM  table _name");

while($row = $result->fetch_assoc())
{
 echoo $row['column_name'];
}