Questions tagged as 'mysql'

Tagged questions
0
answers

Can you download a phpmyadmin database from PHP?

I'm thinking of enabling a button or a link to download the .SQL file that generates phpmyadmin from the database that is being used. But I really have no idea if this can be done. If anyone knows how it can be done and can help me, grateful, if...
asked by 13.08.2017 / 21:05
1
answer

Select query with JComboBox

Hi I have a problem I want to make a JComboBox I can select an article from my BD and I do the query to load well and everything but when I want to select another article the query that I have to look at the stock of said article fails me here I...
asked by 14.08.2017 / 00:16
1
answer

Registration of MySQL records with NodeJS (Backend) that does not enter "Success" and hangs. That could be happening?

I expose the code to see if someone can help me HTML code with the button that calls the function: <div id="btn_crearcurs" class="btn_curs"> <a class="btn btn-warning btn-lg btn-block" ng-click="crearCursos()">Crear...
asked by 16.08.2017 / 06:56
3
answers

How to join tables in MySQL?

I have three related tables in this way: What I want to do is make the final result look like this: The SQL query I did was the following: select pe.id_pago_empleado,e.nombre,e.apellido_paterno,e.apellido_materno,pe.sueldo,pe.frecu...
asked by 29.07.2017 / 19:04
2
answers

SQL Where do I put the foreign key table hiija or father?

CREATE TABLE personajes( per_nombre varchar(50) not null default 'Desconocido' , per_genero varchar(30) not null default 'Desconocido', per_raza varchar(50) not null default 'Desconocido', per_alias varchar(50) not null def...
asked by 15.07.2017 / 18:36
0
answers

Advanced search form

I have an advanced search form with input and checkbox , in which you can enter the name or select one or all of the checkboxes but how can I do it so that it takes the entered values to perform the search in mysql ?. <f...
asked by 27.07.2017 / 12:19
1
answer

A Switch does not work [php]

                 INTRA-Nielsen | Scheduling <link rel="stylesheet" href="/dist/css/styles.css"> <!-- Tell the browser to be responsive to screen width --> <meta content="width=device-width, initial-scale=1, maximum-scale=1, use...
asked by 27.07.2017 / 15:03
0
answers

Auto-complete a table from a select with mysql data and continue adding more items to the table

What I want to do is that in a form have a select with the products and next to the select an input type = button where you add it to a table the data and that you can continue selecting more products to add it in the same table. This is the...
asked by 12.07.2017 / 21:08
0
answers

Error 1054 when executing sql statement at end of cycle

I have a MySQL table called empleados , I'm in the option modificar , this is the final code of the cycle modificar : sql="update Empleados set numdocEmp='"+numdocEmp+"', NombreEmp= '"+nombreEmp+"', salariobasico= '"+salbasic...
asked by 14.07.2017 / 17:21
0
answers

Error 2003 (HY000): Can not connect to MySQL server on 'localhost'

I get this error and I do not know how to solve it.    ERROR 2003 (HY000): Can not connect to MySQL server on 'localhost'   (10061 "Unknown error")     
asked by 10.07.2017 / 16:37