PHP get_id_bille_by_nom примеры использования

Пример #1

Файл: set_update_reference_bille.php Проект: didier-gilles-65/bet

    $motif_type = $bdd->quote($_POST['input_motif_type']);
} else {
    $error = 1;
}
$id = $_POST['bille'];
if ($error) {
    header('Location: detail.php?id=' . $id . '&err=true');
    exit;
}
$requete = "DELETE FROM SYNONYMES WHERE SYNONYME_A={$id} or SYNONYME_B={$id} ";
ecrireLog('SQL', 'INFO', 'SET_UPDATE_REFERENCE_BILLES.PHP| REQUETE = ' . $requete);
$req = $bdd->prepare($requete);
$req->execute();
if (isset($_POST['input_synonyme'])) {
    foreach ($_POST['input_synonyme'] as $synonyme) {
        $id_synonym = get_id_bille_by_nom($sql_bille_by_id, $synonyme);
        if ($id_synonym == 0) {
            continue;
        }
        $requete = "INSERT INTO SYNONYMES ( SYNONYME_A, SYNONYME_B ) values ( {$id}, {$id_synonym} )";
        ecrireLog('SQL', 'INFO', 'SET_UPDATE_REFERENCE_BILLES.PHP| REQUETE = ' . $requete);
        $req = $bdd->prepare($requete);
        if (!$req->execute()) {
            continue;
        }
    }
}
$description = $bdd->quote($description);
$description_anglaise = $bdd->quote($description_anglaise);
$requete = "UPDATE billes set nom = {$nom}, description = {$description}, description_anglaise = {$description_anglaise}, base_frittee = {$base_frittee}, base_irisee = {$base_irisee}, base_givree = {$base_givree}, base_couleur = {$base_couleur}, base_type = {$base_type}, motif_couleur = {$motif_couleur}, motif_type = {$motif_type} where ID_BILLES={$id}";
ecrireLog('SQL', 'INFO', 'SET_UPDATE_REFERENCE_BILLES.PHP| REQUETE = ' . $requete);

Пример #2

Файл: set_post.php Проект: didier-gilles-65/bet

    header('Location: VUE/BILLES/v_erreur.php?id=1004');
    exit;
}
$req->closeCursor();
$post_id = $line['b_post_id'];
if ($blog_id != 0) {
    $requete = 'DELETE from b_post_billes where b_post_billes_post_id = ' . $blog_id;
    $req = $bdd->prepare($requete);
    //echo $requete.'</p>';
    if (!$req->execute()) {
        $req->closeCursor();
        header('Location: VUE/BILLES/v_erreur.php?id=1009');
        exit;
    }
    $req->closeCursor();
}
foreach ($tags as $tag) {
    if ($tag == '') {
        break;
    }
    $tag_bille_num = get_id_bille_by_nom($sql_bille_by_id, $tag);
    $requete = "INSERT INTO b_post_billes(b_post_billes_billes_num, b_post_billes_post_id, b_post_billes_tag_text) VALUES ({$tag_bille_num}, {$post_id}, '{$tag}')";
    $req = $bdd->prepare($requete);
    if (!$req->execute()) {
        $req->closeCursor();
        header('Location: VUE/BILLES/v_erreur.php?id=1005');
        exit;
    }
    $req->closeCursor();
}
header('Location: blogs.php');