Noobie starting to learn OOP for databases needs help

From: Date: Sun, 16 Dec 2012 15:38:22 +0000
Subject: Noobie starting to learn OOP for databases needs help
Groups: php.general 
Request: Send a blank email to php-general+get-319899@lists.php.net to get a copy of this message
Hi all, Noobie starting to learn oop for databases from here: https://github.com/JeffreyWay/PHP-MySQL-Database-Class/blob/master/MysqlDb..php I've got lots working but have a few issues: 1 - after an insert I'd like to get the id of the new record and I'm not sure how to get that... mysql_insert_id (depricated?) or mysqli_insert_id() (I am using mySql 5.3) not sure where to add this... (most likely in MysqlDb.php but I don't know where or how...) http://de.php.net/manual/en/function.mysql-insert-id.php 2 - how does one do aggrigate select queries like "SELECT SUM(price) FROM mytable" ... what I tried seemed to fail... And if anyone can point to some good OOP training URL's I'd appreciate it. Thanks in advance for any assistance... -- Thanks, Dave - DealTek dealtek@gmail.com [db-12]

« previous php.general (#319899) next »