PHP - Variable Returning Empty

Where is my "Progr" return value?   This is not my first day using php but I don't code in the language that often. I don't understand why my dynamic variable is not returned in AJAX GET? Essentially, I need to give the client a simple UI so that they can copy files to a printer and I wanted to provide a little unfiltered feedback so they knew whether operation was a success. My feedback was just going to be output of exec() function though cleaned up slightly (perhaps replace line breaks with html break tags). PHP version is 5.2.17.17 and cannot be upgraded. Web Server Apache.   PHP dumbed down code:   exec("LoadZPL_PURL.bat", $output);

Hello all,

I am a beginner at PHP and trying to form an IF statement, I'm running into a problem which I cannot seem to solve.
Due to my lack of syntax knowledge I would appreciate if someone could point me in the right direction.

The combo variables are sent to this page through a form and defined as these variables at the top of the page.
e.g $combo0 = $_POST["combo0"];

When the results are displayed any form field which was left blank or empty I want to show "N/A" if data is detected in being sent through the form I then want the "Else" statement to take affect.

Currently when I run the below statement N/A is echoed despite if data was sent through the form fields or not....

if (empty($scrap))  {
echo "<h3>Submitted Scrap Results</h3> No scrap parts were booked off";
}
elseif (empty($combo0) || empty($combo1) || empty($combo2) || empty($combo3) || empty($combo4)) {
echo "N/A";
}
else {
echo "<h3>Submitted Scrap Results</h3> <b>Reason:</b> " .$combo0." - ".$combo1." - ".$combo2." - ".$combo3." - ".$combo4."
<br /> <b>on machine</b> " .$mid. " - <b>No. Scrap</b> " .$noscrap. "";
}

Anyone any ideas?

Hello all,  I'm new to PHP and new to this forum (although I have benefitted from your help already -cheers!). However,  this time I cannot find the answer I need/recognise/understand..

I have a form and want to conduct tests on each field returning an error message as a session variable if the test fails. The test will be different for some of the fields, and the error message is specific to each field. If there is an error in any one of the fields I want to be redirected to a failure page where all of the error messages are displayed,  otherwise I am sent on to another page.

I have already written and tested a function to sanitise the incoming form data,  so that's not a problem - it's just how to loop through and test.

I can guess that there are many ways to do this but I need to understand why one option is better than another,  and follow the syntax used (it's all part of my steep learning curve)

The approach I have thought to use is to create an array holding the field name, the test and the message,  then loop through using foreach, applying the array values into the test and creating the error message....but it's not working for me.

The other method is to declare a variable $Stop='No' and if the loop identifies an error, part of the output is to change this to 'yes' and through that redirect to the error page.

I'd really welcome your advice and tuition....cheers.. my code so far is...

Code: [Select]
$Stop='No';
$StaffPassCheck=sanitisealphanum($_POST['PasswordCheck']);

$Errors[0]['value']= sanitisealphanum($_POST['FirstName']);
$Errors[0]['message']='Please re-enter your name';
$Errors[0]['test']=($StaffFname="");

$Errors[1]['value']= sanitisealphanum($_POST['Surname']);
$Errors[1]['message']='Please re-enter your surname';
$Errors[1]['test']=($StaffSname="");

$Errors[2]['value']= sanitisealphanum($_POST['Post']);
$Errors[2]['message']='You must select an option';
$Errors[2]['test']=($StaffPost="Select Value");

$Errors[3]['value']= sanitisealphanum($_POST['Username']);
$Errors[3]['message']='You must select an option';
$Errors[3]['test']=($StaffUser="");

$Errors[4]['value']= sanitisealphanum($_POST['Password']);
$Errors[4]['message']='Please re-enter your password';
$Errors[4]['test']=($StaffPass="");

$Errors[5]['value']= sanitisealphanum($_POST['PasswordCheck']);
$Errors[5]['message']='Sorry, your passwords do not match';
$Errors[5]['test']=($StaffPass===$StaffPassCheck);

foreach ($Errors as $key => $Value){
if ( $Errors['test']=true ){
$Stop='Yes';
return $_SESSION[$key]=$Value['message'];
}
}

if ($Stop='Yes'){
header('Location.test.php');
die();
}else{
header('Location.indexp.php');
}

I know the following simple demonstration fails and what to do to rectify it (though with a lot of additional code is necessary), but I don't know why this is the behaviour. It would be great if someone could explain to me why, and what the neatest way of fixing it would be.

Code: [Select]
+----------+--------------+------+-----+---------+
| Field    | Type         | Null | Key | Default |
+----------+--------------+------+-----+---------+
| Id       | int(11)      | NO   | PRI | NULL    |
| Name     | varchar(45)  | YES  |     | NULL    |     
| Number   | int(9)       | YES  |     | NULL    |         

Code: [Select]
$name = "Bradley Cooper";
$number = "";

$query = "INSERT INTO table (Id, Name, Number) VALUES (1, '$name', $number)";
mysql_query($query);

Because the $number variable is empty, this simple query fails. Logically, one would think that nothing or NULL gets inserted to that field since the MySQL structure rule states that default is NULL, and since nothing is fed to it in the query, I think that it would automatically be NULL since if the column is omitted, that is exactly the value that will be inserted.

Enclosing the variable with quotes is not preferable since this field accepts integers. Also, converting the variable to an integer by (int)$number results in a 0, which is not what I want either. Checking if the variable is empty of not, and if it is, assign $number = "''" so that the query would succeed by enclosing the empty string with single quotes. But this creates a lot of unnecessary code (some of my tables are 80 columns wide and the query therefore have equal amount of variables).

So to summarise, why is this happening and how do I neatly avoid assigning quotes to the empty strings? In other words, how do I insert nothing when variables that usually contain an integer is on occation empty?

How would I write this in php?:

Code: [Select]
If $url does not begin with 'http://'
$url = ''
I want to assign nothing to the variable if it doesn't begin with http://

Thanks! 

Is if($variable) the same as if(!empty($variable)), just different syntax?

Hi I am new to php,  I am trying to capture the url and place into a variable but I only get the 1st digit to show,  I just cant see what I am doing wrong. 

Sorry to ask such a basic question but I just can't work it out,  I have attached a screen shot of all me code, your help would be very very much appreciated.

Man, I'm having a rough week with questions--if you're following at home.  Basically matching a Coach's first and last name to another table, which if matched will yield information about that coach's team. 

Code: [Select]
// or get user by username
$current_user = wp_get_current_user();
$current_first = $current_user->user_firstname;
$current_last = $current_user->user_lastname;
$current_id = $current_user->ID;


echo '<div class="contact_form">';

    echo  $current_first . ' ' . $current_last .' :: ';


$query = "SELECT * FROM schools WHERE coachFirst='".$current_first."' AND coachLast='".$current_last."'";
$result = mysql_query ($query);

if(!$result) {
echo 'There is not a match for your name.';
}
else
{
while($school= mysql_fetch_array($result)) {


echo $school['school'] . ' ' .  $school['id'];

include(ABSPATH ."wp-content/plugins/my-team/form.php");

}




echo '</div>';


echo '<div class="roster">';

include(ABSPATH ."wp-content/plugins/my-team/roster.php");

echo '</div>';
}

What I am looking for is that if any field in a database is empty, the form comes back and puts in the word "empty" into the web page, but not the database.


I got this right now, it shows the first part fine, but the second part it doesn't show the "Empty" comment... I don't understand why... as far as I can tell the code is fine...

Code: [Select]
<?php
            //Nonconformity, Disposition, Comments and Comments & Additional Details
            echo '<div id="box3">';
                if (!empty($row['Nonconformity']) || !empty($row['Disposition']) || !empty($row['Comments']) || !empty($row['CommentsAdditional_Details'])) {
                    echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br />' . $row['Nonconformity'] . '</div>';
                    echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;</span><br />' . $row['Disposition'] . '</div>';
                    echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;</span><br />' . $row['Comments'] . '</div>';
                    echo '<div id="comma"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br />' . $row['CommentsAdditional_Details'] . '</div>';}
                        else
                            if (empty($row['Nonconformity']) || empty($row['Disposition']) || empty($row['Comments']) || empty($row['CommentsAdditional_Details'])) {
                                echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br />Empty</div>';
                                echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;<br /></span>Empty</div>';
                                echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;<br /></span>Empty</div>';
                                echo '<div id="comma"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br />Empty</div>';}
            echo '</div>';
?>

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.";


?>

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 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.

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, 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';

?>

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.