ajax insert

-
index.php

<!DOCTYPE html>
<html>
<head>
  <title>Ajax insert</title>
  <!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">

<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">


</head>
<body>
<div class="container">
    <div class="row">
          <div class="col-md-3"></div>
          <div class="col-md-6">
          <form >
            <div class="form-group">
                <div class="form-label">Names</div>  
                <input type="text" name="name"  id="name" class="form-control">
            </div>
            <div class="form-group">
            <div class="form-label">Surname</div> 
                <input type="text" name="surname"  id="surname" class="form-control">
            </div>
            <div class="form-group">
              <input type="button" name="submit" value="Submit" id="submit">
            </div>
            </form>
          </div>
          <div class="col-md-3" >
            <textarea id="view"></textarea>
          </div>
    </div>  
</div>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.1/jquery.min.js"></script>
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
<script type="text/javascript">
  
$(document).ready(function(){

 $("#submit").click(function(){
    var name=$("#name").val();
    var surname=$("#surname").val();

 $.post("insert.php",{fname:name,sname:surname},function(data){
    $("#view").html(data);


  /*var dataString='fname='+ name +'sname='surname;

    $.ajax({

        method:"post",
        url:"insert.php",
        data:dataString,
        success:function(data){
         $("#view").html(data);
        }


    
*/

});
});
});


</script>
</body>
</html>




insert.php


<?php
$con=mysqli_connect('localhost','root','root','insert');

    if (isset($_POST['fname']) && isset($_POST['sname'])) {
      
          $name=$_POST['fname'];
          $surname=$_POST['sname'];

      $query=mysqli_query($con,"insert into db_insert(name,surname) values('$name','$surname')") or die(mysqli_error($con));

      if($query)
      {
        echo "record inserted successfully";
      }
      else {
       echo "failed";
      }

    }
    



?>


Comments

Post a Comment

Popular posts from this blog

How to Delete record using PHP Ajax

-
index.php ?   01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 <!DOCTYPE html> <html> <head>      <title></title> </head> <body>   <?php        $connection = mysqli_connect( "localhost" , "root" , "" , "db_2018" ) or die (mysqli_error());        $ReadSql = "SELECT * FROM `crud`" ;      $res = mysqli_query( $connection , $ReadSql );   ?>     <table>      <tr>          <th>name</th>          <th>Last Name</th>          <th>email id</th>     ...
Read more

How to seperate character from string in php

-
?   1 2 3 4 5 6 7 8 9 $string = "abcdef" ; $result =[]; $strlen = strlen ( $string ); for ( $i =0; $i < $strlen ; $i ++) {      $result [ $i ]= $string [ $i ];   } print_r( $result );     $string = "abcdef"; $result=[]; $strlen = strlen($string); for($i=0;$i<$strlen;$i++) { $result[$i]=$string[$i]; } print_r($result);
Read more
-
 <?php function numberToWords($num) {     $ones = array(         0 => "zero",         1 => "one",         2 => "two",         3 => "three",         4 => "four",         5 => "five",         6 => "six",         7 => "seven",         8 => "eight",         9 => "nine",         10 => "ten",         11 => "eleven",         12 => "twelve",         13 => "thirteen",         14 => "fourteen",         15 => "fifteen",         16 => "sixteen",         17 => "seventeen",         18 => "eighteen",         19 => "nineteen"   ...
Read more