PHP - Keeping Track Of Online Status

Hi,   i am a student for a school.   we have in each class a book that lists the shool year. Teachers use it to make notes in it and mark people that are not present.   i want to bring that whole process online making a website out of it.   Teachers can log in and see the yearbook. Days view, Week view, Month view. Mark people that have been missing on a specific day. List all the people that have been missing during a school week.   How would i present the Calender? Tables?   I have the some knowledge in mysql, php and joomla.   How would i go about getting startet? Do i need to have a Framework?   All ideas would be greatly appreciated.   Thank you    

I have a site where people vote, currently if two computers that are on the same network vote, my site will see them as one computer because I only track people by IP address.

What would be a good way to track 2+ computers with the same IP address?

I've searched the forum, and haven't yet found what I need.

I have a long list of PDF files:  http://www.iampeth.com/vintage_magazines.php

How can I track the number of downloads for each file?

Hello!

I want to build a script to basically keep track of the number of hosting accounts that are currently on each server. I have roughly 30 servers (root access,  WHM, cPanel) that I would like to be able to track all of from a single page. Could someone help/point me in the right direction/offer any input?


thanks! much appreciated!

How can I track session requests, so I can, after a certain number of requests (let's say ten because it's physcologically pleasing), have the id regenerated?

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

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.

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?

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

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?

Problem:

I'm trying to make it so the array responds to the integer of status in the database. So, to check if it's one, I try this:


$get["status"]["1"] = "Message here...";


But, on my result, I'm just getting WWTT - And the value in the database for the ticket is 0. I'm not sure if I'm using the array correctly.

My full code:


<?php
session_start();
include("../includes/mysql.php");
include("../includes/config.php");

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="../style.css" rel="stylesheet" type="text/css" />
<title><?php echo $title; ?></title>
</head>

<body>
<div id="container">
<div id="content">
<div id="left">
<div class="menu">
<?php include("../includes/navigation.php"); ?>
<div class="menufooter"></div>
</div>
<?php include("../includes/menu.php"); ?>
</div>
<div id="middle">
<?php
$existing = $_POST['existing'];

$query = mysql_query("SELECT COUNT(id),id,status,date,question,title FROM tickets WHERE id='$existing'");
$get = mysql_fetch_assoc($query);

if(!$existing)
{
echo 
'
<div class="post">
<div class="postheader"><h1>Error</h1></div>
<div class="postcontent">
<p>You have not enetered in a ticket ID. Please go back and do so.</p>
</div>
<div class="postfooter"></div>
</div>
';
}
elseif($get['COUNT(id)'] < 1)
{
echo 
'
<div class="post">
<div class="postheader"><h1>Error</h1></div>
<div class="postcontent">
<p>The ticket ID you are trying to use doesnt exist. Please go back or submit another ticket.</p>
</div>
<div class="postfooter"></div>
</div>
';
}
else
{
$get["status"]["0"] = "Waiting for support...";
$get["status"]["1"] = "Waiting for user...";
$get["status"]["2"] = "Ticket Closed...";
$get["status"]["3"] = "Ticket Opened...";

echo 
'
<div class="post">
<div class="postheader"><h1>View Ticket Status - ID '. $get["id"] .'</h1></div>
<div class="postcontent">
<p>Title: '. $get["title"] .' - Posted on: '. $get["date"] .'</p>
<p>Ticket Status: '. $get["status"] .'</p>
<p>Question: '. nl2br($get["question"]) .'</p>
</div>
<div class="postfooter"></div>
</div>
';

}
?>
</div>
</div>
</div>
</body>
</html>