...
$qr_result = mysql_query("select `Id`, `IP`, `State` from `table4`")
or die(mysql_error());
while ($data = mysql_fetch_array($qr_result)) {
//объявляем переменные
$ip=$data['IP'];
if (!preg_match('/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/',$ip)) {echo "Sorry, wrong request"; exit;}//проверка на правильность записи
preg_match('/^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}/',"$ip", $matches);//удаление порта, если есть
$ip2=$matches[0];
...
};[root@billing ~]# ssh radio.lds.net.ua
Last login: Thu Oct 1 12:31:01 2015 from 193.192.36.2
[root@radio ~]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 45
model name : Intel(R) Core(TM) i7-3970X CPU @ 3.50GHz
stepping : 2
cpu MHz : 3502.101
cache size : 15360 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss nx rdtscp lm constant_tsc nonstop_tsc arat pni ssse3 cx16 sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips : 7004.20
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 45
model name : Intel(R) Core(TM) i7-3970X CPU @ 3.50GHz
stepping : 2
cpu MHz : 3502.101
cache size : 15360 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss nx rdtscp lm constant_tsc nonstop_tsc arat pni ssse3 cx16 sse4_1 sse4_2 popcnt lahf_lm [8]
bogomips : 7004.20
[root@radio ~]# free
total used free shared buffers cached
Mem: 1034612 447780 586832 0 146004 250312
-/+ buffers/cache: 51464 983148
Swap: 2097144 0 2097144
[root@radio ~]# w
13:42:48 up 6 days, 5:34, 1 user, load average: 0,00, 0,00, 0,00
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/0 193.192.36.2 13:42 0.00s 0.07s 0.00s w
[root@radio ~]#