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
-
1
votes0
answers637
viewsQueries with mysql LIKE Operator
Hello! I’m having a problem doing a search with like mysql. My table is type Myisam, colation latin1_swedish_ci. I’m using php and queries using like are not returning expected results! If I look…
-
1
votes1
answer156
viewsPHP/Mysqli(phpmyadmin)
Good guys, I need help with the following: I want to insert 3 simple information in the database, product name, price and image. Outside the form I opened a tag to show the output, but it only shows…
-
1
votes2
answers94
viewsPHP site does not read special characters
The Site they sent me (I am an intern) is in trouble because it is not reading the special characters. I’ve noticed the famous charset UTF-8, but when I went to look at the databank, the collation…
-
1
votes2
answers343
viewsselect Count within select
With the query below this returning the total values of each month, however I need to count the quantities of times each item has in each month. SELECT instancia, (SELECT COUNT(instancia) FROM urt…
-
1
votes0
answers80
viewsDownload database data in csv format
I am trying to download the database data in csv format but it is indicating that the SQL syntax is wrong. public void exportarBaseRespostaPI() { String banco = "b2wentregascorreios"; String tabela…
-
1
votes1
answer158
viewsDifferent coding problem when recording data via PHP project or direct from Mysql
Friends, all right? I’m learning about PHP and when testing connections with Mysql I noticed a curious problem: If I am using phpMyAdmin and through it insert records, with accentuation, in my table…
-
1
votes1
answer577
viewsI’m trying to create a Mysql Trigger but is giving syntax error
CREATE TRIGGER comissao ON tb_Pedido FOR INSERT, UPDATE, DELETE AS BEGIN DECLARE v_codFuncionario INT DEFAULT NULL; DECLARE v_dataPedido DATETIME(3) DEFAULT NULL; DECLARE v_valorComissao…
-
1
votes1
answer70
viewsHow can I insert data into two different tables?
I created a function to insert information to two different tables, but it is showing an error: You have an error in your SQL syntax; check the manual that Corresponds to your Mariadb server version…
-
1
votes1
answer114
viewsSyntax error in SELECT MAX
I have a syntax problem in my sql code inside the php code, I need to know which video has the biggest id in the database to save it in a separate folder with the same id number, so that the path is…
-
1
votes2
answers100
viewsRemaining minutes between field and dateAtual
I am trying to create a direct query in mysql where I must return some value if the time interval of the current date and my datareg field is 02 minutes. SELECT * FROM tabelax WHERE grade = 19 AND…
-
1
votes1
answer35
viewsQuery to list the amount(Count) of records for a Foreign key
I’m trying to create a query that lists how many times a Foreign key has appeared from another table but I’m not getting it. I wanted to count how many times each customer appears in the order,…
-
1
votes2
answers1607
viewsI can not put foreign key in PHPMYADMIN
I have my bank already created in phpmyadmin, are two tables, payments and students. I have seen several tutorials and read various ways of how to put a foreign key (fk_alunos) id_students in my…
-
1
votes2
answers114
viewsHow to check whether data already exists or has remained blank?
I was testing the registrations of the site I did, and I noticed that I managed to register the same username 2 times, even having declared "UNIQUE" in the table. And another thing, I also noticed…
-
1
votes1
answer72
viewsTake larger ID and insert Bank
My doubt is the following need to take the ID with higher value and enter the information in it. The PHP file is working but I need it to identify the ID with higher VALUE and insert it instead of…
-
1
votes3
answers228
viewsHow to insert multiple arrays at the same time in the database?
I have a table and each row has 6 inputs that must be saved in the database as a product. The system has a button in HTML, which adds another line with 6 inputs, that is, when clicking on submit I…
-
1
votes1
answer135
viewsError while generating XML
I made a system in PHP to display XML file, but is giving the following error: This page contains the following errors: error on line 29 at column 1: Extra content at the end of the Document Below…
-
1
votes1
answer51
viewsAdd values to a database by PHP
I’m trying to add values to a database through PHP. I am using Phpmyadmin for both databases and also for the site in question. At this point the code I have is the following, I present my doubts at…
-
1
votes2
answers240
viewsHow to sort a table according to data from another table
I have two tables Table 1 create table tb1 ( cd_tb1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY ); Table 2 create table tb2 ( cd_tb2 INT NOT NULL AUTO_INCREMENT PRIMARY KEY, cd_tb1 int, vl_avaliacao…
-
1
votes1
answer348
viewsDisplay photo of logged-in user from SESSION
I’ve been having trouble with this PHP code for days. I’m developing a simple user registration system, but I’m using access levels, so far so good! I can already display the user name through…
-
1
votes1
answer64
viewsShow in PHP a query that is done directly in phpMyAdmin
I have a query ready (I didn’t do it) that every month I change the values of the months, copy and paste in phpMyAdmin (in the SQL tab) to run. She presents me with a very beautiful and structured…
-
1
votes3
answers216
viewsHow to take the value of a Database table field and use it in a PHP variable?
I have the following question: I have a condition if else in php the problem is that I need a value inserted into a field in the database table for the script fulfil the condition of if or of else.…
-
1
votes1
answer37
viewsReplace random text between two known strings
I need to replace a random text between two fixed strings in a database created by Wordpress. Database: "database" Table: "wordpress_posts" Field: "post_content" ID: "6450" For example, I have the…
-
1
votes1
answer550
viewsPHP Friendly URL: Does not load files from Folder
I have in my root directory the index.php file and config.php. Inside the root folder of my site I have the pages folder with the home.php, login.php and Register.php files, but when I try to access…
-
1
votes0
answers48
viewsPass page via $_GET and manipulating the URL via . htacess
I have a page in PHP that shows the products in general (products.php): <?php include_once("conexao.php"); $query = "SELECT * FROM produtos"; $result_query = mysqli_query($conn, $query); ?>…
-
1
votes1
answer39
viewsProblem with coding in phpmyadmin on remote server
The problem is this. I am developing a site locally in PHP with access to database and I am facing coding problems, but this problem only happens in hosting, works normally on the local server.…
-
0
votes2
answers1879
viewsactivating the phpmyadmin
I am running XAMPP, however my phpmyadmin is disabled I have done everything to activate, there is some other option, follow below the error. #2002 - File or directory not found Server not…
-
0
votes1
answer1367
viewsHow to create mysql.socket file
I’m using the phpmyadmin because, it is returning me an error that refers to the missing file mysql.sock, there is a possibility to install this file? Error reported below: error 2002 : file not…
-
0
votes1
answer1025
viewsPackage duplicity error updating Ubuntu 14.04
In Ubuntu 14.04, I am trying to update the Repositions with apt-get update. However, stop at the duplicity error below. I’m doing the procedure to install phpmyadmin. Thanks for your help. # apt-get…
-
0
votes2
answers4154
viewsDROP DATABASE in phpMyAdmin
How do I enable DROP DATABASE in phpmyadmin? Every time I try to drop a bank gives error saying that the command is not enabled. I’m using phpMyAdmin on my local machine’s WAMP.…
-
0
votes1
answer993
viewsMysql does not connect to server
Hello, I went to enter the phpmyadmin and appeared this, where should be the problem ?? Code $coneccao = mysqli_connect("localhost", "root", "MINHASENHA"); mysqli_select_db($coneccao, "luppbox");…
-
0
votes1
answer31
viewsError in mysql query
I am hours away from realizing what is wrong with my query. I would like you to give me a help SELECT `recargas`.`valor_recarga` as saldo FROM `contas_pessoais` INNER JOIN `contas` ON…
-
0
votes0
answers183
viewsDifferent results for Mysql 5.1 and 5.7 query
We developed a project for a client using Mysql 5.1.68 and at the time of publication we identified that the client’s hosting had version 5.7.4. After publishing the project, we started to check…
-
0
votes1
answer654
viewsError to import mysql table into phpmyadmin
I have a problem to import a table in phpmyadmin. Table: CREATE TABLE ManterEmpresa ( IdEmpresa INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, CNPJ INTEGER UNSIGNED NOT NULL, NomeEmpresa VARCHAR(45) NOT…
-
0
votes4
answers842
viewsWrite MYSQL data in en / UTF8 format
As I do to save data in the database in Brazilian format with accents, I used it in connection mysqli_set_charset($conexão, 'utf8'); but now my code is all in PDO as I do to save this data in utf8…
-
0
votes3
answers3932
viewsHow do you configure phpmyadmin on linux?
I gave one apt-get install phpmyadmin and linux did the installation in the folder etc; rode in the browser http://localhost/phpmyadmin and gave error 404. I changed and played the phpmyadmin folder…
-
0
votes0
answers183
viewsPassword Bitnami Moodle
I’m trying to access the Phpmyadmin in the Moodle of Bitnami and I can’t get in, I just installed it and I don’t know the password to root, waiting for answers... I tried to leave no password and…
-
0
votes1
answer316
viewsHow to increase sql file size in phpMyAdmin?
How to increase the size of sql files, for import, in phpMyAdmin, from MAMP?
-
0
votes1
answer132
viewsSelect PHP + Mysql
Guys, I’m a beginner in web programming and I’m having trouble creating a CRUD, the insert worked OK, but the next step is SELECT is not running as it should and I would like you to help me see what…
-
0
votes0
answers429
viewsphpMyAdmin Error "Error During Session start; Please check your PHP and/or webserver log file and configure your PHP installation properly."
error_log [Sun Jun 05 16:58:42.851072 2016] [ssl:warn] [pid 1851] AH01909: localhost:8443:0 server certificate does NOT include an ID which matches the server name [Sun Jun 05 16:58:43.036199 2016]…
phpmyadminasked 8 years, 5 months ago MatheusVieira 45 -
0
votes1
answer2051
viewsHow to put auto increment in php myadmin
I am using PHP my admin, but n is showing the auto increment option, what can I do?
-
0
votes1
answer520
viewsTime difference in execution of the same query between PHP and PHPMYADMIN
I am trying to improve the performance of my pages to improve the user experience, but, I am not able to identify the problem. According to Google, it is recommended that the pages respond in less…
-
0
votes0
answers28
viewsSync failed? Myworkbench 6.3 --> phpMyAdmin
Good people, I’d like you to clear up a question for me and, if possible, help me. I designed a data model (myWorkBench) and then synchronized the data model.. After that, I have access to the…
-
0
votes0
answers186
viewsRecover Database data to Android using php!
I need to retrieve the name, message, lat, long data from php. The problem is being in the part of Android, what I need to do to recover this data from the Activity "Android Part" saving these in…
-
0
votes1
answer57
viewsHow to show a block field a word according to certain parameters?
I need to display a name in a form field with buttons. If the user selects the number 1 in the previous field, in the next field in block mode (so that it is not modifiable by the user), he should…
-
0
votes0
answers32
viewsHow to change database already in use, with data inside?
I have a database with data inside. I need to change the colletion of a certain data from a bank table. How can I do that? The reason is that I’m not able to register accounts with accentuation.…
phpmyadminasked 7 years, 9 months ago GustavoSevero 2,567 -
0
votes1
answer66
viewsIF Mariadb phpmyadmin
I’m trying to create a Rigger using phpmyadmin with Mariadb bank but when it gets on the line if it gives a message: unrecognized statement type. (near IF) Trigger is the one: SET @TOTAL = (SELECT…
-
0
votes1
answer1315
views404 not found - phpmyadmin/Ubuntu
I am using Ubuntu and installed LAMP correctly. I open PHP applications on localhost quietly, but when I try to access the localhost/phpmyadmin he shows me a erro 404 Not Found. I’ve seen several…
-
0
votes1
answer28
viewsDoubt with this query
My teacher made the following query, to show the total amount of stock of each product, however I do not understand very well how it does to generate the total stock quantity of each product,…
-
0
votes2
answers1381
viewsHow to create a Rigger to save updates from two tables?
I have two tables : Tabela1 : three-column id_product, product name, product price; table 2 : four-column id_brand, id_product, tag, price_tag; I created a new Tabela3 : three-column id_product,…
-
0
votes1
answer102
viewsSelect Mysql query used ports?
Personal I am needing to make a query from which return me the unused values, using 3 tables from which return me which ports are not being used in a network switch first table sw_local id, nome…