MySQL Improved

mysqli.php

<?php

$db_user = 'root';
$db_pass = 'toor';
$db_host = 'localhost';
$db_port = 3306;
$db_name = 'my_db';
$db_encoding = 'utf8';

//mysqli_connect(host, username, password, dbname, port, socket);
$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name, $db_port);

// Check connection
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// Change character set to utf8
mysqli_set_charset($conn, $db_encoding);

mysqli_select_db($conn, 'my_data');

$sql = 'SELECT * FROM my_table WHERE 1 LIMIT 1000';

$result = mysqli_query($conn, $sql);

// Fetch all
$my_data = mysqli_fetch_all($result, MYSQLI_ASSOC);

// Free result set
mysqli_free_result($result);

mysqli_close($conn);