Egw_db FETCH_ASSOC

[Nathan_Gray-2]

To be clear about these (r25021) changes:

Old: ($db is clone of $GLOBALS[‘egw’]->db)

$db->select(‘table’, array(’*’), array(), LINE,FILE,…);
$list = array();
while($row = $db->row(true)) {
$row[‘date’] = $db->from_timestamp($row[‘date’]);
$list[] = $row;
}
return $list;

New: ($db is $GLOBALS[‘egw’]->db)

$list = $db->select(‘table’, array(’*’), array(), LINE,
FILE, …);
foreach($list as &$row) {
$row[‘date’] = $db->from_timestamp($row[‘date’]);
}
return $list;

How long do you think I should wait before starting to use the new way?

Nathan Gray
nathan at goarctic dot com

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Ralf_Becker_6]

Hi Nathan,

you can start using it NOW

My plans to replace the regular db access with PDO, will still allow to
use that syntax.

Please remember you need to specify the application ($app param of
select), if it’s not the api AND you can’t do
$GLOBALS[‘egw’]->db->set_app(‘myapp’) as that will break the api.

Ralf

Nathan Gray schrieb:

To be clear about these (r25021) changes:

Old: ($db is clone of $GLOBALS[‘egw’]->db)

$db->select(‘table’, array(’*’), array(), LINE,FILE,…);
$list = array();
while($row = $db->row(true)) {
$row[‘date’] = $db->from_timestamp($row[‘date’]);
$list[] = $row;
}
return $list;

New: ($db is $GLOBALS[‘egw’]->db)

$list = $db->select(‘table’, array(’*’), array(), LINE,
FILE, …);
foreach($list as &$row) {
$row[‘date’] = $db->from_timestamp($row[‘date’]);
}
return $list;

How long do you think I should wait before starting to use the new way?

Nathan Gray
nathan at goarctic dot com

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[Nathan_Gray-2]

I think this is also worth mentioning here:

$query[‘total’] = $this->db->query($sql='SELECT count(id) AS count ’ .
$sql_query,LINE,FILE)->NumRows();

instead of something like:
$this->db->query($sql . $sql_query, LINE, FILE);
if($row = $this->db->row(true)) {
$query[‘total’] = $row[‘count’];
}

Nathan Gray
nathan at goarctic dot com

---

Extra punctuation??? Ug!!!
Just say no! Punctuation marks do not gain significance if you
increase their number, they make you look silly. One is sufficient.

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers