<!DOCTYPE html>
<html>
<head>
<title>update</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="style.css">
<script src="js/jquery-1.2.6.min.js"></script>
<script src="js/jquery.validate.js"></script>
</head>
<body>
<div>
<h1>update existing <button class="learn-more" onclick="window.location.href='/vaadbait/ContactForm/index.html';">Home page</button></h1>
</div>
<div id="page-wrap">
<form method="post" autocomplete="off" action="updatetenant.php" id="commentForm">
<fieldset>
<div id="formRight">
<label for="Name">number:</label>
<?php
$dsn = "mysql:host=localhost;dbname=vaadbait;charset=UTF8";
$username = "root";
$password = "";
$options = [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
try {
$pdo = new PDO($dsn, $username, $password, $options);
$stmt = $pdo->query("SELECT appartnmb,firstname,lastname FROM contacts");
$rows = $stmt->fetchAll();
if ($stmt->rowCount() > 0) {
?>
<!-- dropdownlist -->
<select class="input-bg" name="nbrselect">
<option value="" disabled selected>choice from list</option>
<?php foreach ($rows as $row) { ?>
<option value="<?php echo $row['appartnmb']; ?>"><?php echo $row['appartnmb'] . ' ' . $row['firstname'] . ' ' . $row['lastname']; ?></option>
<?php } ?>
</select>
<!-- dropdownlist -->
<?php } ?>
<label for="Name">Lastname</label>
<?php
if ($stmt->rowCount() > 0) {
foreach ($rows as $row) { ?>
<div class="input-bg">
<input type="text" name="lastname" id="lastname" placeholder="Lastname" class="required" required="required" value="<?php echo $row['lastname'] ?>" />
</div>
<?php }
}
?>
<br>
<input type="image" src="images/send-button.jpg" name="submit" value="Submit" class="submit-button" />
</div>
<div id="formLeft">
<label for="Name">FirstName:</label>
<div class="input-bg">
<input type="text" name="firstname" id="firstname" placeholder="FirstName" class="required" required="required" />
</div>
<label for="Email">Email:</label>
<div class="input-bg">
<input type="text" name="mail" id="mail" placeholder="Email" />
</div>
</div>
<div class="clear"></div>
</fieldset>
</form>
</div>
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#commentForm").validate();
});
</script>
</body>
</html>
Comments