mysql - PHP Session Variable lost after click on page other category -

-

i have 1 site such olx.com used product buy , sell, index page has city filter drop down list, once user clicks filter see product filter city , redirect page city_filter.php till working, after city filter when user click on categories such computer or electronics user not found product, categories coming mysql database, city_filter.php included function_city.php calling function categories, please find city_filter.php function created on function_city.php follow:

function displaycomputer_city(){                  global $con;                 $get_cats = "select * categories categories_id = 1";                 $run_cats = mysqli_query($con, $get_cats);                  while ($row_cats=mysqli_fetch_array($run_cats)) {                  $computer_id = $row_cats['categories_id'];                 $computer_title = $row_cats['categories_name'];                       echo "<li><a href='city_filter.php?computer_cat=$computer_id'>$computer_title</a></li>";                  }           }

on city_filter.php page, when click computer take on browser computer_cat=id , using mention function filter computer filter city

function getcomputerpro_city() {          global $con;         global $eu;         global $limit;            if(isset($_get['computer_cat'])){                             $cat_id = $_get ['computer_cat'];    $get_products = "select product_list.*, city1.* product_list inner join city1 on product_list.city_id=city1.city_id , product_list.city_id={$_sesseion['city_id']} , categories_id='$cat_id' limit $eu, $limit";  foreach ($con->query($get_products) $row) {  echo "<div class='ser-grid-list'> <h5>$row[product_title]</h5>     <img src='admin_area/product_images/$row[image_1]' width='160' height='110' alt=''>     <p>price : $row[currency] $row[product_price]</p>     <p>city : $row[city_name]</p>     <p>date : $row[date]</p>     <div class='btn top'><a href='details.php?pro_id=$row[list_id]'>view more</a></div> </div>"; }    }        }

i think not going correct why, because noticed when click on computer categories takes computer_cat = id on receive using method, , once click categories city id session lost, don't practice type of situation.

if have included session_start(); in start of every page , if have not unset/destroyed sessions, have typo here:

change this:

$get_products = "select product_list.*, city1.* product_list inner join city1 on product_list.city_id=city1.city_id , product_list.city_id={$_sesseion['city_id']} , categories_id='$cat_id' limit $eu, $limit";

to this:

$get_products = "select product_list.*, city1.* product_list inner join city1 on product_list.city_id=city1.city_id , product_list.city_id={$_session['city_id']} , categories_id='$cat_id' limit $eu, $limit";

Comments

Post a Comment

Popular posts from this blog

html - Firefox flex bug applied to buttons? -

-
i'm trying apply flex button on firefox i'm having problem on chrome doesn't happens. this css: .button { display: inline-flex; align-items: center; } as can see in fiddle, "caret" word moved new line, happens if element <button> tag, <div> works expected. http://codepen.io/anon/pen/xblmgx is firefox bug or there css i'm missing? nevermind, looks "mr firefox" doesn't idea... <button> not implementable (by browsers) in pure css, bit of black box, perspective of css. means don't react in same way e.g. <div> would. this isn't specific flexbox -- e.g. don't render scrollbars if put "overflow:scroll" on button, , don't render table if put "display:table" on it. stepping further, isn't specific <button> . consider <fieldset> , <table> have special rendering behavior: data:text/html,<fieldset style="d
Read more

html - Missing border-right in select on Firefox -

-
Image
when put select div width , padding-left, options have no border on right. more, happend if select have width 118px , parent have 15px of padding left! have idea, going on? my code: <!doctype html> <html> <head lang="en"> </head> <body> <div style="width: 1000px; padding-left: 15px;"> <select style="width: 118px;"> <option>a</option> <option>b</option> <option>c</option> </select> </div> </body> </html> and result: here plunker: click it happend on firefox on windows. tested on 40.0.2 version -webkit-box-sizing: border-box; -moz-box-sizing: border-box; -ms-box-sizing: border-box; box-sizing: border-box; source: https://stackoverflow.com/a/11390432/4431269 source of problem: https://bugzilla.mozilla.org/show_bug.cgi?id=924068 and use of google ! edit: (source of problem, explained) after rea
Read more

c# - two queries in same method -

-
i trying execute 2 queries in same method gives me exception. can red of exception declaring new command there way use same command? string id="hi"; connection.open(); oledbcommand command1 = new oledbcommand(); command1.connection = connection; string query1 = "select * products category='" + combobox1.text + "' , subcategory = '" + combobox2.text + "' , sizes='" + combobox3.text + "'"; command1.commandtext = query1; oledbdatareader reader = command1.executereader(); while (reader.read()) { id = reader[0].tostring(); } textbox1.text = id; string query = "insert category_in (category_id,amount,amount_in) values ('"+ id+"' ,500,300)"; command1.commandtext = query; command1.executenonquery(); messagebox.show("saved"); connection.close();
Read more