Savoir si une requête select ne retourne rien

Version imprimable

Bonjour et merci à tous et à toutes.
Je sèche. Je veux retourner un "faild" ajax si la requette select n'est pas vide.
Hélas je tourne en rond.
Voici le code:

Code:

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';
}
?>

Merci pour votre aide

je fais cela mais ca retourne tout le temps faild

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
$query = "SELECT * FROM orders WHERE activite = '".$activite."' AND
debutActivite BETWEEN '".$_POST["debutActivite"]."' AND '".$_POST["finActivite"]."'";
 
    $link = mysql_connect("localhost", "root", "");
    mysql_select_db("philippe", $link);
 
    $result = mysql_query($query, $link);
    $num_rows = mysql_num_rows($result);
 
    if ($num_rows>0) {echo "faild";}
 
 
    $req = "INSERT INTO orders VALUES ('','$employeur','$activite','$salaire','$debutActivite','$finActivite')";
 
try {$conn->query($req);} catch (Exception $e) {$e->getMessage();}
echo 'Success';

J'ai essayer ca ca donne toujour faild.

Code:

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
 
<?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');
 
 
 
 
 
    $con=mysqli_connect("localhost","root","","philippe");
    // Check connection
    if (mysqli_connect_errno())
    {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
 
    $sql="SELECT * FROM orders WHERE activite = '".$activite."' AND
 debutActivite BETWEEN '".$_POST["debutActivite"]."' AND '".$_POST["finActivite"]."'";
 
    if ($result=mysqli_query($con,$sql))
    {
        // Return the number of rows in result set
        $rowcount=mysqli_num_rows($result);
        printf("Result set has %d rows.\n",$rowcount);
        // Free result set
        mysqli_free_result($result);
    }
 
        $req = "INSERT INTO orders VALUES ('','$employeur','$activite','$salaire','$debutActivite','$finActivite')";
 
    try {$conn->query($req);} catch (Exception $e) {$e->getMessage();}
    echo 'Success';
 
 
    mysqli_close($con);
 
}

J'ai trouver.

Code:

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
38
39
 
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;
 
 
    $query = "SELECT * FROM orders WHERE activite = '".$activite."' AND
debutActivite BETWEEN '".$_POST["debutActivite"]."' AND '".$_POST["finActivite"]."'";
 
    mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "root", "", "philippe");
 
 
 
 
    $result = $mysqli->query($query);
 
    $row_cnt = $result->num_rows;
 
    if ($row_cnt!=0) {echo 'faild';} else {
 
    $req = "INSERT INTO orders VALUES ('','$employeur','$activite','$salaire','$debutActivite','$finActivite')";
    $mysqli->query($req);
//     try {$conn->query($req);} catch (Exception $e) {$e->getMessage();}
 
//     $result = mysql_query($req, $link);
    echo 'Success';}
}