<?php
//My login Script
// declare variables
$username=$_POST["nome"];
$Password=$_POST["passWord"];
//
// mysql connection variables
$host = 'localhost';
$dbuser = 'root';
$dbpass = 'pollo';
$dbname = 'arduino_db';
$table = 'tb_accesso';
//
// connect to db
$db = mysql_connect($host,$dbuser,$dbpass) or die("error=could not connect to $host");
$db = mysql_select_db($dbname);
if(!$db)
{
echo "error=could not connect to $dbname table";
exit;
}
//
// check table
$query = mysql_query("SELECT * FROM $table WHERE nome = \"".$username."\" AND passWord = \"".$Password."\"");
//echo ("SELECT * FROM $table WHERE nome = \"".$username."\" AND passWord = \"".$Password."\"");
$num = mysql_num_rows($query);
//echo ("echo ha dato $num");
if($num>0)
{
    print("&messaggio=ok");
} else {
    print("&messaggio=not ok $Password");
}

mysql_close($db);
?>