here is my table data..
here is my table data..
(4 Columns/1row in mysql table)
id bno date results
310 001 02-15-2020 MI,108.53
Oh,194.57
PA,182.22
WA,238.57
How to split(statemiles) single column into (state, Miles) two columns and output like following 5 columns /4rows in mysql using php code.
(5 Columns in mysql table)
------------------------------------------------------------------------------------
id bno date result1 result2
310 001 02-15-2020 MI 108.53
310 001 02-15-2020 Oh 194.57
310 001 02-15-2020 PA 182.22
310 001 02-15-2020 WA 238.57
Following php code split two columns perfectly..
(screenshot below)
<?php
//invoice.php
include('../includes/config.php');
if(isset($_POST["add"]))
{
$order_no=$_POST['order_no'];
$comma = preg_replace('/,\\s*/', "', '", $_POST["stateandmileslist"]);
$row = preg_replace('/\\n/', "'), \n('", $comma);
$query = "insert into tis_satesmiles (states, miles) values ('" . $row . "')";
$statement = $dbh->prepare($query);
$statement->execute();
}
?>
But how can i update or insert order_no and order_date input values in same table?
Following attachment shown form page how users submit values