PHP delete_from_table Examples

Example #1

File: delete_coinfection.php Project: nkiourt/amacs

        delete_from_table($_GET['code'], "hbv_other_treatments_after_art");
    }
    if ($_GET['type'] == "hcv") {
        $sql = "";
        $sql .= " UPDATE `coinfections` ";
        $sql .= "SET HCV='0', HCVDate=NULL, HCVGenotype=''";
        $sql .= " WHERE PatientCode='" . $_GET['code'] . "'";
        //		echo "<BR>".$sql."<BR><BR>";
        $what_happened = execute_query($sql);
        if ($what_happened == 1) {
            //   		echo "<P>Τα δεδομένα διαγράφτηκαν με επιτυχία!</P>";
        } else {
            //    		echo "<P>$what_happened</P>";
        }
        delete_from_table($_GET['code'], "hcv_clinical_status");
        delete_from_table($_GET['code'], "hcv_iologikes");
        delete_from_table($_GET['code'], "hcv_istology");
        delete_from_table($_GET['code'], "hcv_other_treatments");
    }
}
mysql_close($dbconnection);
perform_post_insert_actions("", "coinfection.php?code=" . $_GET['code'], "");
?>

<p><a href="javascript:location.href = '<?php 
echo getenv('HTTP_REFERER');
?>
';">Κάντε click εδώ για επιστροφή</a></p>


</BODY></HTML>

Example #2

File: test_delete.php Project: RevelationTechnologies/tp-dev

<?php

require_once '..\\utilities\\functions.php';
//  Define Table
$table = 'person';
$email = $_POST['email'];
//Build Fields and Values to insert
$record = array();
$record = add_where("email", $email, $record);
delete_from_table($table, $record);