1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
|
try
{
$bdd = new PDO('mysql:host=localhost;dbname=vroum','root','');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$req = $bdd->query('SELECT url FROM urls');
echo "Données réceptionnés.<br>";
while($link = $req->fetch())
{
$html1 = geturlpr($link['url']);
$texte = $html1->find('p');
foreach ($texte as $texte1)
{
$final = strip_tags($texte1);
$phrase_temp = explode("|", $final);
foreach ($phrase_temp as $phrase)
{
if (strlen($phrase) > 40)
{
$debut = '';
$milieu ='';
$fin = '';
$fk = 3;
$req = $bdd->prepare("INSERT INTO `content` (`id`, `id.urls`,`debut`, `milieu`, `fin`) VALUES (NULL, ?, ?, ?, ?)");
$req->execute(array($fk, $debut,$milieu,$fin));
}
}
}
}
}
catch(Exception $e)
{
die('ERROR '.$e->getMessage());
} |
Partager