if(!empty($_POST['submit'])){
//Create an array of fields for your insert query
$fields = array(
  'pr_nume_username' => Input::get('pr_nume_username'),
  'pr_nume' => Input::get('pr_nume'),
  'pr_telefon' => Input::get('pr_telefon') ,
  'pr_animal_nume' => Input::get('pr_animal_nume'),
  'pr_adaugat' => Input::get('pr_adaugat'),
  'pr_kilograme' => Input::get('pr_kilograme'),
  'pr_varsta' => Input::get('pr_varsta'),
  'pr_sex' => Input::get('pr_sex'),
  'pr_vacinat' => Input::get('pr_vacinat'),
  'pr_detalii' => Input::get('pr_detalii')
);
$db->insert('propietar',$fields);
$newProId = $db->lastId();

// prepare sql and bind parameters
//Now they are being sanitized too!
//You really don't need to create a variable for each one unless
//you want to use it somewhere else on the page. You could just
//use Input::get down in the array below
$pro_id = Input::get('newProId');
$pro_nume = Input::get('pr_nume');
$pro_telefon = Input::get('pr_telefon');
$pro_animal_nume = Input::get('pr_animal_nume');
$pro_data = Input::get('pr_data');
$pro_ora = Input::get('pr_ora');
$pro_vacinat = Input::get('pr_vacinat');
$pro_varsta = Input::get('pr_varsta');
$pro_kilograme = Input::get('pro_kilograme');
$pro_sex = Input::get('pro_sex');
$pro_alte_detalii = Input::get('pro_alte_detalii');
$pro_pachet_mini = Input::get('pro_pachet_mini');
$pro_pachet_mediu = Input::get('pro_pachet_mediu');
$pro_pachet_maxi = Input::get('pro_pachet_maxi');
$pro_tuns = Input::get('pro_tuns');
$pro_spalat = Input::get('pro_spalat');
$pro_uscat = Input::get('pro_uscat');
$pro_taiat_ungi = Input::get('pro_taiat_ungi');
$pro_curatat_urechi = Input::get('pro_curatat_urechi');
$pro_vidat = Input::get('pro_vidat');
$pro_pernute = Input::get('pro_pernute');
$pro_periat = Input::get('pro_periat');
$pro_parfumat = Input::get('pro_parfumat');
$pro_fundita = Input::get('pro_fundita');
$pro_stele = Input::get('pro_stele');


 foreach($_POST['pro_nume'] as $value){
//Create an array of fields for your insert query
$fields = array(
  'pro_id' => $newProId,
  'id_key_sub' => $key,
  'pro_nume' => $value,
  'pro_telefon' => $pr_telefon ,
  'pro_animal_nume' => $pr_animal_nume,
  'pro_data' => $pro_data,
  'pro_ora' => $pro_ora,
  'pro_vacinat' => $pr_vacinat,
  'pro_varsta' => $pr_varsta,
  'pro_kilograme' => $pro_kilograme,
  'pro_sex' => $pro_sex,
  'pro_alte_detalii' => $pr_alte_detalii,
  'pro_pachet_mini' => $value,
  'pro_pachet_mediu' => $value,
  'pro_pachet_maxi' => $value,
  'pro_tuns' => $value,
  'pro_spalat' => $value,
  'pro_uscat' => $value,
  'pro_taiat_ungi' => $value,
  'pro_curatat_urechi' => $value,
  'pro_vidat' => $value,
  'pro_pernute' => $value,
  'pro_periat' => $value,
  'pro_parfumat' => $value,
  'pro_fundita' => $value,
  'pro_stele' => $pro_stele
);

//Run the insert.
//to do an insert query, you only need to know what table and an array of fields. This creates, prepares, binds, and sanitizes your db update.

$db->insert('programare',$fields);
 }
//here is the id of the above query


//Put your sub queries down here...
    header('Location: account.php');
}