<?php

$fields = [
  'title',
  'first_name',
  'last_name',
  'mid_name',
  'gender',
  'h_address',
  'n_bus',
  'religion',
  'tel',
  'occupation',
  'o_address',
  'dob',
  'o_number',
  'email',
  'local',
  'state',
  'bank_name',
  'account_name',
  'account_num',
  'phone',
  'your_email',
];

$columns = implode(', ', $fields);
$values = implode(', ', array_map(function ($field) {
  return ":{$field}";
}, $fields));

$data = [];
foreach ($fields as $field) {
  $data[$field] = isset($_POST[$field]) ? $_POST[$field] : null;
}
$sql = "INSERT INTO users ({$columns}) VALUES ({$values})";

try {
  $dsn = "mysql:host=localhost;dbname=myDatabase;charset=utf8mb4";
  $options = [
    PDO::ATTR_EMULATE_PREPARES   => false,
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  ];
  $pdo = new PDO($dsn, "username", "password", $options);
  $statement = $pdo->prepare($sql);
  $statement->execute($data);
  echo $pdo->lastInsertId();

} catch (Exception $e) {
  error_log($e->getMessage());
}