PHP execInsert示例

示例#1

文件： appointment_fun.php 项目： MUN06/Lok-Sabha-Election-16th

function delete_temp_app_letter($usercd)
{
    $sql = "delete from tmp_app_let where usercode='{$usercd}'";
    $i = execInsert($sql);
    connection_close();
    return $i;
}

示例#2

文件： add_fun.php 项目： MUN06/Lok-Sabha-Election-16th

function save_Termination($ter_id, $PersonalID, $TerminationCause, $DateofTermination, $Remarks, $usercd)
{
    $sql = "insert into termination (personal_id,termination_cause,termination_date,remarks,users_id) values (";
    $sql .= "'{$PersonalID}','{$TerminationCause}','{$DateofTermination}','{$Remarks}','{$usercd}')";
    $i = execInsert($sql);
    connection_close();
    return $i;
}

示例#3

文件： populate_second_appt.php 项目： MUN06/Lok-Sabha-Election-16th

<?php

date_default_timezone_set('Asia/Calcutta');
include_once 'inc/db_trans.inc.php';
$pc_cd = isset($_GET['pc_cd']) ? $_GET['pc_cd'] : "";
//$pc_cd='39';
$sql0 = "delete from second_appt where pccd='{$pc_cd}'";
$i = execDelete($sql0);
$sql1 = "INSERT INTO second_appt( assembly, pccd, groupid ,mem_no)  SELECT  forassembly, forpc, groupid,count(*)  FROM personnela WHERE booked = 'P'  and forpc='{$pc_cd}'  GROUP BY forassembly, groupid ";
$i = execInsert($sql1);
$sql2 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly and second_appt.groupid=personnela.groupid\r\n  SET second_appt.pr_personcd = personnela.personcd,second_appt.pr_name = personnela.officer_name,second_appt.`pr_designation` =personnela.off_desg,second_appt.`pr_officecd`= personnela.officecd,second_appt.`pr_status`='PR',second_appt.pr_post_stat='Presiding Officer'\r\nWHERE personnela.forpc = '{$pc_cd}' and  personnela.booked = 'P'  and personnela.poststat = 'PR' ";
$i = execUpdate($sql2);
$sql3 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly  and \r\nsecond_appt.groupid=personnela.groupid  SET second_appt.p1_personcd = personnela.personcd,second_appt.p1_name = personnela.officer_name,second_appt.`p1_designation`=personnela.off_desg,second_appt.`p1_officecd`=personnela.officecd, second_appt.`p1_status`='P1',second_appt.p1_post_stat='1st Polling Officer' \r\nWHERE personnela.forpc = '{$pc_cd}' and  personnela.booked = 'P' and personnela.poststat = 'P1'";
$i = execUpdate($sql3);
$sql4 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly  and \r\nsecond_appt.groupid=personnela.groupid  SET second_appt.p2_personcd = personnela.personcd,second_appt.p2_name = personnela.officer_name,second_appt.`p2_designation` \r\n=personnela.off_desg,second_appt.`p2_officecd`= personnela.officecd,second_appt.`p2_status`='P2',second_appt.p2_post_stat='2nd Polling Officer'\r\nWHERE personnela.forpc = '{$pc_cd}' and  personnela.booked = 'P'  and personnela.poststat = 'P2'";
$i = execUpdate($sql4);
$sql5 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly  and \r\nsecond_appt.groupid=personnela.groupid  SET second_appt.p3_personcd = personnela.personcd,second_appt.p3_name = personnela.officer_name,second_appt.`p3_designation` \r\n=personnela.off_desg,second_appt.`p3_officecd`= personnela.officecd,second_appt.`p3_status`='P3',second_appt.p3_post_stat='3rd Polling Officer'\r\nWHERE personnela.forpc = '{$pc_cd}' and  personnela.booked = 'P'  and personnela.poststat = 'P3'";
$i = execUpdate($sql5);
$sql6 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly  and \r\nsecond_appt.groupid=personnela.groupid  SET second_appt.pa_personcd = personnela.personcd,second_appt.pa_name = personnela.officer_name,second_appt.`pa_designation`=personnela.off_desg, second_appt.`pa_officecd`= personnela.officecd,second_appt.`pa_status`='PA', second_appt.pa_post_stat='Addl. 2nd Polling Officer-1' \r\nWHERE personnela.forpc = '{$pc_cd}' and  personnela.booked = 'P'  and personnela.poststat = 'PA'";
$i = execUpdate($sql6);
$sql7 = "UPDATE second_appt JOIN personnela ON second_appt.assembly=personnela.forassembly  and \r\nsecond_appt.groupid=personnela.groupid  SET second_appt.pb_personcd = personnela.personcd,second_appt.pb_name = personnela.officer_name,second_appt.`pb_designation`=personnela.off_desg,second_appt.`pb_officecd`= personnela.officecd,second_appt.`pb_status`='PB',second_appt.pa_post_stat='Addl. 2nd Polling Officer-2' \r\nWHERE personnela.forpc = '{$pc_cd}' and  personnela.booked = 'P'  and personnela.poststat = 'PB'";
$i = execUpdate($sql7);
$sql8 = "UPDATE second_appt JOIN office ON second_appt.pr_officecd = office.officecd   SET  second_appt.pr_officename =  office.office,second_appt.`pr_officeaddress`= concat(office.address1,',',office.address2),second_appt.pr_postoffice=office.postoffice,second_appt.pr_pincode=office.pin, second_appt.pr_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.pr_status = 'PR'";
$i = execUpdate($sql8);
$sql9 = "UPDATE second_appt JOIN office ON second_appt.p1_officecd = office.officecd   SET  second_appt.p1_officename =  office.office,second_appt.`p1_officeaddress`= concat(office.address1,',',office.address2),second_appt.p1_postoffice=office.postoffice,second_appt.p1_pincode=office.pin ,second_appt.p1_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.p1_status = 'P1' ";
$i = execUpdate($sql9);
$sql10 = "UPDATE second_appt JOIN office ON second_appt.p2_officecd = office.officecd   SET  second_appt.p2_officename =  office.office,second_appt.`p2_officeaddress`= concat(office.address1,',',office.address2),second_appt.p2_postoffice=office.postoffice,second_appt.p2_pincode=office.pin,second_appt.p2_subdivision=office.subdivisioncd  WHERE second_appt.pccd='{$pc_cd}' and second_appt.p2_status = 'P2' ";
$i = execUpdate($sql10);
$sql11 = "UPDATE second_appt JOIN office ON second_appt.p3_officecd = office.officecd   SET  second_appt.p3_officename =  office.office,second_appt.`p3_officeaddress`= concat(office.address1,',',office.address2),second_appt.p3_postoffice=office.postoffice,second_appt.p3_pincode=office.pin, second_appt.p3_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.p3_status = 'P3' ";
$i = execUpdate($sql11);
$sql12 = "UPDATE second_appt JOIN office ON second_appt.pa_officecd = office.officecd   SET  second_appt.pa_officename =  office.office,second_appt.`pa_officeaddress`= concat(office.address1,',',office.address2),second_appt.pa_postoffice=office.postoffice,second_appt.pa_pincode=office.pin , second_appt.pa_subdivision=office.subdivisioncd WHERE second_appt.pccd='{$pc_cd}' and second_appt.pa_status = 'PA' ";

示例#4

文件： training2_fun.php 项目： MUN06/Lok-Sabha-Election-16th

function save_training2_schedule($schedule_cd, $forpc, $assembly, $party_reserve, $start_sl, $end_sl, $training_venue, $training_dt, $training_time, $usercd)
{
    $sql = "insert into second_training (schedule_cd,for_pc,assembly,party_reserve,start_sl,end_sl,training_venue,training_dt,training_time,\tusercode) values ('{$schedule_cd}','{$forpc}','{$assembly}','{$party_reserve}','{$start_sl}','{$end_sl}','{$training_venue}','{$training_dt}','{$training_time}','{$usercd}')";
    $i = execInsert($sql);
    return $i;
}

示例#5

文件： form_12_fun.php 项目： MUN06/Lok-Sabha-Election-16th

function save_po_ed($personnel, $pc, $ed_pb, $usercd)
{
    $sql = "insert into po_ed (personcd, pccd, ed_pb, usercode) values ('{$personnel}','{$pc}','{$ed_pb}','{$usercd}')";
    $i = execInsert($sql);
    return $i;
}

示例#6

文件： user_fun.php 项目： MUN06/Lok-Sabha-Election-16th

function save_user_permission($user_cd, $menu_cd, $submenu_cd)
{
    $sql = "insert into user_permission (user_cd,menu_cd,submenu_cd) values ('{$user_cd}','{$menu_cd}','{$submenu_cd}')";
    $i = execInsert($sql);
    return $i;
}

示例#7

文件： master_fun.php 项目： MUN06/Lok-Sabha-Election-16th

function save_dcrc_party($assembly, $member, $party_req, $dcrc_code, $subdivision, $pc, $dc_date, $dc_time, $usercd)
{
    $sql = "insert into dcrc_party (dcrcgrp, assemblycd, number_of_member, partyindcrc, subdivisioncd, forpc, dc_date, dc_time, usercode) values ('{$dcrc_code}','{$assembly}','{$member}','{$party_req}','{$subdivision}','{$pc}','{$dc_date}','{$dc_time}','{$usercd}')";
    $i = execInsert($sql);
    return $i;
}

示例#8

文件： training_fun.php 项目： MUN06/Lok-Sabha-Election-16th

function save_training_schedule($schedule_code, $training_venue, $training_type, $training_dt, $training_time, $post_status, $no_pp, $usercode)
{
    $sql = "insert into training_schedule (schedule_code,training_venue,training_type,training_dt,training_time,post_status, no_pp, usercode) values ('{$schedule_code}','{$training_venue}','{$training_type}','{$training_dt}','{$training_time}','{$post_status}', '{$no_pp}','{$usercode}')";
    $i = execInsert($sql);
    return $i;
}