<?
echo "<table><td>Last position</td><td bgcolor=yellow>$ 0.00</td><tr><td>Position. No gap</td><td bgcolor=silver>$ 0.00</td>
<tr><td>Position. GAP!</td><td bgcolor=pink>$ 0.00</td>
</table><br><br><table width=700 border=1><td>Keyword</td><td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
<td>5</td>
<td>6</td>
<td>7</td>
<td>8</td>
<td>9</td>
<td>10</td>
<td>Income</td>
<td>Cost</td>
<td>ROI</td><tr>";
$conn = pg_connect("user=user dbname=smozle password=pass") or die(hej);
$query = "SELECT * FROM system";
$res = pg_exec( $conn, $query ) or die (hej);
$number = pg_numrows($res);
$ii =0;
while($ii < $number){
$keyword = pg_result($res,$ii,"keyword");
$db_position = pg_result($res,$ii,"position");
$username = pg_result($res,$ii,"username");
$password = pg_result($res,$ii,"password");
$position_internet = pg_result($res,$ii,"position");
$num = pg_result($res,$ii,"position");
$domain = pg_result($res,$ii,"domain");
$stock = fopen("http://www.searchfeed.com/rd/SearchResults.jsp?SearchString=$keyword", "r");
if (!$stock) {
die("Får ingen kontakt med sidan.\n");
}
$i = 0;
$max = 350;
$result[] = "inget data funnet";
while (!feof($stock) || $i == $max) {
$line = fgets($stock, 1024);
if (eregi(".*<b>URL</b>:(.*)</font>", $line, $out)) {
$result[] = $out[1];
}
if (eregi(".*<a href='/rd/AdvertiserInfo.jsp'>(.*)</a>", $line, $bidd)) {
$bid[] = $bidd[1];
}
$i++;
}
fclose($stock);
# LAST POSITION YELLOW
if ( strstr ( $result[1], "$domain" ) ){$position_internet = 1;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[2], "$domain" ) ){$position_internet = 2;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[3], "$domain" ) ){$position_internet = 3;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[4], "$domain" ) ){$position_internet = 4;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[5], "$domain" ) ){$position_internet = 5;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[6], "$domain" ) ){$position_internet = 6;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[7], "$domain" ) ){$position_internet = 7;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[8], "$domain" ) ){$position_internet = 8;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[9], "$domain" ) ){$position_internet = 9;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
if ( strstr ( $result[10], "$domain" ) ){$position_internet = 10;}if($position_internet == $db_position){}else{$bgcolor_internet[$num] = yellow;}
$bid[0] = substr("$bid[0]", 1); // returns "bcdef"
$bid[1] = substr("$bid[1]", 1); // returns "bcdef"
$bid[2] = substr("$bid[2]", 1); // returns "bcdef"
$bid[3] = substr("$bid[3]", 1); // returns "bcdef"
$bid[4] = substr("$bid[4]", 1); // returns "bcdef"
$bid[5] = substr("$bid[5]", 1); // returns "bcdef"
$bid[6] = substr("$bid[6]", 1); // returns "bcdef"
$bid[7] = substr("$bid[7]", 1); // returns "bcdef"
$bid[8] = substr("$bid[8]", 1); // returns "bcdef"
$bid[9] = substr("$bid[9]", 1); // returns "bcdef"
$bid[10] = substr("$bid[10]", 1); // returns "bcdef"
$afterbid[0] = $bid[1];if($bid[0] == $bid[1]){}if($bid[0] > $bid[1]){$afterbid[0] += 0.01;}
$afterbid[1] = $bid[2];if($bid[1] == $bid[2]){}if($bid[1] > $bid[2]){$afterbid[1] += 0.01;}
$afterbid[2] = $bid[3];if($bid[2] == $bid[3]){}if($bid[2] > $bid[3]){$afterbid[2] += 0.01;}
$afterbid[3] = $bid[4];if($bid[3] == $bid[4]){}if($bid[3] > $bid[4]){$afterbid[3] += 0.01;}
$afterbid[4] = $bid[5];if($bid[4] == $bid[5]){}if($bid[4] > $bid[5]){$afterbid[4] += 0.01;}
$afterbid[5] = $bid[6];if($bid[5] == $bid[6]){}if($bid[5] > $bid[6]){$afterbid[5] += 0.01;}
$afterbid[6] = $bid[7];if($bid[6] == $bid[7]){}if($bid[6] > $bid[7]){$afterbid[6] += 0.01;}
$afterbid[7] = $bid[8];if($bid[7] == $bid[8]){}if($bid[7] > $bid[8]){$afterbid[7] += 0.01;}
$afterbid[8] = $bid[9];if($bid[8] == $bid[9]){}if($bid[8] > $bid[9]){$afterbid[8] += 0.01;}
$afterbid[9] = $bid[10];if($bid[9] == $bid[10]){}if($bid[9] > $bid[10]){$afterbid[9] += 0.01;}
$afterbid[10] = $bid[11];if($bid[10] == $bid[11]){}if($bid[10] > $bid[11]){$afterbid[10] += 0.01;}
if(($num == 1) && ($bid[0] == $afterbid[0])){$bgcolor_internet[1] = silver;}
if(($num == 1) && ($bid[0] > $afterbid[0])){$bgcolor_internet[1] = pink;}
if(($num == 2) && ($bid[1] == $afterbid[1])){$bgcolor_internet[2] = silver;}
if(($num == 2) && ($bid[1] > $afterbid[1])){$bgcolor_internet[2] = pink;}
if(($num == 3) && ($bid[2] == $afterbid[2])){$bgcolor_internet[3] = silver;}
if(($num == 3) && ($bid[2] > $afterbid[2])){$bgcolor_internet[3] = pink;}
if(($num == 4) && ($bid[3] == $afterbid[3])){$bgcolor_internet[4] = silver;}
if(($num == 4) && ($bid[3] > $afterbid[3])){$bgcolor_internet[4] = pink;}
if(($num == 5) && ($bid[4] == $afterbid[4])){$bgcolor_internet[5] = silver;}
if(($num == 5) && ($bid[4] > $afterbid[4])){$bgcolor_internet[5] = pink;}
if(($num == 6) && ($bid[5] == $afterbid[5])){$bgcolor_internet[6] = silver;}
if(($num == 6) && ($bid[5] > $afterbid[5])){$bgcolor_internet[6] = pink;}
if(($num == 7) && ($bid[6] == $afterbid[6])){$bgcolor_internet[7] = silver;}
if(($num == 7) && ($bid[6] > $afterbid[6])){$bgcolor_internet[7] = pink;}
if(($num == 8) && ($bid[7] == $afterbid[7])){$bgcolor_internet[8] = silver;}
if(($num == 8) && ($bid[7] > $afterbid[7])){$bgcolor_internet[8] = pink;}
if(($num == 9) && ($bid[8] == $afterbid[8])){$bgcolor_internet[9] = silver;}
if(($num == 9) && ($bid[8] > $afterbid[8])){$bgcolor_internet[9] = pink;}
if(($num == 10) && ($bid[9] == $afterbid[9])){$bgcolor_internet[9] = silver;}
if(($num == 10) && ($bid[9] > $afterbid[9])){$bgcolor_internet[9] = pink;}
echo "<td>$keyword</td>
<td bgcolor=$bgcolor_internet[1]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=1>$bid[0]</a></td>
<td bgcolor=$bgcolor_internet[2]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=2>$bid[1]</td>
<td bgcolor=$bgcolor_internet[3]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=3>$bid[2]</td>
<td bgcolor=$bgcolor_internet[4]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=4>$bid[3]</td>
<td bgcolor=$bgcolor_internet[5]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=5>$bid[4]</td>
<td bgcolor=$bgcolor_internet[6]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=6>$bid[5]</td>
<td bgcolor=$bgcolor_internet[7]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=7>$bid[6]</td>
<td bgcolor=$bgcolor_internet[8]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=8>$bid[7]</td>
<td bgcolor=$bgcolor_internet[9]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=9>$bid[8]</td>
<td bgcolor=$bgcolor_internet[10]><a href=change.php?keyword=$keyword&bid=$bid[0]&position=10>$bid[9]</td>
<td>Soon</td>
<td>Soon</td>
<td>Soon</td><tr>";
$ii++;
}
echo "</table>";
?>
resultatet finns på www.smozle.com/sheet.php
Varför blir det samma "bid" på de olika sökorden? Casino ska vara mycket högre, men den tar tydligen första buden i andra raden också.
Men varför? Jag vill inte ha det så.
Michael
[Redigerat av mikaeled den 11 jan 2002]