• Hello friends,

    I did a form with html and js, and through a plugin i coded in php, i’d like to insert the result of this form into my wordpress database. But i run into multiples problems. One was that wordpress would told me he couldnt find one column that actually existed, and now that i removed that column from my data just to see, wordpress tell me the insertion was sucessfull. However, my table is empty. Nothing is added into it.

    This is my php code that is supposed to insert it

    // Créer un tableau vide pour stocker les réponses nettoyées
        $reponse = array();
        
        // Parcourir le tableau $_POST et nettoyer chaque valeur
        foreach ($_POST as $key => $value) {
            if (!empty($value)) {
                $reponse[$key] = sanitize_text_field($value);
            }
        }
    
        // Insérer les données en utilisant $wpdb->insert
        $result = $wpdb->insert($table_name, $reponse);
    
    
    // Vérifier le résultat
    if ($result === false) {
      echo "Erreur lors de l'insertion des données : " . $wpdb->last_error;
    } else {
        echo "L'insertion des données a réussi";
    }
    print_r($wpdb->queries);
    
    
    $result = $wpdb->insert($table_name, $data);
    
    }

    When i print_r my queries, i can see multiple submissions i did to the form. I even don’t know how it is possible. I see 25 differents submissions that was done on differents days. How can it keep so much of the informations if there are not even kept anywhere in the database ? For example :

     [16] => stdClass Object
            (
                [id] => 17
                [Nom] => Test
                [Prenom] => Test
                [Adresse] => Test
                [Code-Postale] => Test
                [Naissance] => 2000-01-01
                [Telephone] => Test
                [Mail] => [email protected]
                [Probleme-de-sante] => 
                [handicap] => Test
                [RQTH] => 
                [Autre-aide] => 
            )

    And when i try to insert something into my database through direct mysql in my phpmyadmin, it works ! So how is it possible ? It’s not a problem of the database since it work. But for some reason there is something preventing my data to be inserted.
    Ofc i already checked the code is connected to the right database and right table, i did an echo to check it.
    If you could help me, i would trully appreciate it.

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    There are many places things can go awry between your form and the DB. The out of context snippet you provided is not enough information for anyone to speculate about what is going wrong. I suggest you post somewhere outside of these forums your form’s HTML, its JS, and the complete PHP which handles the form submission. Enough information that someone could test your code themselves if they were so inclined. A couple possible places to post are pastebin.com and gist.github.com.

    With access to complete information, hopefully someone will be able to spot where the problem is.

Viewing 1 replies (of 1 total)
  • The topic ‘Can’t insert into my database’ is closed to new replies.