Questions tagged as 'mysql'

Tagged questions
1
answer

Generate monthly chart

I'm putting together a monthly chart where the sum of expenses and revenue per day is displayed, but the data displayed in the chart is only the dates that exist in the mysql database. How could I display dates that do not exist in the ba...
asked by 03.05.2015 / 05:47
1
answer

MySQL does not connect to server

Hello, I went into phpmyadmin and it appeared, where is that supposed to be the problem ?? Code$coneccao=mysqli_connect("localhost", "root", "MINHASENHA"); mysqli_select_db($coneccao, "luppbox"); The server is hosted in a VPS, instead of l...
asked by 14.05.2015 / 18:14
2
answers

SubSelect in same column

I'm trying to create a subselect in the same column, I have to use a column row to get back a new value from the column itself. follow my sql code SELECT 'idUnidadeOrganica', 'NmUnidadeOrganica', 'idUOSuperior', (SELECT 'NmUnidadeOrganica...
asked by 08.05.2015 / 17:43
1
answer

Get field related to higher date

Yesterday the staff helped me get the last status referring to the highest date, ie displaying the status of the last modification. Now I came across another difficulty related to the same issue but with multiple statuses I return not only...
asked by 30.04.2015 / 15:31
1
answer

Best form tag Select in Php without framework with DAO project pattern

I'm having a question about how best to implement a method that traverses a common select using DAO standard with PDO. It would be appropriate for me to do this, my whole code in the view: $conexao = new PDOUtil (); $consulta = $conexao->...
asked by 29.04.2015 / 05:24
1
answer

How to compare string with accents in php

I have a problem that I could not resolve in php, I have a field varchar in MySQL with accentuation, I make a rescue of it and use htmlentities so that the string gets the correct accent. I need to compare the variable comin...
asked by 15.06.2015 / 14:56
2
answers

Insert MySql Error

Well, I'm trying to create a menu, and my sql is returning the following error: This is the result they are getting, I gave an echo to see if it was going correctly. Who we are is the name that identifies the menu, 2 is the code of who is the su...
asked by 15.06.2015 / 14:01
2
answers

Connection between MySQL and FireDAC closes the application when it is activated

I developed an application that uses FireDAC to connect to MySQL. But when I try to open it in a station, when the Connected := True is set, the application is closed, without returning any Exception. I wrapped the code in a try...exce...
asked by 15.06.2015 / 16:32
1
answer

Display links in sql query

In a database (MySQL) I have a column dedicated to electronic addresses (links). My problem is: many times the same line can have several links. I would like to include the links in the database in the same cell (Links), and in the view, make a...
asked by 24.04.2015 / 00:19
1
answer

Make select inside a setInterval and fill an array in nodejs

I'm making an application that needs to be checking in the database if there was any change using nodejs. The application works, however, when I have more than one record in the table, it gets duplicate data that I keep in an array. For example:...
asked by 24.04.2015 / 23:15