Questions tagged as 'mysql'

1
answer

Users No records in BD

I have 2 tables, one of users with id autoincrement ID_usuario|nombre and another where their accesses are registered. ID_acesso|ID_usuario|fecha_hora_registro How can I get the users who do not have any registration during the...
asked by 18.04.2018 / 19:54
2
answers

Pass select / option to variable

I finally decided to do the consultation in a forum, since I no longer find a way to solve the doubt I have. I am trying to pass the chosen option of a select / option to fields that are hidden and that are autocompleted. I've read a lot,...
asked by 18.04.2018 / 20:12
0
answers

Query in Paradox Data Base

Good day. I need to filter between two dates in a paradox database, I'm using this command: select * from fact01.db where date_doc between '01 / 05/2018 'and '31 / 05/2018' donated this error: Type mismatch in expression. I put it between...
asked by 11.04.2018 / 12:25
1
answer

Fatal error: Can not use object of type Course as array in

Hello, I have this function that pulls out an array but when I try to get the name of the following form, for example [0] ['name'] tells me that the object of type Course can not be used as a matrix. public function mostrarCurso(){ $db = B...
asked by 11.04.2018 / 11:56
1
answer

SQL query to show image by ID

I would like to help me solve a problem I have in my web project, my case is that I have two products registered and I want to add images to each product. As you can see in my database I have two different images (printer.jpg and camara.jp...
asked by 11.04.2018 / 15:31
0
answers

How can I get the quartz cron trigger from a mysql database in java code?

I have an application in which I use Quartz and I store the information of the triggers in mysql, but to set the parameters of the trigger I want to get the information from the base so as not to have hardcoding in my java code, could someone te...
asked by 11.04.2018 / 16:10
3
answers

I can not insert data in my table

I am learning to insert users in my database, but the data I insert does not appear in the usuarios table, what is the problem? This is my code: <?php if (isset($_POST['submit'])) { $username = $_POST['username']; $password...
asked by 14.04.2018 / 10:56
2
answers

Auto complete several text boxes

I need auto to complete several text boxes through a search to a mysql table. I have found an example that fits my needs, but I can not make it work The form is in the index.html file. Entering two digits in the field "registration" makes...
asked by 13.04.2018 / 23:31
0
answers

Is this Truncate Table correct?

I am creating a code so that at the end of the day it allows me to erase all the data that is stored in it, they would be deleted manually by means of a truncate. But at the time of executing the php this does not erase the data. Some informatio...
asked by 14.04.2018 / 06:09
0
answers

Problem when starting MYSQL WORKBENCH

Good evening friends I have a problem with the Mysql WorkBench, I have it installed correctly but I want to run it and nothing appears on the screen, could you please help me? Active. Please Help :(     
asked by 09.04.2018 / 01:07