wilsoc31

thank you so much for your help, i think the missing part i had was the ",true" and i wasnt doing the decode right..

[ { "place_id": 329211526, "licence": "Data © OpenStreetMap contributors, ODbL 1.0. https://osm.org/copyright", "osm_type": "way", "osm_id": 19239538, "boundingbox": [ "34.6786854", "34.6787122", "-77.5843465", "-77.5835107" ], "lat": "34.6787013", "lon": "-77.5840059", "display_name": "West Main Street, lex, Troy Township, BIGG County, Ohio, 44333, United States", "class": "highway", "type": "primary", "importance": 0.6000099999999999 }, { "place_id": 329211743, "licence": "Data © OpenStreetMap contributors, ODbL 1.0. https://osm.org/copyright", "osm_type": "way", "osm_id": 38610646, "boundingbox": [ "34.6787122", "34.6871188", "-77.603118", "-77.5843465" ], "lat": "34.6827021", "lon": "-77.5937807", "display_name": "West Main Street, lex, Troy Township, BIGG County, Ohio, 44333, United States", "class": "highway", "type": "secondary", "importance": 0.6000099999999999 }, { "place_id": 329180475, "licence": "Data © OpenStreetMap contributors, ODbL 1.0. https://osm.org/copyright", "osm_type": "way", "osm_id": 823017968, "boundingbox": [ "34.9201281", "34.9214493", "-81.1346294", "-81.1251686" ], "lat": "34.9208004", "lon": "-81.1297602", "display_name": "West Main Street, Alliance, lex Township, Stark County, Ohio, 44601, United States", "class": "highway", "type": "tertiary", "importance": 0.6000099999999999 }, { "place_id": 329179580, "licence": "Data © OpenStreetMap contributors, ODbL 1.0. https://osm.org/copyright", "osm_type": "way", "osm_id": 19258266, "boundingbox": [ "34.9095347", "34.9189094", "-81.1539336", "-81.134635" ], "lat": "34.9146373", "lon": "-81.1445334", "display_name": "West Main Street, Alliance, lex Township, Stark County, Ohio, 44601, United States", "class": "highway", "type": "unclassified", "importance": 0.6000099999999999 } ] all i want to do is get the values of "lat" and "lon" from the first section (inside the first "{ }" ). so i can do: $lat=34.6787013; $lon=-77.5840059; thanks for your help in advanced. ive tried looking up objects ect.. im not even sure what they are. is lat and lon objects ??

Barand, Thank you for your reply. so i tried that. the issue is the json will not parse it out correctly i guess. here is the output from print_r . not sure why its changing the way it looks, but it wont parse out right if i cant get it to look right Array ( [0] => Array ( [name] => 2ND ANNUAL KINGS ISLAND SHOWDOWN CINCY METRO USA [dates] => 06-21-2024 [datee] => 06-23-2024 [location] => LEBANON,OH ) [1] => Array ( [name] => Midwest Championship #2 [dates] => 06-21-2024 [datee] => 06-23-2024 [location] => Rantoul,IL ) [2] => Array ( [name] => MIDWEST MELEE CHAMPIONSHIP [dates] => 06-21-2024 [datee] => 06-23-2024 [location] => Columbia City,IN ) [3] i need it to look like this: [{"name":"TURKEY RUN EVENT-OPEN-$595","dates":"11-16-2024","datee":"11-17-2024","city":"Redding","state":"CA"},{"name":"TURKEY RUN EVENT-OPEN-$595","dates":"11-16-2024","datee":"11-17-2024","city":"Redding","state":"CA"},{"name":"TURKEY RUN EVENT-OPEN-$595","dates":"11-16-2024","datee":"11-17-2024","city":"Redding","state":"CA"},{"name":"TURKEY RUN EVENT-OPEN-$595","dates":"11-16-2024","datee":"11-17-2024","city":"Redding","state":"CA"}] i even tried $array_count= count($response) -1; foreach ($response as $x => $y) { if($array_count != $x) { $output .= json_encode($response[$x]).","; } else { $output .= json_encode($response[$x]); } } echo "[".$output."]"; it looks ok, but something must be off: [{"name":"2ND ANNUAL KINGS ISLAND SHOWDOWN CINCY METRO USA","dates":"06-21-2024","datee":"06-23-2024","location":"LEBANON,OH"},{"name":"Midwest Championship #2","dates":"06-21-2024","datee":"06-23-2024","location":"Rantoul,IL"},{"name":"MIDWEST MELEE CHAMPIONSHIP","dates":"06-21-2024","datee":"06-23-2024","location":"Columbia City,IN"},{"name":"Missouri East State","dates":"06-21-2024","datee":"06-23-2024","location":"Eureka,MO"},{"name":"BUCKET BONANZA SHOWCASE","dates":"06-21-2024","datee":"06-23-2024","location":"NEWTON FALLS,OH"},{"name":"BUCKET BONANZA SHOWCASE","dates":"06-21-2024","datee":"06-23-2024","location":"NORTH RIDGEVILLE,OH"},{"name":"42ND SMOKEY BAKER ALL AMERICAN MEMORIAL NIT","dates":"06-21-2024","datee":"06-23-2024","location":"HARRISON,OH"},{"name":"26TH ANNUAL INDEPENDENCE CLASSIC","dates":"06-21-2024","datee":"06-23-2024","location":"MAUMEE OHIO,OH"},{"name":"C-State Championships (10U & 12U)","dates":"06-21-2024","datee":"06-23-2024","location":"Jerrersom City,MO"},{"name":"B-State Championships (10U & 12U)","dates":"06-21-2024","datee":"06-23-2024","location":"Jerrersom City,MO"}]

for the life of me, i'm overlooking something. this line is inside of a loop but at the end, it only has the last record. why??? Thanks in advance $response = array(); while ($row = mysqli_fetch_array($get_tour,MYSQLI_ASSOC)) { $response = array(["name"=>"$tour_name","dates"=>"$print_start","datee"=>"$print_end","location"=>"$city,$state"]); } echo json_encode($response); output: (only last line) [{"name":"TURKEY RUN EVENT-OPEN-$595","dates":"11-16-2024","datee":"11-17-2024","location":"Redding,CA"}]

so @Barand i switched to use the simple dom but for some reason im not getting the hperlink. do you have an idea? ive tried a few ways and researched but i keep getting the outer text "Links" but not the hyperlink <li> <span class="label"><i class="fas fa-link"></i>Links</span> <span class="texts"> <a href="https://playpass.com/robinson-girls-youth-softball-association" target="_blank" class="social-link" title="Robinson Girls Youth Softball Association Website"><i class="fas fa-globe"></i></a> </span> </li> here is the code i tried: foreach($dom2->find('<li>') as $el2) { echo "test weblink2: "; print_r($el2->href); } but all i get is an empty line

so doing include('simple_html_dom.php'); is better even reading a file? appreciate your responses btw

quick question here.. can you not use preg_match_all to read a file.txt and parse it out? maybe i dont fully understand how preg_match_all works. i would have assumed that reg_match_all("@<tr><td(.+)</td></tr>@", $html, $matches); $listItems = $matches[1]; would have parsed out the <tr><td> tags out of this file <tr> <td data-title='Tournament'><a href='https://some website.com'>Midwest Championship</a></td> <td data-title='Location'>Rantoul, Illinois</td> <td data-title='Organization'>Rock Tournaments</td> <td data-title='GG'>4</td> <td data-title='Start Date'>04-19-2024</td> <td data-title='End Date'>04-21-2024</td> <td data-title='Age Groups'>10U, 12U, 14U</td> </tr> <tr> <td data-title='Tournament'><a href='https://some website.com'>FAST PITCH SLUGFEST</a></td> <td data-title='Location'>West Chicago, Illinois</td> <td data-title='Organization'>Seminole Sports Softball</td> <td data-title='GG'>4</td> <td data-title='Start Date'>04-19-2024</td> <td data-title='End Date'>04-21-2024</td> <td data-title='Age Groups'>10U, 12U, 14U</td> </tr> </tr> but i get empty results. thanks

ok, i can try that. thank you so much for your help. i noticed this way it removes the hyperlink under the first column. is there an easy way to keep the hyperlink too? im trying different solutions on google but not finding anything useful. thanks again

thank you that helped! should I be concerned about this warning? Warning: DOMDocument::loadHTML(): htmlParseEntityRef: no name in Entity, line: 4 this is the line: $dom->loadHTML($htmlSection);

if i had to guess, i dont have things installed to support that. is there another way? Fatal error: Uncaught Error: Call to undefined function str_get_html()

get an error Warning: include(): Failed opening 'simple_html_dom.php' for inclusion

Thanks in advance for help. not sure what I'm doing wrong. ive read the documents and from my understanding of the function, i expected it to work. im trying to scrap from a page so i can make some changes systematically. I need to separate out each field inside of the <td> tags </td>. so the first thing i do is get a substr of the page so i know im getting the correct table. i store it and then do the preg_match_all . what i thought would work, inst parsing out the data fields inside the tags. $html = file_get_contents($url); $start_master = stripos($html, '<table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0">'); $end_master = stripos($html, '</table>', $start_master+10); // just get the entire table <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> to </table> $htmlSection = substr($html, $start_master , $length); preg_match_all('@<td style=(.+)</td>@', $htmlSection, $matches2); $listItems2 = $matches2[1]; $j = 0; while ($j < count($listItems2)) { echo "listItems2-1-".$j.": ".$listItems2[$j]."<br>"; $j++; } $htmlSection is: <table style="text-align: left; width: 100%;" border="0" cellpadding="2" cellspacing="0"> <tr><td style="width: 275px;"><a href="/test1.html?ti=1327"><b><span style="color: #AB1717;">2023 NSA AUTUMN BY THE SEA - 1ST/2ND PLACE TEAMS WIN BOWNET PRIZE PACK </span></b></a></td><td style="width: 225px;">MAD BCH ROC/STARKEY RANCH</td><td style="width: 100px;">MAD BCH/TRINITY</td><td style="width: 15px;">2023-09-23</td><td style="width: 15px;">2023-09-24</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1326"><b><span style="color: #AB1717;">2023 NSA LIGHT OF AUBRIEN SCHOLARSHIP TOURNAMENT</span></b></a></td><td style="width: 225px;">BLACKSTONE PARK</td><td style="width: 100px;">PALMETTO</td><td style="width: 15px;">2023-09-23</td><td style="width: 15px;">2023-09-24</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1328"><b><span style="color: #AB1717;">2023 NSA LADY BOMBERS LESLEY JOHNSON 4TH ANNUAL MEMORIAL TOURNAMENT - 4 SEED INTO SINGLE ELIM</span></b></a></td><td style="width: 225px;">EC MOORE/NEW TAMPA COMM PARK</td><td style="width: 100px;">CLEARWATER/NEW TAMPA</td><td style="width: 15px;">2023-09-30</td><td style="width: 15px;">2023-10-01</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1329"><b><span style="color: #AB1717;">2023 NSA BATTLE FOR THE DOLLAR - WIN $$$ - EVERY TEAM WILL HAVE A CHANCE TO WIN CASH!</span></b></a></td><td style="width: 225px;">STARKEY RANCH</td><td style="width: 100px;">TRINITY</td><td style="width: 15px;">2023-10-07</td><td style="width: 15px;">2023-10-08</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1330"><b><span style="color: #AB1717;">2023 NSA/ST LEO REP THE ROAR TOURNAMENT - 1ST PLACE WINS BUSCH GARDENS SEASON PASSES!</span></b></a></td><td style="width: 225px;">EC MOORE/MAD BCH ROC</td><td style="width: 100px;">CLEARWATER/MAD BCH</td><td style="width: 15px;">2023-10-14</td><td style="width: 15px;">2023-10-15</td><td style="width: 50px;">8U - 14U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1331"><b><span style="color: #AB1717;">2023 NSA/ST LEO REVERSE EXPOSURE INVITATIONAL</span></b></a></td><td style="width: 225px;">EC MOORE</td><td style="width: 100px;">CLEARWATER</td><td style="width: 15px;">2023-10-14</td><td style="width: 15px;">2023-10-15</td><td style="width: 50px;">14U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1333"><b><span style="color: #AB1717;">2023 NSA KING OF THE HILL - 3 SEED INTO DOUBLE ELIM - 1ST PLACE WINS HOWL-O-SCREAM TICKETS!!</span></b></a></td><td style="width: 225px;">EC MOORE/MAD BCH ROC</td><td style="width: 100px;">CLEARWATER/MAD BCH</td><td style="width: 15px;">2023-10-21</td><td style="width: 15px;">2023-10-22</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1332"><b><span style="color: #AB1717;">2023 NSA PALMETTO SCARED HITLESS - 1ST PLACE WINS HOWL-O-SCREAM TICKETS!!</span></b></a></td><td style="width: 225px;">BLACKSTONE PARK</td><td style="width: 100px;">PALMETTO</td><td style="width: 15px;">2023-10-21</td><td style="width: 15px;">2023-10-22</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1334"><b><span style="color: #AB1717;">2023 NSA BOMBERWEEN - COSTUME CONTEST - PUMPKIN PRIZES!!</span></b></a></td><td style="width: 225px;">EC MOORE</td><td style="width: 100px;">CLEARWATER</td><td style="width: 15px;">2023-10-28</td><td style="width: 15px;">2023-10-29</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1335"><b><span style="color: #AB1717;">2023 NSA 13TH ANNUAL PITCH FOR THE CURE - OVER 80 TEAMS LAST YR - 4 SEED/SINGLE ELIM!</span></b></a></td><td style="width: 225px;">EC MOORE</td><td style="width: 100px;">CLEARWATER</td><td style="width: 15px;">2023-11-04</td><td style="width: 15px;">2023-11-05</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1337"><b><span style="color: #AB1717;">2023 NSA FALL BRAWL - 1ST PLACE WINS BUSCH GARDENS TICKETS!!</span></b></a></td><td style="width: 225px;">555 COMPLEX</td><td style="width: 100px;">BARTOW</td><td style="width: 15px;">2023-11-11</td><td style="width: 15px;">2023-11-12</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1336"><b><span style="color: #AB1717;">2023 NSA FALL BRAWL - 3 SEED INTO DOUBLE ELIMINATION!!</span></b></a></td><td style="width: 225px;">STARKEY RANCH</td><td style="width: 100px;">TRINITY</td><td style="width: 15px;">2023-11-11</td><td style="width: 15px;">2023-11-12</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1338"><b><span style="color: #AB1717;">2023 NSA BATTERBALL TURKEYFEST - DOUBLE/DOUBLE - 1ST & 2ND PLACE WIN NEW GLOVES!!</span></b></a></td><td style="width: 225px;">BLACKSTONE PARK</td><td style="width: 100px;">PALMETTO</td><td style="width: 15px;">2023-11-18</td><td style="width: 15px;">2023-11-19</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1339"><b><span style="color: #AB1717;">2023 NSA BATTERBALL TURKEYFEST - DOUBLE/DOUBLE - 1ST & 2ND PLACE WIN NEW GLOVES!!</span></b></a></td><td style="width: 225px;">MAD BCH ROC/STARKEY RANCH</td><td style="width: 100px;">MAD BCH/TRINITY</td><td style="width: 15px;">2023-11-18</td><td style="width: 15px;">2023-11-19</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1340"><b><span style="color: #AB1717;">2023 NSA THANKSGIVING THROWDOWN - 1 DAY/SUNDAY ONLY EVENT!!</span></b></a></td><td style="width: 225px;">NEW TAMPA COMM PARK</td><td style="width: 100px;">NEW TAMPA</td><td style="width: 15px;">2023-11-26</td><td style="width: 15px;">2023-11-26</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1341"><b><span style="color: #AB1717;">2023 NSA TOYS FOR TOTS #1 - 1ST & 2ND PLACE WIN NEW GLOVES!!</span></b></a></td><td style="width: 225px;">MADEIRA BEACH ROC</td><td style="width: 100px;">MADEIRA BEACH</td><td style="width: 15px;">2023-12-02</td><td style="width: 15px;">2023-12-03</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1342"><b><span style="color: #AB1717;">2023 NSA FALL STATE CHAMPIONSHIPS - REDEEM THE $$ YOU EARNED EACH TOURNAMENT THIS FALL!!</span></b></a></td><td style="width: 225px;">MULTIPLE VENUES</td><td style="width: 100px;">POLK COUNTY</td><td style="width: 15px;">2023-12-09</td><td style="width: 15px;">2023-12-10</td><td style="width: 50px;">8U - 18U</td></tr><tr><td style="width: 275px;"><a href="/test1.html?ti=1343"><b><span style="color: #AB1717;">2023 NSA TOYS FOR TOTS #2 - CHANCE TO WIN SOME PRESENTS & COME MEET SANTA!!</span></b></a></td><td style="width: 225px;">NEW TAMPA COMM PARK</td><td style="width: 100px;">NEW TAMPA</td><td style="width: 15px;">2023-12-16</td><td style="width: 15px;">2023-12-17</td><td style="width: 50px;">8U - 18U</td></tr> </table> the output is: "width: 275px;">2023 NSA AUTUMN BY THE SEA - 1ST/2ND PLACE TEAMS WIN BOWNET PRIZE PACK MAD BCH ROC/STARKEY RANCHMAD BCH/TRINITY2023-09-232023-09-248U - 18U2023 NSA LIGHT OF AUBRIEN SCHOLARSHIP TOURNAMENTBLACKSTONE PARKPALMETTO2023-09-232023-09-248U - 18U2023 NSA LADY BOMBERS LESLEY JOHNSON 4TH ANNUAL MEMORIAL TOURNAMENT - 4 SEED INTO SINGLE ELIMEC MOORE/NEW TAMPA COMM PARKCLEARWATER/NEW TAMPA2023-09-302023-10-018U - 18U2023 NSA BATTLE FOR THE DOLLAR - WIN $$$ - EVERY TEAM WILL HAVE A CHANCE TO WIN CASH!STARKEY RANCHTRINITY2023-10-072023-10-088U - 18U2023 NSA/ST LEO REP THE ROAR TOURNAMENT - 1ST PLACE WINS BUSCH GARDENS SEASON PASSES!EC MOORE/MAD BCH ROCCLEARWATER/MAD BCH2023-10-142023-10-158U - 14U2023 NSA/ST LEO REVERSE EXPOSURE INVITATIONALEC MOORECLEARWATER2023-10-142023-10-1514U - 18U2023 NSA KING OF THE HILL - 3 SEED INTO DOUBLE ELIM - 1ST PLACE WINS HOWL-O-SCREAM TICKETS!!EC MOORE/MAD BCH ROCCLEARWATER/MAD BCH2023-10-212023-10-228U - 18U2023 NSA PALMETTO SCARED HITLESS - 1ST PLACE WINS HOWL-O-SCREAM TICKETS!!BLACKSTONE PARKPALMETTO2023-10-212023-10-228U - 18U2023 NSA BOMBERWEEN - COSTUME CONTEST - PUMPKIN PRIZES!!EC MOORECLEARWATER2023-10-282023-10-298U - 18U2023 NSA 13TH ANNUAL PITCH FOR THE CURE - OVER 80 TEAMS LAST YR - 4 SEED/SINGLE ELIM!EC MOORECLEARWATER2023-11-042023-11-058U - 18U2023 NSA FALL BRAWL - 1ST PLACE WINS BUSCH GARDENS TICKETS!!555 COMPLEXBARTOW2023-11-112023-11-128U - 18U2023 NSA FALL BRAWL - 3 SEED INTO DOUBLE ELIMINATION!!STARKEY RANCHTRINITY2023-11-112023-11-128U - 18U2023 NSA BATTERBALL TURKEYFEST - DOUBLE/DOUBLE - 1ST & 2ND PLACE WIN NEW GLOVES!!BLACKSTONE PARKPALMETTO2023-11-182023-11-198U - 18U2023 NSA BATTERBALL TURKEYFEST - DOUBLE/DOUBLE - 1ST & 2ND PLACE WIN NEW GLOVES!!MAD BCH ROC/STARKEY RANCHMAD BCH/TRINITY2023-11-182023-11-198U - 18U2023 NSA THANKSGIVING THROWDOWN - 1 DAY/SUNDAY ONLY EVENT!!NEW TAMPA COMM PARKNEW TAMPA2023-11-262023-11-268U - 18U2023 NSA TOYS FOR TOTS #1 - 1ST & 2ND PLACE WIN NEW GLOVES!!MADEIRA BEACH ROCMADEIRA BEACH2023-12-022023-12-038U - 18U2023 NSA FALL STATE CHAMPIONSHIPS - REDEEM THE $$ YOU EARNED EACH TOURNAMENT THIS FALL!!MULTIPLE VENUESPOLK COUNTY2023-12-092023-12-108U - 18U2023 NSA TOYS FOR TOTS #2 - CHANCE TO WIN SOME PRESENTS & COME MEET SANTA!!NEW TAMPA COMM PARKNEW TAMPA2023-12-162023-12-178U - 18U what i expected was something like this: 2023 NSA AUTUMN BY THE SEA - 1ST/2ND PLACE TEAMS WIN BOWNET PRIZE PACK MAD BCH ROC/STARKEY RANCH MAD BCH/TRINITY 2023-09-23 2023-09-24 8U - 18U [ ect to the next row ]

does anyone know why this query isnt working? it would work i think ok in oracle so not sure what im doing wrong here... thanks in advance select * from pool_play where tournament_id = '3522' and user_id= '1' and (team_name is not null or team_name !='' or team_name NOT LIKE '%[teamname]%'); i would expect all the or's to work inside the () so obviously i would expect nulls to filter out, and also the NOT LIKE '%[teamname]% to filter out too

let me step back and try again.. 1. this entire thing has been javascript from the start. I can tell its using some sort of array but im not super great at javascript. 2. I added the php parts as it was not storing the results other than cache in the array. it is storing the data just fine and also able to pull the data from the database as well. 3. if i left it as is from the original (javascript only) and if someone only did Team1 and Team2. walked away and came back to it later, it timed out and the cache is gone. this is why i wanted to store it on the database (which is why you now see php mixed in) 4. the code even though it saves and pulls from php/mysql, it still is looping through the cached array as the main driver but it starts over as it doesnt know where it left off. what i would like is to at minimum load the array each time from the database instead. currently it keeps scores of the teams, so i can do a query with something like: select * from table where score1 =null and score2 =null but im having trouble figuring out the array load part in javascript. Does this make more sense? and thank you for your help so far by the way

I appreciate you asking. I'm having a hard time with the JavaScript part. I know what it's doing is looping through an array based on info provided, see image. The issue is the entire thing is looping through an array. Also in the array I'm inserting records to save them. Instead of the long array I want to pull from the database so it's no longer a cached issue