function extraire($nom)
{
$fic = fopen($nom, "r");
while (!feof($fic)) {
$mots = fgets($fic, 4096);
$tab = explode(" ", $mots);
$nb = count($tab) - 1;
for ($i = 0; $i < $nb; $i++) {
if (strcmp($tab[$i], "-->") !== 0) {
if (!ctype_digit("{$tab[$i]}")) {
if (strlen($tab[$i]) > 1) {
if (substr_count($tab[$i], "00:0") == 0) {
$chaine = $tab[$i];
$newch = sans_accent($chaine);
//supprime les accents ou caractere spécial
$ch = strtolower($newch);
//met la chaine en minuscule
$connexion = connect_bdd();
if (!$connexion) {
echo "connexion a la base impossible";
}
$req = "select count(*) from rejet where libelle={$ch}";
if ($resultat = mysqli_query($connexion, "{$req}")) {
$mot_rejet = mysqli_fetch_row($resultat);
if ($mot_rejet[0] > 0) {
echo $ch;
echo "</br>";
}
}
}
}
}
}
}
}
fclose($fic);
}
function update_article_sql($id, $title, $firstname, $name, $desc, $age, $price)
{
$title = protect_sql($title, "none");
$firstname = protect_sql($firstname, "none");
$name = protect_sql($name, "none");
$desc = protect_sql($desc, "none");
$age = protect_sql($age, "intval");
$price = protect_sql($price, "intval");
$sql = 'UPDATE articles SET title = "' . $title . '", firstname_articles = "' . $firstname . '", name_articles = "' . $name . '", desc_articles = "' . $desc . '", age = "' . $age . '", price = "' . $price . '" WHERE id_articles = "' . $id . '"';
$bdd = connect_bdd();
if (mysqli_query($bdd, $sql)) {
mysqli_close($bdd);
return 1;
} else {
echo mysqli_error($bdd);
mysqli_close($bdd);
return 0;
}
}
