<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	xmlns:georss="http://www.georss.org/georss" xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#" xmlns:media="http://search.yahoo.com/mrss/"
	>

<channel>
	<title>techno surprises</title>
	<atom:link href="https://mustafaturan.wordpress.com/feed/" rel="self" type="application/rss+xml" />
	<link>https://mustafaturan.wordpress.com</link>
	<description>Guide to technology and web pages with suprising technologies...</description>
	<lastBuildDate>Thu, 04 Sep 2008 23:54:45 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>
	hourly	</sy:updatePeriod>
	<sy:updateFrequency>
	1	</sy:updateFrequency>
	<generator>http://wordpress.com/</generator>
<site xmlns="com-wordpress:feed-additions:1">1325152</site><cloud domain='mustafaturan.wordpress.com' port='80' path='/?rsscloud=notify' registerProcedure='' protocol='http-post' />
<image>
		<url>https://s2.wp.com/i/webclip.png</url>
		<title>techno surprises</title>
		<link>https://mustafaturan.wordpress.com</link>
	</image>
	<atom:link rel="search" type="application/opensearchdescription+xml" href="https://mustafaturan.wordpress.com/osd.xml" title="techno surprises" />
	<atom:link rel='hub' href='https://mustafaturan.wordpress.com/?pushpress=hub'/>
	<item>
		<title>C# source code for strip_tags in PHP</title>
		<link>https://mustafaturan.wordpress.com/2008/09/04/csharp-source-code-for-strip_tags-in-php/</link>
					<comments>https://mustafaturan.wordpress.com/2008/09/04/csharp-source-code-for-strip_tags-in-php/#respond</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Thu, 04 Sep 2008 23:52:08 +0000</pubDate>
				<category><![CDATA[c]]></category>
		<category><![CDATA[c sharp]]></category>
		<category><![CDATA[csharp]]></category>
		<category><![CDATA[php]]></category>
		<category><![CDATA[strip_tags]]></category>
		<category><![CDATA[match]]></category>
		<category><![CDATA[matchcollection]]></category>
		<category><![CDATA[namespace]]></category>
		<category><![CDATA[regex]]></category>
		<category><![CDATA[regular expressions]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/?p=36</guid>

					<description><![CDATA[Source to download: http://mustafaturan.net/download/lectures/csharp/strip_tags_csharp.txt // as a namespace do not forget to add: using System.Text.RegularExpressions; static string strip_tags(string str, string allowed_tags) { /* // Coder: Mustafa Turan // Date: 05.09.2008 // Contact: // http://mustafaturan.net/ // https://mustafaturan.wordpress.com/ // wm [ #at# ] mustafaturan.net // Licence: GNU and MIT Licence // EXAMPLES // &#8212;&#62;     function call1: strip_tags(&#8220;&#60;a [&#8230;]]]></description>
										<content:encoded><![CDATA[<blockquote><p>Source to download: <a href="http://mustafaturan.net/download/lectures/csharp/strip_tags_csharp.txt" rel="nofollow">http://mustafaturan.net/download/lectures/csharp/strip_tags_csharp.txt</a></p>
<p>// as a namespace do not forget to add: using System.Text.RegularExpressions;<br />
static string strip_tags(string str, string allowed_tags)<br />
{<br />
/*<br />
// Coder: Mustafa Turan<br />
// Date: 05.09.2008<br />
// Contact:<br />
// <a href="http://mustafaturan.net/" rel="nofollow">http://mustafaturan.net/</a><br />
// <a href="https://mustafaturan.wordpress.com/">https://mustafaturan.wordpress.com/</a><br />
// wm [ #at# ] mustafaturan.net<br />
// Licence: GNU and MIT Licence<br />
// EXAMPLES<br />
// &#8212;&gt;     function call1: strip_tags(&#8220;&lt;a href=\&#8221;asdadsadsad.html\&#8221;&gt;doctor&lt;/a&gt; &lt;p&gt;pirasa&lt;/p&gt; &lt;img src=\&#8221;asd.jpg\&#8221; /&gt; &lt;h1&gt;hey you&lt;/h1&gt;&#8221;, &#8220;&lt;a&gt;,&lt;p&gt;,&lt;img /&gt;&#8221;)<br />
// &#8212;&gt;     result: &lt;a href=&#8221;&#8221;&gt;doctor&lt;/a&gt; &lt;p&gt;pirasa&lt;/p&gt; &lt;img src=&#8221;asd.jpg&#8221; /&gt; hey you<br />
// &#8212;&gt;     function call2: strip_tags(&#8220;&lt;a href=\&#8221;asdadsadsad.html\&#8221;&gt;doctor&lt;/a&gt; &lt;p&gt;pirasa&lt;/p&gt; &lt;img src=\&#8221;asd.jpg\&#8221; /&gt; &lt;h1&gt;hey you&lt;/h1&gt;&#8221;, &#8220;&#8221;)<br />
// &#8212;&gt;     result: doctor pirasa hey you<br />
*/</p>
<p>// START<br />
// pattern for getting all tags<br />
string pattern_for_all_tags = &#8220;&lt;/?[^&gt;&lt;]+&gt;&#8221;;</p>
<p>// pattern for allowed tags<br />
string allowed_patterns = &#8220;&#8221;;<br />
if(allowed_tags!=&#8221;&#8221;){<br />
// get allowed tags if any exists<br />
Regex r = new Regex(&#8220;[\\/&lt;&gt; ]+&#8221;);<br />
allowed_tags = r.Replace(allowed_tags,&#8221;&#8221;);<br />
string[] allowed_tags_array = allowed_tags.Split(&#8216;,&#8217;);<br />
foreach (string s in allowed_tags_array)<br />
{<br />
if (s == &#8220;&#8221;) continue;<br />
// Definin patterns<br />
string p_1 = &#8220;&lt;&#8221; + s + &#8221; [^&gt;&lt;]*&gt;$&#8221;;<br />
string p_2 = &#8220;&lt;&#8221; + s + &#8220;&gt;&#8221;;<br />
string p_3 = &#8220;&lt;/&#8221; + s + &#8220;&gt;&#8221;;<br />
if(allowed_patterns!=&#8221;&#8221;)<br />
allowed_patterns += &#8220;|&#8221;;<br />
allowed_patterns += p_1 + &#8220;|&#8221; + p_2 + &#8220;|&#8221; + p_3;<br />
}<br />
}</p>
<p>// Get all html tags included on string<br />
Regex strip_tags = new Regex(pattern_for_all_tags);<br />
MatchCollection all_tags_matched = strip_tags.Matches(str);</p>
<p>if (allowed_patterns != &#8220;&#8221;)<br />
foreach (Match m in all_tags_matched)<br />
{<br />
Regex r_1 = new Regex(allowed_patterns);<br />
Match m_1 = r_1.Match(m.Value);<br />
if (!m_1.Success)<br />
{<br />
// if not allowed replace it<br />
str = str.Replace(m.Value, &#8220;&#8221;);<br />
}<br />
}<br />
else<br />
// if not allow anyone replace all<br />
str = strip_tags.Replace(str, &#8220;&#8221;);<br />
return str;<br />
}</p></blockquote>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2008/09/04/csharp-source-code-for-strip_tags-in-php/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">36</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>mysql 5 procedure calls for creating member registration</title>
		<link>https://mustafaturan.wordpress.com/2008/05/05/mysql-5-procedure-calls-for-creating-member-registration/</link>
					<comments>https://mustafaturan.wordpress.com/2008/05/05/mysql-5-procedure-calls-for-creating-member-registration/#respond</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Mon, 05 May 2008 19:57:01 +0000</pubDate>
				<category><![CDATA[database]]></category>
		<category><![CDATA[mysql 5]]></category>
		<category><![CDATA[procedure calls]]></category>
		<category><![CDATA[call]]></category>
		<category><![CDATA[member registration]]></category>
		<category><![CDATA[members]]></category>
		<category><![CDATA[mysql]]></category>
		<category><![CDATA[procedure]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/?p=35</guid>

					<description><![CDATA[http://mustafaturan.net/tr/mysql5_procedured_function_calls2_for_membership.html ## Coder Mustafa Turan ## ## http://mustafaturan.net/ ## ## Delimiters $$ ## ## members(m_ID, m_name, m_email, m_pass, m_acode, m_status, m_datetime) ## DROP PROCEDURE NewMember$$ CREATE PROCEDURE NewMember(# yeni kullanıcı # IN N_m_name VARCHAR(14), IN N_m_email VARCHAR(55), IN N_m_pass CHAR(32), IN N_m_acode CHAR(6), OUT N_m_err TINYINT ) BEGIN DECLARE name_exist TINYINT; DECLARE email_exist TINYINT; SET [&#8230;]]]></description>
										<content:encoded><![CDATA[<p><a href="http://mustafaturan.net/tr/mysql5_procedured_function_calls2_for_membership.html">http://mustafaturan.net/tr/mysql5_procedured_function_calls2_for_membership.html</a><br />
<code><br />
## Coder Mustafa Turan ##<br />
## http://mustafaturan.net/ ##<br />
## Delimiters $$ ##</p>
<p>## members(m_ID, m_name, m_email, m_pass, m_acode, m_status, m_datetime) ##</p>
<p>DROP PROCEDURE NewMember$$</p>
<p>CREATE PROCEDURE NewMember(# yeni kullanıcı #<br />
	IN N_m_name VARCHAR(14),<br />
	IN N_m_email VARCHAR(55),<br />
	IN N_m_pass CHAR(32),<br />
	IN N_m_acode CHAR(6),<br />
	OUT N_m_err TINYINT<br />
)<br />
BEGIN<br />
	DECLARE name_exist TINYINT;<br />
	DECLARE email_exist TINYINT;<br />
	SET name_exist = 0;<br />
	SET email_exist = 0;</p>
<p>	# get m_ID to name_exist #<br />
	SELECT count(m_ID) INTO name_exist FROM members WHERE m_name = N_m_name LIMIT 0,1;</p>
<p>	# get m_ID to email_exist #<br />
	SELECT count(m_ID) INTO email_exist FROM members WHERE m_email = N_m_email LIMIT 0,1;</p>
<p>	IF name_exist &gt; 0 THEN<br />
		SET N_m_err	= 1;<br />
	ELSE IF email_exist &gt; 0 THEN<br />
		SET N_m_err	= 2;<br />
	ELSE<br />
		INSERT INTO members (m_ID, m_name, m_email, m_pass, m_acode, m_status, m_datetime) VALUES (NULL, N_m_name, N_m_email, N_m_pass, N_m_acode, 0, NOW())<br />
		SET N_m_err	= 0;<br />
	END IF;<br />
END$$</p>
<p>DROP PROCEDURE ActivateMember$$ </p>
<p>CREATE PROCEDURE ActivateMember(# kullanıcıyı aktive etmek #<br />
	IN N_m_email VARCHAR(55),<br />
	IN N_m_acode CHAR(6),<br />
	OUT N_m_err TINYINT<br />
)<br />
BEGIN<br />
	DECLARE already_active TINYINT;<br />
	DECLARE wrong_code TINYINT;<br />
	SET already_active = 0;<br />
	SET wrong_code = 0;</p>
<p>	# get active status #<br />
	SELECT count(m_ID) INTO already_active FROM members WHERE m_email = N_m_email AND m_acode = N_m_acode AND m_status = 1 LIMIT 0,1;</p>
<p>	# get code status #<br />
	SELECT count(m_ID) INTO wrong_code FROM members WHERE m_email = N_m_email AND m_acode = N_m_acode LIMIT 0,1;</p>
<p>	IF already_active &gt; 0 THEN<br />
		SET N_m_err	= 3;<br />
	ELSE IF wrong_code &lt;= 0 THEN<br />
		SET N_m_err	= 4;<br />
	ELSE<br />
		UPDATE members SET m_status = 1 WHERE m_email = N_m_email AND m_acode = N_m_acode LIMIT 1;<br />
	END IF;<br />
END$$</p>
<p>DROP PROCEDURE ChangePassword$$</p>
<p>CREATE PROCEDURE ChangePassword( # şifre değiştirme #<br />
	IN N_m_email VARCHAR(55),<br />
	IN N_m_pass CHAR(32),<br />
	IN O_m_pass CHAR(32),<br />
	OUT N_m_err TINYINT<br />
)<br />
BEGIN<br />
	DECLARE wrong_pass TINYINT;<br />
	SET wrong_pass = 0;</p>
<p>	# get code status #<br />
	SELECT count(m_ID) INTO wrong_pass FROM members WHERE m_email = N_m_email AND m_pass = O_m_pass LIMIT 0,1;</p>
<p>	IF wrong_pass  0 THEN<br />
		# DELETE * FROM files WHERE m_ID = O_m_ID; #<br />
		# DELETE * FROM members WHERE m_ID = O_m_ID LIMIT 1; #<br />
		UPDATE MEMBERS SET m_status = 0 WHERE m_ID = O_m_ID LIMIT 1;<br />
		SET N_m_err	= 5;<br />
	ELSE<br />
		SET N_m_err	= 6;</p>
<p>END$$<br />
</code></p>
<p><code><br />
$N_m_err[0] = ‘Please check your email’;<br />
$N_m_err[1] = ‘Already in use.’;<br />
$N_m_err[2] = ‘E-mail in use.’;<br />
$N_m_err[3] = ‘Already active user.’;<br />
$N_m_err[4] = ‘Invalid activation code!’;</p>
<p>$N_m_err[5] = ‘User and its db files are deleted.’;<br />
$N_m_err[6] = ‘User not found.’;</p>
<p>$N_m_err[7] = ‘Old password is wrong.’;<br />
</code></p>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2008/05/05/mysql-5-procedure-calls-for-creating-member-registration/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">35</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>Windows Vista SP1 Download</title>
		<link>https://mustafaturan.wordpress.com/2008/03/19/windows-vista-sp1-download/</link>
					<comments>https://mustafaturan.wordpress.com/2008/03/19/windows-vista-sp1-download/#respond</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Wed, 19 Mar 2008 00:12:44 +0000</pubDate>
				<category><![CDATA[service pack]]></category>
		<category><![CDATA[sp1]]></category>
		<category><![CDATA[vista]]></category>
		<category><![CDATA[windows]]></category>
		<category><![CDATA[1]]></category>
		<category><![CDATA[download]]></category>
		<category><![CDATA[legal]]></category>
		<category><![CDATA[link]]></category>
		<category><![CDATA[pack]]></category>
		<category><![CDATA[service]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/?p=34</guid>

					<description><![CDATA[Microsoft published windows vista sp1 today. Here is legal download links: Overview of Windows Vista SP1 and Download Links http://www.microsoft.com/downloads/details.aspx?familyid=39B802EA-B2CF-4585-8CEA-2CC6A6247CB3&#038;displaylang=en http://msdn2.microsoft.com/en-us/windowsvista/bb898842.aspx (subscription links) http://www.microsoft.com/downloads/details.aspx?familyid=b0c7136d-5ebb-413b-89c9-cb3d06d12674&#038;displaylang=en]]></description>
										<content:encoded><![CDATA[<p>Microsoft published <b>windows vista sp1 </b>today. Here is legal download links:</p>
<h3>Overview of Windows Vista SP1 and Download Links</h3>
<p><a href="http://www.microsoft.com/downloads/details.aspx?familyid=39B802EA-B2CF-4585-8CEA-2CC6A6247CB3&#038;displaylang=en" rel="nofollow">http://www.microsoft.com/downloads/details.aspx?familyid=39B802EA-B2CF-4585-8CEA-2CC6A6247CB3&#038;displaylang=en</a></p>
<p><a href="http://msdn2.microsoft.com/en-us/windowsvista/bb898842.aspx" rel="nofollow">http://msdn2.microsoft.com/en-us/windowsvista/bb898842.aspx</a>  (subscription links)</p>
<p><a href="http://www.microsoft.com/downloads/details.aspx?familyid=b0c7136d-5ebb-413b-89c9-cb3d06d12674&#038;displaylang=en" rel="nofollow">http://www.microsoft.com/downloads/details.aspx?familyid=b0c7136d-5ebb-413b-89c9-cb3d06d12674&#038;displaylang=en</a></p>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2008/03/19/windows-vista-sp1-download/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">34</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>Translator Live Communication</title>
		<link>https://mustafaturan.wordpress.com/2008/01/24/translator-live-communication/</link>
					<comments>https://mustafaturan.wordpress.com/2008/01/24/translator-live-communication/#respond</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Thu, 24 Jan 2008 15:19:02 +0000</pubDate>
				<category><![CDATA[live]]></category>
		<category><![CDATA[microsoft]]></category>
		<category><![CDATA[product]]></category>
		<category><![CDATA[service]]></category>
		<category><![CDATA[translate easily]]></category>
		<category><![CDATA[translate in a quick way]]></category>
		<category><![CDATA[translation]]></category>
		<category><![CDATA[translator,]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/2008/01/24/translator-live-communication/</guid>

					<description><![CDATA[After Google Translate Live.com published a beta&#160; translator service which is using the&#160; systransoft technology. Link: http://translator.live.com/ Technology: http://www.systransoft.com/]]></description>
										<content:encoded><![CDATA[<p>After <a href="https://mustafaturan.wordpress.com/2007/07/07/using-google-translate-is-smart-idea/">Google Translate</a> Live.com published a beta&nbsp; translator service which is using the&nbsp; systransoft technology.</p>
<p>Link: <a title="http://translator.live.com/" href="http://translator.live.com/">http://translator.live.com/</a></p>
<p>Technology: <a title="http://www.systransoft.com/" href="http://www.systransoft.com/">http://www.systransoft.com/</a></p>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2008/01/24/translator-live-communication/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">33</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>HTML 5</title>
		<link>https://mustafaturan.wordpress.com/2008/01/24/html-5/</link>
					<comments>https://mustafaturan.wordpress.com/2008/01/24/html-5/#respond</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Thu, 24 Jan 2008 15:13:46 +0000</pubDate>
				<category><![CDATA[html]]></category>
		<category><![CDATA[html 5]]></category>
		<category><![CDATA[w3]]></category>
		<category><![CDATA[w3.org]]></category>
		<category><![CDATA[w3c]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/2008/01/24/html-5/</guid>

					<description><![CDATA[W3C Publishes HTML 5 Draft, Future of Web Content 2008-01-22: W3C today published an early draft of HTML 5, a major revision of the markup language for the Web. The HTML Working Group is creating HTML 5 to be the open, royalty-free specification for rich Web content and Web applications. &#8220;HTML is of course a [&#8230;]]]></description>
										<content:encoded><![CDATA[<h3>W3C Publishes HTML 5 Draft, Future of Web Content</h3>
<p>2008-01-22: W3C today published an early draft of HTML 5, a major revision of the markup language for the Web. The HTML Working Group is creating HTML 5 to be the open, royalty-free specification for rich Web content and Web applications. &#8220;HTML is of course a very important standard,&#8221; said Tim Berners-Lee, author of the first version of HTML and W3C Director. &#8220;I am glad to see that the community of developers, including browser vendors, is working together to create the best possible path for the Web.&#8221; New features include APIs for drawing two-dimensional graphics and ways to embed and control audio and video content. HTML 5 helps to improve interoperability and reduce software costs by giving precise rules not only about how to handle all correct HTML documents but also how to recover from errors. </p>
<p>Source: <a title="http://www.w3.org/TR/2008/WD-html5-20080122/" href="http://www.w3.org/TR/2008/WD-html5-20080122/">http://www.w3.org/TR/2008/WD-html5-20080122/</a></p>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2008/01/24/html-5/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">32</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>PHP &#8211; MSSQL to XML</title>
		<link>https://mustafaturan.wordpress.com/2008/01/23/php-mssql-to-xml/</link>
					<comments>https://mustafaturan.wordpress.com/2008/01/23/php-mssql-to-xml/#respond</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Wed, 23 Jan 2008 16:04:07 +0000</pubDate>
				<category><![CDATA[code]]></category>
		<category><![CDATA[column]]></category>
		<category><![CDATA[connect]]></category>
		<category><![CDATA[connection string]]></category>
		<category><![CDATA[mssql]]></category>
		<category><![CDATA[name]]></category>
		<category><![CDATA[php]]></category>
		<category><![CDATA[php mssql]]></category>
		<category><![CDATA[row]]></category>
		<category><![CDATA[sample]]></category>
		<category><![CDATA[software]]></category>
		<category><![CDATA[xml]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/2008/01/23/php-mssql-to-xml/</guid>

					<description><![CDATA[These piece of PHP code is help to understand; How to get column names from MSSQL with PHP? How to get related row attributes from MSSQL with PHP? And how to convert MSSQL tables to XML data store type? Here is the source code, it is completely free and usable for any purposes. &#60;?php // [&#8230;]]]></description>
										<content:encoded><![CDATA[<p>These piece of <strong>PHP code</strong> is help to understand;</p>
<ul>
<li>How to get column names from MSSQL with PHP?</li>
<li>How to get related row attributes from MSSQL with PHP?</li>
<li>And how to convert MSSQL tables to XML data store type?</li>
</ul>
<p>Here is the source code, it is completely free and usable for any purposes.</p>
<blockquote>
<p>&lt;?php </p>
<p>// Coder Mustafa Turan</p>
<p>// <a href="https://mustafaturan.wordpress.com/">https://mustafaturan.wordpress.com/</a><br />// get query from URL <br />$query&nbsp;&nbsp;&nbsp; = urldecode($_GET[&#8216;q&#8217;]); <br />if(empty($_GET[&#8216;q&#8217;])) exit(); <br />echo &#8220;&lt;?xml version=\&#8221;1.0\&#8221; encoding=\&#8221;UTF-8\&#8221;?&gt;&#8221;; <br />&nbsp;&nbsp;&nbsp; /* <br />&nbsp;&nbsp;&nbsp; sample query: <br />&nbsp;&nbsp;&nbsp; $query = &#8220;SELECT * FROM table_name&#8221;; <br />&nbsp;&nbsp;&nbsp; */ </p>
<p>&nbsp;&nbsp;&nbsp; // connection open to MSSQL <br />&nbsp;&nbsp;&nbsp; $link = mssql_connect(&#8216;hostname&#8217;, &#8216;username&#8217;, &#8216;password&#8217;); <br />&nbsp;&nbsp;&nbsp; mssql_select_db(&#8216;dbname&#8217;, $link); </p>
<p>&nbsp;&nbsp;&nbsp; // get the query result <br />&nbsp;&nbsp;&nbsp; $result = mssql_query($query, $link); <br />&nbsp;&nbsp;&nbsp; $i = 0; </p>
<p>&nbsp;&nbsp;&nbsp; // get all columns readed from query <br />&nbsp;&nbsp;&nbsp; while ($column = mssql_fetch_field ($result)){ <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $columnx[$i] = $column-&gt;name; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $i++; <br />&nbsp;&nbsp;&nbsp; } <br />&nbsp;&nbsp;&nbsp; $column = null; </p>
<p>&nbsp;&nbsp;&nbsp; // read all rows with its column name <br />&nbsp;&nbsp;&nbsp; while (($row = mssql_fetch_array($result, MSSQL_BOTH))) <br />&nbsp;&nbsp;&nbsp; { <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo &#8220;\n &lt;new_row&gt;&#8221;; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; foreach($columnx as $C){ <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // $C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : column name <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // $row[$C]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : it give the current rows&#8217; column variable <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // sample output&nbsp;&nbsp;&nbsp; : &lt;column_name&gt;column_content&lt;/column_name&gt; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo &#8220;\n&nbsp; &lt;&#8221; . $C . &#8220;&gt;&#8221; . $row[$C] . &#8220;&lt;/&#8221; . $C . &#8220;&gt;&#8221;; <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } <br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo &#8220;\n &lt;/new_row&gt;&#8221;; <br />&nbsp;&nbsp;&nbsp; } </p>
<p>&nbsp;&nbsp;&nbsp; // close the current connection <br />&nbsp;&nbsp;&nbsp; mssql_free_result($result); <br />&nbsp;&nbsp;&nbsp; mssql_close($link); <br />echo &#8220;\n&lt;/xml&gt;&#8221;; <br />?&gt; </p>
</blockquote>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2008/01/23/php-mssql-to-xml/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">31</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>Windows XP Service Pack 3 Release Candidate</title>
		<link>https://mustafaturan.wordpress.com/2007/12/30/windows-xp-service-pack-3-release-candidate/</link>
					<comments>https://mustafaturan.wordpress.com/2007/12/30/windows-xp-service-pack-3-release-candidate/#respond</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Sun, 30 Dec 2007 15:38:16 +0000</pubDate>
				<category><![CDATA[download]]></category>
		<category><![CDATA[Release Candidate]]></category>
		<category><![CDATA[service pack]]></category>
		<category><![CDATA[service pack 3]]></category>
		<category><![CDATA[sp 3]]></category>
		<category><![CDATA[sp3]]></category>
		<category><![CDATA[windows]]></category>
		<category><![CDATA[windows xp]]></category>
		<category><![CDATA[xp]]></category>
		<category><![CDATA[operating system]]></category>
		<category><![CDATA[OS]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/2007/12/30/windows-xp-service-pack-3-release-candidate/</guid>

					<description><![CDATA[Standalone Update Package for Windows® XP Service Pack 3 Release Candidate See the overview from http://www.microsoft.com/ Windows XP SP3 combines all previously released performance, security, and stability updates. It also provides a limited number of new and enhanced functionalities, although it does not significantly change the Windows XP experience or bring functionality from newer versions [&#8230;]]]></description>
										<content:encoded><![CDATA[<p>Standalone Update Package for Windows® XP Service Pack 3 Release Candidate</p>
<p>See the overview from <a href="http://www.microsoft.com/" rel="nofollow">http://www.microsoft.com/</a></p>
<blockquote><p><span>Windows XP SP3 combines all previously released performance, security, and stability updates. It also<br />
provides a limited number of new and enhanced functionalities, although it does not significantly change the<br />
Windows XP experience or bring functionality from newer versions of Windows to Windows XP. The goals of<br />
Windows XP SP3 are to:<br />
</span></p>
<ul>
<li>Provide a new baseline for customers still deploying Windows XP, to help them avoid the inconvenience<br />
of applying individual updates.</li>
<li>Fill gaps in the updates users might have missed by declining individual updates when using Automatic<br />
Updates, and to deliver updates not made available through Windows Update.</li>
</ul>
<p>Windows Vista provides the most advanced security and management capability, but for PCs that cannot be<br />
upgraded to Windows Vista right now, Windows XP SP3 ensures these PCs have all available updates and<br />
allows these PCs to leverage some new Windows Server 2008 capabilities, such as Network Access<br />
Protection (NAP).</p></blockquote>
<p><b><i>All language supported downlod links:</i></b></p>
<p><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=75ed934c-8423-4386-ad98-36b124a720aa&#038;DisplayLang=en" rel="nofollow">http://www.microsoft.com/downloads/details.aspx?FamilyID=75ed934c-8423-4386-ad98-36b124a720aa&#038;DisplayLang=en</a></p>
<p><b><i>Overview</i></b></p>
<p><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=68c48dad-bc34-40be-8d85-6bb4f56f5110&#038;DisplayLang=en#filelist" rel="nofollow">http://www.microsoft.com/downloads/details.aspx?FamilyID=68c48dad-bc34-40be-8d85-6bb4f56f5110&#038;DisplayLang=en#filelist</a></p>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2007/12/30/windows-xp-service-pack-3-release-candidate/feed/</wfw:commentRss>
			<slash:comments>0</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">27</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>Random Team Matching with php</title>
		<link>https://mustafaturan.wordpress.com/2007/12/06/random-team-matching-with-php/</link>
					<comments>https://mustafaturan.wordpress.com/2007/12/06/random-team-matching-with-php/#comments</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Thu, 06 Dec 2007 17:26:13 +0000</pubDate>
				<category><![CDATA[php]]></category>
		<category><![CDATA[programming]]></category>
		<category><![CDATA[code]]></category>
		<category><![CDATA[free]]></category>
		<category><![CDATA[match]]></category>
		<category><![CDATA[matching]]></category>
		<category><![CDATA[php code]]></category>
		<category><![CDATA[random]]></category>
		<category><![CDATA[randomize]]></category>
		<category><![CDATA[selection]]></category>
		<category><![CDATA[selector]]></category>
		<category><![CDATA[teams]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/2007/12/06/random-team-matching-with-php/</guid>

					<description><![CDATA[echo "start\n\n"; $a1 = Array('Chealsea', 'Arsenal', 'Manchester', 'Liverpool');$a2 = Array('Ato', 'Ozi', 'Mustafa', 'Emo'); $b = "0123"; $c = "0123";   for($i=0;$i&#60;(sizeof($a1)-1);$i++) { if($i!=0){ $b = str_replace($s1,"",$b); $c = str_replace($s2,"",$c); } $s1 = substr(str_shuffle($b), 0, 1); $s2 = substr(str_shuffle($c), 0, 1); echo $a1[$s1] . ":" . $a2[$s2] . "\n"; } echo "\n\nend";]]></description>
										<content:encoded><![CDATA[<pre>

echo "start\n\n"; $a1 = Array('Chealsea', 'Arsenal', 'Manchester', 'Liverpool');$a2 = Array('Ato', 'Ozi', 'Mustafa', 'Emo');
<pre>
$b = "0123";

$c = "0123";   for($i=0;$i&lt;(sizeof($a1)-1);$i++) {

if($i!=0){

$b	= str_replace($s1,"",$b);

$c	= str_replace($s2,"",$c);

}

$s1	= substr(str_shuffle($b), 0, 1);

$s2	= substr(str_shuffle($c), 0, 1);

echo $a1[$s1] . ":" . $a2[$s2] . "\n";

}

echo "\n\nend";</pre>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2007/12/06/random-team-matching-with-php/feed/</wfw:commentRss>
			<slash:comments>1</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">26</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>Microsoft Visual Studio 2008 Express Edition DVD iso</title>
		<link>https://mustafaturan.wordpress.com/2007/12/06/microsoft-visual-studio-2008-express-edition-dvd-iso/</link>
					<comments>https://mustafaturan.wordpress.com/2007/12/06/microsoft-visual-studio-2008-express-edition-dvd-iso/#comments</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Thu, 06 Dec 2007 02:40:15 +0000</pubDate>
				<category><![CDATA[full programs]]></category>
		<category><![CDATA[iso]]></category>
		<category><![CDATA[microsoft]]></category>
		<category><![CDATA[software]]></category>
		<category><![CDATA[2008]]></category>
		<category><![CDATA[direct link]]></category>
		<category><![CDATA[download]]></category>
		<category><![CDATA[download link]]></category>
		<category><![CDATA[dvd]]></category>
		<category><![CDATA[edition]]></category>
		<category><![CDATA[express]]></category>
		<category><![CDATA[full]]></category>
		<category><![CDATA[link]]></category>
		<category><![CDATA[original]]></category>
		<category><![CDATA[save]]></category>
		<category><![CDATA[studio]]></category>
		<category><![CDATA[visual]]></category>
		<category><![CDATA[visual studio 2008 express edition]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/2007/12/06/microsoft-visual-studio-2008-express-edition-dvd-iso/</guid>

					<description><![CDATA[Free DVD iso link given by originally download.microsoft.com visual studio 2008 express edition all in one http://go.microsoft.com/fwlink/?LinkId=104679 http://download.microsoft.com/download/8/B/5/8B5804AD-4990-40D0-A6AA-CE894CBBB3DC/VS2008ExpressENUX1397868.iso Visual Basic 2008 Express Edition Visual C# 2008 Express Edition Visual C++ 2008 Express Edition Visual Web Developer 2008 Express Edition SQL Server Express Edition Directlink &#8211; 897 MB &#8211; DVD Iso File]]></description>
										<content:encoded><![CDATA[<p>Free DVD iso link given by originally download.microsoft.com</p>
<h3>visual studio 2008 express edition all in one</h3>
<p><strong><a href="http://go.microsoft.com/fwlink/?LinkId=104679" rel="nofollow">http://go.microsoft.com/fwlink/?LinkId=104679</a></strong></p>
<p><strong><a href="http://download.microsoft.com/download/8/B/5/8B5804AD-4990-40D0-A6AA-CE894CBBB3DC/VS2008ExpressENUX1397868.iso" rel="nofollow">http://download.microsoft.com/download/8/B/5/8B5804AD-4990-40D0-A6AA-CE894CBBB3DC/VS2008ExpressENUX1397868.iso</a> </strong></p>
<p>Visual Basic 2008 Express Edition<br />
Visual C# 2008 Express Edition<br />
Visual C++ 2008 Express Edition<br />
Visual Web Developer 2008 Express Edition<br />
SQL Server Express Edition</p>
<p>Directlink &#8211; 897 MB &#8211; DVD Iso File</p>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2007/12/06/microsoft-visual-studio-2008-express-edition-dvd-iso/feed/</wfw:commentRss>
			<slash:comments>3</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">25</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
		<item>
		<title>Installing required packages for C compiler on Linux</title>
		<link>https://mustafaturan.wordpress.com/2007/11/04/installing-required-packages-for-c-compiler-on-linux/</link>
					<comments>https://mustafaturan.wordpress.com/2007/11/04/installing-required-packages-for-c-compiler-on-linux/#comments</comments>
		
		<dc:creator><![CDATA[Mustafa Turan]]></dc:creator>
		<pubDate>Sun, 04 Nov 2007 23:45:01 +0000</pubDate>
				<category><![CDATA[apt-get]]></category>
		<category><![CDATA[c compiler]]></category>
		<category><![CDATA[devoloper]]></category>
		<category><![CDATA[kubuntu]]></category>
		<category><![CDATA[kubuntu 7.10]]></category>
		<category><![CDATA[ubuntu]]></category>
		<category><![CDATA[ubuntu 7.10]]></category>
		<category><![CDATA[c]]></category>
		<category><![CDATA[gcc]]></category>
		<category><![CDATA[kubuntun]]></category>
		<guid isPermaLink="false">http://mustafaturan.wordpress.com/2007/11/04/installing-required-packages-for-c-compiler-on-linux/</guid>

					<description><![CDATA[Installing required packages for C compiler on Ubuntu 7.10 If you need to compile C, C++ programs under ubuntu or kubuntu, packages listed below will help you to compile. apt-get install  libpqxx-dev apt-get install  libstdc++6-42-doc apt-get install  cpp-4.2 all packages: gcc, libpqxx-dev, libstdc++6-42-doc,cpp-4.2]]></description>
										<content:encoded><![CDATA[<p>Installing required packages for C compiler on Ubuntu 7.10</p>
<p>If you need to compile C, C++ programs under ubuntu or kubuntu, packages listed below will help you to compile.</p>
<p>apt-get install  libpqxx-dev</p>
<p>apt-get install  libstdc++6-42-doc</p>
<p>apt-get install  cpp-4.2</p>
<p>all packages: gcc, libpqxx-dev, libstdc++6-42-doc,cpp-4.2</p>
]]></content:encoded>
					
					<wfw:commentRss>https://mustafaturan.wordpress.com/2007/11/04/installing-required-packages-for-c-compiler-on-linux/feed/</wfw:commentRss>
			<slash:comments>3</slash:comments>
		
		
		<post-id xmlns="com-wordpress:feed-additions:1">24</post-id>
		<media:content url="https://1.gravatar.com/avatar/df91fcfc27a599d637183a6b1ac64fc07b60ff906680164dd1fcde76492012da?s=96&#38;d=identicon&#38;r=G" medium="image">
			<media:title type="html">mustafaturan</media:title>
		</media:content>
	</item>
	</channel>
</rss>
