Gecko [ www.jdcpatala.org ]

Name	Size	Permission
ad_jquery	[ DIR ]	drwxr-xr-x
admin_task	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
doc	[ DIR ]	drwxr-xr-x
highslide	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
libs	[ DIR ]	drwxr-xr-x
misc	[ DIR ]	drwxr-xr-x
reports	[ DIR ]	drwxr-xr-x
simplexlsx-master	[ DIR ]	drwxr-xr-x
uploads	[ DIR ]	drwxr-xr-x
Bank_Transfer_Admission.php	3.17 KB	-rw-r--r--
Distrcits.php	6.43 KB	-rw-r--r--
ICM1401.jpg	20.16 KB	-rw-r--r--
Library_membership.php	2.92 KB	-rw-r--r--
Qualification.php	5.72 KB	-rw-r--r--
Request_leave.php	3.99 KB	-rw-r--r--
Student_reports.php	1.54 KB	-rw-r--r--
University.php	6.15 KB	-rw-r--r--
add_new_user.php	5.51 KB	-rw-r--r--
add_subjects.php	2.84 KB	-rw-r--r--
admin_task.php	5.63 KB	-rw-r--r--
admin_task_leave.php	6 KB	-rw-r--r--
admission_dashborad.php	5.56 KB	-rw-r--r--
admission_preview.php	19.35 KB	-rw-r--r--
admission_report.php	13.55 KB	-rw-r--r--
ajaximage.php	984 B	-rw-r--r--
attendance.php	4.34 KB	-rw-r--r--
auth.php	249 B	-rw-r--r--
back.php	1.2 KB	-rw-r--r--
bank.php	5.67 KB	-rw-r--r--
blank.php	834 B	-rw-r--r--
calendar.php	1.46 KB	-rw-r--r--
card.php	406 B	-rw-r--r--
caste.php	6.35 KB	-rw-r--r--
category.php	5.65 KB	-rw-r--r--
change.php	494 B	-rw-r--r--
change_salary.php	4.83 KB	-rw-r--r--
character.php	2.05 KB	-rw-r--r--
chart.php	4.45 KB	-rw-r--r--
chief.png	5.98 KB	-rw-r--r--
city.php	7.58 KB	-rw-r--r--
client_door.php	2.44 KB	-rw-r--r--
college_info.php	7.44 KB	-rw-r--r--
da.php	5.47 KB	-rw-r--r--
dash_admission.php	10.71 KB	-rw-r--r--
date.js	11.66 KB	-rw-r--r--
department.php	5.63 KB	-rw-r--r--
designations.php	5.54 KB	-rw-r--r--
editSalary.php	29.6 KB	-rw-r--r--
edit_student_admission.php	27.24 KB	-rw-r--r--
emp_dash.php	2.56 KB	-rw-r--r--
emply_load.php	43 B	-rw-r--r--
emptype.php	5.51 KB	-rw-r--r--
enter_attendance.php	7.19 KB	-rw-r--r--
error.php	1.84 KB	-rw-r--r--
fee_edit.php	18.57 KB	-rw-r--r--
fee_receipts.php	6.17 KB	-rw-r--r--
fee_s.php	23.02 KB	-rw-r--r--
file-manager.php	1.19 KB	-rw-r--r--
filter_admno.php	479 B	-rw-r--r--
filter_studid.php	732 B	-rw-r--r--
footer.php	3.3 KB	-rw-r--r--
form.php	13.22 KB	-rw-r--r--
foundation.php	5.68 KB	-rw-r--r--
functions.php	1.03 KB	-rw-r--r--
functions_hr.php	947 B	-rw-r--r--
gallery.php	1.42 KB	-rw-r--r--
gender.php	5.49 KB	-rw-r--r--
gender_admission_report.php	4.96 KB	-rw-r--r--
gender_admission_report_old.ph...	3.63 KB	-rw-r--r--
getClassDetail.php	1.47 KB	-rw-r--r--
getStudentRegistrationDetails....	1.22 KB	-rw-r--r--
grid.php	8.81 KB	-rw-r--r--
grn_new_add.php	25.5 KB	-rw-r--r--
header.php	5.53 KB	-rw-r--r--
hr.php	2.52 KB	-rw-r--r--
icon.php	312.57 KB	-rw-r--r--
index.php	3.71 KB	-rw-r--r--
info.php	23 B	-rw-r--r--
last_stream.php	5.67 KB	-rw-r--r--
leave_managment.php	1.23 KB	-rw-r--r--
list_job.php	5.83 KB	-rw-r--r--
load_data.php	1.27 KB	-rw-r--r--
loader.gif	10.57 KB	-rw-r--r--
login.php	8.15 KB	-rw-r--r--
logout.php	254 B	-rw-r--r--
mcm_admin	330 B	-rw-r--r--
mcm_admission.php	52.06 KB	-rw-r--r--
mcm_admission_record.php	7.76 KB	-rw-r--r--
meerutCollegeHome.jpg	304.11 KB	-rw-r--r--
new_emp.php	24.74 KB	-rw-r--r--
new_emp_Gyan.php	24.86 KB	-rw-r--r--
new_subject.php	3.34 KB	-rw-r--r--
notice.php	11.71 KB	-rw-r--r--
paper.php	8 KB	-rw-r--r--
payBill_reports.php	4.1 KB	-rw-r--r--
pay_scale.php	5.52 KB	-rw-r--r--
pay_slip.php	2.54 KB	-rw-r--r--
payroll_period.php	8.16 KB	-rw-r--r--
persnal_details.php	3.02 KB	-rw-r--r--
pf.php	5.46 KB	-rw-r--r--
postal.php	7.43 KB	-rw-r--r--
practical.php	5.63 KB	-rw-r--r--
profile.php	954 B	-rw-r--r--
read_msg.php	8.27 KB	-rw-r--r--
religion.php	5.57 KB	-rw-r--r--
reports.php	5.4 KB	-rw-r--r--
salary_gen.php	28.52 KB	-rw-r--r--
salary_management.php	2.32 KB	-rw-r--r--
salary_transfer.php	8.51 KB	-rw-r--r--
send_msg.php	8.02 KB	-rw-r--r--
session.php	5.61 KB	-rw-r--r--
shift.php	5.63 KB	-rw-r--r--
state.php	5.78 KB	-rw-r--r--
stream.php	6.16 KB	-rw-r--r--
student_transfer.php	7.8 KB	-rw-r--r--
subjects.php	4.83 KB	-rw-r--r--
submit_atten_sms.php	5.91 KB	-rw-r--r--
totalSalary_reports.php	4.11 KB	-rw-r--r--
total_salary.php	5.65 KB	-rw-r--r--
tour.php	1.04 KB	-rw-r--r--
transfer.php	11.26 KB	-rw-r--r--
transfer1.php	11.21 KB	-rw-r--r--
transferSalary.php	4.9 KB	-rw-r--r--
transfer_certificates.php	5.81 KB	-rw-r--r--
typography.php	8.34 KB	-rw-r--r--
ui.php	11.77 KB	-rw-r--r--
update_emp.php	22.95 KB	-rw-r--r--
update_image.php	8.97 KB	-rw-r--r--
update_img.php	2.81 KB	-rw-r--r--
update_salary.php	4.96 KB	-rw-r--r--
upload_merit_list.php	6.38 KB	-rw-r--r--
upload_photo.php	529 B	-rw-r--r--
view_attendacne.php	6.02 KB	-rw-r--r--
view_leave.php	1.85 KB	-rw-r--r--
view_sms_attendacne.php	6.04 KB	-rw-r--r--
wampmanager.ini	142.65 KB	-rw-r--r--
withdrawl_list.php	73.5 KB	-rw-r--r--
x.php	4.71 KB	-rw-r--r--

Code Editor : grn_new_add.php

<?php 
ob_start();
session_start();
error_reporting(4);
include("includes/connection.php");
include_once("includes/function.inc.php");
validateUser();
$Query=mysql_fetch_array(mysql_query("select * from grn_report where grn_no='".$_GET['Add_qid']."'"));
?>

<?php

if(isset($_POST['ADD_SUBMIT']))
{

for($i=1;$i<=$_POST['item_counter'];$i++)
{
$Query_item=mysql_query("insert into grn_relation_item set usercity='".$_SESSION['usercity']."',
														   grn_no='".$Query['purchage_ord']."',
														   gpo_no='".$Query['grn_no']."',
														   item_code='".$_POST['item_code'.$i]."',
														   item_name='".$_POST['item_name'.$i]."',
														   uom='".$_POST['item_uom'.$i]."',
														   item_description='".$_POST['item_dis'.$i]."',
														   po_qty='".$_POST['item_poqty'.$i]."',
														   pandding_qty='".$_POST['item_panding'.$i]."',
														   recevied_qty='".$_POST['item_recqty'.$i]."',
														   rate='".$_POST['item_rate'.$i]."',
														   total_item_price='".$_POST['item_price'.$i]."',
														   invoice_no='".$Query['invoiceno']."'");
}

for($i=1;$i<=$_POST['vehicle_counter'];$i++)
{
$Query_vehicle=mysql_query("insert into grn_reatation_vehicle set usercity='".$_SESSION['usercity']."',
																  grn_no='".$Query['grn_no']."',
																  purchage_order='".$Query['purchage_ord']."',
																  vehicle_no='".$_POST['add_vehicle_no'.$i]."',
																  lr_no='".$_POST['add_lr'.$i]."',
																  lr_date='".$_POST['add_lr_date'.$i]."',
																  way_bill_no='".$_POST['add_bill_no'.$i]."',
																  way_bill_amount='".$_POST['add_bill_amount'.$i]."'");
}

for($i=1;$i<=$_POST['vehicle_count'];$i++)
{
$Query_box=mysql_query("insert into grn_box_details set usercity='".$_SESSION['usercity']."',
														grn_no='".$Query['grn_no']."',
														po_no='".$Query['purchage_ord']."',
														boxitem_code='".$_POST['item_code'.$i]."',
														boxitem_name='".$_POST['item_name'.$i]."',
														box_packageno='".$_POST['package_no'.$i]."',
														box_nopackage='".$_POST['no_ofpack'.$i]."',
														box_location='".$_POST['box_location'.$i]."',
														box_update='available'
														");	
	
}
}

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Warehouse</title>
<link href="css/mystyle.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/thickbox.js"></script>
<link href="js/jquery-calendar.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="js/jquery-calendar.js"></script>
<script language="javascript">
$("#form1").ready(function(){   
$('#PODate').calendar({dateFormat: 'DMY-'});
$('#DeliveryDate').calendar({dateFormat: 'DMY-'});
$('#CanceDate').calendar({dateFormat: 'DMY-'});
$('#Gateentry').calendar({dateFormat: 'DMY-'});
$('#grndate').calendar({dateFormat: 'DMY-'});
$('#venderinvoice').calendar({dateFormat: 'DMY-'});
$('#fromdate').calendar({dateFormat: 'DMY-'});
$('#todate').calendar({dateFormat: 'DMY-'});

});

</script>

</head>

<body>
<div class="outer">
 <?php include("includes/header.inc.php"); ?>
  
  <div class="page">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td height="400" align="center" valign="middle"><form id="form1" name="form1" enctype="multipart/form-data" method="post" onsubmit="return validate();">
          <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="table-border">
            <tr>
              <td class="tble-heading" colspan="3">GRN Details</td>
            </tr>
            <tr>
              <td colspan="2">&nbsp;</td>
              <td width="13%">&nbsp;</td>
            </tr>
            <tr>
              <td colspan="3" align="center"><table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
                  <tr>
                    <td><div class="tab-heading">GRN Details</div>
                   </td>
                  </tr>
                  <tr>
                    <td height="212" align="center" ><table width="100%" border="0" cellpadding="0" cellspacing="0" >
                        <tr>
                          <td height="176" align="center" valign="middle">
                          
                          
                          
                          
                          <table width="93%" border="0" cellspacing="0" cellpadding="3" class="tble-cntent">
                              <tr>
                              <td>Location</td>
                              <td><select name="location" id="location" class="txtbox2">
                                  <option value="">Choose One</option>
                                  <?php $query_loc=mysql_query("select * from location where usercity='".$_SESSION['usercity']."'");
								  while($location=mysql_fetch_array($query_loc))
								  {
								  ?>
                                  
                                  <option value="<?php echo $location['SizeName'];?>"<?php if($Query['location']==$location['SizeName']){ echo "selected";} ?>><?php echo $location['SizeName'];?></option>
                                  
                                  <?php } ?>
                                  </select></td>
                              
                              <td>Warehouse</td>
                              <td><select name="warehouse" id="warehouse" class="txtbox2" >
                                  <option value="">Choose One</option>
                                  <?php $query_wer=mysql_query("select * from warehouse where usercity='".$_SESSION['usercity']."'");
								  while($wearhouse=mysql_fetch_array($query_wer))
								  {
								  ?>
                                  
                                  <option value="<?php echo $wearhouse['SizeName'];?>"<?php if($Query['warehouse']==$wearhouse['SizeName']){ echo "selected"; }?>><?php echo $wearhouse['SizeName'];?></option>
                                  
                                  <?php } ?>
                                  </select></td>
                              
                              <td>GRN No</td>
                              <td><input type="text" name="grn_no" id="grn_no" value="<?php echo $Query['grn_no'];?>" class="txtbox2"></td>
                              </tr>
                              
                              <tr>
                              <td>GRN Date</td>
                              <td><input type="text" name="grndate" value="<?php echo $Query['grn_date'];?>" id="grndate" class="txtbox2"></td>
                              
                              <td>Purchase Type</td>
                              <td><select name="purchagetype" id="purchagetype" class="txtbox2" >
                              <option value="">Choose One</option>
                              <?php 
							  $query=mysql_query("select * from purchage_type where usercity='".$_SESSION['usercity']."' order by SizeId DESC");
							  while($purchage=mysql_fetch_array($query))
							  {
							  ?>
                              <option value="<?php echo $purchage['SizeName'];?>"<?php if($Query['purchage_date']==$purchage['SizeName']){ echo "selected"; } ?>><?php echo $purchage['SizeName'];?></option>
                              <?php } ?>
                              </select></td>
                              
                              <td>Supplier Name</td>
                              <td><input type="text" name="suppler_name" value="<?php echo $Query['supplier_name'];?>" id="suppler_name" class="txtbox2"></td>
                              </tr>
                              
                              <tr>
                              <td>Po Lot No</td>
                              <td><select name="po_lot_no"  id="po_lot_no" class="txtbox2" onchange="showpurchage(this.value)">
                                  <option value="">Choose One</option>
                                  <?php $Qpur=mysql_query("select distinct lotno from purchageorder where usercity='".$_SESSION['usercity']."' order by VID desc");
								  while($Qp_order=mysql_fetch_array($Qpur))
								  {
								  ?>
                                  <option value="<?php echo $Qp_order['lotno'];?>"<?php if($Query['lot_no']==$Qp_order['lotno']) { echo "selected"; }?>><?php echo $Qp_order['lotno'];?></option>
                                  <?php } ?>
                                  </select></td>

<td>Purchage Order</td>
                                <td><input type="text" name="purchageorder" value="<?php echo $Query['purchage_ord'];?>" class="txtbox2"></td>

<td>Receving Time</td>
                              <td><script language="JavaScript" src="http://oluchi.yn.lt/wapmaster/tools/js/gt/time.js" type="text/javascript"></script></td>
                              
                              
                              </tr>
                              
                             
                              
                               <tr>
                              <td>Invoice No</td>
                              <td><input type="text" name="invoice_no" value="<?php echo $Query['invoiceno'];?>" id="invoice_no" class="txtbox2"></td>
                              
                              <td>Invoice Date</td>
                              <td><input type="text" name="invoice_date" value="<?php echo $Query['invoice_date'];?>" class="txtbox2" id="DeliveryDate" readonly="readonly"></td>
                              
                              <td>Vender Invoice No</td>
                              <td><input type="text" name="vender_invoice_no" value="<?php echo $Query['vender_invoiceno'];?>" id="vender_invoice_no" class="txtbox2"></td>
                              </tr>
                              
                              
                              <tr>
                              <td>Vender Invoice Value</td>
                              <td><input type="text" name="vender_invoice_value" value="<?php echo $Query['vender_invoice_value'];?>" id="vender_invoice_value" class="txtbox2"></td>
                              
                              
                              <td>Gate Entry No</td>
                              <td><input type="text" name="gateentryno" value="<?php echo $Query['gateentry_no'];?>" id="gateentryno" class="txtbox2"></td>
                              <td>Transport Name</td>
                              <td><input type="text" name="transport_name" value="<?php echo $Query['transporter_name'];?>" id="transport_name" class="txtbox2"></td>
                           
                              
                              
                              </tr>
                              
                              <tr>
                              <td>Gate Entry Date</td>
                              <td><input type="text" name="gate_entry_date" value="<?php echo $Query['gateentry_date'];?>" id="Gateentry" class="txtbox2"></td>
                              
                              <td>BOE No</td>
                              <td><input type="text" name="boe_no" value="<?php echo $Query['boe_no'];?>" id="boe_no" class="txtbox2"></td>
                              
                              </tr>
                              
                              <tr>
                              <td>No of Package</td>
                              <td><input type="text" name="no_of_package" value="<?php echo $Query['no_package'];?>" id="no_of_package" class="txtbox2"></td>
                              
                              <td>POD Done</td>
                              <td><select name="pod_done" id="pod_done" class="txtbox2">
                              <option value="">Choose One</option>
                              <option value="Yes"<?php if($Query['no_package']=='Yes'){ echo "selected"; }?>>Yes</option>
                              <option value="No"<?php if($Query['no_package']=='No'){ echo "selected"; }?>>No</option>
                              </select>
                              </td>
                              
                              
                              
                              </tr>
                              
                              
                              <tr>
                              
                              
                             
                              
                               </tr>
                              
                              
                              <tr>
                              <td>Remark if Any</td>
                              <td colspan="4"><textarea name="remark"  class="txtbox2" style="height:50px; width:600px; resize: none;"><?php echo $Query['remark'];?></textarea></td>
                              
                              </tr>
                              
                              <tr>
                              <td height="30" align="center"></td>
                              </tr>
                              
                              
                              
                              
                           
                              
                          </table></td>
                        </tr>
                        
                        <tr>
                        <td height="30"></td>
                        </tr>
                        
                        <tr>
                        <td height="55" align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#039;">Add Details ||
                         Insert The No of Row</span>&nbsp;&nbsp;<input type="text" name="item_no_row" value=""  class="txtbox2" onblur="item_row(this.value)"></td>
                        </tr>
                        
                        <tr>
                        <td>
                        <table class="tble-cntent">
                        
                        
                        <tr>
                        <td width="38" class="tble-heading"><strong>S.No.</strong></td>
                        <td width="86" class="tble-heading"><strong>Item code</strong></td>
                        <td width="90" class="tble-heading"><strong>Item Name</strong></td>
                        <td width="69" class="tble-heading"><strong>UOM</strong></td>
                        <td width="113" class="tble-heading"><strong>Discription</strong></td>
                        <td width="93" class="tble-heading"><strong>Po Qty</strong></td>
                        <td width="115" class="tble-heading"><strong>Pending Qty</strong></td>
                        <td width="135" class="tble-heading"><strong>Recived Qty</strong></td>
                        
                        
                        <td width="88" class="tble-heading"><strong>Rate</strong></td>
                        <td width="118" class="tble-heading"><strong>Total Item price</strong></td>
                        </tr>
                        
                        <tr>
                        <td colspan="10"><div id="txtitemrow"></div></td>
                        </tr>
                        
                       
                        
                        
                        
                        <tr>
                        <td height="55"></td>
                        </tr>
                        
                        </table>
                        </td>
                        </tr>
                        
                        
                        <tr>
                        <td height="55" align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#039;">Add Details ||
                         Insert The No of Row</span>&nbsp;&nbsp;<input type="text" name="item_no_row" value=""  class="txtbox2" onblur="item_vehicle(this.value)"></td>
                        </tr>
                        
                        
                             
                        
                        <tr>
                        <td>
                        <table class="tble-cntent">
                        
                        
                        <tr>
                        <td width="29" class="tble-heading"></td>
                        <td width="192" class="tble-heading"><strong>Vehice No</strong></td>
                        <td width="198" class="tble-heading"><strong>LR No</strong></td>
                        <td width="195" class="tble-heading"><strong>LR Date</strong></td>
                        <td width="171" class="tble-heading"><strong>Way Bill No</strong></td>
                        <td width="176" class="tble-heading"><strong>Way Bill Amount</strong></td>
                        </tr>
                        
                        
                       
                        <tr>
                        <td colspan="7"><div id="txtvehicle"></div></td>
                        </tr>
                       
                        <tr>
                        <td height="55"></td>
                        </tr>
                        
                        </table>
                        </td>
                        </tr>
                        
                        <tr>
                        <td height="30"></td>
                        </tr>   
                        
                        <tr>
                        <td>
                        <table width="989" class="tble-cntent">
                        
                 
                        
                        <tr>
                        <td width="56"></td>
                        <td width="134">Total Amount</td>
                        <td width="311"><input type="text" name="total_amount1" value="" id="tatao_amount1" class="txtbox"></td>
                        <td width="99">Freight</td>
                        <td width="365"><input type="text" name="freieght" value="" id="freieght" class="txtbox"></td>
                        </tr>
                      
                        
                        
                        
                        
                        
                        <tr>
                        <td width="56"></td>
                        <td>Tax Values</td>
                        <td width="311"><input type="text" name="tax_values" value="" id="tax_values" class="txtbox"></td>
                        <td>Grand Total</td>
                        <td width="365"><input type="text" name="grand_total" value="" id="grand_total" class="txtbox"></td>
                        </tr>
                        
                        <tr>
                        <td height="20"></td>
                        </tr>
                                                
                        
                        </table>
                        </td>
                        </tr>
                        <tr>
                        <td height="55" align="left"><span style="font-family:Verdana, Geneva, sans-serif; font-size:12px; color:#039;">Add Details ||
                         Insert The No of Row</span>&nbsp;&nbsp;<input type="text" name="item_no_row" value=""  class="txtbox2" onblur="item_box(this.value)">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="file" name="file_import_box"><input type="submit" name="Box_submit" value="Import"></td>
                        </tr>
                        
                        <?php
     if(isset($_POST['Box_submit']))
     {
    $connect=mysql_connect("localhost","atlerp_inv","inv12312");

if (!$connect) {
     die('Could not connect to MySQL: ' . mysql_error());
     }

$cid =mysql_select_db('atlerp_inv',$connect);

$fn = $_FILES["file_import_box"]["tmp_name"];
	 if(empty($fn)){
	 echo "File is empty Please Select the file first";
  mysql_close($connect);}else{
	 
     $csv_file =  $fn ; // Name of your CSV file
     $csvfile = fopen($csv_file, 'r');
     $theData = fgets($csvfile);
     $i = 0;
     while(!feof($csvfile)) 
     {
     $csv_data[] = fgets($csvfile, 1024);
     $csv_array = explode(",", $csv_data[$i]);
     $insert_csv = array();
     $insert_csv['VID'] = $csv_array[0];
     $insert_csv['po_no'] = $csv_array[1];
     $insert_csv['boxitem_code'] = $csv_array[2];
     $insert_csv['boxitem_name'] = $csv_array[3]; 
     $insert_csv['box_packageno'] = $csv_array[4];
     $insert_csv['box_nopackage'] = $csv_array[5];
      $insert_csv['box_location'] = $csv_array[6];
	 $insert_csv['grn_no'] =  $csv_array[7];
    $insert_csv['box_update'] =$csv_array[8];
    $insert_csv['usercity'] = $_SESSION['usercity'];
     $insert_csv['box_txt'] =$csv_array[9];

$query = "insert into grn_box_details ( VID ,  po_no ,  boxitem_code ,  boxitem_name ,  box_packageno ,  box_nopackage ,  box_location ,  grn_no ,  box_update ,  usercity ,  box_txt ) VALUES('','".$insert_csv['po_no']."','".$insert_csv['boxitem_code']."','".$insert_csv['boxitem_name']."','".$insert_csv['box_packageno']."','".$insert_csv['box_nopackage']."','".$insert_csv['box_location']."','".$insert_csv['grn_no']."','".$insert_csv['box_update']."','".$insert_csv['usercity']."','".$insert_csv['box_txt']."')";
$n=mysql_query($query, $connect ) or die(mysql_error());
if($n){

}else{
  echo "U got Error";
}
$i++;
}
fclose($csvfile);
}
echo "File data successfully imported to database!!";
mysql_close($connect);
}
?>
                        
                        
                        
                        
                       
                        
                        <tr>
                        <td>
                        <table width="988" class="tble-cntent">
                        <tr>
                        <td width="61" class="tble-heading"><strong>S.No.</strong></td>
                        <td width="180" class="tble-heading"><strong>Item Code</strong></td>
                        <td width="204" class="tble-heading"><strong>Item Name</strong></td>
                        <td width="205" class="tble-heading"><strong>Package No</strong></td>
                        <td width="168" class="tble-heading"><strong>No of Package</strong></td>
                        <td width="141" class="tble-heading"><strong>Location</strong></td>
                        </tr>
                        
                        
                        <tr>
                        <td colspan="6" align="left"><div id="txtbox"></div></td>
                        </tr>
                        
                        
                         <tr>
                        <td height="55"></td>
                        </tr>
                        
                        </table>
                        </td>
                        </tr>
                       <tr>
                       <td><input type="submit" value="SUBMIT" class="sbt-btn" name="ADD_SUBMIT"></td>
                       </tr> 
                               
                            
                          </table></td>
                        </tr>
                        <tr>
                          <td height="15" align="center" valign="top">&nbsp;</td>
                        </tr>
                    </table></td>
                  </tr>
                  <tr>
                    <td>&nbsp;</td>
                  </tr>
              </table></td>
            </tr>
            
          </table>
                </form>
                
                
                
        </td>
      </tr>
    </table>
  </div>
  
 <?php include("includes/footer.inc.php"); ?>
   <script type="text/javascript">
var TabbedPanels1 = new Spry.Widget.TabbedPanels("TabbedPanels1");
</script>
</div>

</body>
</html>

${this.title}

Code Editor : grn_new_add.php