<?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
}
}
}
}
