Advertisement
Guest User

Untitled

a guest
May 12th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.49 KB | None | 0 0
  1. <?php
  2. $myServer = "HOME-528EABE208\SQLEXPRESS";
  3. $myUser = "";
  4. $myPass = "";
  5. $myDB = "db_mrosario";
  6.  
  7. //connection to the database
  8. $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");
  9.  
  10. //select a database to work with
  11. $selected = mssql_select_db($myDB, $dbhandle) or die("Couldn't open database $myDB");
  12.  
  13. $q=mssql_query("select * from tbl_Rosario");
  14. while($qq=mssql_fetch_assoc($q))
  15. {
  16.     extract($q);
  17.     echo "{$flavorname} <br />";
  18. }
  19. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement