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
-
0
votes1
answer74
viewsHow to make an Insert in this table
I have a registration of vehicles, which has a combo box with the years for the user to choose, these years come from the table "year". When I complete a registration of a new car, I have to give an…
-
0
votes1
answer68
viewsSeparate data in table
I would like to make a table separated by "seasons". Example: Tabela estatisticas: Temporada 1: ID | JOGADOR | PTS | AST | 0 | Leonard | 12 | 7 | 1 | Pedro | 10 | 5 | Temporada 2: ID | JOGADOR | PTS…
-
0
votes2
answers261
viewsTranslate mysql_query to PDO "UPDATE * SET... WHERE..."
Hello, I recently started translating my sites to PDO for obvious reasons. Yet this one is giving me a bit of a headache. $sql = mysql_connect("localhost", "user", "pass") or die(mysql_error());…
-
0
votes0
answers102
viewsCalculated field
Good afternoon, I have a database made using the phpMyAdmin tool, but based on SQL. The database has a table that has a calculated field. The table has 6 records, but when I do the command for the…
-
0
votes1
answer1652
viewsHow to create a Trigger for a specific column of a table?
I created a Trigger to my table X, with the purpose of making a record of update that run you in this table. For each update on the table X, modified (old) values are stored in the table Z.…
-
0
votes1
answer58
viewsColorize a column field according to parameters
I have a table with five columns and two records. One of the fields in the record is a number (notaQualif), I need the field in which it is inserted to be painted green if it is greater than 75 and…
-
0
votes2
answers44
viewsFile sharing - php
Good afternoon, I have a website to share information, and my question at this point is how can I share information only for certain users who are chosen by me? In the database I have User -cc,…
phpmyadminasked 7 years, 7 months ago Zeantonio 3 -
0
votes1
answer531
viewsError trying to log into localhost by Phpmyadmin
I am trying to connect to my local database and am getting the following errors: #1045 - Access denied for user 'root'@'187.20.253.86' (using password: NO) mysqli_real_connect(): (HY000/1045):…
phpmyadminasked 7 years, 6 months ago Francisco 7,472 -
0
votes2
answers2936
viewsInsert special mysql characters and pull these identical values in the web application
Good evening, I need to add values to the database by mysql so that they have special characters. I can add, but I can’t pull the values correctly, they end up coming with symbols in place of the…
-
0
votes0
answers40
viewsinsert balance into db only after confirmation
I am making a system for controlling expenses/revenues, and I want to know how to make the amounts of revenue or expenditure if they add to the balance only after confirmation of payment. Ex:…
-
0
votes0
answers661
viewsI can’t start Mysql on Easyphp
Whenever I use Easyphp I cannot start Mysql and Apache starts normally. What I can do?…
-
0
votes0
answers1736
viewsDifficulty interpreting database diagram
Good evening. I am having some problems interpreting a diagram that from it I will make a sql database. My programming skills are not very good and I would very much appreciate a help. In case I…
-
0
votes0
answers490
viewsinsert into two tables at the same time with php
I’m in trouble. I have the tables usuario and aluno which are related by primary and foreign key. I want to make an insertion with php to insert data into the two tables, the idusuario table usuario…
-
0
votes0
answers92
viewsUpdate table after payment completed PHP
Good I’m trying to automate the release of products in my store so I made a purchase status system only that does not update the line that was paid or create a new line Behold:…
-
0
votes1
answer63
viewsRun ID in sequence without auto increment
I have a bank problem. When registering a user the ID is set to 0. I try to use Auto Increment, but when I activate this option, the other entries stop working.
-
0
votes2
answers268
viewsAzure phpMyAdmin error: Access denied!
Sometimes, during my work developing my app on Azure, I come across this situation: I use Chrome browser My Mysql database: MySQL no Aplicativo so I only use for one application. Any suggestions on…
-
0
votes0
answers20
viewsSave database data in array?
I have a database where saved email and file names attached by users, which can attach more than one file, and would like to show all the files that the user attached on the screen, I thought to…
-
0
votes1
answer91
viewsData being multiplied in the table
I have a register of recipes and this register has a button that clones the fields "amount of ingredients" and the "combo box of ingredients". If I add only a quantity and ingredient, the…
-
0
votes1
answer137
viewsHow to update a different table with data from another table in PDO
I have a pay-as-you-go table, and in it I have an indemnification code for every transaction, when receiving the update data, I want to take the data and enter in update in another table of the…
-
0
votes1
answer512
viewsHow to do an INNER JOIN by bringing specific fields from two tables and removing the repeated records and with a max condition?
Well, I have the following tables: Table 01: And table 02: There I would like to bring only all fields with higher points and do not repeat the waiter in the case, how to do?…
-
0
votes2
answers981
viewsPHP/Mysql - Switching from localhost to online hosting
I created a website with PHP and a Mysql database using XAMPP. Now I’d like to put the site online on a host, I have to change the connection to the database where it says localhost? What procedures…
-
0
votes2
answers104
viewsSql file or direct in the database
Today a question came to me, I was creating a table in the database and I found out if I should do it manually, directly in the database or create this table through queries, creating a page .sql.…
-
0
votes0
answers33
viewsHow to take a value within the array
I would like to know how to get the value of this array Array ( [TIMEDIFF('2017-12-14 17:44:14', '2017-12-14 16:12:21')] => 01:31:53 ) I’ve tried to $timEnd =…
-
0
votes0
answers285
viewsSum hours obtained through a query in mysql
SELECT TIMEDIFF( atendimento_ticket.close_atendimento, atendimento_ticket.open_atendimento ) AS duracao FROM atendimento_ticket WHERE id_tec =…
-
0
votes1
answer32
viewsI have two grouped entries but only one is changed in the update
I set up an update by grouping the field presenca which should change two arrays in a repeat loop, follows the query: UPDATE acessos AS a JOIN ( SELECT usr_id, presenca FROM acessos GROUP BY…
-
0
votes4
answers152
viewsUsing Mysql how to create a Select that searches "together" words
In Mysql how to create a select that searches "together" words. For example: SELECT pessoa FROM tabela WHERE pessoa like '%josedasilva%' But in this way nothing returns. Because it is registered as…
-
0
votes1
answer137
viewsSynchronization of Phpmyadmin tables
I needed help in PHP My Admin on synchronizing fields in different tables and in the same database. For example: Database: Data Base Test Table test1 columns: - col1 - col2 Table test2 columns: -…
-
0
votes0
answers46
viewsGenerate random characters in SQL
Hello, I have a question in PHP My Admin which is as follows: -I have a table that I need to put as default value in a column a random value. Someone could shed some light on this matter? I know how…
-
0
votes1
answer219
viewsForm does not receive registered data
What’s going on: I have a system that, after completing the form and saving, does not save the changes by appearing a alert "saved without changes" and back to previous page. It does not seem to be…
-
0
votes1
answer197
viewsMysql return JSON
I am trying to do this example but, is giving error: #1582 - Incorrect Parameter Count in the call to Native Function 'JSON_OBJECT' SELECT JSON_OBJECT('City', Name, 'Dist', District, 'Pop',…
-
0
votes3
answers978
viewsForm data is not being registered
I have a form written in php with connection to a database administered by phpMyAdmin. WHAT SHOULD HAPPEN: The data entered in the form should be registered showing a alert of "successfully saved"…
-
0
votes1
answer45
viewsMysql syntax problem generated by Phpmyadmin
I have a problem when Myadmin generates a table creation script. The Script: CREATE TABLE `crud_ABC`.`cliente_ABC` ( `id` INT(10) NOT NULL AUTO_INCREMENT , `nome` VARCHAR(300) NOT NULL , `valor`…
-
0
votes0
answers96
viewsphpmyadmin on Nginx
Well, I installed Ubuntu server 16.04 on my local computer, but when I access the phpmyadmin it from error 404. I’m accessing the ip_local/phpmyadmin address Here is my virtual server phpmyadmin:…
-
0
votes2
answers893
viewsDisable ONLY_FULL_GROUP_BY at once
How do I disable ONLY_FULL_GROUP_BY it remains disabled for good? I wonder why I already did the steps below: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); and also…
-
0
votes1
answer3831
viewsI cannot log into phpmyadmin
Right now I’m studying shared file cloud services like Owncloud and Pydio. I am using Debian 9 as a machine. I installed xampp on it. I entered the phpmyadmin settings normally and went to put…
-
0
votes1
answer51
viewsIs that a server error?
I have developed an application in which on my local server is working perfectly. So when I put on the web server is returning me the following error: Fatal error: Class 'mysqli' not found in Can…
-
0
votes0
answers77
viewsCreation of EVENT in PHPMYADMIN
Next, I have a game server and I’m trying to automate the purchase of cash on my site ( the user buys cash to spend on the game ). I have a table in my bank called USERS: user_id (A.I) user_name…
-
0
votes4
answers4522
viewsCount number of records in a Mysql table with PHP?
Guys, I have a database with a table called "users", and I would like to know how I do, through PHP, count how many records there are in this table, and then give an echo to show this amount on the…
-
0
votes1
answer42
viewsProblem inserting special character in Mysql
When I insert some information in Mysql through the form in my system is saved all wrong in the BD, the characters ç, `Uga everything, but insert manually in the right phpmyadmin. In HTML I put the…
-
0
votes1
answer302
viewsProblem running SELECT in a phpmyadmin table
I have several tables in my database, and until recently, there was no problem in any of them. I was able to manage the entire bank smoothly by Phpmyadmin. But suddenly in one of the tables the…
-
0
votes0
answers844
viewsHow to access Virtual Host from another pc on the same network
I want to access my site that is in #PC1 by mobile or #PC2, but I can only access it by the computer itself where it is, and if I try to enter from another computer only works if I put the IP of my…
-
0
votes1
answer70
viewsForm submission settings
Well guys, what happens... I created a php form to insert in my project, it happens that, always gives some error when sending, and the times I managed to send did not send all the data but only the…
-
0
votes2
answers102
viewsHow to take the last inserted values from two tables, and sort them by the last access?
I need to create a select who picks up the id's of two tables, unite them and show me the last record of the two together. I tried so: SELECT DISTINCT p.cod_mobilibus, p.nome, q.dt_acesso FROM…
-
0
votes1
answer1051
viewsMysql error - phpmyadmin: Access denied!
I have this problem with phpmyadmin, it was working normal, but when I typed: "mysql" in the linux shell it did not open mysql, only when typing: mysql -h 127.0.0.1 -P 3306 -u root. Then I saw some…
-
0
votes0
answers84
viewsLogin System - HTTP ERROR 500
I am making a login system, but when submitting the data it from HTTP ERROR 500. I tried to change the code anyway but this error continues. I am using 000webhost to test how the site is getting,…
-
0
votes2
answers82
viewsSQL Updating Wrong Value
I am creating a QUERY to change every day of the dates registered in the BD to the last day of the month of that record... what happens is that when I play the QUERY selecting a record in the month…
-
0
votes1
answer401
viewsCreate Slug across MYSQL database
I have an older MYSQL database and in it I have a news table and I needed to create a "Slug" column to save Slug from the news. Therefore, I would like to create an automatic Slug for all records…
-
0
votes1
answer98
viewsPhpmyadmin does not save file if you already have one saved
I made a code to save the name of a file in the Phpmyadimn database, it works if the table is empty, but when I try to attach another file it error, does anyone have any idea why this occurs?…
-
0
votes1
answer35
viewsJoin in sql that returns everything
I have two tables, the episodes and episodes seen, I need to make a query that will join the two by the id of the episode, however I do not want the episodes that are not in the second table do not…
-
0
votes1
answer568
viewsConvert entire mysql database to lowercase
It is possible convert all columns of tables in a database mysql for lower-case letters? I have several records and several tables, all are a patchwork of upper and lower case (and some with…