using Ajax to insert and fetch the data insert is working but fetch function is not working












0















I'm using ajax insert and fetch the data from the database, insert is working perfectly but fetching part is not working give a feedback to fix this issues.



<script>
$(document).ready(function(){
$("#button").click(function(e){
e.preventDefault();
var postId=$("#postId").val();
var userId=$("#userId").val();
var postComm=$("#postComments").val();

$.ajax({
url:'../validate/inserPostComm.php',
method:'POST',
data:{
poId:postId,
usId:userId,
poco:postComm
},
success:function(data){
//alert(data);
displayFromDatabase();
$("#postComments").val('');
}
});
});
});

function displayFromDatabase(){
var postId=$("#postId").val();
alert(postId);
$.ajax({
url: "../validate/getComments.php",
type: "POST",
async: false,
data: {
poId:postId,
},
success: function(data){
('#display_area').html(data);
}
});
}
</script>


and this my html code to retrieve the fetching details from database.



<li>
<div id="display_area">

</div>
</li>
<button type="button" id="button"><i class="fa fa-paper-plane"></i></button>


and also i attached my php code through the ajax i'm passing the id and i'm get the details according to the id.



$postId=$_POST["poId"];

$getPostCom=$postComments->getPostComm($postId,"../");

while($PostComments=mysqli_fetch_assoc($getPostCom))
{

?>


<div class="comet-avatar">
<img src="<?php echo $PostComments["u_image"]; ?>" alt="">
</div>
<div class="we-comment">
<div class="coment-head">
<h5><a href="user-profile.php?user_id=<?php echo $PostComments["u_id"]; ?>" title=""><?php echo $PostComments["u_fname"]; ?> <?php echo $PostComments["u_lname"]; ?></a></h5>
</div>
<p><?php echo $PostComments["p_comments"]; ?></p>
</div>

<?php
}
exit();
?>









share|improve this question




















  • 2





    There is no element with the id button in your code. Provide a Minimal, Complete, and Verifiable example

    – Quentin
    Nov 16 '18 at 12:02






  • 1





    You missed $ in the success block

    – Akshit Ahuja
    Nov 16 '18 at 12:10











  • Did you look at the error in your developer console?

    – epascarello
    Nov 16 '18 at 14:32


















0















I'm using ajax insert and fetch the data from the database, insert is working perfectly but fetching part is not working give a feedback to fix this issues.



<script>
$(document).ready(function(){
$("#button").click(function(e){
e.preventDefault();
var postId=$("#postId").val();
var userId=$("#userId").val();
var postComm=$("#postComments").val();

$.ajax({
url:'../validate/inserPostComm.php',
method:'POST',
data:{
poId:postId,
usId:userId,
poco:postComm
},
success:function(data){
//alert(data);
displayFromDatabase();
$("#postComments").val('');
}
});
});
});

function displayFromDatabase(){
var postId=$("#postId").val();
alert(postId);
$.ajax({
url: "../validate/getComments.php",
type: "POST",
async: false,
data: {
poId:postId,
},
success: function(data){
('#display_area').html(data);
}
});
}
</script>


and this my html code to retrieve the fetching details from database.



<li>
<div id="display_area">

</div>
</li>
<button type="button" id="button"><i class="fa fa-paper-plane"></i></button>


and also i attached my php code through the ajax i'm passing the id and i'm get the details according to the id.



$postId=$_POST["poId"];

$getPostCom=$postComments->getPostComm($postId,"../");

while($PostComments=mysqli_fetch_assoc($getPostCom))
{

?>


<div class="comet-avatar">
<img src="<?php echo $PostComments["u_image"]; ?>" alt="">
</div>
<div class="we-comment">
<div class="coment-head">
<h5><a href="user-profile.php?user_id=<?php echo $PostComments["u_id"]; ?>" title=""><?php echo $PostComments["u_fname"]; ?> <?php echo $PostComments["u_lname"]; ?></a></h5>
</div>
<p><?php echo $PostComments["p_comments"]; ?></p>
</div>

<?php
}
exit();
?>









share|improve this question




















  • 2





    There is no element with the id button in your code. Provide a Minimal, Complete, and Verifiable example

    – Quentin
    Nov 16 '18 at 12:02






  • 1





    You missed $ in the success block

    – Akshit Ahuja
    Nov 16 '18 at 12:10











  • Did you look at the error in your developer console?

    – epascarello
    Nov 16 '18 at 14:32
















0












0








0








I'm using ajax insert and fetch the data from the database, insert is working perfectly but fetching part is not working give a feedback to fix this issues.



<script>
$(document).ready(function(){
$("#button").click(function(e){
e.preventDefault();
var postId=$("#postId").val();
var userId=$("#userId").val();
var postComm=$("#postComments").val();

$.ajax({
url:'../validate/inserPostComm.php',
method:'POST',
data:{
poId:postId,
usId:userId,
poco:postComm
},
success:function(data){
//alert(data);
displayFromDatabase();
$("#postComments").val('');
}
});
});
});

function displayFromDatabase(){
var postId=$("#postId").val();
alert(postId);
$.ajax({
url: "../validate/getComments.php",
type: "POST",
async: false,
data: {
poId:postId,
},
success: function(data){
('#display_area').html(data);
}
});
}
</script>


and this my html code to retrieve the fetching details from database.



<li>
<div id="display_area">

</div>
</li>
<button type="button" id="button"><i class="fa fa-paper-plane"></i></button>


and also i attached my php code through the ajax i'm passing the id and i'm get the details according to the id.



$postId=$_POST["poId"];

$getPostCom=$postComments->getPostComm($postId,"../");

while($PostComments=mysqli_fetch_assoc($getPostCom))
{

?>


<div class="comet-avatar">
<img src="<?php echo $PostComments["u_image"]; ?>" alt="">
</div>
<div class="we-comment">
<div class="coment-head">
<h5><a href="user-profile.php?user_id=<?php echo $PostComments["u_id"]; ?>" title=""><?php echo $PostComments["u_fname"]; ?> <?php echo $PostComments["u_lname"]; ?></a></h5>
</div>
<p><?php echo $PostComments["p_comments"]; ?></p>
</div>

<?php
}
exit();
?>









share|improve this question
















I'm using ajax insert and fetch the data from the database, insert is working perfectly but fetching part is not working give a feedback to fix this issues.



<script>
$(document).ready(function(){
$("#button").click(function(e){
e.preventDefault();
var postId=$("#postId").val();
var userId=$("#userId").val();
var postComm=$("#postComments").val();

$.ajax({
url:'../validate/inserPostComm.php',
method:'POST',
data:{
poId:postId,
usId:userId,
poco:postComm
},
success:function(data){
//alert(data);
displayFromDatabase();
$("#postComments").val('');
}
});
});
});

function displayFromDatabase(){
var postId=$("#postId").val();
alert(postId);
$.ajax({
url: "../validate/getComments.php",
type: "POST",
async: false,
data: {
poId:postId,
},
success: function(data){
('#display_area').html(data);
}
});
}
</script>


and this my html code to retrieve the fetching details from database.



<li>
<div id="display_area">

</div>
</li>
<button type="button" id="button"><i class="fa fa-paper-plane"></i></button>


and also i attached my php code through the ajax i'm passing the id and i'm get the details according to the id.



$postId=$_POST["poId"];

$getPostCom=$postComments->getPostComm($postId,"../");

while($PostComments=mysqli_fetch_assoc($getPostCom))
{

?>


<div class="comet-avatar">
<img src="<?php echo $PostComments["u_image"]; ?>" alt="">
</div>
<div class="we-comment">
<div class="coment-head">
<h5><a href="user-profile.php?user_id=<?php echo $PostComments["u_id"]; ?>" title=""><?php echo $PostComments["u_fname"]; ?> <?php echo $PostComments["u_lname"]; ?></a></h5>
</div>
<p><?php echo $PostComments["p_comments"]; ?></p>
</div>

<?php
}
exit();
?>






javascript php jquery ajax






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 16 '18 at 12:04







Jerad

















asked Nov 16 '18 at 11:58









JeradJerad

829




829








  • 2





    There is no element with the id button in your code. Provide a Minimal, Complete, and Verifiable example

    – Quentin
    Nov 16 '18 at 12:02






  • 1





    You missed $ in the success block

    – Akshit Ahuja
    Nov 16 '18 at 12:10











  • Did you look at the error in your developer console?

    – epascarello
    Nov 16 '18 at 14:32
















  • 2





    There is no element with the id button in your code. Provide a Minimal, Complete, and Verifiable example

    – Quentin
    Nov 16 '18 at 12:02






  • 1





    You missed $ in the success block

    – Akshit Ahuja
    Nov 16 '18 at 12:10











  • Did you look at the error in your developer console?

    – epascarello
    Nov 16 '18 at 14:32










2




2





There is no element with the id button in your code. Provide a Minimal, Complete, and Verifiable example

– Quentin
Nov 16 '18 at 12:02





There is no element with the id button in your code. Provide a Minimal, Complete, and Verifiable example

– Quentin
Nov 16 '18 at 12:02




1




1





You missed $ in the success block

– Akshit Ahuja
Nov 16 '18 at 12:10





You missed $ in the success block

– Akshit Ahuja
Nov 16 '18 at 12:10













Did you look at the error in your developer console?

– epascarello
Nov 16 '18 at 14:32







Did you look at the error in your developer console?

– epascarello
Nov 16 '18 at 14:32














1 Answer
1






active

oldest

votes


















0














Yes this code working perfectly but i missed the $ in the success block.



<script>
$(document).ready(function(){
$("#button").click(function(e){
e.preventDefault();
var postId=$("#postId").val();
var userId=$("#userId").val();
var postComm=$("#postComments").val();

$.ajax({
url:'../validate/inserPostComm.php',
method:'POST',
data:{
poId:postId,
usId:userId,
poco:postComm
},
success:function(data){
//alert(data);
displayFromDatabase();
$("#postComments").val('');
}
});
});
});

function displayFromDatabase(){
var postId=$("#postId").val();
alert(postId);
$.ajax({
url: "../validate/getComments.php",
type: "POST",
async: false,
data: {
poId:postId,
},
success: function(data){
$('#display_area').html(data);
}
});
}
</script>





share|improve this answer
























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53337467%2fusing-ajax-to-insert-and-fetch-the-data-insert-is-working-but-fetch-function-is%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Yes this code working perfectly but i missed the $ in the success block.



    <script>
    $(document).ready(function(){
    $("#button").click(function(e){
    e.preventDefault();
    var postId=$("#postId").val();
    var userId=$("#userId").val();
    var postComm=$("#postComments").val();

    $.ajax({
    url:'../validate/inserPostComm.php',
    method:'POST',
    data:{
    poId:postId,
    usId:userId,
    poco:postComm
    },
    success:function(data){
    //alert(data);
    displayFromDatabase();
    $("#postComments").val('');
    }
    });
    });
    });

    function displayFromDatabase(){
    var postId=$("#postId").val();
    alert(postId);
    $.ajax({
    url: "../validate/getComments.php",
    type: "POST",
    async: false,
    data: {
    poId:postId,
    },
    success: function(data){
    $('#display_area').html(data);
    }
    });
    }
    </script>





    share|improve this answer




























      0














      Yes this code working perfectly but i missed the $ in the success block.



      <script>
      $(document).ready(function(){
      $("#button").click(function(e){
      e.preventDefault();
      var postId=$("#postId").val();
      var userId=$("#userId").val();
      var postComm=$("#postComments").val();

      $.ajax({
      url:'../validate/inserPostComm.php',
      method:'POST',
      data:{
      poId:postId,
      usId:userId,
      poco:postComm
      },
      success:function(data){
      //alert(data);
      displayFromDatabase();
      $("#postComments").val('');
      }
      });
      });
      });

      function displayFromDatabase(){
      var postId=$("#postId").val();
      alert(postId);
      $.ajax({
      url: "../validate/getComments.php",
      type: "POST",
      async: false,
      data: {
      poId:postId,
      },
      success: function(data){
      $('#display_area').html(data);
      }
      });
      }
      </script>





      share|improve this answer


























        0












        0








        0







        Yes this code working perfectly but i missed the $ in the success block.



        <script>
        $(document).ready(function(){
        $("#button").click(function(e){
        e.preventDefault();
        var postId=$("#postId").val();
        var userId=$("#userId").val();
        var postComm=$("#postComments").val();

        $.ajax({
        url:'../validate/inserPostComm.php',
        method:'POST',
        data:{
        poId:postId,
        usId:userId,
        poco:postComm
        },
        success:function(data){
        //alert(data);
        displayFromDatabase();
        $("#postComments").val('');
        }
        });
        });
        });

        function displayFromDatabase(){
        var postId=$("#postId").val();
        alert(postId);
        $.ajax({
        url: "../validate/getComments.php",
        type: "POST",
        async: false,
        data: {
        poId:postId,
        },
        success: function(data){
        $('#display_area').html(data);
        }
        });
        }
        </script>





        share|improve this answer













        Yes this code working perfectly but i missed the $ in the success block.



        <script>
        $(document).ready(function(){
        $("#button").click(function(e){
        e.preventDefault();
        var postId=$("#postId").val();
        var userId=$("#userId").val();
        var postComm=$("#postComments").val();

        $.ajax({
        url:'../validate/inserPostComm.php',
        method:'POST',
        data:{
        poId:postId,
        usId:userId,
        poco:postComm
        },
        success:function(data){
        //alert(data);
        displayFromDatabase();
        $("#postComments").val('');
        }
        });
        });
        });

        function displayFromDatabase(){
        var postId=$("#postId").val();
        alert(postId);
        $.ajax({
        url: "../validate/getComments.php",
        type: "POST",
        async: false,
        data: {
        poId:postId,
        },
        success: function(data){
        $('#display_area').html(data);
        }
        });
        }
        </script>






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 18 '18 at 5:26









        JeradJerad

        829




        829
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53337467%2fusing-ajax-to-insert-and-fetch-the-data-insert-is-working-but-fetch-function-is%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Bressuire

            Vorschmack

            Quarantine