- 16, May 2024
- #1
Как мне вставить электронная почта_alert из ввода в БД? Я пытался
$email_alert = $_POST['email_alert'];
<form method="post" name="job_alerts" action="/index.php">
Email Address <span class="error">* </span>: <br><input type="text" name="email_alert" value=""> <input type="submit" name="submit" value="Submit">
</form>
Код (разметка):
$job_alert = $job_name; $area_alert = $city_name; $conn = mysqli_connect($host, $user, $pass,$dbname); if(!$conn){ die('Could not connect: '.mysqli_connect_error()); } echo 'Connected successfully<br/>'; $alerts = "INSERT INTO jobalerts (email_alert, job_alert, area_alert) VALUES ('$email_alert', '$job_alert', '$area_alert')"; if(mysqli_query($conn, $alerts)){ echo "Record inserted successfully"; }else{ echo "Could not insert record: ". mysqli_error($conn); } mysqli_close($conn);
Код (разметка):