Most voted "phpmyadmin" questions
phpMyAdmin is a web application developed in PHP for Mysql administration over the Internet. From this system it is possible to create and remove databases, create, remove and change tables, insert, remove and edit fields, execute SQL codes and manipulate key fields.
Learn more…330 questions
Sort by count of
-
2
votes1
answer86
viewsSELECT returns nothing when I put a WHERE clause
When I run the following sql command I get an empty return, even if I indicate an id that is present in some rows of the table to be searched SELECT e.data_request, e.id_exchange, e.data_exchange,…
-
1
votes2
answers10718
viewsSearch the entire database
Is it possible to query or is there a phpmyadmin tool that does this: Query the entire database for example: I have the value 23600 and I want him to find that value in the entire bank independent…
-
1
votes1
answer1026
viewsHow to exchange a charset from a table to utf8 in a latin1 database?
I am trying to change the charset of a table to utf8 in a BD that contains all other tables like latin1swedish. I ran several commands and says it changed, it shows that that table is the only one…
-
1
votes2
answers2979
viewsView column quantities in each table
How do I get phpmyadmin to show me this: --- tabelas --- usuarios(5) clientes(20) admins(2) for example using some mysql command or even some phpmyadmin functionality?…
-
1
votes0
answers50
viewsAccess phpMyAdmin remotely
I’m having trouble accessing the phpMyAdmin external page. This is the first time I’ve tried to access it because it’s on an external server. There’s a user who can get in without any difficulty and…
phpmyadminasked 9 years, 7 months ago ChrisAdler 1 -
1
votes1
answer96
viewsError This table does not contain a Unique column
When viewing the tables shows me this message: This table does not contain a Unique column. Grid Edit, checkbox, Edit, Copy and Delete Features are not available. I cannot change mysql data. You do…
-
1
votes1
answer491
viewsphpMyAdmin with slow Xdebug on Windows 8.1 with Xampp
Boas, A while ago I noticed that my phpMyAdmin was stupidly slow (more than half a minute in a simple consultation)... After researching about this, I came to the conclusion that Xdebug should be…
-
1
votes1
answer891
viewsMake a select in a varchar column as if it were SQL datetime
The code is as follows:: SELECT data FROM lista WHERE data BETWEEN '01-08-2015' AND '05-08-2015'; The problem is that the date column is a varchar and I would like to use it as a date…
-
1
votes1
answer1776
viewsImporting a very large . sql file
I have a file about 192.2 MB in size. I tried to import it through Phpmyadmin, but he complains that the file is too big. I searched the internet for a possible solution to the case, and I saw that…
-
1
votes1
answer3743
viewsLogin using PDO
I’m developing a system of login with the pdo for learning, but it always accuses error in password. Follows the code: <?php session_start(); include "../../lib/inc_con.php"; $pdo=conectar();…
-
1
votes1
answer1281
viewsVarious products within an order
I am with the following problem, I have a sales registration system, and in these sales I can add a product for each order, but as I would add several products to 1 order ? Registration code of the…
-
1
votes1
answer384
viewsPhpmyadmin Import file size
I’m having trouble importing a 600mb . sql file. My PHP is already authorized to receive files of this size: memory_limit =1000M post_max_size = 1000M upload_max_filesize = 1000M max_execution_time…
-
1
votes0
answers31
viewsProblems with data type
My website is popping up like this http://www.adota-me.tk/anuncio.php?id_anuncio=1454792030 With some strange characters. I’ll tell you everything I put. In php this:…
-
1
votes1
answer620
viewsIs it possible to execute multiple queries in a single run?
I needed some data from a database in mysql. However, the data were in different tables, so the most obvious solution was to filter using relational tables, with the respective indexes. But I don’t…
-
1
votes1
answer344
viewsReset mysql Table automatically
I have a database that stores some leads, it is possible to reset the tables of this database every day at a certain time or until it reaches so many lines? Use phpmyadmin in Cpanel.
-
1
votes1
answer136
viewsMAMP - phpMyAdmin - Error
When I go into phpMyAdmin through Mamp, this error occurs: phpMyAdmin - Error Error During Session start; Please check your PHP and/or webserver log file and configure your PHP installation…
-
1
votes1
answer63
viewsHow to make modification records in a Mysql Table (without using triggers )?
I wonder if there is another technique to make records of modifications in the tables without going through triggers ?
-
1
votes0
answers37
viewsJava Script error in phpMyadmin desgin mode
When I try to save the organization of a table structure, using the design mode in Myadmin, I get a "fatal java Script error". That is, whenever I open this tool, the tables appear all disorganized,…
phpmyadminasked 8 years, 1 month ago Mr_sang 35 -
1
votes1
answer1275
viewsAllow null value in relationship field
I have a database MySQL with tables t1 and t2. One of the columns in the table t1 has a foreign key to t2. You need to allow the foreign key column to accept values null. Important data already…
-
1
votes2
answers66
viewsSQL filter (Result that should not appear)
is the following I am creating an online schedule and need to list the and show the times that are not scheduled, to show the schedules free. And for that I created the schedule_schedules table…
-
1
votes0
answers1210
viewsError: invalid or exchanged testimony in PHPMYADMIN
I’ve never seen this mistake before, on the Internet has virtually no information about it Error: invalid or exchanged testimony…
phpmyadminasked 7 years, 8 months ago Matheus Silva Itep 231 -
1
votes1
answer72
viewsAWS : Error installing php Myadmin
People installing phpmyadmin installed everything ok, however it gave problem when accessing the ip/phpmyadmin of the error : The mbstring extension is missing. Please check your PHP configuration.…
-
1
votes1
answer763
viewsConvert date format to php echo
Good afternoon, My database is saving dates in the following format "2017-04-19", I do not know if it has to change the data already registered in it and the way the data will be saved, so I chose…
-
1
votes0
answers49
viewsAjax with phpmyadmin
I have a form that records the data in phpmyadmin, but when the data is sent, the page of a Reload for php. I researched on ajax, and I saw that it can help me, but I did not understand very well…
-
1
votes0
answers541
viewsPhp my admin showing font code
I installed mysql, php and apache good so I restarted all and went to install php my admin until a problem arose at the time of launching the same in the browser it shows the source code, I tried to…
-
1
votes1
answer317
viewsSQL counting data from the second table of INNER JOIN, but shouldn’t?
I have 2 tables: sponsors quotas What I need to do is check how many nominees the sponsors have but only count the users who have the record in the table cotas. The SQL I made is as follows: SELECT…
-
1
votes0
answers90
viewsHow to create a file store?
How do I create a file store? Example: The person wants to save a PDF file on my website, then it goes there, click the send file button and gets saved on my system. And when she accesses, she can…
-
1
votes0
answers5187
viewsXAMPP - New Security Concept
I have a little problem with XAMPP, I’m not able to allow PHP Myadmin access to mobile. I’ve seen tutos on the Net, but nothing’s worked. Obs: The PC is 64bit, but only found the 32 Bit version to…
-
1
votes1
answer1338
viewsProblem with BETWEEN dates
I need a light for a question, I have a data filtering system (search) where I have to search for two Initial and Final dates. Since I have these two columns in the database, then when I run the…
-
1
votes4
answers1009
viewsConnecting PHP to the Mysql database
I need help I am trying to connect my PHP file with the database to be able to perform a query and present on the screen the records. Connection code: define('usuario_bd', 'root');…
-
1
votes1
answer68
viewsUPDATE SET Does not work on Mariadb
I have the following code on phpmyadmin, Mariadb UPDATE bairro SET NM_BAIRRO = 'Bairro' ,CD_CIDADE = 1 ,CD_ZONA = 1 WHERE CD_BAIRRO = 1 Someone can tell me, just because this command doesn’t work?…
-
1
votes0
answers1170
viewsPhpmyadmin does not open after sena default change
Good afternoon, everyone, After modifying the default Mysql password (In the Xampp interface), it no longer opens and displays the following error message: 1045 - Access denied for user…
-
1
votes1
answer30
viewsinsert Mutiplos data already having data in db
Great, I’m having a problem adding values to db. I want to add a value in a field that already has a value, without eliminating the value that is there, but by joining the two values separated by a…
-
1
votes1
answer16
viewsRestarting indexes for each new client
I need help from you. I have a small system that allows the registration of companies, and each one can contain one or more members. See a summary of the tables: //Tabela Empresa emp_codigo (chave…
-
1
votes2
answers188
viewsInstallation phpmyadmin
I’m trying to install phpmyadmin on a computer running apache 1.3.27. I did the installation normally, but when I try to access the phpmyadmin link the following error appears: The requested URL…
-
1
votes0
answers173
viewsError trying to import database into phpmyadmin
I am migrating a wordpress site from one server to another. I created a new Mysql database on the new server, but by clicking "import" I get this message. How to solve?…
-
1
votes0
answers216
viewsThe mbstring Extension is Missing. Please check your PHP Configuration - Ubuntu
Hello, I try to access my phpMyAdmin but error appears: The mbstring extension is missing. Please check your PHP configuration. Someone who knows how to fix it?
-
1
votes2
answers1167
viewsTake the value of a php session
I have a PHP session that saves the email of the logged in user. Then when this user is registering a text on this page below the text has to be saved with the email field being the one that is…
-
1
votes1
answer378
viewsDatabase does not work
I never made a form, so forgive me if I’m absurdly wrong. Here is the bank with the table: CREATE DATABASE db_formacao; USE db_formacao; CREATE TABLE `db_formacao`.`formacoes` ( `ID` INT( 5 ) NOT…
-
1
votes2
answers73
viewsNon-functional PHP Mysql database
I have a PHP form with a Mysql database generated by phpMyAdmin, but the database does not receive the information entered in the form. Follow the form code: <!-- content --> <div…
-
1
votes1
answer488
viewsLoop to Add values from a db
I’m making a financial control system, and I looped while to take the client data from a db and show them on a table. What I want to do is take the values of the column "PRICE" and add, to give the…
-
1
votes1
answer24
viewsInformation registered at the bank is exchanged
I have a form that sends the information to a bank and a page that takes this information and prints it in table format. However, the information in this table is appearing exchanged and when I try…
-
1
votes1
answer707
viewsUpdate does not update database records
In my system has a registration page and a page with a table with the information of registered. In this table there is an edit button that links with an equal form of the registration page. What…
-
1
votes0
answers105
viewsError in SQL Phpmyadmin execution
I am trying to include records by Phpmyadmin, but it is returning a strange error as excerpt below: Error #1054 - Unknown column '€ F’' in 'field list' Query: INSERT INTO `pe_orclinhas`…
-
1
votes1
answer196
viewsError - Display an image saved in the BLOB database
I have a php script that already does the insertion of images in the database, as shown below: <?php session_start(); include "conexao.inc.php"; setlocale( LC_ALL, 'pt_BR', 'pt_BR.iso-8859-1',…
-
1
votes1
answer388
viewsHow to make a ranking in php?
[Help] ranking in.php file illustrative image: http://prntscr.com/kl11df website image(main page): http://prntscr.com/kl12b3 image of the accounts created for testing: http://prntscr.com/kl13gz I…
-
1
votes2
answers538
viewsDifferent mysqli_fetch array output than the one running in phpmyadmin
I have the following php code that queries the database and returns a vector with the data. public function executeSelect($query){ $resultado_id = mysqli_query($this->objetoConexao, $query);…
-
1
votes2
answers171
viewsError #1064 in CREATE PROCEDURE - Phpmyadmin SQL
Message from Phpmyadmin: Mensagens do MySQL : Documentação 1064 - Você tem um erro de sintaxe no seu SQL próximo a '@NumeroSerie INT(11), @Velocidade TINYINT(4), @Direcao SMALLINT(6), @Latit' na…
-
1
votes1
answer33
viewsQuery mysql in phpmyadmin
Good afternoon guys, can someone please help me? I have two tables, Tabela1 and Tabela2, would like to enter the column data carro of Tabela2 in the column carro of Tabela1, but in their respective…
-
1
votes0
answers101
viewsProblem running event with Mysql
Eai guys, all right? I’m having a doubt, I set up 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…