The zend-db-table tag has no wiki summary.
0
votes
0answers
17 views
Why Zend framework Db Table put an asterisk before the table name on my query?
I have a problem with a query like this:
$sSqlAux = $this->select()->setIntegrityCheck(false)
->from(array("a_aux" => $this->_name), "id_a", $this->_schema)
...
0
votes
1answer
18 views
zf2 How to var_dump the result of select
I am trying to var_dump the result (only database rows) of select query.
I have a simple TableGateway (facotry service_manager)
public function shwoContactFormMessages)
{
$select = new Select();
...
0
votes
1answer
24 views
Zend Framework 2 Form With Password
I'm using zend framework 2, how can I force the user has set a password of 8 characters min, but both letters and numbers?
This is my code:
$this->add(array(
'name' => 'password',
...
1
vote
2answers
29 views
how to export a mysql db table data to a spreadsheet and then send it to the browser?
I need to export a table named 'app_users' from my database, into a spreadsheet, a csv for example. How do I do this? Also, how do I send this file to browser? I am using Zend framework.
0
votes
1answer
20 views
zf many to many relationship, how to find values stored in intermediary table without a second lookup
I have a many to many relationship between two tables which is represented with an intermediary table. I am using the ZF1 table relationships methodology to model the database in my application and ...
0
votes
1answer
32 views
Zend_Framework 1.12 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax
Before anything I am aware of the multiple questions asked concerning this exception. I have looked through them but have not found an answer for my particular problem. Most of the questions use the ...
-1
votes
0answers
21 views
Application Error When inserting data in Zend Framework
When I tried to insert dta in my mysql table, its showing me APPLICATION ERROR.
Can someone please help me out in this??
Model
public function add($array){
$chip=new ...
0
votes
0answers
21 views
zend db table Model Ondelete Restrict doesn't work
I have two table and use this method in model to delete row but if row has child this method delete the row ! I set this in the model:
'onDelete' => self::RESTRICT,
'onUpdate' => ...
1
vote
1answer
13 views
Zend default adapter not available when using just config
I'm using application.ini to bootstrap DB settings and adapter in Zend 1.12
resources.db.adapter = "PDO_MYSQL"
resources.db.params.host = "server"
resources.db.params.port = "3310"
...
0
votes
2answers
60 views
Zend Db Sql Where
Hi how can I do a query like this in zf2 with zend\db\sql?
Query:
SELECT * FROM table WHERE field = $field AND data > SUBDATE(NOW(), INTERVAL 1 DAY)
In ZF2
$select = ...
0
votes
1answer
33 views
Zend_Db_Table_Row_Exception
I have this query below which I am trying to port to Zend (even further below lol). I am getting this error:
Uncaught exception 'Zend_Db_Table_Row_Exception' with message
'Specified column ...
0
votes
2answers
61 views
Zend:Fetching Data from Multiple tables
Please find my code below
module.php
public function getServiceConfig()
{
return array(
'factories' => array(
'Shopping\Model\ShopTable' => function($sm) {
$tableGateway = ...
0
votes
1answer
51 views
Zend Framework 2: Getting an ordered SQL call
I've been trying to get an order ASC/DESC call for a field (let's say craeted), and I can't seem to figure out how to do it in ZF2.
Where am I going wrong..?
namespace Todo\Model;
class TodoTable ...
0
votes
2answers
59 views
How to get table foreign keys in Zend Framework?
I can get table columns with information about columns types by writting:
$table = new Zend_Db_Table('schema.table_name');
$info = $table->info();
There is information about Primary key, but ...
1
vote
1answer
27 views
how to create a Zend_Db_Table_Select through a string query php
I have been taking a look, for if there any way to create a Zend_Db_Table_Select or Zend_Db_Select instance with a literal sql query. I mean, I've got a complex query and I want through this query ...
