Questions tagged as 'mysql'

Tagged questions
1
answer

How to use the between command in codeigniter to generate report

I need to generate the following report: The user selects the time interval (start date and end date) and the revenue report is generated showing the value of the added revenues. Here is the photo of the view that calls the function in the...
asked by 17.07.2018 / 23:47
1
answer

Error getting data from input radio

Well, I'm having the following problem while submitting the form: Hereispartoftheformcodeandvalidation:<divclass="form-group"> <label for="sexoFunc" class="control-label col-sm-2">Sexo:</label> <div class="radio...
asked by 24.05.2018 / 15:18
1
answer

Filter records by date

My code is not working what might be wrong? In the database the date is with Date / Time as datetime , follow the code: <?php $query = $mysql->query("SELECT * FROM c_clientes WHERE cliente_data_cadastro...
asked by 07.05.2018 / 16:22
1
answer

Save more than one PHP and MYSQL record

How do I give an update on more than one record, for example it appears in the notes.php page the following information: Thisinformationisfromabank,soeachstudentisidsdifferent.MyproblemiswhenIclickthesavebutton,becausewhenIclickititonlysaves...
asked by 08.05.2018 / 22:31
1
answer

MySQL compare a number with string returns true if string starts with number

I have the following table in the database: idUser - Username - Group 1 - John - 5GR 2 - Doe - 1GR And the following query: SELECT * FROM 'table' WHERE 'idUser' = '$name' OR 'Group = '$name' $ name is the variable that conta...
asked by 24.05.2018 / 11:18
1
answer

Convert .FRM to .SQL

I have a database of 300MB and I only have the FRM, MYI and MYD files. I need to convert the FRM files first to create the structure of the tables, I have already used the following tools and methods and I did not succeed: link Error: ER...
asked by 11.09.2018 / 01:17
1
answer

Searching and displaying results 2 tables mysqli / php

I wanted to search 2 tables (news and photos) and then display the results of this query below. But the fields I have in each table are different and I'm not able to work out a way to display the results because of that. News table fields: Ti...
asked by 11.09.2018 / 20:46
2
answers

Safer way to encrypt passwords in MySQL? And the easiest? [duplicate]

What would be the safest way to encrypt passwords in MySQL? And the easiest? I am using a MYSQL database, with the removal of the PASSWORD function I would like to know another way to encrypt.     
asked by 14.09.2018 / 21:27
1
answer

Array split with array_push for multiple INSERT in SQL

I have a foreach looping in a file's data, this loop generates some values that are entered in array with array_push , precise break those values entered in this array to generate multiple INSERT INTO because...
asked by 01.05.2018 / 04:10
2
answers

Concatenate CPF in Mysql

Good Afternoon I would like to know how to concatenate 11 digits in the form of a CPF. Type, format for a CNPJ, I did this: update ger_ter set cpfcgc = CONCAT(SUBSTRING(cpfcgc, 1,2), '.', SUBSTRING(cpfcgc,3,3), '.', SUBSTRING(cpfcgc,6,3), '...
asked by 30.04.2018 / 20:00