/**
* Creating new record
*/
public function insertIntoTable($obj, $column_names, $table_name)
{
$db = new dbConnect();
$this->conn = $db->connect();
$c = (array) $obj;
$keys = array_keys($c);
$columns = '';
$values = '';
foreach ($column_names as $desired_key) {
// Check the obj received. If blank insert blank into the array.
if (!in_array($desired_key, $keys)) {
${$desired_key} = '';
} else {
${$desired_key} = $c[$desired_key];
}
$columns = $columns . $desired_key . ',';
$values = $values . "'" . ${$desired_key} . "',";
}
$query = "INSERT INTO " . $table_name . "(" . trim($columns, ',') . ") VALUES(" . trim($values, ',') . ")";
$r = $this->conn->query($query) or die($this->conn->error . __LINE__);
if ($r) {
$new_row_id = $this->conn->insert_id;
$db->disconnect();
return $new_row_id;
} else {
$db->disconnect();
return NULL;
}
}
