{"id":989,"date":"2017-10-02T19:50:37","date_gmt":"2017-10-02T10:50:37","guid":{"rendered":"https:\/\/www.dogrow.net\/linux\/?p=989"},"modified":"2021-09-16T00:23:14","modified_gmt":"2021-09-15T15:23:14","slug":"blog58","status":"publish","type":"post","link":"https:\/\/www.dogrow.net\/linux\/blog58\/","title":{"rendered":"(58)\u3010\u9023\u8f091-2\u3011VirtualBox\u4e0a\u306eUbuntu\u3092WEB\u30b5\u30fc\u30d0\u30fc\u306b"},"content":{"rendered":"

\u9023\u8f09\uff12\u56de\u76ee\u3001\u524d\u56de\u306e \u300c(57)\u3010\u9023\u8f091\u3011CentOS7\u306bVirtualBox\u3092\u5165\u308c\u308b\u300d<\/a> \u306e\u7d9a\u304d\u3067\u3059\u3002<\/p>\n

\u3053\u306e\u9023\u8f09\u3067\u6700\u7d42\u7684\u306b\u3084\u308a\u305f\u3044\u3053\u3068<\/h1>\n

CentOS7\u3092\u5165\u308c\u305f\u7269\u7406\u30b5\u30fc\u30d0\u30fc\u306b VirtualBox\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001
\n\u3000VirtualBox\u306e\u4eee\u60f3\u30de\u30b7\u30f3\u4e0a\u3067 Ubuntu\u306e\u4eee\u60f3\u30b5\u30fc\u30d0\u30fc\u3092\u52d5\u304b\u3057\u3001
\n\u3000\u3000Ubuntu\u306e\u4eee\u60f3\u30b5\u30fc\u30d0\u30fc\u4e0a\u3067 WEB\u30b5\u30fc\u30d0\u30fc\u3092\u52d5\u304b\u3057\u3001
\n\u3000\u3000\u3000eclipse \uff0b xdebug, PhpStorm + xdebug\u3067\u30ea\u30e2\u30fc\u30c8\u30c7\u30d0\u30c3\u30b0\u3057\u305f\u3044\u3002<\/p>\n

\u4eca\u56de\u3084\u308a\u305f\u3044\u3053\u3068<\/h1>\n

CentOS7\u3092\u5165\u308c\u305f\u7269\u7406\u30b5\u30fc\u30d0\u30fc\u306b VirtualBox\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001Ubuntu\u306e\u4eee\u60f3\u30b5\u30fc\u30d0\u30fc\u3092\u52d5\u304b\u3057\u305f\u3002
\n\u4eca\u56de\u306f\u3053\u306e Ubuntu\u3092 WEB\u30b5\u30fc\u30d0\u30fc\u3068\u3057\u3066\u4f7f\u3044\u3001PHP\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u52d5\u304b\u3057\u3066MySQL\u3092\u5236\u5fa1\u3057\u305f\u3044\u3002<\/p>\n

(1) \u5fc5\u8981\u306a\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h1>\n

1) \u5b9a\u756a\u306eHTTP\u30b5\u30fc\u30d0\u30fc\u3067\u3042\u308b Apache2\u3092\u5165\u308c\u308b\u3002<\/p>\n

\r\nsudo apt install apache2\r\n\r\nsudo systemctl enable apache2\r\nsudo systemctl restart apache2\r\nsudo systemctl status apache2\r\n<\/pre>\n
\u524d\u56de\u306e\u6295\u7a3f\u3067 FireWall\u3092\u5c0e\u5165\u3057\u305f\u306e\u3067\u3001Port#80\uff08for http\uff09\u3092\u958b\u3051\u3066\u304a\u304f\u3002<\/p>\n
\r\nsudo ufw allow http\r\nsudo ufw status\r\n<\/pre>\n
2) PHP7.0\u3092\u5165\u308c\u308b\u3002  \u203bapt\u306b7.1\u304c\u306a\u304b\u3063\u305f\u3002<\/span><\/p>\n
\r\nsudo apt install php7.0\r\nsudo apt install php7.0-mysql php7.0-gd php7.0-mbstring php7.0-pear php7.0-common\r\nsudo apt install libapache2-mod-php7.0 php7.0-curl php7.0-mcrypt php7.0-cgi\r\n\r\nsudo a2enconf php7.0-cgi\r\nsudo systemctl reload apache2\r\n<\/pre>\n
3) MySQL\u3092\u5165\u308c\u308b\u3002<\/p>\n
\r\nsudo apt install mysql-server\r\n<\/pre>\n
MySQL\u306f 5.7.19 \u304c\u5165\u3063\u305f\u3002<\/p>\n
\r\nuser@:~$ mysql --version\r\nmysql  Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using  EditLine wrapper\r\n<\/pre>\n
(2) \u3068\u308a\u3042\u3048\u305a\u52d5\u304f\u304b\u898b\u3066\u307f\u308b<\/h1>\n
1. WEB\u30d6\u30e9\u30a6\u30b6\u3067\u30a2\u30af\u30bb\u30b9\u3057\u3066\u307f\u308b\u3002<\/h3>\n
Windows\u30d1\u30bd\u30b3\u30f3\u3067 http:\/\/192.168.1.4 \u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u307f\u308b\u3002
\n\u203b192.168.1.4\u306f\u524d\u56de\u6295\u7a3f\u3067\u5f53\u8a72VM\u306b\u5272\u308a\u5f53\u3066\u305f\u56fa\u5b9aIP\u30a2\u30c9\u30ec\u30b9<\/span>
\n\"\"
\n\u3053\u3053\u307e\u3067\u306f\u3088\u308d\u3057\u3044\u3088\u3046\u3067\u3002<\/p>\n
2. phpinfo\u3092\u898b\u3066\u307f\u308b\u3002<\/h3>\n
phpinfo\u3092\u8868\u793a\u3059\u308b\u3060\u3051\u306e PHP\u30b9\u30af\u30ea\u30d7\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u308a\u3001WEB\u30d6\u30e9\u30a6\u30b6\u3067\u3053\u308c\u3092\u8868\u793a\u3057\u3066\u307f\u308b\u3002<\/p>\n
\r\nvi \/var\/www\/html\/info.php\r\n<\/pre>\n
\r\n<?php\r\n  phpinfo();\r\n?>\r\n<\/pre>\n
Windows\u30d1\u30bd\u30b3\u30f3\u3067 http:\/\/192.168.1.4\/info.php \u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u307f\u308b\u3002
\n\"\"
\n\u3053\u3061\u3089\u3082\u5927\u4e08\u592b\u306a\u3088\u3046\u3067\u3002<\/p>\n
3. PHP\u30b9\u30af\u30ea\u30d7\u30c8\u5185\u3067MySQL DB\u3092\u64cd\u4f5c\u3057\u3066\u307f\u308b\u3002<\/h3>\n
1) \u307e\u305a\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5f8c\u4f55\u3082\u3057\u3066\u3044\u306a\u3044MySQL DB\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n
\u30ed\u30b0\u30a4\u30f3\u3059\u308b\u3002<\/p>\n
\r\nuser@:~$ mysql -uroot -pxxxxx\r\n<\/pre>\n
Test\u3068\u3044\u3046\u540d\u524d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n
\r\ncreate database Test;\r\nuse Test;\r\n<\/pre>\n
Test\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b Ttt\u3068\u3044\u3046\u540d\u524d\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u3002\u30ab\u30e9\u30e0\u306fINT AAA\u3068 TEXT BBB\u306e 2\u500b\u3068\u3059\u308b\u3002<\/p>\n
\r\ncreate table Ttt (`AAA` INT, `BBB` TEXT);\r\n<\/pre>\n
\u30c6\u30fc\u30d6\u30eb\u306b\u30ec\u30b3\u30fc\u30c9\u30921\u500b\u633f\u5165\u3059\u308b\u3002\u5024\u306f AAA=123, BBB=’ABC’<\/p>\n
\r\ninsert into Ttt values('123','ABC');\r\n<\/pre>\n
\u3053\u3093\u306a\u30c6\u30fc\u30d6\u30eb\u304c\u3067\u304d\u305f\u3002<\/p>\n
\r\nmysql> show tables;\r\n+----------------+\r\n| Tables_in_Test |\r\n+----------------+\r\n| Ttt            |\r\n+----------------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql> desc Ttt;\r\n+-------+---------+------+-----+---------+-------+\r\n| Field | Type    | Null | Key | Default | Extra |\r\n+-------+---------+------+-----+---------+-------+\r\n| AAA   | int(11) | YES  |     | NULL    |       |\r\n| BBB   | text    | YES  |     | NULL    |       |\r\n+-------+---------+------+-----+---------+-------+\r\n2 rows in set (0.00 sec)\r\n\r\nmysql> select * from Ttt;\r\n+------+------+\r\n| AAA  | BBB  |\r\n+------+------+\r\n|  123 | ABC  |\r\n+------+------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n
\u3053\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u8aad\u307f\u51fa\u3059PHP\u30b9\u30af\u30ea\u30d7\u30c8 view.php \u3092\u66f8\u304f\u3002<\/p>\n
\r\nvi \/var\/www\/html\/view.php\r\n<\/pre>\n
\r\n<?php\r\n    \/\/ DB\u306b\u63a5\u7d9a\r\n    $cdb = new mysqli('127.0.0.1', 'root', 'xxxxx', 'Test');\r\n\r\n    \/\/ Test\u30c6\u30fc\u30d6\u30eb\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\r\n    $res = $cdb->query('SELECT * FROM `Ttt`;');\r\n\r\n    \/\/ \u53d6\u5f97\u3057\u305f\u30ec\u30b3\u30fc\u30c9\u3092\u8868\u793a\r\n    $row = $res->fetch_assoc();\r\n    var_dump($row);\r\n?>\r\n<\/pre>\n
Windows\u30d1\u30bd\u30b3\u30f3\u3067 http:\/\/192.168.1.4\/view.php \u306b\u30a2\u30af\u30bb\u30b9\u3057\u3066\u307f\u308b\u3002
\n\"\"
\n\u78ba\u304b\u306b\u5024\u304c\u53d6\u5f97\u3067\u304d\u305f\u3002\u3053\u3061\u3089\u3082\u5927\u4e08\u592b\u306a\u3088\u3046\u3060\u3002<\/p>\n
\u2605\u6700\u7d42\u7684\u306b\u3067\u304d\u305f\u3053\u3068<\/h1>\n
\u30fbCentOS7\u7269\u7406\u30b5\u30fc\u30d0\u30fc\u4e0a\u306eUbuntu17\u4eee\u60f3\u30b5\u30fc\u30d0\u30fc\u306bWEB\u30b5\u30fc\u30d0\u30fc\u3092\u8a2d\u7f6e\u3067\u304d\u305f\u3002
\n\u30fb\u3053\u306eWEB\u30b5\u30fc\u30d0\u30fc\u4e0a\u3067\u306f PHP + SQL \u3067WEB\u30a2\u30d7\u30ea\u3092\u4f5c\u6210\u3067\u304d\u308b\u3002<\/p>\n
\u76ee\u7684\u3092\u9054\u6210\u3067\u304d\u305f\u306e\u3067\u3053\u3053\u307e\u3067\u3067OK\u3068\u3059\u308b\u3002<\/p>\n
\n","protected":false},"excerpt":{"rendered":"
\u9023\u8f09\uff12\u56de\u76ee\u3001\u524d\u56de\u306e \u300c(57)\u3010\u9023\u8f091\u3011CentOS7\u306bVirtualBox\u3092\u5165\u308c\u308b\u300d \u306e\u7d9a\u304d\u3067\u3059\u3002 \u3053\u306e\u9023\u8f09\u3067\u6700\u7d42\u7684\u306b\u3084\u308a\u305f\u3044\u3053\u3068 CentOS7\u3092\u5165\u308c\u305f\u7269\u7406\u30b5\u30fc\u30d0\u30fc\u306b VirtualBox\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001 \u3000Vir\u2026 \u7d9a\u304d\u3092\u8aad\u3080 »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[125,80,79],"tags":[],"class_list":["post-989","post","type-post","status-publish","format-standard","hentry","category-db","category-mysql","category-php"],"views":5168,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/posts\/989","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/comments?post=989"}],"version-history":[{"count":45,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/posts\/989\/revisions"}],"predecessor-version":[{"id":1409,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/posts\/989\/revisions\/1409"}],"wp:attachment":[{"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/media?parent=989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/categories?post=989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dogrow.net\/linux\/wp-json\/wp\/v2\/tags?post=989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}