PHP - Link Tracking

Hello everyone.

I have a small problem.  I might receive a ?aff=## or not on the end of my url when I get a visitor to my website.  This depends on if they are sent from a affiliate website or not.  If they are it shows fine on the home page but I loss it if they go to another page on my website.  I need to keep this ?aff=## information while they look at the other pages.  How would I capture and pass this information to my other pages as they surf my site? 
I tried this to no avail.
$aff=$_GET['aff'];
I have no clue no adding it back to the next page they go to.  Any ideas would be helpful..

I am looking to save the user's access of an application.  For instance, when they log in, I create a record in the "track_login" table which includes information such as the requesting IP, the user's ID, the date, (not the user's password), etc.  And then for every page they visit, I store a record in the "track_page_viewed" table which includes a FK to the "track_login" table and also includes additional information about their request.   Both the track_login and track_page_viewed tables are currently in the same database as used by the primary application.   So far, so good.   Next, I want to start tracking when a user does special tasks such as when they forget their password and request that a new one be emailed to them. Or maybe when they attempt to login with an invalid username and password.  Currently, I just included another table called "track_special" which includes the data, the type of special request, etc.   Now, I am thinking of adding three other things to track: General PHP errors MySQL errors Try/Catch errors which I did not expect to happen One option is just to add these to my "track_special" table or maybe make one or three new tables in the same database.   But is this a good idea?  If I have a SQL error, do I really want to store the error in the same database?  Maybe I should use a separate database called "myTrackerDB", and include all the above tables in that database?  Or maybe I should just write the data to a flat file, and parse the file on a regular basis, and then store the information in the database?   Please provide any recommendations, guidance, suggestions, criticism, etc.  Thank you

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=350102.0

I have a small database snippet over at SQLFiddle: http://sqlfiddle.com/#!2/9ff722/55   I need help with writing a query that will allow me to track students in a certain cohort from beginning to graduation. I have two tables: application and stu_acad_cred. The application has the start term and the stu_acad_cred are course registrations. If I want to track students in a fall 2012 (12/FA) cohort, then the query must join the two tables; if the student has a start term of 12/FA *and* has registered for 12/FA courses, the student should be counted. I then want to track those student from year to year or term to term to see if the number of students that started in the 12/FA cohort actually decrease overtime. So, the results should return something similar to below.

| # Students (12/FA Cohort) | Year  |

-------------------------------------

|  2                        |  2012 |

|  2                        |  2013 |

|  2                        |  2014 |

I am not sure if this can be done straight forward or with a stored procedure but any help or direction is greatly appreciated.

Hey guys im a little stumped.

My pages has the following links.

<a href="?page=yes">Yes</a>


to Change content i use

  <?php
            if (isset($_GET['page']))
   {
      include ("include/".$_GET['page'].".php");
   }
   else
   {
      echo 'Welcome to Liquids Scripts PHP Code repository. Just select the categorie from the top and get all the info required ';
   }
   ?>


Will this be tracked by google analytics?

Any help would be awsome.

Hi everyone,

I'm developing an affiliate tracking process and after a lot of thought, I was wondering if someone might be able suggest if I'm on the right track.  I'm trying to get away from the usual ...?id=135845 type of links.  I was thinking about two possibilities:

1.  (I don't know if this is possible), but to generate a subdomain with php at the time an affiliate signs up and then track them by extracting the subdomain to identify the affiliate, or

2.  Somehow, maybe using a mod rewrite, using the affiliate username at the end of a url, ex. www.website.com/username  , you can see that there is no extension, but when a person comes to that url, it will display the contents of www.website.com and I'd extract the username 'username' from the url and query the database to identify the affiliate.

Any thoughts on how this can be done?

Hey guys, I am not a coder at all and would love a little bit of help with my code not working.
Basically, I have a redirect script that sends my visitors to a software download. I want to be able to track a snippet from the incoming refer and send it along with the download. I hope I am explaining this correctly. Here is my code:

<?php
   $tid = $_GET["tid"];
   header( 'Location: http://www.liutilities.com/affcb/?id=RBgendtd&aff=14231&xat=WU-<?php echo $tid; ?>' );
?>

The page that sends them to this script automatically adds ?tid={keyword here}. What the above script is supposed to do is grab tid and then put it after the &xat=WU- but instead, its only putting the actual code itself (&xat=WU-<?php echo $tid; ?>). Can anyone offer a suggestion? Thanks so much!

Hi, I'm trying to make/ am looking for a script (that's free) to provide users with a button to donate, once they have donated they are then returned to the website and the donation amount is stored in a database. I have no idea how i would get this made and the paypal website wasn't much help either. If anyone knows of a free script or can help me make one i would be very greatful.

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=311981.0

 

As we have been working on an eCommerce project, we want to add an option in the eCommerce, that user should have the live location tracking of delivery boy (as same as SWIGGY) in the website. Is there any chance to track the live location using PHP and JavaScript? Searched on the google but nothing resolved my problem? Please anyone suggest us to track the live location of the delivery boy. Thanks in advance

I am in need of suggestions on how too achive this:

I have a surf exchange and whenever a member has viewv a site, it ads this members Id and time to a table called vtp_tracking.

I have now created a team script, so I can count the total of surf for members within this team from the vtp_table.

What I am in need of is this:
I would like to add a bonus for the teams, so my idea was this: every hour run a cronjob to get the results for the last hour by team id lik so:

Code: [Select]
WHERE vtp_members.team_id="teamid" AND vtp_tracking.credit_members_id=vtp_members.id AND vtp_tracking.action_date>date_sub(NOW(),interval 60 minute
I believe the above code will work fine and get me the results for team members for the last hour.

Problem: how can I get this result, multiple it with the value from another field and divide by 100  and add this to a third field?

eg: (result from above * value from other field / 100) then add to a third field.

Anyone willing to try and answer this one?

Hello, I'm working on this PHP website of my college. Where in after sending the order to the vendor an e-mail is sent to the person who ordered and the head of that department notifying them about the details of order along with that now I need to send a tracking number of every order in that e-mail which gets automatically incremented in subsequent orders.
So please let me know how should I approach or do this.
Thank you.

I need like,

http://www.trackcourier.in/

The customer chooses selected courier service and enters tracking id then clicks its redirect to the appropriate courier service website.

eg: If tracking id 12345 the redirect link should be https://www.fedex.com/apps/fedextrack/index.html?tracknumbers=12345&cntry_code=in

How to do for India courier services?

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=326408.0

Hello. I have a bit of a problem. When I fetch the link field from the database.i don't see an actual link on the page.  One more thing, what type of field should I use to store the link in the database? Probably there is where I went wrong. All help is