Currently using:
MySQL
Bash
Apache
Im creating a script wich is intented for my website. It records what your typing
and throws it out on your screen, if it exists.
My humble question is what have i done wrong?
The "else" and "fi" commands are marked red thats Vim's way saying iv done wrong
but i dont know exactly what i have done wrong?
Thanks!
edit: The script still wont do anything, when i search for something nothing happens
Regards / Alexander / Sweden
------------------------------------------------------------------------------------------------------
#!/bin/bash/
TITEL=$(echo $QUERY_STRING | cut -d\& -f1 | cut -d= -f2)
DATUM=$(echo $QUERY_STRING | cut -d\& -f2 | cut -d= -f2)
TEXT=$(echo $QUERY_STRING | cut -d\& -f3 | cut -d= -f2)
KOLL=$(echo "SELECT count(titel) FROM TEXTER WHERE titel='$TEXTER';"| mysql -N -u root TEXTER)
#skriv en HTTP-Header
echo "content-type: text/html"
echo
#Skriv en HTML-Header
echo "<HTML><HEAD><TITLE>Resultat</TITLE></HEAD><BODY>
if [ $KOLL -ne 0 ]; then
echo "<h4 style=\"color: #fff\">Titeln $TITEL finns redan!.</h4>"
else
echo "INSERT INTO TEXTER(titel,datum,text) VALUES ('$TEXTER','$DATUM','$TEXT');"| mysql -u root -N TEXTER
echo "Titeln till texten är tillagd"
fi
echo "SELECT titel FROM TEXTER;" | mysql -N -u root TEXTER > /tmp/sqlsvar
IFS=$'\n'
echo "<P>Dessa Titlar finns i tabellen</P>"
echo "<ul>"
for i in $(cat /tmp/sqlsvar); do
echo "<li>$i</li>"
done
echo "</ul>"
# skriv HTML-slutet
echo "</body></html>
-----------------------------------------------------------------------------------------------------