php - Trying to send star ratings from krajee bootstrap star rating to mysql database -


i using following plugin

http://plugins.krajee.com/star-rating

i'm trying send rating submitted database values not being recorded. 

require_once $doc_root . '/includes/act_initiate_article_xref.php';      $rating_value = (@$user_article_xref_row['rating'] > 0) ? $user_article_xref_row['rating'] . ' stars' : 'unrated';     $article_rating = '<span class="line-sep">rated:</span> ' . $rating_value; if ($_session['user_id'] == 1 || $_session['user_id'] == 41)    {     $rating_value_attr = (isset ($user_article_xref_row['rating'])) ? ' value="' . $user_article_xref_row['rating'] . '"' : '';     $article_rating .= '<span class="line-sep">your rating: </span> <input id="input-21d" type="number" class="rating"' . $rating_value_attr . ' data-min=0 data-max=5 step=0.5 data-size="xs">'; }

and code act_initiate_article_xref.php

<?  /**  * reads user_article_xref  */ $this_routine[] = "includes/act_initiate_article_xref.php";  /**  * no direct access allowed  */ $doc_root = $_server['document_root']; require_once $doc_root . '/includes/act_check_valid_access.php';  $table_title = 'user_article_xref';  $user_id = (isset ($_session['user_id'])) ? $_session['user_id'] : 0;  $fields = '`id`, `hits`, `rating`'; $match_where = '`user_id` = ' . $user_id . ' , `article_id` = ' . $article_id; $article_result = $db->selectbystrings($fields, $table_title, $match_where, null, 1); #if ($_session['user_id'] == 1) { echo "<br>21. select $fields $table_title $match_where<pre>";print_r($_session);echo "</pre>"; }  /**  * if there record, update  * if there isn't record, insert  * either way, $user_article_xref_row holds details ajax rating update  */ if ($db->getnumrows($article_result) > 0)   {     $user_article_xref_row = $db->getnextrow($article_result);     $hits = $user_article_xref_row['hits'] + 1;     $pairs_array = array ('hits' => $hits);     $id_where = '`id` = ' . $user_article_xref_row['id'];     $update_result = $db->updatebyarray($table_title, $pairs_array, $id_where);     $test = 'update'; } else {     $hits = 1;     $user_article_xref_row = array ('user_id' => $user_id, 'article_id' => $article_id, 'hits' => $hits);     $insert_result = $db->insertbyarray($table_title, $user_article_xref_row);     $test = 'insert'; } #if ($_session['user_id'] == 1) { echo "<br>37. $test<pre>";print_r($user_article_xref_row);echo "</pre>"; }  ?>

i know post little old in case. in star-rating.js added ajax post php file set.listenclick function. hope helps.

self.listenclick(self.$rating, function(e) {                 if (self.inactive) {                     return false;                 }                 pos = self.getposition(e);                 var div_id = self.$element.attr('id');                 self.setstars(pos);                 self.$element.trigger('change').trigger('rating.change', [self.$element.val(), self.$caption.html()]);                 self.starclicked = true;                 var rating = self.$element.val();                 $.ajax({                 type:"post",                 url:"rating.php",                 data:"div="+div_id+"&rating="+rating,                 success: function(res){                  console.log("rating posted " + div_id + rating);                                              return res;                 }             });             });

Comments

Post a Comment

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

i'm looking dynamically populate select element names of items stored array. for reason it's not working , i'm not sure why. html: <div class="col-md-4 col-md-offset-4"> <select class="select1"> </select> , <select class="select2"> </select> </div> note i'm using bootstrap layout. here's jquery i'm using try , populate ".select1" jquery: select: function() { $.each(state.greens, function(index, value) { $(".select1").append("<option value =' " + index + " '>" + state.greens[index].name + "</option>"); }); } note function 'select' stored within object called 'display'. state.greens name of array i'm trying access. so @ end of html page call display.select(); call function. no error messages showing in console. also, saw question: appending ...
Read more

Android soft keyboard reverts to default keyboard on orientation change -

i'm building android soft keyboard , can't seem fix bug - have arabic , qwerty keyboard , when rotate device on qwerty keyboard (or arabic shift), it's if program has "restarted" , becomes arabic keyboard without shift. the onsaveinstancestate(bundle savedinstancestate) not work because application not extend activity inputmethodservice . i put following in android manifest android:configchanges="keyboard|keyboardhidden|orientation" android:windowsoftinputmode="stateunchanged|adjustresize"> i tried using @override public void onconfigurationchanged(configuration newconfig) { super.onconfigurationchanged(newconfig); log.i(mydebug, "config changed " + currentkeyboard.equals(qwerty)); } however, currentkeyboard.equals(qwerty)) results false , made sure true before orientation change. any appreciated. i think applications fault. if application restarting on orientation change...
Read more

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -

i rendering jbutton image on simulate jcheckbox behavior. why don't let jtable render jcheckbox? because need bigger checkboxes , there's no way can resize them (as far know). so, have own table cell renderer , editor. both renders jbutton , checkbox images on them. trying change image checked image unchecked image (or vice versa) , update cell value (boolean true or false). however, reason, getcelleditorvalue() not update table. so, release mouse, value goes original one. any appreciated! lot! public class tableexample extends jframe { jscrollpane pane; jpanel panel; jtable table; object[][] data; mytablemodel tm; renderer buttoncolumn; public tableexample(object[][] data) throws ioexception { string[] columns = {"column#1", "column#2", "column#3", "column#4", "column#5", "column#6"}; this.data = data; this.setpreferredsize(new dimension(700, 500)); ...
Read more