\r\n"; echo "\r\n"; echo ""; echo "Astroland Doubles Search Engine"; $queryvariable = $_GET['queryvariable']; if (isset($_POST['searchstring'])) { $searchstring=$_POST['searchstring'];} else {$searchstring="";} if ($queryvariable !="") {$searchstring=$queryvariable;} echo "
\r\n"; echo "
\r\n"; echo ""; echo "
\r\n"; echo "\r\n"; echo "\r\n"; echo "\r\n"; echo "
\r\n"; if($searchstring) { $searchstring = str_replace("#","",$searchstring); $searchstring = str_replace("@","",$searchstring); $searchstring = str_replace("%","",$searchstring); $searchstring = str_replace("'","\'",$searchstring); } if ($searchstring && $searchstring!="") // perform search only if a string was entered. { $connid = mysql_connect ('localhost' , 'rastrono' , 'sinhosejar'); mysql_select_db ("rastrono_numbers"); $connid = mysql_connect ('localhost' , 'rastrono' , 'sinhosejar'); mysql_select_db ("rastrono_numbers"); $searchstring = str_replace("Cedeno","CedeÑo",$searchstring); $searchstring = str_replace("Cedeño","CedeÑo",$searchstring); $searchstring = str_replace("cedeño","CedeÑo",$searchstring); $searchstring = str_replace("cedeno","CedeÑo",$searchstring); $searchstring = str_replace("CEDEÑO","CedeÑo",$searchstring); $searchstring = str_replace("CEDENO","CedeÑo",$searchstring); $searchstring = str_replace("Centeno","Centeño",$searchstring); $searchstring = str_replace("Centeño","Centeño",$searchstring); $searchstring = str_replace("centeño","Centeño",$searchstring); $searchstring = str_replace("centeno","Centeño",$searchstring); $searchstring = str_replace("CENTENO","Centeño",$searchstring); $searchstring = str_replace("CENTEÑO","Centeño",$searchstring); $searchstring = str_replace("Beltran","Beltrán",$searchstring); $searchstring = str_replace("beltran","Beltrán",$searchstring); $searchstring = str_replace("Beltrán","Beltrán",$searchstring); $searchstring = str_replace("beltrán","Beltrán",$searchstring); $searchstring = str_replace("BELTRAN","Beltrán",$searchstring); $searchstring = str_replace("BELTRÁN","Beltrán",$searchstring); $searchstring = str_replace("Trainers","Trainer",$searchstring); $searchstring = str_replace("trainers","Trainer",$searchstring); $searchstring = str_replace("TRAINERS","Trainer",$searchstring); $searchstring = str_replace("Mascots","Mascot",$searchstring); $searchstring = str_replace("mascots","Mascot",$searchstring); $searchstring = str_replace("MASCOTS","Mascot",$searchstring); $searchstring = str_replace("Refractors","Refractor",$searchstring); $searchstring = str_replace("refractors","Refractor",$searchstring); $searchstring = str_replace("REFRACTORS","Refractor",$searchstring); $searchstring = str_replace("Albertson's","Albertsons",$searchstring); $searchstring = str_replace("albertson's","albertsons",$searchstring); $searchstring = str_replace("ALBERTSON'S","albertsons",$searchstring); $searchstring = str_replace("Mothers","Mother's",$searchstring); $searchstring = str_replace("mothers","Mother's",$searchstring); $searchstring = str_replace("MOTHERS","Mother's",$searchstring); $searchstring = str_replace("X-fractors","Xfractor",$searchstring); $searchstring = str_replace("x-fractors","Xfractor",$searchstring); $searchstring = str_replace("X-FRACTORS","Xfractor",$searchstring); $searchstring = str_replace("Xfractors","Xfractor",$searchstring); $searchstring = str_replace("xfractors","Xfractor",$searchstring); $searchstring = str_replace("XFRACTORS","Xfractor",$searchstring); $searchstring = str_replace("Proofs","Proof",$searchstring); $searchstring = str_replace("proofs","Proof",$searchstring); $searchstring = str_replace("PROOFS","Proof",$searchstring); $searchstring = str_replace("Plates","Plate",$searchstring); $searchstring = str_replace("plates","Plate",$searchstring); $searchstring = str_replace("PLATES","Plate",$searchstring); $searchstring = str_replace("Bowmna","Bowman",$searchstring); $searchstring = str_replace("Pinacle","Pinnacle",$searchstring); $searchstring = str_replace("Tops ","Topps ",$searchstring); $searchstring = str_replace("Goudy","Goudey",$searchstring); $searchstring = str_replace("Afficionado","Aficionado",$searchstring); $searchstring = str_replace("Tuscon","Tucson",$searchstring); $searchstring = str_replace("tuscon","Tucson",$searchstring); $searchstring = str_replace("OPC","O-Pee-Chee",$searchstring); $searchstring = str_replace("bowmna","Bowman",$searchstring); $searchstring = str_replace("pinacle","Pinnacle",$searchstring); $searchstring = str_replace("tops ","Topps ",$searchstring); $searchstring = str_replace("goudy","Goudey",$searchstring); $searchstring = str_replace("afficionado","Aficionado",$searchstring); $searchstring = str_replace("Topps 205","Topps X205",$searchstring); $searchstring = str_replace("topps 205","topps X205",$searchstring); $searchstring = str_replace("Topps 206","Topps X206",$searchstring); $searchstring = str_replace("topps 206","topps X206",$searchstring); $searchstring = str_replace("topps 52","topps X52",$searchstring); $searchstring = str_replace("row 3","row X3",$searchstring); $searchstring = str_replace("row 2","row X2",$searchstring); $searchstring = str_replace("row 1","row X1",$searchstring); $searchstring = str_replace("Row 3","row X3",$searchstring); $searchstring = str_replace("Row 2","row X2",$searchstring); $searchstring = str_replace("Row 1","row X1",$searchstring); $searchstring = str_replace("opc","O-Pee-Chee",$searchstring); $searchstringname = array(); $searchstringfirstletter=array(); $searchbufferleading=array(); $searchbuffertrailing=array(); $stringoffset=0; $propersearchstring=""; $searcharray = preg_split("/[\s]/",$searchstring); for ($k=0;$k"; echo ""; while ($row = mysql_fetch_assoc($result)) { $name = rtrim($row['Name']); $card = rtrim($row['Card']); $price = rtrim($row['Price']); $sort = rtrim($row['Sort']); $name=str_replace(" ^","",$name); $name=str_replace("^ ","",$name); $card=str_replace("^ ","",$card); $card=str_replace(" ^","",$card); $sort=str_replace("^ ","",$sort); $sort=str_replace(" ^","",$sort); $aname=$card.$name; $aname=strtolower($aname); $aname=str_replace(" ","",$aname); $aname=str_replace(".","",$aname); $aname=str_replace("&","",$aname); //$aname=str_replace("/","",$aname); $aname=str_replace("'","",$aname); $aname=str_replace("-","",$aname); $aname=str_replace("(","",$aname); $aname=str_replace(")","",$aname); $aname=str_replace("#","",$aname); $name = str_replace("\\","",$name); $name = str_replace(" ^","",$name); $name = str_replace("[ Auto ]","",$name); $name = preg_replace ("/\[[^\].]*\]/","",$name); $i++; $firstletter = array(); $cardarray = array(); $card =strtolower($card); if (strpos($card,"/") != false) {$slashpos=strpos($card,"/")+1; $slashflag=1;} else {$slashflag=0;} $cardarray = preg_split("/[\s\/]/ ",$card); $card=""; for ($n=0;$n\r\n"; } if ($i=="") {$i=0; echo ""; } } else { $i=0; echo "
Search Results in Doubles for \"".str_replace("Ñ","ñ",rtrim(ltrim($propersearchstring)))."\"
 
"; if ($i < 10) {echo "    ";} elseif ($i<100) {echo "  ";} if ($i%2 ==1) {$backgroundstyle="style=\"color:black;background-color:darkgray\" ";$fontcolor=black;} else {$backgroundstyle="";$fontcolor="white";} echo $i."."; $nbspvar ="       "; if (strlen($name) > 80) { $offset = 0; // initial offset is 0 $spaceCounter = 0; // Check the rest of the string for spaces while($offset = strpos($name," ",$offset + 1)){ if ($offset > 40 && $offset < 64 && strpos($name,"#")!=$offset - 1) {$breakpoint = $offset;} } } if (strpos($name,"(") != false) { $parenthesecheckers = substr($name,strpos($name,"(")+1,1); if ($parenthesecheckers !="" && preg_match("/[p123456789]/",$parenthesecheckers)) { $suffix = substr($name,strpos($name,"(")); $name = substr($name,0,strpos($name,"("));} else {$suffix="";} } else {$suffix="";} $card=str_replace("/ ","/",$card); if (strpos($name,"Mc")>0) { $mcpos=strpos($name,"Mc"); $lettertoupper = substr($name,$mcpos+2,1); $name = substr_replace($name,strtoupper($lettertoupper),$mcpos+2,1);} if (strpos($name,"(")==1 ) { $parenthpos=strpos($name,"("); $lettertoupper = substr($name,$parenthpos+1,1); $name = substr_replace($name,strtoupper($lettertoupper),$parenthpos+1,1);} $numbersignstrpos=strpos($card,"#"); $descandcardnumber = substr($card,$numbersignstrpos+2); $originaldescandcardnumber=$descandcardnumber; $firstspaceafter=strpos($descandcardnumber," "); if ($firstspaceafter=="") {$cardnumber=strtoupper($descandcardnumber); $card=str_replace($descandcardnumber,$cardnumber,$card); } else { $cardnumber = substr($descandcardnumber,0,$firstspaceafter); $originalcardnumber=$cardnumber; $cardnumber=strtoupper($cardnumber); $descandcardnumber=str_replace($originalcardnumber,$cardnumber,$descandcardnumber);} $card = str_replace($originaldescandcardnumber,$descandcardnumber,$card); $card=str_replace("AUTO","Auto",$card); $card=str_replace("Spx","SPx",$card); $card=str_replace("Sspc","SSPC",$card); $card=str_replace("O-pee-chee","O-Pee-Chee",$card); $card=str_replace("^ ","",$card); $card=str_replace(" ^","",$card); if (strpos($name,"'")>0 ) {$apospos=strpos($name,"'"); $lettertoupper = substr($name,$apospos+5,1); $name = substr_replace($name,strtoupper($lettertoupper),$apospos+5,1);} $name = str_replace("?n","án;",$name); $name = str_replace("?","ñ",$name); $name = str_replace("Ño","ño",$name); $card = str_replace("Non-astros","Non-Astros",$card); $card = str_replace("'S","'s",$card); $card = str_replace("Sp Authentic","SP Authentic",$card); $card = str_replace("Focus Je ","Focus JE ",$card); $card = str_replace(" Ud "," UD ",$card); $card = str_replace(" Lb "," LB ",$card); if (substr($name,0,9) !="1977 TCMA" && substr($name,0,9) !="1978 TCMA") { if (substr($name,5,6) !="Choice") { $name = preg_replace("/# 0(?=[1-9])/", "# ", $name);} else { $name = preg_replace("/# 000(?=[1-9])/", "# 0", $name); $name = preg_replace("/# 00(?=[1-9])/", "# ", $name); } $name = preg_replace("/# 000(?=[1-9])/", "# ", $name); $name = preg_replace("/# 00(?=[1-9])/", "# ", $name); } $name = preg_replace("/ - 000(?=[1-9])/", "-   ", $name); $name = preg_replace("/ - 00(?=[1-9])/", "-  ", $name); $name = preg_replace("/ - 0(?=[1-9])/", "- ", $name); $name = preg_replace("/P000(?=[1-9])/", "P", $name); $name = preg_replace("/P00(?=[1-9])/", "P", $name); $name = preg_replace("/P0(?=[1-9])/", "P", $name); $name = preg_replace("/C000(?=[1-9])/", "C", $name); $name = preg_replace("/C00(?=[1-9])/", "C", $name); $name = preg_replace("/C0(?=[1-9])/", "C", $name); $name = preg_replace("/UH000(?=[1-9])/", "UH", $name); $name = preg_replace("/UH00(?=[1-9])/", "UH", $name); $name = preg_replace("/UH0(?=[1-9])/", "UH", $name); $name = preg_replace("/US-000(?=[1-9])/", "US-", $name); $name = preg_replace("/US-00(?=[1-9])/", "US-", $name); $name = preg_replace("/US-0(?=[1-9])/", "US-", $name); $name = preg_replace("/T000(?=[1-9])/", "T", $name); $name = preg_replace("/T00(?=[1-9])/", "T", $name); $name = preg_replace("/T0(?=[1-9])/", "T", $name); $name = preg_replace("/10000/", "10,000", $name); $name = preg_replace("/Topps Chrome Red Xfractor/", "Topps Chrome (Red) Xfractor", $name); $name = preg_replace("/Topps Chrome Update Red Xfractor/", "Topps Chrome Update (Red) Xfractor", $name); $name = preg_replace("/2004 Topps Chrome White Refractor/", "2004 Topps Chrome (White) Refractor", $name); $name = preg_replace("/2005 Topps Chrome White Refractor/", "2005 Topps Chrome (White) Refractor", $name); if (strpos($name,"First 2,000 Printed") != false) {$name = str_replace("First 2,000 Printed","",$name); $first2000flag=1;} if (strpos($name,"one of 2000") != false) {$name = str_replace("one of 2000","",$name); $oneof2000flag=1;} if (strpos($name,"one of 500") != false) {$name = str_replace("one of 500","",$name); $oneof500flag=1;} if (strpos($name,"Rated Rookie") != false) {$name = str_replace("Rated Rookie","",$name); $ratedrookieflag=1;} if ($first2000flag==1) {echo "1st 2,000 Printed"; $first2000flag=0;} if ($oneof2000flag==1) {echo "one of 2000"; $oneof2000flag=0;} if ($oneof500flag==1) {echo "one of 500"; $oneof500flag=0;} if ($ratedrookieflag==1) {echo "Rated Rookie"; $ratedrookieflag=0;} $playerinitial =substr($sort,0,1); $asciicode=ord($playerinitial); if ($asciicode> 64 && $asciicode < 72) {$doublespage="";} if ($asciicode> 71 && $asciicode < 80) {$doublespage="2";} if ($asciicode> 79) {$doublespage="3";} echo $suffix.$card." ".$name.""; echo ""; echo number_format($price,2)."
Sorry, but feel free to try again!
Please enter a search.";} if ($i ==1) {$cardtense="Card";} else {$cardtense = "Cards";} echo "
".$i." Different ".$cardtense; if ($i>0) {echo "

"; echo "

"; if ($searchstring) {mysql_close ($connid);} }


Astroland:
Search Engine Home Page Doubles For Sale or Trade Doubles Search Engine
Autographed Card Counter Beckett Low Breakdown Beckett High Breakdown Bowman Chrome Rainbow Finder
Bowman Chrome Worksheets Complete Sets Game Bat Card Counter Game-Used "Fabric" Card Counter
The Hundred Club Jersey-Numbered Numbereds Leaf Certified Cuts Worksheet Leaf Certified Mats Worksheets
Minor League Singles Minor League Teamsets Numbered Card Counter Parallel Want Finder
Topps Chrome Worksheets Upper Deck Heroes Worksheet Upper Deck Special F/X Worksheet Wantlist Search Engine
Cards by Year