Hi guys, new to the forum and new to PHP - I have written a script to enable me to enter employee details into my MySQL database but it just won’t work lol, here is the code if anyone can help please
<?php
$fullname = $_POST['fullname'];
$date_of_birth = $_POST['date_of_birth'];
$address_1 = $_POST['address_1'];
$address_2 = $_POST['address_2'];
$address_3 = $_POST['address_3'];
$postcode = $_POST['postcode'];
$home_phone = $_POST['home_phone'];
$mobile_phone = $_POST['mobile_phone'];
$ni_number = $_POST['ni_number'];
$next_of_kin = $_POST['next_of_kin'];
$phone_number = $_POST['phone_number'];
$doctor = $_POST['doctor'];
$doctor_address_1 = $_POST['doctor_address_1'];
$doctor_address_2 = $_POST['doctor_address_2'];
$doctor_address_3 = $_POST['doctor_address_3'];
$doctor_postcode = $_POST['doctor_postcode'];
$doctor_phone_number = $_POST['doctor_phone_number'];
$known_medical_issues = $_POST['known_medical_issues'];
$date_started = $_POST['date_started'];
$dbc = mysqli_connect('localhost','web205-wr_2013','wr_2013','web205-wr_2013')
or die ('Error connecting to Database');
$query = "INSERT INTO staff (fullname, date_of_birth, address_1, address_2, address_3, postcode, home_phone, mobile_phone, ni_number, next_of_kin, phone_number, doctor, doctor_address_1, doctor_address_2, doctor_address_3, doctor_postcode, doctor_phone_number, known_medical_issues, date_started)" .
"VALUES ('$fullname', '$date_of_birth', '$address_1', '$address_2', '$address_3', '$postcode', '$home_phone', '$mobile_phone', '$ni_number', '$next_of_kin', '$phone_number', '$doctor', '$doctor_address_1', '$doctor_address_2', '$doctor_address_3', '$doctor_postcode', '$doctor_phone_number', '$known_medical_issues', '$date_started')";
$result = mysqli_query($dbc, $query)
or die ('Error querying Database.');
mysqli_close ($dbc);