timmah1 Posted August 7, 2009 Share Posted August 7, 2009 On a web site a friend made, they have a page that is grabbed from a different web site <?php echo file_get_contents("http://sportscapping.com/new/export/?AF28_36/export/all_cappers"); ?> Now, this formatting is not very good, so what I would like to try and do, is take the info from that page, and just put it in a database. How would I go about doing this? Here is the page itself from viewing the source <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/337/Wunderdog/AF28_36">Wunderdog</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> The Dog is passing on MLB today. Check back tomorrow for more MLB winners and football info! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/300/Matt Fargo/AF28_36">Matt Fargo</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> • **10** MLB #1 TOP REPORTS 4-3 (57%) YTD • • 9* MLB TOTAL DOMINATOR ***3-0 SUNDAY*** • Fargo is coming off a PERFECT Sunday as he SWEPT his baseball reports with all three games ‘Over’! Those games surpassed the posted totals by a combined 22 ru... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/317/Mike Lineback /AF28_36">Mike Lineback</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> No added picks for Thursday. Next scheduled report Friday 5:30p ET. Full-time Professional handicapper with 5+ years of documented profit-taking. Only handicap Football, NBA & MLB. Below market prices. Invest in a long term membership plan t... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/280/John Martin/AF28_36">John Martin</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> *86-74 Overall Run Gaining +1275 Units!* Despite a losing card Wednesday, it has still been a great week for premium clients as 4 OF MY LAST 5 CARDS PROFIT! Come bet along side the DEFENDING 2008 MLB World Handicapping CHAMPION with my Thursday MLB... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/312/Alex Grosse/AF28_36">Alex Grosse</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Alex has another solid 5 unit winner for Wednesday afternoon. He is currently on a 4-1 Run in his last 5 recorded Top Plays! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/304/Craig Trapp/AF28_36">Craig Trapp</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> 5-1 the last five days and 15-6 over the last two weeks. A rough loss yesterday but Craig is starting a new streak with two top plays: 5 star Early Riser and Grand Slam NL 5 star Play of week! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/296/Tony George/AF28_36">Tony George</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Tony George has been in the ethical Handicapping Business since 1992, Over 40 Top 10 Awards from respected monitors. EXPERIENCE COUNTS with a proven winner who is respected nationwide. </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/331/Steve Merril/AF28_36">Steve Merril</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Steve Merril's 21-6 MLB run continues with a powerful Blowout Winner for Thursday night - Guaranteed to CRUSH THE LINE! Get each of Steve Merril's selections on a daily basis or you can save 75% with Weekly and Monthly packages which includes ever... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/344/Jamie Tursini/AF28_36">Jamie Tursini</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> ***LIVE DOG ALERT***40* Winner Up & Ready! ***Early Bird Football Up*** Jamie destroyed the books in 2008 hitting a documented 70% in the NFL! Get his Early-Bird Subscription now at an unbelievable price! A "Vegas Pro" Working For You! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/278/Info Plays/AF28_36">Info Plays</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Long-Term 63-38 (62%) Run on 10* Top Plays has $1,000/Unit Clients Up $212,000! Larry Cook finally cooled off last night, suffering two 1-run losses and a 2-run loss! He'll get back at the books today with his 10* A.L. Thursday Afternoon GOLD MINE ... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/282/Nick Jones/AF28_36">Nick Jones</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Sign up today with Nick Jones and start winning! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/264/Jack Jones/AF28_36">Jack Jones</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> 15* cashes in on Seattle last night. For Thursday I'm sticking with one play, a 15* total scheduled for 2:05 PM EST. Get in on it now! We are having a great season with a 134-108 record for +2,508 units with my last 235 picks, plus a 41-24 record ... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/288/Eddie McKinney/AF28_36">Eddie McKinney</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Thursday August 6, 2009 - Fast Eddie Sports has MLB plays going today !!! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/299/Vernon Croy/AF28_36">Vernon Croy</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> *** GUARANTEED *** Join Vernon Croy Friday Night if you are looking for 1 solid MLB Play that cashes hands down backed by a full in-depth report! This HUGE play is GUARANTEED to cash or you get the next day 100% FREE! GET ON IT NOW! Full Exper... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/291/Steve Janus/AF28_36">Steve Janus</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Steve Janus is passing on Thursday's MLB Games. </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/311/Mikey Sports/AF28_36">Mikey Sports</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Mikey Sports has a Top 5* MLB Play for Thursday and a 3* Preseason NFL Play ready for Sunday!! Mikey Sports is 17-10 63% Last 27 MLB Top Plays! 17-11 61% Last 28 NBA Plays! Mikey Sports finished the CBB Season rated #1 83-54 60.6%!! 12-4 in NFL Prese... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/307/Jay Todd/AF28_36">Jay Todd</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> ***Profited 13 of last 14 days & 24-8 L24 (75%) overall plays*** There is no one better than Todd right now! Since the All Star Break he has been ABSOLUTELY DOMINANT. Todd is 16-4 L19 (80%) and 44-26 (63%) overall *10* unit plays. How is that for num... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/322/Big Al McMordie/AF28_36">Big Al McMordie</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Al McMordie is the most honored technical handicapper in the country, with 34 Handicapping Championships since 1992, including the $100,000 World Series of Sports Handicapping in 2007, and the Stardust Casino Football Invitational in 2004. Big Al ha... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/339/Hunter Price/AF28_36">Hunter Price</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> There's no time like the present to jump on board as he helps build your sports book account into a investment that works for you. As always, each package includes a profitability guarantee. You turn a profit or receive an additional package fre... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/343/Dennis Macklin /AF28_36">Dennis Macklin</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> In an industry that offers no guarantees, of one thing you can be certain. Nobody works harder or is better prepared to get YOU the money. The Mack Attack has your back and the best is yet to come. </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/269/Jimmy Boyd/AF28_36">Jimmy Boyd</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> ***5* 2009 NATIONAL LEAGUE GAME OF THE YEAR*** No. 2 Ranked Overall Handicapper in the World in 2009 ($1,000/Game Bettors up $59,720)! $1,000/Unit Bettors are up $192,000 this year! Jimmy takes the books to school with a 3-1 Wednesday slaughter (w... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/275/Dave Price/AF28_36">Dave Price</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Back with one bullet Thursday! Our Impressive 52-30 All Picks Run (63%, +1712) and 39-22 7* Top Play Run (64%, +1176) continues with my Red Sox/Yankees 7* A.L. EAST GAME OF THE MONTH! Get ready to GO LARGE on baseball's biggest rivalry! ***SPECIAL... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/345/Jordan Haimowitz/AF28_36">Jordan Haimowitz</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> A split last night was the result. However, we hit our 4 STAR Bookmakers Bust on the Astros. Another night of profita, grab Jordan's Tuesday MLB plays now and you'll start winning tonight. If picks don't hit, you get the next days All-Access Pass ... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/319/R&R Totals/AF28_36">R&R Totals</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> R&R Totals has a Top MLB Over-Under for Thursday! R&R Totals is 82-52 61% In MLB This Season!! R&R Totals is now 20-10 67% Last 30 MLB Top Plays! Join us today!! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/342/Robbie Gainous/AF28_36">Robbie Gainous</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Robbie is passing on Thursday's MLB Card we will return on Friday with our next MLB Report. </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/321/Tom Freese/AF28_36">Tom Freese</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Tom Freese is releasing his MLB 10* TOTAL OF THE WEEK Wednesday. Tom is a SOLID 59% with his OVER/UNDER plays this year. Join Tom now and TOTALLY CRUSH the Sports Books! You'll be real glad you did! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/271/Jeff Alexander/AF28_36">Jeff Alexander</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> ***18-5 L23 5* Wiseguy GAME OF THE YEAR Plays (78%)*** After a scorching hot July, we've taken a few lumps in the first few days of August. Regulars can say with complete confidence that the books have never been able to keep me down for long. A n... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/298/Jerry Johnson/AF28_36">Jerry Johnson</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Jerry Johnson is one of the most honest and trusted handicappers in the world. A proven winner across the board! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/332/John Ryan/AF28_36">John Ryan</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> 7-0 with 7* Titans this week after a perfect 3-0 sweep last night with Phils, Cleveland, and +130 dog MLW. The combined score of these games was an amazing 19-2! Join Ryan for his COMPLETE card. First card goes off early so join him now for another 7... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/302/Ben Burns/AF28_36">Ben Burns</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Competing against a field of 150, Ben Burns is the #1 ranked NFL Handicapper in the entire history of one of the Internet's longest running and most respected sports monitors! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/305/Pure Lock/AF28_36">Pure Lock</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Pure Lock has TWO TOP MLB PLAYS for Thursday! Pure Lock is 20-9 69% Last 29 MLB Top Plays! Never had a season below 60% in CFB! 31-13 70% last 3 years in College Football! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/347/Ross Benjamin/AF28_36">Ross Benjamin</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Ross Benjamin is an award winning professional sports handicapper as well as a national sports talk radio show host of "The Ross Benjamin Show" on the Sports Journey Radio Network. </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/340/Freddy Wills/AF28_36">Freddy Wills</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> We look to bounceback as we have done so often after a losing day here with our shocking POD winner available for JUST $20! 13-5 lAST 18 Continue to check out our winning sports pick packages with our pre-season NFL package special! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/289/Timothy Black/AF28_36">Timothy Black</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> The hottest handicapper around, Timothy Black has clients up 3250 units over the last 60 days while hitting almost 60% of his plays! Overall, premium clients are now up over 3600 units this season with your #1 MLB handicapper! Check in for another ... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/279/Black Widow/AF28_36">Black Widow</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> After Back-to-Back WINNING CARDS to start the week, Bill Young gave some of it back Wednesday with a poor showing! Don't sweat it because he'll get it all back and then some tonight with his 6* Widow Wiseguy N.L. Thursday Late-Night Lock! This play... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/303/Evan Altemus/AF28_36">Evan Altemus</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> I have been on documented as having one of the best overall starts in college football and NFL. I am already up over 20 units of profit in just the month of October, so don't miss out! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/306/Mr. East/AF28_36">Mr. East</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> The one thing I will never be guilty of is offering any selection, on any event, without a detailed analysis of the game in hand. The biggest reason for my success is coupling years of knowledge and my professional sports background, with relentless ... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/315/JR O'Donnell/AF28_36">JR O'Donnell</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> HALL OF FAME GAME NFL BILLS/TITANS SUNDAY TOP PLAY!!!!! GRAB THE BEST NFL TOP SHELFER TODAY.. + ******Thursday's 5-0 TOP PLAY MLB Smash Set****** ... check out the football & another power play mlb comp thursday + We are Grabbi... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/286/Rocky Atkinson/AF28_36">Rocky Atkinson</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Rocketman has his TOP RATED 5* MLB Game of the Month on Thursday! 46-33 59% in MLB this year! +138.35 units in the NHL this year! 5-2 71% last 7 5* MLB plays! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/320/Michael Alexander/AF28_36">Michael Alexander</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Michael had a tough day on the diamond yesterday but GUARANTEES to HAMMER the books today! In fact, Michael has been dominant on Thursday going a stellar 10-4 the L5 Thursdays! Today he continues to own Thursdays with his Hardball Full Card Hammer!... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/292/Bob Harvey/AF28_36">Bob Harvey</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Bob Harvey is having a monster MLB season. He's hitting sides and totals on a nightly basis. Let Bob help make your MLB sports investing a profitable one. </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/294/Rob Vinciletti/AF28_36">Rob Vinciletti</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> GOLDEN CONTENDER SPORTS FINISHED UP WITH OVER 110 UNITS OF PROFIT IN HOOPS THIS YEAR FINISHING AS THE #1 OVERALL NBA REGULAR SEASON SERVICE AT THE MYHANDICAPPER MONITOR.BASES HAS BEEN PIPING HOT.IF YOUR TIRED OF PAYING FOR HIGH PRICED FAVORITES,AND W... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/335/Carlo Campanella/AF28_36">Carlo Campanella</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Carlo Campanella, also known as The Iron Horse, due to his SELECTIVE Handicapping approach. Campanella usually offers his highest-rated picks each day, usually ONLY 1 pick per sport and on rare occasions 2 picks. If you're looking for games to LOAD... </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/301/Doc's Sports/AF28_36">Doc's Sports</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> This will be Doc's Sports 37th Year in the industry and the legend just continues to grow. We have full time handicappers in all major sports, check them out! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/333/Jorge Gonzalez /AF28_36">Jorge Gonzalez</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Jorge is Locked and loaded with Winners full of value for the second half of the football season! Play with the the Red Hot Vegas Kid and Ca$h in!! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/348/Joseph D'Amico/AF28_36">Joseph D'Amico</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Joe D'Amico is ON FIRE in the MLB. Don't miss out on his daily winners. </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/346/Mark Franco/AF28_36">Mark Franco</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Mark Franco is working hard for the coming Football season to bring you another winning year in 2009! No hype just straight talk from a Vegas Pro! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/297/Slade Henning/AF28_36">Slade Henning</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Slade Henning of Southcoast Sports MLB MLB Game of the Day Selection goes at 6:05 P.M. CST!!! This Huge Game of the Day Selection can be yours for only $25! That's a small price to pay for a HUGE WINNER! Get it Now! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/349/Steve Zukiel/AF28_36">Steve Zukiel</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Steve Zukiel Is Ready To Dominate Another Football Campaign! Find Out Why He Is One Of The Most Respected In The Industry! </td> </tr> </table> </div> <div id="service_promo"> <table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0"> <tr class="promo_header"> <th> <b><a rel="nofollow" href="/sportscapping.php?capper/capper/329/Trev Rogers/AF28_36">Trev Rogers</a></b><br> </th> </tr> <tr> <td class="description" valign="top"> Trev Rogers ***Top Rated Plays*** finished 2008 52-29-1 and are 116-71-9 since 2006! His ***Top Rated Plays*** are 19-12-1 in 2009 after Trev won his 1st MLB "INSIDER" selection with the Red Sox on 6/12/09 and his 2nd "INSIDER" with the Detroit Tiger... </td> </tr> </table> </div> Any help in this would be greatly appreciated Thanks in advance Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/ Share on other sites More sharing options...
jonsjava Posted August 7, 2009 Share Posted August 7, 2009 um...based on your question, you could do this: <?php $data = file_get_contents("http://sportscapping.com/new/export/?AF28_36/export/all_cappers"); //db_connection stuff goes here $data = mysql_real_escape_string($data); //import all the data into the db. but I'm thinking you are wanting to parse the file, and grab what you want, and import just that. am I right? Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-892634 Share on other sites More sharing options...
timmah1 Posted August 7, 2009 Author Share Posted August 7, 2009 I just need to grab the info within the table. In a perfect world I'd be able to put each table information into it's own field, but I'm sure that can't be done Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-892635 Share on other sites More sharing options...
jonsjava Posted August 7, 2009 Share Posted August 7, 2009 I found this Table extractor. it may be able to help you do what you are wanting to do. Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-892640 Share on other sites More sharing options...
timmah1 Posted August 7, 2009 Author Share Posted August 7, 2009 I don't understand any of that Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-892649 Share on other sites More sharing options...
timmah1 Posted August 7, 2009 Author Share Posted August 7, 2009 I found a class that will extract the data, and put it into an array. Works great for one table, but there are numerous tables on this page The class works by finding the "Anchor Point", in which is case is <div id="service_promo"> and then it grabs the info from the table below that anchor point. How can I loop this to grab all of the anchor points and display all of the contents? <?php include 'tableExtractor.class.php'; $tx = new tableExtractor; $tx->source = file_get_contents('http://sportscapping.com/new/export/?AF28_36/export/all_cappers'); $tx->anchor = '<div id="service_promo">'; $tableArray = $tx->extractTable(); echo var_dump($tableArray); ?> Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-892657 Share on other sites More sharing options...
sasa Posted August 7, 2009 Share Posted August 7, 2009 try $pat = '#<div id="service_promo">\s*<table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0">\s*<tr class="promo_header">\s*<th>\s*<b><a [^>]*>([^<]*)</a></b><br>\s*</th>\s*</tr>\s*<tr>\s*<td class="description" valign="top">\s*([^<]*)\s*</td>#'; preg_match_all($pat,$data,$ma); $out = array_combine($ma[1],$ma[2]); print_r($out); Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-893130 Share on other sites More sharing options...
timmah1 Posted August 7, 2009 Author Share Posted August 7, 2009 Doing this <?php include 'tableExtractor.class.php'; $tx = new tableExtractor; $tx->source = file_get_contents('http://sportscapping.com/new/export/?AF28_36/export/all_cappers'); $tx->anchor = '<div id="service_promo">'; $tableArray = $tx->extractTable(); $pat = '#<div id="service_promo">\s*<table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0">\s*<tr class="promo_header">\s*<th>\s*<b><a [^>]*>([^<]*)</a></b><br>\s*</th>\s*</tr>\s*<tr>\s*<td class="description" valign="top">\s*([^<]*)\s*</td>#'; preg_match_all($pat,$data,$ma); $out = array_combine($ma[1],$ma[2]); print_r($out); ?> Gives me an error Warning: array_combine() [function.array-combine]: Both parameters should have at least 1 element in test.php on line 10 Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-893179 Share on other sites More sharing options...
Catfish Posted August 7, 2009 Share Posted August 7, 2009 You'd be best reading up on regular expressions and the functions PHP provides for them. There's a lot to them but they are extremely powerful for pulling data out of HTML http://au2.php.net/manual/en/book.pcre.php Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-893189 Share on other sites More sharing options...
sasa Posted August 8, 2009 Share Posted August 8, 2009 <?php $data = file_get_contents('http://sportscapping.com/new/export/?AF28_36/export/all_cappers'); $pat = '#<div id="service_promo">\s*<table cellpadding="%%CELLPADDING%%" cellspacing="%%CELLSPACING%%" border="0">\s*<tr class="promo_header">\s*<th>\s*<b><a [^>]*>([^<]*)</a></b><br>\s*</th>\s*</tr>\s*<tr>\s*<td class="description" valign="top">\s*([^<]*)\s*</td>#'; preg_match_all($pat,$data,$ma); $out = array_combine($ma[1],$ma[2]); print_r($out); ?> Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-893439 Share on other sites More sharing options...
timmah1 Posted August 8, 2009 Author Share Posted August 8, 2009 Thank you sasa Quote Link to comment https://forums.phpfreaks.com/topic/169174-solved-how-to-grab-and-database-contents/#findComment-893711 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.