湖濱散記部落格的樹心幽徑[<a href=login.php>login</a>][<a href= . >主頁</a>]<hr>
447:20181217在Ubuntu1604-Linux裝apache2 web server 和 php 7，並設計m1.php資料庫連線查詢程式<br><table width=800 border=8><tr><td bgcolor=cyan><p>(1) treehrt@treehrt-BM6AE-BM1AE-BP1AE:~$<span style="background-color: #ffff99;"> sudo apt-get install apache2</span><br />:</p>
<p>下列的額外套件將被安裝：<br />&nbsp; apache2-bin apache2-data apache2-utils libaprutil1-dbd-sqlite3<br />&nbsp; libaprutil1-ldap<br />建議套件：<br />&nbsp; apache2-doc apache2-suexec-pristine | apache2-suexec-custom<br />下列【新】套件將會被安裝：<br />&nbsp; apache2 apache2-bin apache2-data apache2-utils libaprutil1-dbd-sqlite3<br />&nbsp; libaprutil1-ldap<br />升級 0 個，新安裝 6 個，移除 0 個，有 455 個未被升級。<br />需要下載 1,342 kB 的套件檔。<br />此操作完成之後，會多佔用 5,346 kB 的磁碟空間。<br />是否繼續進行 [Y/n]？ [Y/n] y<br />:</p>
<p>取得 1,342 kB 用了 7秒 (189 kB/s)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br />選取了原先未選的套件 libaprutil1-dbd-sqlite3:i386。<br />（讀取資料庫 ... 目前共安裝了 317470 個檔案和目錄。）<br />準備解開 .../libaprutil1-dbd-sqlite3_1.5.4-1build1_i386.deb ...<br />解開 libaprutil1-dbd-sqlite3:i386 (1.5.4-1build1) 中...<br />選取了原先未選的套件 libaprutil1-ldap:i386。<br />準備解開 .../libaprutil1-ldap_1.5.4-1build1_i386.deb ...<br />解開 libaprutil1-ldap:i386 (1.5.4-1build1) 中...<br />選取了原先未選的套件 apache2-bin。<br />準備解開 .../apache2-bin_2.4.18-2ubuntu3.9_i386.deb ...<br />解開 apache2-bin (2.4.18-2ubuntu3.9) 中...<br />選取了原先未選的套件 apache2-utils。<br />準備解開 .../apache2-utils_2.4.18-2ubuntu3.9_i386.deb ...<br />解開 apache2-utils (2.4.18-2ubuntu3.9) 中...<br />選取了原先未選的套件 apache2-data。<br />準備解開 .../apache2-data_2.4.18-2ubuntu3.9_all.deb ...<br />解開 apache2-data (2.4.18-2ubuntu3.9) 中...<br />選取了原先未選的套件 apache2。<br />準備解開 .../apache2_2.4.18-2ubuntu3.9_i386.deb ...<br />解開 apache2 (2.4.18-2ubuntu3.9) 中...<br />Processing triggers for man-db (2.7.5-1) ...<br />Processing triggers for systemd (229-4ubuntu21.2) ...<br />Processing triggers for ureadahead (0.100.0-19) ...<br />ureadahead will be reprofiled on next reboot<br />Processing triggers for ufw (0.35-0ubuntu2) ...<br />設定 libaprutil1-dbd-sqlite3:i386 (1.5.4-1build1) ...<br />設定 libaprutil1-ldap:i386 (1.5.4-1build1) ...<br />設定 apache2-bin (2.4.18-2ubuntu3.9) ...<br />設定 apache2-utils (2.4.18-2ubuntu3.9) ...<br />設定 apache2-data (2.4.18-2ubuntu3.9) ...<br />設定 apache2 (2.4.18-2ubuntu3.9) ...<br />Enabling module mpm_event.<br />Enabling module authz_core.<br />Enabling module authz_host.<br />Enabling module authn_core.<br />Enabling module auth_basic.<br />Enabling module access_compat.<br />Enabling module authn_file.<br />Enabling module authz_user.<br />Enabling module alias.<br />Enabling module dir.<br />Enabling module autoindex.<br />Enabling module env.<br />Enabling module mime.<br />Enabling module negotiation.<br />Enabling module setenvif.<br />Enabling module filter.<br />Enabling module deflate.<br />Enabling module status.<br />Enabling conf charset.<br />Enabling conf localized-error-pages.<br />Enabling conf other-vhosts-access-log.<br />Enabling conf security.<br />Enabling conf serve-cgi-bin.<br />Enabling site 000-default.<br />Processing triggers for systemd (229-4ubuntu21.2) ...<br />Processing triggers for ureadahead (0.100.0-19) ...<br />Processing triggers for ufw (0.35-0ubuntu2) ...</p>
<p>&nbsp;</p>
<p>(2)</p>
<p>$ sudo systemctl start apache2</p>
<p>$ sudo systemctl enable apache2<br />apache2.service is not a native service, redirecting to systemd-sysv-install<br />Executing /lib/systemd/systemd-sysv-install enable apache2</p>
<p>(3)</p>
<p>$ sudo systemctl status apache2<br />● apache2.service - LSB: Apache2 web server<br />&nbsp;&nbsp; Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)<br />&nbsp; Drop-In: /lib/systemd/system/apache2.service.d<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; └─apache2-systemd.conf<br />&nbsp;&nbsp; Active: active (running) since 一 2018-12-17 20:19:15 CST; 2min 38s ago<br />&nbsp;&nbsp;&nbsp;&nbsp; Docs: man:systemd-sysv-generator(8)<br />&nbsp;&nbsp; CGroup: /system.slice/apache2.service<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ├─4771 /usr/sbin/apache2 -k start<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ├─4774 /usr/sbin/apache2 -k start<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; └─4775 /usr/sbin/apache2 -k start<br /><br />12月 17 20:19:14 treehrt-BM6AE-BM1AE-BP1AE systemd[1]: Starting LSB: Apache2 web server...<br />12月 17 20:19:14 treehrt-BM6AE-BM1AE-BP1AE apache2[4741]:&nbsp; * Starting Apache httpd web server apache2<br />12月 17 20:19:14 treehrt-BM6AE-BM1AE-BP1AE apache2[4741]: AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally <br />12月 17 20:19:15 treehrt-BM6AE-BM1AE-BP1AE apache2[4741]:&nbsp; *<br />12月 17 20:19:15 treehrt-BM6AE-BM1AE-BP1AE systemd[1]: Started LSB: Apache2 web server.<br />12月 17 20:20:43 treehrt-BM6AE-BM1AE-BP1AE systemd[1]: Started LSB: Apache2 web server.</p>
<p>(4) http://localhost/ 成功看到預設網頁</p>
<div class="page_header floating_element"><img class="floating_element" src="http://localhost/icons/ubuntu-logo.png" alt="Ubuntu Logo" /> <span class="floating_element"> Apache2 Ubuntu Default Page </span></div>
<div class="page_header floating_element"><span class="floating_element">(5)</span></div>
<div class="page_header floating_element"><span class="floating_element">treehrt@treehrt-BM6AE-BM1AE-BP1AE:~$<span style="background-color: #ffff99;"> sudo apt-get install php libapache2-mod-php php-mcrypt php-mysql</span><br />:</span></div>
<div class="page_header floating_element"><span class="floating_element">下列的額外套件將被安裝：<br />&nbsp; libapache2-mod-php7.0 libmcrypt4 php-common php7.0 php7.0-cli php7.0-common<br />&nbsp; php7.0-json php7.0-mcrypt php7.0-mysql php7.0-opcache php7.0-readline<br />建議套件：<br />&nbsp; php-pear libmcrypt-dev mcrypt<br />下列【新】套件將會被安裝：<br />&nbsp; libapache2-mod-php libapache2-mod-php7.0 libmcrypt4 php php-common<br />&nbsp; php-mcrypt php-mysql php7.0 php7.0-cli php7.0-common php7.0-json<br />&nbsp; php7.0-mcrypt php7.0-mysql php7.0-opcache php7.0-readline<br />升級 0 個，新安裝 15 個，移除 0 個，有 455 個未被升級。<br />需要下載 3,819 kB 的套件檔。<br />此操作完成之後，會多佔用 14.0 MB 的磁碟空間。<br />是否繼續進行 [Y/n]？ [Y/n] y</span></div>
<div class="page_header floating_element"><span class="floating_element">:</span></div>
<div class="page_header floating_element"><span class="floating_element">設定 php-common (1:35ubuntu6.1) ...<br />設定 php7.0-common (7.0.32-0ubuntu0.16.04.1) ...<br /><br />Creating config file /etc/php/7.0/mods-available/calendar.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/ctype.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/exif.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/fileinfo.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/ftp.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/gettext.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/iconv.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/pdo.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/phar.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/posix.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/shmop.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/sockets.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/sysvmsg.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/sysvsem.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/sysvshm.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/tokenizer.ini with new version<br />設定 php7.0-json (7.0.32-0ubuntu0.16.04.1) ...<br /><br />Creating config file /etc/php/7.0/mods-available/json.ini with new version<br />設定 php7.0-opcache (7.0.32-0ubuntu0.16.04.1) ...<br /><br />Creating config file /etc/php/7.0/mods-available/opcache.ini with new version<br />設定 php7.0-readline (7.0.32-0ubuntu0.16.04.1) ...<br /><br />Creating config file /etc/php/7.0/mods-available/readline.ini with new version<br />設定 php7.0-cli (7.0.32-0ubuntu0.16.04.1) ...<br />update-alternatives: using /usr/bin/php7.0 to provide /usr/bin/php (php) in auto mode<br />update-alternatives: using /usr/bin/phar7.0 to provide /usr/bin/phar (phar) in auto mode<br />update-alternatives: using /usr/bin/phar.phar7.0 to provide /usr/bin/phar.phar (phar.phar) in auto mode<br /><br />Creating config file /etc/php/7.0/cli/php.ini with new version<br />設定 libapache2-mod-php7.0 (7.0.32-0ubuntu0.16.04.1) ...<br /><br />Creating config file /etc/php/7.0/apache2/php.ini with new version<br />Module mpm_event disabled.<br />Enabling module mpm_prefork.<br />apache2_switch_mpm Switch to prefork<br />apache2_invoke: Enable module php7.0<br />設定 libapache2-mod-php (1:7.0+35ubuntu6.1) ...<br />設定 libmcrypt4 (2.5.8-3.3) ...<br />設定 php7.0 (7.0.32-0ubuntu0.16.04.1) ...<br />設定 php (1:7.0+35ubuntu6.1) ...<br />設定 php7.0-mcrypt (7.0.32-0ubuntu0.16.04.1) ...<br /><br />Creating config file /etc/php/7.0/mods-available/mcrypt.ini with new version<br />設定 php-mcrypt (1:7.0+35ubuntu6.1) ...<br />設定 php7.0-mysql (7.0.32-0ubuntu0.16.04.1) ...<br /><br />Creating config file /etc/php/7.0/mods-available/mysqlnd.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/mysqli.ini with new version<br /><br />Creating config file /etc/php/7.0/mods-available/pdo_mysql.ini with new version<br />設定 php-mysql (1:7.0+35ubuntu6.1) ...<br />Processing triggers for libc-bin (2.23-0ubuntu10) ...<br />Processing triggers for libapache2-mod-php7.0 (7.0.32-0ubuntu0.16.04.1) ...<br /></span></div>
<div class="page_header floating_element"><span class="floating_element"><br /></span></div>
<div class="page_header floating_element"><span class="floating_element">(6)</span></div>
<div class="page_header floating_element"><span class="floating_element">$ sudo vi /etc/apache2/mods-enabled/dir.conf<br /></span></div>
<div class="page_header floating_element"><span class="floating_element">$ cat /etc/apache2/mods-enabled/dir.conf<br />&lt;IfModule mod_dir.c&gt;<br />&nbsp;&nbsp;&nbsp; DirectoryIndex index.php index.html index.cgi index.pl index.xhtml index.htm<br />&lt;/IfModule&gt;<br /><br /># vim: syntax=apache ts=4 sw=4 sts=4 sr noet</span></div>
<div class="page_header floating_element"><span class="floating_element">(7)$ sudo systemctl restart apache2</span></div>
<div class="page_header floating_element"><span class="floating_element">(8)$ sudo systemctl status apache2<br />● apache2.service - LSB: Apache2 web server<br />&nbsp;&nbsp; Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)<br />&nbsp; Drop-In: /lib/systemd/system/apache2.service.d<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; └─apache2-systemd.conf<br />&nbsp;&nbsp; Active: active (running) since 一 2018-12-17 20:38:12 CST; 18s ago<br />&nbsp;&nbsp;&nbsp;&nbsp; Docs: man:systemd-sysv-generator(8)<br />&nbsp; Process: 12791 ExecStop=/etc/init.d/apache2 stop (code=exited, status=0/SUCCES<br />&nbsp; Process: 12817 ExecStart=/etc/init.d/apache2 start (code=exited, status=0/SUCC<br />&nbsp;&nbsp; CGroup: /system.slice/apache2.service<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ├─12835 /usr/sbin/apache2 -k start<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ├─12838 /usr/sbin/apache2 -k start<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ├─12839 /usr/sbin/apache2 -k start<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ├─12840 /usr/sbin/apache2 -k start<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ├─12841 /usr/sbin/apache2 -k start<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; └─12842 /usr/sbin/apache2 -k start<br /><br />12月 17 20:38:11 treehrt-BM6AE-BM1AE-BP1AE systemd[1]: Starting LSB: Apache2 web<br />12月 17 20:38:11 treehrt-BM6AE-BM1AE-BP1AE apache2[12817]:&nbsp; * Starting Apache ht<br />12月 17 20:38:11 treehrt-BM6AE-BM1AE-BP1AE apache2[12817]: AH00558: apache2: Cou<br />12月 17 20:38:12 treehrt-BM6AE-BM1AE-BP1AE apache2[12817]:&nbsp; *<br />12月 17 20:38:12 treehrt-BM6AE-BM1AE-BP1AE systemd[1]: Started LSB: Apache2 web <br />lines 1-21/21 (END)</span></div>
<div class="page_header floating_element"><span class="floating_element">(7) http://localhost/index.php</span></div>
<div class="page_header floating_element"><span class="floating_element">成功的看到</span></div>
<div class="page_header floating_element"><span class="floating_element">
<h1 class="p">PHP Version 7.0.32-0ubuntu0.16.04.1</h1>
<p>(8)設計mysql連線程式如下：</p>
<p>/var/www/html$ cat m1.php<br /><span style="background-color: #ffff99;">&lt;?php</span><br /><span style="background-color: #ffff99;">$con = @mysqli_connect('localhost', 'treehrt', 'abc123abc123', 'ilvssell');</span><br /><span style="background-color: #ffff99;">if (!$con) {</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp;&nbsp; echo "Error: " . mysqli_connect_error();</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp;&nbsp; exit();</span><br /><span style="background-color: #ffff99;">}</span><br /><span style="background-color: #ffff99;">echo 'Connected to MySQL OK!&lt;hr&gt;';</span><br /><span style="background-color: #ffff99;">mysqli_query($con, "set names utf8");</span><br /><span style="background-color: #ffff99;">$sql &nbsp;&nbsp;&nbsp; = 'SELECT cardid,uname,cid4 FROM new_cust';</span><br /><span style="background-color: #ffff99;">$query &nbsp;&nbsp;&nbsp; = mysqli_query($con, $sql);</span><br /><span style="background-color: #ffff99;">$c=0;</span><br /><span style="background-color: #ffff99;">while ($row = mysqli_fetch_array($query))</span><br /><span style="background-color: #ffff99;">{</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp;&nbsp; echo $c . ":" . $row['cardid'] . ":" . $row['uname'] . ":" . $row['cid4'] . "&lt;br&gt;";</span><br /><span style="background-color: #ffff99;">&nbsp;&nbsp;&nbsp; $c+=1;</span><br /><span style="background-color: #ffff99;">}</span><br /><span style="background-color: #ffff99;">mysqli_close ($con);</span><br /><br /><span style="background-color: #ffff99;">?&gt;</span></p>
<p>(9) http://localhost/m1.php 程式執行結果如下：</p>
<p><span style="background-color: #ffff99;">Connected to MySQL OK! </span></p>
</span>
<hr />
</div>
<div class="page_header floating_element"><span style="background-color: #ffff99;"> 0:201801:小新:xxxx</span><br /><span style="background-color: #ffff99;">:</span></div>
<div class="page_header floating_element"><span style="background-color: #ffff99;">19:712003:王一志:B301</span><br /><span style="background-color: #ffff99;">:</span></div>
<div class="page_header floating_element"><span style="background-color: #ffff99;">30:c922006:蛇:xxxx</span></div>
<div class="page_header floating_element"></div></table><br> select id,article_id,topic,text from lt_articles_text where article_id =447; ok.
update lt_articles set num_reads=num_reads +1 where id=447; ok.