php - How to insert (order form data) in multiple rows of mysql having same name -


here code.

<form id="form.id" name="form.id" action="order" method="post">   <ul>      //loading dynamically javascript      <li class="singalproductlist'+ productid +'">         <input type="text" value="'+ productid +'" name="dishid[]" disabled>         <input class="newlass'+ productid +'" type="text"                        value="1" name="dishquantity[]" disabled>         <input type="text" value="'+ name +'" name="dishname[]" disabled>         <input type="text" value="'+ price +'" name="dishprice[]" disabled>     </li>   </ul> </form>

i using mvc that's why action (order) only.

i submitting other button javascript not shown here.

i able single li having 4 input fields value without [ ].

when use [ ] error occur: notice: undefined index: dishname in .....

i have used every code that's why can't show particular one.

li can 5 or 6 no limit.

i can use productid in every name inside [ ].

i want insert every li have 4 inputs in 1 row , others in next row in mysql.

i have problem php side.

thank in advanced in case of help.

php code dishid , dishname,

$dishids = $_post['dishid']; $dishnames = $_post['dishname'];  $query = $con1->prepare("insert dishes (dish_id, dish_name) values (?, ?)");      ($i=0; $i<count($dishid); $i++) {          $dishid = $dishids[$i];         $dishname = $dishnames[$i];          $query->bind_param('ssi', $dishid, $dishname);         $query->execute();     }      echo "done";     $query->close();

here working php code processing order form data , insert in mysqli using php.

include 'includes/db.php';      $did = $_post['dishid'];     $dqty = $_post['dishquantity'];     $dname = $_post['dishname'];     $dprice = $_post['dishprice'];      $totaldishes = sizeof($did);      for($i=0;$i<$totaldishes;$i++) {        $insertdid = $did[$i];       $insertdqty = $dqty[$i];       $insertdname = $dname[$i];       $insertdprice = $dprice[$i];        $sql = "insert test (dish_id, dish_quantity ,dish_name ,dish_price)       values ('$insertdid','$insertdqty','$insertdname','$insertdprice') ";        if ($con1->query($sql) === true) {         echo "new record created <br />";       } else {         echo "error: " . $sql . "<br>" . $con1->error;       }     }

if interested , need more code or can ask.


-

Comments

Post a Comment

Popular posts from this blog

unity3d - Rotate an object to face an opposite direction -

i have object , b. when click on object b, rotates object b (a faces b). b doesn't face a. need following : when faces b, need face opposite direction. have code rotating @ b. how rotate face opposite direction after that? vector3 targetdirection = target - transform.position; float step = speed * time.deltatime; vector3 newdirection = vector3.rotatetowards (turretdome.transform.forward, targetdirection, step, 0.0f); turretdome.transform.rotation = quaternion.lookrotation (newdirection); you object facing object b, want inverse direction of object after that? objecta.transform.rotation = quaternion.inverse(objecta.transform.rotation) but lets assume example turretdome object a, (negate direction): turretdome.transform.rotation = quaternion.lookrotation (-newdirection); naturally, both of these snippets not show how smoothen rotation, seem know how use time.deltatime. just incase unsure, quaternion.lerp this
Read more

angular - Is it possible to get native element for formControl? -

i've got angular2 reactive form . created formcontrol s , assigned input fields by [formcontrol]=... . understand creates nativeelement <-> formcontrol link. my question: possible nativeelement formcontrol ? wanna myformcontrol.nativeelement.focus() i can share 1 terrible solution works me. in reactive forms can use either 1) formcontroldirective ts mycontrol = new formcontrol('') template <input type="text" [formcontrol]="mycontrol"> or 2) formcontrolname ts myform: formgroup; constructor(private fb: formbuilder) {} ngoninit() { this.myform = this.fb.group({ foo: '' }); } template <form [formgroup]="myform"> <input type="text" formcontrolname="foo"> </form> so these directives write patch like 1) formcontroldirective const originformcontrolngonchanges = formcontroldirective.prototype.ngonchanges; formcontroldirective.proto
Read more

javascript - Why jQuery Select box change event is now working? -

i working on product filters user select select box according his/her preference not getting selected value user in jquery. html code:- <select name="product_filter" id="product_filter"> <option value="price_low_first">price : low high</option> <option value="price_high_first">price : high low</option> <option value="latest">latest</option> <option value="popular">most popular</option> </select> jquery code: $(function () { $("#product_filter").change(function () { alert("hi") var selectedtext = $(this).find("option:selected").text(); var selectedvalue = $(this).val(); alert("selected text: " + selectedtext + " value: " + selectedvalue); }); }); hi believe code perfect. once please check jquery.min.js
Read more