PHP Zend Executing a raw SQL statement from controller action

Question

I'm looking to see if it's possible to execute a raw SQL statement from a PHP controller action. Currently, I'm trying to execute a block of code that I build within the controller action to insert values into a table within my database...

$sql = "BEGIN INSERT INTO HOSTS VALUES('1', 'hostname1'); INSERT INTO HOSTS VALUES('2', 'hostname2'); END;";
$db->exec($sql);

Is something similar to the above code possible to be handled within a controller/action, or do I need to pursue a different route? Thank you in advance.

msleone · Accepted Answer · 2023-04-27 15:20:18Z

1

I figured out you can reference your DB credentials within the application.ini file and execute the SQL statement using said credentials. This can be done within the controller page of your code.

$sql = "BEGIN INSERT INTO HOSTS VALUES('1', 'hostname1'); INSERT INTO HOSTS VALUES('2', 'hostname2'); END;";
$stmt = Zend_Registry::get('DBNAME')->prepare($sql);
$stmt->execute();

edited Apr 27, 2023 at 15:20

answered Aug 8, 2017 at 17:55

msleone

2272 gold badges6 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

PHP Zend Executing a raw SQL statement from controller action

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related