Tweet
<?php
$update_query = tep_db_query("select products_model, products_price,
products_last_modified from "
. TABLE_PRODUCTS . " where products_status = 1");
while ($update = tep_db_fetch_array($update_query)) {
$price_old = $update['products_price'];
$id = $update['products_model'];
$last_update = $update['products_last_modified'];
// Der Link zur Suche
$URL = "http://xxx.de/id=4441225";
// Start der Auslese
$Start = 'Art.Nr.';
$End = "<td align=right><input type=text name=";
// Öffnen der Seite
$file = fopen("$URL", "r");
// Lesen der Seite
$r = file_get_contents($URL);
// Suchen, wonach gesucht werden soll
$stuff = eregi("$Start(.*)$End", $r, $content);
// Zeichen ersetzen
$content[1] = str_replace(".", "", $content[1]);
$content[1] = str_replace(",", ".", $content[1]);
$content[1] = str_replace(" EUR", "", $content[1]);
$content[1] = str_replace(" ", "", $content[1]);
$content[1] = str_replace("<br>", "", $content[1]);
$content[1] = str_replace("<td align=right>", "", $content[1]);
$content[1] = str_replace("</td>", "", $content[1]);
$content[1] = str_replace("/span>", "", $content[1]);
$content[1] = str_replace("<td>", "", $content[1]);
fclose($file);
$stuff = $content[1];
// Werte Speichern
$items = explode("[LINES]",$stuff);
$count = "0";
$rest = substr($stuff, 1, 8);
$rest1 = substr($stuff, 10, 15);
$id = $rest;
$price = $rest1;
$db_price = $price / 116 * 100;
}
?>
// Genau hier, soll dann Zeile für Zeile nach jeder
erfolgten Abfrage erscheinen! echo Artikelnummer
Moderator
<?php
$sql = "SELECT products_model, products_price, products_last_modified "
."FROM " . TABLE_PRODUCTS . " WHERE products_status = 1";
$update_query = tep_db_query($sql);
while ($update = tep_db_fetch_array($update_query)) {
$r = file_get_contents('http://xxx.de/id=4441225');
eregi("Art\.Nr\.(.*)<td align=right><input type=text name=", $r, $content);
$search = array(
'.',
',',
' EUR',
' ',
'<br>',
'<td align=right>',
'</td>',
'</span>',
'<td>'
);
$stuff = str_replace($search, '', $content[1]);
$items = explode("[LINES]", $stuff);
$id = substr($stuff, 1, 8);
$price = substr($stuff, 10, 15);
$db_price = $price / 116 * 100;
// Hier die Ausgabe! (In $update hast du die Werte aus der DB.)
echo 'whatever you want';
}
?>
Kommentar