Questions tagged as 'symfony'

1
answer

how to prevent sql injection symfony 1.4 and doctrine 1.2?

Hi, I have a 3 inputs of searches that make queries to the database and I get the data obtained. So a malicious user can circumvent my system and get other information. By analyzing the behavior I use for the user to interact with my syste...
asked by 19.11.2015 / 18:14
1
answer

Select Distinct in Doctrine and Symfony

Hi, I have a photo album creation table. My code makes 1 insert for each image added in the photo album. I have a grid for displaying the albums for the user to view. I want to make a distinct of duplicate albums. I have this type of code:...
asked by 10.09.2015 / 14:25
2
answers

current_date doctrine

Tchê, I'm just trying to get information from the bank only when I have the same day as today, so I tried these ways: ... ->where('a.data_hora = ?', current_date()); .... ->where('a.data_hora = current_date'); ..... $data = date...
asked by 03.06.2015 / 15:35
2
answers

___ ___ erkimt SQLSTATE [42703] Undefined column: 7 ERROR: alis.nome_coluna column does not exist LINE 1: [closed] ______ qstntxt ___

I have a page on my system that does a file transfer, it just does an update on the table. I copied the lines of this code and put it to work on another page, changing only the field and table names.

I'm using the Symfony 1.4 framework with MVC for PHP development. In the action of the original function there are two actions one that opens the page and another that makes the update code. In the action of the other page, I copied the action that makes the page open and the code action doing the update, changed the fields and table name.

My role, as I said, is to take the procedure number (original code page) and bring it along to whom the procedure was registered. In the database has a boolean column %code% that receives default %code% and if it is changed it becomes %code% - and if it is %code% I say in my code for it to invert the values.

I did the same thing for the other page. If I do not create the column %code% (new boolean column) my button that does the function of opening the page to transfer, everything works fine, however it does not change anything because it does not have a column in the table created to receive the value% with%. If I create the column %code% my system does not load the data and the error appears saying that the column does not exist.

My action code is this:

%pre%

I am not the creator of the system, I am only giving maintenance (I am a trainee). Can anyone help me?

    
______ azszpr57824 ___

try to put one in? as in the above line between the parameters:  -> set ('d.transferido_den', '?', 'NOT (d.transferido_den)')

It will probably work.

    
______ azszpr58125 ___

I was making a mistake because of the database I was calling. There were 2 with similar names, I was creating in db that was not being called in my file, so the error.

    
___

I have a page on my system that does a file transfer, it just does an update on the table. I copied the lines of this code and put it to work on another page, changing only the field and table names. I'm using the Symfony 1.4 framework with M...
asked by 09.04.2015 / 16:15
1
answer

how to work with aes_decrypt in symfony 3 [closed]

I have a database that is encrypted by another system and I need to decrypt the data for display on the system made in symfony 3. I have the decryption key and I need to do this. I have little symfony experience. How should I do this? Was it E...
asked by 18.07.2016 / 15:30