INSERT INTO pdo from web-form

Question

Why my insert-form isn't works?

public function safeCar() {

    $asd = "INSERT INTO 
        'Car'(mark,
        model,
        year,
        state_num,
        mileage,
        colour,
        consumption,
        cost_less_30_inc,
        cost_more_31) 
        VALUES('$this->mark', 
        '$this->model', 
        $this->year, 
        $this->state_num, 
        $this->mileage, 
        '$this->colour', 
        $this->consumption,
        $this->cost_less_30, 
        $this->cost_more_31)";
    echo($asd);

    $this->db->prepare($asd)->execute();

I'm sending form via POST and trying to add data into DB. But php sent me a error

Fatal error: Uncaught Error: Call to a member function prepare() on string in ...

..

But my string looks so good

INSERT INTO 'Car'(mark, model, year, state_num, mileage, colour, consumption, cost_less_30_inc, cost_more_31) VALUES('Fiat', 'Punto', 2003, 345, 32929, 'black', 7, 10, 7)

it works in phpMyAdmin

Where I made a mistake?

var - db its PDO object

Learn about prepared Statements to prevent SQL injection – Jens Nov 02 '17 at 08:24 — Jens, Nov 02 '17 at 08:24
ok, I got it. But it just study project – Andreykin Sergey Nov 02 '17 at 11:19 — Andreykin Sergey, Nov 02 '17 at 11:19

Mert Simsek · Answer 1 · 2017-11-02T11:44:43.857

0

 $prepare = $this->db->prepare("INSERT INTO Car (mark, model, year,state_num,mileage,colour, consumption, cost_less_30_inc, cost_more_31) 
        VALUES (:mark, :model, :year, :state_num,:mileage,:colour,:consumption,:cost_less_30_inc,:cost_more_31)");

$prepare->execute(array(
    'mark' => 'Honda',
    'year' => 2016,
     ...
     ...
);

edited Nov 02 '17 at 11:44

answered Nov 02 '17 at 08:42

Mert Simsek

1,550
9
19

I did it but it isn't works :( Connection with db is ok, my 'select' queries works great – Andreykin Sergey Nov 02 '17 at 11:41
i edited, try this and have you take error output? – Mert Simsek Nov 02 '17 at 11:45
Yes, the error is similar.. I've already tried to do it like that – Andreykin Sergey Nov 02 '17 at 11:57
I did it! My var "db" was static and it must be calling by self:: But all the same tx to u. – Andreykin Sergey Nov 02 '17 at 16:41
ah i see, ure welcome:) – Mert Simsek Nov 02 '17 at 17:20

INSERT INTO pdo from web-form

..

it works in phpMyAdmin

1 Answers1