PHP - Required Field

Hi Friends,

I am trying to do an API with oracle database. The JSON request from 3rd party will look like below.

{
    "contact_id": "1",
    "serial_no": "100",
    "name": "baby",
    "inv_date": "2018-06-27",
    "due_date": "2018-06-27",
    "currency": "KD",
    "subtotal": "143",
    "tax_total": "13",
     "shipment_data": [
        {
            "serial_no": "33",
            "master_no": "55",
            "house_no": "77",
            "cost_revenue_items": [
                {
                    "charge_ref": "rr",
                    "currency": "INR",
                    "quantity": "2",
                    "selling_rate": "45",
                    "exchange_rate": "7",
                     "taxes": [
                        {
                            "serial_no": "1",
                            "ref": "INR",
                            "voiding_remarks": "oo"
                        },{
                            "serial_no": "2",
                            "ref": "KWD",
                            "voiding_remarks": "asd"
                        }
                    ]
                    
                }
            ]
        }
     
       
    ]
}

how to handle request for JSON in which master is updated (PUT) and child record is (Either INSERTED, UPDATED or DELETED) ?

One of my virtual hosts contained php_value upload_max_filesize 8M which resulted in error when running as php-fpm.  Also, looks like .htaccess files are no longer used.  Any other gotcha's???

Reading up on it, looks like I want to move all .htaccess instructions to a https://www.php.net/manual/en/configuration.file.per-user.php file.  Should be straight forward enough.

Looking at https://www.php.net/manual/en/configuration.changes.php, looks like I should scan /etc/httpd/* as well as any virtual sites defined elsewhere for "php_" and move these requirements elsewhere.  Will this also have to be a per directory .user.ini file?  Reason I ask is I always thought it was better performance to when possible use apache's conf file than a .htaccess file.

if (!empty($_POST['progress'])) {
	if(Input::exists()) {
		if(Token::check(Input::get('token'))) {
			$adminprogress = Input::get('admin');
			$adminidprogress = Input::get('adminid');
			$memberprogress = Input::get('member');
			$projectprogress = Input::get('project');
			$statusprogress = Input::get('status');
			$timestamp = date('Y-m-d H:i:s');
			
			$progressupdate = DB::getInstance()->insert(progress, array(
				'admin' => $adminprogress,
				'adminid' => $adminidprogress,
				'member' => $memberprogress,
				'project' => $projectprogress,
				'status' => $statusprogress,
				'timestamp' => $timestamp
			));

			Redirect::to('memberattire1.php');
		}
	}
}

<form method="post" action="">
<label>
	<select name="status">
				<option value=choose>---Please Select---</option>
				<option value = "0">(10%) Bunker Registered</option>
				<option value = "10">(20%) First discussions held</option>
				<option value = "20">(30%) Initial research undertaken</option>
				<option value = "30">(40%) Ideas shared</option>
				<option value = "40">(50%) Enquiries made</option>
				<option value = "50">(60%) Results of enquiries shared</option>
				<option value = "60">(70%) Preferences shared</option>
				<option value = "70">(80%) Decisions made</option>
				<option value = "80">(90%) Decisions being executed</option>
				<option value = "90">(100%) Project Completed</option>
	</select>
</label>
<br><br>
<input type="hidden" name="member" value="<?php echo $membername; ?>">
<input type="hidden" name="admin" value="<?php echo $admin; ?>">
<input type="hidden" name="adminid" value="<?php echo $adminid; ?>">
<input type="hidden" name="project" value="attire1">
<input type="hidden" name="token" value="<?php if(isset($token)) { echo $token; } else { echo $token = Token::generate(); } ?>" >
<input type="submit" value="Submit Update" name="progress">
</form>

I have a html/php i am creating but getting the following error:

[10-May-2019 09:42:13 UTC] PHP Fatal error:  Uncaught Error: Call to a member function prepare() on null in C:\inetpub\wwwroot\SupportDesk\php\Add_New_Engineer.php:88
Stack trace:
#0 C:\inetpub\wwwroot\SupportDesk\php\Add_New_Engineer.php(5): create_eng()
#1 {main}
  thrown in C:\inetpub\wwwroot\SupportDesk\php\Add_New_Engineer.php on line 88

Here is my code:

<?php
$server = htmlentities($_SERVER['PHP_SELF']); 
 	if (isset($_POST['submit'])) {
        $result = create_eng();
 }
?>
<!DOCTYPE html>
<html lang="en">
   <head>
      <title>Add A New Engineer | DDS Dashboard</title>
      <meta charset="utf-8"  />
      <link rel="icon" type="image/png" href="../images/favicon-16x16.png"/>
   </head>
   <body>
      <?php 
         include('nav.php');
         include('ConnectionDB.php');
         
         ?>
      <div class="jumbotron">
         <div class="container">
            <h1><br><img src="../images/clipboard-customer.png"/> Add New Engineer:</br></h1>
         </div>
      </div>
      <form class="form-horizontal" role="form" id="add_eng" action="<?php $server ?>" method = "post">
         <div class="form-group">
		 <!--<?php //display_msg($msg);?>-->
            <label for="EngineerName" class="col-sm-2 control-label">Engineer Name:</label>
            <div class="col-sm-6">
               <input type="text" class="form-control" id="EngName" name="EngineersName" placeholder="Enter Engineer's Name"></input>
               <small class="form-text text-muted">
               Enter the new engineer's name above to enter them into the database.
               </small>
            </div>
            <input name="submit" type="submit" value="Create Engineer" class="btn btn-primary default"></input>
            <input name="reset" type="Reset" value="Reset Form" class="btn btn-primary default"></input>
         </div>
      </form>
      <br><br>
   </body>
</html>
	<?php
	$sql = "Select * from [Engineers] where [Engineer] not like '%\_%' Escape '\' order by [Engineer] asc";
			$stmt = $conn->prepare($sql);
			$stmt->execute();
			$results=$stmt->fetchAll(PDO::FETCH_ASSOC);
			?>
			<div class="containerenglist">
			<div class="col-sm-5">
			<table id="alleng" class="table table-bordered">
			<tr>
			<th>Active Engineer's Names:</th>
			</tr>
			<?php
			foreach ($results as $row) {
				echo "<tr><td>";
				echo $row['Engineer'];
				echo "</td>";
				echo "</tr>";
			}
			?>
			</table>
			</div>
			</div>
	
</body>
</html>		

<?php

Function create_eng(){
	global $msgID;
	global $msg, $conn;
	include('ConnectionDB.php');
	$conn = null;
	$msgID = 0;
	//Get POST from submit
	$eng_name = $_POST['EngineersName'];
	//SQL Query
	$sql_count = "select count(*) as num from [Engineers] where [Engineer] = :eng_name";
	//Query SQL Statement
	//echo $eng_name;
	$stmt = $conn->prepare($sql_count);
	$stmt->bindValue(':eng_name', $eng_name);
	//Execute SQL Statement
	$stmt->execute();
	$results=$stmt->fetchAll(PDO::FETCH_ASSOC);
	If($results['num'] > 0){
		echo $msg = "Engineer $eng_name exist's in the database";
		$msgID = 1;
	}else{
		$sql_insert = "insert into [Engineers](Engineer) values '$eng_name'";
		//Prepare SQL Statement
		$stmt = $conn->Prepare($sql_insert);
		//Execute SQL Statement
		$stmt->execute();
	    $results=$stmt->fetchAll(PDO::FETCH_ASSOC);
		echo $msg = "Engineer $eng_name added to the database";
		$msgID  = 2;
	}

}	
?>

Everything works correctly until i try submitting a name to the DB the line that is being pulled is $stmt = $conn->prepare($sql_count);