Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.56 KB | None | 0 0
  1. <form action="for_lease_edit.php?i=<?php echo($rowProperty['leaseid']); ?>" method="post">
  2. 'value => (isset($_POST['lease_name'])) ? $_POST['lease_name'] : $rowProperty['lease_name'],
  3. 'value' => (isset($_POST['lease_type'])) ? $_POST['lease_type'] : $rowProperty['lease_type'],
  4. 'value' => (isset($_POST['lease_address'])) ? $_POST['lease_address'] : $rowProperty['lease_address'],
  5. 'value' => (isset($_POST['lease_price'])) ? $_POST['lease_price'] : $rowProperty['lease_price'],
  6. 'value' => (isset($_POST['lease_condition'])) ? $_POST['lease_condition'] : $rowProperty['lease_condition'],
  7. 'value' => (isset($_POST['lease_description'])) ? $_POST['lease_description'] : $rowProperty['lease_description'],
  8. </form>
  9.  
  10. <div class="col-md-4 col-md-offset-8">
  11. <input type="submit" class="btn bg-color-dark-gold color-white form-control" name="submit" value="SAVE">
  12. </div>
  13.  
  14. require_once($routePath . "_config/db.php");
  15. $dbConfig = new config_db();
  16. $db = $dbConfig->init();
  17.  
  18. require_once($routePath . "_mc/Property.mc.php");
  19. $mcProperty = new Property_MC();
  20.  
  21. if (isset($_POST['submit']) && $_POST['submit'] == 'SAVE')
  22. {
  23. $leaseid = $_GET['i'];
  24. $lease_name = $_POST['lease_name'];
  25. $lease_type = $_POST['lease_type'];
  26. $lease_address = $_POST['lease_address'];
  27. $lease_price = $_POST['lease_price'];
  28. $lease_condition = $_POST['lease_condition'];
  29. $lease_description = $_POST['lease_description'];
  30.  
  31. $mcProperty->UpdateLease($db, $leaseid, $lease_type, $lease_name, $lease_address, $lease_price, $lease_condition, $lease_description);
  32. }
  33.  
  34. <?php
  35.  
  36. Class Property_MC {
  37.  
  38. public function UpdateLease($db, $leaseid, $lease_type, $lease_name, $lease_address, $lease_price, $lease_condition, $lease_description) {
  39.  
  40. $stmt = $db->prepare(
  41. " UPDATE for_lease
  42. SET lease_type :lease_type, lease_name :lease_name, lease_address :lease_address, lease_price :lease_price, lease_condition :lease_condition, lease_description :lease_description
  43. WHERE leaseid = :leaseid "
  44. );
  45.  
  46. $stmt->bindValue(':leaseid', $leaseid, PDO::PARAM_INT);
  47. $stmt->bindValue(':lease_name', $lease_name, PDO::PARAM_STR);
  48. $stmt->bindValue(':lease_type', $lease_type, PDO::PARAM_STR);
  49. $stmt->bindValue(':lease_address', $lease_address, PDO::PARAM_STR);
  50. $stmt->bindValue(':lease_price', $lease_price, PDO::PARAM_INT);
  51. $stmt->bindValue(':lease_condition', $lease_condition, PDO::PARAM_STR);
  52. $stmt->bindValue(':lease_description', $lease_description, PDO::PARAM_STR);
  53.  
  54. $stmt->execute();
  55. $rowAffected = $stmt->rowCount();
  56.  
  57. return $rowAffected;
  58. }
  59. }
  60.  
  61. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement