Questions tagged as 'mysql'

Tagged questions
1
answer

"echo" the date if it is different from the previous one

The whole problem is for a chat. I have a echo , within a foreach , and for each message, get the complete date: Example: Sat, 21 of July 2018 and I want to know how to put a check to see if the following message has the sa...
asked by 21.07.2018 / 22:50
0
answers

How to create a location option in the publications of my web page and save it in mysql?

I am developing a website where you can access with a user, make publications, comment, etc. But what I still lack and I do not know how to do it is like putting a location option to put in the publication, something like this: And when...
asked by 15.07.2018 / 05:19
1
answer

I am failing to consult within a Stored Procedure

I make a query, to know the Id of a specific table whose value I keep in a variable, this always gives me zero and is incorrect, since that value is in that table. set @provi = (select Id From Provincia Where Nombre = _provincia);     
asked by 16.07.2018 / 17:06
0
answers

I can not add user using Java EE and MySQL. I can not find the error

Hello, I am trying to insert a user and I can not specify it. I do not find error in the code, however it is not achieved. JSP FORM: <form action="operador" method="post"> <input id="nombre" type="text" name="nom...
asked by 14.07.2018 / 02:00
0
answers

Convert java.util.Date to java.sql.Date

I need to do the conversion java.util.Date to java.sql.Date . I have tried the following: private long convertirDate(java.util.Date f1) { java.sql.Date fechaSalida = new java.sql.Date(f1.getTimeInMillis()); } The problem is...
asked by 15.07.2018 / 17:52
1
answer

I do not want to insert data in the database

I do not want to save any data in the database and in view it does not tell me any error I do not know if I have an error in the code Model require_once('../admin/Conexion.php'); class Usuario{ private $cedula, $usuario, $pSecreta, $res...
asked by 15.07.2018 / 22:46
4
answers

Why does the Inspector Character ( ) appear in some data obtained from the Database?

I was dealing with the dilemma of converting the accents and special characters of my system. It happens that now some of the data obtained from the database that have tildes come out with this: . The strange thing is that there can be up...
asked by 31.03.2017 / 12:53
0
answers

I want to make a query with STORED PROCEDURES where I can eliminate with a conditioner

Eliminate an employee permanently. For this will have to verify that said employee is not being referenced in tables DEPARTAMENTO , TRABAJA_EN and DEPENDIENTE . In the event that yes there is a reference to send an error messa...
asked by 18.07.2018 / 03:35
1
answer

Select multiple with data from both MySQL tables

I am trying to perform a query in which I select several data from both tables where their relationship is NickName at the beginning to take the messages had this code SELECT * FROM $tabla WHERE UserEmitter IN ('$usuarioActual', '$usuarioR...
asked by 16.07.2018 / 15:35
1
answer

Loop to database insertion

I want to upload each one of the: Titles, Lists and descriptions Knowing that: $ title is executed 40 times with different titles $ list is executed 40 times with different list $ description is executed 40 times with different description I can...
asked by 18.07.2018 / 01:00