Noobie starting to learn OOP for databases needs help
| From: | dealTek | 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]