Всем хай . Пишу регестрацию на PHP, и возникла такая проблема, то что значения не заносатся в базу. Код ниже <?php $db_host = 'localhost'; $db_user = 'root'; $db_password = ''; $db_name = 'base'; $dbc = mysqli_connect($db_host, $db_user, $db_password, $db_name) OR DIE('Error'); if (isset($_POST['submit'])) { $login = mysqli_real_escape_string($dbc, trim($_POST['login'])); $password = mysqli_real_escape_string($dbc, trim($_POST['password'])); if (!empty($login) && !empty($password)) { $query = "INSERT INTO `base` (`login`, `password`) VALUES ('$Login', '$password')"; mysqli_query($dbc, $query); mysqli_close(); exit(); } } ?> PHP <?php $db_host = 'localhost'; $db_user = 'root'; $db_password = ''; $db_name = 'base'; $dbc = mysqli_connect($db_host, $db_user, $db_password, $db_name) OR DIE('Error'); if (isset($_POST['submit'])) { $login = mysqli_real_escape_string($dbc, trim($_POST['login'])); $password = mysqli_real_escape_string($dbc, trim($_POST['password'])); if (!empty($login) && !empty($password)) { $query = "INSERT INTO `base` (`login`, `password`) VALUES ('$Login', '$password')"; mysqli_query($dbc, $query); mysqli_close(); exit(); } } ?> <!DOCTYPE html> <html> <head> <title></title> </head> <body> <section> <div> <form action="p-reg.php" method="post"> <label>Login</label> <input type="text" name="login"> <label>Password</label> <input type="password" name="password"> <button name="submit">Login</button> </div> </form> </section> </body> </html> HTML <!DOCTYPE html> <html> <head> <title></title> </head> <body> <section> <div> <form action="p-reg.php" method="post"> <label>Login</label> <input type="text" name="login"> <label>Password</label> <input type="password" name="password"> <button name="submit">Login</button> </div> </form> </section> </body> </html>
<?php $db_host = 'localhost'; $db_user = 'root'; $db_password = ''; $db_name = 'base'; $dbc = mysqli_connect($db_host, $db_user, $db_password, $db_name) OR DIE('Error'); if (isset($_POST['login']) && isset($_POST['password'])) { $login = mysqli_real_escape_string($dbc, trim($_POST['login'])); $password = mysqli_real_escape_string($dbc, trim($_POST['password'])); if (!empty($login) && !empty($password)) { $query = "INSERT INTO `base` (`login`, `password`) VALUES ('$Login', '$password')"; mysqli_query($dbc, $query); mysqli_close(); exit(); } } ?> Code <?php $db_host = 'localhost'; $db_user = 'root'; $db_password = ''; $db_name = 'base'; $dbc = mysqli_connect($db_host, $db_user, $db_password, $db_name) OR DIE('Error'); if (isset($_POST['login']) && isset($_POST['password'])) { $login = mysqli_real_escape_string($dbc, trim($_POST['login'])); $password = mysqli_real_escape_string($dbc, trim($_POST['password'])); if (!empty($login) && !empty($password)) { $query = "INSERT INTO `base` (`login`, `password`) VALUES ('$Login', '$password')"; mysqli_query($dbc, $query); mysqli_close(); exit(); } } ?>
Попробуй с такой формой. <!DOCTYPE html> <html> <head> <title></title> </head> <body> <section> <div> <form action="p-reg.php" method="post"> <label>Login</label> <input type="text" name="login"> <label>Password</label> <input type="password" name="password"> <input type="submit" value="Login"> </div> </form> </section> </body> </html> Code <!DOCTYPE html> <html> <head> <title></title> </head> <body> <section> <div> <form action="p-reg.php" method="post"> <label>Login</label> <input type="text" name="login"> <label>Password</label> <input type="password" name="password"> <input type="submit" value="Login"> </div> </form> </section> </body> </html>
файл p-reg.php: <?php $db_host = 'localhost'; $db_user = 'root'; $db_password = ''; $db_name = 'base'; $dbc = mysqli_connect($db_host, $db_user, $db_password, $db_name) OR DIE('Error'); if (isset($_POST['login'])) { $login = mysqli_real_escape_string($dbc, htmlspecialchars($_POST['login'])); $password = mysqli_real_escape_string($dbc, htmlspecialchars($_POST['password'])); if (!empty($login) && !empty($password)) { $query = "INSERT INTO `base` (`login`, `password`) VALUES ('$login', '$password')"; mysqli_query($dbc, $query); mysqli_close($dbc); exit(); } } ?> <!DOCTYPE html> <html> <head> <title></title> </head> <body> <section> <div> <form action="p-reg.php" method="post"> <label>Login</label> <input type="text" name="login"> <label>Password</label> <input type="password" name="password"> <button name="submit">Login</button> </div> </form> </section> </body> </html> Code <?php $db_host = 'localhost'; $db_user = 'root'; $db_password = ''; $db_name = 'base'; $dbc = mysqli_connect($db_host, $db_user, $db_password, $db_name) OR DIE('Error'); if (isset($_POST['login'])) { $login = mysqli_real_escape_string($dbc, htmlspecialchars($_POST['login'])); $password = mysqli_real_escape_string($dbc, htmlspecialchars($_POST['password'])); if (!empty($login) && !empty($password)) { $query = "INSERT INTO `base` (`login`, `password`) VALUES ('$login', '$password')"; mysqli_query($dbc, $query); mysqli_close($dbc); exit(); } } ?> <!DOCTYPE html> <html> <head> <title></title> </head> <body> <section> <div> <form action="p-reg.php" method="post"> <label>Login</label> <input type="text" name="login"> <label>Password</label> <input type="password" name="password"> <button name="submit">Login</button> </div> </form> </section> </body> </html>
функция mysqli_close должна содержать параметр и я думаю что у тебя структура базы отличается от той что ты задал, убедись что она выглядит именно так как ты указал: https://i.imgur.com/4yPXcvF.png т.е имя базы base и название таблицы base.