Questions tagged as 'mysql'

Tagged questions
1
answer

Change type of all table fields

Can you change all fields in my table to VARCHAR ? I have a table with a lot of fields and I wanted all fields to be automatically changed to type VARCHAR     
asked by 13.02.2016 / 20:07
1
answer

encrypt and determine valid time for url php

I need to encrypt some parameters of the url, such as email and client code, and determine the valid time for the forwarded link. I mirrored on Facebook, Google and Twitter using this methodology to ensure the security of the url. What wou...
asked by 12.02.2016 / 14:07
1
answer

json_encode Empty

Below my PHP code. It takes the data from the database, puts it in an array, and then passes it through a json_encode. However, it does not print anything, how to solve? Note: Using print_r in the array it is possible to perfectly visualize t...
asked by 27.01.2016 / 19:54
1
answer

Doubts question and answer systems with $ _GET method

I have a system that shows a question and the person responds, but I am with a failure, following:  When the staff responds step I use the $ _GET method to pick up the response from it and insert the information into the bank, plus the failure a...
asked by 13.04.2016 / 17:26
1
answer

Tuple of values using mysql procedure

I have a form where you have two fields, one service and another value, for each service the user has to put a value, after the user chooses, I consult the bank how many rows will return me with this filter. For the procedure I pass two paramete...
asked by 29.01.2016 / 19:35
1
answer

Problem with special php characters

I'm using php on the html page to validate a form. When the database retries the text to the page php is not displaying the result with special characters. Where is the error? Page: <meta http-equiv="Content-Type" content="text/html; ch...
asked by 14.04.2016 / 15:55
1
answer

Laravel - Save data in the database only if there is no ...

I have a person registration system and there is an area with several checkbox fields that represent the social groups that the current person represents: TABLES person id | nome 1 | João 2 | Maria 3 | Ana group id | grupo...
asked by 30.05.2016 / 18:27
1
answer

Identify and archive old MySql records

I'm working on a project using database as MySql where some areas will be constantly fed generating a large number of records in a short time, as is the case of an area for maintenance tickets. However, this data becomes obsolete as quick...
asked by 30.05.2016 / 02:38
1
answer

sum of PHP and MySql values

Good afternoon, Friends I am creating here a system of notes to use in the company he is very basic, but I am in doubt on how to set up the payment function so that it identifies the values goes down the amount paid and create a balance. my tabl...
asked by 01.06.2016 / 19:19
1
answer

Mysqli Prepare with loop for Select

I am trying to make a SELECT using MySQLi and PREPARE in FOR but not working. It is always returning a single zero. Application code: if( $teste = $mysqli->prepare("SELECT COUNT(*) AS TOTAL_CONTATOS, 'data' AS...
asked by 13.01.2016 / 16:34