host=`hostname`

LOGFILE1=/tmp/ibm_1_$host.log
LOGFILE2=/tmp/ibm_2_$host.log

if [ -f $LOGFILE1 ]; then
 rm -i $LOGFILE1
fi;

if [ -f $LOGFILE2 ]; then
 rm -i $LOGFILE2
fi;



for FILE in `find . -name "*.php"`
do
# cp $FILE $FILE.tmp
# cat $FILE.tmp | sed -e "s/
//g" > FILE
# rm $FILE.tmp
 t_line=`cat $FILE | wc -l`
 s_line=`cat $FILE | grep -i select | wc -l`
 u_line=`cat $FILE | grep -i update | wc -l`
 i_line=`cat $FILE | grep -i insert | wc -l`
 p_line=`cat $FILE | grep "\[" | wc -l`
 m_line=`cat $FILE | grep mysql | wc -l`
 echo "$host,$FILE,$t_line,$s_line,$u_line,$p_line,$m_line"  | tee -a $LOGFILE1
 echo `cat $FILE | grep mysql | sed -e "s/
//g"` | tee -a $LOGFILE2
done