PHP - Fourgefeed Returning Blank

hello, anybody able to help me with why this is only returning the first staff member's hours?

Code: [Select]
<?php

if(isset($_POST['view']))
{

$y3=$_POST['y'];
$m3=$_POST['m'];
$d3=$_POST['d'];

$pdate=$y3."-".$m3. "-".$d3;
$pdate1 = date( 'D M j', strtotime($pdate) );
} else {


$pdate =  date('Y-m-d', strtotime("-1 day") );
$pdate1 = date( 'D M j', strtotime($pdate) );


}
echo "<table border='1' style='border-collapse: collapse' bordercolorlight='#000000' bordercolordark='#000000' width='98%' align='center'>";
echo "<tr><td width='100%' colspan='9' align='center'><b>Timesheets For $pdate1</b></td></tr>";


$result = mysql_query("SELECT * FROM staff ORDER BY name");
while($row = mysql_fetch_array($result))
{
$eid=$row['eid'];
$name=$row['name'];

  echo "<tr>";
  echo "<td align='left' colspan='9'><b>" . $name . "</b></td>";
  echo "</tr>";
 
 echo "<tr>
<th align='center'>Date</th>
<th align='center'>Job Number</th>
<th align='center' width='30%'>Service Report</th>
<th align='center'>Sign In Time</th>
<th align='center'>Sign Out Time</th>
<th align='center'>Lunch</th>
<th align='center'>Time Billed</th>
<th align='center'>Estimated</th>

</tr>";
 
 
$result3 = mysql_query("SELECT * FROM timesheet WHERE date = '$pdate' AND eid = '$eid'");
$talltime = 0;
while($row3 = mysql_fetch_array($result3))
{

  $tid=$row3['id'];
  $tdate=$row3['date'];
  $tjobnumber=$row3['jobnumber'];
  $teid=$row3['eid'];
  $tdescription=$row3['description'];
  $tsignin=$row3['start'];
  $tfinish=$row3['finish'];
  $tlunch=$row3['lunch'];
  $tkms=$row3['kms'];
  $tschednum=$row3['schednum'];

 
  
  $tdate1 = date( 'M j, Y', strtotime($tdate) );
  
    $tsignin1 = date( 'g:i a', strtotime($tsignin) );
$tfinish1 = date( 'g:i a', strtotime($tfinish) );

if( empty($tfinish) ) {
 $tfinish2="<i>In Progress";
} else {
 $tfinish2="$tfinish1";
}

$shortid=substr($tjobnumber, 5, -1); //remove the first 5 characters and minus the last character

$result = mysql_query("SELECT * FROM jobs WHERE id = '$shortid'");
while($row = mysql_fetch_array($result))
{
$jstatus=$row['status'];
 
}


$result4 = mysql_query("SELECT * FROM schedule WHERE id = '$tschednum'");
while($row4 = mysql_fetch_array($result4))
{

  $sid=$row4['id'];
  $sdate=$row4['date'];
  $seid=$row4['eid'];
  $sjobnumber=$row4['jobnumber'];
  $sstarttime=$row4['starttime'];
  $sstatus=$row4['status'];
  $setime=$row4['etime'];
  
}

$log_in_time_string = strtotime($tsignin);
$log_out_time_string = strtotime($tfinish);
$difference_in_seconds = ($log_out_time_string - $log_in_time_string);
$tbilled = ($difference_in_seconds / 3600);
  
  
  if($tbilled < 0)
{
    $tbilled1 = $tbilled + 24;
} else {
    $tbilled1=$tbilled;
}
  
  $tbilled2 = number_format(round($tbilled*4)/4,2);
  $tbilled3 = $tbilled2 - $tlunch ;
  $talltime += $tbilled3;
  
  
  echo "<tr>";
  echo "<td align='center'>" . $tdate1 . "</td>";
  echo "<td align='center'>" . $tjobnumber . "</td>";
  echo "<td align='center'>" . $tdescription . "</td>";
  echo "<td align='center'>" . $tsignin1 . "</td>";  
echo "<td align='center'>" . $tfinish2 . "</td>";
echo "<td align='center'>" . $tlunch . " hour</td>";
echo "<td align='center'>";
     if ($tbilled3 > $setime ) {
 echo "<font color='red'><b>*** " . $tbilled3 . " hours ***</b></font>";
 } else {
 echo "" . $tbilled3 . " hours";
 }
echo "</td>";
echo "<td align='center'>" . $setime . " hours</td>";


  echo "</tr>";

} 
   echo "<tr>";
 
  echo "<td colspan='6' align='right'><b>Totals :</td>";
  echo "<td align='center' colspan='2'>";
     if ($talltime > "8" ) {
 echo "<font color='red'><b>*** " . $talltime . " hours ***</b></font>";
 } elseif ($talltime < "0" ) {
 echo "<font color='red'><b>Not Signed Out</b></font>";
 } else {
 echo "" . $talltime . " hours";
 }
echo "</td>";

  echo "</tr>";

   echo "<tr>";
 echo "<td align='center' colspan='8' bgcolor='#D9FFD9'><hr></td>";
  echo "</tr>";

}
    
echo "</table>";







include 'close.php';

?>

How would i return the id in the echo of this post:


$query = "INSERT INTO jobs SET agent = '".mysql_real_escape_string($agent)."', title = '".mysql_real_escape_string($title)."', location = '".mysql_real_escape_string($location)."', salary_from = '".$salary_from."', salary_to = '".$salary_to."', frequency = '".$frequency."', jobtype='".$jobtype."', description='".$description."', email = '".$email."', created_at = '".$created_at."', closing_date ='".$closing_date."', categories = '".$categories."', sectors = '".$sectors."', ref='".$ref."'";
if(mysql_query($query)) {
echo "Job inserted!";
} else {
die(mysql_error());
}


Thanks for the help guys

Ok I have this code retrieving information from mysql:


if (isset($memid)) {
    $query_meminfo = "SELECT * FROM ".MEMBER_PROFILE_TABLE." WHERE `user_id`=".$memid;
    $query_result = mysql_query($query_meminfo, $db);
    $MemName = mysql_result($query_result, 0, 'display_name');
    $MemGroup = mysql_result($query_result, 0, 'Group');
    $LevelQuery = "SELECT group_level FROM ".MEMBER_GROUPS." WHERE group_id='".$MemGroup."'";
    $LevelResult = mysql_result(mysql_query($LevelQuery, $db), 0, 'group_level');
    $MemLevel = intval($LevelResult);
}


It is definitely retrieving the correct info as it is correctly checking member levels to display certain information.

Part 2 of code:


<table width="100%" id="userlinks" cellspacing="6">
    <tr>
        <td>Welcome
            <?php
            if (isset($MemName)) {
            Echo $MemName + " "; ?>
            (<a href="index.php?act=logout">Logout</a>
            <?php
                if ($MemLevel >= 9000) {
                    echo " | <a href='admin.php'>Admin CP</a>";
                }
            ?>
            )
            <?php
            }
            Else {
                ?>
            Guest (<a href="index.php?act=login">Login</a> | <a href="index.php?act=register">Register</a>)
            <?php
            }
            ?>
        </td>
    </tr>
</table>


For some reason, instead of displaying the person's display name it is just displaying the number 0.

SELECT i.item_id, 
		         i.title, 
		         i.price,
		         i.p_and_p,
		         SUM(i.price + i.p_and_p) AS `total_price`,
		         i.listing,
		         i.condition,
		         i.start_date_time,
		         i.listing_duration,
		         CONVERT_TZ(DATE_ADD(i.start_date_time, INTERVAL concat(i.listing_duration) DAY), '+00:00', u.time_zone) AS `end_date_time`
		  FROM items i
		  LEFT JOIN sub_categories sc ON sc.sub_category_id = i.sub_category_id
		  LEFT JOIN categories c ON c.name = 'test'
		  JOIN users u
		  WHERE u.username = 'Destramic'
		  AND i.start_date_time < NOW() 
		  AND DATE_ADD(i.start_date_time, INTERVAL concat(i.listing_duration) DAY) >= NOW()

I'm having a problem with my query returning more than 1 rows...I've even copied the row which is returning to see if that'll return 2 rows but it doesn't   can anyone explain why this is happening please?    

Hi All

Please take a look at the code below.  I am sucessfully accessing a database and pulling the details through into a HTML form with a drop down.  However I then want to use a variable (test) in another page.  However I cannot get the variable userrow['userid'] to send a value to my getquiz.php.  What am I doing wrong?

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>
 <?php
include_once "db.inc.php";
?>
<body>
<form action="getquiz.php" method="GET">
  <tr><td class="title">Please Select User</td> 
<td><select name="test">
<?php
$courseid = mysqli_query($link, 'SELECT id FROM mdl_quiz WHERE course = "225"; ');
if (!courseid)
{
$error = ' Error fetching course id: ' . mysqli_error($link);
include 'error.html.php';
exit();
}
else {
while($row = mysqli_fetch_array($courseid))
  {
  $user = mysqli_query($link, 'SELECT userid FROM mdl_quiz_attempts WHERE quiz =' . $row['id']);
  while ($userrow = mysqli_fetch_array($user))
  {
  $names = mysqli_query($link, 'SELECT firstname,lastname FROM mdl_user WHERE id=' . $userrow['userid']);
  while ($usernames = mysqli_fetch_array($names))
  {?>
  <option value="<?php $userrow['userid']?>"> <?php echo $usernames ['firstname'] . " " . $usernames['lastname'] . $userrow['userid']; ?> </option>
  <?php
     }
  }
  }
}
?>
</select>
</td></tr>
<center><input type="submit" value="Submit"></center>
</table>
</form>
</body>
</html>

Browser HTTP client makes a request to a HTTP web server which makes a HTTP cURL request to a HTTP REST API which initiates a ReactPHP socket client to make a request to a socket server, and the socket server script eventually execute the following method:

    public function executeSpecificRequestCommand(array $data):bool {
        $status = $this->doSomething($data);
        return $status; //{success: $status} will be returned to the socket client
    }

All is good until doSomething()  takes a lot of time and results in a cURL error between the HTTP web server and HTTP REST API.  For this particular case, the task isn't meant to provide immediate feedback to the user, but to do some work and update the database, and as such, my desire is to return true status and then perform the work instead of extending the cURL timeout.

One option is to ran some process in the background and return status, but I don't think doing so is really right.  Using a queue seems excessive as I am already decoupled via the socket.  As such, I will probably just add some logic between the initial $string->on('data') and this executeSpecificRequestCommand() method to determine whether the success message should be returned before or after the method is complete.

Before doing so, however, I would like to know if there is a more appropriate approach to this scenario.  It appears that maybe a child process or a deferred might be appropriate, but am not sure whether I am going down the wrong path.

I'm trying to get this to either show "Final" or "Final Overtime" but it just continues to show "Final" even when the XML key value says Overtime...   What am I missing here?   Thank you!

 

i am having issues returning all sent messages.  it will only return one for some reason.

Code: [Select]
//If there are sent messages, display them
if ($row = mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result) or die(mysql_error());

    //Open table and create headers
    echo "<table border=\"1\">\n";
    echo "  <tr>\n";
echo "    <th>Recipient</th>\n";
    echo "    <th>Subject</th>\n";
    echo "  </tr>\n";

while(mysql_fetch_array($result))
{
//Show messages
$userIDTo = $row['userIDTo']; // Get the recipient's ID number
$recipient = checkRecipient($userIDTo); // Get the sender's Username
$messageID = $row['ID'];
        echo "  <tr>\n";
echo "    <td>{$recipient}</td>\n";
        echo "    <td><a href='messageDetails.php?messageID=$messageID' target='_blank'>{$row['subject']}</a></td>\n";
        echo "  <tr>\n";
}
thanks in advance.

Hello.

I am trying to pass along a variable in an email auto response ($park), however if the variable is 2 words then it only passes along the first word.  Any info would be great.

Code: [Select]
<?php

$to = "$email";
$subject = "Event Signup Confirmation";
$message = "Hello $firstname! 

Thank you for signing up to work the $park event.  Someone will contact you shortly.

Event Information
Park: $park
Date: $orderdate
Time: $hour:$min $ampm
Description: $description
Crew Leader: $leader";

$from = "guy@xxxx.com";
$headers = "From: $from";
mail($to,$subject,$message,$headers);

 
echo "Thank you for signing up. You will receive an email shortly letting you know event details and who your crew leader is.";


?>

Hey there,

Now I was curious if there was a way I could return an array in my function like the following, I currently get a error though:

Code: [Select]
Catchable fatal error: Object of class panel_accounts could not be converted to string in C:\wamp\www\X-HostLTD - Panel\PanelFrontend\index.php on line 21

But can you only return strings?.

Here is the function that it errors on:


function returnAccountInformation($AccountID)
{
return mysql_fetch_array(mysql_query("SELECT * FROM ****_***** WHERE *****_***** = '".mysql_escape_string($AccountID)."'"));
}


Could somebody help me on the matter?, Thank you.

P.S sorry for staring out the table names but I don't really want people knowing my database structure hehe.

Hi all. I'm having a bit of trouble with my script. I can't get "getDirectoryListings()" to return what folders are inside of #SharedObjects

Here's my 2 files, 1 is sollib.php, the other is solindex.php.

Code: [Select]
solindex.php:

<?php

        require('sollib.php');

$shell= new COM('WScript.Shell');
$data=$shell->regRead('HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\ProgramFilesDir');

$regval = trim($data, "Program Files");

if(getenv('AppData')!=''){

  $filename = getenv('AppData')."\\Macromedia\\FlashPlayer\\#SharedObjects\\".getDirectoryListings();
  
  die($filename);


}

?>

sollib.php:

<?php

die(getDirectoryListings());

        function getDirectoryListings() {

                         $final = "";

 $filename = getenv('AppData')."\\Macromedia\\FlashPlayer\\#SharedObjects\\";

if ($handle = opendir($filename)) {


while (false !== ($file = readdir($handle))) {


if(($file != '.') && ($file != '..')) {

if(!strpos($file,'.')) {

if ($handle2 = opendir($filename.$file)) {




while (false !== ($file2 = readdir($handle2))) {

die($file2);


if(($file2 != '.') && ($file2 != '..')) {



 $final = $filename."$file\\$file2\\".get_files($file2);

 die($final);

if($file2 == 'www.xatech.com'){



 die('files: '.get_files($file2));



}



}


}

}
 
}else{

 $final = $file;

}

}

}
  
 closedir($handle);
}

 return $final;

        }

function get_files($dir){

 //path to directory to scan

 $directory = $dir;


 
//get all sol files with a .sol extension.

 $file11 = glob("" . $directory . "*.sol");
 

//print each file name

foreach($file11 as $files10){

   $final = $files10;
   die($final);
}

}

?>

My aim is for this what if the table is empty which means no results will be retrieved in the first query then I want it to repeat the $testArray as "TBD" as well.


Code: [Select]
function getTop5()
    {
        $this->db->select('character1_id, character2_id, character3_id, character4_id, character5_id');
        $this->db->from('site_top5');
        $this->db->where('status_id', '1');
        $this->db->order_by('id', 'desc');
        $query = $this->db->get(); 
        $row = $query->row();
        $ids = array(
        $row->character1_id,
        $row->character2_id,
        $row->character3_id,
        $row->character4_id,
        $row->character5_id
        );
       
        $testArray = array();
        foreach ($ids as $id) {
            if($id !== "0") {
                $this->db->select('character_name');
                $this->db->from('characters');
                $this->db->where('id', $id);
                $query = $this->db->get(); 
                $row = $query->row();
                $testArray[] = $row->character_name;
            } else {
                $testArray[] = "TBA";
            }
        }
        return $testArray;
    }

Hey Guys,

I am hoping you can help me find out why a function of mine is only returning 1 record when I am asking for 10.

Here is the function I am using to get the data.

When I run the $sql that is printed in phpmyadmin.... I get then records. But when I print the $event_data I am only getting 1 record.

Any help would be greatly appreciated


function get_events($data)
{
//print_r($data);
$lat = $data['lat'];
$long = $data['long'];
$offset = $data['offset'];
$radius = $data['radius'];
$amount = $data['amount'];

//the events query
$sql = sprintf("SELECT *, ( 3959 * acos( cos( radians('%s') ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( latitude ) ) ) ) AS distance FROM events WHERE `status` = '0' HAVING distance < '%s'  ORDER BY distance LIMIT $amount OFFSET $offset",
  mysql_real_escape_string($lat),
  mysql_real_escape_string($long),
  mysql_real_escape_string($lat),
  mysql_real_escape_string($radius));

//debugging
print_r($sql);

$event_data = array();
$event_data = mysql_fetch_array(mysql_query($sql));

//debugging
print_r($event_data);

return $event_data;

}

Below is some PHP code that looks at a DB and outputs a value within the user declared time and date period, via user recall using a web app attached to it.  The code is rounding the numbers but I want it to include 2 of the decimal places. The original numbers in the DB have up to 5 decimal digits.  This code is making them whole numbers.  i would like to include the first 2 digits.  I suspect the float should somehow be float(2) .  Not sure how to do that. 

thanks in advance   

<?php
$sql = ";WITH TOTAL_FULL_ENERGY_SUM_BASE_WEEKDAY_SUMMER AS
(
SELECT cdate, datepart(hh, cdate) as trans_hour, datepart(mi, cdate) as trans_minute, comm_id, 
max(cast(total_full_energy_b AS FLOAT)/1000) * meter_multiplier AS totalUsage, meter_multiplier
  FROM [radiogates].[dbo].[purge_data] LEFT OUTER JOIN [radiogates].[dbo].[ops_invoice] on [radiogates].[dbo].[purge_data].[comm_id] = [radiogates].[dbo].[ops_invoice].[meter_id] 
  where comm_id='$comm_id' and meter_multiplier is not null
  group by comm_id, cdate, meter_multiplier
)
SELECT top 1 *, datepart(weekday, cdate) as trans_date_day, 
datepart(month, cdate) as trans_date_month, datepart(hour, cdate) as trans_date_hour, DATEPART(minute, cdate) as trans_date_minute
FROM TOTAL_FULL_ENERGY_SUM_BASE_WEEKDAY_SUMMER 

where datepart(weekday, cdate) IN ('2', '3', '4', '5', '6') 
AND DATEPART(MONTH, cdate) IN ('5','6','7','8','9','10') 
and cdate between '$base_date $base_start_time' and '$base_date $base_end_time'

ORDER BY totalUsage desc";
$query = sqlsrv_query($conn, $sql);if ($query === false){  exit("<pre>".print_r(sqlsrv_errors(), true));}while ($row = sqlsrv_fetch_array($query)){  	$sumUsageWKW += $row[totalUsage];}sqlsrv_free_stmt($query);?> 

Edited by Butterbean, 15 October 2014 - 01:31 PM.

Code: [Select]

//policies subreport
function opportunity_sub_report($business_contact_id){
global $edit, $styles;
$sql="Select * from opportunities WHERE op_business_contact_id='$business_contact_id'";
$rs=myload($sql);

echo '<table>';
if (count($rs)>0){
// print a header row
echo '<tr>
<td>Opportunity ID</td>
<td>Category</td>
<td>Agent</td>
<td>Opportunity Name</td>
<td>Priority</td>
<td>Assigned To</td>
<td>Opportunity Type</td>
<td>Opporunity Status</td>
<td>Opportunity Submission</td>
<td>Due Date</td>
<td>Contracting Recieved(Y or N)?</td>
<td>New Business</td>
<td>Notes</td>
<td>Business Contact ID</td>
</tr>';

// print all data rows
foreach ($rs as $r){
echo '<tr>
<td>'.display_field('', $p,$r['op_id']).'</td>
<td>'.display_field('',$p,$r['op_category']).'</td>
<td>'.display_field('', $p,$r['op_agent_id']).'</td>
<td>'.display_field('', $p, $r['op_opportunity_name']).'</td>
<td>'.display_field('', $p, $r['op_priority']).'</td>
<td>'.display_field('', $p, $r['op_assigned_to']).'</td>
<td>'.display_field('', $p, $r['op_opportunity_type']).'</td>
<td>'.display_field('', $p, $r['op_status']).'</td>
<td>'.display_field('', $p, $r['op_submission_date']).'</td>
<td>'.display_field('', $p, $r['op_due_date']).'</td>
<td>'.display_field('', $p, $r['op_contracting_received_y_or_n']).'</td>
<td>'.display_field('', $p, $r['op_new_business_app_received_y_or_n']).'</td>
<td>'.display_field('', $p, $r['op_wholesaler_notes']).'</td>
<td>'.display_field('', $p, $r['op_business_contact_id']).'</td>
</tr>';
}

}
echo '</table>';


}

I'm having some trouble with some code I'm tasked with maintaining.  This code works, but it doesn't return the information in a tab.  I'm using tabber.js 
It's being called here

Code: [Select]
echo '
<tr>
<td class="timegrid" colspan=5>
<div class="tabber">
<div class="tabbertab" title="Contracting"></div>
<div class="tabbertab" title="Licensing"></div>
<div class="tabbertab" title="Cases"></div>
<div class="tabbertab" title="Commissions"></div>
<div class="tabbertab" title="Opportunities">'.opportunity_sub_report($rs[0][bc_business_contact_id]).'</div>
<div class="tabbertab" title="Tasks"></div>
<div class="tabbertab" title="Calendar"></div>
<div class="tabbertab" title="Attachments">'.agent_detail_attachments($rec_id).'</div>
</div>
</td>
</tr>';

echo '</table>';
I've tried changing it from echo to return, but I'm not sure how to keep the foreach loop intact in such a way.  I'm trying to create subreports in a web app, that would act like access.  Any help would be much appreciated.