17Jun 2009 by Asim Zeeshan No Comments

Installing / re-installing and Configuring phpMyAdmin on Ubuntu

How to, Linux, OpenSource, PHP, Resources, Tips and Tricks, Tutorials, Ubuntu
phpMyAdmin is a very common and handy tool that most of the developers use. It is available on almost every server. Installing phpMyAdmin on Ubuntu server is even easier, you just need to [sourcecode language="plain"]sudo apt-get install phpmyadmin[/sourcecode] but what if we accidently skip the configuration screen where phpmyadmin makes modifications to apache? Dont worry just do the following Edit Apache's configuration file (assuming you are using apache2) [sourcecode language="plain"]sudo nano /etc/apache2/apache2.conf # better to use the following command instead of the one above #gksudo gedit /etc/apache2/apache2.conf[/sourcecode] Add the following line of code inside apache2.conf: [sourcecode language="plain"]Include /etc/phpmyadmin/apache.conf[/sourcecode] Now restart Apache: [sourcecode language="plain"]sudo /etc/init.d/apache2 restart[/sourcecode] Go to /phpmyadmin/ and login with your mysql username and password.
Read More
26May 2009 by Asim Zeeshan No Comments

How to list Stored Procedures and Functions in MySQL database

How to, Resources, Tips and Tricks, Tutorials
How to check if there are any STORED PROCEDURE in MySQL database? [sourcecode language="sql"]SHOW PROCEDURE STATUS;[/sourcecode] Similarly for MySQL database FUNCTIONS [sourcecode language="sql"]SHOW FUNCTION STATUS;[/sourcecode] But it displays a list of all PROCEDURE and all FUNCTIONS, you can chop down the list by appending [sourcecode language="sql"]## display FUNCTIONS from 'test' db SHOW FUNCTION STATUS WHERE db LIKE ='test';[/sourcecode] Hope it helps somebody. Enjoy!
Read More
14May 2009 by Asim Zeeshan 21 Comments

Creating and Installing crontabs using CodeIgniter

How to, OpenSource, PHP, Resources, Reviews, Tips and Tricks, Tutorials
Last night, I was trying to get a crontab working in CodeIgniter, since my current project (a personal project) is using CodeIgniter now. I didn't wanted to use the conventional approach of running crontabs and my code seperate. Unfortunately, CodeIgniter does not have support for Crontabs and I didn't wanted to user wget in linux crontab to initiate unwanted requests. I spent some time and came up with a solution. It uses CodeIgniter backend Does not modify any core architecture of CodeIgniter Keeps configuration at one place So enough of the summary and let me show you how its done. Create a file (e.g. cron.php) in the same place as your index.php and system folder. Here is its code [php]/** * @author Asim Zeeshan * @web http://www.asim.pk/ * @date 13th…
Read More
07May 2009 by Asim Zeeshan 2 Comments

Template Library for CodeIgniter, Simple, Fast and Easy!

How to, OpenSource, PHP, Resources, Reviews, Tips and Tricks, Tutorials
If you have not noticed, I just got started on CodeIgniter. I was really disappointed today when I noticed the lack of a template system in CodeIngiter to skin my little application. They say The Template Parser Class is not a full-blown template parsing solution. We've kept it very lean on purpose in order to maintain maximum performance. Lucky for me, I got a little help here, the library is great and works well for the latest version of CI too best of all its small and does not modify the CI code in anyway. It just uses the already available code to skin the application. Sleak! I made a couple of modifications in the original library, here are my modifications [php]<?php if ( ! defined('BASEPATH')) exit('No direct script access…
Read More
01May 2009 by Asim Zeeshan 6 Comments

Installing MySQL 5.1 on Ubuntu

How to, Linux, Tips and Tricks, Tutorials, Ubuntu
I wanted to use PARTITIONING introduced in MySQL 5.1 to handle some 2 Million records (and growing everyday) in a table. Ubuntu 8.10 does not have MySQL 5.1 available if you do apt-get the latest version available is 5.0 So this is what I did, its easy and this might help somebody. [sourcecode language="plain"]nano /etc/apt/sources.list[/sourcecode] I prefer nano editor but you can use any editor of your choice. Add these new lines at the end of the end of the file. [sourcecode language="plain"]deb http://ppa.launchpad.net/monty/ubuntu gutsy main universe restricted multiverse deb http://ppa.launchpad.net/smurf/ubuntu gutsy main universe restricted multiverse[/sourcecode] (These packages were targeted for 7.10 so I will recommend using them and removing them from this list once you got the latest MySQL version) Now run the following commands [sourcecode language="plain"]apt-get update apt-get…
Read More
04Mar 2009 by Asim Zeeshan No Comments

Join Vteams (NEXTBRIDGE) Network on Facebook

How to, Linux, Resources, Tips and Tricks, Tutorials
I have recently request FaceBook to add the Vteams (aka NEXTBRIDGE in Lahore, Pakistan) as a network. To join, you must have an active @nxvt.com email account, just go to Setting -> Account, select network tab. In network name box type "Vteams", enter email address and click JOIN. Check your email and click on the confirmation link Congratulation, you have joined the Vteams Network
Read More