I've got a return 0 and i dont know why

Question

I've got a problem in my PHP code whith an SQL statement.

I want to get back the ID of my Indice where my name = 'myname'. Here is my code :

<?php
include 'Connection.php';

try { 
    $db = new PDO("$server:host=$host;dbname=$base", $user, $passwd); 


    //Statement = INSERT INTO indice
    $stmtInd = $db->prepare("INSERT INTO indice(ID, Name, IDFormation)
        VALUES (:ID, :Name, :IDFormation)");
        $stmtInd->bindParam(':ID', $id);
        $stmtInd->bindParam(':Name', $name);
        $stmtInd->bindParam(':IDFormation', $idformation);
    //Statement = INSERT INTO note
    $stmtNote = $db->prepare("INSERT INTO note(ID, Valeur, Valeurtext, IDIndice)
        VALUES (:ID, :Valeur, :Valeurtext, :IDIndice)");
        $stmtNote->bindParam(':ID', $ID);
        $stmtNote->bindParam(':Valeur', $valeur);
        $stmtNote->bindParam(':Valeurtext', $valeurtext);
        $stmtNote->bindParam(':IDIndice', $IDindice);
    $noteIdindice = $db->prepare("SELECT ID FROM indice WHERE Name = :Name");
        $noteIdindice->bindParam(':Name', $name);
        $noteIdindice->execute();           
        $resultat = $noteIdindice->fetch(\PDO::FETCH_ASSOC);    
        var_dump($resultat);

    //Indice 1
    $name = "Equilibre theorie / pratique";
    $idformation = "1";
    $stmtInd->execute();

    $valeur = $_POST["indice1"];
    $valeurtext = "";
    $IDindice = $resultat['ID'];
    $stmtNote->execute();
    echo "Success";
} 
catch (PDOException $e) { 
    die("Impossible de se connecter a la source de donnees..."); 
}
?>

There is other Indice but you dont need it cuz its the same as "//Indice 1".

Everything works and i have no failure. But my query give me a wrong return. It returns me "0" instead of the ID i want.

Do you guys know why ?

I dont print the result i just use fetch() to put the result in my variable $resultat — Fefil, Apr 14 '17 at 07:44
How do you know the $resultat variable = 0 if you don't print it ? — Thomas Rollet, Apr 14 '17 at 07:47
can you add details of your $stmtNote. Describe the query please. — Mrunmay Deswandikar, Apr 14 '17 at 07:49

Thomas Rollet · Answer 1 · 2017-04-14T09:20:52.780

Your prepared statement is never executed, you should add execute :

$noteIdindice = $db->prepare("SELECT ID FROM indice WHERE Name = :Name");
$noteIdindice->bindParam(':Name', $name);
$noteIdindice->execute();//Add this row
$resultat = $noteIdindice->fetch();

EDIT :

You are trying to binding params with null values.

        $stmtInd = $db->prepare("INSERT INTO indice(ID, Name, IDFormation)
        VALUES (:ID, :Name, :IDFormation)");
        $stmtInd->bindParam(':ID', $id);
        $stmtInd->bindParam(':Name', $name); //$name variable not exists
        $stmtInd->bindParam(':IDFormation', $idformation);//$idformation variable not exists

Try to do this :

<?php
include 'Connection.php';

try { 
    $db = new PDO("$server:host=$host;dbname=$base", $user, $passwd); 
    //Indice 1
    $name = "Equilibre theorie / pratique";
    $idformation = "1";
    $valeur = $_POST["indice1"];
    $valeurtext = "";
    //Statement = INSERT INTO indice
    $stmtInd = $db->prepare("INSERT INTO indice(ID, Name, IDFormation)
        VALUES (:ID, :Name, :IDFormation)");
        $stmtInd->bindParam(':ID', $id);
        $stmtInd->bindParam(':Name', $name);
        $stmtInd->bindParam(':IDFormation', $idformation);
        $stmtInd->execute();
    //Statement = INSERT INTO note
    $stmtNote = $db->prepare("INSERT INTO note(ID, Valeur, Valeurtext, IDIndice)
        VALUES (:ID, :Valeur, :Valeurtext, :IDIndice)");
        $stmtNote->bindParam(':ID', $ID);
        $stmtNote->bindParam(':Valeur', $valeur);
        $stmtNote->bindParam(':Valeurtext', $valeurtext);
        $stmtNote->bindParam(':IDIndice', $IDindice);
        $stmtNote->execute(); 
    $noteIdindice = $db->prepare("SELECT ID FROM indice WHERE Name = :Name");
        $noteIdindice->bindParam(':Name', $name);
        $noteIdindice->execute();           
        $resultat = $noteIdindice->fetch(\PDO::FETCH_ASSOC);    
        var_dump($resultat);

    $IDindice = $resultat['ID'];

    echo "Success";
} 
catch (PDOException $e) { 
    die("Impossible de se connecter a la source de donnees..."); 
}
?>

After : `$resultat = $noteIdindice->fetch();` put `var_dump($resultat)` — Thomas Rollet, Apr 14 '17 at 08:17
i got this : C:\wamp64\www\Test\Insertion.php:55:boolean false — Fefil, Apr 14 '17 at 08:20
Look at this post : http://stackoverflow.com/questions/10145259/ensure-that-pdo-fetch-method-result-false-is-a-error-or-empty-result — Thomas Rollet, Apr 14 '17 at 08:22
Okay. Even if i dont understand why it works perfectly thx man ! only it wont work for each indice that i want to insert. — Fefil, Apr 14 '17 at 09:28
its not completly solve but im looking for a better way to do what i want — Fefil, Apr 14 '17 at 09:36

I've got a return 0 and i dont know why

1 Answers1