sandalian.com

Update PHP on Virtualmin

March 3, 2012 | Technical Stuffs | centos, PHP, upgrade php, virtualmin

I’m using Virtualmin to manage some servers (both physical or VPS) and I’m pretty confidence to say that this is the best freeware for server control panel.

Virtualmin currently provide PHP 5.1 (I’m using CentOS 5.5) and here’s how to upgrade its PHP version to 5.2. This command will activate Bleeding Edge Packages for CentOS/RHEL 5 on Virtualmin:

[root@server01 ~]# rpm -ivh http://software.virtualmin.com/bleed/centos/5/i386/virtualmin-bleed-release-1.0-1.rhel.noarch.rpm

After that, simply run following command to update PHP:

[root@server01 ~]# yum update php

And just answer “yes” when your system ask. Update process will just take a few seconds to complete.

No comment

Install Nginx, PHP-FPM & MySQL in Centos

April 21, 2011 | Technical Stuffs | centos, install nginx, nginx, PHP, php-vpm, vps

After reading a tutorial of how to install Nginx, PHP and MySQL in a difficult way, now I would like to tell ya how to install them in a very easy way.

I found this method was very effective and completed just within few minutes in my Centos VPS.

1. Download  this shell script to your VPS

   [root@power ~]# wget http://freevps.us/downloads/nginx-centos.sh

2. Run that bash script

   [root@power ~]# bash nginx-centos.sh

   then wait..

3. Voila! Nginx, PHP-FPM and MySQL are installed at glance!

Not only that, this shell script also installed a tool to create virtual host in Nginx named setup-vhost.

When I made virtual host for this blog, I just need to run this command:

[root@power ~]# setup-vhost sandalian.com

Then I uploaded all my files at /var/www/sandalian.com and configure database connection etc.

Thanks to you guys at freevps.us, installing this stack never been easier than this!

8 comments

Insert French Characters Into MySQL

June 4, 2010 | PHP | french characters, mysql, mysql french, non english, PHP

I was developing a bi-lingual website, so my custom CMS should be able to accept and display both English and non English characters. For English characters, it’s a piece of cake. But for French characters, I have pulling my hair for days to find out what went wrong with my script.

I have set the database to use UTF-8 encoding, but every time I inserted the text it’s messed up. French characters become a horror, unreadable for everyone.

After several days –literally– I have found the solution: I must set the character set into UTF-8 right before I insert the data!

< ?php
mysql_query("SET CHARACTER SET utf8"); //<--the key!
mysql_query("insert into data values ('$french_chars')");
?>

SET CHARACTER SET utf8 will tell MySQL to store the inserted data using UTF-8 encoding. And it works for me.

6 comments