Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // include file connection database
- require_once("connection.php");
- if($_SERVER["REQUEST_METHOD"] == "POST"){
- $userName = $_POST["username"];
- $Gender = $_POST["gender"];
- $Country = $_POST["country"];
- $Date = date("y-m-d");
- $sql = "INSERT INTO upload(username,gender,country,date)
- VALUES(:username,:gender,:country,:date)";
- $stmt = $connect->prepare($sql);
- // bind value to a paramater
- $stmt->bindValue(":username",$userName,PDO::PARAM_STR);
- $stmt->bindValue(":gender",$Gender,PDO::PARAM_STR);
- $stmt->bindValue(":country",$Country,PDO::PARAM_STR);
- $stmt->bindValue(":date",$Date,PDO::PARAM_STR);
- $res = $stmt->execute();
- if($res){
- $msg = "new record add to database";
- }else{
- $msg = "Error";
- exit();
- }
- }
- $connect = NULL;
- ?>
- <?php require_once("head.html"); ?>
- <div class="container">
- <center><h3>CodeJs : How To Insert Data Into Database And display it <br />
- Input types = text , radio , select , submit </h3></center><br /><br />
- <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="POST" enctype="multipart/form-data">
- <div class="form-group"> <!-- input text -->
- <label for="username">Username :</label>
- <input type="text" class="form-control" placeholder="Your Username" name="username">
- </div>
- <div class="radio"> <!-- Radio Buttons -->
- Man : <label class="radio-inline"><input type="radio" name="gender" value="man"></label>
- Woman : <label class="radio-inline"><input type="radio" name="gender" value="woman"></label>
- </div>
- <div class="form-group"> <!-- Select List -->
- <label for="sel1">Country :</label>
- <select class="form-control" id="sel1" name="country">
- <option value="Tunisia">Tunisia</option>
- <option value="USA">USA</option>
- <option value="France">France</option>
- <option value="Russia">Russia</option>
- </select>
- </div>
- <button type="submit" class="btn btn-primary">Register</button> <!-- button submit -->
- <br /><br />
- <?php if(isset($msg)){ ?> <!-- Alert Message -->
- <div class="alert alert-danger">
- <?php echo $msg; ?>
- </div>
- <?php } ?> <!-- End Alert Message -->
- </form>
- </div>
- <style>
- form, h2{ width: 400px; margin: 0 auto; }
- </style>
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement