function saveUploadData($db, $metadata) { global $dataMap, $fpConfig; $dbConnected = $db != NULL; if (!$dbConnected) { $db = new SqlManager($fpConfig); } if ($db->offline) { return -1; } //TODO: use remap between exif data and db row? //step 1: insert record based on image EXIF metadata if (!isset($metadata["upload_id"])) { $data = arrayRemap($metadata, $dataMap); // $data["meal"] = selectMeal($data["image_date_taken"]); } else { //step 2: update record based on form data $data = $metadata; } $data["username"] = fpCurrentUsername(); $data["table"] = "user_upload"; $result = $db->saveRow($data); if (!$dbConnected) { $db->disconnect(); } return $result; }