External DB Ms SQL queries, Custom Pages, and Pagination

  • Hello:

    I am looking for assistance / information with the following criteria.

    I would like to create a custom page that pulls information from a MS SQL DB based on a submitted post form with as much of an integrated look as possible with WordPress with such features as pagination.

    I have been searching for this but as much as I google it I have been unable to consistently locate a well written article on the subject.

    Any suggestions are welcome.

    Thank you,
    Richard

Viewing 2 replies - 1 through 2 (of 2 total)
  • Dion

    (@diondesigns)

    You’re going to need code that creates an interface to SQL Server, and then queries the MSSQL database for the data you require for your page. Your PHP installation will need the SQLSRV extension, which is not installed by default. And obviously your (Windows) server must have a version of SQL Server installed that supports your database.

    If you are looking for a pre-packaged solution, I suspect it does not exist…or if it does, it will be very expensive (as is pretty much everything associated with SQL Server).

    Thread Starter Richard Krone

    (@rkrone)

    Hello DionDesigns:

    Thanks for responding.

    I do realize that step one is to establish a conn with the MS SQL DB via PHP. I will be doing this in a WP custom dummy page that I use just for this sort of thing.

    Once I have a successful connection I would like to display the results of the query in a nicely formatted way. One thing that is nice about the ASP.NET page that I am converting to PHP is that its output to the screen has pagination. The reason this is important is that some queries can return hundreds of large results and that makes for too long of a page.

    Thanks,
    Richard

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘External DB Ms SQL queries, Custom Pages, and Pagination’ is closed to new replies.