0

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');
}
Jacob Mulquin
  • 2,486
  • 1
  • 17
  • 22

0 Answers0