all users

Previous topic

Developer

Next topic

Author	Message
Mazen Alsibai	Tuesday 08 November 2005 7:11:13 am Hi: how can i fetch all users registered in my database? thanks
Łukasz Serwatka	Wednesday 09 November 2005 11:30:38 pm You can do tree fetch from User accounts fetch(content,tree ...) http://ez.no/doc/ez_publish/technical_manual/3_6/reference/modules/content/fetch_functions/tree But this will be inefficient if you have e.g 15000 users. All users are in ezuser table, so with one simple SQL query you can fetch data and via custom operator return array then display data using {section} or {foreach} http://ez.no/products/ez_publish_cms/documentation/development/extensions/template_operator Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog

Author

Message

Mazen Alsibai

Tuesday 08 November 2005 7:11:13 am

Hi:
how can i fetch all users registered in my database?
thanks

Łukasz Serwatka

Wednesday 09 November 2005 11:30:38 pm

You can do tree fetch from User accounts

fetch(content,tree ...)

http://ez.no/doc/ez_publish/technical_manual/3_6/reference/modules/content/fetch_functions/tree

But this will be inefficient if you have e.g 15000 users.

All users are in ezuser table, so with one simple SQL query you can fetch data and via custom operator return array then display data using {section} or {foreach}

http://ez.no/products/ez_publish_cms/documentation/development/extensions/template_operator

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

eZ debug

Timing:	Jan 31 2025 04:29:12
Script start
Timing:	Jan 31 2025 04:29:12
Module start 'layout'
Timing:	Jan 31 2025 04:29:12
Module start 'content'
Timing:	Jan 31 2025 04:29:12
Module end 'content'
Timing:	Jan 31 2025 04:29:12
Script end

Main resources:

Total runtime	0.0150 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	588.0078	151.1953
Module start 'layout'	0.0052	0.0024	739.2031	36.6016
Module start 'content'	0.0076	0.0059	775.8047	90.2344
Module end 'content'	0.0135	0.0015	866.0391	29.9922
Script end	0.0150		896.0313

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0023	15.2720	14	0.0002
Check MTime	0.0010	6.9227	14	0.0001
Mysql Total
Database connection	0.0007	4.7910	1	0.0007
Mysqli_queries	0.0025	16.9510	3	0.0008
Looping result	0.0000	0.0937	1	0.0000
Template Total	0.0011	7.1	1	0.0011
Template load	0.0008	5.4692	1	0.0008
Template processing	0.0002	1.4185	1	0.0002
Override
Cache load	0.0006	3.8315	1	0.0006
General
dbfile	0.0019	12.5762	8	0.0002
String conversion	0.0000	0.0397	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs