php - UPDATE don't work in database -


i have problem: when submit form page refresh , not update database.. :ss

<? error_reporting(0); require('cdn/inc/header.php');   if(isset($_session['user_data'])): $user_level = $_session['user_data']['level'];   switch($user_level): case 1: case 2:  case 3:  case 5: case 8: case 9:  $query = "select * testes id = :id"; $result = $db->prepare($query); $result->execute(array(':id' => $_request['id']) ); if ($row = $result->fetch(pdo::fetch_assoc)) {  ?>   <form action="<?php echo $_server['php_self']; ?>" method="post">     <input id="title" type="text" name="title" value="<?php echo $row['title']; ?>" required />    <input type="hidden" name="id" value="<?php echo $row['id']; ?>" />  <input type="submit" name="submit" value="salvar alterações" /> </form>  <?   }   elseif (isset($_post['submit'])) {  $id = $_post['id'];    $title = $_post['title'];    $queryupdate = "update testes set tile = :title id= :id";     $q = $db->prepare($queryupdate);  $q->execute(array(":title" => $title, ":id" => $id));  header ('location: edit.php');}    else {  $stmt = $db->query("select * testes order str_to_date(date, '%d-%m-%y') asc, title asc);  $stmt->execute();  $data = $stmt->fetchall(pdo::fetch_assoc);?>   <div id="user-bar" style="background: #c16011;">   <i>    <a href="add.php">adicionar</a>   </i>  </div>   <br />  <br />   <?  foreach($data $index => $row) {   $classname = $index % 2 == 0 ? "class" : "class-1" ?>  <form action="" name="inser" method="post">  <div class="selector">   <input name="selector[]" class="selector" type="checkbox" value="<?php echo $row['id']; ?>" />  </div>     <a href="edit.php?id=<? echo $row['id']; ?>"><? echo $row['title']; ?></a>      </div>   </h6>  </div>  <?  }  if(empty($data)){?>   <div class="no-data">   data/hora: <b><?echo date("d-m-y");?></b>/<b><? echo date("h:i");?></b>  <br />   sem nada  </div>  <?} else {?>   <div class="btn-padding">   <div class="btn-group dropup pull-right">    <button type="button" class="btn btn-primary">seleciona uma acção</button>    <button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-expanded="false">     <span class="caret"></span>     <span class="sr-only"></span>    </button>    <ul class="dropdown-menu dropdown-menu-right" role="menu">     <li><a href="" class="selectall-button" onclick="return false;">selecionar tudo / nao selecionar</a></li>     <li class="divider"></li>     <li><a href="#" type="submit" class="delete-button"onclick="javascript:document.insert.submit();">eliminar</a></li>    </ul>   </div>  </div> </form>    <?  }  $edittable=$_post['selector'];  $n = count($edittable);  for($i=0; $i < $n; $i++)  {  $result = $db->prepare("delete testes id= :id");  $result->bindparam(':id', $edittable[$i]);  $result->execute();  header ('location: edit.php');   }  }  ?>   <br />  <br />   <center>   <small>teste.</small>  </center>   </body> </html>  <? break;  endswitch;  else:  header( 'location: ../ ');  endif; ?>

anyone knows how can fix this? dont have ideia how can solve this, tried everything, problem continue..

when form submitted, same php file executed again. have check $session , $post first , action it, before else including spitting out form headers.


Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more