Accessing a Microsoft SQL Server database from PHP running under Linux
25966Accessing a Microsoft SQL Server database from PHP running under Linuxhttp://www.phpbuilder.com/columns/alberto20000919.php3In this article, I will explain how it is possible to connect and query an MS SQL server (running under a Windows operating system) from php installed on a unix box. The same problem, in the case of php installed under Windows is not covered here because it is well explained in php FAQ; sadly I cannot say the same thing for the unix case. In fact, there is a multitude of incorrect or outdated sources of information which will cause new people trying to solve this problem to drop it after some bad tries. This article can also be of help to people who don't want to use php as a client.PHP > Tips and Tutorials > Database-RelatedOct 15, 2006
In this article, I will explain how it is possible to connect and query an MS SQL server (running under a Windows operating system) from php installed on a unix box. The same problem, in the case of php installed under Windows is not covered here because it is well explained in php FAQ; sadly I cannot say the same thing for the unix case. In fact, there is a multitude of incorrect or outdated sources of information which will cause new people trying to solve this problem to drop it after some bad tries. This article can also be of help to people who don't want to use php as a client.
While the word "integrity" connotes "wholeness", it's important to understand what it means specifically in the case of relational database design. Failure to ensure data integrity can result in the database returning incorrect results, or in data becoming unretrievable. This is true of all relational databases, not just MySQL. Fortunately, the principles of data integrity are not difficult to understand. How difficult they are to implement in MySQL and PHP will depend in large degree on how many tables and relationships the database has. This article will start with an overview of relational concepts, and then illustrate each of the concepts with simple examples.
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.