Questions tagged as 'mysql'

1
answer

Save date and time in the database

I would like to know if I have save the date and time of my system to be able to save in the database, I would not like to create a "created_em" and add the time in the database, what I want to do is " complex "I think, I'm trying here but I did...
asked by 24.08.2017 / 21:13
1
answer

I do not connect to the Panel (Codeigniter)

Good evening, I made a script for content management but when I put my data does not connect, just refresh the page and stay in the same place, put a command to give error but not even that. application \ views \ admin \ login.php: <?php...
asked by 17.08.2017 / 02:12
0
answers

Turning rows into columns

I would like to convert some table values into columns. The structure of the table would be basically this: | id | idUnidade | mesCompetencia | valor | |----|-----------|----------------|-------| | 1 | 237 | 2017-05-01 | 35 | | 2...
asked by 17.08.2017 / 20:16
1
answer

How to maintain a constant connection with the database for updating data without the need to refresh

I have an application that is working with MySQL database and PHP. There is data in this bd that is updated frequently because it is a vote, but this vote occurs on an external website and my site only displays the rank with the total votes....
asked by 19.08.2017 / 22:44
1
answer

I do not receive data from SELECT FROM

I'm doing a simple login system but I never get a real line where $sql = "SELECT * FROM $this->table WHERE 'email' = :email AND 'senha' = :senha"; But the email and password are correct, PHP Function: public function logarUsuario(){...
asked by 19.08.2017 / 20:29
2
answers

Login with user or email in the same field [duplicate]

Hello! I have a login code, but I can not get the user to log in with your email or username using the same field! Below is my code, the email on my base date is named "mail".     
asked by 19.08.2017 / 04:04
1
answer

Querying with duplicate data in MySQLi

Hello. I'm having trouble displaying the result of a query in the database. I have 2 tables Tabela 1 - logs // logs do sistema //user_id = são os usuários administrativos do sistema //user_perfil = é o perfil do usuário que usa o sistema...
asked by 16.08.2017 / 17:14
0
answers

Email search without domain

I am doing a query to receive various data from DB, which involves entering the email field, but I do not want to do searches that show emails because of the domain. For example, I have an email " [email protected] " With the following quer...
asked by 07.08.2017 / 13:52
1
answer

Ajax and PHP Update

I'm having a problem editing the database values. My Script Code: $(function(){ $(document).on('click', '#salvar_pedido', function(e) { e.preventDefault; var id = $(this).closest('tr').find('td#id').html(); var nome = $(this).clos...
asked by 06.08.2017 / 22:28
1
answer

How to give permission to write temporary files in the c \ windows \ tmp folder with laravel 5.4?

I would like you to help me solve this problem: How to give permission to write temporary files in the c \ windows \ tmp folder with laravel 5.4?     
asked by 06.08.2017 / 03:51