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']; }