Questions tagged as 'phpmyadmin'

Tagged questions
0
answers

Problem running event with MySQL

Hey guys, all right? I have a question, I have the following SQL CREATE DEFINER = 'root'@'localhost' EVENT 'ut_clear_cart' ON SCHEDULE EVERY 1 MINUTE STARTS '2018-11-20 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO DELETE FROM ut_cart...
asked by 20.11.2018 / 13:35
1
answer

Different coding problem when registering data via PHP project or directly through MySQL [duplicate]

Friends, how are you? I'm learning about PHP and testing connections to MySQL I noticed a curious problem: If I am using phpMyAdmin and through it I insert records, with accentuation, in my table the information is normally displayed whe...
asked by 29.05.2018 / 22:37
1
answer

How can I enter data into two different tables?

I have created a function to insert information into two different tables, but it is displaying an error:    You have an error in your SQL syntax; ('mary', 2147483647, 'a' at line 2) My role is: function newUser($connect, $name, $reg...
asked by 14.06.2018 / 04:37
0
answers

Download bank data in csv format

I am trying to download the database data in csv format but it indicates that the SQL syntax is wrong. public void exportarBaseRespostaPI() { String banco = "b2wentregascorreios"; String tabela = "baserespmanifest"; String caminho...
asked by 09.05.2018 / 18:03
1
answer

Insert data into related tables using PDO

Hello, I have 2 tables with a foreign key, I need to insert data into it using the PDO library. OBS: I'm newbie so do not get heavy .. Tables: FormCode:<?phprequire'connect.php';?><html><head><title>CadastrodeCurso...
asked by 11.03.2018 / 17:48
1
answer

I can not access PHPMyAdmin - error # 1045

I can no longer access PHPMyAdmin. Until yesterday was normal, I did not change anything and today when I enter it is like this: (It is not access to a specific DB, it is for the general DB where the listing of all banks appears). Us...
asked by 22.01.2018 / 23:36
1
answer

PHP / Mysqli (phpmyadmin) I try to insert into the database, but there is no error

Good luck, I need help with the following: I want to insert 3 simple information into the database, product name, price and image. Out of the form I opened a tag to show the output, but only shows the name! and in the database do not appear new...
asked by 30.01.2018 / 09:57
0
answers

Queries with LIKE operator mysql

Hello! I'm having a problem while doing a search with like mysql. Mine table is type MyISAM, colation latin1_swedish_ci. I'm using php and queries using like are not returning expected results! If I search for example employees SELECT *...
asked by 18.01.2018 / 11:52
0
answers

The mbstring extension is missing. Please check your PHP configuration - Ubuntu

Hello, I try to access my phpMyAdmin but the error appears: The mbstring extension is missing. Please check your PHP configuration. Someone who knows how to solve this?     
asked by 12.12.2017 / 17:32
0
answers

Error trying to import database into phpmyadmin

I'm migrating a wordpress site from one server to another. I created a new MySQL database on the new server, but when I click on "import" I get this message. How to solve?     
asked by 08.12.2017 / 17:47