Re: In-Progress Job

<?php

$host = 'localhost';

$db = 'atlamhgs_serviceCentreDB';

$user = 'atlamhgs_serviceCentreDBUser';

$pass = 'yXNgC!fGxug?G1Yn7';

$charset = 'utf8mb4';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";

$options = [

PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,

PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,

PDO::ATTR_EMULATE_PREPARES => false,

];

$jobID = htmlspecialchars($_GET["jobID"]);

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

$jobID2 = $_POST["jobID"];

$inProgressjobsql = $pdo->query("UPDATE appData_clientJobs SET jobStatus = '5' WHERE ID = $jobID2");

echo('<div class="alert alert-secondary" role="alert"><b>Job Updated</div>');

}

?>

<form id="inProgress" method="post">

<input type="Hidden" Name="jobID" Value=$jobID>

<div class="form-group">

<button name="inProgress" type="submit" value="submit" style="background-color: #3c3d42; border-color: #3c3d42;"class="btn btn-primary">In-Progress</button>

</div>

</form>

Author

Title

Language

Your paste - Paste your paste here

&lt;?php
$host = 'localhost';
$db   = 'atlamhgs_serviceCentreDB';
$user = 'atlamhgs_serviceCentreDBUser';
$pass = 'yXNgC!fGxug?G1Yn7';
$charset = 'utf8mb4';

$dsn = &quot;mysql:host=$host;dbname=$db;charset=$charset&quot;;
      $options = [
        PDO::ATTR_ERRMODE            =&gt; PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE =&gt; PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   =&gt; false,
      ];

$jobID = htmlspecialchars($_GET[&quot;jobID&quot;]);

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

$jobID2 = $_POST[&quot;jobID&quot;];

$inProgressjobsql = $pdo-&gt;query(&quot;UPDATE appData_clientJobs SET jobStatus = '5' WHERE ID = $jobID2&quot;);

echo('&lt;div class=&quot;alert alert-secondary&quot; role=&quot;alert&quot;&gt;&lt;b&gt;Job Updated&lt;/div&gt;');
    }

?&gt;

&lt;form id=&quot;inProgress&quot; method=&quot;post&quot;&gt;
  &lt;input type=&quot;Hidden&quot; Name=&quot;jobID&quot; Value=$jobID&gt;
  &lt;div class=&quot;form-group&quot;&gt;
    &lt;button name=&quot;inProgress&quot; type=&quot;submit&quot; value=&quot;submit&quot; style=&quot;background-color: #3c3d42; border-color: #3c3d42;&quot;class=&quot;btn btn-primary&quot;&gt;In-Progress&lt;/button&gt;
  &lt;/div&gt;
&lt;/form&gt;

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

Spam protection -

Re: In-Progress Job

A PHP Error was encountered

A PHP Error was encountered

A PHP Error was encountered

Reply to "Re: In-Progress Job"