Questions tagged as 'phpmyadmin'

Tagged questions
4
answers

Write MYSQL data in pt-br / UTF8 format

How do I save data in the database in Brazilian format with accents, I used this in connection mysqli_set_charset($conexão, 'utf8'); But now my code is all in PDO how do I save this data in utf8 in PHPMyadmin database? <?php /...
asked by 15.10.2015 / 01:45
1
answer

MySQL Error 1064

In the insert below I get the following error. INSERT INTO dump1090 ('hex','squawk','flight','lat','lon','validposition','altitude','vert_rate','track','validtrack','speed','messages','seen') VALUES ('e4827e','3670','TAM3754 ','-22.850818','-4...
asked by 28.11.2018 / 17:30
1
answer

AUTO_INCREMENT MySQL problem

I had a problem that from ID 35218, the accounts started to be inserted from ID 400000, but I do not remember having tampered with the value of AUTO_INCREMENT. What can I do to get the accounts back to the lowest empty ID?     
asked by 09.10.2018 / 02:43
2
answers

SQL Updating Wrong Value

I'm creating a QUERY to change every day of the dates recorded in the DB for the last day of the month of that record ... what happens is that when I play QUERY by selecting a record in month 5 (May) it updates the value of the day with 30 ......
asked by 03.08.2018 / 16:22
2
answers

Unrecognized keyword "as"

I'm using MYSQL together with PHPMyAdmin 4.7.4, and he accuses the 'as' keyword is not recognizable, but when running it it goes in infinite loop, and does not show any results. SELECT c.'nome', case c.'id_estado' when c.'...
asked by 16.05.2018 / 07:33
3
answers

Form data is not being registered

I have a form written in php with connection to a bank administered by phpMyAdmin. WHAT SHOULD HAPPEN: The data entered in the form should be registered with a alert "saved successfully" and returning to the previous page. WHA...
asked by 04.08.2017 / 14:37
1
answer

Time difference in execution of the same query between PHP and PHPMYADMIN

I'm trying to improve the performance of my pages to improve the user experience, but I'm not able to identify the problem. According to Google, it is recommended that pages respond in less than 0.4 seconds, but only the connection to the dat...
asked by 19.07.2016 / 15:27
1
answer

DROP DATABASE in phpMyAdmin

How do I enable DROP DATABASE in phpmyadmin? Every time I try to drop a bank it gives an error saying that the command is not enabled. I'm using phpMyAdmin in WAMP on my local machine.     
asked by 24.10.2014 / 20:10
2
answers

Error writing date converted to phpMyAdmin database

I'm trying to write a form to the database, in that form there's a date field that contains dd/mm/aaaa mask. To write to the bank I need to convert that date to aaaa-mm-dd , until then I got str_replace , the problem is that w...
asked by 07.11.2018 / 14:17
1
answer

How to get information that is in 2 tables mysql [duplicate]

Table 01: $file Table 02: $users I want to do so, when a user for level ID = 30 displays a msg EXAMPLE, FILE 01 ( $file->userid = 20 that is, this user id is in table 02, $users->id ) TABLE $ FILE...
asked by 31.07.2018 / 00:53