3.extension_dir

####IBM##2009###FlexpureXML##3##:##pureXMLWeb##HTML###1###23#FlexpureXML##3##:##pureXMLWeb###HTML###pureXMLRSS#####TwitterJoeLennon######Freelance2009#12#21#IBMDB2#pureXMLXMLAdobeFlexXML###Flex3pureXML#Web###AdobeFlexTwitter#WebServices#DB2pureXML#######AdobeFlex#ActionScriptpureXMLWebServices##HTML################1#####DB2pureXML##Web###2#####FlexPHP#ProfileBadgeGenerator#RSSPublisher#TwitterApacheWeb####DB2Express-C#######API#######HTML########HTTP########RSS########SDK########SQL########URL########XML########developerWorksibm.
com/developerWorks/cn/#FlexpureXML##3##:##pureXMLWeb##HTML###2###23IBMDB2pureXMLPHPWeb##HTML##ProfileBadge#Web###HTML######pureXML########badge#PHP#####RSSPosttoTwitterTwitterAPITwitter##WebApacheWebPHP###Apache#DB2Apache###Apache####Web######ApacheHTTPServerbestavailableversion########Win32BinarywithoutCrypto2.
2.
14#Windowsmsi##Next###LicenseAgreement###Iacceptthetermsinthelicenseagreement#######Next######ReadThisFirst#####Next####ServerInformationApacheInstallApacheHTTPServer2.
2programsandshortcutsforAllUsers,onPort80,asaService1Next##1.
ApacheServerInformationTypical#Custom#ApacheServerTypical#####Next####DestinationFolderC:\ProgramFiles\ApacheSoftwareFoundation\Apache2.
2\#ibm.
com/developerWorks/cn/developerWorks#FlexpureXML##3##:##pureXMLWeb##HTML###3###23ReadytoInstalltheProgram#####Install#####2#####Finish########2.
###########ApacheApache3####3.
Apache############ApacheWebURLhttp://localhost/index.
html###Apache"Itworks!
"###4####4.
Itworks!
###ApachePHP#developerWorksibm.
com/developerWorks/cn/#FlexpureXML##3##:##pureXMLWeb##HTML###4###23##PHP#####PHP###WindowsPHP##5.
2.
x#5.
2.
11VC6x86ThreadSafe#####5######PHP5.
3#PHPExtensionCommunityLibrary(PECL)#####VC6x86ThreadSafe###Zip#######Installer#DebugPack###5.
PHPWindowsZipC:\php#lib#dll#####PEAR#6###ibm.
com/developerWorks/cn/developerWorks#FlexpureXML##3##:##pureXMLWeb##HTML###5###23#6.
C:\php######PHPWindowsControlPanel###System######Advanced######7##developerWorksibm.
com/developerWorks/cn/#FlexpureXML##3##:##pureXMLWeb##HTML###6###23#7.
Systemproperties##EnvironmentVariablesSystemvariables###PathEdit###8###8.
Environmentvariables#EditSystemVariablec:\php###Variablevalue#####9###ibm.
com/developerWorks/cn/developerWorks#FlexpureXML##3##:##pureXMLWeb##HTML###7###23#9.
Editsystemvariable#3OK######C:\phpphp.
ini-recommended#php.
ini######PHP#DB2PHP#PECL####php_ibm_db2.
dll#C:\php\ext######DB2PHP######C:\php\php.
ini######extension_dirextension_dir="c:\php\ext"######extension=php_zip.
dll#DB2#####extension=php_ibm_db2.
dll#;extension=php_curl.
dllextension=php_curl.
dll########PHP#ApachePHP###ApacheC:\ProgramFiles\ApacheSoftwareFoundation\Apache2.
2\conf\httpd.
conf#1##1.
##Apache###PHP-httpd.
conf##LoadModulephp5_module"c:/php/php5apache2_2.
dll"AddTypeapplication/x-httpd-php.
phpPHPIniDir"C:/php"##httpd.
confApache#####Apache2.
2>Restart#Web##WebPHP#DB2#######PHP#DB2phpphpinfo();>#test.
phpC:\ProgramFiles\ApacheSoftwareFoundation\Apache2.
2\htdocs#######Web######http://localhost/test.
php#PHP10#developerWorksibm.
com/developerWorks/cn/#FlexpureXML##3##:##pureXMLWeb##HTML###8###23#10.
PHP####PHPDB2ibm_db2######11DB2###ibm.
com/developerWorks/cn/developerWorks#FlexpureXML##3##:##pureXMLWeb##HTML###9###23#11.
ibm_db2#####PHP###PHP#DB2DB2######PHPDB2PHP#########PHP###DB2##########DB22test_db.
phpC:\ProgramFiles\ApacheSoftwareFoundation\Apache2.
2\htdocs######$db#$user#$passDB2#####$user#####Schema###2.
test_db.
php";echodb2_conn_errormsg($conn);}$sql="SELECT*FROMstatus_updates";$result=db2_exec($conn,$sql);echo"";developerWorksibm.
com/developerWorks/cn/#FlexpureXML##3##:##pureXMLWeb##HTML###10###23while($row=db2_fetch_array($result)){echo"$row[0]";}echo"";>http://localhost/test_db.
php#12##12.
##PHP#DB2####DB2PHPPHPPHPProfileBadge#######HTML#####Web#########HTML##PHP#DB212XMLSELECTXML#date_created#text#HTML###DB2#######SQL/XML#pureXMLPHPXQuery########DB2CommandEditor####(Start>Programs>IBMDB2>DB2COPY1(Default)>CommandLineTools>CommandEditor)#####MBLOG3##3.
######CREATEVIEWupdates(date_created,text)ASSELECTt.
date_created,t.
textFROMstatus_updatessu,XMLTABLE('$u/update'passingsu.
dataas"u"columnsdate_createdvarchar(100)path'date_created',textvarchar(500)path'text')ast;ibm.
com/developerWorks/cn/developerWorks#FlexpureXML##3##:##pureXMLWeb##HTML###11###23Play##selectdate_created,textfromupdates;#13#####13.
##Updates########SELECT#######date_created#text######status_updatesPHP####SELECT##########DB2#######ProfileBadgeGenerator#PHP#####BadgeGeneratorGenerateWeb###HTML###generate.
php#C:\ProgramFiles\ApacheSoftwareFoundation\Apache2.
2\htdocs#######4##4.
generate.
phpYourProfileBadgeisReady!
YourProfileBadgeisReady!
marginheight="0"marginwidth="0"style="background-color:developerWorksibm.
com/developerWorks/cn/#FlexpureXML##3##:##pureXMLWeb##HTML###12###23PastethefollowingcodeintoyourblogorWebsiteHTMLcodeinordertoaddtheProfileBadgetothatpage:marginheight="0"marginwidth="0"style="background-color:GenerateProfileBadgeGenerateProfileBadgeColor:WhiteYellowGreySize:WideNarrow>ProfileBadgeProfileBadgeIFRAME###HTMLIFRAME#5badge.
php############generate.
php#########5.
badge.
php";echodb2_conn_errormsg($conn);}>.
update{border-bottom:1pxsolidblack;padding:5px;}0&&strlen($row[1])>0){echo''.
''.
$row[0].
'