Mysql delete query using zend

Question

i'm developing an application where there is a function (correctly called) that receive an id an should delete records from a table where the id is present.

This is my code:

public function deleteAction($id) {
        if ($id) {
            $where[] = $this->_db->quoteInto('transazione = ?', $id);
            $this->_db->delete($this->_name, $where);   
        }
    }

The function is correctly called but i receive this error:

An error occurred

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 ')' at line 1

How can i solve this?

bxN5 · Accepted Answer · 2017-03-30 07:48:45Z

1

try

   $n = $this->_db->delete('tablename', "column_id = $id");
        /*or*/ 
   $q = $this->_db->quoteInto('DELETE * FROM bugs WHERE reported_by = ?', $id);
   $this->_db->query($q);

edited Mar 30, 2017 at 7:48

answered Mar 30, 2017 at 7:41

bxN5

1,4302 gold badges16 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Edoardo Over a year ago

i've used the second option and it works... Thank's a lot

Collectives™ on Stack Overflow

Mysql delete query using zend

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related