smd.iotkit2.ch / Mbed 2 deprecated 2-07-04-Uebung

Important changes to repositories hosted on mbed.com

Mbed hosted mercurial repositories are deprecated and are due to be permanently deleted in July 2026.

To keep a copy of this software download the repository Zip archive or clone locally using Mercurial.

It is also possible to export all your personal repositories from the account settings page.

Dependencies:   EthernetInterface TMP175 mbed-rtos mbed

Fork of HTTP_POST by smd.iotkit2.ch

cgi-bin/restsql.txt@9:dffb514cde17, 2015-06-08 (annotated)

Committer:
stefan1691
Date:
Mon Jun 08 19:09:11 2015 +0000
Revision:
9:dffb514cde17
Child:
10:3a38ba20cb57
REST Beispiel hinzugefuegt

Who changed what in which revision?

UserRevisionLine numberNew contents of line
stefan1691 9:dffb514cde17 1 #!/bin/bash
stefan1691 9:dffb514cde17 2 #
stefan1691 9:dffb514cde17 3 # Mittels HTTP POST in MySQL Schreiben
stefan1691 9:dffb514cde17 4
stefan1691 9:dffb514cde17 5 # HTTP Header fuer Client
stefan1691 9:dffb514cde17 6 echo "Content-type: text/plain"
stefan1691 9:dffb514cde17 7 echo ""
stefan1691 9:dffb514cde17 8
stefan1691 9:dffb514cde17 9 #
stefan1691 9:dffb514cde17 10 ### POST
stefan1691 9:dffb514cde17 11 #
stefan1691 9:dffb514cde17 12 if [ "$REQUEST_METHOD" = "POST" ]
stefan1691 9:dffb514cde17 13 then
stefan1691 9:dffb514cde17 14 # Zerlegt den Querystring in Einzelteile
stefan1691 9:dffb514cde17 15 saveIFS=$IFS
stefan1691 9:dffb514cde17 16 IFS='=&'
stefan1691 9:dffb514cde17 17 parm=(`cat -`)
stefan1691 9:dffb514cde17 18 IFS=$saveIFS
stefan1691 9:dffb514cde17 19
stefan1691 9:dffb514cde17 20 printf "write to SQL Database: "
stefan1691 9:dffb514cde17 21 FIELDS=""
stefan1691 9:dffb514cde17 22 DATA=""
stefan1691 9:dffb514cde17 23 for (( index = 0; index < ${#parm[@]}; index += 2 ))
stefan1691 9:dffb514cde17 24 do
stefan1691 9:dffb514cde17 25 if [ ${index} -gt 0 ]
stefan1691 9:dffb514cde17 26 then
stefan1691 9:dffb514cde17 27 FIELDS=${FIELDS}","
stefan1691 9:dffb514cde17 28 DATA=${DATA}","
stefan1691 9:dffb514cde17 29 fi
stefan1691 9:dffb514cde17 30 FIELDS=${FIELDS}${parm[index]}
stefan1691 9:dffb514cde17 31 DATA=${DATA}${parm[index+1]}
stefan1691 9:dffb514cde17 32 done
stefan1691 9:dffb514cde17 33 SQL="INSERT INTO data( ${FIELDS} ) VALUES( ${DATA} );"
stefan1691 9:dffb514cde17 34 echo $SQL
stefan1691 9:dffb514cde17 35 mysql -uroot -padmin sensoren <<EOF
stefan1691 9:dffb514cde17 36 ${SQL}
stefan1691 9:dffb514cde17 37 EOF
stefan1691 9:dffb514cde17 38
stefan1691 9:dffb514cde17 39 fi