Questions tagged as 'mysql'

Tagged questions
2
answers

Check if returned records in select PHP

I need to check if my 'Select', is returning records to then load the data on the screen. Here is the code I'm using: $sql = mysqli_query($conn,"SELECT * FROM USUARIOS;"); $linhas=mysqli_num_rows($sql); //eu preciso verificar aqui!!!!! whi...
asked by 01.03.2018 / 14:20
1
answer

Migrating from a Local DB to MySQL DB

I'm developing an ASP.NET WEB page with MVC and I made all the model, control and display settings in Visual Studio 2017 and it created a Local BD by SQL Server LocalDB to store the data but there is an automated function that migrates the table...
asked by 01.03.2018 / 12:27
2
answers

I can not see the error (PHP and HTML)

I wanted to show the names of the employees and the teams they are part of so that if the user enters a name, it will filter all the teams that that person is part of. It's coming in white. try{ $pdo = Conexao::getI...
asked by 02.03.2018 / 13:47
1
answer

Linting is disabled for this query because it exceeds the maximum lengt

Next I have a problem with mysql which is as follows when I am going to add an image in the text editor of my content manager, this image is converted to base64, this editor is summernote, however the code is added by half on the bank in the tex...
asked by 22.02.2018 / 19:28
1
answer

Count Number of Uploads in a Certain Period

I have the following query in my file: SELECT IDUsuario,IDArquivo,Time FROM uploads WHERE Time >= '2018-02-20 00:00:00' AND Time < '2018-03-21 00:00:00' And my result looks like this: In this case I have repeated user ID...
asked by 23.02.2018 / 00:15
1
answer

Save form with NodeJS and MySQL

I am a layman in the world of Node.JS and I am developing a form in which the number of fields is dynamic, ie there is a button that calls a function in JavaScript that is adding fields according to the user's need. My problem is to capture t...
asked by 06.03.2018 / 19:19
0
answers

Identify and list which users viewed a post Laravel

Good afternoon, for the purposes of studies, I'm creating a system of communications, where users register communications in a timeline, but I came across the following doubt, How would I show which users viewed this release? Announcements are s...
asked by 06.03.2018 / 17:31
0
answers

Doubt in logic for table comparisons between plans - Timeout is giving

I have the following table on my site, and today it is static (not updatable by CMSs). It has more lines than this image, but I just took a piece to illustrate. Today,inmydatabase,Ihavethese3plans(ACO,ACOFITandACOModular)registeredinatableca...
asked by 06.03.2018 / 18:16
0
answers

Change data using Checkbox - Php + MySql

Hello, I'm building an internal request system and would like to include status / status steps, I'm trying to do this in bulk using the checkbox. I basically want to select x number of items from a list, and move them to another list. My di...
asked by 20.02.2018 / 16:26
1
answer

DATE_FORMAT function - Mysql

I have this query below, which brings all the information I need. However the resolution field is with the date (yy-mm-dd), I need it to return with the date formed as dd / mm / yy: select * FROM denuncia WHERE resolution BETWEEN ('2018-01-0...
asked by 20.02.2018 / 15:52