How to filter by categories in php?

Question

Good afternoon guys, I’m new in web programming and I’m making an online schedule where a student registers a test or work that will and then (through CRUD) the site shows the evidence and registered works. However, I’m having trouble making a category screen. In my database have the following fields: id_evaluacao, disciplina_avaliacao, materia_avaliacao, professor_avaliacao, categoria_avaliacao e nota_avaliacao. I would like to have a menu on the page categories.php and in the menu have the category fields: arts, matematica, Portuguese etc... and when the user clicks on some field, the site shows the proofs of the selected category.

Answer 1

I’ll try to give you a starting point.

Send the category name using the method _GET, from there you can use the code below as a base.

Remembering, this will only take the name of the category and make the call of what is inside this field. As you have disciplina_avaliacao and materia_avaliacao, I have decided for one of the two, however, can make use of the field that is necessary.

<?php
//Primeiro deverá pegar o nome da categoria através do $_GET, aqui, irei definir que o GET já possui um valor fixo pra poder continuar.
$_GET['cat'] = "matematica";

$categoria = $_GET['cat'];

$query = "SELECT * FROM categoria WHERE disciplina_avaliacao = " . $categoria . ";

//Montar a estrutura desejada abaixo

?>

This is what you need?

I hope I’ve helped.