0){ $info = mysqli_fetch_array($result); $last_id=$info['id']; }else{ $last_id="0"; } $track_id="$last_id$date_day$date_month$date_year"; //date_delivered, received_detail, status2 $sql="INSERT INTO logistic_shipment (customer_name, customer_address, customer_phone, customer_email, item_name, item_detail, date_entry, source_address, destination_address, cost, other_detail, status1, track_id) VALUES ('$customer_name', '$customer_address', '$customer_phone', '$customer_email', '$item_name', '$item_detail', '$date_entry', '$source_address', '$destination_address', '$cost', '$other_detail', '$status1', '$track_id')"; mysqli_query($conn, $sql) or die(mysqli_error($conn)); $msg="Record created"; $last_id = mysqli_insert_id($conn); } if(isset($_REQUEST['editing'])){ $select_id = mysqli_escape_string($conn, $_REQUEST['id']); $sql = "SELECT * FROM logistic_shipment WHERE id='$select_id'"; $result = mysqli_query($conn, $sql) or die(mysqli_error($conn)); $info = mysqli_fetch_array($result); $id=$info['id']; $customer_name=$info['customer_name']; $customer_address=$info['customer_address']; $customer_phone=$info['customer_phone']; $customer_email=$info['customer_email']; $item_name=$info['item_name']; $item_detail=$info['item_detail']; $date_entry=$info['date_entry']; $source_address=$info['source_address']; $destination_address=$info['destination_address']; $cost=$info['cost']; $other_detail=$info['other_detail']; } if(isset($_REQUEST['edit_id'])){ $edit_id = mysqli_escape_string($conn, $_REQUEST['edit_id']); $customer_name = mysqli_escape_string($conn, $_REQUEST['customer_name']); $customer_address = mysqli_escape_string($conn, $_REQUEST['customer_address']); $customer_phone = mysqli_escape_string($conn, $_REQUEST['customer_phone']); $customer_email = mysqli_escape_string($conn, $_REQUEST['customer_email']); $item_name = mysqli_escape_string($conn, $_REQUEST['item_name']); $item_detail = mysqli_escape_string($conn, $_REQUEST['item_detail']); $date_day = mysqli_escape_string($conn, $_REQUEST['date_day']); $date_month = mysqli_escape_string($conn, $_REQUEST['date_month']); $date_year = mysqli_escape_string($conn, $_REQUEST['date_year']); $date_entry="$date_day-$date_month-$date_year"; $source_address = mysqli_escape_string($conn, $_REQUEST['source_address']); $destination_address = mysqli_escape_string($conn, $_REQUEST['destination_address']); $cost = mysqli_escape_string($conn, $_REQUEST['cost']); $other_detail = mysqli_escape_string($conn, $_REQUEST['other_detail']); $sql1 = "UPDATE logistic_shipment SET customer_name = '$customer_name', customer_address = '$customer_address', customer_phone = '$customer_phone', customer_email = '$customer_email', item_name = '$item_name', item_detail = '$item_detail', date_entry = '$date_entry', source_address = '$source_address', destination_address = '$destination_address', cost = '$cost', other_detail = '$other_detail' WHERE id = '$edit_id'"; mysqli_query($conn, $sql1) or die(mysqli_error($conn)); //Update $msg="EDITING WAS SUCCESSFUL"; } ?>

Logistic Shipment New Entry

Customer name *

required />

Customer address

Customer phone *

required />

Customer email

Items name*

required />

Items Detail (e.g size, weight, condition etc.)

Entry Date

Source address *

required />

Destination address *

required />

Shipment cost *

required />

Detail

"; if(isset($_REQUEST['editing'])){ $select_id = mysqli_escape_string($conn, $_REQUEST['id']); print ""; print ''; }else{ print ' '; } ?>