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

Andrin.Spitzer

Erfahrenes Mitglied
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
Unbenannt.PNG
PHP:
$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;

HTML:
<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>
 
oof Ganz dummer fehler.

habe eine spalte vergessen:

PHP:
//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);
 
Zurück