顯示具有 php 標籤的文章。 顯示所有文章
顯示具有 php 標籤的文章。 顯示所有文章

2014年5月25日 星期日

[Gantt Chart] Use jQuery PHP Gantt Planner to plan your schedule


[Gantt Chart] Use jQuery PHP Gantt Planner to plan your schedule



1. Download jQuery-Php-Gantt.zip to your server.



2. Unzip jQuery-Php-Gantt.zip



3.  Login your web server

http://XXXXXX.biz/gantt/gantt.html



Have two account can login.



Account    : project1

Password : mypassword



Account    : project2

Password : mypassword2



Reference :



2014年4月11日 星期五

2014年3月16日 星期日

[PHP] Solve scrambled code display in web when read from database


[PHP] Solve scrambled code display in web when read from database



四個編碼設定



我自己的經驗就是確認下述四個地方的編碼設定都是UTF8:




  1. mySQL資料表:用phpmyadmin建立資料表時,注意選擇utf8_unicode_ci的編碼 (通常在最下面)


  2. 在PHP內寫資料庫存取語法時,在mysql_select_db之前,加上 mysql_query(“SET NAMES ‘UTF8′");


  3. 顯示讀出資料庫結果的網頁,也要確認是否有加上


  4. 用編輯器開啟網頁編輯的編碼,若不是UTF8,會造成網頁內靜態中文字亂碼,因此請轉換為UTF8



Reference :



2011年12月8日 星期四

[Ubuntu] Installing Lighttpd With PHP5 And MySQL

1 Preliminary Note

In this tutorial I use the hostname server1.example.com with the IP address 192.168.0.100. These settings might differ for you, so you have to replace them where appropriate.

2 Installing MySQL 5.0

First we install MySQL 5.0 like this:

apt-get install mysql-server mysql-client

Create a password for the MySQL user root (replace yourrootsqlpassword with the password you want to use):

mysqladmin -u root password yourrootsqlpassword

Then check with

netstat -tap | grep mysql

on which addresses MySQL is listening. If the output looks like this:

tcp        0      0 localhost.localdo:mysql *:*                     LISTEN     2713/mysqld

which means MySQL is listening on localhost.localdomain only, then you're safe with the password you set before. But if the output looks like this:

tcp        0      0 *:mysql *:*                     LISTEN     2713/mysqld

you should set a MySQL password for your hostname, too, because otherwise anybody can access your database and modify data:

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

3 Installing Lighttpd

Lighttpd is available as a Debian package, therefore we can install it like this:

apt-get install lighttpd

Now direct your browser to http://192.168.0.100, and you should see the Lighttpd placeholder page:



Lighttpd's default document root is /var/www on Debian, and the configuration file is /etc/lighttpd/lighttpd.conf.

4 Installing PHP5

We can make PHP5 work in Lighttpd through FastCGI. Fortunately, Debian provides a FastCGI-enabled PHP5 package which we install like this:

apt-get install php5-cgi

5 Configuring Lighttpd And PHP5

To enable PHP5 in Lighttpd, we must modify two files, /etc/php5/cgi/php.ini and /etc/lighttpd/lighttpd.conf. First we open /etc/php5/cgi/php.ini and add the line cgi.fix_pathinfo = 1 right at the end of the file:

vi /etc/php5/cgi/php.ini


    [...]
cgi.fix_pathinfo = 1


Then we open /etc/lighttpd/lighttpd.conf and add "mod_fastcgi", to the server.modules stanza:

vi /etc/lighttpd/lighttpd.conf




    [...]
server.modules              = (
            "mod_access",
            "mod_alias",
            "mod_accesslog",
            "mod_fastcgi",
#           "mod_rewrite",
#           "mod_redirect",
#           "mod_status",
#           "mod_evhost",
#           "mod_compress",
#           "mod_usertrack",
#           "mod_rrdtool",
#           "mod_webdav",
#           "mod_expire",
#           "mod_flv_streaming",
#           "mod_evasive"
 )
[...]



and then right at the end of the file, we add the following stanza:


    [...]
fastcgi.server = ( ".php" => ((
                     "bin-path" => "/usr/bin/php5-cgi",
                     "socket" => "/tmp/php.socket"
                 )))


Then we restart Lighttpd:

/etc/init.d/lighttpd restart
Reference :

  • Installing Lighttpd With PHP5 And MySQL Support On Debian Etch