Monthly Archives: November 2014

class konversi sederhana PHP

iseng iseng posting buat class  aplikasi konversi satuan dengan menggunakan database mysq dan bahasa pemrograman PHP

pertama kita buat database terserah apa namanya misalnya contoh

dalam database contoh tersebut kita buat table

conversi dengan fold id,dari,ke,nilai

db_concersi

kemudian kita buat class dalam PHP

class konversi
{

function db($nilai,$dari,$ke)
{
$sql = mysql_query(“SELECT count(*) kodisi FROM conversi where dari ='” . $dari .”‘ and ke ='”.$ke.”‘”);
while($r = mysql_fetch_array($sql))
{
$kondisi = $r[kodisi];
}
if ($kondisi==’1′)
{
$sql1 = mysql_query(“SELECT * FROM conversi where dari ='” . $dari .”‘ and ke ='”.$ke.”‘”);
while($r1 = mysql_fetch_array($sql1))
{
$hasil = $nilai * $r1[‘nilai’];

}
}
else
{
$sql = mysql_query(“SELECT count(*) kodisi FROM conversi where ke ='” . $dari .”‘ and dari ='”.$ke.”‘”);
while($r = mysql_fetch_array($sql))
{
$kondisi = $r[kodisi];
}
if ($kondisi==’1′)
{
$sql1 = mysql_query(“SELECT * FROM conversi where ke ='” . $dari .”‘ and dari ='”.$ke.”‘”);
while($r1 = mysql_fetch_array($sql1))
{
$hasil = $nilai / $r1[‘nilai’];

}
}
else
{
$hasil =’Belum ada Di db';
}
}
return $hasil;
}

}

semoga dapat membantu



Setting IPTABLES di kloxo via ssh

Seperti biasa login putty dulu…

Stop iptables service:

/etc/init.d/iptables stop

Disable iptables service:

chkconfig iptables off

Copy this code to /etc/init.d/firewall (Reminder: Disable “word wrap” in your text editor. Ex.: nano -w /etc/init.d/firewall)

#!/bin/sh
# firewall
# chkconfig: 3 21 91
# description: Starts, stops iptables firewall

case "$1" in
start)

# Clear rules
iptables -t filter -F
iptables -t filter -X
echo - Clear rules : [OK]

# SSH In
iptables -t filter -A INPUT -p tcp --dport 22 -j ACCEPT
echo - SSH : [OK]

# Don't break established connections
iptables -A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT
iptables -A OUTPUT -m state --state RELATED,ESTABLISHED -j ACCEPT
echo - established connections : [OK]

# Block all connections by default
iptables -t filter -P INPUT DROP
iptables -t filter -P FORWARD DROP
iptables -t filter -P OUTPUT DROP
echo - Block all connections : [OK]

# SYN-Flood Protection
iptables -N syn-flood
iptables -A syn-flood -m limit --limit 10/second --limit-burst 50 -j RETURN
iptables -A syn-flood -j LOG --log-prefix "SYN FLOOD: "
iptables -A syn-flood -j DROP
echo - SYN-Flood Protection : [OK]

# Loopback
iptables -t filter -A INPUT -i lo -j ACCEPT
iptables -t filter -A OUTPUT -o lo -j ACCEPT
echo - Loopback : [OK]

# ICMP (Ping)
iptables -t filter -A INPUT -p icmp -j ACCEPT
iptables -t filter -A OUTPUT -p icmp -j ACCEPT
echo - PING : [OK]

# DNS In/Out
iptables -t filter -A OUTPUT -p tcp --dport 53 -j ACCEPT
iptables -t filter -A OUTPUT -p udp --dport 53 -j ACCEPT
iptables -t filter -A INPUT -p tcp --dport 53 -j ACCEPT
iptables -t filter -A INPUT -p udp --dport 53 -j ACCEPT
echo - DNS : [OK]

# NTP Out
iptables -t filter -A OUTPUT -p udp --dport 123 -j ACCEPT
echo - NTP : [OK]

# WHOIS Out
iptables -t filter -A OUTPUT -p tcp --dport 43 -j ACCEPT
echo - WHOIS : [OK]

# FTP Out
iptables -t filter -A OUTPUT -p tcp --dport 20:21 -j ACCEPT
iptables -t filter -A OUTPUT -p tcp --dport 30000:50000 -j ACCEPT
# FTP In
iptables -t filter -A INPUT -p tcp --dport 20:21 -j ACCEPT
iptables -t filter -A INPUT -p tcp --dport 30000:50000 -j ACCEPT
iptables -t filter -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
echo - FTP : [OK]

# HTTP + HTTPS Out
iptables -t filter -A OUTPUT -p tcp --dport 80 -j ACCEPT
iptables -t filter -A OUTPUT -p tcp --dport 443 -j ACCEPT
# HTTP + HTTPS In
iptables -t filter -A INPUT -p tcp --dport 80 -j ACCEPT
iptables -t filter -A INPUT -p tcp --dport 443 -j ACCEPT
echo - HTTP/HTTPS : [OK]

# Mail SMTP:25
iptables -t filter -A INPUT -p tcp --dport 25 -j ACCEPT
iptables -t filter -A OUTPUT -p tcp --dport 25 -j ACCEPT
echo - SMTP : [OK]

# Mail POP3:110
iptables -t filter -A INPUT -p tcp --dport 110 -j ACCEPT
iptables -t filter -A OUTPUT -p tcp --dport 110 -j ACCEPT
echo - POP : [OK]

# Mail IMAP:143
iptables -t filter -A INPUT -p tcp --dport 143 -j ACCEPT
iptables -t filter -A OUTPUT -p tcp --dport 143 -j ACCEPT
echo - IMAP : [OK]

# Kloxo
iptables -t filter -A INPUT -p tcp --dport 7777:7778 -j ACCEPT
iptables -t filter -A OUTPUT -p tcp --dport 7777:7778 -j ACCEPT
echo - Kloxo : [OK]

echo - Firewall [OK]
exit 0
;;

stop)
echo "Stopping Firewall... "
iptables -P INPUT ACCEPT
iptables -P OUTPUT ACCEPT
iptables -t filter -F
echo "Firewall Stopped!"
exit 0
;;

restart)
/etc/init.d/firewall stop
/etc/init.d/firewall start
;;

*)
echo "Usage: /etc/init.d/firewall {start|stop|restart}"
exit 1
;;
esac

Jika anda mempunya slave server dan ini adalah server utamanya…

Tulis kode berikut

iptables -t filter -A INPUT -p tcp -s SLAVE_IP –dport 7779 -j ACCEPT
iptables -t filter -A OUTPUT -p tcp -d SLAVE_IP –dport 7779 -j ACCEPT

Note: tulis SLAVE_IP dengan IP Slave server anda.

Tambahkan kode berikut pada slave server

iptables -t filter -A INPUT -p tcp -s MASTER_IP –dport 7779 -j ACCEPT
iptables -t filter -A OUTPUT -p tcp -d MASTER_IP –dport 7779 -j ACCEPT

Note: tulis MASTER_IP dengan IP Master server.

Mudah kan…

sumber : http://gspot-design.blogspot.com/2012/05/setting-iptables-di-kloxo-via-ssh.html