jquery - Data is not inserting to database but retrieving is working fine using PHP and Ajax? -


before ask question want clarify i'm rookie ajax , jquery, please spare me if doubt small or piece of cake, sorry that.

i'm trying create review system e-commerce using ajax , php. problem is, data not inserting in database, if insert the data manually in database displaying in site.i think there going wrong variable review or user_review couldn't find is.so, please tell me i've done mistake.

<div role="tabpanel" class="tab-pane" id="reviews">     <h4>write review</h4>     <form action="" method="post" onsubmit="return post();">         <textarea id="review" class="reviewbox" placeholder="write review here....."></textarea>         <button type="submit" class="btn">submit</button>     </form>     <div id="all_reviews">         <?php                             $query = $pdo->prepare("select * reviews product_id=?");                             $query -> bindvalue(1, $id);                             $query->execute();                             while ($row = $query->fetch(pdo::fetch_assoc))                             {                                 $name = $row['user_name'];                                 $text = $row['review_text'];                                 $time = $row['post_time'];                         ?>             <h5>by <?php echo $name; ?></h5>             <p><i>posted on <?php echo $time; ?></i></p>             <p>                 <?php echo $text; ?>             </p>             <hr>             <?php                             }                         ?>     </div>     <script type="text/javascript" src="jquery.js">     < script type = "text/javascript" >         function post() {             var review = document.getelementbyid("review").value;             if (review) {                 $.ajax({                     type: 'post',                     url: 'post_reviews.php',                     data: {                         user_review: review                     },                     success: function(response) {                         document.getelementbyid("all_reviews").innerhtml = response + document.getelementbyid("all_reviews").innerhtml;                         document.getelementbyid("review").value = "";                     }                 });             }             return false;         }     </script> </div>

this post_reviews.php:

 <?php     session_start();     require('includes/product.php');     require('includes/connect.php');     $product = new product;              if(isset ($_get['id'])) {         $id = $_get['id'];         $data = $product -> fetch_data($id);              if(isset($_post['user_review'])){             $review=$_post['user_review'];             if (isset($_session['logged_in'])) {                 $query = $pdo -> prepare("insert reviews(product_id,user_name,review_text) values (?,?,?)");                 $query -> bindvalue(1, $id);                 $query -> bindvalue(2, $_session['name']);                 $query -> bindvalue(3,$review);                 $query ->execute();             }             else{                 $review_msg="please login post review";             }             $query = $pdo->prepare("select * reviews product_id=?");             $query -> bindvalue(1, $id);             $query->execute();             while ($row = $query->fetch(pdo::fetch_assoc)){                 $name = $row['user_name'];                 $text = $row['review_text'];                 $time = $row['post_time']; ?>                 <?php if(isset($review_msg)){ ?>                     <small style = "color : #aa0000"; ><?php echo $review_msg ?></small>                     <br><br>                 <?php } ?>                 <h5>by <?php echo $name; ?></h5>                 <p><i>posted on <?php echo $time; ?></i></p>                 <p><?php echo $text; ?></p>                 <hr> <?php              }         }         exit;     } ?>

there mistake have done script code not closed 

 <script type="text/javascript" src="jquery.js">

to

 <script type="text/javascript" src="jquery.js"></script>

that reason ajax not working.


Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more