real_connect("127.0.0.1", "jop", "a54BE!wTR542!","jop");
if ($mysqli->connect_errno) {
printf("Échec de la connexion : %s\n", $mysqli->connect_error);
exit();
}
# Creation de l'index
if ($complet == true){
$complet=$complet."".$title."\n";
}
function ecriture($title,$content){
$actuel="/var/www/jop/$id.php";
$handle=fopen($actuel, "w") or die ("impossible d'ecrire le fichier");
$title="".$title."
\n";
fwrite($handle,$title);
$content="".$content."
";
fwrite($handle,$content);
fclose($handle);
}
foreach (range(1,356) as $id){
$req="select post_id, post_title, post_content from blog_post where post_id=".$id.";";
$re=$mysqli->query("$req");
# echo "on a exec la requete $id
";
#$requete=$link->use_result();
#echo "on récup les résultats $requete
";
while($res=$re->fetch_object()){
$idb=$res->post_id;
# echo "$idb";
$title=$res->post_title;
# echo $title;
$content=$res->post_content;
}
# Creation de l'index
$complet=$complet."".$title."\n";
# $actuel="/var/www/jop/$id.php";
# $handle=fopen($actuel, "w") or die ("impossible d'ecrire le fichier");
# echo $handle;
# $title="".$title."
\n";
# fwrite($handle,$title);
# $content="".$content."
";
# fwrite($handle,$content);
# fclose($handle);
# ecriture($title,$content);
}
# $final="/var/www/jop/indexb.php";
# $hfinal=fopen($final, "w") or die ("impossible d'ecrire le fichier");
$complet="";
echo $complet;
# $fwrite($hfinal,"$complet");
# fclose($hfinal);
mysqli_close($mysqli);
?>