I've looked everywhere and most forums tell me to write a php file then use a cron job. The problem is how to write this php according to my files already.
include('connect-mysql.php'); $date = $_POST['date']; $date = date('Y-m-d'); $fname = $_POST['fname']; $lname = $_POST['lname']; $phonenumber = $_POST['phonenumber']; $email = $_POST['email']; $bookname = $_POST['bookname']; $isbnnumber = $_POST['isbnnumber']; $bookcondition = $_POST['bookcondition']; $price = $_POST['price']; $info = $_POST['info']; $sqlinsert = "INSERT INTO people (date, firstname, lastname, phonenumber, email, bookname, isbnnumber, bookcondition, price, info) VALUES ('$date', '$fname', '$lname', '$phonenumber', '$email', '$bookname', '$isbnnumber', '$bookcondition', '$price', '$info')";
This is a part of the code im using to post into the database.
Please help me figure this out.
<input type="hidden" name="submitted" value="true" /> <input type="hidden" name="date" value="<?= $date ?>">
This is also part of my files.
I don't know how to write it accordingly with the date.