"; exit;} //------------------ validate json ------------------ $errjson = json_validate($jstp); if($errjson == 'false') { $json = "[]"; echo $json; mysql_close($con); exit; } //------------------ validate json ------------------ //-------------------------------GET login,passwd FROM json ----------------------------------- $data = json_decode($jstp); mysql_query('set names utf8'); if ($jstp=="") { $json = "[]"; echo $json; mysql_close($con); exit; } $lastchar=substr($jstp, -1); if (!$lastchar=="}") { $json = "[]"; echo $json; mysql_close($con); exit; } //-------------------------------GET FROM SETS ------------------------------------------------ date_default_timezone_set ("Europe/Athens"); $date = date('d/m/Y H:i:s'); mysql_query('set names utf8'); $data = json_decode($jstp); //foreach($data as $item) { // $sCmp=$item->{'cmp'}; // $item=$item->{'itecode'}; // } $sCmp=$data->{'cmp'}; $item=$data->{'itecode'}; //-------------------------------GET FROM SETS ------------------------------------------------ $sql="INSERT DLTAITE (cmp,itecode,DateInsert,json) VALUES ("; $sql=$sql."'".$sCmp."',"; $sql=$sql."'".$item."',"; $sql=$sql."'".$sdate."',"; $sql=$sql."'".$jstp."'"; $sql=$sql.")"; if (!mysql_query($sql)) { $json = "[]"; echo $json; mysql_close($con); exit; } $sql="INSERT AITE (cmp,itecode,DateInsert,json) VALUES ("; $sql=$sql."'".$sCmp."',"; $sql=$sql."'".$item."',"; $sql=$sql."'".$sdate."',"; $sql=$sql."'".$jstp."'"; $sql=$sql.")"; if (!mysql_query($sql)) { $json = "[]"; echo $json; mysql_close($con); exit; } header('Content-Type: application/json'); //echo "true"; $AutoNumber=mysql_insert_id(); echo $AutoNumber ; mysql_close($con); ob_end_flush(); ?>