PHP - Need Help Getting On The Right Track

Hello,   I have been looking for a way to track the play stats on audio mp3's in the admin of my custom post-type. Whatever I google seems to come up with nothing. I not very versed in audio player code - could someone please point me in the right direction.    Again:  I have a custom post-type which uses the wordpress default audio.  I would like to get the number of plays for each audio file and display that in the admin column for my custom post-type   Thanks, Drew

Hi everybody,   I want to cloak my affiliate links or mask it so it looks like a pretty url. Also if possible, I want to track the clicked link with Google Analytics so I think I need a page where I can log the click.   I found lots of information but not for the situation I have. I get my links from my database like this:

echo '<a href="'.$info['url'].'">the link</a>';

How can I accomplish this? So I need a url like www.mydomain.com/click and when a user click on the link the get a new page with a tracking code and a redirect script to the right url.   Thanks so much for the help!   Kind regards, Mark

Hi all,

I followed a tutorial to get the base of a php calendar done, then added some custom Javascript in order to be able to change the color of the cells.

The calendar can be seen he

http://www.education-world.co.uk/Education%20World%20Site/calendar.php

The problem is now, that I need to integrate a SQL database to keep track of what was set for certain dates.

I'm not sure of how to even begin this, all i need to do is keep track of if the candidate is available, not available or working for a specific day. The calendar is submitted to an email but this means when they return at a later date (availability may change) their previously set availability will have been wiped!

I can provide code if needed.

Can anyone help me out here, really struggling with this!

Many thanks,

Greens85

So i have a bunch of random videos playig one after the other what i want is to track if the user viewed the videos by inserting a view lets say in to the database, so if they view the first video the database will increment by 1 then after the page refreshes and the next video loads it will increment again, the only part i dont know what im doing is how would i know if my user viewed the video, any help please thank you?

Hello friends,

I am new to PHP and have developed a website... i am stuck at one place. I want to know if the user changes the url in the adress bar and goes to another webpage.. Can we detect that?

This is very important for my website because I calsulate the duration of login based on whether user goes to another page or logs out.

I'm interested to know how other people keep track of time and also how they display time correctly back to the users. I'm using a third party API that I can tie into that actually gives me the userID of a user, their full name and the timezone for that user. After checking a few users data, this is an example data of what I'm working with.

userID: 234213412
first_name: foo
last_name: bar
timezone: -6

Basically when a user visits my web app, I create a new account for them and store the above data. Currently, I'm just fetching the result from time() and converting it into MySQL DateTime format and storing that into my database.

Code: [Select]
//get the current time as an integer
$php_timestamp = time();
//formats the time according to MySQL DateTime type
$this->mysql_formatted_time = date('Y-m-d H:i:s', $php_timestamp);

I would think the current way that I'm doing this is not very good because there is a possibility that I could introduce load balancing servers into the mix and they might not be located in the same region. Also, I would have no idea how to factor the time and modify it according to the timezone value.(in my above example, -6)

Can anyone help me decide what method I should use to keep all of my servers timestamps in sync and how to display the time to the end user so that it looks correct to them?

I have a table which stores job numbers…each job number can have multiple “line items”…here is a screenshot of example data: https://imgur.com/qSaiJMD

I am trying to use another feature of handsontable called nestedRows which makes it look like this: https://imgur.com/lRE6mbq

In that example I have setup the JSON with hardcoded data. I am trying to integrate it into my PHP now. I have to make the JSON go from this: https://imgur.com/7hHQvC9

To something like this: https://imgur.com/7bSdl1O

I can’t figure out how I can compare the current value in “job_number” to the last row’s “job_number” value so that I can tell the code for example…

if($previousRow_job_number == $currentRow_job_number) {
    //then structure JSON data as a child (line item) of this job number
} else {
    //structure JSON data as a parent job number
}

This is my current code I am trying to modify:

			<script type="text/javascript">
				/*	JSON Construction */
				const data = 
					<?php
					//setup query
					$sql = 'SELECT * FROM production_data';

					//execute SQL transaction
					try {
						//prepare SQL statement & execute
						$stmt = $pdo->prepare($sql);
						$stmt->execute();

						//bind column names to variables
						$stmt->bindColumn('id', $id);
						$stmt->bindColumn('job_number', $job_number);
						$stmt->bindColumn('enterprise', $enterprise);
						$stmt->bindColumn('part_number', $part_number);
						$stmt->bindColumn('description', $description);
						$stmt->bindColumn('qty', $qty);
						$stmt->bindColumn('line_item', $line_item);
						$stmt->bindColumn('as400_ship_date', $as400_ship_date);
						$stmt->bindColumn('date_showed_on_report', $date_showed_on_report);
						$stmt->bindColumn('shipping_method', $shipping_method);
						$stmt->bindColumn('notes', $notes);
						$stmt->bindColumn('date_shown_complete', $date_shown_complete);
						$stmt->bindColumn('actual_ship_date', $actual_ship_date);
						$stmt->bindColumn('qty_shipped', $qty_shipped);

						//output data into spreadsheet view
						while($row = $stmt->fetch(PDO::FETCH_BOUND)) {

							//construct array with data
							$json = array();
							while($row = $stmt->fetch(PDO::FETCH_BOUND)) {
								//$json[] = array($description, $qty, $line_item, $job_number, $as400_ship_date, $date_showed_on_report, "5", $notes, $date_shown_complete, $actual_ship_date, $qty_shipped);
								$json[] = array($job_number, $line_item, $description, $qty, $as400_ship_date, $date_showed_on_report, "5", $notes, $date_shown_complete, $actual_ship_date, $qty_shipped);
							}

							//encode for JSON and output to screen
							print(json_encode($json));

						}
					}
					//failed to execute SQL transaction
					catch (PDOException $e) {
						print $e->getMessage();
					}
					?>
				/*	End JSON Construction */
				
				const container = document.getElementById('productionLogTable');
				const hot = new Handsontable(container, {
				  data: data,
				  //colHeaders: ['Description', 'Qty', 'LN #', 'Order Number', 'AS400 Ship Date', 'Date Showed on Report', 'Days to Manufacture', 'Notes', 'Date Shown Completed', 'Actual Ship Date', 'Qty Shipped'],
				  colHeaders: ['Job Number', 'LN #', 'Description', 'Qty', 'AS400 Ship Date', 'Date Showed on Report', 'Days to Manufacture', 'Notes', 'Date Shown Completed', 'Actual Ship Date', 'Qty Shipped'],
				  //colWidths: [300, 70, 70, 110, 110, 90, 90, 300, 90, 90],
				  colWidths: [110, 70, 300, 70, 110, 90, 90, 300, 90, 90],
				  rowHeaders: true,
				  headerTooltips: {
				  	columns: true,
				  	onlyTrimmed: true
				  },
				  filters: true,
				  dropdownMenu: true,
				});
			</script>

 I hope I’ve provided enough detail…

Edited March 25, 2020 by mongoose00318
to make links into actual links

This topic has been moved to Ajax Help.

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

Hello,

I am creating a website with the use of php and mysql. While I am not advanced, I've been learning quite a bit on php. However, I am looking to build a tracker type script and hide it into my coding so that if someone were to hack into my website and take my website coding, that it would send me an email notifying that they were using my coding.

How would I go about this? If you can help me, i'd be glad to credit you!

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?

Hello, I want to buy some traffic on "trafficholder".

This site have a large network of sellers and you paid for traffic niche, country, etc...

so just to know if they send me the correct amount of traffic I though on give they an URL like this:

www.mysite.com/?ref=traffic

so all traffic sent there will be counted.

whit this method I can I can differentiate that traffic is normal and what is from trafficholder (they send traffic from many many sites so it's difficult to track it whit google-analytics for example)

do you know guys how to do it?

if you can do a script for me (I think it's simple but my php knowledge is 0) I'll appreciate!!!

Thanks in advance

I have items in my DB as inventory.  The table has 2 main fields for this, a total inventory # (per item), and a "remaining" field that will count down as the item is ordered.  My problem is keeping track of the "remaining" number.  There are two ways on the web page a user can change the # of an item they want, by entering a number in a form field which they can only enter a number up to the current # of items left at the time they load the page, and by using up and down arrows.  Each click of the arrow is an addition or deduction of 1 item.  In this case, I can keep track of how many are left, because I know it is always +1 or -1.  The issue is with the manually entered field.  For example, if item1 has 5 left, and a user types in 3, I can easily just subtract 3 from the inventory, and get 2.  But, if the user then types in 4 for item1, I do not know that the last value they entered was 3, to get the difference of 1, and subtract 1 more from inventory, nor do I know that when they first started, there were 5 left, and subtract 4 to get 1.  This gets even more confusing if there are 2 users trying to get the same item...

This must be a common thing, but again, I cannot get it figured out...

In advance, thank you to all who have replied and helped on my other posts lately.  These questions all revolve around the same site I am building, and have maybe bit off more than I can chew at a reasonable pace...

Pete