You are at the archive for the Tutorial category


Concat multiple rows!

October 29th

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 [...]

Mail with attachment from Shell

October 19th

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!

October 6th

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?

October 5th

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!

September 27th

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!

September 19th

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!

September 12th

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!

September 10th

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

September 5th

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

September 2nd

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

August 26th

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

July 8th

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

June 5th

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

January 17th

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

December 5th

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.

« Previous Entries

Size

Colors