|
PHP - Trying To Track A Value For Comparing Outside Of Loop To Structure Json
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 mongoose00318to make links into actual links Similar TutorialsI have this array of items in my php file.
$items = array(
array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"),
);
Using the above array I am trying to generate a JSON file that will have the following structu
{
"category":[
{
"categoryName":"level1",
"category":[
{
"categoryName":"powders",
"products":[
{
"id":"100",
"path":"level1/powders",
"prodname":"Mens powder"
},
{
"id":"1000",
"path":"level1/powders",
"prodname":"Womens powder"
}
]
},
{
"categoryName":"oils",
"category":[
{
"categoryName":"sunflower",
"products":[
{
"id":"200",
"path":"level1/oils/sunflower",
"prodname":"XYZ oil"
},
{
"id":"400",
"path":"level1/oils/sunflower",
"prodname":"ABC oil"
}
]
},
{
"categoryName":"groundnut",
"products":[
{
"id":"1100",
"path":"level1/oils/groundnut",
"prodname":"GN oil"
}
]
}
]
},
{
"categoryName":"eatable",
"category":[
{
"categoryName":"vegetables",
"products":[
{
"id":"300",
"path":"level1/eatable/vegetables",
"prodname":"carrot"
},
{
"id":"600",
"path":"level1/eatable/vegetables",
"prodname":"spinach"
}
]
},
{
"categoryName":"fruits",
"products":[
{
"id":"500",
"path":"level1/eatable/fruits",
"prodname":"mango"
}
]
}
]
}
},
{
"categoryName":"level2",
"category":[
{
"categoryName":"baby items",
"category":[
{
"categoryName":"toys",
"products":[
{
"id":"700",
"path":"level2/baby items/toys",
"prodname":"puzzle blocks"
},
{
"id":"800",
"path":"level2/baby items/toys",
"prodname":"trucks and cars"
}
]
},
{
"categoryName":"clothes",
"products":[
{
"id":"900",
"path":"level2/baby items/clothes",
"prodname":"shirts"
}
]
}
]
}
]
}
Not being an expert in php, I have somehow managed to reach thus far in my code, but can not quite arrive at the correct logic. Having trouble with handling associative arrays and objects in php. (Javascripting is much easier I feel) So far I have managed to fix all the errors/warning in my code. Here is my full php code:
$items = array(
array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"),
);
$jsonStruct = array();
function jsonCreateStruct(){
GLOBAL $items;
for($c=0; $c<count($items); $c++){
$categ = $items[$c]["categorypath"];
insertJson($categ, $items[$c]);
}
}
function insertJson($catg, $itm){
GLOBAL $jsonStruct;
$exp = explode("/",$catg);
print_r("\n\n\n $catg \n");
if(count($exp) == 1){
print_r("Level 1 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["products"] = array($itm);
print_r("\nCreated:: $exp[0]");
}else{
$notFound = true;
for($j=0; $j<count($jsonStruct); $j++){
$catgName = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName");
if($catgName == $exp[0]){
$notFound = false;
if($jsonStruct[$j]["products"]){
array_push($jsonStruct[$j]["products"],array($itm));
}else{
$jsonStruct[$j]["products"] = array();
array_push($jsonStruct[$j]["products"],array($itm));
}
}
}
if($notFound){
print_r("\nNotFound\n");
array_push($jsonStruct,array("categoryName"=> $exp[0], "products" => array($itm)));
}
}
}
if(count($exp) == 2){
print_r("Level 2 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "products" => array($itm));
print_r("\nCreated:: $exp[0] / $exp[1]");
}else{
$notFound1 = true;
$notFound2 = true;
$indexLevel = null;
for($j=0; $j<count($jsonStruct); $j++){
$catgName1 = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName1");
if($catgName1 == $exp[0]){
$notFound1 = false;
$indexLevel = $j;
if(isset($jsonStruct[$j]["categorypath"])){
$level1 = $jsonStruct[$j]["categorypath"];
for($m=0; $m<count($level1); $m++){
if(isset($level1[$m]["categoryName"])){
$catgName2 = $level1[$m]["categoryName"];
print_r("\nFound: $catgName2");
if($catgName2 == $exp[1]){
$notFound2 = false;
if($level1[$m]["products"]){
array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
}else{
$jsonStruct[$j]["categorypath"][$m]["products"] = array();
array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
}
}
}
}
}
}
}
if($notFound1){
print_r("\nNotFound1\n");
array_push($jsonStruct,array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
}else if($notFound2){
print_r("\nNotFound2\n");
// $jsonStruct[$indexLevel]["categorypath"] = array("categoryName"=> $exp[1], "products" => array($itm));
$jsonStruct[$indexLevel]["categorypath"] = array();
array_push($jsonStruct[$indexLevel]["categorypath"], array("categoryName"=> $exp[1], "products" => array($itm)));
}
}
}
if(count($exp) == 3){
print_r("Level 3 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm)));
print_r("\nCreated:: $exp[0] / $exp[1] / $exp[2]");
}else{
$notFound1 = true;
$notFound2 = true;
$notFound3 = true;
$indexLevel1 = null;
$indexLevel2 = null;
for($j=0; $j<count($jsonStruct); $j++){
$catgName1 = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName1");
if($catgName1 == $exp[0]){
$notFound1 = false;
$indexLevel1 = $j;
if(isset($jsonStruct[$j]["categorypath"])){
$level2 = $jsonStruct[$j]["categorypath"];
for($m=0; $m<count($level2); $m++){
if(isset($level2[$m]["categoryName"])){
$catgName2 = $level2[$m]["categoryName"];
print_r("\nFound: $catgName2");
if($catgName2 == $exp[1]){
$notFound2 = false;
$indexLevel2 = $m;
if(isset($level2[$m]["categorypath"])){
$level3 = $level2[$m]["categorypath"];
for($n=0; $n<count($level3); $n++){
//print_r($level3["categoryName"]);
if(isset($level3["categoryName"])){
$catgName3 = $level3["categoryName"];
print_r("\ncatgName3: ". $catgName3);
if($catgName3 == $exp[2]){
$notFound3 = false;
if($level3["products"]){
print_r("\npushing into array\n");
array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
}else{
print_r("\ncreate new and pushing into array\n");
$jsonStruct[$j]["categorypath"][$m]["categorypath"][$n]["products"] = array();
array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
}
}
}
}
}
}
}
}
}
}
}
if($notFound1){
print_r("\nNotFound1\n");
array_push($jsonStruct, array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
}else if($notFound2){
print_r("\nNotFound2\n");
if(!$jsonStruct[$indexLevel1]["categorypath"]){
$jsonStruct[$indexLevel1]["categorypath"] = array();
}
array_push($jsonStruct[$indexLevel1]["categorypath"], array("categoryName"=> $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm))));
}else if($notFound3){
print_r("\nNotFound3\n");
//$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array("categoryName"=> $exp[2], "products" => array($itm));
if(!$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"]){
$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array();
}
array_push($jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"], array("categoryName"=> $exp[2], "products" => array($itm)));
}
}
}
}
jsonCreateStruct();
print_r("----------------------------------------");
print_r($jsonStruct);
// echo json_encode($jsonStruct);
I have now reached a point where I desperately need help from experts.
Hello, Having a bit of a tough time understanding what is going on in my brain! I'm basically pulling some data from an API using CuRL, which is working fine. The structure of the data is: [data][tickets] - tickets being an array of support tickets in the system, which then contains ticketNumber, title, content. I want to display these values in a list, I have this code currently:
if ($err) {
echo "cURL Error #:" . $err;
} else {
$return = json_decode($response, true);
foreach($return as $key) {
echo $key["tickets"][1]['ticketNumber']." - ";
echo $key["tickets"][1]['title']." - ";
echo $key["tickets"][1]['content'];
}
}
Which obviously returns the ticketNumber, title & content of the first support ticket in the array, but I want to loop through and display that information for each ticket! Can anyone advise as to where I am going wrong? I think I need to utilise the ["tickets"][x] but not sure how!
Thanks in advance! Steve Hey there folks, Im trying to get a foreach loop working correctly from a json source epg heres my code: https://pastebin.com/FjHj1EF6 Here is the current output, which.. while correct is only the first instance of these values i wanted using the foreach loop, i would love any tips on why my approach failed and to be pointed in the right direction. While it has to be included: $url = "https://mywebsite.fake/mlb.php?id={$arr['games'][0]["gamePk"]}"; this value isn't related to the assistance im asking for. that will work for my purposes later. but for now i just need to understand the issue with the foreach loop. Thanks in advance for your thoughtful response. mosb3rgler I have my data array which i converted to json by splitting the keys using for each loop. Data:
$data = Array ( [table6-ios-camt] => [table6-ios-iamt] => [table6-ios-samt] => [table6-ios-type] => [table6-isd-camt] => 0 [table6-isd-iamt] => 0 [table6-isd-samt] => 0 [table6-isd-type] => [table6-ios-csamt] => [table6-isd-csamt] => 0 [table6-other-camt] => [table6-other-iamt] => [table6-other-samt] => [table6-other-type] => [table6-tran1-camt] => 0 [table6-tran1-iamt] => [table6-tran1-samt] => 0 [table6-tran1-type] => [table6-tran2-camt] => 0 [table6-tran2-iamt] => [table6-tran2-samt] => 0 [table6-tran2-type] => [table6-itc_3b-csamt] => 0 [table6-dump_iog-camt] => [table6-dump_iog-iamt] => [table6-dump_iog-samt] => [table6-dump_iog-type] => [table6-dump_oth-camt] => 4386.09 [table6-dump_oth-iamt] => [table6-dump_oth-samt] => 4386.09 [table6-dump_oth-type] => [table6-itc_clmd-camt] => [table6-itc_clmd-iamt] => [table6-itc_clmd-samt] => [table6-itc_clmd-type] => [table6-total_10-camt] => 4386.09 [table6-total_10-iamt] => 0 [table6-total_10-samt] => 4386.09 [table6-total_10-type] => [table6-total_11-type] => [table6-total_8-csamt] => 0 [table6-total_9-csamt] => 0 [table6-dump_iog-csamt] => [table6-dump_isrc-camt] => [table6-dump_isrc-iamt] => [table6-dump_isrc-samt] => [table6-dump_isrc-type] => [table6-dump_oth-csamt] => [table6-iog_goods-camt] => [table6-iog_goods-iamt] => [table6-iog_goods-samt] => [table6-iog_goods-type] => Capital Goods [table6-itc_clmd-csamt] => [table6-total_10-csamt] => 0 [table6-dump_isrc-csamt] => [table6-iog_goods-csamt] => [table6-iog_inputs-camt] => [table6-iog_inputs-iamt] => [table6-iog_inputs-samt] => [table6-iog_inputs-type] => Input Services [table6-iog_inputs-csamt] => [table6-iog_services-camt] => [table6-iog_services-iamt] => [table6-iog_services-samt] => [table6-iog_services-type] => Input Services [table6-supp_non_rchrg_goods-camt] => [table6-supp_non_rchrg_goods-iamt] => [table6-supp_non_rchrg_goods-samt] => [table6-supp_non_rchrg_goods-type] => Capital Goods [table6-supp_rchrg_reg_goods-camt] => [table6-supp_rchrg_reg_goods-iamt] => [table6-supp_rchrg_reg_goods-samt] => [table6-supp_rchrg_reg_goods-type] => Capital Goods [table6-supp_non_rchrg_goods-csamt] => [table6-supp_non_rchrg_inputs-camt] => 4386.09 [table6-supp_non_rchrg_inputs-iamt] => [table6-supp_non_rchrg_inputs-samt] => 4386.09 [table6-supp_non_rchrg_inputs-type] => Inputs [table6-supp_rchrg_reg_goods-csamt] => [table6-supp_rchrg_reg_inputs-camt] => [table6-supp_rchrg_reg_inputs-iamt] => [table6-supp_rchrg_reg_inputs-samt] => [table6-supp_rchrg_reg_inputs-type] => Input Services [table6-supp_non_rchrg_inputs-csamt] => [table6-supp_rchrg_reg_inputs-csamt] => [table6-supp_rchrg_unreg_goods-camt] => [table6-supp_rchrg_unreg_goods-iamt] => [table6-supp_rchrg_unreg_goods-samt] => [table6-supp_rchrg_unreg_goods-type] => Capital Goods [table6-supp_non_rchrg_services-camt] => [table6-supp_non_rchrg_services-iamt] => [table6-supp_non_rchrg_services-samt] => [table6-supp_non_rchrg_services-type] => Input Services [table6-supp_rchrg_reg_services-camt] => [table6-supp_rchrg_reg_services-iamt] => [table6-supp_rchrg_reg_services-samt] => [table6-supp_rchrg_reg_services-type] => Input Services [table6-supp_rchrg_unreg_goods-csamt] => [table6-supp_rchrg_unreg_inputs-camt] => [table6-supp_rchrg_unreg_inputs-iamt] => [table6-supp_rchrg_unreg_inputs-samt] => [table6-supp_rchrg_unreg_inputs-type] => Input Services [table6-supp_non_rchrg_services-csamt] => [table6-supp_rchrg_reg_services-csamt] => [table6-supp_rchrg_unreg_inputs-csamt] => [table6-supp_rchrg_unreg_services-camt] => [table6-supp_rchrg_unreg_services-iamt] => [table6-supp_rchrg_unreg_services-samt] => [table6-supp_rchrg_unreg_services-type] => Input Services [table6-supp_rchrg_unreg_services-csamt] => ); json:
{
"table6":{
"ios":{
"camt":0,
"iamt":0,
"samt":0,
"csamt":0
},
"isd":{
"camt":0,
"iamt":0,
"samt":0,
"csamt":0
},
"other":{
"camt":0,
"iamt":0,
"samt":0,
"csamt":0
},
"tran1":{
"camt":0,
"iamt":0,
"samt":0,
"csamt":0
},
"tran2":{
"camt":0,
"iamt":0,
"samt":0,
"csamt":0
},
"itc":{
"camt":0,
"iamt":550,
"samt":230,
"csamt":680
},
"iog":[
{
"itc_typ":"cg",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
},
{
"itc_typ":"ip",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
},
{
"itc_typ":"is",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
}
],
"supp_non_rchrg":[
{
"itc_typ":"cg",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
},
{
"itc_typ":"ip",
"camt":4386.09,
"samt":4386.09,
"iamt":0,
"csamt":0
},
{
"itc_typ":"is",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
}
],
"supp_rchrg_reg":[
{
"itc_typ":"cg",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
},
{
"itc_typ":"ip",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
},
{
"itc_typ":"is",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
}
],
"supp_rchrg_unreg":[
{
"itc_typ":"cg",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
},
{
"itc_typ":"ip",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
},
{
"itc_typ":"is",
"camt":0,
"samt":0,
"iamt":0,
"csamt":0
}
]
}
}
Keeping in mind the following conditions: 1.If all the keys in the objects are 0 then the entire object will be removed (easy part). 2.If a key in the object has any value other than 0 , the object should not be removed and the key with "0" value should also be there.i've tried splitting value and using conditions to check for 0 or null values but the problem with that is it removes all keys that have 0 values thus failing condition 2 for the code.
$vars = $data;
$count = "";
$finalArray = array();
foreach ($vars as $keys => $values) {
foreach ($values as $k => $v) {
foreach ($v as $ke => $ve) {
if ($keys == "table6") {
$count = (array)$v;
foreach ($count as $ck => $cv) {
if ($cv != "0")
{
$flag = true;
break;
}
}
if($flag == false)
{
array_push($finalArray, $count);
}
}
}
}
print_r($finalArray);
die();
I expeced the output to contain the objects with key value pairs that does not contain 0 value but everything prints here. When having different levels of directories, using relative paths will not work anymore, for example: controller - authentication File 1: include('../../model/header.php') model File 2: header.php view File 3. style.css The header.php file includes the css file with a relative path, but the problem is it includes it as follows: ../view/style.css When now the header.php file gets included into File 1 in the folder "authentication", then the css file will not be accessible anymore, for it to be accessible you would have to go two directories up. In this sense my question is, what would be the proper path structure for a folder structure with multiple levels? Should I rather use absolute paths, I am not so prone of absolute path. What if the folders changes a bit, or the domain changes, or the location changes? 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? 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? 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! 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 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 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. What is the best way to keep track of a User's (real-time) online status? Right now I have a Log In script and I set the status in the User's Session, and then "pass" that status from page to page with session_start();. However, the problems with this approach include... 1.) A User is idle for hours or days and thus not really online 2.) A User leaves my site and thus is not really online (Or does closing the window change that?) I want a fairly accurate and real-time reading of whether or not a User is actively using my site so I can set their "Online Status" icon as green (online) or yellow (in active) or grey (offline). Any idea how to accomplish that so I have monitoring like you'd see on an Instant Messenger App? Thanks, Debbie 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 This topic has been moved to Ajax Help. http://www.phpfreaks.com/forums/index.php?topic=316351.0 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 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 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! |
|||||||