Sandy's Blog

配置文件路径：/etc/sysconfig/iptables

# Generated by iptables-save v1.4.7 on Fri Apr 20 13:12:14 2018
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [40:6082]
-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT
# Completed on Fri Apr 20 13:12:14 2018

Read more

ssh 到远程ip的指定端口：

ssh -p xx user@ip

xx 为 端口号，user为用户名，ip为要登陆的ip。

通过IP直接访问的话会301跳转到相应域名，.htaccess内容：

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{http_host} ^101.100.102.90 [NC]
RewriteRule ^(.*)$ http://www.domain.com/$1 [R=301,L]
RewriteBase /
</IfModule>

记录一款原生的PHP分页类，分页样式有点类似bootstrap。

Read more

DELETE FROM small_pic WHERE num IN (
SELECT num
FROM (

SELECT num
FROM small_pic
GROUP BY num
HAVING COUNT( * ) >1
)t
)