SpecialBoernie
Grünschnabel
Schönen guten Tag
ich habe ein Formular erstellt wo die Antworten auf meiner Datenbank gespeichert werden sollen ohne jegliche Überprüfung. Jedoch kriege ich die Fehlermeldung Fatal error: Call to a member function bind_param() on boolean in /users/virtualeasyjet/www/interface/newflight.php on line 14. Ich würde mich über über Aufklärung meines Fehlers wenn sogar Korrigierung sehr freuen. Hier ist der Code reinkopiert. Vielen Dank
<?php
$db = new mysqli('localhost','virtualeasyjet_users','Flida123','virtualeasyjet_users');
if($db->connect_error):
echo $db->connect_error;
endif;
if(isset($_POST['submit'])):
$pilotname = $_POST['name'];
$aircraft = $_POST['aircraft'];
$depairport = $_POST['depairport'];
$arrairport = $_POST['arrairport'];
$passengers = $_POST['passengers'];
$flightnumber = $_POST['flightnumber'];
$insert = $db->prepare("INSERT INTO flights (name,aircraft,depairport,arrairport,flightnumber) VALUES (?,?)");
$insert->bind_param('ss',$pilotname,$aircraft,$depairport,$arrairport,$passengers,$flightnumber);
$insert->execute();
header("Location: interface.html");
endif;
?>
<!DOCTYPE html>
<html>
<head>
<title>Virtual EasyJet | New Flight</title>
<meta charset="utf-8">
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body>
<header>
<div>
<img id="logo" src="../images/logos/logo.jpg">
<nav>
<ul>
<li><a class="navbar" href="../index.html">Home</a></li>
<li><a class="navbar" href="../pilots.html">Pilots</a></li>
<li><a class="navbar" href="../partnerships.html">Partnerships</a></li>
<li><a class="navbar" href="../contact.html">Contact</a></li>
<li><a style="border:solid 1px #55acee;border-radius:5px;color:white;background-color:#55acee;box-shadow: 0px 5px 0px 0px #3C93D5;" class="navbar" href="../login/anmelden.php">Login</a></li>
</ul>
</nav>
</div>
</header>
<div id="form">
<br><h1 class="ueberschrift">Register a new flight</h1>
<form action="" method="POST">
<br />
<div class="answers">
<input type="text" name="name" placeholder="Pilotname" required><br />
</div>
<div class="answers">
<input type="text" name="aircraft" placeholder="Aircraft" required><br />
</div>
<div class="answers">
<input type="text" name="depairport" placeholder="Departure airport" required><br />
</div>
<div class="answers">
<input type="text" name="arrairport" placeholder="Arrival airport" required><br />
</div>
<div class="answers">
<input type="text" name="passengers" placeholder="Passengers" required><br />
</div>
<div class="answers">
<input type="text" name="flightnumber" placeholder="Flightnumber" required><br />
</div>
<div class="answers">
<input name="submit" class="partnerbutton" type="submit" value="New Flight">
</div>
</form>
</div>
<footer>
<p id="copyright">
© 2019 Pascal
</p>
<hr class="hr"/>
<div id="socialmedia">
<a href="t"><img class="socialmedia" src="../images/logos/instagram.png"></a>
<a href="f"><img class="socialmedia" src="../images/logos/youtube.png"></a>
<a href="#"><img class="socialmedia" src="../images/logos/twitter.png"></a>
</div>
<img id="footerlogo" src="../images/logos/logo.jpg">
</footer>
</body>
</html>
ich habe ein Formular erstellt wo die Antworten auf meiner Datenbank gespeichert werden sollen ohne jegliche Überprüfung. Jedoch kriege ich die Fehlermeldung Fatal error: Call to a member function bind_param() on boolean in /users/virtualeasyjet/www/interface/newflight.php on line 14. Ich würde mich über über Aufklärung meines Fehlers wenn sogar Korrigierung sehr freuen. Hier ist der Code reinkopiert. Vielen Dank
<?php
$db = new mysqli('localhost','virtualeasyjet_users','Flida123','virtualeasyjet_users');
if($db->connect_error):
echo $db->connect_error;
endif;
if(isset($_POST['submit'])):
$pilotname = $_POST['name'];
$aircraft = $_POST['aircraft'];
$depairport = $_POST['depairport'];
$arrairport = $_POST['arrairport'];
$passengers = $_POST['passengers'];
$flightnumber = $_POST['flightnumber'];
$insert = $db->prepare("INSERT INTO flights (name,aircraft,depairport,arrairport,flightnumber) VALUES (?,?)");
$insert->bind_param('ss',$pilotname,$aircraft,$depairport,$arrairport,$passengers,$flightnumber);
$insert->execute();
header("Location: interface.html");
endif;
?>
<!DOCTYPE html>
<html>
<head>
<title>Virtual EasyJet | New Flight</title>
<meta charset="utf-8">
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body>
<header>
<div>
<img id="logo" src="../images/logos/logo.jpg">
<nav>
<ul>
<li><a class="navbar" href="../index.html">Home</a></li>
<li><a class="navbar" href="../pilots.html">Pilots</a></li>
<li><a class="navbar" href="../partnerships.html">Partnerships</a></li>
<li><a class="navbar" href="../contact.html">Contact</a></li>
<li><a style="border:solid 1px #55acee;border-radius:5px;color:white;background-color:#55acee;box-shadow: 0px 5px 0px 0px #3C93D5;" class="navbar" href="../login/anmelden.php">Login</a></li>
</ul>
</nav>
</div>
</header>
<div id="form">
<br><h1 class="ueberschrift">Register a new flight</h1>
<form action="" method="POST">
<br />
<div class="answers">
<input type="text" name="name" placeholder="Pilotname" required><br />
</div>
<div class="answers">
<input type="text" name="aircraft" placeholder="Aircraft" required><br />
</div>
<div class="answers">
<input type="text" name="depairport" placeholder="Departure airport" required><br />
</div>
<div class="answers">
<input type="text" name="arrairport" placeholder="Arrival airport" required><br />
</div>
<div class="answers">
<input type="text" name="passengers" placeholder="Passengers" required><br />
</div>
<div class="answers">
<input type="text" name="flightnumber" placeholder="Flightnumber" required><br />
</div>
<div class="answers">
<input name="submit" class="partnerbutton" type="submit" value="New Flight">
</div>
</form>
</div>
<footer>
<p id="copyright">
© 2019 Pascal
</p>
<hr class="hr"/>
<div id="socialmedia">
<a href="t"><img class="socialmedia" src="../images/logos/instagram.png"></a>
<a href="f"><img class="socialmedia" src="../images/logos/youtube.png"></a>
<a href="#"><img class="socialmedia" src="../images/logos/twitter.png"></a>
</div>
<img id="footerlogo" src="../images/logos/logo.jpg">
</footer>
</body>
</html>