1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
$id_action =$_POST['Id_Action'];
$id_utilisateur =$_POST['Id_utilisateur'];
$type_action =$_POST['Type_action'];
$id_contact =$_POST['Id_Contact'];
$date_action =$_POST['Date_Action'];
$year = substr($date_action, 0, 4);
$year = intval($year);
$month = substr($date_action, 5, 2);
$month = intval($month);
$day = substr($date_action, 8, 2);
$day = intval($day);
$hours = substr($date_action, 11, 2);
$hours = intval($hours);
$minutes = substr($date_action, 14, 2);
$minutes = intval($minutes);
$seconds = substr($date_action, 17, 2);
$seconds = intval($seconds);
$msec = substr($date_action, 20, 3);
$msec = intval($msec);
$commentaire_action=$_POST['Commentaire_Action'];
//connection à la base de données
include('../connection_bd.php');
//construction de la requette
$sql = "UPDATE [BDD_TOOL_V2].[dbo].[ACTIONS]
SET
[ID_TYPE_ACTION] ='".$type_action."',
[DATEACTION] = '".$year."'+'-'+'".$month."'+'-'+'".$day."'+' '+'".$hours."'+':'+'".$minutes."'+':'+'".$seconds."'+'.'+'".$msec."',
[COMMENTAIREACTION] ='".$commentaire_action."'
WHERE ACTIONS.[ID_ACTION] ='".$id_action."'";
//execution de la requette
odbc_do($connexion, $sql) or die(odbc_error()); |
Partager