MBED HTTP client with web pages for server

Dependencies:   DS1820

Fork of J_HTTP_Client by Jan Kamidra

ForServer/nucleoin.php

Committer:
JohnnyK
Date:
2018-05-23
Revision:
1:920482bc63f4
Parent:
0:d90e1f7bda1f

File content as of revision 1:920482bc63f4:

<?php
	$server = "sql.someweb.com";	// Here you place your MySQL server address
	$user = "johnybravo";			// Here you place your user name of your MySQL
	$pass = "bravo";				// Here you place your password of your MySQL
	$db = "dtb";					// Here you place your name of your DTB

	$mysql = mysql_connect($server, $user, $pass);  // Connect to MySQL
	mysql_select_db($db);							// Select DTB of MySQL
	
	if(!$mysql)	
	{
		die("Unable connect to server!");
	}

	$doSql = mysql_query('SELECT * FROM nucleo_data WHERE id=1');
	
	if(mysql_num_rows($doSql) == 0){
		mysql_query('INSERT INTO nucleo_data (id, time, date, temp) VALUES (1, '.date("H:i:s",time()).', '.date("Y-m-d",time()).',  0)');
	}
	
	if($mysql and isset($_GET['temp'])){
		$temp = sanitize($_GET['temp']);
		
		$sqll = 'UPDATE nucleo_data SET temp="'.$temp.'", time="'.date("H:i:s",time()).'", date="'.date("Y-m-d",time()).'" WHERE id=1';
		$doSqll = mysql_query($sqll);

		if($doSqll){ 
			echo 'Zapis byl uspesny';
		}
		else{
			die('Invalid query: ' . mysql_error());
		}	
	}
	function sanitize($input){
		$input = htmlspecialchars($input);
		$input = htmlentities($input);
		$input = strip_tags($input);
		$input = trim($input);
		return $input;
	}
?>