Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement