Using the database - examples?
Permalink
Hello all,
I just created my first "block" and have it installing and creating its table in the database. I have also created a blank page that exists in the dashboard for the purpose up updating the data that this block will display. So far, the block seems to work, I've added it to a page, and displayed some static content.
I have some questions and cant find any examples of how to use the database with c5 from within a block or from within the dashboard.
First, the bID field in the table created is not an auto-increment field. When I add records to this table, do I need to increment this, how does that work?
Second, are there any tutorials or examples of developing complex blocks with database inserts, deletes, updates etc?
And last, when your block creates a table in the database, is this searchable with the C5 search?
Thanks for any pointers or direction you can give me, I've been digging through the site and api and what docs I can find and have been limping along slowly.
Cheers,
Joe
Any takers :)?
I just created my first "block" and have it installing and creating its table in the database. I have also created a blank page that exists in the dashboard for the purpose up updating the data that this block will display. So far, the block seems to work, I've added it to a page, and displayed some static content.
I have some questions and cant find any examples of how to use the database with c5 from within a block or from within the dashboard.
First, the bID field in the table created is not an auto-increment field. When I add records to this table, do I need to increment this, how does that work?
Second, are there any tutorials or examples of developing complex blocks with database inserts, deletes, updates etc?
And last, when your block creates a table in the database, is this searchable with the C5 search?
Thanks for any pointers or direction you can give me, I've been digging through the site and api and what docs I can find and have been limping along slowly.
Cheers,
Joe
Any takers :)?