Today I was wondering how can I concatenate multiple rows in a single row. Suppose, I need to get the email addresses of a user table. The “SELECT `email` FROM `usertable`;” will return something like this:
email1
email2
email3
But I needed:
email1, email2, email3
It is very easy to process and make same output using PHP. But I thought there [...]
You are at the archive for the Tutorial category
Mail with attachment from Shell
Today, for a specific need, I had to work with logwatch. After setting up logwatch, I needed to check the logwatch reports. But I can’t wait for it to mail me at next mailing time. But I can generate the report to see on screen by
logwatch –print
But it was too big! So, I redirected the [...]
Earn from your blog!
If you have a quality blog you can often earn good money from it. That means earn money while enjoying to write blog.
By quality blog, i meant that your blog has a good number of readers and it has 3+ or 4+ google pagerank (homepage). There are ample opportunities to earn using your blog.
Rounded corner without image?
If you are a fan of round corner box, I think, you do it using CSS and 4 related corner images matching your background.
See my latest design here at www.projanmo.com. The top menu has rounded corner. But believe me, I did not use even a single image to show the round corner there.
Easy Control Nginx!
Recently I am trying to learn managing nginx web server. Most probably it is going to take the place of Apache or at least seat beside Apache. The main benefit Nginx is claimed to be low memory footprint.
So far I have configured three VPS with nginx (also mysql & php). But every time I felt [...]
Surprise your friends!
Do you want to read mind of your buddy members? Or at least do want to know earlier they are going to type anything for you on the messenger? I believe, you friend will call you magician when you can it ;).
Pidgin is a fantastic Instant Messaging software. Using this software you can simultaneously [...]
Yum groupinstall may save your hours!
Today I have purchased another new VPS to play with nginx web server. After getting the login info, I tried to compile the nginx source. But I found that no development libraries were installed. So I started to install one by one:
yum install gcc
yum install glibc
yum install make
and so on. [Note: these can be run [...]
PHP_SELF is empty!
Last two days, I am playing or learning to play with nginx web server. I have heard some reputation about it and saw some performance chart in the web. I liked it for its, as claimed, extremely low memory footprint for one of my small VPS.
After reading some tutorial in Projanmo Forum, I am successfully [...]
PunBB Warning System
Today I am working on basic PunBB Warning System extension. It is a long expected feature of PunBB and specially a Projanmo Community desire. This extension will work with upcoming PunBB 1.3
In this version admin can define number of warnings an user may get before getting a temporary ban and also number of warnings before [...]
Remote Desktop from Linux
From a few days I was wondering how to use windows remote desktop sharing feature. I am using Linux (Fedora) in my Laptop while run Windows XP in my desktop. My Desktop is my internet gateway as my EDGE modem does not work in Linux. So I use internet in Linux using Window’s Internet Connection [...]
…website is still on the old server
I have updated the DNS but still I am getting the site from old server. Is this your problem?
Cause:
This occurs due to propagation time. When you update the DNS it needs up to 72 hours to populate on internet. All ISP uses DNS caching to cache the DNS query results. So, it needs some time [...]
Setting up Remote MySQL in cPanel
Today my client was facing problem to setup a remote mysql connection. He wanted to connect a database which belongs to another server and domain. Its fairly simple. But most of the tasks remains on the remote server.
Permission denied: .htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable
Do you get the following error message when you try to visit a site/your site?
Forbidden
You don’t have permission to access / on this server.
Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.
Efficient server Migration for Dynamic Website
If you maintain a website,
you may have to change you current hosting server for many reasons. It
may be that, their service is not good or uptime is low or you may
consider to go a server with better facilities or even you may move to
your own VPS/Dedicated server. All of the these requires that you move
your current website to the new server.
About Internet using Mobile Phone
Quite often I see posts about "how to setup internet in mobile phone?" like questions. I have answered the details several times specially in ict_of_bangladesh group. As this is happening quite often, I think its better to write up it here and give everyone this link to follow.
I am user of GP’s EDGE Service. So I only know about GP’s configuration. I will tell about it here now. Will try to add others in future.
Internet Packages:
Now GP offers 3 Internet Package naming P1, P2 and P3.









