What is a way for accessing a SQL database server?

What is a way for accessing a SQL database server?

Hi dear,

The Best way is via a PHP script.

For instance:

<? PHP
$myServername = "localhost";
$myUsername = "your_Username";
$myPassword = "your_password";
$myDB = "example";

//Connect to the database
$dbhandle = mssql_connect($myServername, $myUsername, $myPassword)
  Or die ("Couldn't connect to SQL Server on $myServer");

//Select a database to work with

//Assuming you have the following database
$selected = mssql_select_db($myDB, $dbhandle)
  Or die ("Couldn't open database $myDB");

//Declare the SQL statement that will query the database
$query = "SELECT id, name, year,make ";
$query .= "FROM cars ";
$query .= "WHERE name='Toyota'";

//Execute the SQL query and return records
$result = mssql_query($query);

$numRows = mssql_num_rows($result);
Echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";

//Show or display the results
While ($row = mssql_fetch_array ($result))
{
  Echo "<Li>" . $row["id"] . $row["name"] . $row["year"] . "</li>";
}
//Close the connection
mssql_close($dbhandle);
?>

The alternative is using DNS 'Data Source Name'

<? PHP

//Connect to a DSN "myDSN"
$conn = odbc_connect ('myDSN','','');

If ($conn)
{
  //The SQL statement that will query the database
  $query = "select * from cars";
  //Perform the query
  $result=odbc_exec($conn, $query);

  Echo "<table border="1"><tr>";

  //Print field name
  $colName = odbc_num_fields($result);
  For ($j=1; $j<= $colName; $j++)
  { 
    Echo "<th>";
    Echo odbc_field_name ($result, $j );
    Echo "</th>";
  }

  //Fetch the data from the database
  While (odbc_fetch_row ($result))
  {
    Echo "<tr>";
    For ($i=1; $i<=odbc_num_fields ($result); $i++) 
    {
      Echo "<TD>";
      Echo odbc_result ($result, $i);
      Echo "</TD>";
    }
    Echo "</tr>";
  }

  Echo "</td> </tr>";
  Echo "</table >";

  //Close the connection
  odbc_close ($conn);
}
Else echo "No connection";
?>

Hope it is helpful. Let me know your progress.

Thanks.