-
-
Save suiramus/7a42c22a0191ecbaa2f85d9f07923c93 to your computer and use it in GitHub Desktop.
HTML to MySQL using PHP (code to accompany https://youtu.be/Y9yE98etanU)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title>Contact</title> | |
| <meta charset="UTF-8"> | |
| <link rel="stylesheet" | |
| href="https://cdn.jsdelivr.net/npm/water.css@2/out/water.min.css"> | |
| </head> | |
| <body> | |
| <h1>Contact</h1> | |
| <form action="process-form.php" method="post"> | |
| <label for="name">Name</label> | |
| <input type="text" id="name" name="name"> | |
| <label for="message">Message</label> | |
| <textarea id="message" name="message"></textarea> | |
| <label for="priority">Priority</label> | |
| <select id="priority" name="priority"> | |
| <option value="1">Low</option> | |
| <option value="2" selected>Medium</option> | |
| <option value="3">High</option> | |
| </select> | |
| <fieldset> | |
| <legend>Type</legend> | |
| <label> | |
| <input type="radio" name="type" value="1" checked> | |
| Complaint | |
| </label> | |
| <br> | |
| <label> | |
| <input type="radio" name="type" value="2"> | |
| Suggestion | |
| </label> | |
| </fieldset> | |
| <label> | |
| <input type="checkbox" name="terms"> | |
| I agree to the terms and conditions | |
| </label> | |
| <br> | |
| <button>Send</button> | |
| </form> | |
| </body> | |
| </html> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| $name = $_POST["name"]; | |
| $message = $_POST["message"]; | |
| $priority = filter_input(INPUT_POST, "priority", FILTER_VALIDATE_INT); | |
| $type = filter_input(INPUT_POST, "type", FILTER_VALIDATE_INT); | |
| $terms = filter_input(INPUT_POST, "terms", FILTER_VALIDATE_BOOL); | |
| if ( ! $terms) { | |
| die("Terms must be accepted"); | |
| } | |
| $host = "localhost"; | |
| $dbname = "message_db"; | |
| $username = "root"; | |
| $password = ""; | |
| $conn = mysqli_connect(hostname: $host, | |
| username: $username, | |
| password: $password, | |
| database: $dbname); | |
| if (mysqli_connect_errno()) { | |
| die("Connection error: " . mysqli_connect_error()); | |
| } | |
| $sql = "INSERT INTO message (name, body, priority, type) | |
| VALUES (?, ?, ?, ?)"; | |
| $stmt = mysqli_stmt_init($conn); | |
| if ( ! mysqli_stmt_prepare($stmt, $sql)) { | |
| die(mysqli_error($conn)); | |
| } | |
| mysqli_stmt_bind_param($stmt, "ssii", | |
| $name, | |
| $message, | |
| $priority, | |
| $type); | |
| mysqli_stmt_execute($stmt); | |
| echo "Record saved."; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment