I want to show more queries within my html page but it only shows a single object. I do not know how to add more
This is in mysql, html, django1.11 and python 2.7.15
views.py
JavaScript
x
9
1
def administrador(request):
2
alumno = Alumnos.objects.get(pk=1)
3
context = { 'alumno': alumno }
4
mapa = mapas.objects.get(pk=4)
5
context2 = { 'mapa' : mapa}
6
competencias = Competencias.objects.get(pk=1)
7
context3 = { 'competencias' : competencias}
8
return render(request, 'competencias_app/competencias.html',context)
9
JavaScript
1
53
53
1
<form action="/competencia" method="POST">
2
{% csrf_token %}
3
4
<div class="container-alumnos">
5
<div>
6
<select id="carrera" name="Carrera">
7
<option value="1">TICS</option>
8
<option value="2">Carrera</option>
9
<option value="3">Carrera</option>
10
<option value="4">Carrera</option>
11
<option value="5">Carrera</option>
12
</select>
13
</div>
14
15
<div>
16
<select id="Alumno" name="Nombre">
17
<option value="{{alumno.idAlumnos}}">{{alumno.nombre}}</option>
18
</select>
19
</div>
20
<form action="">
21
<label for="ID">ID</label>
22
<input type="input" name="id" disabled value="{{alumno.idAlumnos}}"><br>
23
<label for="apellidos">Apellidos</label>
24
<input type="input" name="apellidos" disabled value="{{alumno.apellidos}}"><br>
25
<label for="Correo">Correo</label>
26
<input type="input" name="Correo" disabled value="{{alumno.correo}}"><br>
27
</form>
28
29
</div>
30
31
<select id="opciones" name="Semana">
32
<option value="1">Semana 1</option>
33
<option value="2">Semana 2</option>
34
<option value="3">Semana 3</option>
35
<option value="4">Semana 4</option>
36
<option value="5">Semana 5</option>
37
</select>
38
<div class="container-listas">
39
40
<select name="OS" size=9>
41
<option selected value="0"> Elige una opción </option>
42
<optgroup label="{{mapa.nombre}}">
43
<option value="1">{{competencias.nombre}}</option>
44
<option value="2">Nombre Competencia</option>
45
<option value="3">Nombre Competencia</option>
46
</optgroup>
47
<optgroup label="Mapa - Nombre">
48
<option value="10">Nombre Competencia</option>
49
<option value="11">Nombre Competencia</option>
50
<option value="12">Nombre Competencia</option>
51
</optgroup>
52
</select>
53
i need add object mapa and competencias. The object alumno i dont have problem
Advertisement
Answer
User filter
instead of get
. Because, get
returns a single object, but filter
returns all matching objects.
JavaScript
1
11
11
1
def administrador(request):
2
alumno = Alumnos.objects.filter(pk=1)
3
mapa = mapas.objects.filter(pk=4)
4
competencias = Competencias.objects.filter(pk=1)
5
context = {
6
'alumno': alumno,
7
'mapa': mapa,
8
'competencias': competencias
9
}
10
return render(request, 'competencias_app/competencias.html', context)
11
In your template
For Alumnao
,
JavaScript
1
6
1
<select id="alumno" name="alumno">
2
{% for item in alumno %}
3
<option value="{{item.id}}">{{item.your_desired_field}}</option>
4
{% endfor %}
5
</select>
6
For mapa
,
JavaScript
1
6
1
<select id="mapa" name="mapa">
2
{% for item in mapa %}
3
<option value="{{item.id}}">{{item.your_desired_field}}</option>
4
{% endfor %}
5
</select>
6
For competencias
,
JavaScript
1
6
1
<select id="competencias" name="competencias">
2
{% for item in competencias %}
3
<option value="{{item.id}}">{{item.your_desired_field}}</option>
4
{% endfor %}
5
</select>
6