php - Empty values inserted to databese -
i'm trying posted values inserted table every time empty values inserted.
<form action="submit.php" method="post"> <input type="text" id="name" placeholder="name"> <input type="text" id="email" placeholder="email"> <button name="submit" value="send" type="submit">subscribe</button> </form> <?php $email = $_post['email'] $name = $_post['name'] $dbc = mysqli_connect('localhost', 'x', 'x', 'x') or die('error connecting mysql server.'); $query = "insert subscribers (name, email)" . "values ('$name', '$email')"; $result = mysqli_query($dbc, $query) or die('error querying database.'); mysqli_close($dbc); ?>
you forgot name attribute in <input> fields:
<input type="text" name="name" id="name" placeholder="name"> <input type="text" name="email" id="email" placeholder="email"> fyi, have caught using var_dump($_post) @ top of file or using tool firebug see no values being sent server. have done echo $query , saw there no values. basic debugging skills.
Comments
Post a Comment