session_start(); ?> = $i){ $i = $offset; $result[] = $offset; } } } $firstdot= $result[0]; $seconddot= $result[1]; $thirddot=$result[2]; $part1=substr ( $ip, 0, $firstdot); $part2=substr ( $ip, $firstdot+1, $seconddot-$firstdot-1); $part3=substr ( $ip, $seconddot+1, $thirddot-$seconddot-1); $part4=substr ( $ip, $thirddot+1, 3); $decimalip= $part1*16777216+$part2*65536+$part3*256+$part4; $sql = "SELECT * FROM `iplist` WHERE `ipfrom` <= $decimalip and `ipto` >= $decimalip"; $countrylist = mysql_query($sql) or die("$sql"); $hits=mysql_num_rows ($countrylist); $countryval="Unknown"; $stateval=" "; $cityval=" "; if($hits>0){ $row = mysql_fetch_assoc($countrylist); $countryval=$row['country']; $stateval=$row['state']; $cityval=$row['city']; } // echo ("hits: ".$hits." IP: ".$ip." Decimal IP: ".$decimalip." Retval: ".$retval); $_SESSION['country']=$countryval; $_SESSION['state']=$stateval; $_SESSION['city']=$cityval; $rawkeyword_string = $_GET['searchval']; // In case the search value is passed between pages $referertext=$_SERVER['HTTP_REFERER']; $_SESSION['refererstring']=$referertext; $parsed_url=parse_url($referertext); $querystring=$parsed_url; $googleresult=strpos($parsed_url['host'],'google'); $yahooresult=strpos($parsed_url['host'],'yahoo'); $bingresult=strpos($parsed_url['host'],'bing'); $AOLresult=strpos($parsed_url['host'],'aol'); $askresult=strpos($parsed_url['host'],'ask.com'); $dogpileresult=strpos($parsed_url['host'],'dogpile.com'); if($googleresult !== false): parse_str($parsed_url['query'],$parsed_query_string); $rawkeyword_string=$parsed_query_string['q'].'[G]'; $_SESSION['keyword']=$rawkeyword_string; $_SESSION['engine']="Google"; elseif($yahooresult !== false): parse_str($parsed_url['query'],$parsed_query_string); $rawkeyword_string=$parsed_query_string['p'].'[Y]'; $_SESSION['keyword']=$rawkeyword_string; $_SESSION['engine']="Yahoo"; elseif($bingresult !== false): parse_str($parsed_url['query'],$parsed_query_string); $rawkeyword_string=$parsed_query_string['q'].'[B]'; $_SESSION['keyword']=$rawkeyword_string; $_SESSION['engine']="Bing"; elseif($AOLresult !== false): parse_str($parsed_url['query'],$parsed_query_string); $rawkeyword_string=$parsed_query_string['query'].'[AOL]'; $_SESSION['keyword']=$rawkeyword_string; $_SESSION['engine']="AOL"; elseif($askresult !== false): parse_str($parsed_url['query'],$parsed_query_string); $rawkeyword_string=$parsed_query_string['q'].'[Ask]'; $_SESSION['keyword']=$rawkeyword_string; $_SESSION['engine']="Ask.com"; else: $_SESSION['engine']="None"; $_SESSION['keyword']="None"; $destination="Landed"; endif; } // Session variables are now defined $keyword_string=rawurlencode($_SESSION['keyword']); // Write to Database $db = MYSQL_CONNECT($roothostname,$rootusername, $rootpassword) OR DIE("Unable to connect to database"); $db1 = mysql_select_db($dbName, $db) or die ("Couldn't select database."); $time = date("Y-m-d H:i:s"); $justdate = date("Y-m-d"); $ip=$_SESSION['hostip']; $kw=$_SESSION['keyword']; $country=$_SESSION['country']; $engine=$_SESSION['engine']; $thissession=session_id(); $referertext=$_SESSION['referer']; $pagename="toolsarticle"; $qry="INSERT INTO `clicks` (`date_clicked` , `justdate`, `ip_address` , `page`, `keyword`,`engine`,`session`, `dest_url`, `country`, `referer`, `city`, `state`) VALUES ('$time', '$justdate','$ip' , '$pagename' , '$kw', '$engine', '$thissession', '$destination', '$country','$referertext','$cityval','$stateval');"; mysql_query($qry) or die("something went wrong"); ?>
Debit CardsDebit cards are not credit cards per se. Instead, they are cards that look like credit cards and are used like credit cards, but actually withdraw funds from your checking account with each use. Pre-paid credit cards are another form of debit card, since the funds are deposited ahead of time and drawn down with each use. Merchant gift cards are also classified as pre-paid debit cards. Checking account debit cards are generally available at no charge from the bank that holds your checking account. To prevent use if the card is lost or stolen, consumers using debit cards must enter a PIN with each use of the card. However, in many cases, a debit card can be used like a credit card and a signature rather than a PIN number is required. Some debit card issuers, such as Pay Pal, offer consumers the option of using the debit card as a credit card and receiving a 1% rebate for each purchase. This is similar to the rewards offered by credit cards and comes out of the fees charged to retailers every time a consumer uses his or her credit card. Some debit card issuers allow their checking account holders to use their debit cards as a form of “instant credit” should their purchase exceed the checking account balance. Many consumers prefer the debit card over check-writing or using cash. Their contention is that it speeds up check-out time and gives them a better record of their own purchasing habits. And, since there are some protections if a card is lost or stolen, debit cards are safer than carrying large sums of cash.
|