Update multiple row by get value from check box in php [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the h开发者_如何学编程elp center. Closed 10 years ago.

Could you help me: I have three table :there are :users(userid,uername,password,groupid),group(groupid,groupname),menus(menuid,menuname),permissions(menuid,gorupid): I would like update to table:permission here my coding:

<?php
    require_once("includes/session.php");
    $post = (!empty($_POST)) ? true : false;
    if ($post)
 {

     require_once("includes/connection.php");
     require_once("includes/functions.php");
     //GET value from page user submited
   $groupname = mysql_prep($_POST['groupname']);
   $desc = mysql_prep($_POST['desc']);
   $st_val = mysql_prep($_POST['valstore']);//store as array ex:(1,2,3,4,5,);
  $store_del_exp = explode("," ,$st_val);
  $store_del_exp_count=count($store_del_exp);
  for($j=0; $j<$store_del_exp_count;$j++)
  {
     $t_id = trim($store_del_exp[$j]);
         $groupid = mysql_prep($_POST['groupid']);
          if($t_id>0){
             $sql = "UPDATE permissions SET menus_menuid ='$t_id' WHERE groups_groupid ='".(int)$groupid."'";
            $result = dbQuery($sql);
          }
  }
       if(mysql_affected_rows){
            echo "Successfully";

        }
 }
?>

---

This is just a punt, as some functions you are using here are not Standard PHP Functions:

<?php
require_once( 'includes/session.php' );
$P = $_POST;
if( count( $P ) ){
  require_once( 'includes/connection.php' );
  require_once( 'includes/functions.php' );
 // GET value from page user submitted
  $groupname = mysql_real_escape_string( $P['groupname'] );
  $groupid   = mysql_real_escape_string( $P['groupid'] );
  $desc      = mysql_real_escape_string( $P['desc'] );
  $st_val    = $P['valstore'];
 // Extract Rows to Update
  $store_del_exp = explode( ',' , $st_val );
 // Execute Updates / Insertions
  $ok    = array();
  $error = array();
  $sqlChk = 'SELECT 1 FROM `permissions` WHERE `groups_groupid`=%s';
  $sqlIns = 'INSERT INTO `permissions` ( `menus_menuid` , `groups_groupid` ) VALUES ( %s , %s )';
  $sqlUpd = 'UPDATE `permissions` SET `menus_menuid`=%s WHERE `groups_groupid`=%s';
  foreach( $store_del_exp as $menu_id ){
    $sql = sprintf( $sqlChk , $groupid );
    $res = mysql_query( $sql );
    if( $res ){
      if( mysql_num_rows( $res )>0 ){
       // Row(s) Exist, Update
        $sql = sprintf( $sqlUpd , $menu_id , $groupid );
        $res = mysql_query( $sql );
        if( $res ){
          $ok[] = 'Updated Record for $menu_id = '.$menu_id.' and $groupid = '.$groupid;
        }else{
          $error[] = 'Failed to Update Record for $menu_id = '.$menu_id.' and $groupid = '.$groupid.' MySQL Error = '.mysql_error();
        }
      }else{
       // Row(s) Do Not Exist, Insert
        $sql = sprintf( $sqlIns , $menu_id , $groupid );
        $res = mysql_query( $sql );
        if( $res ){
          $ok[] = 'Inserted Record for $menu_id = '.$menu_id.' and $groupid = '.$groupid;
        }else{
          $error[] = 'Failed to Insert Record for $menu_id = '.$menu_id.' and $groupid = '.$groupid.' MySQL Error = '.mysql_error();
        }
      }
    }else{
      $error[] = 'Failed to Check Record for $menu_id = '.$menu_id.' and $groupid = '.$groupid.' MySQL Error = '.mysql_error();
    }
  }
 // Check Results
  if( count( $error )==0 ){
    echo 'All Actions Completed Successfully';
  }else{
    echo count( $ok ).' Actions Completed OK';
    echo '<pre>'.implode( "\n" , $ok ).'</pre>';
    echo count( $error ).' Errors Encountered';
    echo '<pre>'.implode( "\n" , $error ).'</pre>';
  }
?>