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
|
<?php
session_start();
if(isset($_POST["debutActivite"], $_POST["finActivite"], $_POST["employeur"], $_POST["activite"], $_POST["salaire"] )) {
$debutActivite = htmlspecialchars( $_POST['debutActivite']) ;
$finActivite = htmlspecialchars( $_POST['finActivite']) ;
$employeur = htmlspecialchars( $_POST['employeur']) ;
$activite = htmlspecialchars( $_POST['activite']) ;
$salaire = htmlspecialchars( $_POST['salaire']) ;
$debutActivite = date('Y/m/d', strtotime($debutActivite));
$finActivite = date('Y/m/d', strtotime($finActivite));
$_SESSION['information'] = $debutActivite;
$conn = mysqli_connect('127.0.0.1', 'root', '', 'philippe');
$query = "SELECT * FROM orders WHERE activite = '".$activite."' AND
debutActivite BETWEEN '".$_POST["debutActivite"]."' AND '".$_POST["finActivite"]."'";
$resultextra = mysqli_query($conn, $query);
if(mysqli_num_rows(mysqli_query($link, $resultatextra))!=0) {echo "faild";} <==> je ne sais pas comment ça fonctionne ça retourne toujourd "faild".
// $req = "INSERT INTO orders VALUES ('','$employeur','$activite','$salaire','$debutActivite','$finActivite',DEFAULT)";
$req = "INSERT INTO orders VALUES ('','$employeur','$activite','$salaire','$debutActivite','$finActivite')";
try {$conn->query($req);} catch (Exception $e) {$e->getMessage();}
echo 'Success';
}
?> |
Partager