Questions tagged as 'mysql'

Tagged questions
1
answer

What is the problem with this query?

Good, I have this query that I do with my API REST in NodeJS router.get("/create/:id/:name/:img",function(req,res){ var query = "INSERT INTO ??, (??, ??, ??) VALUES (?, ?, ?)"; var table = ["demos", "id", "name", "img", req.params....
asked by 11.01.2017 / 21:49
1
answer

Print data in a table

good I have a query which will look for the payments of people and show in a table that month paid and leave blank or print that month I do not deposit, I have the following code, but that is stuck here to show the payments in your due month, th...
asked by 09.09.2018 / 17:51
1
answer

PDO using LIKE in the MySQL query

I have the following code $damn = '%'.$busqueda.'%'; $q_i = $this->pdo->prepare('SELECT * FROM registro_viaje WHERE (id_pas_reg LIKE ? OR nomc_pas_reg LIKE ? OR tel_pas_reg LIKE ?) AND matricula_veh_reg=?'); $q_i-...
asked by 13.10.2016 / 23:50
1
answer

mysql Queries with arithmetic operations

I have tried to find some kind of query that does arithmetic operations to show them in a table only the result. I've tried with count() but I only get the data and not the operations, such as adding and multiplying the sales. For exam...
asked by 02.01.2019 / 03:23
0
answers

Login script _construct

I have a problem with my session script. Out of nowhere, my "classes" folder with all the files has been deleted from the hosting and I am re-writing them. MY problem is that it does not start the session. I think there is a problem in the const...
asked by 11.04.2016 / 18:51
2
answers

How can I download a PDF file from a registry in a MySQL database with C #?

With the help of this query, ( How can I attach a PDF file to a DB record in SQL with C #? ) and  with some small modifications I was able to add a PDF file to a MySQL table, now I have the inverse problem, this is I need to be able to download...
asked by 07.04.2016 / 22:27
2
answers

Error making a record in the bd mysql on a host

How about, I have a form, I've uploaded it to a host, for example www.example.com/register and at the time of registering I get the following Warning: mysql_connect(): Connection refused in /home/xxx/xx.xx/prueba/controllerdb.php on line 16...
asked by 08.04.2016 / 20:22
1
answer

Registration with RESTful API in java

I need to create a small application with java to allow users to register, I have to use a API RESTful and I would like to know the relationship between the registry that is stored in a database MySQL and API RESTful ....
asked by 22.06.2018 / 22:42
1
answer

How to make a query with unrelated data MySQL

How can I make this query in mysql? 'SELECT * FROM tblEmpleados e LEFT JOIN tblUsuarios u on u.usuarios_nombres,' 'u.usuarios_apellido_paterno LIKE' concat('%',e.empleados_nombres,'%','%',e.empleados_apellido_paterno,'%') I do not have a f...
asked by 28.06.2018 / 22:16
1
answer

Create a foreign key on phpmyadmin

I need to create a foreign key in a database that I have in phpmyadmin. The database consists of 4 tables, all of them already contain data. One of the three tables is related to the rest of them. All the columns in the main table have an index...
asked by 11.04.2018 / 13:03