Dear All Members
here is my table data..
(4 Columns/1row in mysql table)
id order_no order_date miles
310 001 02-15-2020 MI,108.53
Oh,194.57
PA,182.22
WA,238.57
How to split(miles) 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 order_no order_date state miles
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
------------------my php code -----------
<?php
//invoice.php
include('../includes/config.php');
if(isset($_POST["add"]))
{
$order_no=$_GET['order_no'];
$order_date=$_GET['order_date'];
$miles=$_POST['miles'];
$miles = explode("\r\n", $_POST["miles"]);
$newdata = "'" . implode("','", $_POST["miles"]) . "'";
$sql ="INSERT INTO tble_states_miles(order_no,order_date, miles) VALUES(:order_no, :order_date, :newdata)";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query-> bindParam(':order_date', $order_date, PDO::PARAM_STR);
$query-> bindParam(':miles', $newdata, PDO::PARAM_STR);
$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
echo "<script type='text/javascript'>alert('Added Sucessfull!');</script>";
echo "<script type='text/javascript'> document.location = 'ifta_miles_calculationlist_added.php'; </script>";
}
else
{
$error="Something went wrong. Please try again";
}
if($query->execute()) {
$sql = "update tis_invoice set flag='1' where order_no=:order_no";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query->execute();
}
}
?>
----------------- my form code ------------------
<?php
$order_no=$_GET['order_no'];
$sql = "SELECT * from tis_invoice where order_no = :order_no";
$query = $dbh -> prepare($sql);
$query->execute(
array(
':order_no' => $_GET["order_no"]
)
);
$result = $query->fetchAll();
foreach($result as $row)
?>
<form method="post">
<table align="center" style="width: 55%">
<tr><td>Invoice Number</td></tr>
<tr><td><input type="text" name="order_no" value="<?php echo $row["order_no"]; ?>" readonly=""></td></tr>
<tr><td>Invoice Date</td></tr>
<tr><td><input type="text" name="order_no" value="<?php echo $row["order_date"]; ?>" readonly=""></td></tr>
<tr><td>
<textarea name="miles" class="form-control" rows="10" placeholder="" required></textarea>
</td></tr>
<tr><td>
<input type="submit" name="add" class="btn btn-primary" value="Add" />
</td></tr></table>
</form>
-- Can any one help how to correct my code..present nothing inserted on table
Thank You