/** * 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; } }