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
votes0
answers1421
views#2054 Unable to login to Mysql server - Phpmyadmin - APACHE ( PASSWORD ERROR)
I was doing the settings, at the time of installing mysql I ended up putting a password but ended up missing believe. Now when logging into Myphpadmin - it gives this error. I’m Using Apache>…
-
0
votes1
answer1406
viewsError upload PHP image. Warning: move_uploaded_file(): failed to open stream: Permission denied
Error you are showing when I execute the code: Warning: move_uploaded_file(fotos/7d80310d2fa83125d395d77e6f739bb8.png): failed to open stream: Permission denied in…
-
0
votes1
answer76
viewsSQL - Perform the removal of two rows in separate tables connected with Foreign Key
Good afternoon, I have a little doubt on a personal project of mine. I own the tables request and itens_request which are connected by foreign key. As an example to simplify my situation: Requested…
-
0
votes2
answers55
viewsQuery to collect data from multiple columns of the same row, by Primary Key of the record
all quiet?! See if you can help me! From the query below (use phpMyAdmin), I only need to bring the results of "LETRAA", "LETRAT", "LETRAG" and "LETRAF" to the browser screen (via PHP), but I do not…
-
0
votes1
answer1009
viewsWarning: mysqli_connect(): (28000/1045): Access denied for user 'root'@'localhost'
I’m making a website, while testing locally this connection code worked <?php $servername = "localhost"; $database = "bdcomentarios"; $username = "root"; $password = ""; // Create connection…
-
0
votes1
answer107
viewsRun a SELECT inside an IF in SQL?
I would like to know how to execute an IF condition with SELECT, I am still studying about SQL so in the example I will try to pass only the idea because the syntax will probably not be correct. IF…
-
0
votes1
answer54
views"Fatal error: Uncaught Error:" in database
I’m running my first database (using a hospital as an example) through phpmyadmin, and the following error is being generated by attempting to register: Fatal error: Uncaught Error: Call to…
-
0
votes1
answer52
viewsHelp with CRUD code
I am creating a CRUD on 000webhost using phpmyadmin I’m not being able to include a new user on the site. If I create a new user by the database it appears on the site, but if created by the site…
-
0
votes1
answer100
viewsProblems inserting data into a table in Mysql (PHP)
I can’t enter data into my table, and the commands are all right, right connection, but it doesn’t enter the data. I already redid the table to see if it was some configuration or name error, but it…
-
0
votes0
answers20
viewsHow to configure the session and user_id as soon as the method is called? (Codeigniter)
I have these two methods responsible for adding users from another system to that system. private function api_login ($ email, $ password) { $Curl = curl_init(); curl_setopt_array($Curl, […
-
0
votes1
answer29
views#1005 - Cannot create table`db_to_do_list`. `tb_completed` (error no. 150 "Foreign key Constraint is incorrectly Formed")
I’m posting this question here, because as much as I’ve researched, I can’t solve it I’m starting to study Mysql and the problem that occurred was this: #1005 - Não pode criar a tabela…
-
0
votes0
answers18
viewsHow do I connect Arduino with esp-01 to myphpadmin?
I have a mega Arduino attached to a esp-01 as follows Arduino-------------esp-01 3v3 gnd------------------gnd Tx-----------------Tx Rx-----------------Rx reset-gnd | en--gnd…
-
0
votes1
answer20
viewsTrigger (Trigger) in phpmyadmin is copying multiplying records
I am a beginner and I have little experience with Mysql, but I have studied and practiced and things are going well, and I need your help because I am stuck in a situation that I can’t find a…
-
0
votes0
answers40
viewsWhat am I missing in this require?
I created a simple structure to train require, but it is showing error. What I am missing ? Structure, within C: xampp_htdocs SMB\ /file_pasta_Root.php /pasta_A/file_pasta_A.php…
-
0
votes2
answers19
viewsHow to use select with php and Pdo
Hi, how are you? I am learning database with php, was creating a class named crud where there is a select function to remove data from the database, however, after select, the result is always 0,…
-
-1
votes1
answer64
viewsWhat steps should I follow to put my website online
I created a website to organize me use the database in phpmyadmin, for now I only use it on localhost but I want to leave it online, I know the hostgator offers free hosting but this is not the only…
-
-1
votes1
answer678
viewsSelect from a line in phpmyadmin
Good afternoon, everyone. When developing for VB I used a select using top, to select certain line I wanted, but I am developing in php now and I am using phpmyadmin BD and would like if possible as…
-
-1
votes1
answer559
viewsError 403 - Password validation forbidden access with Mysql in PHP7 code, how to fix?
Good afternoon guys, I am taking a course of a real estate portal system in PHP that I bought and I I stopped at the time to make the portal login system. The course uses PHP below version 5 and the…
-
-1
votes1
answer289
viewsSynchronize the server database with a localhost
I need to synchronize two databases so that the information of both are equal due to problems of instability of the internet. researching found the replication that exists in phpmyadmin, but as I…
-
-1
votes2
answers185
viewsThe mbstring is Missing - NGINX PHPMYADMIN PHP 7.0.23 CENTOS 7
how can I fix this error, because I am using php7, and I cannot download this extension. php 7.0.23 Nginx Centos 7…
-
-1
votes1
answer170
viewsDo I need to create columns in phpmyadmin for every checkbox I created?
I’m creating a hotel website for a school project, and I’d like to know if for each checkbox that I created in the code, I will have to create a column in the database of the phpmyadmin? And how to…
-
-1
votes1
answer492
viewsProblems with phpMyAdmin Uolhost
I have a site on Uol host and a database too, the site communicates perfectly with mysql, but I have a desktop software that I need to communicate with mysql as well, Is there any configuration I…
-
-1
votes2
answers2893
viewsChange date and date time format in Mysql
I do not want code to send the date converted to Mysql, I want to know if it is possible to show the date as 09/05/2018 09:59:54 instead of 2018-05-09 09:59:54. It is possible to change this in some…
-
-1
votes1
answer344
viewsAlternative to Phpmyadmin
Can anyone tell me a database manager where I can build more complex queries without having to enter the query? Just clicking where I want to make a SELECT for example? I need to do several queries…
-
-1
votes1
answer499
viewsSQL - Condition with Between
I have a form where the user can search for a date range, so far so good. If it searches only for a date, how can I do this in a direct way in sql or even in php ?! Any suggestions ?
-
-1
votes2
answers68
viewsdatabase saving only password
This is my first post here, I’ve been following the forum for a long time but I never wanted to interact, today this desire arose along with a little problem ... I’m learning to html, css, php and…
-
-1
votes3
answers1256
viewsHow to do an INNER JOIN bringing everything from two tables and one more "max" in a specific field?
Good guys, to be more specific I have two tables,. table 01: ...and table 02: ...and would like to make a "select" bringing all of these two tables, but where in the field "points" (table 02) have…
-
-1
votes1
answer35
viewsPhpmyadmin collecting data unnecessarily?
Below the code I have to collect the $_POST <?php $conexao = mysql_connect("localhost:3306",'user1','senhadementirinha'); $bd = mysql_select_db("recados"); ?> <form name="form"…
-
-1
votes1
answer43
viewsRemove space from a column in Opencart
I made a select in the table oc_product SELECT * FROM oc_product in the column sku needed to remove all spaces of these items are over 2000 lines with this problem is possible to remove it…
-
-1
votes1
answer203
viewsError accessing mysql Workbench using Docker-Compose
I’m starting to work with containers and I ran into a problem. Configure my Docker-Compose.yml file version: '3.3' volumes: data: services: mysql: image: mysql:5.7 ports: - "3306:3306" volumes: -…
-
-1
votes1
answer1140
viewsPHP connection using phpMyAdmin
Good evening, I’m doing a college job of creating an e-commerce site, but I’m not able to connect with my comic book, can anyone help me ? When I turn I keep saying you’re wrong on line 17, but I…
-
-1
votes1
answer5130
viewsmysqli_real_connect():(HY000/2002):
I have a problem accessing my phpMyAdmin. I started using Wampserver to program in PHP. I don’t know if I should make some initial configuration, but the way I tried to log in was without filling in…
-
-1
votes2
answers88
viewsUnrecognized keyword "as"
I am using MYSQL together with Phpmyadmin 4.7.4, and it accuses that the keyword 'as' is not recognizable, but when running it is in infinite loop, and shows no result. SELECT c.`nome`, case…
-
-1
votes1
answer397
viewsperform Insert with logged user code,in a table in the database
Hello I am developing a form, so the user submit the form I would like the database in the table form, be inserted the logged in user code, along with the other information filled in the form, in…
-
-1
votes1
answer66
viewsTake the values that were changed in the bank and match the new values
I have the following question. When making changes to a certain register, I need to keep the old information somewhere, I first thought of a log scheme, but it was time to take the old values, I…
-
-1
votes1
answer40
viewsSQL performance when dividing results into categories
I have a bank with all the products of my store, I want to list the products by categories but I do not know what is the most efficient way to do this, because it is a big bank. It would be better…
-
-1
votes1
answer156
viewsProblems installing broken phpMyAdmin - dbconfig-*
I have a problem trying to install phpMyAdmin on my Ubuntu Server 16.04. I installed Mysql normally, but when I install PMA, the following error occurs in the dependent packages dbconfig-common,…
-
-1
votes1
answer67
viewsHow to get information that is in 2 mysql tables
Table 01: $file Table 02: $users I want to do so, when a user is level ID = 30 display an msg EXAMPLE, File 01 ($file->userid = 20 that is, that user id is in table 02, $users->id) FILE TABLE…
-
-1
votes1
answer1287
viewsHow to receive data from an html form with PHP
Good afternoon, I am new in this area and I am having problems to receive data from my html form with my PHP code. My problem is I’m using for the name of Inputs the following format…
-
-1
votes1
answer95
viewsLogin System with Dominio
Well, let’s see if you can help me! I’m trying to make a basic login system, but I have a problem, I’m still beginner in php and I don’t know much. I’m trying to make this form work properly.…
-
-1
votes2
answers36
viewsDelete only if there is - in the word
I would like to delete some useless records from my database They are, for example: -2046820062 -2046820165 -2046820183 In short, all records that start with the symbol - (less) of my data2 column…
-
-1
votes2
answers131
viewsSyntax error in sql command
I have a possible problem in sql syntax in my code if (tbCPF.Text != "" && tbNome.Text != "" && tbEndereco.Text != "" && tbNumero.Text != "" && tbBairro.Text != ""…
-
-1
votes1
answer9028
viewsNo connection can be made because the target machine actively refused them. XAMPP
Guys, I’m having trouble getting other machines to connect to my localhost, and the error always occurs: Warning: mysqli_connect(): (HY000/2002): No connection to be made because the hand of destiny…
-
-1
votes2
answers266
viewsHow to store the values of a phpMyAdmin table in a variable/array/array and use it in Arduino code?
My school work consists of a basic security system using card frequencies, in a similar way to buses: passes card in the reader, if the frequency is X releases the ratchet, if it is non-X the…
-
-1
votes1
answer54
viewsTOP 5 PLAYERS
I’m trying problems in my code, I wanted him to get the 5 best players who most purchased products in the month, the problem is that I wanted him to catch the guy’s user and show the amount he paid,…
-
-1
votes2
answers451
viewsLoop in PHP to create a form dynamically
good pie. I’m having trouble creating a php function to create a checkbox list. I want to fill in the value attribute and HTML content of with information provided by PHP, through a loop. The final…
-
-1
votes1
answer60
viewsDelete button does not work!
Good evening! I have a page excluirConta.php that is not functional, here is the code: <?php session_start(); require_once("../banco/conexao.php"); if (isset($_SESSION['id'])) { $id =…
-
-1
votes1
answer34
viewsLoad reply to another page
I have a list of registered projects and the user can select one of them and click next to describe more details on the other page. I would like that, when pressing the forward button, besides being…
-
-1
votes1
answer131
viewsUpdate the status of multiple ids at the same time Mysqli php mvc
Good morning! I need to "Pick up the selected Ids" and change their status to the option you choose in select status. Bulk editing, same value in the status field for all selected Ids. Models:…
-
-1
votes1
answer74
viewsQuery works on phpmyadmin, but not on Laravel
Galley, Laravel helps a lot, but when he wants to complicate too, it really does. I did a query and tested in phpmyadmin and it works normally, but insert the query in my project Laravel gives…