Assign an article in more than one category php

Question

Assign an article in more than one category php

Navigation

#1 by (0 votes)

0

I have to insert a database in the database assigned to more than one category, how could I do this? In case it would appear the category options available in my bank and I would select them with a checkbox

php mysql html

asked by anonymous 07.07.2016 / 19:10

1 answer

Send bit to specific parallel port pins with php Developer account [closed]

score 0 · Accepted Answer

In this case your tables in the database should have more or less these structures:

|--------artigo----------|  
|id - titulo - nome - etc|  
|------------------------|  

|---categoria---|  
|id - nome - etc|  
|---------------|  

|-------artigo_categoria------|  
|id - id_artigo - id_categoria|  
|-----------------------------|

This gives you an article that has more than one category. When doing select just use a inner join to associate.

select * from artigo
inner join artigo_categoria on (artigo.id = artigo_categoria.id_artigo)
inner join categoria on (artigo_categoria.id_categoria = categoria.id)