PHP7.0 connecting MySQL database code

1.
<?PHP$mysql _server_name= ' localhost ';//change to your MySQL database server$mysql _username= "Root";//change to your MySQL database user name$mysql _password= "QMTG";//change to your MySQL database password$mysql _database= "Testmydatabase";//change to your MySQL database name$conn=NewMysqli ($mysql _server_name,$mysql _username,$mysql _password);//connecting to a databaseif($conn==false){    Echo"Data connection Failed!" ";}Else{    Echo"The data connection was successful!" ";} $conn->query ("Set names ' UTF8 '");//the database output encoding should be consistent with your database encoding. Nanchang Website Construction company hundred Constant network PHP engineer proposed to use UTF-8 International standard Code.$conn-SELECT_DB ($mysql _database);//Open Database$sql= "SELECT * from Testtale";//SQL statements$result=$conn->query ($sql);//Query Successful$data=Array();Echo"Start";  while($tmp=$result-Fetch_assoc ()) {        $data[]=$tmp; }Var_dump($data);Echo"End";?>

2.

<?PHP$mysql _server_name= ' localhost ';//change to your MySQL database server$mysql _username= "Root";//change to your MySQL database user name$mysql _password= "QMTG";//change to your MySQL database password$mysql _database= "Testmydatabase";//change to your MySQL database name$conn=NewMysqli ($mysql _server_name,$mysql _username,$mysql _password);//connecting to a databaseif($conn==false){    Echo"Data connection Failed!" ";}Else{    Echo"The data connection was successful!" ";} $conn->query ("Set names ' UTF8 '");//the database output encoding should be consistent with your database encoding. Nanchang Website Construction company hundred Constant network PHP engineer proposed to use UTF-8 International standard Code.$conn-SELECT_DB ($mysql _database);//Open Database$sql= "SELECT * from Testtale";//SQL statements$result=$conn->query ($sql);//Query Successful$data=Array();Echo"Start";  while($tmp=$result-Fetch_assoc ()) {        $data[]=$tmp; Echo $tmp[' Name '].Php_eol; }//Var_dump ($data);Echo"End";?>

3.

PHP7.0 connecting MySQL database code