Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>Insert data in MySQL database using Ajax</title>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
- <link rel="stylesheet" type="text/css" href="mystyle.css">
- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- </head>
- <body>
- <div id="targetLegit"> </div>
- <div id="targetLegit2"> </div>
- <script>
- $(document).ready(function() {
- $('#butSave').on('click', function() {
- let name = $('#name').val();
- let email = $('#email').val();
- let identification = $('#identification').val();
- $.ajax({
- url: "save.php",
- type: "POST",
- data: {
- name: name,
- email: email,
- },
- cache: false,
- success: function(dataResult){
- dataResult = JSON.parse(dataResult);
- if(dataResult.statusCode==200){
- $("#butSave").removeAttr("disabled");
- $('#fupForm').find('input:text').val('');
- $("#success").show();
- $('#success').html('Data added successfully !');
- $('#targetLegit').load('show.php');
- $('#targetLegit2').load('showName.php', {identification: identification});
- }
- else if(dataResult.statusCode==201){
- alert("Error occured !");
- }
- }
- });
- });
- $('#butLoad').on('click', function() {
- let identification = $('#identification').val();
- $.ajax({
- url: "showName.php",
- type: "POST",
- data: {
- identification: identification
- },
- cache: false,
- success: function(dataResult){
- dataResult = JSON.parse(dataResult);
- if(dataResult.statusCode==200){
- $('#fupForm').find('input:text').val('');
- $("#success").show();
- $('#success').html('Data added successfully !');
- $('#targetLegit3').load('showName.php', {identification: identification});
- }
- else if(dataResult.statusCode==201){
- alert("Error occured !");
- }
- }
- });
- });
- });
- </script>
- <?php
- error_reporting(E_ALL);
- ini_set('display_errors', 1);
- echo <<<EOT
- <p> FORUM CODE HERE </p>
- <div style="margin: auto;width: 60%;">
- <div class="alert alert-success alert-dismissible" id="success" style="display:none;">
- <a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
- </div>
- <form id="fupForm" name="form1" method="post">
- <div class="form-group">
- <label for="name">Name:</label>
- <input type="text" class="form-control" id="name" placeholder="Name" name="name">
- </div>
- <div class="form-group">
- <label for="">Email:</label>
- <input type="email" class="form-control" id="email" placeholder="Email" name="email">
- </div>
- <div class="form-group">
- <label for="id">Identification #:</label>
- <input type="number" class="form-control" id="identification" placeholder="id" name="identification">
- </div>
- <input type="button" name="save" class="btn btn-primary btn-lg" value="Save to Database" id="butSave">
- <input type="button" name="load" class="btn btn-primary btn-lg" value="Load From Database" id="butLoad">
- </form>
- </div>
- </body>
- EOT;
- ?>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement