I have two tables:
tbl_author: authorId, name
tbl_book: bookId, authorId, title
What I want is to create php-based system, which is able to:
I can surely on it using raw php, but it'll take a week. Tried to use Yii, but it still lacks components required for auto-complete.
On the other hand this is doable in no time in MS Access starting from 1998. So I think, is there php-world solution (I mean tool or framework), to quickly create such a simple CRUD systems?
The above is just a matter of table relations and yii do support such things. I am giving my answer based on Yii1.
** A) functionallity to add/edit/delete authors/books;**
Use Yii , GII creation tool to get started
B) show authors, books in a grid; support filtering & pagination;
Step 1: create a relation in Author model to say Author has many Books
Step 2: Create a relation for Book to say Book has One Author
Step 3: Use CActiveDataProvider so that it handles pagination. Here you can use the model Book:
$dataProvider=new CActiveDataProvider('Book', array(
'criteria'=>array(
'with'=>array('author'),
),
'pagination'=>array(
'pageSize'=>20,
),
));
It will return all the books linked with authors. Of coz , with the data you can display as you want. There is such a thing called CGridView.
Step 4: As for searching, you can refer here
C) support autocomplete for when entering a new book, so it helps to fill an author.
This is the matter of jquery and search.