mysql - how to insert dynamically added form fields in database using php -


i want add dynamic form fields in database using php. have used angular add dynamic form fields. thing when trying insert data database last form field inserting in database. so, used array , loop increment , update form field database. somehow query not working , data not inserting database. can tell me wrong here? stuck. please help. thanx in advance

php code: <?php if(isset($_post['submit_row'])) { $link = mysqli_connect("localhost", "root", "", "midata");  // check connection if($link === false){     die("error: not connect. " . mysqli_connect_error()); }   $camp_name = mysqli_real_escape_string($link, $_request['camp_name']);  $start_date = mysqli_real_escape_string($link, $_request['start_date']);  $end_date = mysqli_real_escape_string($link, $_request['end_date']);   $store = mysqli_real_escape_string($link, $_request['$store']); $elements= $mysqli->real_escape_string($_post['elements']); $quantity = $mysqli->real_escape_string($_post['quantity']);  $description = mysqli_real_escape_string($link, $_request['description']);  for($i=0;$i<count($elements);$i++)  {   if( $elements[$i]!="" && $quantity[$i]!="")   {  $sql = "insert create_campaign(camp_name, start_date, end_date,store,elements,quantity, description ) values('$camp_name',' $start_date', '$end_date','$store','$elements[$i]', '$quantity[$i]', '$description')";  if(mysqli_query($link, $sql)){     echo "records added successfully."; } else{     echo "error: not able execute $sql. " . mysqli_error($link); } mysqli_query($sql, $link); } } }   ?>   html code:   <div class="row col-md-12" ng-app="angularjs-starter" ng-controller="mainctrl">                                                     <fieldset  data-ng-repeat="choice in choices" name="records">                                                         <label for="inputpassword3" class="col-md-1 control-label">elements</label>                                                         <div class="form-group col-md-3 ">                                                             <input type="text" placeholder="campaign name" ng-model="choice.name" class="form-control c-square c-theme input-lg" name="elements[]">                                                          </div>                                                         <label for="inputpassword3" class="col-md-1 control-label">quantity</label>                                                         <div class="form-group col-md-3" >                                                            <select class="form-control  c-square c-border-2px c-theme"  name="quantity[]>                                                              <option value="1">100</option>                                                              <option value="2">200</option>                                                              <option value="3">300</option>                                                              <option value="4">400</option>                                                              </select>                                                         </div>                                                       <button type="button" class="btn c-theme-btn c-btn-uppercase btn-lg c-btn-bold c-btn-square" ng-click="addnewchoice()" >add</button>                                                      <button   ng-show="$last" ng-click="removechoice()" class="btn c-theme-btn c-btn-uppercase btn-lg c-btn-bold c-btn-square" >remove</button>                                                      </fieldset>                                                   </div>                                               </div>                                         </div>                                       <div class="form-group">                                             <input type="text" placeholder="description" class="form-control c-square c-theme input-lg" name="description">                                       </div>                                         <input class="btn c-theme-btn c-btn-uppercase btn-lg c-btn-bold c-btn-square" value="submit" type="submit" name="submit_row">                                      </form>                                 </div>


Comments

Post a Comment

Popular posts from this blog

python - Operations inside variables -

this question has answer here: evaluating mathematical expression in string 12 answers i want make python script finds maximum possible output using 2 operations. problem says there syntax error @ 2nd last line, in b in there. how can fix it? x = 0 = int(input("1st number:")) c = int(input("2nd number:" )) e = int(input("3rd number:" )) in range(4): if == 0: b = "+" elif == 1: b = "-" elif == 2: b = "/" else: b = "*" j in range(4): if j == 0: d = "+" elif j == 1: d = "-" elif j == 2: d = "/" else: d = "*" k = b c d e print(k) if you're after variables e on single line, couldn...
Read more

Generic Map Parameter java -

i having lot of methods of type: public static list<eduusers> getdetails(class c, map<string, integer> params) { list<eduusers> details = null; session session = hibernateutil.getsessionfactory().opensession(); transaction tx = null; try { tx = session.begintransaction(); criteria cr = session.createcriteria(c); (map.entry<string, integer> entry : params.entryset()) { cr.add(restrictions.eq(entry.getkey(), entry.getvalue())); } details = cr.list(); tx.commit(); } catch (exception asd) { log.debug(asd.getmessage()); if (tx != null) { tx.commit(); } } { session.close(); } return details; } i trying have generic method them , have written far: public static <t> list<t> getdetails(class<t> c, class<t> b) { l...
Read more

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -

what arrayindexoutofboundsexception mean , how rid of it? here code sample triggers exception: string[] name = {"tom", "dick", "harry"}; for(int = 0; i<=name.length; i++) { system.out.print(name[i] +'\n'); } your first port of call should documentation explains reasonably clearly: thrown indicate array has been accessed illegal index. index either negative or greater or equal size of array. so example: int[] array = new int[5]; int boom = array[10]; // throws exception as how avoid it... um, don't that. careful array indexes. one problem people run thinking arrays 1-indexed, e.g. int[] array = new int[5]; // ... populate array here ... (int index = 1; index <= array.length; index++) { system.out.println(array[index]); } that miss out first element (index 0) , throw exception when index 5. valid indexes here 0-4 inclusive. correct, idiomatic for statement here be: for (int index = 0; index <...
Read more