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
votes2
answers75
viewsForm data is not registered in the database
Guys help me. Next: I have here an html form which I send the form data to an email through the action. Only, before sending it to the email I want that same data to be entered in the database. For…
-
0
votes1
answer71
viewsMysql IN function but my parameter comes a string
Hello, I have a trial that receives a few parameters, among them I need to receive a list of codes, which are 10 at most. But in the consultation, I’m trying to WHERE value IN(value1, value2), but…
-
0
votes1
answer278
viewsCan I create an event in Phpmyadmin?
I want to create an event in Phpmyadmin, where each day implements +1 in a field like int, but on my local server works normally, on hosting says I need the user super global, all right so far,…
-
0
votes2
answers1136
viewsInstall PHPMYADMIN on linux with php5.6
Hello, I am configuring a machine with php5.6, I have installed and configured apache, php5.6 and mysql, now I want to install phpmyadmin, the problem is that when trying to install through apt it…
-
0
votes1
answer598
viewsAUTO_INCREMENT Mysql problem
I had a problem that from the ID 35218, the accounts started to be inserted from the ID 400000, but I do not remember having touched the value of AUTO_INCREMENT. What can I do to get the accounts…
-
0
votes0
answers22
viewsphp system transport errors to another computer
I have a system that works perfectly on the computer(A) that was developed and, when passing to the computer(B) server with the same settings, the same version of Easyphp(5.2.10) and etc, presented…
-
0
votes1
answer499
viewsCreate Procedure in phpmyadmin
I am trying to create a precedent that changes between Insert and update in phpmyadmin but returns me an error in the line of if EXISTS, then I tried to create by the graphical panel and returns me…
-
0
votes1
answer54
viewsMysql 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…
-
0
votes0
answers75
viewsError Connect to Database?
Well I’m trying to make a connection to a database and is giving the following error "ERROR: SQLSTATE[HY000] [2003] Can’t connect to Mysql server on '167.114.173.210' (13)" And I have a program…
-
0
votes1
answer177
viewsQuery works in phpmyadmin, but does not work in PHP
I’m trying to do a query via php in Mysql , but it’s not working in PHP, but it works in PHPMYADMIN. $check_in = strtotime($arrival); $check_out = strtotime($departure); Queries I’ve tried in PHP...…
-
0
votes1
answer594
viewsLinting is disabled for this query because it Exceeds the Maximum lengt
next I’m having a problem in mysql which is as follows, when I register an image in the text editor of my content manager, this image is converted to Base64, this editor is summernote, however the…
-
0
votes1
answer478
viewsChange Login button to logout
First of all I want to warn you that I am a beginner in PHP and I appreciate help because I need to deliver a work and I am in Deadline I have a login button and I want you to switch to logout when…
-
0
votes2
answers53
viewsUpdate data associated with a specific name in a PHP and SQL database
UPDATE: This question will be long - notice that I am very inexperienced in PHP. I have been (trying) to create a web page that can access a database created in Phpmyadmin in the last few days, this…
-
0
votes1
answer162
viewsTable already exists when creating a new mysql table, even if it does not exist
I have a database from which I accidentally delete a table and when I try to recreate it, it says that the table already exists, but it doesn’t appear. When executing the command: SELECT * FROM…
-
0
votes1
answer39
viewshow to connect to Phpmyadm database?
he make that mistake here: Uncaught Error: Call to Undefined Function mysql_connect() I can’t connect to the database.…
-
0
votes2
answers58
viewsProblem sending something to database
So, I’m trying to create a page, really simple, to send some things to the database, (id,username,code_placa) but I’m not able to, when removing the lines that give error, the page opens, however,…
-
0
votes0
answers33
viewsProblem with JSON extension in phpMyAdmin
Hello, I needed to reinstall the server (apache, php, mysql and phpmyadmin) and I am having this error when accessing the page localhost/phpmyadmin. Before that it was giving the same problem but…
-
0
votes1
answer289
viewsTrigger with sum between dates
Good evening, I need a help I’m not getting, I have two tables in my db. 1 - Portfolio table composed of: CREATE TABLE `carteira` ( `id` int(11) NOT NULL, `datat` datetime DEFAULT NULL, `vl_cliente`…
-
0
votes1
answer52
viewsHide "PROFILE" in the Phpmyadmin view tab
Does anyone know how to hide this Profile part in Phpmyadmin? I’ve touched everything here, tried to reset the default settings and nothing!…
-
0
votes2
answers200
viewsNothing happens when calling . php file via Ajax call in pure Javascript
I am creating Mysql server persistence for a web application of mine. For this I am using the xampp and phpmyadmin. I created a database in phpMyAdmin and in my application, in a javascript I have…
-
0
votes1
answer29
viewsSearches in mysql - Accented letters
Currently I do my search as follows: SELECT * FROM cadastro WHERE nome LIKE '%são%' This way does not return me a result, however, when I put only the ã capitalized à I get the result. That’s how it…
-
0
votes0
answers51
viewsFill out information from the database search form by Codusuario and Codficha
I’m trying to fill information in the form searching the database by codusuario and codficha, but there is an error and do not know how to solve, follow my code below: Code of the movement screen…
-
0
votes0
answers35
viewsForm, filled in with the same information, of the second ID
Hello I am with a problem, when I click on the Preview button that calls the screen that will fill the form the same comes filled with the same information of the second ID even by clicking on the…
-
0
votes0
answers13
viewsShowing symbols when importing sql database
There was a database on an A server. I deleted that server and am creating a new B server. When importing the.sql file to the B server, the names are all wrong. Imagery: How do I make in the…
-
0
votes2
answers8160
viewsError switching mysql port in xampp
Because I needed to use Mysql Workbench for college, I left port 3306 pro server Workbench and replaced the XAMPP for 3307 as the boy Suman Kotagiri said in this forum…
-
0
votes1
answer201
viewsWarning: mysqli_real_escape_string() expects Exactly 2 Parameters, 1 Given
I’m making a posting system using PHP and Mysqli, but there are some errors that I’m not able to fix. Follow the PHP code below: <?php if (isset($_POST['enviar'])){ $autor =…
-
0
votes1
answer521
viewsHow to put a. php pagination script on my website?
I’ve already built a website, but I’m having trouble with the paging system. I don’t know how to handle php, I found some videos on youtube and got a script of php pagination. Now I need to put this…
-
0
votes1
answer158
viewsI click the save button to register a product in my database and nothing happens HTML + PHP
I made a code in html + php to register products in my database, the connection class is working because the client registration works and I use the same include_once("connection.php"). The form is…
-
0
votes1
answer18
viewsImport description from another table
Hello guys I have the following code: SELECT COUNT(*) AS categorias_total, v_lctos_despesa.id_categorias FROM 'v_lctos_despesa' INNER JOIN categorias ON (v_lctos_despesa.id_categorias =…
-
0
votes2
answers90
viewssql filter in another table
Good morning, I have a problem where I have the following code working. select (sum((case when (lanc.id_tipo = 1 OR lanc.id_tipo = 5) then lanc.valor else 0 end)) + sum((case when (lanc.id_tipo = 2)…
-
0
votes1
answer276
viewsHelp in Mysql Phpmyadmin How to insert a table in a database?
How do I insert a table into a abanco ? I am a beginner mysql user and beginner in the world of programming. I made the following code: INSERT INTO banco1( CREATE TABLE Cliente ( id INT NOT NULL…
-
0
votes1
answer32
viewsUsed AUTO_INCREMENT to create ID numbers
I am using AUTO_INCREMENT to automatically add an ID whenever I create a new column. However when clearing a column, the ID number continues to add +1 instead of starting from where it left off. How…
-
0
votes0
answers46
viewsSELECT in a time period in a datetime column
I have the following column id datareg 1 2020-07-24 08:00:00 2 2020-07-24 08:30:00 3 2020-07-24 08:45:00 4 2020-07-24 09:00:00 5 2020-07-24 13:00:00 I need a query that returns the AMOUNT of records…
-
0
votes4
answers1283
viewsHow to save form image directory in the database
In the system I am developing has a form with a field where the user can attach an image. After saving the form, the user wants to view the record including the image, so I thought about saving the…
-
0
votes1
answer47
viewsPHP, Relationship Too Much for Many
My doubt is in the construction of Logic. How do I, so that I determine item, can have more than one value? EX: I have the table of vehicles and the table of inputs. Each vehicle can have more than…
-
0
votes0
answers214
viewsUpload FTP - PHP Progress Bar
I have a code ready here, with upload to database and to a local folder that has a javascript progress bar, but what I wanted was to use this progress bar to upload to a folder on an FTP and also to…
-
0
votes2
answers85
viewsError saving converted date in phpMyAdmin database
I am trying to write a form in the database, in this form has a date field that contains mask dd/mm/aaaa. To record in the bank I need to convert that date to aaaa-mm-dd, so far I’ve managed…
-
0
votes1
answer284
viewsPHP Mysql error - mysql_num_rows()
I’m having trouble correcting this error, I don’t know much about language (almost anything). The error that appears on the page is this: Warning: mysql_num_rows() expects parameter 1 to be…
-
0
votes1
answer79
viewsError generating XML from a Mysql database
I need to generate XML from a Mysql database. I’m using Mysql database with PHP (let’s be clear that I’m new to PHP, what I did was with a Youtube video (that) and very little of what I know).…
-
0
votes1
answer102
viewsMYSQL connection error on Android using php
I’m trying to connect my Android Java application via php with my MYSQL database and insert data in it, but despite the Android application report that the "user was successfully registered" the…
-
0
votes2
answers26
viewsHow to organize DB information printed on the page
I created a panel, where I want to show the information that is in db, these are printed on the screen through the code: <?php $servidor = "localhost"; $usuario = "root"; $senha = ""; $dbname =…
-
0
votes2
answers258
viewsHow to update or choose a specific version of phpMyAdmin when using Docker-Compose.yml?
Using the file Docker-Compose.yml to ride my containers, I know I can choose any version for the chosen service, for example: mariadb: or mariadb:10.4. But using the settings for phpMyAdmin, if…
-
0
votes3
answers50
viewsCount data from a table to sum
Hello folks I’m crando a Dashboard and I came across a challenge and I don’t know what to do. Table Order of Services Nome_do_profissional = Susana Serviço = MegaHair Valor = 80 I need to create a…
-
0
votes0
answers69
viewsnumber of characters in Mysql
Someone said that the TEXT type allows 65535 bytes, but I can’t post more than 10,000 characters, which I’m doing wrong? This is my Table DROP TABLE IF EXISTS `cad_materia`; CREATE TABLE IF NOT…
-
0
votes1
answer201
viewsError Mysql PHP connection
Good evening, everyone, I am trying to connect my wordpress application to the remote database, so I can list users within the application. I already tested some things between some researches, but…
-
0
votes1
answer67
viewsReturn of consultation in descending order
With this code, how do I make the return of the query come in order decreasing? <?php session_start(); include_once "conexao.php"; ?> <!DOCTYPE html> <html lang="pt-br">…
-
0
votes1
answer173
viewsAccentuation in Edittext
I have an API 28 application that consumes Webservice and sends data by GET using Json, and I need a field EditText which accepts Accents, but when it arrives in the database it only records up to…
-
0
votes0
answers41
viewsForeign key in phpMyAdmin brings duplicate record
Problem I have a table called "entidades_category-script" (let’s call 'A') that has the following keys: It turns out that it references another table called entidades_category-script-type (let’s…
-
0
votes1
answer71
viewsHow to upload an image through its path stored in the database?
I exported a database from a website here at the company where I work, and imported that same database into a xampp server, in one of the database tables has a picture column that is a varchar field…
phpmyadminasked 5 years, 6 months ago Felipe Sousa Canuto dos Santos 13 -
0
votes0
answers41
viewsUpdate Posts links from the database
Hello, good night. I have a problem and I wanted a help. Within each my post I have a link. Example: Post1 I have the link: https://google.com Post2 I have the link: https://face.com Post3 I have…