PHP/MySQL Dev. Primer (1) Establish Env.

PHP/MySQL Dev. Primer (1) Establish Env. Author: 柳大·Poechant Blog:Blog.CSDN.net/Poechant Email: zhongchao.ustc@gmail.com Date: May 15 th , 2012 1 Install Web Server Usually, people are willing to use Apache as the web server of their si

PHP/MySQL Dev. Primer (1) Establish Env.

• Author: 柳大·Poechant
• Blog: Blog.CSDN.net/Poechant
• Email: zhongchao.ustc@gmail.com
• Date: May 15^th, 2012

1 Install Web Server

Usually, people are willing to use Apache as the web server of their sites. Honstly, I have to say Apache is an excellent web server. However, you also have to concede Nginx is superstar in this realm. Perhaps you have heard Nginx could perform better than Apache for dynamic pages.

Based on the high-performance of Nginx, it is necessary to introduce how to set up Nginx instead of Apache or any other web server software.

<code><span>wget</span> http://nginx.org/download/nginx-<span>1.2</span><span>.0</span>.tar.gz
<span>tar</span> -zxvf nginx-<span>1.2</span><span>.0</span>.tar.gz
<span>cd</span> nginx-<span>1.2</span><span>.0</span>
./configure
<span>make</span>
<span>sudo</span> make install
</code>

Then Nginx has been install into /usr/local/nginx directory. What’s next? Configuration. The following configuration is aimed at a PHP web site.

<code><span>//TODO</span>
</code>

2 Install Database

ignored

3 Install Script Lang. Dev. Env.

ignored

4 Integrated Installation Tools

• MAMP: Mac Apache MySQL PHP. Eh, I’m fond of this one :)

• WAMP: Windows Apache MySQL PHP

• XAMPP: Windows/MacOSX/Linux/Solaris Apache MySQL PHP/Perl/Python

5 Basic Configuration for the Integrated Env.

Apache Document Root or Nginx Location

6 Hello World

6.1 PHP

<code><span>
<span>html</span>></span>
    <span>head</span>>
        <span>meta</span> <span>http-equiv</span>=<span>"Content-Type"</span> <span>content</span>=<span>"text/html; charset=UTF-8"</span>>
        <span>title</span>><span><span>title</span>></span>
    <span><span>head</span>></span>
    <span>body</span>>
        <span><?php $myvar = "Hello World, PHP";
            echo $myvar;
        ?></span>
    <span><span>body</span>></span>
<span><span>html</span>></span>
</code>

6.2 MySQL

<code><span><span>create</span> database testdb;</span>

<span><span>create</span> <span>table</span> example (
    id      <span>int</span>,
    data    <span>varchar</span>(<span>100</span>)
);</span>

<span><span>insert</span> <span>into</span> example <span>values</span> (
    <span>1</span>, <span>'Hello World, MySQL'</span>
);</span>

<span><span>select</span> * <span>from</span> example;</span>
</code>

-

Blog.CSDN.net/Poechant

-