Add on for my life

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’s start.

First Prepare script for smarty.

require ‘kernel/libs/Smarty.class.php’; // This is my smarty class.

$smarty = new Smarty; //

$smarty->caching = true;
$smarty->cache_dir = “mycachedir/” where is cache?

Continue Reading »

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) system to slow. And hero is come  Zend Cache.

Zend Cache is very good for our job. We can use for it some part to cache. And other parts is dynamic.

This is our site (Plan  ) // Ok i know this is table :P. But system is not.

Ok. There is very important.  More user means more sql and more sql means more slow.

And answer is Zend: Here my function for zend cache.

Test on 1.7 framework.

Important PS: In my project (pls look) every work evalute in indexController class. You can write any where you needed.

Insert this code on your code. (i put this code indexController )

Continue Reading »

Tags: cache, framework, sql, zend

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 ……… Database will taked more data and getting slowly.

Ok. This article about myisam and innodb.
Test database 3300 unique data and i copy more and we have 217k data now. (Innodb and Myisam)

Test computer have (My old friend) 512 mb Ram, Centrino 2.0 GHZ (Pentium M). and a lot of process. (in web server we have a lot of process.)

Ok Let’s test. Not: Myisam hasn’t fulltext,index or nothing

First Test: Count to Data. (command base)

InnoDB: 15.14 second. (217536)
Myisam: 0 second (217536)

Second Test: Select * from tables limit 600,30

InnoDB: 0.14 second. (30)
Myisam: 0.06 second (30)

Third Test: Select * from tables order by RAND() limit 5;

InnoDB: 5.28 second. (5)
Myisam: 2.31 second (5)

Fourth Test: Select * from tables where column like “%yo%” limit 5;

InnoDB: 0.05 second. (5)
Myisam: 0.03 second (5)

This is done for now.  Myisam id winner of speed test. For now.

Tags: innodb, myisam, Mysql, speed test

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 “You can do it with Zend Router”, but how?

Answer:
You open index.php and  insert

Continue Reading »

Tags: class, framework, Php, router, zend

On Internet most people use “MYISAM” 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:

1. Innodb has no Fulltext search. This one is very bad thing  (I think).
2. Innodb is powerfull. More secure for crash.
3. Innodb has foreign keys. It ’s very good for programmers. (Maybe in future i write something)

MyISAM:

1. It has full-text search.
2. You can crash.
3. It’s fast. Writing and reading faster than InnoDb.
4. There is no Foreing keys.

Yeap. Most using engine. And most of  script file has using Myisam engine.

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(”n”,$firstTakeAllData);

foreach ($secondAddArray as $key=>$takeMyDataFor)
{
$mysqlData=explode(”;“,$takeMyDataFor);

mysql_query(’INSERT into mycostumer (name,surname,street,tel,email) values (”$mysqlData[0]“,”$mysqlData[1]“,”$mysqlData[2]“,”$mysqlData[3]“,”$mysqlData[4]“)’); // It’s good for one user but this a lot of query , you can do it in one query

}
[/PHP]

This is simple example. You can use any function for your demand.

;

Tags: excel, intermediate, Mysql, Php

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.

Tags: code, Mysql

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.

Tags: cyrpto, md5, Mysql, simple

The scenario;

I have a lot of records on my test table. And costumer want to “Need a order by manualy”. 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]

Tags: code, Mysql, simple, starter

Yeah. It looks simple if there is some unique column, but if not!!!

I search answer on web and i found something.

[MYSQL]

SELECT CONCAT( `firstname` , `lastname` ) as keyac , count( CONCAT( `firstname` , `lastname` ) ) AS numOfRecord FROM users
GROUP BY CONCAT( `firstname` , `lastname` ) HAVING ( COUNT( CONCAT( `firstname` , `lastname` ) ) >1 ) ORDER BY `numOfRecord` DESC;

[/MYSQL]

It looks firstname and lastname.

Tags: code, intermedia, Mysql