SQL Server 2008 and PHP Web

makeshiftklipInternet και Εφαρμογές Web

31 Οκτ 2013 (πριν από 3 χρόνια και 8 μήνες)

87 εμφανίσεις

SQL Server 2008 and PHP Web
Application Infrastructure

Keith Combs

Microsoft US IT Pro Evangelist

keith.combs@microsoft.com

http://blog.technet.com/keithcombs

Agenda


8:30
-

Windows Server 2008 Active Directory (AD)
Interop with Linux and OS X


9:45
-

Break


10:00
-

Running Open Source Software (OSS) on

Windows Server 2008


11:00
-

Break


11:15
-

Installing and Using PHP with

SQL Server 2008


12:15


Local Event Drawing

Why do this?


IIS is very easy to manage and monitor


Management and monitoring software integration with
Systems Center Operations Manager (SCOM)


SQL Server is easy, low cost and has great functionality


Extensive Reporting And Data Analysis


Easily Scale from Desktop to Datacenter


Integrity, Reliability, and Security


A powerful web platform with flexibility, stability, and
support


Active Directory (AD) integration and authentication



Pre
-
Installation

Windows Server 2008

Web
Edition

x32 or x64

IIS

PHP

SQL Server 2008

2008 Server

SQL Auth

2005 Client

Text Search

Sample Database

Download

Install

Set Security

Let’s
Take

A

Look

Configure Database Security

SQL Server 2005 Driver for PHP


Windows Server 2003 Service Pack 1


Windows XP Service Pack 2


Windows Vista


Windows Server 2008

OS


www.php.net (stable release)

PHP


php_sqlsrv_ts.dll


“Thread Safe”


Reliable


php_sqlsrv.dll


Sequential Processing

SQL Driver


Microsoft SQL Server
2005

Native Client


2008 Client Supports Driver (v1.1)
Available By EOY 2009

SQL Client

Let’s
Take

A

Look

Install and Configure PHP for
SQL Server Driver

IIS FastCGI
-

Under the hood

FastCGI process pool for
PHP4

php.exe

Request
queue

FastCGI process pool for
PHP5

php
-
cgi.exe

FastCGI protocol
over named pipes
or TCP


Run PHP apps
with
IIS 7.0
and SQL


Easy to set up


Install PHP with
FastCGI


Deploy the application


Compatible


Top 25 PHP applications tested/documented on
http://learn.iis.net/page.aspx/271/manually
-
installing
-
php
-
applications
-
on
-
iis/



Ease migration with URL Rewrite support for
mod_rewrite

configuration


SQL Server 2008 Surface Area Configuration


Setup Firewall if PHP and SQL not installed on the
same box … Ports 1433 +++

Let’s
Take

A

Look

Installing and Testing

an Application

IT Pro Momentum Program

A Microsoft program focused on supporting “early adopters”


IT professionals who bet on the newest technologies to drive
business value for their companies


Is IT Pro Momentum right for you?


Interested in learning more about the newest Microsoft
technologies?


Need help to evaluate different Microsoft products and
features?


Willing to test and pilot in production Microsoft beta products?


Would like to have access to exclusive forums and Microsoft
product support?


If you answered ‘yes’ for all the questions above, IT Pro
Momentum can help!


Email
keith.combs@microsoft.com

for more information

Call to Action


Download and install Windows Server 2008


Download SQL Server 2008


http://www.microsoft.com/sqlserver/2008/en/us/t
rial
-
software.aspx


http://www.microsoft.com/express/sql/download/


See the SQL Server 2008 Virtual Labs at
http://www.microsoft.com/sqlserver/2008/en/us/virt
ual
-
labs.aspx


Contact
Keith.Combs@microsoft.com

for the IT Pro
Momentum Program





End
-
of
-
the
-
Road Prize Drawing


Grand Prize
-

One Lenovo
Thinkpad

T61p
Laptop


approx value $1700.00


First Place
-

One Xbox 360 Video Game
Entertainment System
-

$300.00


Second Place
-

One 12GB Zune Digital
Media Player
-

$250.00


Third Place
-

One 8 GB Zune Digital
Media Player
-

$150.00



http://technetevents.com/interop/rules.htm


Resources


SQL 2005 Client Connectivity
http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994
-
8453
-
4998
-
8226
-
fa42ec403d17&displaylang=en



Sample Databases
http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?Rele
aseId=18407



Sample Application
http://msdn.microsoft.com/en
-
us/library/cc296196.aspx



System Requirements (SQL Server 2005 Driver for PHP)

http://msdn.microsoft.com/en
-
us/library/cc296170(SQL.90).aspx



Download latest "Stable Release" of PHP
http://www.php.net



PHP Driver for SQL

http://www.microsoft.com/downloads/details.aspx?FamilyId=61BF87E0
-
D031
-
466B
-
B09A
-
6597C21A2E2A&displaylang=en



More Resources


SQL 2005 Native Client (connects to 2005 and 2008 server)
http://download.microsoft.com/download/2/7/c/27c60d49
-
6dbe
-
423e
-
9a9e
-
1c873f269484/sqlncli.msi



Microsoft SQL Server 2008 Feature Pack, August 2008 (list of
downloads)
http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF
-
BA29
-
4A43
-
8D69
-
A2BED18FE73C&displaylang=en


Feature Pack for Microsoft SQL Server 2005
-

February 2007
http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994
-
8453
-
4998
-
8226
-
fa42ec403d17&displaylang=en



Non
-
Express SQL Sample Code and DB’s
CodePlex

Web site
http://www.codeplex.com/SqlServerSamples



Sample databases and sample code for SQL Server Express, see
Databases and Samples Overview
http://go.microsoft.com/fwlink/?LinkId=110391