SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'desc, type , created_at) VALUES ( 'dfgsdg', 'IRR', '1', '3456346', 'sdgsdgdsg...' at line 1
My form:
<form method="post" action="http://localhost/windocs/billing/store">
<div class="form-group row">
<label class="col-sm-2 col-form-label">Title Of billing</label>
<div class="col-sm-10">
<input autocomplete="off" type="text" id="name" name="name" class="form-control">
</div>
</div>
<div class="form-group row">
<label class="col-sm-2 col-form-label">Currency</label>
<div class="col-sm-10">
<select name="currency" id="currency" class="form-control">
<option value="IRR">IRR - iranian rial</option>
<option value="Dollar">Dollar - united states dollar</option>
<option value="Euro">Euro - European euro</option>
</select>
</div>
</div>
<input type="hidden" name="owner_id" value="<?php echo $_SESSION['user_id']; ?>">
<input type="hidden" name="module_id" value="<?php echo $_SESSION['module_id']; ?>">
<div class="form-group row">
<label class="col-sm-2 col-form-label">Amount price Of billing</label>
<div class="col-sm-10">
<input autocomplete="off" type="number" id="price" name="price" class="form-control">
</div>
</div>
<div class="form-group row">
<label class="col-sm-2 col-form-label">Desc Of billing</label>
<div class="col-sm-10">
<textarea name="desc" id="desc" rows="4" cols="70"></textarea>
</div>
</div>
<div class="form-group row">
<label class="col-sm-2 col-form-label">Type</label>
<div class="col-sm-10">
<select name="type" id="type" class="form-control">
<option value="income">income</option>
<option value="cost">cost</option>
<option value="deleted-income">deleted-income</option>
<option value="deleted-cost">deleted-cost</option>
</select>
</div>
</div>
action page
public function store($request)
{
$request['name'] = preg_replace("/[^a-zA-Z 0-9الف-ی]+/", "_", $request['name']);
$_SESSION['menu']="Billing";
$db= new DataBase();
$db->insert('billing',array_keys(array_filter($request)) , array_filter( $request));
//$this->redirect('billing');
}