Questions tagged as 'mysql'

Tagged questions
1
answer

the procedure is fine with an output (phpmyadmin)

How about? I have a doubt I want to make a procedure so that the end result of a result 0 or 1 according to the result number of my table users the procedure is this: DELIMITER $$ CREATE PROCEDURE Coretec_ConfirmUser(IN p_user_mail VARCHAR(150...
asked by 27.10.2018 / 22:16
1
answer

How to insert a LocalDateTime (Date with time) into a MySyQL database

I have a database created with phpMyAdmin, and in a "reservations" table I have a field that asks me for the specific date and time of a reservation. Now the problem is in which at the time of inserting the reservation, I do not take the date, w...
asked by 26.10.2018 / 15:32
0
answers

PHP - JS - WebSocket connection to 'ws: // localhost: 8125 /' failed: Error in connection establishment: net :: ERR_CONNECTION_REFUSED

I have a problem trying to login to my local webpage. When I click on the enter button or when loading the page, it appears on the console: Making validation of the query I also notice that the variables that are passed by post do not take...
asked by 26.10.2018 / 16:51
0
answers

Trigger Record Update Date

Good bye? I would need to create a trigger that before a modification of some field of my user table, I enter the current date of modification, if you could help me I would be very grateful.     
asked by 04.11.2018 / 22:01
1
answer

Save button that serves to update

I appeal to you since I have a question and can not think of anything to solve it. I comment I'm doing a CRUD in Java with the BD Mysql. I have done almost all the buttons, I just need to update. It turns out that I want the Save button to als...
asked by 04.11.2018 / 21:23
0
answers

login does not redirect to server

I have a login already tested in localhost that works for me and when uploading it to the server it does not redirect me to "index.php", when I enter the user and the pass, but after sending the request to the server I must edit in the URL the "...
asked by 04.11.2018 / 21:42
0
answers

Fill data with a ComboBox from MySQL

I am trying to make the information load when the first option is selected a project that was stored in a database and that at the time of selecting a project the respective information below is selected depending on the previously stored inform...
asked by 27.10.2018 / 05:00
0
answers

Transpose query data in mysql

I have this table in mysql (The registers are dynamic): And I need to show the data in the sql query in this way:     
asked by 27.10.2018 / 00:24
0
answers

Can not add or update to child row: a foreign key constraint fails MYSQL WITH C #

I am in this problem I was searching and so according to the error is that I do not have data in my table1 -> appointments to place it in my table 2 - > I already made sure that the dating is the correct one Open();...
asked by 01.11.2018 / 21:44
0
answers

My PHP Script Send incomplete mail with the data of a WHILE

Greetings guys I have a conflict that I explain below: I have the following script <?php $sql2 = "SELECT tarjetas.*, users.nombre, users.email, users.username FROM tarjetas INNER JOIN users ON tarjetas.usuario=users.idusuario WHERE usua...
asked by 01.11.2018 / 18:19