Programovani

 
Nastaveni:
C:\dev\prog\EasyPHP-DevServer-14.1VC11\modules\phpmyadmin414x140330211351
 
Změna limitu:
C:\dev\prog\php5
 
max_execution_time = 60
max_input_time = 90 
memory_limit = 128M
upload_max_filesize = 200M
post_max_size = 180M
 
http://www.fit.vutbr.cz/study/courses/IW1/public/info/lib/exe/fetch.php?media=iw4:iw4-zakladni-prehled-sql-prikazu.pdf
SELECT * FROM `maillog` WHERE _auth = 'email'
SUM(mails)
 
http://www.tvorba-webu.cz/php/mysql.php
 
SELECT SUM(size) FROM `maillog` WHERE _auth = 'kurzy@xxxx' UNION SELECT SUM(mails) FROM `maillog` WHERE _auth ='kurzy@xxxx'
 
SELECT * FROM `maillog` GROUP  BY _from ORDER  BY Count(*) DESC LIMIT  1
 
SELECT CONCAT('Od:',_from) AS 'spojeni' FROM `maillog` WHERE _to IN('xxxxx','xxxx')