include_once 'include/class.books.php'; /* make asoociative array for testing */ $insert_data = array("isbn" => "278914", "up_date" => "2016-02-06 18:07:57", "title" => "C How to Program", "author" => "Paul Dietel & Harvey", "publisher" => "", "p_year" => "2016-02-06 18:07:57", "edition" => "7", "lang" => "English", "category" => "programming", "tags" => "c how to program", "pages" => "10", "rating" => "", "comment" => "", "count" => "0"); $books = new Books(); echo "<h1>Successfully Created Connection</h1>"; $books->add_records($insert_data); $isbn = "\t9780132990448"; $books->update_edition($isbn, 7); $books->delete_record($isbn); $books->bookExist(3); $books->getAuthorName(278); $books->authorsList(); $books->booksList(); $books->getBooksCount(); $authorName = "Paul Dietel & Harvey"; $books->books_by_author($authorName); $categoryName = "programming"; $books->books_by_category($categoryName); $p_year = "2016-02-07 00:02:19"; $books->books_by_p_year($p_year); $books->books_sortby_up_date(); $books->books_sortby_p_year(); $books->books_sortby_title(); $books->books_by_rating(4); $publisher = "MISSING MANUAL"; $books->books_by_publisher($publisher); $books->books_by_lang("english"); $books->parse_tags("english;hindi;janju;kamina"); $books->update_tags($isbn, "test1;test2;test3");