Questions tagged as 'mysql'

Tagged questions
1
answer

Why do not you save the data? FormData ()

I am trying to save the data of an excel, using a file-type input to select it, I recently managed to do it without ajax, and it turned out well; However, I have not been able to do it using Ajax. When I researched, I read that to send data from...
asked by 20.09.2017 / 01:59
1
answer

DATETIME in MySQL does not correctly record the date

I have the following problem. I use the datetimepicker library to select a date in a form and register it in the database. The problem is that I want to register the date in the MySQL format but I do not record the time, that is, I select the...
asked by 28.09.2017 / 16:27
0
answers

Do I have to create a model in Laravel for a pivot table of 3 tables?

I am developing an application in which exam simulations are carried out. The exams are generated for each user with random questions. There are questions and each one has its answers, one of them is correct. In turn, the user performs the exam,...
asked by 16.11.2017 / 00:17
2
answers

Display Date data in TableView JavaFX

I have an SQL query that brings two (2) data that are name and licenseexpires SELECT nombre, licenciaexpira FROM conductores I have managed to show the name on my Table but the date does not. I was investigating and I realized that my licen...
asked by 15.11.2017 / 21:10
1
answer

How can I use this Mysql statement in Mysqli?

Since the old versions of php are no longer supported, I am migrating my projects to MYSQLI and I have a problem, I do not know how to group them in an array, since my previous code was this: $enero = mysql_fetch_array(mysql_query("SELECT SUM(...
asked by 16.11.2017 / 01:01
2
answers

Consult sql with 4 dates and verify that the dates do not cross?

I have a table with these fields We want to bring the id's of cars that are available in a range of dates that I receive from two inputs that would be when they want to take the car and when they want to return it. This dates I compare wit...
asked by 08.09.2017 / 17:25
1
answer

SQL Error 1005: Can not create table

I am using workbench in graphic mode, I made a model and now it gives me the following error: Executing SQL script in server ERROR: Error 1005: Can't create table 'bd_easymaker_0'.'herramientas' (errno: 121 "Duplicate key on write or update")...
asked by 08.09.2017 / 18:26
1
answer

RecyclerView with reverse order

I have my RecyclerView that gets the data from my MySQL database through json. The fact is that when I run the app and it gets the remote data, I always put the element with id 1 at the beginning of the list and the others behind ranked in...
asked by 11.09.2017 / 19:09
0
answers

Send info to table from a modal with php

Hello, I have read but I really have not succeeded, this is my code index.php <form class="modal fade modal_edit" id="modalNuevo" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" method="post" action="/../components/insertar....
asked by 11.09.2017 / 19:37
0
answers

Problem with While mysqli_fetch_array

I have the following problem, I do not know how to do a while in codeigniter for the following example (this was done in object-oriented php, in a class, and I called it in a listboxt in the design) function lista_sucursales(){ $opciones="";...
asked by 11.09.2017 / 21:10