<?php function connectToMysql() { $mysqli = new mysqli('localhost', 'usr_fashionne', 'password', 'fashionne'); if (mysqli_connect_errno() > 0) { $problem = mysqli_connect_error(); die($problem); } return $mysqli; } $db = connectToMysql();
<option value="F">female</option> </select> <input type="date" name="hire" placeholder="hire date" /> <input type="submit" class="btn" value="submit"/> </fieldset> </form> <?php } else { if ($request == 'doInsert') { $emp_no = $_POST['emp_no']; $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $birth = $_POST['birth']; $gender = $_POST['gender']; $hire = $_POST['hire']; connectToMysql(); $query = "INSERT INTO employee('emp_no','birth_date','first_name',\n 'last_name','gender','hire_date') VALUES ('{$emp_no}',{$birth}\n '{$first_name}','{$last_name}','{$gender}','{$hire}')"; if ($result === mysql_query($query)) { echo "sukses memasukkan satu data dengan detail : " + $query; mysql_close(); } else { mysql_close(); ?> <script> //location.replace('employee.php?action=insert') </script> <?php } } } }