The zend-db-select tag has no wiki summary.
0
votes
0answers
20 views
Zend\Db\Sql\Sql row array
how can I create a multidimensional array? currently this query returns me this:
Array
(
[id] => 1
[name] => Samsung galaxy S4
[homepage] => 1
)
but I wish that I returned ...
0
votes
1answer
32 views
add multi tables in from() zend_db_select
i have to do a select from multi tables using zend_db_select for this sql :
SELECT t1.id,t2.ids, t3.uid
FROM table1 t1,table2 t2, table3 t3
this is the code used :
$subQuery = ...
1
vote
2answers
86 views
Zend 2.1: Is it possible to do a multiple schema join via Db>Sql>Select
I'm pretty new to Zend and having a go with Zend Select abstraction. I have hit a bit of a problem when trying to create a query which joins another table from a different schema.
The mySql query ...
0
votes
2answers
53 views
Issue with quoting of IS, NULL, NOT, !, and other reserved strings in ON conditions of JOIN clauses in Zend Framework 2
I have an SQL statement, that selets sport classes/courses (courses) with their trainers (trainers) over an association table (courses_trainers). Since some courses have multiple trainers, I use the ...
0
votes
0answers
45 views
ZF2 complex SQL where closes
How can I create complex WHERE closes in Zend\Db\Sql?
Those with "COLLATE utf_general_ci" or "REGEXP".
Also what is the way to feed it the query as a string I want?
Thank you!
-1
votes
1answer
39 views
Zend_Db magic method specific cell selection
Currently I'm working on a couple of model related improvements and looking into a specific query I've wrote.
$queryGetPages = $this->fetchAll($this->select()
...
0
votes
1answer
74 views
SetIntegrityCheck from DB Adapter in Zend
Hi there I want to use join in zend db select. I know that setintegritycheck() is importants in joins. I know how to implement it when I am having a model object like
$select = $this->select();
...
0
votes
1answer
101 views
Zend select data from multiple table
I have trouble with pulling data from two different tables. I'm attempting to first grab all the addresses with a given name (select all the addresses with the name tom in table). Then with the ...
0
votes
1answer
277 views
ZendFramework2 AbstractTableGateway getSql
I got a ZF2 project with 2 Models PosTable/TopTable which extend AbstractTableGateway.
I want to Paginate results from those Tables so i have a Pagination function in both of them.
this is what the ...
0
votes
0answers
58 views
Zend_Db select joinLeft creates wrong inner join query
I have the following code:
$db_fields = array(
"Checklists_id" => "Checklists.id",
"Checklists_title" => "Checklists.title",
"Checklists_department" => "Checklists.department",
...
1
vote
4answers
282 views
MySQL Query to a Zend DB Select
I have a MySQL standard query that I need to convert into a Zend_Db_Select but I can't get it to work.
I get this error:
Select query cannot join with another table
Here's the query:
// THE ...
0
votes
1answer
256 views
MySQL Query - Select all posts and count comments for each one
It's 3:30 AM in my country so I need to sleep but I can't without this:
I'm trying to get all posts (using Zend_Db) and count comments for each one.
Schema
blog_posts:
...
1
vote
1answer
102 views
Zend_Db nested queries where one query needs the ID from the other
I am fairly new to Zend Framework and have searched for days without finding an example for the following issue:
The result I am trying to achieve from the code below is a list that would have the ...
3
votes
1answer
289 views
How to convert normal sql query to Zend_Db_Select?
Hi I want to convert my normal mysql query to zend.db.select;
I want to use this script:
$select = $db->select();
// Add a FROM clause
$select->from( ...specify table and columns... )
// Add ...
0
votes
1answer
74 views
Zend Framework: Select the greatest number from table columns
How can I select the greatest number from table columns, exp. that is my table:
id|name|views|
1|test|42|
2|test1|89|
3|test2|4|
4|test3|35|
I need to select all values for ...
