Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

Change the date model of the database Data AAA / MM / dd to dd / MM / AAA

Good I would like to know if it is possible to change the model of the dates from the same wampserver     
asked by 02.03.2018 / 00:57
2
answers

Display a user's name in their profile. PHP

Good morning, have all of you! I'm making a user platform and I'm in the profile phase, I've already logged in (which, you enter by registered mail), registration, use of cookies, password forgotten, etc ... Now, my PHP code for the profil...
asked by 02.02.2018 / 15:38
2
answers

Place field that can be left blank or not

I have a couple of fields in mysql that I want them to be blank but I miss the error that I have to enter them and the problem is that they will not always be blank this is the insert of the data $Nombre = mysqli_real_escape_string($con,(st...
asked by 16.11.2017 / 16:02
1
answer

Save image in blob or by route? [closed]

What would be most appropriate and a good practice to save images in database By route or within the manager as data     
asked by 25.10.2017 / 13:23
1
answer

Error with group by in mysql 5.7

I have the following query : SELECT count(id_estadistica) AS num_clicks, a.*, b.* FROM estadisticas AS a LEFT JOIN noticias AS b ON a.id_elemento = b.id_noticia WHERE b.id_noticia IS NOT NULL AND b.fecha_pub BETWEEN '2017-10-01 00:00:01...
asked by 08.11.2017 / 08:16
1
answer

Triggers PhpMyAdmin

I have the following trigger: CREATE OR REPLACE TRIGGER tr_insercion_evento AFTER INSERT ON evento BEGIN INSERT INTO historico_evento(historico_evento.id, historico_evento.fecha_cambio, historico_evento.evento_id, historico_evento.usuario_exo...
asked by 08.11.2017 / 15:55
2
answers

Percentage of sales for the current month

I want to get the percentage of sales for the month of the current year. In other words, I sum the total sales of the month of each month and I divide them by the total sales of the year. SELECT *, sum(total_venta) as total_venta FROM...
asked by 01.10.2017 / 02:11
1
answer

Problems with perl using CGI

Global symbol "$mysqli" requires explicit package name at register.cgi line 15. Global symbol "$dbh" requires explicit package name at register.cgi line 30. Global symbol "$dbh" requires explicit package name at register.cgi line 36. register....
asked by 08.10.2017 / 06:13
1
answer

Replace one image with another PHP and MYSQLI

I have my code to edit images in my database, but when replacing the image in the folder or the path where it is saved does not replace them, but adds a new one. I leave image below: The image that is underlined in yellow is the one I w...
asked by 31.10.2017 / 22:07
1
answer

Syntax error with case in mysql using SP

Well from phpMyAdmin I'm doing a crud with case, and well he tells me that there is syntax error nothing else I do not see something bad. My code is this: create PROCEDURE usuarioXY (in _idUser int(11), in _usuario char(50), in _consetrasen...
asked by 20.09.2017 / 21:26