October 7, 2008 01:57pm pdt

1. hielo 1,628,249
2. hernst42 842,715
3. Ray_Pas... 389,271
4. angelIII 336,363
5. logudotcom 334,326
6. Roonaan 312,357
7. Squinky 256,490
8. RQuadling 246,798
9. glcummins 245,535
10. ddrudik 234,574
11. routinet 229,492
12. nplib 221,264
13. bportlock 154,021
14. Xyptilon2 146,289
15. b0lsc0tt 145,465
16. yodercm 140,308
17. ali_kayahan 127,464
18. darron_c... 126,316
19. dr_dedo 124,191
20. Michael701 114,309
21. Tchuki 111,335
22. fibo 110,445
23. rowejd 107,480
24. gamebits 101,805
25. Rok-Kralj 99,594

1. hernst42 2,408,793
2. Roonaan 2,026,676
3. hielo 1,668,774
4. TeRReF 1,246,909
5. Diablo84 1,046,676
6. Squinky 953,095
7. angelIII 936,569
8. RQuadling 788,500
9. glcummins 732,448
10. steelseth12 649,023
11. snoyes_jw 589,263
12. ldbkutty 468,085
13. Batalf 452,611
14. nizsmo 437,234
15. Zyloch 433,586
16. routinet 393,304
17. yodercm 393,022
18. nicholass... 391,903
19. Ray_Pas... 391,271
20. b0lsc0tt 366,871
21. logudotcom 359,038
22. gamebits 343,571
23. MasonWolf 331,658
24. nplib 326,749
25. dr_dedo 326,740

06.19.2008 at 11:12AM PDT, ID: 23499962

	[x] Attachment Details

Proper way to create a instance of Zend_DB_Select in Zend Framework

Asked by sean-keys in PHP Scripting Language

I need some advice on the "proper" way to create a zend_db_select class. I use to have the following old code that used Db_Table_Abstract to do a fetch. I'm trying to use Db_Select so that I can create custom queries at the same time keeping things object oriented. Right now I'm getting the following error

Parse error: syntax error, unexpected T_VARIABLE, expecting T_FUNCTION in /home/sean/Zend/workspaces/psi-inv-zf/library/Fetchshortview.php on line 4

As you can tell I'm a noob with ZF, any input would be appreciated. Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:

           
           
             // OLD CODE *************************************************************************************
 
require_once 'Zend/Db/Table/Abstract.php';
 
class Items extends Zend_Db_Table_Abstract {
	/**
	 * The default table name 
	 */
	protected $_name = 't_items';
 
} 
 
public function showallAction()
    {
    	$this->view->title = "Showing All Inventory";
	     	$items = new Items();
		$this->view->items = $items->fetchAll();	
    }
 
 
// NEW CODE ***********************************************************************
 
class Fetchshortview {
	$query = $db->select();
	$query ->from('v_itemshort', array('id','nickname','serial'));
 
}
 
 public function showallAction()
    {
    	$this->view->title = "Showing All Inventory";
	    $items = new Fetchshortview();
		$this->view->items = $items->fetchAll($query);
		
    }

           
         

Keywords: Proper way to create a instance of Ze…

	Title
1	Cannot Redeclare Class error
2	How to fetch row set with JOINs in Ze…
3	SELECT statement in Zend_Framework
4	Zend_Feed_Rss failing not throwing …
5	How to get FetchAll() to return an ar…
6	Why Zend Core?

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Proper way to create a instance of Zend_DB_Select in Zend Framework

Asked by sean-keys in PHP Scripting Language

About this solution