Updating single item in a basket with multiple items using php and My Sql -


i making shopping basket website , stuck on updating quantities, have database conected , basket being generated basket table, have loop displays products in users basket , produces form each product generating textbox user can enter quanitity , click submit. have seperate file called updatebasket excutes update statement using gameid in whereclause. having trouble sending gameid each product on updatebasket file when update button clicked. here code below.

this cart.php file

cart.php <?php require "dbconnect.php"; session_start(); $memberid = $_session['id'];   $query = "select rectable.gameid, rectable.gameimg, rectable.gameprice, rectable.gamename rectable, basket rectable.gameid = basket.gameid , basket.id = '".$memberid."'";  $results = $connect->query($query); $numrow = $results->num_rows;  $count = 0; while ($count < $numrow) { $row = $results -> fetch_assoc(); extract($row); echo"<div>"; echo"<div class='recommended_games'>";     echo "<img src='images/".$gameimg."' />"; echo "</div>";   echo '<div class="price_tag">';     echo '<div class="price_tag">£'.$gameprice. '</div>'; echo'</div>';  echo '<div id="update_form"><form action="updatebasket.php" method="post" name="updateform">'; echo  '<input type="text" value="1" name="quantity" id="quantity" />'; echo '<input type="text" value="'.$gameid.'" name="'.$gameid.'" id="gameid" />'; echo    '<input type="submit" value="update" />'; echo '</form>'; echo '</div>';                                              echo"<img class='box1' src='images/grey-banners.png' />"; echo"</div>"; $count = $count + 1;         }         ?>

this updatebasket.php file

updatebasket.php <?php session_start(); require "dbconnect.php";  $memberid = $_session['id'];   $quantity = $_post['quantity']; $gameid = $_post['gameid'];  $query = "update basket set quantity = '".$quantity."' gameid = '".$gameid."' , id = '".$memberid."' "; header('location: cart.php') ?>


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more