update database field based on what the user selects via dropdown

Question

so on my site, the admin can assign a job to a user and that job will automatically have the status: waiting to be accepted. I have now created a drop down box on the job page so that the user can either decline or accept the job with that drop down box. however im unsure of the coding needed to update the database field based on what the user selects.

what im aiming for is: the user selects a status, then clicks the change button to update the status of the job.

current code:

   



    
    
        
           
    
    

            Tyre Hire
            
        
    

    
    

    
    
        
        
    
        
        

             
                
            

        
        

                getMessage();
        }

                if(!isset($_SESSION["username"]))
    {
        //user tried to access the page without logging in
        header( "Location: add.php" );

    }

        $login = $_SESSION['user_ID'];

        $query = "SELECT * FROM login WHERE user_ID = :user_ID"; 
    $term = $conn->prepare($query);
    $term->bindValue(':user_ID', $login);
    $term->execute();

    $login = $term->fetch(PDO::FETCH_OBJ);      


    $status = "Waiting to be accepted";
    $status2 = "Accept Job";
    $status3 = "Decline Job";

    if(isset($_SESSION["username"]))
    {
        echo "Welcome, you are now logged in as ".$_SESSION['username']." "; }
        else { 
        echo "You are currently not logged in";
        };

        ?>
        
                
        

            
      
        
          
          Tyre Hire
        
        
          

                     Home 
                    Search 
                    user_ID . "&occupation=". $login->occupation ."''> Current Jobs ";?> 
                      Register Interest 
                    Logout 
          
          
             Sign Up
             Login
          
        
      
    
        
        
            
        
            
                Current Jobs
                One of the best sites to find the best qualified and skilled drivers in the UK.


                            
            Job Details 

        

    Job role :".$worker->jobTitle."";

    echo "";
    echo " About the role ";
    echo "Company Name:".$worker->company."";

    echo "Job Description:".$worker->jobDescription."";
    echo "shift pattern";
    echo "Start Time: ".$worker-> startTime."";
    echo "End Time: ".$worker-> endTime."";
    echo "
";
    echo "start Date:".$worker->startDate."";
    echo "Job Expiry Date:".$worker->expiry."";
    echo "Current Status: ".$worker->status."";
    echo "";




    ?>
     
      Status
        

             

            

    

     
 
    

    

        




    
     
                      







    

              


            
            




            
             
            
             Recruitment Agencies  
            
             
            
            
             
            
            
             
            
            
             
            
            
            

            
            

            

            
             
            
            
                Address: 5A twickenham road, london SJ5 7AE

attempted it after reading the update manual, no errors but upon clicking the button it gives a blank page.:

   getMessage();
}


$status = $_POST["status"];
$job = $_POST['job_id'];
print_r($_POST);

$query = "UPDATE jobs SET status = :status WHERE job_id = :job_id AND status = :status";


    // Prepare statement
    $stmt = $conn->prepare($query);
$stmt->bindValue(':status', $status);
$stmt->bindValue(':job_id', $job);
    // execute the query
    $stmt->execute();
    //$stmt->commit();
 echo $stmt->rowCount() . " records UPDATED successfully";
?>

ravioli · Accepted Answer

The basic syntax for UPDATE is:

UPDATE 
SET  = 
WHERE  =

In your case, it would probably look something like:

UPDATE jobs
SET status = 
WHERE userid = 
AND jobid =

update database field based on what the user selects via dropdown

Answers (1)

Related Questions