Questions tagged as 'mysql'

Tagged questions
2
answers

How would it be possible to perform the following consultation?

SELECT * FROM 'ofertas' WHERE date LIKE '2016-12-20%' BETWEEN LIKE '2017-01-16%' I would like to consult a range of dates, but the column date is declared with the default CURRENT_TIMESTAMP , so when making the query with the clau...
asked by 23.01.2017 / 18:00
1
answer

automatically fill in mysql intermediate tables

I am trying to fill an intermediate table automatically from another one, the example is as follows. where when filling the table SPECIFICALLY the salary field (# 13) it should be filled in the following intermediate table as a record only...
asked by 23.01.2017 / 19:48
2
answers

"Unknown" error in PHP form

I have a php that is connected to a BD Mysql and that its function is a login , the problem is that it always shows me that the user or password they are incorrect even if they are not. I leave you the PHP <?php ses...
asked by 23.01.2017 / 13:23
1
answer

Show image BLOB type of MySQL in a JSP?

I have this code but it does not show me anything, as I can do to show the images I have in my database on a jsp page. mostrar.jsp: <%@ page import="java.sql.*" %> <%@ page import='java.io.InputStream' %> <%@ page im...
asked by 08.12.2016 / 03:47
1
answer

Eloquent Count + Group By + Inner join

I am having some problems with the queries in the ORM-Eloquent, I have integrated eloquent in codeigniter, I am trying to make the following query: SELECT tp.*, COUNT(*) as cuenta FROM tipo_llamadas tp INNER JOIN encuestas e ON tp.id = e.id_ti...
asked by 15.12.2016 / 15:52
1
answer

Mysqli with php saves all empty data

E Fixed error "undefined index" with if, what happens is that I save empty data now in the database, without if I get error and just the empty guard, see something I do not? help please ............. This is the form, the select is nothing mo...
asked by 28.02.2017 / 04:37
4
answers

Mysqli saves the empty records from Php

Good morning everyone ..... I have a problem in which my form should send the records to my database, but what it does is keep my records completely empty, I leave my code and hope someone can help me, thanks. . This is my form, here I assign...
asked by 28.02.2017 / 16:03
1
answer

Error in php with MySQL query [closed]

I do not know how to ask this question very long since I do not know why this query does not work for me. According to the file in localhost I get an encapsulation error but I do not see the error if someone helps me I appreciate it: mysqli_...
asked by 14.01.2017 / 04:46
1
answer

Show results in a select from the database [closed]

I want to pull data from a database but only show fields that are equal to 1 and its id equal to 7 say in an html select. Let me explain myself better: If your id is equal to 7 but your "home" field is equal to one, I do not want to show "hom...
asked by 12.01.2017 / 23:19
1
answer

Error connecting to a Mysql database. Object reference not set to an instance of an object

What I am trying to do is a simple connection method in c #, but at the moment that I want to make the connection with my Database I get the following error:    Reference to object not established as an instance of an object. Code where I...
asked by 23.03.2017 / 18:03