38 lines
757 B
PHP
38 lines
757 B
PHP
<?php
|
|
include "db.php";
|
|
|
|
$id=$_POST['id'];
|
|
$name=$_POST['name'];
|
|
$email=$_POST['email'];
|
|
$phone=$_POST['phone'];
|
|
$category=$_POST['category'];
|
|
$description=$_POST['description'];
|
|
|
|
mysqli_query($conn,"UPDATE records SET
|
|
name='$name',
|
|
email='$email',
|
|
phone='$phone',
|
|
category='$category',
|
|
description='$description'
|
|
WHERE id=$id");
|
|
|
|
|
|
// DELETE OLD FIELDS
|
|
mysqli_query($conn,"DELETE FROM additional_fields WHERE record_id=$id");
|
|
|
|
|
|
// INSERT NEW FIELDS
|
|
if(isset($_POST['fields']))
|
|
{
|
|
foreach($_POST['fields'] as $field)
|
|
{
|
|
if(!empty($field)){
|
|
$field=mysqli_real_escape_string($conn,$field);
|
|
mysqli_query($conn,"INSERT INTO additional_fields(record_id,field_value)
|
|
VALUES($id,'$field')");
|
|
}
|
|
}
|
|
}
|
|
|
|
?>
|