郭進電腦使用筆記

2015年2月5日星期四

Server6_Web

# vi /var/www/html/index.php
<?php
if ($_POST["act"]=="login"){
$db_link=mysql_connect("localhost","root","db123456");
$db_sel=mysql_select_db("kkdb");
$str_sel="SELECT * FROM `tblmen` WHERE `accnt`= '".$_POST["accnt"]."' AND `pwd`='".$_POST["pwd"]."'";

$result=mysql_query($str_sel);
$data_cnt=mysql_num_rows($result);

if ($data_cnt==1){
header("Location:list.php");
}else{
header("Location:index.php");
}

}
?>

<html>
<head></head>
<body>
<h1 align="center">會員登入</h1>
<form action="" method="post" name="formAdd">
<table align="center">
<tr><td>帳號</td><td><input type="text" name="accnt"></td></tr>
<tr><td>密碼</td><td><input type="text" name="pwd"></td></tr>
<tr><td></td><td>
<input type="hidden" value="login" name="act">
<input type="submit" value="登入" name="ok">
</td></tr>
</table>
</form>
</body>
</html>

+++++++++++++++++++++++++++++

# vi /var/www/html/list.php
<?php
$db_link=mysql_connect("localhost","root","db123456");

mysql_query("SET NAMES 'utf8'");

$db_sel=mysql_select_db("kkdb");
$str_sel="select * from tblmen";
$result=mysql_query($str_sel);

?>

<html>
<head></he/ad>
<body>
<h1 align="center">學生系統</h1>
<p align="center"><a href="add.php">新增學生資料</a> <a href="query.php">查詢學生資料</a></p>
<table align="center">
<tr><td>編號</td><td>名字</td><td>帳號</td><td>密碼</td></tr>

<?php
while ($tbl_rows=mysql_fetch_assoc($result)){
echo "<tr>";
echo "<td>".$tbl_rows["mid"]."</td>";
echo "<td>".$tbl_rows["na"]."</td>";
echo "<td>".$tbl_rows["accnt"]."</td>";
echo "<td>".$tbl_rows["pwd"]."</td>";
echo "<td><a href='update.php?mid=".$tbl_rows["mid"]."'>修改</a></td>";
echo "<td><a href='delete.php?mid=".$tbl_rows["mid"]."'>刪除</a></td>";
echo "</tr>";

}
?>

</table>
</body>
</html>

++++++++++++++++++++++++++++++++++++

# vi /var/www/html/add.php

<?php
if ($_POST["act"]=="add"){
$db_link=mysql_connect("localhost","root","db123456");

mysql_query("SET NAMES 'utf8'");

$db_sel=mysql_select_db("kkdb");
$str_insert="INSERT INTO `tblmen`(`mid`, `na`, `accnt`, `pwd`) VALUES ('".$_POST["mid"]."','".$_POST["na"]."','".$_POST["accnt"]."','".$_POST["pwd"]."')";
mysql_query($str_insert);
header("Location:list.php");

}
?>

<html>
<head></head>
<body>
<h1 align="center">新增資料</h1>
<p align="center"><a href="list.php">返回主畫面</a></p>
<form action="" method="post" name="formAdd">
<table align="center">
<tr><td>編號</td><td><input type="text" name="mid"></td></tr>
<tr><td>名字</td><td><input type="text" name="na"></td></tr>
<tr><td>帳號</td><td><input type="text" name="accnt"></td></tr>
<tr><td>密碼</td><td><input type="text" name="pwd"></td></tr>
<tr><td></td><td>
<input type="hidden" value="add" name="act">
<input type="submit" value="新增" name="ok">
<input type="reset" value="清除" name="erase">
</td></tr>
</table>
</form>
</body>
</html>

++++++++++++++++++++++++++

# vi /var/www/html/update.php

<?php
$db_link=mysql_connect("localhost","root","db123456");

mysql_query("SET NAMES 'utf8'");

$db_sel=mysql_select_db("kkdb");

if ($_POST["act"]=="update"){
$str_update="UPDATE `tblmen` SET `na`='".$_POST["na"]."',`accnt`='".$_POST["accnt"]."',`pwd`='".$_POST["pwd"]."' WHERE `mid` ='".$_POST["mid"]."'";

mysql_query($str_update);
header("Location:list.php");

}
$str_sel="SELECT * FROM `tblmen` WHERE `mid`='".$_GET["mid"]."'";
//echo $str_sel;

$result=mysql_query($str_sel);
$tbl_rows=mysql_fetch_assoc($result);
?>

<html>
<head></head>
<body>
<h1 align="center">修改資料</h1>
<p align="center"><a href="list.php">返回主畫面</a></p>
<form action="" method="post" name="formUpdate">
<table align="center">
<tr><td>編號</td><td><input type="text" name="mid" value="<?php echo $tbl_rows["mid"]; ?>" disabled></td></tr>
<tr><td>名字</td><td><input type="text" name="na" value="<?php echo $tbl_rows["na"]; ?>"></td></tr>
<tr><td>帳號</td><td><input type="text" name="accnt" value="<?php echo $tbl_rows["accnt"]; ?>"></td></tr>
<tr><td>密碼</td><td><input type="text" name="pwd" value="<?php echo $tbl_rows["pwd"]; ?>"></td></tr>

<tr><td></td><td>

</td></tr>

</table>

</form>

</body>

</html>

+++++++++++++++++++++++++++++++++

# vi /var/www/html/query.php

<html>
<head></head>
<body>
<h1 align="center">會員查詢</h1>
<p align="center"><a href="list.php">返回主畫面</a></p>
<form action="" method="post" name="formQuery">
<table align="center">
<tr><td>姓名</td><td><input type="text" name="na"></td><td></td><td></td></tr>
<tr><td></td><td>
<input type="hidden" value="query" name="act">
<input type="submit" value="查詢" name="ok">
</td><td></td><td></td></tr>

<tr><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td></tr>
<tr><td></td><td></td><td></td><td></td></tr>

<tr><td>編號</td><td>姓名</td><td>帳號</td><td>密碼</td></tr>

<?php
if ($_POST["act"]=="query"){
$db_link=mysql_connect("localhost","root","db123456");

mysql_query("SET NAMES 'utf8'");

$db_sel=mysql_select_db("kkdb");
$str_sel="SELECT * FROM `tblmen` WHERE `na` LIKE '%".$_POST["na"]."%'";
//echo $str_sel;
$result=mysql_query($str_sel);
$data_cnt=mysql_num_rows($result);

if ($data_cnt!=0){
while ($tbl_rows=mysql_fetch_assoc($result)){
echo "<tr>";
echo "<td>".$tbl_rows["mid"]."</td>";

echo "<td>".$tbl_rows["na"]."</td>";

echo "<td>".$tbl_rows["accnt"]."</td>";

echo "<td>".$tbl_rows["pwd"]."</td>";

echo "</tr>";

}

</table>

</form>

</body>

</html>

++++++++++++++++++++++++++++++++++

# vi /var/www/html/delete.php

<?php

$db_link=mysql_connect("localhost","root","db123456");

$db_sel=mysql_select_db("kkdb");

$str_del="DELETE FROM `tblmen` WHERE `mid`='".$_GET["mid"]."'";

$result=mysql_query($str_del);

<html>

<body>

<h1 align="center">資料刪除完畢！</h1>

<p align="center"><a href="list.php">返回主畫面</a></p>

</body>

</html>

2015年1月27日星期二

Server5_bind

# yum -y install bind bind-chroot
# vi /etc/sysconfig/iptables
.
-A INPUT -m state --state NEW -m tcp -p tcp --dport 53 -j ACCEPT
-A INPUT -m state --state NEW -m udp -p udp --dport 53 -j ACCEPT

# service iptables restart
# service named start
# netstat -tunlp

# dig @127.0.0.1 tw.yahoo.com
.
;; ANSWER SECTION:
.

# vi /etc/named.conf

listen-on port 53 { any; }; //原127.0.0.1

allow-query { any; }; //原localhost

# service named restart

# dig @192.18.2.105 tw.yahoo.com

+++++++++++++++++++++++++++++++++++++++

# vi /etc/named.rfc1912.zones
//只要自己的正解即可
zone "502.kk" IN {
type master;
file "named.502.kk";
allow-update { none; };

};

# vi /var/named/named.502.kk
$TTL 600
@ IN SOA dns.502.kk. guochin369@gmail.com. (0 3H 15M 1W 1D)
@ IN NS dns.502.kk.
dns IN A 192.168.2.105
www IN A 192.168.2.105

# service named restart

# ping www.502.kk

# dig @dns.502.kk tw.yahoo.com

+++++++++++++++++++++++++++++++++++++++

另一測試電腦IP：192.168.2.51 Win7 設定dns：192.168.2.105
cmd
c:\Users\User>ping 192.168.2.105
c:\Users\User>ping dns.502.kk
c:\Users\User>ping www.50.2kk
c:\Users\User>ping tw.yahoo.com

瀏覽器連結tw.yahoo.com

Server4_samba

# yum -y install samba
# useradd kk7 -s /sbin/nologin
# smbpasswd -a kk7
New SMB password:
Retype new SMB password:
Added user kk7.

# service smb start

ps：於win7內
開始-->執行-->\\192.168.2.105

2015年1月26日星期一

Server3_php_MySql

# yum -y install php
# rpm -qa | grep php
php-common-5.3.3-40.el6_6.i686
php-cli-5.3.3-40.el6_6.i686

php-5.3.3-40.el6_6.i686

# vi /etc/php.ini
.
register_globals = On
# service httpd restart

# vi /var/www/html/test.php
<?php
phpinfo();
php?>

+++++++++++++++++++++++++++++++++++++++++

# yum -y install mysql mysql-server
# rpm -qa | grep mysql
mysql-libs-5.1.73-3.el6_5.i686
mysql-5.1.73-3.el6_5.i686
mysql-server-5.1.73-3.el6_5.i686

# service mysqld start
# service mysqld status

# mysqladmin -u root password dd123 //設定root登入mysql密碼
# mysql -u root -p //帳號root登入mysql
Enter password:
mysql> show databases;
mysql> quit

# mysqladmin -u root -p password db123456 //變更root密碼
Enter password: //原密碼

~~~~~~~~~~~~變更MySQL預設編碼以免影響中文呈現
步驟1：
php程式中，資料開啟時加上
mysql_query("SET NAMES 'utf8'");

步驟2：似乎不需
# cp /etc/my.cnf /etc/my.cnf.bk
# cp /usr/share/doc/mysql-server-5.1.73/my-large.cnf /etc/my.cnf
# vi /etc/my.cnf
.
[client]
.
default-character-set=utf8
.
[mysqld]
.
default-character-set=utf8

init_connect='SET NAMES utf8'

# service mysqld restart

# mysql -u root -p

Enter password:

mysql> show variables like '%character%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.00 sec)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+++++++++++++++++++++++++++++++++++++++++

# yum -y install php-mysql php-mbstring
# rpm -qa | grep php
php-common-5.3.3-40.el6_6.i686
php-mbstring-5.3.3-40.el6_6.i686
php-cli-5.3.3-40.el6_6.i686
php-mysql-5.3.3-40.el6_6.i686
php-5.3.3-40.el6_6.i686

php-pdo-5.3.3-40.el6_6.i686

wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/4.0.10.8/phpMyAdmin-4.0.10.8-all-languages.tar.gz
# tar -zxvf phpMyAdmin-4.0.10.8-all-languages.tar.gz
# cp -r phpMyAdmin-4.0.10.8-all-languages /var/www/html/phpMyAdmin //-r複製目錄
# cd /var/www/html/phpMyAdmin/
# cp config.sample.inc.php config.inc.php

# vi config.inc.php
.
$cfg['Servers'][$i]['auth_type'] = 'http'; //原cookie改成http

# service mysqld restart
# service httpd restart

瀏覽器
http://192.168.2.105/phpMyAdmin
root
db123456
登入

++++++++++++++++++++++++++++++++++++++++++

phpMyAdmin
資料庫
建立資料庫：kkdb 編碼排序：utf8_unicode_ci -->建立

建立資料表：tblmen 欄數：4 -->執行

mid varchar 10 utf8_unicode_ci 索引：primary
na varchar 20 utf8_unicode_ci
accnt varchar 10 utf8_unicode_ci
pwd varchar 10 utf8_unicode_ci

編碼與排序： utf8_unicode_ci -->儲存

~~~~~~~~~~~~~由phpMyAdmin匯入文字資料
原始資料由EXCEL另存新檔-->存檔類型：文字檔(Tab字元分隔)-->按<是> -->再開啟所得文字檔，另存新檔-->存檔類型：UTF-8。
進入phpMyAdmin-->匯入-->選擇檔案-->首列跳過的列數：1(因EXCEL原始資料有標題列)-->格式：CSV-->格式選項：欄位分隔符號：\t (表示Tab字元分隔)-->執行。

2015年1月25日星期日

Server2_http

# yum -y install httpd
# rpm -qa | grep httpd
httpd-tools-2.2.15-39.el6.centos.i686

httpd-2.2.15-39.el6.centos.i686

# vi /etc/sysconfig/iptable
.
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
# service iptables restart
# service httpd start

# ps aux | grep httpd //或netstat -tunlp
# chkconfig httpd on //即setup或ntsysv

# vi /etc/httpd/conf/httpd.conf
.
.
DirectoryIndex index.html index.html.var index.php
.

ServerName www.502.kk:80

KeepAlive On

#service httpd restart

++++++++++++++++++

# vi /etc/httpd/conf/httpd.conf
<IfModule mod_userdir.c>
.
# UserDir disabled
.
UserDir public_html

</IfModule>
.
.
Alias /webkk7 /home/kk7/public_html
.
# service httpd restart
# chmod 711 /home/kk7
# vi /home/kk7/index.html

瀏覽器：
http://192.168.2.105/~kk7

http://192.168.2.105/webkk7
(Alias /webkk7 /home/kk7/public_html)

+++++++++++++++++++++++++

# mkdir /webs
# chmod 711 /webs
# cd /webs
# vi index.html
.
this is from /webs

# vi /etc/httpd/conf/httpd.conf

Alias /w3 /webs

# service httpd restart

瀏覽器：
http://192.168.2.105/w3/

Server1_vsftp

#vi /etc/selinux/config

SELINUX=disabled //預設enforcing,後重新開機

++++++++++++++++++++++++++++++++++

#rpm -qa | grep vsftpd

#yum -y install vsftpd

#service vsftpd start

#netstat -tunlp | grep vsftpd

# vi /etc/sysconfig/iptables

-A INPUT -m state --state NEW -m tcp -p tcp --dport 21 -j ACCEPT

# service iptables restart

# vi /etc/vsftpd/vsftpd.conf

.加入

pasv_enable=no

anonymous_enable=NO

chroot_local_user=YES

# service vsftpd restart

#yum -y remove vsftpd

++++++++++++++++++++++++++++++

使用者權限群組相關

#adduser kk1
#passwd kk1
New password:....
#su kk1
$logout //登出回到root

+++++++++++++++++++++++++++++++++++++++

#groupadd sales //新增群組sales
#cat /etc/group
#adduser -g sales kk2 //新增帳號kk2且加入sales群組
#passwd kk2
#cat /etc/passwd //查看帳號資料或 #id kk2

+++++++++++++++++++++++++++++++++++++++

#cp install.log install.log.kk
#ls -l install.log.kk
#chown kk2:sales install.log.kk //變更檔案install.log.kk擁有者及群組
#ls -l install.log.kk

#chmod ugo+x install.log.kk //檔案增加u,g,o 權限r,w,x(4,2,1)

# chmod -R +w /home/kk2 //資料夾變更權限

+++++++++++++++++++++++++++++++++++++++

#gzip install.log.kk //壓縮為install.log.kk.gz

#gunzip install.log.kk.gz

#tar -cvf Myinstall.log.tar install.log.kk install.log.mm

//打包成Myinstall.log.tar

//-c產生新的包裹檔 -v看指令進度

//-f指定包裹檔名稱 -x將包裹檔解開

#tar -xvf Myinstall.log.tar

#tar -czvf Myinstall.log.tar.gz install.log.kk install.log.mm

//先打包再壓縮 *.tar + *.gz =*.tar.gz

#tar -xzvf Myinstall.log.tar.gz //先解壓縮再解開包裹檔

訂閱：文章 (Atom)

內容選單標籤

2015年2月5日 星期四

2015年1月27日 星期二

2015年1月26日 星期一

2015年1月25日 星期日

+++++++++++++++++++++++++++++++++++++++

#gzip install.log.kk //壓縮為install.log.kk.gz

#gunzip install.log.kk.gz

2015年2月5日星期四

2015年1月27日星期二

2015年1月26日星期一

2015年1月25日星期日