Questions tagged as 'mysql'

1
answer

Navicat MySQL server has gone away

I am creating a base de datos and at the moment of importing a file SQL with too many records or just that it is very heavy, I get the following error:    [Err] [Dtf] 2006 - MySQL server has gone away It is worth mentioning...
asked by 21.06.2018 / 06:40
1
answer

How to insert the value of two foreign keys in another table in MySQL?

Good day, I have a problem and I would like someone to help me. I have a database in which I am trying to insert in the table dig_item, but this has two foreign keys from the tables dig_pagina and dig_hritem, what I need is to insert as su...
asked by 22.06.2018 / 16:49
1
answer

Consult mysql with Flask

I am trying to make a query to MySQL that should bring data in a set date range and it does not work, if I could make other queries but it does not work, the data of the date range are two input type="date" I show them the code: <for...
asked by 22.06.2018 / 12:09
0
answers

Cloud of tags in php and mysql

I'm making a website where people can download images, you can search by categories, but due to the infinite variety of images the categories could only be very generic, which is why I had thought of adding a system of Tags or tags, I have to do...
asked by 19.06.2018 / 16:25
0
answers

problem generating pdf with fpdf

My problem is this: I have a form with which I select some data that I import from a MYSQL database, when I give it the save button it must open a new window where the pdf should be generated, the problem is that when I hit the save button I...
asked by 18.06.2018 / 21:51
0
answers

Show averages of student grades in php and mysql

In the image, the grades show them down and I repeat the name of the subject, I tried everything but I can not get me to just put the name once, and to appear to the right. Each note corresponds to period 1, 2 and 3. When I click on th...
asked by 18.06.2018 / 22:11
1
answer

MYSQL order query

I have the following mysql queries: <div class="container"> <?php foreach($mysqli->query('SELECT * FROM categoria ORDER BY categoria_ordre ASC') as $row_cat) { ?> <div class="panel panel-default"> &...
asked by 25.06.2018 / 14:14
0
answers

Relationships between MySql tables - PHP

I'm doing a system of commissions in which I have three tables: tabla 1 "administrador" id codeEmpresa empresa tabla 2 "cominicionista" id idEmpresa nombre categoria //la categoria puede ser A, B o C tabla 3 "cliente" id nombre categoriaClie...
asked by 22.06.2018 / 17:58
0
answers

PDO does not save query values

I have an html for registering users in a system (signup.html), and with a form I send the data to a PHP that executes a query to save them in the database (signup.php), but when I review the table where the record should be saved there is nothi...
asked by 16.06.2018 / 16:42
1
answer

Phpmyadmin and Java

I'm trying to make a BDD server, to be able to connect with java (ide: netbeas), the question is how is the class connection, since I think that is my problem here to access the database that I believe in phpmyadmin Obvious story with ip publica...
asked by 16.06.2018 / 04:17