break; case 'm_patient_fp_obgyn': $spc_field = 'fp_id'; $field_to_find = 'obshx_id'; $value_to_find = $get_all_result['obshx_id']; break; case 'm_patient_fp_method_service': $spc_field = 'fp_id'; $field_to_find = 'service_id'; $value_to_find = $get_all_result['service_id']; break; default: $value_to_find = ''; break; } $missing = find_missing($delete_value[0], $delete_value[2], $field_to_find, $value_to_find, $spc_field, $delete_value[4]); if ($missing != NULL || $missing != '') { ehr_connect(); $delete_query = mysql_query("DELETE FROM {$delete_value['4']} WHERE {$delete_text} {$missing}") or die("Error 227 : " . mysql_error()); } } ehr_connect(); } else { if ($delete_value[4] == 'm_consult_notes') { $delete_text = "notes_id = '{$delete_value['3']}'"; } $delete_query = mysql_query("DELETE FROM {$delete_value['4']} WHERE {$delete_text}") or die("Error 132 : " . mysql_error()); } $push_data_array = array($delete_value[0], $delete_value[1], $delete_value[2], $delete_value[3], $delete_value[4], $delete_value[5], 'N', $delete_value[6]); array_push($array_m_push_update, $push_data_array); unset($push_data_array);
// intialize array $a = range(1, 500); $shuffle_times = 5; // random it function shuffle_array(&$a) { for ($i = 0, $len = count($a); $i < $len; $i++) { $p = rand(0, $len - 1); $tmp = $a[$p]; $a[$p] = $a[$i]; $a[$i] = $tmp; } } for ($i = 0; $i < $shuffle_times; $i++) { echo "shuffle {$i} times.\n"; shuffle_array($a); } // remove a random element $rkey = array_rand($a, 1); array_splice($a, $rkey, 1); echo "After shuffled {$shuffle_times} times: " . json_encode($a) . "\n"; $missing = find_missing($a, count($a) + 1); echo "Missing one:" . $missing . "\n"; // space O(1), time O(1) , math way function find_missing($a, $count) { $sum = ($count + 1) * $count / 2; // Get sum of it should be return $sum - array_sum($a); // the difference between it should be and it has is the missing one. }