php include-如何在包含变量的地方使用变量?
|
我正在尝试包含一个文件,该文件正在从各种网站上抓取我的所有数据,但是该文件无法正常工作。这是我的代码。
首先,抓取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 i.e. $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?
没有找到相关结果
已邀请:
4 个回复
社攻取墟槽
旦彤
和
与您的已发布代码有关:我看不到将数据添加到数据库的位置。你不应该那样做吗?
届甸衬丝蚕
弛保矮瘦敖