Stack Overflow
Stack Overflow

Questions tagged [zend-db]

Database access component for the Zend Framework.

for PHP 5 includes a database access component, referred to as Zend\Db.

The Zend\Db component includes features such as:

  • Database connection factory class.
  • Adapter for multiple brands of database, closely matching the interface, and also supporting other non-PDO database interfaces such as mysqli and oci.
  • Simple query builder for generic SELECT syntax.
  • statement profiler and logger.
  • Table Data Gateway and Row Data Gateway classes. Together these are similar to the popular Active Record pattern.

Resources:

  1. Github repository
1092 questions
-1
votes
0 answers

Zend_Db_Select won't allow column values from joined tables

I am having a problem getting Zend_Db_Select to give me column values from joined tables. For example, this join works: $select->from(array('a' => 'files'), array('fil_last_name','fil_first_name','fil_middle_name')) …
tjb1982
  • 2,257
  • 2
  • 26
  • 39
-1
votes
1 answer

how to use IN-function within Zend_Select

I different string values komma separated out of a form. In the code I cast them and then it looks like this: $kritkeyword ='test, abc, xyz'; Now I want to use the variable within an IN-function. In original sql ist would be: where keyword IN…
pia-sophie
  • 505
  • 4
  • 21
-1
votes
1 answer

Tablegateway "insert" gets executed but no values are written into table

Environment: Docker container, where PHPand MySQL runs in seperated containers I have a table "persons" and want to insert values using TableGateway. The code gets executed and I can catch the last inserted value. It's an autoincrement and every…
hmartini
  • 139
  • 1
  • 6
-1
votes
1 answer

ZF3 unable to populate select field from db

Can anyone explain me the easiest way to populate select field in form from db? ChartsForm.php 

        

            

                
                 
                
                 
                
                 
                
                 
                
            

            

                
                    


    
    
        
    
    

        ajazsiddiqui
        
    
            
  • 29
    • 
            
            
            
  • 7
    •
-1
votes
1 answer

Automatch DB columns with Zend_DB ResultSet (ZF2)

In my "Module.php" i have this code in getServiceConfig() 'FoobarTableGateway' => function ($sm) { $dbAdapter = $sm->get('dbfoobar'); $resultSetPrototype = new ResultSet(); …
Paladin
  • 1,637
  • 13
  • 28
-1
votes
2 answers

Magento 1.9.0.1: There has been an error processing your request: dbModel read resource does not implement Zend_Db_Adapter_Abstract

I need some help please.. how can i solve this error in magento There has been an error processing your request dbModel read resource does not implement Zend_Db_Adapter_Abstract
xXxrk04
  • 185
  • 2
  • 4
  • 12
-1
votes
4 answers

Page not found on request url in zend 2 framework application

I am newbie to zend framework and i am trying to configure the zend. I was sucessfully installed zendskeleton applicaion on window 7 and XAMPP After installation I am creating new module Album as per define in user guide. I was make all code and…
Anshul Parashar
  • 3,096
  • 4
  • 30
  • 56
-1
votes
1 answer

zend-framework navigation

i have this xml file for Creating a container , if i want create a db for save this items and and create container from db how should i do ?
ulduz114
  • 1,150
  • 6
  • 21
  • 37
-1
votes
1 answer

calling stored procedure using output parameter which is ref cursor by zend framework 1

I have the following oracle procedure: TYPE VarRecCur IS RECORD ( CustomerId Customer.CustomerId%TYPE, Name Customer.Name%TYPE ); TYPE VarCursor_CUSTOMER IS REF CURSOR RETURN VarRecCur; PROCEDURE…
user3637971
  • 313
  • 5
  • 21
-1
votes
1 answer

How i can realize the next mysql query on zend?

SELECT * FROM ( SELECT `* FROM `messages` ORDER BY `message_id` DESC LIMIT 15 ) AS temp ORDER BY message_id ASC
Isabek Tashiev
  • 1,036
  • 1
  • 8
  • 14
-1
votes
2 answers

Zend Framework2 how to make Concat and Left Join

Does not work: $sql = new Sql($this->adapter); $select = $sql->select(); $select->from('request') ->columns(array('*', new Expression("CONCAT(up1.value,' ',up2.value) as display_name"))) ->join(array('up1'=>'user_profile'),…
Mikhail Kiselev
  • 1
  • 3
-1
votes
3 answers

Mysql/sql/zend query with one select?

Well so I got a tiny problem, I got a db and 2 tables like this Table User user_id Table UserrToData user_id int pk data_id int Table UserData data_id name nick I got the user_id and i need to get records from the userdata , is it possible using…
Gosu Przmak
  • 172
  • 9
-1
votes
1 answer

Where condition in ZF2 using Anonymous function

As the official documentation say I'm using an anonymous PHP function in my ZF2 model (Zend\Db\TableGateway) use Zend\Db\TableGateway\TableGateway; use Zend\Db\Sql\Select; $artistTable = new TableGateway('artist', $adapter); // search for at…
Dionysos
  • 303
  • 1
  • 3
  • 15
-1
votes
1 answer

Zend like with or condition

I got sql question with where condition: $select->where('(users.user_fname LIKE (?) )','%'.$first.'%'); How to put in it OR condition so it would look like: $select->where('(users.user_fname LIKE (?)…
ariel
  • 379
  • 4
  • 11
-1
votes
2 answers

php isset() is not working

At first I posted my code: //if ($filterResults['id']) { if (isset($filterResults['id'])){ $select = $this->select(); $select->where('id = ?', $filterResults['id']); $this->fetchAll($select); } Now, the…
user1559230
  • 2,790
  • 5
  • 26
  • 32
1 2 3
…
72
73