<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.8.4" -->
<rss version="0.92">
<channel>
	<title>Add on for my life</title>
	<link>http://www.eklenti.org</link>
	<description>It is all about my articles.</description>
	<lastBuildDate>Sat, 16 Jan 2010 10:52:35 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Eklenti.org</title>
		<description><![CDATA[Uzun zamandır eklenti.org ile ilgilenemiyordum. Evet artık hayatımdaki köklü değişikliklerden sonra bu sitem ile ilgili daha ayrıntılı ve köklü değişiklikler yapacağım.
Daha önce bir okurun özel mesajında belirttiği gibi bu siteyi tamamen türkçe ve özel paylaşımlar için ve yenilik amaçlı kodlar için kullanacağım. Bu araya kadar takip edenler için teşekkür ederim.
]]></description>
		<link>http://www.eklenti.org/2010/01/eklenti-org/</link>
			</item>
	<item>
		<title>How To Smarty Cache</title>
		<description><![CDATA[Ok. If you use smarty and some part of your web site are no need to uptime any time, we can use the Smarty cache.
But smarty cache is not usefull for big project.  But you can use in very simple let&#8217;s start.
First Prepare script for smarty.
require &#8216;kernel/libs/Smarty.class.php&#8217;; // This is my smarty class.
$smarty = [...]]]></description>
		<link>http://www.eklenti.org/2009/04/how-to-smarty-cache/</link>
			</item>
	<item>
		<title>Zend Cache with Zend Framework (Simple Function)</title>
		<description><![CDATA[Ok. In my new project we have a lot of dymanic part.  This part actually not up-to-date every time. (maybe one or two times in a day).  If we use html for this part , we are so tried to update it. If we use sql all time (daily 2k+ visitor and growing) [...]]]></description>
		<link>http://www.eklenti.org/2009/02/cache-with-zend-framework/</link>
			</item>
	<item>
		<title>We are in Mysql Speed Test (Myisam vs InnoDB)</title>
		<description><![CDATA[Ok. In present day, almost everybody have a web site.  Actually many kind of web site is dynamic.  I change my decision to mysql. (maybe later postgresql or another)
And in starting every kind of database fast and doing their job clearly.  So time is past and past and past and past &#8230;&#8230;&#8230; [...]]]></description>
		<link>http://www.eklenti.org/2009/02/myisam-vs-innodb-speed-test/</link>
			</item>
	<item>
		<title>Sefurl with Zend Framework</title>
		<description><![CDATA[Zend is very powerfull framework. We want to use some kind of big project but we have a problem.
Problem is; url sef link  http://www.example.com/article/2009/06/sef-url-with-zend.html
But we want to: http://www.example.com/sef-url-with-zend.html
Ok; Everybody says &#8220;You can do it with Zend Router&#8221;, but how?
Answer:
You open index.php and  insert
Zend gerçekten çok güçlü frameworktür. Bir çok büyük projede kullanabiliriz. Ama [...]]]></description>
		<link>http://www.eklenti.org/2009/01/sefurl-with-zend-framework/</link>
			</item>
	<item>
		<title>InnoDB vs MyISAM</title>
		<description><![CDATA[On Internet most people use &#8220;MYISAM&#8221; storage engine. This engine is so good for web application. But we have a lot of  alternative.  This article has InnoDb and MyIsam engines.
InnoDB:

Innodb has no Fulltext search. This one is very bad thing  (I think).
Innodb is powerfull. More secure for crash.
Innodb has foreign keys. It [...]]]></description>
		<link>http://www.eklenti.org/2009/01/innodb-vs-myisam/</link>
			</item>
	<item>
		<title>How can add our excel files to mysql</title>
		<description><![CDATA[The scenario;
I have an excel list about our costumers info. So i want to add all excel data in to mysql.
First i must save excel (.csv) format. And open my php script. my php script;
[PHP]
$firstTakeAllData=file_get_contents($filenameofcvs);
$secondAddArray=explode(&#8221;n&#8221;,$firstTakeAllData);
foreach ($secondAddArray as $key=&#62;$takeMyDataFor)
{
$mysqlData=explode(&#8221;;&#8220;,$takeMyDataFor);
mysql_query(&#8217;INSERT into mycostumer (name,surname,street,tel,email) values (&#8221;$mysqlData[0]&#8220;,&#8221;$mysqlData[1]&#8220;,&#8221;$mysqlData[2]&#8220;,&#8221;$mysqlData[3]&#8220;,&#8221;$mysqlData[4]&#8220;)&#8217;); // It&#8217;s good for one user but this a lot of query [...]]]></description>
		<link>http://www.eklenti.org/2008/09/how-can-add-our-excel-files-to-mysql/</link>
			</item>
	<item>
		<title>Create random password in mysql</title>
		<description><![CDATA[The scenario;
I coded my script but i want to change password with mysql. (Maybe want to change a lot row). My password length have 8 character.
[MYSQL]
UPDATE mycostumerdata SET password=SUBSTRING(MD5(ROUND(RAND(9999)*1000)),1,8)
[/MYSQL]
You can add any coloum for better random password.
Web sitesi programlaması yaparken bazen eski veritabanlarımızdan yararlanabiliriz. Bu kayıtlarımıza ait şifreleri yeniden oluşturmak bazen düşündüğümüzden daha zor olabilir. [...]]]></description>
		<link>http://www.eklenti.org/2008/09/create-random-password-in-mysql/</link>
			</item>
	<item>
		<title>How can cyrpto my old coloum</title>
		<description><![CDATA[The scenario;
I have a costumer database. And they are login my simple application. But i want to security to passwords.
[MYSQL]
UPDATE mycostumerdata  SET password=MD5(SHA1(MD5(password)))
[/MYSQL]
If you want more, you add php code md5() or sha() to user id and mysql query add md5(userid). There is no chance to pass in with sql injection
Change it to yourself.
Çoğu [...]]]></description>
		<link>http://www.eklenti.org/2008/09/how-can-cyrpto-my-old-coloum/</link>
			</item>
	<item>
		<title>How can update my record with another record?</title>
		<description><![CDATA[The scenario;
I have a lot of records on my test table. And costumer want to &#8220;Need a order by manualy&#8221;. So i want to update my table and set new order value. The new order value is old id value.
Here is code;
[MYSQL]
UPDATE Mytable SET ordervalue = oldid
[/MYSQL]
Bir Arkadaşım kendisine ait bir veritabanında yeni bir alan [...]]]></description>
		<link>http://www.eklenti.org/2008/09/how-can-update-my-record-with-another-record/</link>
			</item>
</channel>
</rss>
