php - Update-ing in to the Database -


this question has answer here:

so @ first made formular users enter data in database worked,after have tried make option them able modify data. , have error , several more

parse error: syntax error, unexpected '}' in c:\xampp\htdocs\atestat\addate.php on line 131

problem somewhere on else statement(131)

<?php  include 'ch20_include.php';   dodb();  if (!$_post) {  //haven’t seen form, show  $display_block = <<<end_of_text  <form method=”post” action=”$_server[php_self]”>  <fieldset>  <legend>first/last names:</legend><br/>  <input type=”text” name=”f_name” size=”30”  maxlength=”75” required=”required” />  <input type=”text” name=”l_name” size=”30”  maxlength=”75” required=”required” />  </fieldset>  <p><label for="adress">strada:</label><br/>  <input type="text"  id="adress" name="adress" size="30" /></p>   <fieldset>  <legend>oras/judet/cod postal:</legend><br/>  <input type="text" name="oras" size="30" maxlength="50" />  <input type="text" name="judet" size="5" maxlength="2" />  <input type="text" name="cod_postal" size="10" maxlength="10" />  </fieldset>   <fieldset>  <legend>numar de telefon:</legend><br/>  <input type="text" name="telefon" size="30" maxlength="25" />  <input type="radio" id="tel_type_h" name="tel_type" value="home" checked />      <label for="tel_type_h">acasa</label>  <input type="radio" id="tel_type_w" name="tel_type" value="work" />      <label for="tel_type_w">elev</label>  <input type="radio" id="tel_type_o" name="tel_type" value="altceva" />      <label for="tel_type_o">altceva</label>  </fieldset>   <fieldset>  <legend>nota-romana:</legend><br/>  <input type="text" name="notar_1" size="5" maxlength="50" />  <input type="text"  name="notar_2" size="5" maxlength="50" />  <input type="text"  name="notar_3" size="5" maxlength="50" />  <input type="text"  name="notar_4" size="5" maxlength="50" />  <input type="text"  name="notar_5" size="5" maxlength="50" />  <input type="text"  name="medier"  size="5" maxlength="50" />  </fieldset>    <fieldset>  <legend>nota-biologie:</legend><br/>  <input type="text" name="notab_1" size="5" maxlength="50" />  <input type="text"  name="notab_2" size="5" maxlength="50" />  <input type="text"  name="notab_3" size="5" maxlength="50" />  <input type="text"  name="notab_4" size="5" maxlength="50" />  <input type="text"  name="notab_5" size="5" maxlength="50" />  <input type="text"  name="medieb"  size="5" maxlength="50" />  </fieldset>    <fieldset>  <legend>nota-chimie:</legend><br/>  <input type="text" name="notac_1" size="5" maxlength="50" />  <input type="text"  name="notac_2" size="5" maxlength="50" />  <input type="text"  name="notac_3" size="5" maxlength="50" />  <input type="text"  name="notac_4" size="5" maxlength="50" />  <input type="text"  name="notac_5" size="5" maxlength="50" />  <input type="text"  name="mediec"  size="5" maxlength="50" />  </fieldset>   <fieldset>  <legend>nota-fizica:</legend><br/>  <input type="text" name="notaf_1" size="5" maxlength="50" />  <input type="text"  name="notaf_2" size="5" maxlength="50" />  <input type="text"  name="notaf_3" size="5" maxlength="50" />  <input type="text"  name="notaf_4" size="5" maxlength="50" />  <input type="text"  name="notaf_5" size="5" maxlength="50" />  <input type="text"  name="medief"  size="5" maxlength="50" />  </fieldset>     <fieldset>  <legend>nota-franceza:</legend><br/>  <input type="text" name="notafr_1" size="5" maxlength="50" />  <input type="text"  name="notafr_2" size="5" maxlength="50" />  <input type="text"  name="notafr_3" size="5" maxlength="50" />  <input type="text"  name="notafr_4" size="5" maxlength="50" />  <input type="text"  name="notafr_5" size="5" maxlength="50" />  <input type="text"  name="mediefr"  size="5" maxlength="50" />  </fieldset>    <fieldset>  <legend>nota-germana:</legend><br/>  <input type="text" name="notag_1" size="5" maxlength="50" />  <input type="text"  name="notag_2" size="5" maxlength="50" />  <input type="text"  name="notag_3" size="5" maxlength="50" />  <input type="text"  name="notag_4" size="5" maxlength="50" />  <input type="text"  name="notag_5" size="5" maxlength="50" />  <input type="text"  name="medieg"  size="5" maxlength="50" />  </fieldset>   <fieldset>  <legend>nota-informatica:</legend><br/>  <input type="text" name="notai_1" size="5" maxlength="50" />  <input type="text"  name="notai_2" size="5" maxlength="50" />  <input type="text"  name="notai_3" size="5" maxlength="50" />  <input type="text"  name="notai_4" size="5" maxlength="50" />  <input type="text"  name="notai_5" size="5" maxlength="50" />  <input type="text"  name="mediei"  size="5" maxlength="50" />  </fieldset>    <fieldset>  <legend>nota-matematica:</legend><br/>  <input type="text" name="notam_1" size="5" maxlength="50" />  <input type="text"  name="notam_2" size="5" maxlength="50" />  <input type="text"  name="notam_3" size="5" maxlength="50" />  <input type="text"  name="notam_4" size="5" maxlength="50" />  <input type="text"  name="notam_5" size="5" maxlength="50" />  <input type="text"  name="mediem"  size="5" maxlength="50" />  </fieldset>    <fieldset>  <legend>nota-religie:</legend><br/>  <input type="text" name="notare_1" size="5" maxlength="50" />  <input type="text"  name="notare_2" size="5" maxlength="50" />  <input type="text"  name="notare_3" size="5" maxlength="50" />  <input type="text"  name="notare_4" size="5" maxlength="50" />  <input type="text"  name="notare_5" size="5" maxlength="50" />  <input type="text"  name="mediere"  size="5" maxlength="50" />  </fieldset>   <p><label for="nota_personala">nota personala:</label><br/>  <textarea id="nota_personala" name="note" cols="35" rows="3"></textarea></p>  end_of_text;       if ($_get) {     $display_block .= "<input type=\"hidden\" name=\"nume_id\"      value=\"".$_get[‘nume_id’]."\">"; } $display_block .= <<<end_of_text  <button type="submit" name="submit" value="send">adauga elev</button>  </form>   end_of_text; } } else if ($_post) {      if ((($_post['p_nume'] == "") || ($_post['nume'] == "")) &&       (!isset($_post['nume_id']))) {        header("location: addate.php");        exit; }      //conectarea la bazadedate          dodb();       $safe_p_nume = mysqli_real_escape_string($mysqli,$_post['p_nume']);      $safe_nume = mysqli_real_escape_string($mysqli,$_post['nume']);      $safe_adresa = mysqli_real_escape_string($mysqli,$_post['adress']);      $safe_oras = mysqli_real_escape_string($mysqli,$_post['oras']);      $safe_judet = mysqli_real_escape_string($mysqli,$_post['judet']);      $safe_cod_postal = mysqli_real_escape_string($mysqli,$_post['cod_postal']);      $safe_tel_numar = mysqli_real_escape_string($mysqli, $_post['telefon']);      $safe_notab_1 = mysqli_real_escape_string($mysqli,$_post['notab_1']);      $safe_notab_2 = mysqli_real_escape_string($mysqli,$_post['notab_2']);      $safe_notab_3 = mysqli_real_escape_string($mysqli,$_post['notab_3']);      $safe_notab_4 = mysqli_real_escape_string($mysqli,$_post['notab_4']);      $safe_notab_5 = mysqli_real_escape_string($mysqli,$_post['notab_5']);      $safe_medieb = mysqli_real_escape_string($mysqli,$_post['medieb']);      $safe_notac_1 = mysqli_real_escape_string($mysqli,$_post['notac_1']);      $safe_notac_2 = mysqli_real_escape_string($mysqli,$_post['notac_2']);      $safe_notac_3 = mysqli_real_escape_string($mysqli,$_post['notac_3']);      $safe_notac_4 = mysqli_real_escape_string($mysqli,$_post['notac_4']);      $safe_notac_5 = mysqli_real_escape_string($mysqli,$_post['notac_5']);      $safe_mediec = mysqli_real_escape_string($mysqli,$_post['mediec']);      $safe_notaf_1 = mysqli_real_escape_string($mysqli,$_post['notaf_1']);      $safe_notaf_2 = mysqli_real_escape_string($mysqli,$_post['notaf_2']);      $safe_notaf_3 = mysqli_real_escape_string($mysqli,$_post['notaf_3']);      $safe_notaf_4 = mysqli_real_escape_string($mysqli,$_post['notaf_4']);      $safe_notaf_5 = mysqli_real_escape_string($mysqli,$_post['notaf_5']);      $safe_medief = mysqli_real_escape_string($mysqli,$_post['medief']);      $safe_notafr_1 = mysqli_real_escape_string($mysqli,$_post['notafr_1']);      $safe_notafr_2 = mysqli_real_escape_string($mysqli,$_post['notafr_2']);      $safe_notafr_3 = mysqli_real_escape_string($mysqli,$_post['notafr_3']);      $safe_notafr_4 = mysqli_real_escape_string($mysqli,$_post['notafr_4']);      $safe_notafr_5 = mysqli_real_escape_string($mysqli,$_post['notafr_5']);      $safe_mediefr = mysqli_real_escape_string($mysqli,$_post['mediefr']);      $safe_notag_1 = mysqli_real_escape_string($mysqli,$_post['notag_1']);      $safe_notag_2 = mysqli_real_escape_string($mysqli,$_post['notag_2']);      $safe_notag_3 = mysqli_real_escape_string($mysqli,$_post['notag_3']);      $safe_notag_4 = mysqli_real_escape_string($mysqli,$_post['notag_4']);      $safe_notag_5 = mysqli_real_escape_string($mysqli,$_post['notag_5']);      $safe_medieg = mysqli_real_escape_string($mysqli,$_post['medieg']);      $safe_notai_1 = mysqli_real_escape_string($mysqli,$_post['notai_1']);      $safe_notai_2 = mysqli_real_escape_string($mysqli,$_post['notai_2']);      $safe_notai_3 = mysqli_real_escape_string($mysqli,$_post['notai_3']);      $safe_notai_4 = mysqli_real_escape_string($mysqli,$_post['notai_4']);      $safe_notai_5 = mysqli_real_escape_string($mysqli,$_post['notai_5']);      $safe_mediei = mysqli_real_escape_string($mysqli,$_post['mediei']);      $safe_notam_1 = mysqli_real_escape_string($mysqli,$_post['notam_1']);      $safe_notam_2 = mysqli_real_escape_string($mysqli,$_post['notam_2']);      $safe_notam_3 = mysqli_real_escape_string($mysqli,$_post['notam_3']);      $safe_notam_4 = mysqli_real_escape_string($mysqli,$_post['notam_4']);      $safe_notam_5 = mysqli_real_escape_string($mysqli,$_post['notam_5']);      $safe_mediem = mysqli_real_escape_string($mysqli,$_post['mediem']);      $safe_notare_1 = mysqli_real_escape_string($mysqli,$_post['notare_1']);      $safe_notare_2 = mysqli_real_escape_string($mysqli,$_post['notare_2']);      $safe_notare_3 = mysqli_real_escape_string($mysqli,$_post['notare_3']);      $safe_notare_4 = mysqli_real_escape_string($mysqli,$_post['notare_4']);      $safe_notare_5 = mysqli_real_escape_string($mysqli,$_post['notare_5']);      $safe_mediere = mysqli_real_escape_string($mysqli,$_post['mediere']);     $safe_notar_1 = mysqli_real_escape_string($mysqli,$_post['notar_1']);      $safe_notar_2 = mysqli_real_escape_string($mysqli,$_post['notar_2']);      $safe_notar_3 = mysqli_real_escape_string($mysqli,$_post['notar_3']);      $safe_notar_4 = mysqli_real_escape_string($mysqli,$_post['notar_4']);      $safe_notar_5 = mysqli_real_escape_string($mysqli,$_post['notar_5']);      $safe_medier = mysqli_real_escape_string($mysqli,$_post['medier']);     $safe_note = mysqli_real_escape_string($mysqli,$_post['note']);       //adauga  if (!$_post['nume_id']) { $add_nume_sql = "insert nume_principal (date_added, date_modified, p_name, nume) values (now(), now(), '".$safe_p_nume."', '".$safe_nume."')"; $add_nume_res = mysqli_query($mysqli, $add_nume_sql) or die(mysqli_error($mysqli));  $nume_id = mysqli_insert_id($mysqli); } else { $nume_id = mysqli_real_escape_string($mysqli, $_post['nume_id']); }      if (($_post['adress']) || ($_post['oras']) || ($_post['judet']) || ($_post['cod_postal'])) {      $add_adress_sql = "insert adress (nume_id,date_added,date_modified,adresa,oras,judet,cod_postal) values ('".$nume_id."',now(),now(),'".$safe_adresa."','".$safe_oras."','".$safe_judet."','".$safe_cod_postal."')";      $add_adress_res = mysqli_query($mysqli, $add_adress_sql) or die(mysqli_error($mysqli));      }      if ($_post['telefon']) {      $add_tel_sql = "insert telefon (nume_id, date_added, date_modified, tel_numar) values ('".$nume_id."', now(), now(), '".$safe_tel_numar."')";      $add_tel_res = mysqli_query($mysqli, $add_tel_sql) or die(mysqli_error($mysqli));      }  if (($_post['notab_1']) || ($_post['notab_2']) || ($_post['notab_3']) || ($_post['notab_4']) || ($_post['notab_5']) || ($_post['medieb'])) {      $add_biologie_sql = "insert biologie (nume_id,date_added,date_modified,notab_1,notab_2,notab_3,notab_4,notab_5,medieb) values ('".$nume_id."',now(),now(),'".$safe_notab_1."','".$safe_notab_2."','".$safe_notab_3."','".$safe_notab_4."','".$safe_notab_5."','".$safe_medieb."')";      $add_biologie_res = mysqli_query($mysqli,$add_biologie_sql) or die(mysqli_error($mysqli));  }  if (($_post['notac_1']) || ($_post['notac_2']) || ($_post['notac_3']) || ($_post['notac_4']) || ($_post['notac_5']) || ($_post['mediec'])) {      $add_chimie_sql = "insert chimie (nume_id, date_added, date_modified, notac_1, notac_2, notac_3, notac_4, notac_5, mediec) values ('".$nume_id."', now(), now(),  '".$safe_notac_1."' ,'".$safe_notac_2."', '".$safe_notac_3."', '".$safe_notac_4."', '".$safe_notac_5."', '".$safe_mediec."')";      $add_chimie_res = mysqli_query($mysqli,$add_chimie_sql) or die(mysqli_error($mysqli));  }  if (($_post['notaf_1']) || ($_post['notaf_2']) || ($_post['notaf_3']) || ($_post['notaf_4']) || ($_post['notaf_5']) || ($_post['medief'])) {      $add_fizica_sql = "insert fizica(nume_id, date_added, date_modified, notaf_1, notaf_2, notaf_3, notaf_4, notaf_5, medief) values ('".$nume_id."', now(), now(),   '".$safe_notaf_1."' ,'".$safe_notaf_2."', '".$safe_notaf_3."', '".$safe_notaf_4."', '".$safe_notaf_5."', '".$safe_medief."')";      $add_fizica_res = mysqli_query($mysqli,$add_fizica_sql) or die(mysqli_error($mysqli));  }  if (($_post['notafr_1']) || ($_post['notafr_2']) || ($_post['notafr_3']) || ($_post['notafr_4']) || ($_post['notafr_5']) || ($_post['mediefr'])) {      $add_franceza_sql = "insert franceza (nume_id, date_added, date_modified, notafr_1, notafr_2, notafr_3, notafr_4, notafr_5, mediefr) values ('".$nume_id."', now(), now(), '".$safe_notafr_1."' ,'".$safe_notafr_2."', '".$safe_notafr_3."', '".$safe_notafr_4."', '".$safe_notafr_5."', '".$safe_mediefr."')";      $add_franceza_res = mysqli_query($mysqli,$add_franceza_sql) or die(mysqli_error($mysqli));  }  if (($_post['notag_1']) || ($_post['notag_2']) || ($_post['notag_3']) || ($_post['notag_4']) || ($_post['notag_5']) || ($_post['medieg'])) {      $add_germana_sql = "insert germana (nume_id, date_added, date_modified, notag_1, notag_2, notag_3, notag_4, notag_5, medieg) values ('".$nume_id."', now(), now(),  '".$safe_notag_1."' ,'".$safe_notag_2."', '".$safe_notag_3."', '".$safe_notag_4."', '".$safe_notag_5."', '".$safe_medieg."')";      $add_germana_res = mysqli_query($mysqli,$add_germana_sql) or die(mysqli_error($mysqli));  }  if (($_post['notai_1']) || ($_post['notai_2']) || ($_post['notai_3']) || ($_post['notai_4']) || ($_post['notai_5']) || ($_post['mediei'])) {      $add_informatica_sql = "insert informatica (nume_id, date_added, date_modified, notai_1, notai_2, notai_3, notai_4, notai_5, mediei) values ('".$nume_id."', now(), now(),  '".$safe_notai_1."' ,'".$safe_notai_2."', '".$safe_notai_3."', '".$safe_notai_4."', '".$safe_notai_5."', '".$safe_mediei."')";      $add_informatica_res = mysqli_query($mysqli,$add_informatica_sql) or die(mysqli_error($mysqli));  }  if (($_post['notam_1']) || ($_post['notam_2']) || ($_post['notam_3']) || ($_post['notam_4']) || ($_post['notam_5']) || ($_post['mediem'])) {      $add_matematica_sql = "insert matematica (nume_id, date_added, date_modified, notam_1, notam_2, notam_3, notam_4, notam_5, mediem) values ('".$nume_id."', now(), now(),  '".$safe_notam_1."' ,'".$safe_notam_2."', '".$safe_notam_3."', '".$safe_notam_4."', '".$safe_notam_5."', '".$safe_mediem."')";      $add_matematica_res = mysqli_query($mysqli,$add_matematica_sql) or die(mysqli_error($mysqli));   }  if (($_post['notare_1']) || ($_post['notare_2']) || ($_post['notare_3']) || ($_post['notare_4']) || ($_post['notare_5']) || ($_post['mediere'])) {      $add_religie_sql = "insert religie (nume_id, date_added, date_modified, notare_1, notare_2, notare_3, notare_4, notare_5, mediere) values ('".$nume_id."', now(), now(),   '".$safe_notare_1."' ,'".$safe_notare_2."', '".$safe_notare_3."', '".$safe_notare_4."', '".$safe_notare_5."', '".$safe_mediere."')";      $add_religie_res = mysqli_query($mysqli,$add_religie_sql) or die(mysqli_error($mysqli));  }  if (($_post['notar_1']) || ($_post['notar_2']) || ($_post['notar_3']) || ($_post['notar_4']) || ($_post['notar_5']) || ($_post['medier'])) {      $add_romana_sql = "insert romana (nume_id, date_added, date_modified, notar_1, notar_2, notar_3, notar_4, notar_5, medier) values ('".$nume_id."', now(), now(),  '".$safe_notar_1."' ,'".$safe_notar_2."', '".$safe_notar_3."', '".$safe_notar_4."', '".$safe_notar_5."', '".$safe_medier."')";      $add_romana_res = mysqli_query($mysqli,$add_romana_sql) or die(mysqli_error($mysqli));  }  if ($_post['note']) {  $add_nota_sql = "update nota_personala (nume_id, date_added, date_modified, note) values ('".$nume_id."', now(), now(), '".$safe_note."')";  $add_nota_res =  mysqli_query($mysqli, $add_nota_sql) or die(mysql_error($mysqli));  }  mysqli_close($mysqli);  $display_block = "<p>a fost adaugat.ai dori sa mai adaugi si <a href=\"addate.php\">altceva</a>?</p>";      }  ?>  <!doctype html>  <head>  <title>adauga un elev</title>  </head>  <body>  <h1>adauga un elev</h1>  <?php echo $display_block; ?>  </body>  </html> 

line 131

} } else if ($_post) {      if ((($_post['p_nume'] == "") || ($_post['nume'] == "")) &&       (!isset($_post['nume_id']))) {        header("location: addate.php");        exit; }      //conectarea la bazadedate  

} } else if ($_post) {  

should

} else if ($_post) {  

Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -