Я пытаюсь включить файл, который очищает все мои данные с нескольких веб-сайтов, но не работает. Вот мой код.
во-первых, очищающий файл php. имя scrapedata.php
<?php //Include the Simple HTML DOM to use its functions, used by other following scripts. //navigate to the content of variable html and save it in price data variable //get the whole html of the webpage into variable html include 'simple_html_dom.php'; $html = file_get_html('http://www.play.com/Electronics/Electronics/4-/16230382/New-Apple-iPod-Touch-8GB-4th-Gen/Product.html?'); $price_data = $html->find('h6[id=bodycontent_0_middlecontent_1_ctl00_ctl00_product_ctl00__overview_ctl00__dataControl__price__headerSix',0)->plaintext; //Amazon.co.uk scrape $amazon_html = file_get_html('http://www.amazon.co.uk/New-Apple-iPod-touch-Generation/dp/B0040GIZTI/ref=br_lf_m_1000333483_1_1_img?ie=UTF8&s=electronics&pf_rd_p=229345967&pf_rd_s=center-3&pf_rd_t=1401&pf_rd_i=1000333483&pf_rd_m=A3P5ROKL5A1OLE&pf_rd_r=1ZW9HJW2KN2C2MTRJH60'); $amazon_pd = $amazon_html->find('b[class=priceLarge]',0)->innertext; libxml_use_internal_errors(true); $dom = new DOMDocument(); $dom->loadHTML($amazon_html); $xpath = new DOMXpath($dom); $expr = "/html/body/div[@id='divsinglecolumnminwidth']/form[@id='handleBuy']/table[3]/tr[3]/td/div/span"; $nodes = $xpath->query($expr); // returns DOMNodeList object // you can check length property ie $nodes->length //echo $nodes->item(0)->nodeValue; // get first DOMNode object and its value $stock_data = $nodes->item(0)->nodeValue; if ( $stock_data == "In stock." ) { $stockyesno = "Yes"; } else { $stockyesno = "No"; } //Currys scrape $currys_html = file_get_html('http://www.currys.co.uk/gbuk/apple-new-ipod-touch-8gb-4th-generation-07677427-pdt.html'); $currys_pd = $currys_html->find('p[class=prd-amount]',0)->plaintext; $currys_stk = $currys_html->find('/html/body/div/div/div[2]/div/div/div[2]/div/ul[2]/li/span')->plaintext; //span[class=icon icon-check]',0); echo $currys_stk; if ( $currys_stk == "Available for home delivery" ) { $currys_stockyesno = "Yes"; } else { $currys_stockyesno = "No"; } //Argos scrape $argos_html = file_get_html('http://www.argos.co.uk/static/Product/partNumber/9282197/Trail/searchtext%3EIPOD+TOUCH.htm'); $argos_pd = $argos_html->find('span[class=actualprice]',0)->plaintext; //Ebuyer scrape $ebuyer_html = file_get_html('http://www.ebuyer.com/product/237805'); $ebuyer_pd = $ebuyer_html->find('span[class=now]',0)->plaintext; //PcWorld scrape $pcworld_html = file_get_html('http://www.pcworld.co.uk/gbuk/apple-new-ipod-touch-8gb-4th-generation-07677427-pdt.html'); $pcworld_pd = $pcworld_html->find('p[class=prd-amount]',0)->plaintext; ?> а затем мою страницу, где она включена, и затем, которая предназначена для доступа к данным в переменных из включенного файла.
<?php include 'scrapedata.php';?> <!-- MYSQL DATABASE CODE --> <?php $db_host = 'localhost'; $db_user = 'admin'; $db_pwd = '1admin'; $database = 'stock_checker'; $table = 'price_stock'; if (!mysql_connect($db_host, $db_user, $db_pwd)) die("Can't connect to database"); if (!mysql_select_db($database)) die("Can't select database"); ?> <!-- MYSQL DATABASE CODE END-->
//Insert the scraped data into the database. mysql_query("INSERT INTO price_stock (retailer,price) VALUES('Play.com', '$play_pd' )") or die(mysql_error()); mysql_query("INSERT INTO price_stock (retailer,price,stock) VALUES('Amazon', '$amazon_pd', '$stockyesno' )") or die(mysql_error()); mysql_query("INSERT INTO price_stock (retailer,price,stock) VALUES('Currys', '$currys_pd', '$currys_stk' )") or die(mysql_error()); mysql_query("INSERT INTO price_stock (retailer,price) VALUES('Argos', '$argos_pd' )") or die(mysql_error()); mysql_query("INSERT INTO price_stock (retailer,price) VALUES('eBuyer', '$ebuyer_pd' )") or die(mysql_error()); mysql_query("INSERT INTO price_stock (retailer,price) VALUES('PCWorld', '$pcworld_pd' )") or die(mysql_error());
?>
<!-- MYSQL DATABASE % TABLE CREATION CODE --> <?php // sending query $result = mysql_query("SELECT * FROM {$table}"); if (!$result) { die("Query to show fields from table failed"); } $fields_num = mysql_num_fields($result); echo "<table width='650px'><tr>"; // printing table headers for($i=0; $i<$fields_num; $i++) { $field = mysql_fetch_field($result); echo "<td><b>{$field->name}</b></td>"; } echo "</tr>\n"; // printing table rows while($row = mysql_fetch_row($result)) { echo "<tr>"; // $row is array... foreach( .. ) puts every element // of $row to $cell variable foreach($row as $cell) echo "<td>$cell</td>"; echo "</tr>\n"; } mysql_free_result($result); ?>
Правильно ли я это сделал? Я не знаю, будут ли они автоматически включаться или они должны быть сделаны GLOBAL?