Archive for the tag 'Php'

Jan 20 2009

Sefurl with Zend Framework

Published by Root under Php, programlama, zend

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
Zend gerçekten çok güçlü frameworktür. Bir çok büyük projede kullanabiliriz. Ama [...]

2 responses so far

Sep 19 2008

How can add our excel files to mysql

Published by Root under Mysql, Php, excel, programlama

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 [...]

No responses yet