Questions tagged as 'mysql'

1
answer

django forms does not insert data

I have a form with a model related to several models, create the form and it is well displayed, but when you submit, nothing happens, that is, the data is not saved in the db, I use python 3.7, django 2.0 and mysql: Model class Proyecto(...
asked by 31.08.2018 / 16:18
3
answers

Registration form, check dni and if user exits PHP + AJAX

have if someone can guide me. I'm making a registration form, in which they have the typical fields; but the ones that I need to do verifications before inserting the registry is of Username (email) and the nif. I have a form that when we giv...
asked by 06.09.2018 / 08:44
0
answers

Group Concat mysql loses the order BY

I have the following SQL Query but the order by the GROUP Concat in some results does not have the expected order as I would like it to be by the date as shown in the image below. SELECT objects.*, GROUP_CONCAT(mvalues.value ORDER BY mvalues....
asked by 11.09.2018 / 12:18
0
answers

I can not download file by php sql

I am trying to download a file (in this case an .xls) by means of php and sqli. The file (hello.xls for giving you an example name) is "downloaded" with its correct name but it weighs 0kbs, so it does not grab the file, it just retrieves the nam...
asked by 03.09.2018 / 15:12
1
answer

node js synchronous query

I'm trying to execute a query to a mysql database after getting some ids from another query, but it sends me the callback blank, so it responds before finishing the query to the bd I do not know how to solve it. imgmodule.darImagen...
asked by 03.09.2018 / 21:19
1
answer

I have a problem with MYSQL and LINUX when altering a value

I have this code to update an item for example if the amount is at 8 and I add 2, when updating the page the change is saved but I do not know why the error is coming out. alert ('Something went wrong, please try again'); before I had the s...
asked by 31.08.2018 / 20:26
0
answers

Print values in an NXN matrix

I have this code that prints a value horizontally and I want it to be printed as a nxn matrix, here my code: <?php include('config.php'); $sq2 = "SELECT * FROM acarga WHERE bl3 = '1' "; $result3 = mysqli_query($conne...
asked by 31.08.2018 / 19:09
1
answer

Load select dependents in Dropdown in update with Codeigniter

Good day, it turns out that I want a page of data update in which I load dependent select with jQuery and Ajax (which I already have it preconfigured in another page where I do it as a new record ~ and the information is load of the db). I sh...
asked by 02.09.2018 / 03:39
0
answers

Make a table or make a query whenever the user enters?

Suppose we have 2 columns of thousands of records and we need to count them and then show the total to the user, the question is should I recount them every time I visit the page or should I make a special table that has the already counted numb...
asked by 02.09.2018 / 16:28
0
answers

Help with Data Clean DATAFRAME

I want to create a function that allows me to split a row / column where it has several words, and transport the word I want to another row / column where there is a Nan. as you can see in the example. I would like to be able to take a descripti...
asked by 30.08.2018 / 19:42