[idée / en cours] Pointeuse ?

<?php
if(isset($_GET['object']))
{
  $object = $_GET['object'];
 }
else

if(isset($_GET['city']))
{
  $city = $_GET['city'];
 }


$jma = date("Y-m-d");
$heur = date("H:i:s");


$db = mysql_connect('XXXX', 'login', 'pwd');
mysql_select_db('nomdb',$db);

$sql = "INSERT INTO test (date, heure, objet, ville)
VALUES('$jma','$heur','$object','$city')";
mysql_query($sql)
or die('Erreur SQL !'.$sql.'
'.mysql_error());


?>

$tps1 = mysql_query("SELECT objet FROM test");

while ($resp = mysql_fetch_array($tps1));
{
echo $resp['objet'];
echo "<br />";
}

$tps1 = mysql_query("SELECT heure FROM test WHERE date = '2009-01-10'");

$resp = mysql_fetch_array($tps1);

$h0=strtotime($resp[0]);
$h1=strtotime($resp[1]);
echo $h0;
echo "<br />";
echo $h1;
echo "<br />";
echo date('H:i',$h1-$h0);

$tps1 = mysql_query("SELECT heure FROM test WHERE date = '2009-01-10'");
$i=0;
while ($resp = mysql_fetch_array($tps1)){
   $tableau[$i] = $resp[0];
$i++;
}

<?php

if (isset($object))
{
    $connection = mysql_connect("sql.free.fr","login","mdp");
    mysql_select_db("bdd") or die ("pas de connection");
 
      $req = "SELECT idpointage FROM pointages WHERE utilisateur='$object' AND dh_pointage_fin = '0000-00-00 00:00:00' ORDER BY idpointage DESC limit 1";
      $res = mysql_query($req) or die(mysql_error());
   
      if (mysql_num_rows($res) > 0)
      {
        $donnees = mysql_fetch_assoc($res);

        // UPDATE
        $req = "UPDATE pointages SET dh_pointage_fin = NOW() WHERE idpointage = ".$donnees['idpointage'];
        $res = mysql_query($req) or die(mysql_error());
        $txtpointage = "fin+du+travail.";
      }
      else
      {
        $req = "INSERT INTO pointages VALUES(0,'$object',NOW(),0)";
        $res = mysql_query($req) or die(mysql_error());
        $txtpointage = "debut+du+travail.";
      }
   
  //on referme la base de données
  mysql_close();



// message nabaztag
// parametres
$mac_adresse = "????????????"; //l'adresse mac de son nabaztag
$token = "??????????"; //le token de son nabaztag
$voice = "FR-Archibald";
$txt = $object.",+".$txtpointage.".";

//message pour nabaztag
$api_url = "http://api.nabaztag.com/vl/FR/api.jsp?sn=".$mac_adresse."&token=".$token."&voice=".$voice."&tts=".$txt."&ttlive=0";
global $api_url; //on récupère l'url de l'api
$content = @file_get_contents("$api_url"); //On charge l'adresse web


  }
  else
    echo 'pas de numero de serie';

?>