insert multiple row in database using php-mysql

<?php include('config.php');

extract($_GET);
extract($_POST);

 $gname = explode(',',$gname);
 $gid = explode(',',$gid);
 $gvalue = explode(',',$gvalue);
 $uname = $nuname;
 $address = $address;
 $mnumber = $mnumber;
 $moperator = $moperator;
 $mail = $email;
 $uid = $uid;
 $fname = $fname;
 $totalpoints = $totalpoints;
 $checkPoints=$checkPoints;
 $sub_date = date("Y-m-d");
 $updatepoint = $checkPoints-$totalpoints;

?>

<?php
$cnt = count($gname);
$cnt2 = count($gvalue);

if ($cnt > 0 && $cnt == $cnt2) {
    $insertArr = array();
    for ($i=0; $i<$cnt; $i++) {

   
 $insertArr[] = "('','" . mysql_real_escape_string($gid[$i]) ."','$uid','" . mysql_real_escape_string($gname[$i]) . "','" . mysql_real_escape_string($gvalue[$i]) ."','$fname','$uname','$sub_date','','$mnumber','$address','$moperator','$mail','','','1','','','','','')";
   
   
//        $insertArr[] = "('','" . mysql_real_escape_string($gname[$i]) . "', '" . mysql_real_escape_string($gvalue[$i]) ."','" . mysql_real_escape_string($gid[$i]) ."','" . mysql_real_escape_string($uname)."','" . mysql_real_escape_string($uname)."')";
    }


$query = "INSERT INTO table_name VALUES ". implode(", ", $insertArr);

if (mysql_query($query))
  {
  include('pointredeam.php');
  }
else
  {
  echo "there was some error please try later";
  }

//echo "query = $query";

}
header('location:index.php');
?>

Posted in: