Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.79 KB | None | 0 0
  1. if(isset($_POST['addproduct'])) {
  2. $product = new product(0,$_POST['productName'],$_POST['productDescription'],$_POST['productVersion']) ;
  3. addProduct($product,$con,$modules);
  4. addproductmodule($modules,$con,$productId);
  5. $modules=$_POST['modules'];
  6. }
  7. function addproduct(Product $product, Connection $con,$modules){
  8. $sql = ("INSERT INTO products (productName,productDescription,productVersion) values(?,?,?)");
  9. $req=$con->getPdo()->prepare($sql);
  10. $req->execute(array($product->getProductName(),$product->getProductDescription(),$product->getProductVersion()));
  11.  
  12. function addproductmodule($modules, Connection $con, $productId){ $productId=$con->getPdo()->lastInsertId();
  13. foreach ($modules as $value)
  14. {$rq = "INSERT INTO product_module (productId, moduleId) VALUES (.'$productId'., .'$value'.)";
  15. $rep=$con->getPdo()->prepare($rq);
  16. $rep->execute(array()); }
  17.  
  18. <form class="form-horizontal " method="POST">
  19. <div class="form-group">
  20. <label for="productName" class="col-sm-3 control-label">Product name : <span class="required" style="color:red;">*</span></label>
  21. <div class="col-sm-9">
  22. <input type="text" id="productName" class="form-control" name="productName" value="" required="required" />
  23. </div>
  24. </div>
  25. <div class="form-group">
  26. <label for="productDescription" class="col-sm-3 control-label">Product description : <span class="required" style="color:red;">*</span></label>
  27. <div class="col-sm-9">
  28. <textarea id="productDescription" class="form-control" name="productDescription" required="required" > </textarea>
  29. </div>
  30. </div>
  31. <div class="form-group">
  32. <label for="productVersion" class="col-sm-3 control-label">Product version <span class="required" style="color:red;">*</span></label>
  33. <div class="col-sm-9">
  34. <input type="text" id="productVersion" class="form-control" name="productVersion" value="" required="required" />
  35. </div>
  36. </div>
  37.  
  38. <?php
  39. $modules=ViewModules($con);
  40. $count=count($modules);
  41. $data='<div class="form-group"><label for="productModules" class="col-sm-3 control-label">Product modules : <span class="required" style="color:red;">*</span></label>
  42. <div class="col-sm-3">
  43. <select id="select1"class="form-control" multiple size="'.$count.'"style="height:100px;">';
  44. if ($count>0){
  45. $number=1;
  46. foreach ($modules as $module)
  47. {$data .='<option value="'.$module['moduleId'].'">'.$module['moduleName'].'</option>';
  48.  
  49. $number++;
  50. }}
  51. else {$data .='<option value="Please add modules first">Please add modules first</option>
  52. </br>';}
  53.  
  54. $data .= '</select><a href="#" id="add">add >></a></div><div class="col-sm-3">
  55. <select multiple="multiple" name="modules" id="select2" class="form-control" style="height:100px;"></select>
  56. <a href="#" id="remove"><< remove</a>
  57. </div></div><br>';
  58. echo $data;
  59.  
  60. ?>
  61. <br>
  62.  
  63. <center><input type="submit" class="btn btn-primary" style="width:10%;" name="addproduct" value="Save"/></center>
  64. </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement