$query = "SELECT id, obj_id FROM database1 WHERE obj_id='".$id."'";
$database->setQuery($query);
$database->loadObject($record);
if ($record) {
$rid = $record->id;
$query = "UPDATE database1 SET ";
$first = true;
foreach ($fields as $key=>$value) {
if (!$first) {
$query .= ",";
} else {
$first = false;
}
if (is_numeric($value)) {
$query .= $key."=".$value;
} else {
$query .= $key."=".$database->Quote($value);
}
}
$query .= " WHERE id=".$rid;
$database->setQuery($query);
$database->query($query);
include("importimg.php");
} else {
$query = "INSERT INTO database1(".implode(",",array_keys($fields)).") VALUES (";
$first = true;
foreach ($fields as $key=>$value) {
if (!$first) {
$query .= ",";
} else {
$first = false;
}
if (is_numeric($value)) {
$query .= $value;
} else {
$query .= $database->Quote($value);
}
}
$query .= ")";
$database->setQuery($query);
$database->query($query);
include("importimg.php");
$rid = $database->insertid();
}

Rispondi quotando