Jump to content

Jim R

Members
  • Content count

    585
  • Joined

  • Last visited

  • Days Won

    1

Jim R last won the day on July 26

Jim R had the most liked content!

Community Reputation

1 Neutral

About Jim R

  • Rank
    Prolific Member

Profile Information

  • Gender
    Not Telling
  1. I'm mostly just wondering if anyone here has dealt with it directly. From there, I'd ask if I pass what I need via the URL, could I return it back in the Advanced Return section.
  2. I've read through their documentation, but as you could imagine, it's mostly about passing transaction information from PayPal, most of which I don't need/want, and even the email addresses are only the same as the registration addresses 60% of the time. That's the issue. Since I render just a one time service, I have only truly cared about the confirmation email I get that someone paid. I've manually linked the payment to the registration. I'm just at a point where I'd like it to automatically link it. I posted the question in the PayPal community, but they have poor avenues for community help.
  3. I'm having a hard time wrapping my head around PayPal's IPN and PDT information. (I assume if you can help me you know what those mean.) However, I'm not trying to pass information from the transaction to my site because the person who pays isn't truly my concern, and the emails don't always match. Parents sign up their son for a basketball league. I have a great form that separates participants based on a couple of factors to three different price points within PayPal. All I want to do is send the player's name and school to PayPal and have it returned as they're sent back to my site after completing payment. From there, I can take that information, Update my database accordingly. I know how to pass variables through URL's. I just don't see much in the way of returning variables which have little to do with the transaction relative to PayPal's needs.
  4. Jim R

    How to add custom php app in wordpress

    What are you trying to do? I'm a PHP tinkerer at best, with a lot of help, but I've been using PHP in WordPress for about a decade. If you're talking about creating a plugin, that's a process that's pretty easy to start, but really tying it into your site, you'll need to study up on WordPress' codex and template tags: https://codex.wordpress.org/Template_Tags If you're talking about putting information onto certain pages, now you're talking about inserting PHP into a page, which isn't native in WordPress. I'd get a plugin called PHP Code Snippet by XYZscripts. It's fantastic, and it allows you to easily use code snippets through your site. From there, I use INCLUDES to associate PHP files to my WP Pages, and I update the PHP files in any text editor. I would recommend checking out the Template Tags no matter what. You can use them in your PHP files just for simple calls, as a lot of what I do involves referring to items within WP.
  5. Thank you both!
  6. SELECT paid,nameFirst,nameLast,college,feet,inches,phoneMobile,email FROM college_league_2018 WHERE confirm ='1' AND teamplayer='player' AND (college != 'Wabash' OR college != 'DePauw') ORDER BY college, nameLast This seems simple, and I've found a few examples saying to use parentheses. It's not working. I want individuals where... confirm = 1 teamplayer = player who don't attend Wabash or DePauw My results still include individuals who attend both schools. When I remove the OR and just exclude one of the schools, it works.
  7. This works. $year = $_GET['&year']; $team = $_GET['&team']; $number = $year.$team; // echo $number; $calendars = array ( '192' =>'2019roots', '212' =>'2021roots', '191' =>'2019grind', '201' =>'2020grind', '211' =>'2021grind', '221' =>'2022grind', '231' =>'2023grind' ); echo $calendars [$number]; echo do_shortcode( '[calendarizeit calendar="'. $calendars [$number] .'"]' );
  8. I might've made the above too complicated, which is to say I was way off. I've changed the code, but now it just prints 'array'. $year = $_GET['&year']; $team = $_GET['&team']; $calendar = $year.$team; $calendar = array ( '192' =>'2019roots', '212' =>'2021roots', '191' =>'2019grind', '201' =>'2020grind', '211' =>'2021grind', '221' =>'2022grind', '231' =>'2023grind' ); echo $calendar;
  9. I'm passing variables passed through the URL for year and team. For example: $year = 19, $team = 2 I'm joining those variables and creating a value which will correspond to team's page on a site. $number = 192 The question is how do I set up my array to use that value 192 to make $calendar = 2019roots ? $year = $_GET['&year']; $team = $_GET['&team']; $number = $year.$team; echo $number; $calendar = array ( '192' =>'2019roots', '212' =>'2021roots', '191' =>'2019grind', '201' =>'2020grind', '211' =>'2021grind', '221' =>'2022grind', '231' =>'2023grind' ); I'm going to use that value to call up the corresponding calendar based on which team's page the User is viewing. (I suppose I could create a series of if/else statements, but I'd rather learn how to do this. I've tried searching for examples, but I'm not even sure how to concisely query the search.)
  10. Jim R

    Group by chronology...

    Understood, but it's still a working environment I want to be as efficient as possible for my Users. I work in my main table directly often, so I want the names there. My Users (me included) enter into the other table from a form. They are going to enter the names, ranging from their phone, a tablet or a laptop. I'm not making them look up ID's to complete their work, nor am I having them use a drop down menu. All my tables have a primary key. I also want the names in the second table because I limit what's shown on the website, and I'd like to be able to easily locate all the information, especially if I need to find it on my phone. A large number of players will have more evaluations over their four year high school careers than what is shown on the site. Not only that, it's much easier to match the names to the WordPress slugs than trying to find those ID's too. I'm 48. I'm self-taught, and I do my own work, outside of the help I've had here over the years. When this site went down, I reached out to whomever ran the Twitter account and offered to host this forum if the issue of keeping it going was hosting expenses. You have to accept sometimes the needs of the User outweigh the intended purpose, especially when it's usage is narrow of focus. Having an extra column isn't hindering anything other someone's sense of structure.
  11. Jim R

    Group by chronology...

    The closest I could come would be to choose the school first. That may be a consideration, but I still like the name in both tables. When I'm home, I just type straight into the database.
  12. Jim R

    Group by chronology...

    Interactive would be great, but that's more coding and MANY more questions. I did get rid of the concats. When I have to improve them, I'm going to move over to mysqli or dig into PDO.
  13. Jim R

    Group by chronology...

    You want me to have a drop down for over 1,000 names? What about the new names? I'm setting this up to quick and efficient at the point of entry. I have an outstanding system. I have a form that submits reviews, and if that player doesn't exist in my main table, it forwards the User to another form, as well as the already completed values (First name, last name, city (if applicable), school and grade), to enter his info to the main table. I can't make it automatically because more information is needed that I don't want my Users to have to type in every time they review a player. Meanwhile, with each new player entered, it preserves them as new until I process them, in terms of caliber and geographical area. I could pre-program the geography, but not all my Users are as adept as I am at knowing which county a school is in. I could link geographical area to the city of the school as well, but with over 420 schools in Indiana, I'm not really interested in having my Users have to use a drop down menu or locate their school ID. However, in creating that list of new players, it's an additional resource for coaches who read our material, featuring those kids. Once a week I go in and process them. If I see one already in the main table due to a typo or misspelling, I can easily change it. Repeating, I'm setting this up to quick and efficient at the point of entry. I came here to ask how I can get chronology of grouped values to the way I wanted it. It turned out it was a simple solution, which I was unable to find easily via searches. You'll forgive me if I don't want to push a drop down menu of 1,000 kids. Maybe one that matches possible last names to selected first names, but the matching of the ID's then would still have to be matched. All of this because you don't like it that I have names in two tables. I truly appreciate the help I get here, and I try to help others while I'm looking for my own solutions. It's likely best to stick to the topic at hand. MAX(time) worked great.
  14. Jim R

    Group by chronology...

    Not that I have to explain this, but as a form submits a player name and review, any new name from the form creates a new row in the master list with a separate grouping identifier. That grouping is ultimately based on their talent level, per later consideration. So we want to know who the new entries are. If we see a pre-existing name due to a typo, we'll know it. So we don't type names in two places. We either type them in the master list, or from a form we type about them while watching them play. And since I distribute to my two other writers these players names and social media handles, they import them into their phone and can dictate about 95% of their work accurately on their phone. As I try to add features, sometimes I run into a learning curve. While I know I can insert a corresponding ID, I still like to open up the database so I can see a larger section of rows than what a normally styled web page can or should show. None of this really has anything to do with my issue. I just couldn't figure out how change how items are grouped, relative to time. Any time I searched "order", it would show results with Group By and Order By. It wasn't helping. How else do you put data into a database other than directly, importing or via a form? So me sitting at my desk typing into Sequel Pro from my notes is madness reigning? (The good news is you didn't overreact.)
  15. Jim R

    Group by chronology...

    Certainly, but then it won't show up as it should and we'll know. Easy enough to correct. They don't know the ID of a player as they're reviewing and are inputting via the data table directly or a form. There is no way around it.
×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.