codeigniter - Why is this page remembering PHP variables from the last page? -


i've made button on site (which uses expressionengine), , works. when put identical code on page, button's text should have been on last page (the opposite should be, though refreshing page puts right, can't flip values. here's code works:

<?php $db1 = $this->ee->load->database('ext_db', true); $mapid = "{entry_id}"; $ipaddress = $_server['remote_addr']; $thisquery = "select * maplikes ipaddress = '$ipaddress' , mapid = '$mapid'"; $q = $db1->query($thisquery); $results = $q->result_array(); foreach ($q->result() $row) {     $liked = $row->liked; } $buttontext = 'like'; $buttonimage = "1"; if ($liked == "1") {     $buttontext = 'unlike';     $buttonimage = "2"; }  if($_post['like']) {     if ($liked == "1") {         $thisquery = "delete maplikes mapid = '$mapid' , ipaddress = '$ipaddress'";         $db1->query($thisquery);     } else {         $thisquery = "insert maplikes (maplikeid, mapid, liked, ipaddress) values ('null', '$mapid', '1', '$ipaddress')";         $db1->query($thisquery);     } } ?>

and code doesn't:

<?php $db1 = $this->ee->load->database('ext_db', true); $mapid = "{segment_3_category_id}"; $ipaddress = $_server['remote_addr']; $thisquery = "select * categorylikes ipaddress = '$ipaddress' , mapid = '$mapid'"; $q = $db1->query($thisquery); $results = $q->result_array(); foreach ($q->result() $row) {     $liked = $row->liked; } $buttontext = 'like'; $buttonimage = "1"; if ($liked == "1") {     $buttontext = 'unlike';     $buttonimage = "2"; }  if($_post['like']) {     if ($liked == "1") {         $thisquery = "delete categorylikes mapid = '$mapid' , ipaddress = '$ipaddress'";         $db1->query($thisquery);     } else {         $thisquery = "insert categorylikes (categorylikeid, mapid, liked, ipaddress) values ('null', '$mapid', '1', '$ipaddress')";         $db1->query($thisquery);     } } ?>

as can see, difference between 2 pieces of code $mapid , queries. yet reason 1 works , other doesn't. have idea might going on? i'm thinking more php problem expressionengine one.

the real question, think, why first example work...

you setting state of button based on current value of $liked, if $_post['like'] set, you're changing state of system , button incorrect. if switch code around , test $_post['like'] first, set value of $like after act on it, button show correct state.


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more