Questions tagged as 'mysql'

2
answers

How to fill the radio button with javascript with data from the BD? [closed]

I need that when loading the page the radio button is selected with the data of the database.     
asked by 04.12.2018 / 18:39
1
answer

ID on a table is altered

I have a table in mysql, which when inserted from PHP alters the logical order of the ID: "INSERT INTO 'persona' ('id_persona', 'nombre_contacto', 'apellido_contacto', 'telefono_persona', 'email_persona', 'documento'...
asked by 28.09.2017 / 20:11
1
answer

Error in data base connection in PHP

I am learning php and when I try to connect to the database I get this error:    Warning: mysqli_connect (): php_network_getaddresses: getaddrinfo   failed: Unknown host. in C: \ xampp \ htdocs \ php2 \ Exercise   1 \ conexion.php on line 2...
asked by 17.11.2018 / 01:59
1
answer

How to get the average life of the records?

I want to take the average life of all the records that exist for example if an employer withdraws Head protection - APRO - Helmet - Steel pro - Complete wing - N / A - 5 - 30-10-2018 , and then the next day remove the same product the av...
asked by 31.10.2018 / 15:20
1
answer

Show select dependent on input

I have a form where I want that when typing an item number in an input, the description belonging to that item appears in a select. The item and the description are from a table in MySQL. I've been researching and I only see solutions in r...
asked by 25.05.2017 / 14:34
2
answers

Fill MYSQL table with another table from the same database where table A has 1 field more than table B

As the question says, both tables are in the same database and both have the same fields (such as telephone address name etc ...) with the difference that table A (original table containing the data) has 1 field more than table B (table where th...
asked by 20.08.2018 / 13:46
1
answer

Search for names in a Select Option Html Php MySql

I have this problem, I want to create a client name search engine that is auto-completed in a select option here my code:   <div class="form-group"> <div class="input-group"> <span clas...
asked by 16.08.2018 / 06:58
1
answer

MySQL query in several tables

good morning. I am registering the sale of a product with its unique ID and price, I am wanting to make a report that tells me what category that product belongs to that is in another table. How can I perform the query in several tables?...
asked by 22.10.2018 / 13:13
2
answers

Relate Data for inventory

Good afternoon I have a problem when it comes to relating data in mysql for a system that I am developing, the doubt that I have is that the company that I am working with buys its products wholesale, and sells them in the same way , but I'm loo...
asked by 26.09.2018 / 18:34
2
answers

Group consultation without losing separate records 2

Hi, I have the same problem as in this question ( Group query without losing different records ), it's complicated explain it. When the results of the records are grouped, information is lost, for example I have data in the customer table and...
asked by 25.07.2018 / 23:16