.

.
Uncategories query of two column which is array format

query of two column which is array format

06:03
public function updatebrandsortid($brid,$sortid)
 {

 //echo $ids;
 $id=$sortid;
$br = explode(",",$brid);
$iduser = explode(",",$id);
//print_r($iduser);
for($i=0;$i<=count($iduser);$i++)
{
if($iduser[$i]!='')
{

 $sql= "Update great_brand set `sortid` = '".$iduser[$i]."' where `bid` = '".$br[$i]."' ";
 $query=$this->db->prepare($sql);
 $query->execute();
 }
 }

 return true;

 <?php
session_start();
error_reporting(E_ALL & ~E_DEPRECATED & ~E_NOTICE);
require_once '../config.php';
include 'includes/init.php';
//print_r($_REQUEST['brid']);/
//print_r($_REQUEST['sortid']);
$brid=implode(',',$_REQUEST['brid']);
$sortid=implode(',',$_REQUEST['sortid']);
$up=$cat->updatebrandsortid($brid,$sortid);
if($up==1)
{
$_SESSION['msg']='Update sort id successfully';
header('Location:viewbrand.php');


}


 //$_REQUEST['action'];
//$ids = implode(',',$_REQUEST['brid']);





?>








 }


EmoticonEmoticon

Subscribe to: Post Comments (Atom)