d($x); $q = 'REPLACE tblSessionData (session_id,session_data,expires) VALUES(?, ?, ?)'; $xxx = Sql::pUpdate($q, 'sss', 666, "hejhej", sql_datetime( time() ) ); d($xxx); $q = 'INSERT INTO tblLikes (owner,type) VALUES (?, ?)'; $id = Sql::pInsert($q, 'ii', 4,9); if ($id < 2) echo "FAIL 5\n"; $w = new Word(); $w->id = 8; $w->value = "sten"; if (SqlObject::exists($w, 'oWord') != true) echo "FAIL 10\n"; $w = new Word(); $w->id = 8; $w->value = "st2en"; if (SqlObject::exists($w, 'oWord') == true) echo "FAIL 11\n"; */ // TODO more reliable test of ListToObjects $q = 'SELECT * FROM tblBookmarks' . ' WHERE owner = ? AND type = ?'; $list = Sql::pSelect($q, 'ii', 2, 100); $objs = SqlObject::ListToObjects($list, 'Bookmark'); if (count($objs) < 5) { echo "FAIL 20\n"; } $q = 'SELECT * FROM tblBookmarks' . ' WHERE id = ?'; $row = Sql::pSelectRow($q, 'i', 66); $obj = SqlObject::RowToObject($row, 'Bookmark'); if ($obj->id != 66) { echo "FAIL 30\n"; } $bb = Bookmark::get(66); d($bb);