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
1 answer

Zend_Db_Expr() doesn't execute as intended in a View in Zend Framework

I just want to do this simple task with Zend Framework: As you can see I'm trying to instantiate Zend_Db_Expr to be able to insert a date in an input…
Metafaniel
  • 29,318
  • 8
  • 40
  • 67
-1
votes
1 answer

Zend adding facebook like

how to add facebook like features in zend based application ? is the code will be placed in view or in helpers ? facebook.app_id = "APPID" facebook.app_secret = "SECRET" thanks
d3bug3r
  • 2,492
  • 3
  • 34
  • 74
-1
votes
1 answer

ZendFramework echo db values if first string = a?

I have this code at the moment to echo out all my database entries, I am wondering what it looks like in ZF to echo out the entries if the first value of the db entry is a. Code: clubs as $clubs) : ?> …
Rik89
  • 157
  • 4
  • 22
-1
votes
2 answers

Zend - populate combobox with database returned data

I try to do it this way: public function init() { /* Form Elements & Other Definitions Here ... */ $sets_table = new Optionals_Model_DbTable_Sets(); $set = new Zend_Form_Element_Select('set'); $set ->setLabel('Alegeti setul de…
-2
votes
1 answer

Store And Retrieve photos with Zend from mysql database

I am trying to store and retrieve photos from a MySql database. Can someone tell me how to do this? 1st Solution that am uisng now : I am using Zend_File_Transfer and Zend_Form_Element_File in my forms to upload files to a specified folder, saving…
Salem
  • 331
  • 1
  • 7
  • 21
-2
votes
3 answers

Zend queries returning nothing on successfully addition of row also

Is something wrong with my zend queries these are extending Zend_Db_Table_Abstract class? Update is returning zero (0) on successful update also it should be one. Adding new user is return nothing on successful insert. Please help me. /* * Adding…
vvr
  • 456
  • 3
  • 17
  • 30
-2
votes
1 answer

Internal Server Error Zend Query

Is something wrong with my query The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, @@ServerAdmin@@ and inform them of the time the error occurred, and…
vvr
  • 456
  • 3
  • 17
  • 30
-2
votes
2 answers

query was: SELECT `articles`.* FROM `articles` WHERE ()

Please I need your help ! I am creating an application that manages the articles for each page with zend framework 1. I want to display for each page its articles. public function getPagearticle(){ $db = Zend_Db_Table::getDefaultAdapter(); …
-2
votes
1 answer

Efficient and fastest way to fetch huge 50,000+ rows in Zf2

I need to fetch huge data in my code. I am using zf2, currently I am using Doctrine2 to deal with my database. But I just found that ORM queries are taking much time than plain mysql queries. So could you please suggest me the best way to fetch huge…
Deepanshu Goyal
  • 2,738
  • 3
  • 34
  • 61
-2
votes
2 answers

Why does ? not work in the LIMIT for Zend_Db

I have the following: public function getAll($limit = 100) { //if ($thread != 0) { $threadq = "WHERE threadId=$threadId"; } $query = <<
Angel.King.47
  • 7,922
  • 14
  • 60
  • 85
-3
votes
1 answer

Mysqli statement execute error : Prepared statement needs to be re-prepared

While execution of an php script, i get an error description as, Mysqli statement execute error : Prepared statement needs to be re-prepared..... The function which performs the mysql execution ( insert / update statement) is an zend function…
Abhijit
  • 1
  • 2
-4
votes
2 answers

Check next record exists in database

I am using Zend fetch method to fetch huge number of records from database for creating reports.Since fetchAll is costly as compared to fetch i am using it.And if its the last row i need to add some additinoal logic.So my question is that is there a…
웃웃웃웃웃
  • 11,829
  • 15
  • 59
  • 91
1 2 3
72
73