jquery - Why am getting error with ajax request PHP? -
i want make , dislike vote in php , ajax jquery .
the problem is, if clicked or dislike getting error in response.
let me first show table query created:
create table if not exists `our_productions` ( `id` int(11) not null auto_increment, `title` varchar(255) collate utf8_unicode_ci not null, `youtube_url` varchar(255) collate utf8_unicode_ci not null, `like_num` bigint(10) not null, `dislike_num` bigint(10) not null, primary key (`id`) ) engine=innodb default charset=utf8 collate=utf8_unicode_ci auto_increment=3 ; and here php snippets order:
db.php
<?php class tutorial{ function __construct(){ //db details $db_host = 'localhost'; $db_user = 'root'; $db_pass = '123456'; $db_name = 'productions'; //connect db $con = mysql_connect($db_host, $db_user, $db_pass); mysql_set_charset('utf8'); //select db mysql_select_db($db_name, $con); } function get_rows($id = ''){ if($id != ''){ //fetch single row $query = mysql_query("select * our_productions id = $id"); $data = mysql_fetch_assoc($query); }else{ //fetch rows $query = mysql_query("select * our_productions"); while($row = mysql_fetch_assoc($query)){ $data[] = $row; } } return $data; } function insert($data = array()){ $data_array_num = count($data); $columns = ""; $values = ""; $i=0; foreach($data $key=>$val){ $i++; $sep = ($i == $data_array_num)?"":", "; $columns .= $key.$sep; $values .= $val.$sep; } $insert = mysql_query("insert our_productions ($columns) values ($values)"); return $insert?true:false; } function update($data = array(), $conditions = array()){ $data_array_num = count($data); $cols_vals = ""; $condition_str = ""; $i=0; foreach($data $key=>$val){ $i++; $sep = ($i == $data_array_num)?'':', '; $cols_vals .= $key."='".$val."'".$sep; } foreach($conditions $key=>$val){ $i++; $sep = ($i == $data_array_num)?"":" , "; $condition_str .= $key."='".$val."'"; } $update = mysql_query("update our_productions set $cols_vals $condition_str"); return $update?true:false; } } ?> votes.php
<?php include_once("db.php"); $tutorial = new tutorial(); if(isset($_post['id']) != '' && isset($_post['type']) != ''){ //previous tutorial data $prev_record = $tutorial->get_rows($_post['id']); //previous total likes $prev_like = $prev_record['like_num']; //previous total dislikes $prev_dislike = $prev_record['dislike_num']; //calculates numbers of or dislike if($_post['type'] == 1){ $like = ($prev_like + 1); $dislike = $prev_dislike; $return_count = $like; }else{ $like = $prev_like; $dislike = ($prev_dislike + 1); $return_count = $dislike; } //store update data $data = array('like_num'=>$like,'dislike_num'=>$dislike,'modified'=>date("y-m-d h:i:s")); //update condition $condition = array('id'=>$_post['id']); //update tutorial dislike $update = $tutorial->update($data,$condition); //return or dislike number if update successful, otherwise return error echo $update?$return_count:'err'; } ?> and index.php
<?php include_once("db.php"); $tutorial = new tutorial(); $trows = $tutorial->get_rows(); ?> <script src="js/jquery-1.11.1.min.js"></script> <script type="text/javascript"> function voting(id,type,target){ $.ajax({ type:'post', url:'votes.php', data:'id='+id+'&type='+type, success:function(msg){ if(msg == 'err'){ alert('some problem occured, please try again.'); }else{ $('#'+target).html(msg); } } }); } </script> <?php foreach($trows $trow){ ?> <div id="content" class="full-width flush-top flush-bottom"> <article class="post-2037 post type-post status-publish format-standard hentry category-aerial category-blog tag-4120 tag-aerial tag-dslr tag-film tag-fortyonetwenty tag-highlight tag-production tag-san-diego tag-video tag-videography tag-vulcan-uav"> <div class="full-width red timestamp"> <h2 class="month">jan</h2> <h2 class="year">2016</h2> </div> <div class="full-width"> <div class="container"> <header> <time class="day"><?php echo $trow['id']; ?></time> <h2 class="post-title"><a><?php echo $trow['title']; ?></a></h2> </header> <div class="entry"> <div class="fve-video-wrapper vimeo" style="padding-bottom:56.25%;"> <iframe width="560" height="315" src="<?php echo $trow['youtube_url']; ?>" frameborder="0" allowfullscreen></iframe> </div> <p style="text-align: left;">lorem ipsum dolor sit amet, consectetur adipisicing elit, sed eiusmod tempor incididunt ut labore et dolore magna aliqua. ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p> </div> <footer class="social-blog"> <!-- icon html --> <span class="glyphicon glyphicon-thumbs-up" onclick="voting(<?php echo $trow['id']; ?>,1,'like_count<?php echo $trow['id']; ?>')"></span> <!-- counter --> <span class="counter" id="like_count<?php echo $trow['id']; ?>"><?php echo $trow['like_num']; ?></span> <!-- dislike icon html --> <span class="glyphicon glyphicon-thumbs-down" onclick="voting(<?php echo $trow['id']; ?>,0,'dislike_count<?php echo $trow['id']; ?>')"></span> <!-- dislike counter --> <span class="counter" id="dislike_count<?php echo $trow['id']; ?>"><?php echo $trow['dislike_num']; ?></span> </footer> </div> </div> </article> </div> <?php } ?> eventually, getting in place, getting err in response when voting, please !!!
it looks
$data = array('like_num'=>$like,'dislike_num'=>$dislike,'modified'=>date("y-m-d h:i:s")); is setting field named 'modified, there no 'modified' in table definition.
Comments
Post a Comment