PHP is_used_address_id Exemples

Exemple #1

Fichier : address_db.php Projet : hessemanj2100/guitar_shop

function disable_or_delete_address($address_id)
{
    global $db;
    if (is_used_address_id($address_id)) {
        $query = 'UPDATE addresses SET disabled = 1 WHERE addressID = :address_id';
        $statement = $db->prepare($query);
        $statement->bindValue(":address_id", $address_id);
        $statement->execute();
        $statement->closeCursor();
    } else {
        $query = 'DELETE FROM addresses WHERE addressID = :address_id';
        $statement = $db->prepare($query);
        $statement->bindValue(":address_id", $address_id);
        $statement->execute();
        $statement->closeCursor();
    }
}

Exemple #2

Fichier : address_db.php Projet : pd00996/hunghbpd00996

function disable_or_delete_address($address_id)
{
    global $db;
    if (is_used_address_id($address_id)) {
        $query = 'UPDATE diachi SET ghichu = 1 WHERE iddiachi = :address_id';
        $statement = $db->prepare($query);
        $statement->bindValue(":address_id", $address_id);
        $statement->execute();
        $statement->closeCursor();
    } else {
        $query = 'DELETE FROM diachi WHERE iddiachi = :address_id';
        $statement = $db->prepare($query);
        $statement->bindValue(":address_id", $address_id);
        $statement->execute();
        $statement->closeCursor();
    }
}