Questions tagged as 'mysql'

Tagged questions
1
answer

How to access MySQL Remote from Cpanel

How do I access the Cpanel MySQL database? I have already entered the wildcard host% in the list of allowed hosts, but when trying to access this error message appears:    Error # 2003   Can not connect to MySql server on 'ServerHost.com' (10...
asked by 10.02.2017 / 19:24
1
answer

Warning: PDOStatement :: execute (): SQLSTATE [HY093] [duplicate]

Good Night! I'm setting up a CRUD, I picked up some codes on the Internet and adapted to my need, everything was running perfectly fine, but when I got to the UPDATE part the application presented me with the following error: Warning: PDOSt...
asked by 12.12.2016 / 23:04
1
answer

Variable does not work in script

Srs, I'm new here, I have no answer to know what is happening. I created a $ rga variable to insert through a field, but it does not work. This srcipt uploads a photo and resizes it. In the displayed mode it does not accept the variable $ rga...
asked by 20.01.2017 / 17:31
2
answers

Extended PDO connection does not work

Well, the netbeans does not acknowledge any errors, but when I try to run it always gives an error in the browser, does anyone know what's wrong? can you tell me how to use the pdo connection of the parent class constructor method in the child c...
asked by 20.01.2017 / 11:04
0
answers

Insert with massive amount of data

Hello We are working on a project using PHP and Mysql database, at which time a large range of records (for example, between 5 thousand and 1 million) should be inserted in the database, At the moment, the most basic way to get performance...
asked by 19.01.2017 / 17:41
2
answers

Relationship between tables

I have a certain table already created and populated: CREATE TABLE 'formulario' ( 'id' int(4) NOT NULL AUTO_INCREMENT, 'nome' varbinary(50) DEFAULT NULL, 'carteira' varchar(30) NOT NULL, 'tipo_ocorrencia' varchar(13) NOT NULL, 'conta...
asked by 20.12.2016 / 21:41
1
answer

How to make modification records in a MySQL table (without using triggers)?

I would like to know if there is another technique of making record changes in the tables without going through triggers ?     
asked by 21.12.2016 / 11:46
1
answer

Error returning date

Are you guys, beauty? I have a problem here, everything was working normally and nothing started to give me this problem. Here is the function: function atualizaHoraServidor() { var dia = digital.getDate(); var mes = digital.get...
asked by 20.12.2016 / 19:10
2
answers

MySQL - Search number in a string

DBMS: MySQL I have a table with a column of type Varchar, with the following data: id Descrição 1 Pgto NF 66096 Lg Sistemas vcto: 01/10/2016. 2 Pgto NF 66096 Lg Sistemas vcto: 01/10/2016. 3 Pgto NF 1763 Criare Net vcto: 02/10/20...
asked by 06.01.2017 / 19:19
1
answer

How to limit the number of pages displayed on a page?

With this question that already has a workaround, I got as a result a paginação com PDO but I have one more problem that will possibly be the target of a reward next week. As you can see in the image below, I have this page with +...
asked by 03.10.2014 / 22:03