Shell Programming and Scripting

#!/bin/bash

a="grep -H -R -n "STRING" /usr/local/bin/Production/me.csv"
a2="grep -H -R -n "OID:" /usr/local/bin/Production/me.csv"

# Condition will return true only if there is a file in directory
# Condition Not true, script will do nothing and script ends 
if [ `$a | grep -c "STRING"` -gt 0 ]
then

# Going to copy entire contents after STRING:
grep -oP 'STRING:\K.*' me.csv > fixme.csv

# Command to remove "\\" from SNMP output
# Sed command only works when running hrstoragedesc script
sed 's/\\//g' /usr/local/bin/Production/fixme.csv > sendtodb.csv

fi

# Current date will display
fetcha=$(date +"%Y-%m-%d")

if [ `$a2 | grep -c "OID:"` -gt 0 ]
then

grep -oP 'OID:\K.*' me.csv >> sendtodb.csv

fi

IFS=,
while read hrstoragedescr hrstoragetype
*** do
**** echo "INSERT INTO info (server,hrstoragedescr,hrstoragetype,date) VALUES ('EXCHANGE','$hrstoragedescr','$hrstoragetype','$fetcha');"
* 
done < /usr/local/bin/Production/sendtodb.csv | mysql -u root -p SNMP;

    $handle = fopen($_FILES['filename']['tmp_name'], "r");

    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $import="INSERT into importing(text,number)values('$data[0]','$data[1]')";

        mysql_query($import) or die(mysql_error());
    }

    fclose($handle);