Error on inserting a new data

Question

Error on inserting a new data

artonico May '15

Created May '15	Last Reply May '15	Replies 2	Views 595	Votes 0

artonico 6.6k

May '15

Hello, i have a quite weird error when doing a data insertion. The error is only occured on this section, when i do insert in other functions, it works fine.

Here's the bugged function:

public function checkoutAction(){
        $cartID = $this->request->getQuery("id");

        $mHTrans = new htransaction();
        $sql2 = "INSERT INTO htransaction (cartID) VALUES ('$cartID')";
        $mHTrans->getModelsManager()->executeQuery($sql2);
}

This will result in Notice: Cannot use a scalar value as an array in phalcon/mvc/model/query.zep on line 1823 in (my file) on line 119 Unknown expression error.

Meanwhile, when i change the sql into INSERT INTO htransaction (cartID, financeStatus) VALUES ('$cartID', 'unconfirmed'), the error becomes Fatal error: Wrong parameters for Exception([string $exception [, long $code [, Exception $previous = NULL]]]) in (my file) on line 119

Here's the htransaction Model :

class htransaction extends Model{

    public $hTransID;
    public $cartID;
    public $adminID;
    public $dateAdded;
    public $financeStatus;

    public function initialize(){
        $this->belongsTo("cartID", "cart", "cartID");
        $this->belongsTo("adminID", "admin", "adminID");
    }
}

Thanks in advance :D

Thien Tran · Answer 1 · 2015-05-18T09:13:17-07:00

Refer to https://docs.phalcon.io/en/latest/reference/phql.html#inserting-data or tried

        $sql2 = "INSERT INTO htransaction (cartID) VALUES ('" . $cartID . " ')";

artonico · Answer 2 · 2015-05-18T09:17:58-07:00

Refer to https://docs.phalcon.io/en/latest/reference/phql.html#inserting-data or tried
       $sql2 = "INSERT INTO htransaction (cartID) VALUES ('" . $cartID . " ')";

Nope, it doesn't work. Still giving the same error. I have try using placeholders but to no avail also.

Andres Gutierrez · Answer 3 · 2015-05-18T09:20:23-07:00

Does this work?

public function checkoutAction(){
        $cartID = $this->request->getQuery("id");

        $mHTrans = new htransaction();
        $sql2 = "INSERT INTO htransaction (cartID) VALUES (?0)";
        $mHTrans->getModelsManager()->executeQuery($sql2, [$cartID]);
}

artonico · Answer 4 · 2015-05-18T09:22:41-07:00

Does this work?

public function checkoutAction(){
       $cartID = $this->request->getQuery("id");

       $mHTrans = new htransaction();
       $sql2 = "INSERT INTO htransaction (cartID) VALUES (?0)";
       $mHTrans->getModelsManager()->executeQuery($sql2, [$cartID]);
}

Sadly also no :x