<?xml version="1.0" encoding="UTF-8"?><?xml-stylesheet type="text/xsl" href="http://www.bytemycode.com/rssformat.xsl"?><rss version="2.0" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/">
	<channel>
		<title>byteMyCode: Snippets for "mysql"</title>
		<link>http://www.bytemycode.com</link>
		<description>Snippets for this tag.</description>
		<pubDate>Tue, 02 Dec 2008 16:39:37 +0000</pubDate>
		<copyright>1998-2008 </copyright>
		<language>en-us</language>
		<image>
		      <link>http://www.bytemycode.com</link>
		      <url>http://www.bytemycode.com/img/rss_title.gif</url>
		      <title>byteMyCode</title>
		</image>

	<item>
	<title>get number of chars and '...' of data field in SQL</title>
	<link>http://www.bytemycode.com/snippets/snippet/860/</link>
	<comments>http://www.bytemycode.com/snippets/snippet/860/comments/</comments>
	<pubDate>Thu, 30 Oct 2008 13:01:42 +0000</pubDate>
	<dc:creator>nostromo</dc:creator>
	<category>"mysql"</category>
	<guid isPermaLink="false">http://www.bytemycode.com/snippets/snippet/860/</guid>
	<description>
		<![CDATA[

			<img src="http://www.bytemycode.com/img/icon_calendar.gif" align="middle" class="icon" alt="Date Submitted" /> Thu. Oct. 30th, 2008  1:01 PM			<br />
			<img src="http://www.bytemycode.com/img/icon_revision.gif" align="middle" class="icon" alt="Revision" /> <a href="http://www.bytemycode.com/snippets/snippet/860/revisions/">1</a>
			<br />
			<img src="http://www.bytemycode.com/img/rank_beginner.gif" align="middle" class="icon" alt="Beginner" /> <a href="http://www.bytemycode.com/members/member/nostromo/" title="Beginner">nostromo</a>
			<br />
			<img src="http://www.bytemycode.com/img/icon_tag.gif" align="middle" class="icon" alt="Tags" /> <a href="http://www.bytemycode.com/tags/tag/%22mysql%22">"mysql"</a>			<br />
			<img src="http://www.bytemycode.com/img/icon_comments.gif" align="middle" class="icon" alt="Comments" /> <a href="http://www.bytemycode.com/snippets/snippet/860/comments/">0 comments</a>
			<br />
			<img src="http://www.bytemycode.com/img/icon_ranking.gif" align="middle" class="icon" alt="Ranking" /> 0
			<p>Get only a number of chars from field and concat '...'<br /><br />if long field is empty return nothing<br />if long field is less than number return field<br />else return number of chars in field and '...'</p>
		]]>
	</description>
</item><item>
	<title>PHP/MySQL/LDap authentication</title>
	<link>http://www.bytemycode.com/snippets/snippet/392/</link>
	<comments>http://www.bytemycode.com/snippets/snippet/392/comments/</comments>
	<pubDate>Sun, 24 Sep 2006 17:23:27 +0000</pubDate>
	<dc:creator>kahotep</dc:creator>
	<category>"authentication", "ldap", "mysql", "php"</category>
	<guid isPermaLink="false">http://www.bytemycode.com/snippets/snippet/392/</guid>
	<description>
		<![CDATA[

			<img src="http://www.bytemycode.com/img/icon_calendar.gif" align="middle" class="icon" alt="Date Submitted" /> Sun. Sep. 24th, 2006  5:23 PM			<br />
			<img src="http://www.bytemycode.com/img/icon_revision.gif" align="middle" class="icon" alt="Revision" /> <a href="http://www.bytemycode.com/snippets/snippet/392/revisions/">1</a>
			<br />
			<img src="http://www.bytemycode.com/img/rank_helper.gif" align="middle" class="icon" alt="Helper" /> <a href="http://www.bytemycode.com/members/member/kahotep/" title="Helper">kahotep</a>
			<br />
			<img src="http://www.bytemycode.com/img/icon_tag.gif" align="middle" class="icon" alt="Tags" /> <a href="http://www.bytemycode.com/tags/tag/%22authentication%22">"authentication"</a>&nbsp;|&nbsp;<a href="http://www.bytemycode.com/tags/tag/%22ldap%22">"ldap"</a>&nbsp;|&nbsp;<a href="http://www.bytemycode.com/tags/tag/%22mysql%22">"mysql"</a>&nbsp;|&nbsp;<a href="http://www.bytemycode.com/tags/tag/%22php%22">"php"</a>			<br />
			<img src="http://www.bytemycode.com/img/icon_comments.gif" align="middle" class="icon" alt="Comments" /> <a href="http://www.bytemycode.com/snippets/snippet/392/comments/">1 comments</a>
			<br />
			<img src="http://www.bytemycode.com/img/icon_ranking.gif" align="middle" class="icon" alt="Ranking" /> 6
			<p>The following program was written for my company's time keeping system which utilizes an LDAP database for authentication and a MySQL database for time-keeping, account access control, etc.<br /><br />If a user has >= 5 unsuccessful logins, it locks the account for 5 minutes.  Once a successful LDAP bind has occured, the $_SESSION vars are set and the authorization process is bypassed until the user logs out or the session expires.</p>
		]]>
	</description>
</item>
	</channel>
</rss>