Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form action="for_lease_edit.php?i=<?php echo($rowProperty['leaseid']); ?>" method="post">
- 'value => (isset($_POST['lease_name'])) ? $_POST['lease_name'] : $rowProperty['lease_name'],
- 'value' => (isset($_POST['lease_type'])) ? $_POST['lease_type'] : $rowProperty['lease_type'],
- 'value' => (isset($_POST['lease_address'])) ? $_POST['lease_address'] : $rowProperty['lease_address'],
- 'value' => (isset($_POST['lease_price'])) ? $_POST['lease_price'] : $rowProperty['lease_price'],
- 'value' => (isset($_POST['lease_condition'])) ? $_POST['lease_condition'] : $rowProperty['lease_condition'],
- 'value' => (isset($_POST['lease_description'])) ? $_POST['lease_description'] : $rowProperty['lease_description'],
- </form>
- <div class="col-md-4 col-md-offset-8">
- <input type="submit" class="btn bg-color-dark-gold color-white form-control" name="submit" value="SAVE">
- </div>
- require_once($routePath . "_config/db.php");
- $dbConfig = new config_db();
- $db = $dbConfig->init();
- require_once($routePath . "_mc/Property.mc.php");
- $mcProperty = new Property_MC();
- if (isset($_POST['submit']) && $_POST['submit'] == 'SAVE')
- {
- $leaseid = $_GET['i'];
- $lease_name = $_POST['lease_name'];
- $lease_type = $_POST['lease_type'];
- $lease_address = $_POST['lease_address'];
- $lease_price = $_POST['lease_price'];
- $lease_condition = $_POST['lease_condition'];
- $lease_description = $_POST['lease_description'];
- $mcProperty->UpdateLease($db, $leaseid, $lease_type, $lease_name, $lease_address, $lease_price, $lease_condition, $lease_description);
- }
- <?php
- Class Property_MC {
- public function UpdateLease($db, $leaseid, $lease_type, $lease_name, $lease_address, $lease_price, $lease_condition, $lease_description) {
- $stmt = $db->prepare(
- " UPDATE for_lease
- 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
- WHERE leaseid = :leaseid "
- );
- $stmt->bindValue(':leaseid', $leaseid, PDO::PARAM_INT);
- $stmt->bindValue(':lease_name', $lease_name, PDO::PARAM_STR);
- $stmt->bindValue(':lease_type', $lease_type, PDO::PARAM_STR);
- $stmt->bindValue(':lease_address', $lease_address, PDO::PARAM_STR);
- $stmt->bindValue(':lease_price', $lease_price, PDO::PARAM_INT);
- $stmt->bindValue(':lease_condition', $lease_condition, PDO::PARAM_STR);
- $stmt->bindValue(':lease_description', $lease_description, PDO::PARAM_STR);
- $stmt->execute();
- $rowAffected = $stmt->rowCount();
- return $rowAffected;
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement