Fatal error : Uncaught Error: Call to a member function bind_param() on boolean in

[Andrin.Spitzer]

Hay.

Ich suche seit stunden nach der Lösung jedoch verstehe ich in den anderen Beiträgen die ich finde nicht was man damit sagen will.

der Fehler:

Fatal error: Uncaught Error: Call to a member function bind_param() on boolean in C:\xampp\htdocs\taru\pages\test.php:93 Stack trace: #0 C:\xampp\htdocs\taru\index.php(15): require_once() #1 {main} thrown inC:\xampp\htdocs\taru\pages\test.phpon line93

Mein Code

$db = new mysqli('localhost','root','','protokol');
   
    if($db->connect_error):
        echo 'Verbindung Fehlgeschlagen';
    endif;
   
    if(isset($_POST['submit'])):
        $seriennummer     = $_POST['Serial-number-Text'];
        $object         = $_POST['Object'];
        $user             = $_POST['User'];
        $creator         = $_POST['Creator'];

    $absenden = $db->prepare("INSERT INTO kontrolliert (seriennummer,type,kontrolliert,gebaut) Values(?,?,?,?,NOW())");
    $absenden->bind_param('iiss',$seriennummer,$object,$user,$creator);
   

    $absenden->execute();
       
    endif;

<form action="" method="post">
                <label class="test-function">Kontroliert von:</label>
                <select name="User" onchange="aktualisiere_progressbar()" class="test-function">
                    <option value="" disabled selected hidden>Auswählen</option>
                    <option>Andrin</option>
                    <option>Dario</option>
                    <option>David</option>
                    <option>Martin</option>
                </select><br><br>
                <label class="test-function">Gebaut von:</label>
                <select name="Creator" class="test-function" onchange="aktualisiere_progressbar()">
                    <option value="" disabled selected hidden>Auswählen</option>
                    <option>Andrin</option>
                    <option>Dario</option>
                    <option>David</option>
                    <option>Martin</option>
                </select><br><br>
                <label class="test-function">Produkt:</label>
                <select name="Object" class="test-function" onchange="aktualisiere_progressbar()">
                    <option value="" disabled selected hidden>Auswählen</option>
                    <option>94003</option>
                    <option>58052</option>
                    <option>51315</option>
                    <option>51317</option>
                </select><br>
                <label class="test-function">Serien Nummer</label>
                  <input class="test-function" onchange="aktualisiere_progressbar()" type="number"            name="Serial-number-Text">
                <br>
                <label class="test-function">Sicht Prüfung</label>
                <input class="test-function" onchange="aktualisiere_progressbar()" type="checkbox"         name="visual-inspection">
                <br>
                <label class="test-function">Schrauben</label>
                <input class="test-function" onchange="aktualisiere_progressbar()" type="checkbox"         name="screw">
                <br>
                <label class="test-function">Kabel Verschraubungen</label>
                <input class="test-function" onchange="aktualisiere_progressbar()" type="checkbox"         name="cable-gland">
                <br>
                <label class="test-function">Stecker</label>
                <input class="test-function" onchange="aktualisiere_progressbar()" type="checkbox"         name="plugs">
                <br>
                <label class="test-function">Säckli</label>
                <input class="test-function" onchange="aktualisiere_progressbar()" type="checkbox"         name="bag">
                <br>
                <label class="test-function">Serien Nummer</label>
                <input class="test-function" onchange="aktualisiere_progressbar()" type="checkbox"         name="Serial-Number">
                <br>
                <label class="test-function">Legende</label>
                <input class="test-function" onchange="aktualisiere_progressbar()" type="checkbox"         name="Type-label">
                <br>
                <label class="test-function">Innen</label><input class="test-function" onchange="aktualisiere_progressbar()" type="file"                 name="inside-Img" accept="image/*"/>
                <br>
                <label class="test-function">Deckel Geöffnet</label><input class="test-function"    onchange="aktualisiere_progressbar()" type="file"     name="top-Img" accept="image/*"/>
                <br>
                <label class="test-function">Stecker + Legende</label><input class="test-function"    onchange="aktualisiere_progressbar()" type="file"     name="plug-legend-img" accept="image/*"/>
                <br>
                <label class="test-function">Serien Nummer</label><input class="test-function"    onchange="aktualisiere_progressbar()" type="file"         name="Serial-number-Img" accept="image/*"/>
                <br>
                <label class="test-function">Deckel mit Säckli</label><input class="test-function"    onchange="aktualisiere_progressbar()" type="file"      name="Top-Bag-img" accept="image/*"/>
                <br>
                <progress id="fortschritt" value="0" max="15"></progress>
                <br><br>
                <input type="submit" name="submit" value="Absenden">
            </form>

 

[Andrin.Spitzer]

oof Ganz dummer fehler.

habe eine spalte vergessen:

//alt

$absenden = $db->prepare("INSERT INTO kontrolliert (seriennummer,type,kontrolliert,gebaut) Values(?,?,?,?,NOW())");
    $absenden->bind_param('iiss',$seriennummer,$object,$user,$creator);

//neu

$absenden = $db->prepare("INSERT INTO kontrolliert (seriennummer,type,kontrolliert,gebaut,datum) Values(?,?,?,?,NOW())");
    $absenden->bind_param('iiss',$seriennummer,$object,$user,$creator);