Facebook
From Wet Cheetah, 5 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 184
  1.  
  2.  
  3. <?php
  4. $mssqlhost = '89.171.97.227';
  5. $mssqldbname = 'B2B';
  6. $mssqluser = 'B2B';
  7. $mssqlpass = 'B@bLog1n';
  8. try {
  9. $db = new PDO("odbc:DRIVER=FreeTDS;SERVER=$mssqlhost;UID=$mssqluser;PWD=$mssqlpass;DATABASE=$mssqldbname;Port=50157;");
  10. $query = $db->prepare("SELECT TOP (1000) [IdTW]
  11.       ,[KodTW]
  12.       ,[Baza]
  13.       ,[Stan]
  14.   FROM [B2B].[dbo].[SM]");
  15. $query->execute();
  16. while($row = $query->fetch(PDO::FETCH_OBJ))
  17. echo "
  18. " . $row->KodTW . "";
  19. } catch (PDOException $exception) {
  20. echo $exception->getMessage();
  21. exit;
  22. }
  23. ?>