PHP 5: Recursively move, copy or delete files and folders

Read more

PHP library for parse and retrieve information from XLS files

It’s realy cool library, you don’t need PEAR library, or other’s files. Now you can parse your xls to array. Example of usage: <?php require_once 'reader.php';   $filename="test.xls"; $prod=parseExcel($filename); echo"<pre>"; print_r($prod);   function parseExcel($excel_file_name_with_path) { $data = new Spreadsheet_Excel_Reader(); // Set output Encoding. $data->setOutputEncoding('CP1251'); $data->read($excel_file_name_with_path);   $colname=array('name','price','old_price','in_price','descr','status','sku','pos','stock','in_name','manufacturer','supplier','photo');   for ($i = 1; $i <= $data->sheets[0]['numRows']; ...

Read more

CS-CART: Random banner rotation

Litle hack to rotate many banners in one block. First of all you need to add all your banners at block, and then open this file: /skins/THEME_NAME/customer/addons/banners/blocks/original.tpl

Read more

PHP-based admin tool to manage SQLite databases

phpLiteAdmin is a web-based SQLite database admin tool written in PHP with support for SQLite2 and SQLite3. Following in the spirit of the flat-file system used by SQLite, phpLiteAdmin consists of a single 100KB source file that is dropped into a directory on a server and then visited in a browser. Setup is as simple ...

Read more

Management autoload services in CentOS

To add a service at startup OS CentOS / RHEL you need a chkconfig  serice

Read more

Convert timestamp to date in MYSQL

Read more

Cross browser testing with Saucelabs

It’s really cool service which I found for myself today. It allows to test your website from different browsers, but its main difference from other services is that it allows you to manage browser. It run’s something like virtual machine with browser, that you selected and allows you work with it, like it’s run in ...

Read more

Disable innodb in mysql 5.5.x

if skip-innodb didn’t help you, try to add this into yours my.cnf ignore_builtin_innodb default_storage_engine=MyISAM

Read more

PHP automate creation of images for CSS sprites.

I use imagefilter to create images for CSS sprites on the fly. This is part of my code:

Read more

MySQL error InnoDB: Unable to lock ./ibdata1, error: 11

Mysql error “InnoDB: Unable to lock ./ibdata1, error: 11″ You need to create copies of original files (ibdata1, ib_logfile0, ib_logfile1… – error may be associated with many files, but the solution is the same). mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.bak cp -a /var/lib/mysql/ibdata1.bak /var/lib/mysql/ibdata1

Read more