Hits: 1864 Most of cloud users prefer Rackspace Cloud for its better service and cost effectiveness… All commands are performed as root to install Apache, MySQL, PHP in CentOS 5.5 Server on Rackspace Cloud. Install Apache # sudo yum install httpd mod_ssl Configure ServerName # sudo /etc/init.d/httpd start Remove Error Starting httpd: httpd: Could not reliably [...]
Hits: 854 PHP have rich set of functions to solve real time problems in programming and web development.. thanks to Rasmus Lerdorf eval — Evaluate a string as PHP code A SET datatype can hold any number of strings from a predefined list of strings. The ENUM datatype restricts to a single member of the set [...]
Hits: 145 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 [...]
Hits: 471 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 [...]
Hits: 69 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 [...]
Hits: 61 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` [...]
Hits: 824 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. [...]
