Upload Large Database Table to Server

Hello Friends, Sometime we want to upload large database table to server but phpMyAdmin have limit to upload SQL large *.sql files.. When we create database table “svnlabs” from mysql admin server make 3 files “svnlabs.frm”, “svnlabs.MYD” and “svnlabs.MYI” These files are located at “/var/lib/mysql/svnlabs”.. we can check this location by phpinfo.php We can upload … Read more

Installing XAMPP in Linux

What is XAMPP ? XAMPP is an easy to install Apache distribution containing MySQL, PHP and Perl. LAMPP (XAMPP for Linux) is very easy to install and to use – just download, extract and start. Download XAMPP http://sourceforge.net/projects/xampp/files/XAMPP Linux/ Installing XAMPP in Linux Download XAMPP Latest version from the following link http://sourceforge.net/projects/xampp/files/XAMPP Linux Currently latest … Read more

Better Solution for Filtering Bad Words in PHP

I was searching for filtering Bad Words from my site…… I have visited so many links on google but…. 🙁 Here is my simple logic for filtering Bad Words from site or any search engine First you have to make a txt file “badwords.txt” or you can search from google Google Keyword: badwords + filetype:txt … Read more

Mysql useful queries

Age: Select DATE_FORMAT (NOW(), ‘%Y’) – DATE_FORMAT(BirthDate, ‘%Y’) – (DATE_FORMAT(NOW(), ’00-%m-%d’) < DATE_FORMAT(BirthDate, ’00-%m-%d’)) AS Age From tbl_member where 1; Change collation: Alter table `tbl_student` convert to character set utf8 collate utf8_swedish_ci; Shift mysql column: ALTER TABLE tableName MODIFY column column_2 int AFTER column_1; Get video info with user info: SELECT `video_id` , `video_title` , … Read more

Lab Tips

Database: 1. Delete all information from databse related to, if deleting user or any content from CMS. 2. Use PDO, ADO, Pear, Zend etc. library to connect to database. 3. Take regular backup for database. 4. Use better naming convension. Folders: 1. Use better naming convension. 2. Take regular backup for folders. 3. Protect project’s … Read more