Questions tagged as 'mysql'

Tagged questions
1
answer

ERROR 1242 (21000): Subquery returns more than 1 row

I have a problem with a Trigger (MySQL). I tried to build it myself. The need: I have a system of occurrences where when passing to the stage of closing (stage 4) it verifies that a description was entered in the field descricao_encerra...
asked by 06.12.2016 / 14:26
1
answer

CakePHP 3 - How to sum the values of the quantity column of several lines and show the result in the view?

I have Table Entradaestoques    id - prod - qtd       1 - soap - 10       2 - cloth - 7       3 - soap - 20       4 - disinfectant - 4       5 - soap - 20       6 - cloth - 3 I want to show in View    Soap: 50 uni...
asked by 10.11.2016 / 20:44
1
answer

Dynamic Combobox with Codeigniter 3

The basic idea is similar to the combobox of states and cities , that when selecting a state, the next select returns the referring cities. In my case I can not list these fields in the second select (which would be equivalent to cities)....
asked by 07.10.2016 / 21:59
1
answer

Structure Array coming from mysql with PDO (organize)

Good evening, I'm having a difficulty with arrays where I'd like them to stay in order so I can use them as follows. In my database I have many images that I call with this code below. <?php $image_search = 00001::conect_sql(); $image_s...
asked by 09.10.2016 / 00:48
1
answer

Unable to connect: No connection could be made because the target machine actively refused them

I'm trying to connect to my database. This is easyphp webserver 14.1. Followthephpcodeforconnection.<?php$HOST='10.40.0.185:3388';$USER='*****';//Aquiinformeiousuáriodomeubanco$PASS='*****';//Aquiinformaeiasenhadousuárioparaacessoaobanco...
asked by 29.09.2016 / 00:12
1
answer

MySql installation error [closed]

After trying to install the LAMP package on Ubuntu 16.04, I'm getting the error:    ERROR 2002 (HY000): Can not connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I've reinstalled all MySql 2x; apt remove...
asked by 30.09.2016 / 17:21
2
answers

How do apps validate login to a remote server?

Let's assume I have a site with a MySQL database with logs for login, so a desktop or mobile app would need information like host, root and password to remotely validate a form, but that would not be dangerous every copy of the app have this inf...
asked by 16.11.2016 / 02:46
1
answer

How to retrieve the new name of a file in an automatic "Drag and Drop" upload

I found a system of upload of images Drag and Drop on the internet that makes upload of the image in a specific folder and renames the file with a random name without having to send the form. Why can not I retrieve the...
asked by 06.10.2016 / 21:35
2
answers

IP Blocked remote access mysql linux debian

I have the following error: [exec] mysqladmin: connect to server at '179.111.225.163' failed [exec] error: 'Access denied for user' rqtecnologia'@'177.21.38.34 '(using password: YES)' I've already changed the user password I was already in...
asked by 05.10.2016 / 12:59
2
answers

Check if the record already exists, if it does not change the value (MYSQL)

PHP FUNCTIONS <? if($_REQUEST['salva_ed']){ $sqlu="update registration set username='$username', firstname='$fname', lastname='$lname', sex='$gender', birth_date='$bdate', addressline1='$address1',addressline2='$address2'...
asked by 06.10.2016 / 21:48