zend-db Questions
1
When I run zend framework project from browser, everything is OK, it connects to DB.
When I run project from command line it can't connect to DB and it throws an error:
Fatal error: Uncaught ex...
Wersh asked 7/12, 2011 at 11:25
3
I am using this to retrieve the database connection atm.
$db = Zend_Db_Table::getDefaultAdapter();
I do set this up in my config like this:
resources.db.adapter = pdo_mysql
resources.db.isDefa...
Geostrophic asked 13/11, 2011 at 21:42
2
Solved
I'm using Doctrine 2 in a Zend Framework application and require functionality similar to Zend_Validate_Db_RecordExists and Zend_Validate_Db_NoRecordExists.
For example, when a user enters a new i...
Polybasite asked 31/10, 2011 at 8:45
2
Solved
I try to find how to translate the following MySQL query into Zend Db Table Select:
SELECT ColA,ColB,ColC
FROM MyTable
FORCE INDEX(ColA,ColB)
WHERE ColA = 'val0002'
AND ColB = 'val0045'
i try to...
Hawkie asked 16/9, 2011 at 9:27
4
Solved
I have been working over an year with Magento and have learned it good enough. Now I want to learn Zend, and I'm stuck with models.
I'm used to have entities and collection of entities in Magento,...
Rile asked 19/8, 2011 at 16:30
1
Solved
I have a complex database design with views, relationship etc. We decided to switch to ORM from the standard Zend_db. I successfully integrated zend 1.11 and doctrine 2.1. All the tutorials out the...
Tansey asked 28/7, 2011 at 19:48
1
Single DB connection (resource configuration) from application.ini:
resources.db.adapter = "pdo_mysql"
resources.db.params.host = "mysql1"
resources.db.params.username = "dbuser"
resources.db.par...
Agro asked 22/7, 2011 at 18:43
3
Solved
How would you write the following query in Zend framework?
SELECT * FROM table_name ORDER BY FIELD(field_name, 'Small','Medium','Large');
I just need the "Order by" part :)
Thanks!
Goodsized asked 7/7, 2011 at 14:15
2
Solved
I'm using a concrete implementation of Zend_Db_Table_Abstract:
class DB_TestClass extends Zend_Db_Table_Abstract {
protected $_name = "test.TestData";
}
If I want select all rows in the table, ...
Fogged asked 24/6, 2011 at 10:45
1
Solved
I have two tables with related data, and I want to select all the records from one table which do not exist in the other table, plus some other criteria on the related table, as follows (123 is jus...
Cookshop asked 21/3, 2011 at 16:30
2
Solved
Possible Duplicate:
How do I add more than one row with Zend_Db?
i would like to build this query
INSERT INTO ad-page (ad_name, page_name) VALUES ('value1', 'value2'), ('value3', 'va...
Lennyleno asked 26/1, 2011 at 8:53
2
Solved
I'm using Zend_DB and trying to change the charset to utf8, here is the code:
config.ini :
[development]
db.host = "localhost"
db.username = "root"
db.password = "toor"
db.dbname = "db_whoopdiedo...
Teaser asked 16/11, 2010 at 9:31
9
Solved
I am looking to register a reference to the main Database Adapter in the Registry during Bootstrapping so it can be used elsewhere in my site (specifically the Authorisation action).
I have impleme...
Ampere asked 28/5, 2009 at 14:6
1
I use Zend_Db in some project, I discover Doctrine there is a while but never actually used it.
What are the advantage of Doctrine over Zend_Db ? What are the benefits to use Doctrine ?
By the wa...
Arsenical asked 14/8, 2010 at 11:13
3
Solved
I have a table full of "title" that I want to order by title. Problem is a lot of them have a empty space before the title. I am thinking of writting a php script to fix it all (super easy) but I w...
Woebegone asked 13/8, 2010 at 20:4
1
Solved
I have a class that extends Zend_Db_Table lets call it 'Users' that uses the class 'User' (inheriting from Zend_Db_Table_Row_Abstract) as its rowClass. I need it this way because User has additiona...
Mi asked 15/7, 2010 at 12:25
1
Solved
I'm trying to do a group by using Zend framework. Here's my code:
$table = new TableClass();
$select = $table->select();
$select->from ("table", array("date", "column1" => "sum(column1)")...
Ponton asked 19/6, 2010 at 4:2
1
Solved
I wonder if this possible with Zend_Db, but I am looking for something like SQL query logging similar to how Hibernate does it, where it shows you what SQL it generates in the log file.
Shamekashameless asked 24/5, 2010 at 0:14
1
Solved
I am using the fluent interface to create a Zend DB Select object/query. As part of the query, I would like to select an arbitrary string, like "SELECT 'foo' AS 'type' FROM ...". foo is not a colum...
Fransen asked 3/5, 2010 at 23:18
5
Solved
Given my generic select below, is there a way to get the number of records returned from a query with Zend Framework? $row++ in a loop is not acceptable for my solution as I am using paging (though...
Ries asked 11/6, 2009 at 20:18
2
Solved
It doesn't look like there's any parameter substitution in Zend_Db_Select's on clause.
It's highly annoying that I can't just do something like:
$select->joinLeft('st_line_item','st_line_item....
Hospitalet asked 2/2, 2010 at 1:22
2
Solved
It seems like there's a few different ways to join two tables using the Zend Framework, but I've never done it before so I don't know which is the best way to do it.
This is what I'm trying to do....
Decalogue asked 23/11, 2009 at 21:21
1
Solved
I have the following code:
public function checkLoginDetails($email, $password) {
$select = $this->select ();
$select->where ( "password=?", md5($password) );
$select->where ( "email=?...
Colunga asked 9/12, 2009 at 19:1
3
Solved
I am using Zend Framework with MySQL,Apache and Ubuntu 9.04.
I am trying to insert NULL values into database like this:
$personObj->setPersonId( '1' );
$personObj->setPersonEmail('NULL');
$...
Bailar asked 13/11, 2009 at 6:16
1
Solved
I am trying to use the Zend Framework without using the MVC structure, specifically the Db_Table classes.
I have created a couple of classes representing my database tables, i.e.
class DBTables_T...
Stormproof asked 6/10, 2009 at 16:27
© 2022 - 2024 — McMap. All rights reserved.