Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $myServer = "localhost";
- $myUser = "sa";
- $myPass = "password1";
- $myDB = "testlink";
- //connection to the database
- $dbhandle = mssql_connect($myServer, $myUser, $myPass)
- or die("Couldn't connect to SQL Server on $myServer");
- //select a database to work with
- $selected = mssql_select_db($myDB, $dbhandle)
- or die("Couldn't open database $myDB");
- //declare the SQL statement that will query the database
- $query = "SELECT * ";
- $query .= "FROM users";
- //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>";
- //display the results
- while($row = mssql_fetch_array($result))
- { echo "<li>" . $row["FIRST_NAME"] . "</li>"; }
- //close the connection
- mssql_close($dbhandle);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement