insert.php

<?php
	$server = 'localhost';
	$user = 'root';
	$pass = '';
	$dbname = 'rideshare';

	try {
		//create database
		$city=$_POST['city'];
		$state=$_POST['state'];
		$date=$_POST['date'];
		$dbconn = new PDO("mysql:host=$server;dbname=$dbname", $user, $pass);
		$dbconn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		$ins=$dbconn->prepare(
			'INSERT INTO `riders` (id,username,state,city,date)
			VALUES (:id,:username,:city,:state,:date)'
		);
		$username="bob";
		$dt=new DateTime($date);
		$date=$dt->format('Y-m-d');
		$ins->bindParam(':id',$id);
		$ins->bindParam(':username',$username);
		$ins->bindParam(':city',$city);
		$ins->bindParam(':state',$state);
		$ins->bindParam(':date',$date);
		$ins->execute();
		echo "New records created successfully";
		echo "<script> location.href='index.html'; </script>";
	}
	catch(PDOException $e){
		echo "<br>" . $e->getMessage();
	}
?>