["input", "", "", "text"], "phone_number" => ["input", "", "", "text"], "address" => ["input", "", "", "address"], "email" => ["input", "", "", "email"], "contact_name" => ["input", "", "", "text"], "account_status" => ["input", "", "", "text"], "internal_notes" => ["input", "", "", "text"], "file" => ["input", "", "", "file"], "historic_tickets" => ["input", "", "", "text"], "security_pin" => ["input", "", "", "text"], ); // if (isset($_GET['id'])) { // $cust_id = escape($_GET['id']); // $query = "SELECT * FROM jeoXillityCrm_sites WHERE company_id='$cust_id'"; // $results = getAll($con, $query); // $fet = mysqli_fetch_assoc($results); // } if (isset($_POST['create_package'])) { $actionId = escape($_POST['actionId']); $company_id = escape($_POST['company_id']); $site_name = escape($_POST['site_name']); $phone_number = escape($_POST['phone_number']); $address = escape($_POST['address']); $email = escape($_POST['email']); $contact_name = isset($_POST['contact_name']) ? implode(',', array_map('escape', $_POST['contact_name'])) : ''; $account_status = escape($_POST['account_status']); $internal_notes = escape($_POST['internal_notes']); $historic_tickets = escape($_POST['historic_tickets']); $security_pin = escape($_POST['security_pin']); $timeAdded = date('Y-m-d H:i:s'); // assuming this format for timeAdded $session_userId = escape($_SESSION['userId']); // assuming you have session management for userId if ($actionId == "") { $id = generateRandomString(); $actionId = $id; $query = "INSERT INTO jeoXillityCrm_sites (id, company_id, site_name, phone_number, address, email, contact_name, account_status, internal_notes, historic_tickets, security_pin, timeAdded, userId) VALUES ('$id', '$company_id', '$site_name', '$phone_number', '$address', '$email', '$contact_name', '$account_status', '$internal_notes', '$historic_tickets', '$security_pin', '$timeAdded', '$session_userId')"; echo $query; } else { $query = "UPDATE jeoXillityCrm_sites SET company_id='$company_id', site_name='$site_name', phone_number='$phone_number', address='$address', email='$email', contact_name='$contact_name', account_status='$account_status', internal_notes='$internal_notes', historic_tickets='$historic_tickets', security_pin='$security_pin' WHERE id='$actionId'"; } runQuery($query); if (isset($_FILES['file']) && $_FILES['file']['error'] == UPLOAD_ERR_OK) { $file = storeFile($_FILES['file']); if ($file != "") { $query = "UPDATE jeoXillityCrm_sites SET file='$file' WHERE id='$actionId'"; runQuery($query); } } header("Location: ?" . generateUrlParams_return(["m" => "Data was saved successfully!", "type" => "success"])); exit(); } if (isset($_GET['delete-record'])) { $id = escape($_GET['delete-record']); $query = "delete from jeoXillityCrm_sites where id='$id'"; runQuery($query); } ?>

Sites

Sites name	Phone number	Address	Email	Contact name	Account status	Internal notes	File	Historic tickets	Security pin	Actions