Host Wordpress on Windows Azure: Consume SQL Azure Using PHP
our wordpress live sample website：
https://wordpress-win-azure.cloudapp.net/
Download sample project here
This tutorial article will show you how to consume SQL Azure using PHP with just several easy steps. Please refer first series article Run PHP application in Windows Azure for a prerequisite.
1. To enable PHP to access SQL Azure, SQL Server Driver must be added to PHP extensions. (For SQL Azure is built on SQL Server).Download it form SQL Server Driver for PHP 2.0.
2．Open and extract it, driver files are listed below.
We choose php_sqlsrv_53_nts_vc9.dll, for it matches our PHP version, VC9 x86 Non Thread Safe.
Put the driver into php\ext folder in the PHP _WebCgiRole project.
Rename php.ini-develop in the php folderto php-ini. Right click on php.ini, choose Properties, and change the value of Build Action to Content.
Click to Open php.ini, look up extension_dir and change its value to "./ext" . It indicates the extension directory of PHP.
Add "extension = php_sqlsrv_53_nts_vc9.dll "to php.ini.
4. Put the PHP code below to index.php (refer to Run PHP application in Windows Azure ) .Please refer to here to replace the SQL Azure account information with yours.
<?php
$serverName = "tcp:ServerID.database.windows.net, 1433";
$connectionOptions = array("Database" => "yourdatabase",
"UID" => "yourusername@ServerID",
"PWD" => "yourpassword",
);
$retry = 10;
$conn ;
while($retry--)
{
$conn = sqlsrv_connect($serverName, $connectionOptions);
if($conn)
{
echo "Connect Success!";
break;
}
}
if($conn === false)
{
die(print_r(sqlsrv_errors(), true));
}
?>
Verification:
5. Press F5 to debug the application, wait for the browser to start, you'll see the result below:
You can put it into Windows Azure Hosted service now, and will get the same result.
The process is still simple and easy as before, now you can exploit the power of SQL Azure!
References:
https://msdn.microsoft.com/en-us/library/ff394110.aspx
https://blogs.msdn.com/b/brian_swan/archive/2010/02/12/getting-started-with-php-and-sql-azure.aspx
Topic |
Description |
This article will show how easy to run PHP application inWindows Azure |
|
This article describes how to access SQL Azure using PHP. |
|
This article describes the process about host Wordpress on Windows Azure. Similarly, you will see how easy it will be. |
|
This article introduces the Windows Azure Storage plugin for WordPress . It enables Wordpress store multimedia contenton Windows Azure Storage. |
Comments
Anonymous
September 07, 2010
Hi, your link for SQL Server Driver for PHP seems broken. You may want to change to this updated link: www.microsoft.com/.../details.aspxAnonymous
September 08, 2010
Hi Wely, Thanks for your input. we have updated the link.Anonymous
December 19, 2010
Hello, I follow your tutorial, and pass through Chapter 1. But I stuck at Chapter 2. I got 3 error popups when I hit F5. "php-cgi.exe - Entry Point Not Found x The procedure entry point php_set_error_handling could not be located in the dynamic link library php5.dll." "php-cgi.exe - System Error x The program can't start because php_pdo.dll is missing from your computer. Try reinstalling the program to fix this problem." "php-cgi.exe - System Error x The program can't start because php_mbstring.dll is missing from your computer. Try reinstalling the program to fix this problem." I carefully recheck again, and try to remove some code in index.php. I found that if I remove "sqlsrv_connect($serverName, $connectionOptions);" the problem was gone. Do you have any idea? ThankAnonymous
December 19, 2010
I'm sure that SQL Azure account information is correct because I can connect to my database using Microsoft SQL Managment Studio. and I have new infos. when index.php don't have "$conn = sqlsrv_connect($serverName, $connectionOptions);" then I got blank page. no error. then if insert "$conn = sqlsrv_connect($serverName, $connectionOptions);" then I got the 3 error popups. and "Http 500 Internal Server Error" then if I change "$conn = sqlsrv_connect($serverName, $connectionOptions);" to " sqlsrv_connect($serverName, $connectionOptions);" then I got "Http 500 Internal Server Error", no the error popups. PS. I use SDK 1.3 and I need to comment <Sites> section in ServiceDefinition.csdef because of a error which discuss here social.msdn.microsoft.com/.../a000c4ec-8d92-4320-8328-8521323c60cd I still stuck in Chapter 2. T TAnonymous
December 19, 2010
Update: I add 2 more extensions in "php-ini" file extension=php_pdo_sqlsrv_53_nts_vc9.dll extension=php_mbstring.dll and the 3 error popups has gone. BTW I still got "Http 500 Internal Server Error" page.Anonymous
December 19, 2010
update: I also try the sample project, and It's doesn't work.