how to connect database in php to server SQL code example

Example 1: php connect ms sql server

<?php
$serverName = "serverName\\sqlexpress"; //serverName\instanceName

// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"dbName");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

Example 2: mysql connection phpmyadmin

<?php
  // This is for checking if your file is linked in your page or game or whatever
  echo "IT WORKS"; // My File is successfuly Linked

  //Remember to create a Database in phpmyadmin or any Online Database
  // the values passed in this parameters are:  the host, the user, user password and the database Name
  $con = mysqli_connect('localhost', 'root', 'root', 'unityaccess');

  // check that connection happen
  if(mysqli_connect_errno()) {
    echo "1: Connection Failed"; //error code #1 = connection Failed
    exit();
  }
?>

Tags:

Sql Example