I’m going to make an app that shows / maps a three dimensional color wheel.
$originalDate = $value;
$newDate = date(“Y-m-d”, strtotime($originalDate));
phpMyadmin accepts this format, Y-m-d, for the “date” data type.
Simple example of sending data to a PHP file, and returning database content based on your selection from the drop down:
The inputs had this at the end of each : \” so i used substr to get rid of it. Also, I had to put the JS on the main html page.
A more indepth explaination.
// Check connection
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
$result = mysqli_query($con,”SELECT field1,field2 FROM table”);
while($row = mysqli_fetch_array($result))
echo “<option value=’”.$row['field1'].”‘>”.$row['field2'].”</option>”;