<?php

$currentDirectory = __DIR__;
$parentDirectory = dirname($currentDirectory);

if ($_SERVER["REQUEST_METHOD"] === "POST") {


    if (isset($_POST['data'])) {

                $db1 = new SQLite3($parentDirectory . '/invoices/database/invoices.db');

                $query1 = "SELECT id, item, description, subtotal, clientname, mobile, email, address, projectname, invoicefull, createdby, createdate FROM figures";
                $result1 = $db1->query($query1);
                $invoiceNumber = $_POST['data'];

                while ($row1 = $result1->fetchArray()) {
                    
					if ($invoiceNumber == $row1['invoicefull'] ){
					$item = $row1['item'];
					$description = $row1['description'];
					$subtotal = $row1['subtotal'];
					
					$clientname = $row1['clientname'];
					$email = $row1['email'];
					$mobile = $row1['mobile'];
					$address = $row1['address'];
					$createdby = $row1['createdby'];
					$projectname = $row1['projectname'];
					$createdate = $row1['createdate'];
					
					$id = $row1['id'];
					
					}
                }
                
                
                $db1->close();
            
                $successfull = $item . "«" . $description . "«" . $subtotal . "«" . $clientname . "«" . $email . "«" . $mobile . "«" . $address . "«" . $createdby . "«" . $projectname . "«" . $createdate . "«" . $id;
                
                echo json_encode(['successfull' => $successfull]);
                
                
                
    } else {
		$successfull = "Not Successfull";
		echo json_encode(['successfull' => $successfull]);
    }
	
	
	}     
                    

?>