Untitled

<!doctype html>

<?php
require_once('get.php');

?>

<html class="no-js" lang="en">
<head>
  <meta charset="utf-8">

  <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">

  <title></title>
  <meta name="description" content="">


  <meta name="viewport" content="width=device-width">


</head>
<body>
  <div id="wrap-body">


    <form action="" method="post">
      <input type="text" name="username" id="username">

      <input type="text" name="msg" id="msg">

      <input type="button" id="submit" value="Send">

    </form>


    <div id="info">


    </div>
  </div>


  <script src="//ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
  <script>window.jQuery || document.write('<script src="js/jquery-1.7.2.min.js"><\/script>')</script>
  <script src="js/login.js"></script>


  <script>
    var _gaq=[['_setAccount','UA-XXXXX-X'],['_trackPageview']];
    (function(d,t){var g=d.createElement(t),s=d.getElementsByTagName(t)[0];
    g.src=('https:'==location.protocol?'//ssl':'//www')+'.google-analytics.com/ga.js';
    s.parentNode.insertBefore(g,s)}(document,'script'));
  </script>
</body>

<script>
$(document).ready(function (){


  $('#submit').click(function (){
     var username = $('#username').val();
      var msg = $('#msg').val();

     $.ajax({
                type: 'POST',
                url: 'get.php',
                dataType: 'json',
                data:{'username': username, 'msg':msg},
                success: function (data){

                   $.each(data, function(i,item) {

                     $('#info').append("<p> you are:"+data[i].username+"</p> <p> your message  is:"+data[i].mesg);

                   });

                }
            });

  });


});


</script>


</html>

PHP:

<?php

$host='localhost';
$username='root';
$password='12345';
$db = 'feeds';


$connect = mysql_connect($host,$username,$password) or die("cant connect");
mysql_select_db($db) or die("cant select the".$db);


$username = $_POST['username'];

$msg = $_POST['msg'];

$insert = "INSERT INTO info(user_name,message) VALUES('$username','$msg')";

	if(@!mysql_query($insert)){

		die('error insertion'.mysql_error());

	}


$get = "SELECT * FROM info ";

$result=mysql_query($get)or die(mysql_error());


$inside_counter =   mysql_num_rows($result);


$data=array();
while ($row = mysql_fetch_array($result))
{
$data[] = array(
   'username'=>$row['user_name'],
   'mesg'=>$row['message'],
   'counter'=>$inside_counter
);
}

echo json_encode($data);


?>