Questions tagged as 'mysql'

1
answer

PHP does not recognize the table in my database

my base is: test, my table: user, inside the table I have two users name and password, when I enter the correct name and password for the user to accept a message of success, but I get this message    Connection error SQLSTATE [42S02]: Base t...
asked by 28.04.2018 / 23:50
1
answer

Make join in two tables in mysql

I have doubts about a query on mysql. I have two tables, one low call and the other called galleries. The low table has the id field and the name field and the galleries table has the id, the lower_id and the image. My question is this, would it...
asked by 29.01.2018 / 20:34
1
answer

phalcon valid fields so they do not repeat themselves?

Good morning. My question is about whether phalcon does the validation of a field by default so that it does not duplicate when creating a user, specifically so that it does not allow to duplicate the identification number. Thank you very...
asked by 30.01.2018 / 13:10
0
answers

ResultSet returns java.lang.nullpointerexception although the conculta has a result

I have a problem with a query: private void cargar(){ query = "select idcte from clientes where nombre like '" + str1 + "';"; res = conn.Consulta(query...
asked by 03.02.2018 / 00:58
0
answers

Query data from an administrator and client view

I have a problem filling in the data of a table in a jsp. My model is as follows: The problem I have is in the index.jsp inside the menuProducts. When filling in the information with the following code: I do not get the d...
asked by 31.01.2018 / 07:48
2
answers

Problems when retrieving array with MySQL info

I'm trying to login with Classes and Objects. The thing has been that when using Classes and Objects the register variable that an associative array saves is inaccessible now and it gives me an error, require_once('conf_db.php'); class Bas...
asked by 31.01.2018 / 11:03
1
answer

how to send a php array by json_encode and show with datatables

I have the following problem. I need to send some data already formatted or calculated in a php array via json to be displayed in datatables. The issue is that I have tried several possible solutions and none shows information about it....
asked by 28.01.2018 / 19:52
1
answer

Subconsultation with LEFT JOIN

The problem is that the subquery does not get anything: What I want to get in the column [rs] is the name of the bank, it is currently returning null. SELECT ta.id ,ta.idTarea ,ta.idConsignacion ,nomBanco.rs FROM tar...
asked by 06.02.2018 / 15:09
0
answers

How to calculate the price of a reservation to insert later in the BB DD in DAO?

I'm doing a room booking system with Mysql, java and HTML.  I wanted to know How can you calculate the price of a room?   Depending on the days and the type of room, whether they have children or not.   And then as I insert it in the database. O...
asked by 09.02.2018 / 18:09
0
answers

How to add columns with UNION?

I have two tables: Sales and history. In the sales table this is practically what the client owes, and in history what he has already paid for. I want to make a query that tells me which product is the most consumed. For this I have to...
asked by 09.02.2018 / 17:15