Re: In-Progress Job

From Soft Bat, 4 Years ago, written in PHP.

Embed

Download Paste or View Raw
Hits: 64

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

{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}

Re: In-Progress Job

Reply to "Re: In-Progress Job"