PHP ConvertWork::startTransaction Exemples

Exemple #1

Fichier : company_delete_proc.php Projet : akswosn/Smartax

//localhost/proc/DataConvert/company_delete_proc.php?co_id=85
//localhost/proc/DataConvert/company_delete_proc.php?co_id=86
//localhost/proc/DataConvert/company_delete_proc.php?co_id=88
//localhost/proc/DataConvert/company_delete_proc.php?co_id=54
//localhost/proc/DataConvert/company_delete_proc.php?co_id=80
//localhost/proc/DataConvert/company_delete_proc.php?co_id=89
//localhost/proc/DataConvert/company_delete_proc.php?co_id=90
//localhost/proc/DataConvert/company_delete_proc.php?co_id=8
//localhost/proc/DataConvert/company_delete_proc.php?co_id=87
/*
	http://localhost/FarmSaver_Data_Convert/proc/DataConvert/company_delete_proc.php?co_id=
*/
try {
    $co_id = $_GET['co_id'];
    $toWork->createWork($_GET, false);
    $toWork->startTransaction();
    //company_member
    $delSql = "DELETE FROM company_member WHERE co_id={$co_id};";
    $toWork->updateSql($delSql);
    //company_info
    $delSql = "DELETE FROM company_info WHERE co_id={$co_id};";
    $toWork->updateSql($delSql);
    //customer
    $delSql = "DELETE FROM customer WHERE co_id={$co_id};";
    $toWork->updateSql($delSql);
    //gicho_detail
    $delSql = "DELETE FROM gicho_detail WHERE co_id={$co_id};";
    $toWork->updateSql($delSql);
    //gicho_master
    $delSql = "DELETE FROM gicho_master WHERE co_id={$co_id};";
    $toWork->updateSql($delSql);