Apache Friends Support Forum

by **fahad** » 14. August 2021 15:30

Good day,
I have a question and I have a problem that the link to the database does not work. I always get this eror: Fatal error: Uncaught PDOException: SQLSTATE [42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-Mail, Password, Date-Time) VALUES (' ddddddddddddddd ',' dddddddddddd @ dddddd ... 'at line 1 in C: \ xampp \ htdocs \ FF-Find Friends \ Registration.php: 82 Stack trace: # 0 C: \ xampp \ htdocs \ FF-Find Friends \ Registration.php (82): PDOStatement-> execute () # 1 {main} thrown in C : \ xampp \ htdocs \ FF-Find Friends \ Registration.php on line 82. I hope you can solve it.
Kind regards
Fahad

the code is:

<!DOCTYPE html>
<html>
<head>
<title>title</title>
<link rel="stylesheet" href="css/style1.css" type="text/css">

<meta name="robots" content="noindex" />
</head>
<body>
<div id="a">
<section>
<header>header</header>
<div class="col-md-6">
<form action="Registrierung.php" method="POST">
<fieldset>
<legend>Bitte merke dir deine Zugangsdaten</legend>
<p>
<label for="username" class="sr-only">Name</label>
<div class="row">
<div class="col-md-3">
<input type="text" name="username" size="100" id="id-name" class="form-control" placeholder="Name" autocomplete="username" required>
</div>
</div>
</p>
<p>
<label for="email" class="sr-only">E-Mail</label>
<div class="row">
<div class="col-md-3">
<input type="email" name="usermail" size="100" id="idmail" class="form-control" placeholder="E-Mail" autocomplete="usermail" required>
</div>
</div>
</p>
<p>
<label for="password" class="sr-only">Passwort</label>
<div class="row">
<div class="col-md-3">
<input type="password" name="userpassword" size="100" id="idpass" class="form-control" placeholder="Passwort" autocomplete="userpass" required>
</div>
</div>
</p>
<p>
<input type="checkbox" name="rememberusername" id="rememberusername" value="1" />
<div class="row">
<div class="col-md-3">
<label for="rememberusername" id="checkmark">Namen merken</label>
</div>
</div>
</p>
<button type="submit" name="login" value="weiter" id="loginbtn">WEITER</button>
</fieldset>
</form>
</div>
</div>
</section>
<footer>
<hr>
<p><a href="#">© 2021 FF</a></p>
</footer>
</div>
</body>
</html>
<?php
if(isset($_POST['login']))
{
require("inc/db_connect.php");

$username = $_POST['username'];
$usermail = $_POST['usermail'];
$userpassword = $_POST['userpassword'];
$datum = date("Y-m-d H:i:s");

echo "Die Nachricht wurde erfolgreich gespeichert!";

$sql = "INSERT INTO benutzer_konten(Benutzername, E-Mail, Passwort, Datum-Uhrzeit) VALUES (:username, :usermail, :userpassword, :datum)";
$stmt = $dbh->prepare($sql);
$stmt->bindValue(':username', $username);
$stmt->bindValue(':usermail', $usermail);
$stmt->bindValue(':userpassword', $userpassword);
$stmt->bindValue(':datum', $datum);

$stmt-> execute();
}
?>

code from dbconnect:

<?php
$user = "FF";
$pass = "!zNzL*4m8aEo9c7c";

try
{
$dbh = new PDO('mysql:host=localhost;dbname=ff - findfriends;charset=utf8' , $user, $pass);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e)
{
print "Error!: " . $e->getMessage() . "<br/>";
die();
}
?>

by **Altrea** » 14. August 2021 22:36

Use backticks to wrap your Database fields:

old

$sql = "INSERT INTO benutzer_konten(Benutzername, E-Mail, Passwort, Datum-Uhrzeit) VALUES (:username, :usermail, :userpassword, :datum)";

new

$sql = "INSERT INTO benutzer_konten(`Benutzername`, `E-Mail`, `Passwort`, `Datum-Uhrzeit`) VALUES (:username, :usermail, :userpassword, :datum)";

by **fahad** » 23. August 2021 10:01

thanks,it really helped.

Apache Friends Support Forum

important

important

Re: important

Re: important

Who is online