Codeigniter: Pano po mag insert ng Array value sa database?

[jade10115]

Codeigniter: E-Library
Mga lods Yung input tag ko naka array po naka array po sya ksi po mnsan dalawa ang author ng isang libro. nkaka insert naman po sya ginamitan ko po ng implode. pero sa database yung dalawang author nasa iisang column lang.

 

[fazz12]

wala namang problema kung nasa iisang column or should i say row/record.

kung problema mo kung pano ireretrieve yan tapos magiging individual sila ulit dapat, pwede mong gamitin yung split para bumalik sila into array, or yung uso nowadays, into list (generics) lol. itake advantage mo yung comma para isplit yung bawat element.

pero kung halimbawa iisang item pero may comma in between, like "sycip, gorrez and velayo" gamit ka na lang siguro ng different approach
example is yung nasa different record sila ng iisang table, tapos connected na lang sila via common id.

halimbawa:

sa tbl_authors instead na may author_name ka na column gawin mo na lang gawa ka ng table na author_names.
tapos sa table na author_names, gawin mong foreign key yung author_id ng tbl_authors table, tapos author_name na column.
parang magiging ganito sila

author_names table

author_id	author_name
1	sycip
1	gorrez
1	velayo
2	gil nonato santos
2	jorge p ocampo

 

[jade10115]

wala namang problema kung nasa iisang column or should i say row/record.

kung problema mo kung pano ireretrieve yan tapos magiging individual sila ulit dapat, pwede mong gamitin yung split para bumalik sila into array, or yung uso nowadays, into list (generics) lol. itake advantage mo yung comma para isplit yung bawat element.

pero kung halimbawa iisang item pero may comma in between, like "sycip, gorrez and velayo" gamit ka na lang siguro ng different approach
example is yung nasa different record sila ng iisang table, tapos connected na lang sila via common id.

halimbawa:

sa tbl_authors instead na may author_name ka na column gawin mo na lang gawa ka ng table na author_names.
tapos sa table na author_names, gawin mong foreign key yung author_id ng tbl_authors table, tapos author_name na column.
parang magiging ganito sila

author_names table

author_id	author_name
1	sycip
1	gorrez
1	velayo
2	gil nonato santos
2	jorge p ocampo

cge2x boss try ko po gawn yan. isip lang po ako kung pano

 

[jz3n]

you can do string manipulation with the use of split, replace, etc
BUT actually you can use JSON format into your database

 

[technologica]

for loop mo yung implode