Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jun 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SQL Server 2005 + PHP

    Hi guys, this is actually my first post, i know how it looks just coming here just to ask this, but hey, ain't that how most of you guys came here in the first place ?

    The problem is: i'm creating a website, but it need to read the stock from this SQL Server 2005 Express Database.. and changing it to a Mysql Database is out of the question ..
    but i've never dealt with SQL Server Dbases..
    can you guys point me at the right direction ? i've been looking for this the past 2 days already ..

    Thank You !
    Ennyn Messor.

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,994
    Thanks
    4
    Thanked 2,662 Times in 2,631 Posts
    If your creating, you won't have any problems. Only if you are porting you may see problems since both languages have proprietary features (LIMIT versus TOP for examples). If I were you, I'd avoid doing direct SQL calls that use proprietary features, and choose abstraction to slide drivers in below if you need that functionality.

    Start here:
    http://ca3.php.net/manual/en/book.mssql.php
    And more importantly here (use the PDO_ODBC, I don't think the MSQL is supported any more):
    http://ca3.php.net/manual/en/book.pdo.php

    PDO is really the way to go. If you avoid the whole proprietary SQL, than you can swap out drivers for different databases as you see fit, without having to touch any other code.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •