Install Nginx, PHP-FPM & MySQL in Centos
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.
- Download this shell script to your VPS
[root@power ~]# wget http://freevps.us/downloads/nginx-centos.sh
- Run that bash script
[root@power ~]# bash nginx-centos.sh
then wait..
- 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!
Insert French Characters Into MySQL
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.
Download Youtube with PHP and CURL
This is an update for my previous Youtube Downloader.
If you don’t know what is PHP Youtube Downloader, it is a simple PHP script that we can use to download video from Youtube.com. You must, at least, having PHP installed and CURL activated.
Download the source at here and read some information at Google Code Page.
Have fun!
