Code: Select all
<html>
<body >
<?php
// Get the ID and number of loops
if(!$_POST[ "submit" ])
{
echo " Please go to input.php and fill up! "; } else {
$offset = $_POST[ "boundry" ];
// Get into loop
for ($i=0; $i<$offset; $i++)
{
//$id = 290603968340;
$id = $_POST[ "fname" ];
$key = "http://www.ebay.co.uk/itm/";
$pID =$id + $i;
$format = $key.$pID;
echo $format."<br />";
// If the listing has ended:
if($site = @file_get_contents($format))
{
echo "Id is valid <br />";
if ( preg_match('@("v4-1-msg")@', $site, $ended) ==false )
{
echo "match- Yes.". "Product available! <br /> ";
// Item condition:
if ( preg_match('@(vi-is1-condText">)(.{1,10})(<)@', $site, $condition) )
{
echo "match- Yes ";} else {echo "match- No ";
}
$con = $condition[2];
echo "Item condition : ".$con."<br />";
// Sold:
if (preg_match('@(>)(.{1,4})(sold<)@', $site, $qtysold) )
{
echo "match- Yes "; $sold = $qtysold[2];} else { echo "match- No "; $sold = 0;
}
echo "Sold so far : ".$sold."<br />";
// Price:
if ( preg_match('@("vi-is1-prcp")(.{5,30})(<)@', $site, $pprice) )
{
echo "match- Yes ";
if(preg_match('@(\$)(.*)@', $pprice[2], $priceUSD))
{
$Price = $priceUSD[2]; $pcurrency= "$";
$pr = $priceUSD[2];
echo "Price : ".$pr."<br />";
}
else
{
preg_match('@(">)(.*)@', $pprice[2], $priceGBP);
$Price = $priceGBP[2]; $pcurrency= "£";
$pr = $priceGBP[2];
echo "Price : ".$pr."<br />";
}
} else {echo "match- No <br />";
}
// Delivery: fshippingCost, 2 option Free or Value also Currency
if ( preg_match('@(fshippingCost")(.{0,80})(>)(.{3,10})(</span>)@', $site, $delivery) )
{
echo "match- Yes ";} else {echo "match- No ";
}
if ( preg_match('@(Free)@', $delivery[0], $outa) )
{
$deliverycost = 0; $currency="£";} else {
preg_match('@(">)(.*)(<)@', $delivery[0], $outF);
if(preg_match('@(£)(.*)@', $outF[2], $delGBP))
{
$deliverycost = $delGBP[2];
$currency= "£";} else {preg_match('@(\$)(.*)@', $outF[2], $delUSD);
$deliverycost = $delUSD[2];
$currency= "$";
}
}
$dc = $currency.$deliverycost;
echo "Delivery cost : ".$dc."<br />";
// Seller:
if ( preg_match('@("mbg-nw">)(.{1,50})(</)@', $site, $seller) )
{
echo "match- Yes ";} else {echo "match- No ";
}
$sp = $seller[2];
echo "Seller : ".$sp."<br />";
// Product discription:
if ( preg_match('@("vi-is1-titleH1">)(.{1,100})(</)@', $site, $discription) )
{
echo "match- Yes ";} else {echo "match- No ";
}
$dp = $discription[2];
echo "Product Discription : ".$dp."<br />"; }else {echo "Listing ended <br />";
}
}
else
{
echo "This product is no longer available <br/>";
}
echo $pID."<br />";
}
//*
// mySQL
//connect
// display
mysql_connect("localhost","root") or
die('Could not connect to MySQL: ' . mysql_error());
echo "Connection OK"."<br/>";
// Select DB, Table and Insert Data
mysql_select_db("mydb") or
die('Could not connect to Database: ' . mysql_error());
echo "Connected to Database"."<br/>";
$res = mysql_query("SELECT *
FROM etb ");
mysql_query(
" INSERT INTO `mydb`.`etb` (`ID`,`pID`,`description`,`condition`,`price`,`delivery`,`sold`,`Seller`)
VALUES(NULL, '$pID','$dp','$con','$pr','$dc','$sold','$sp' ) "
) or die('Could not insert to Database: ' . mysql_error());
echo "Data inserted into Database"."<br/>";
}
?>
<table width="700" border="1" cellspacing="0" cellpadding="0">
<tr>
<td>ID</td>
<td>Product ID</td>
<td>Description</td>
<td>Product Condition</td>
<td>Price</td>
<td>Delivery Cost</td>
<td>Sold so far</td>
<td>Seller</td>
<?php
while($display = mysql_fetch_array($res))
{
echo "<tr><td>",$display['ID'],"</td><td>",$display['pID'],"</td><td>",$display['description'],"</td><td>",$display['condition'],"</td><td>",$display['price'],"</td><td>",$display['delivery'],"</td><td>",$display['sold'],"</td><td>",$display['Seller'],"</td></tr>" ;
}
?>
</table>
</body>
</html>
above is the code of my work. price is displayed on the page, but it would not be updated in database and because of that can not display in table.