Questions tagged as 'phpmyadmin'

1
answer

Problem inserting data with MySQLi

I have this database created in phpMyAdmin: The problem I have is that when I insert the data of the form where I create a user manages to connect to the database, the data sends them but does not save them, concluding with the redirect...
asked by 26.12.2015 / 07:20
3
answers

How to check existence of records in mysql with php?

I'm doing a class work in which they ask me to make a record system, to insert the user's data in a database, I have the following function: function comprovaUsuari($user, $passwd){ $servername = "localhost"; $username = "root"; $d...
asked by 28.03.2018 / 12:54
2
answers

Highlight the first record brought from a Mysql query with DESC

I do not know if the title is descriptive enough, but I did not know how to ask the question. The problem is this: I have a query that I use to show a "top" of the 20 ages of some people. What I want is that the first record shown, in this ca...
asked by 29.04.2018 / 03:12
2
answers

Problem with COUNT (*) Does not return data (PHP AND MYSQL) [closed]

I try to count the amount of invoices in the database: //conexion: [email protected]_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME); if(!$con){ die("imposible conectarse: ".mysqli_error($con)); } if (@mysqli_connect_errno()) {...
asked by 27.04.2018 / 17:38
2
answers

Error in phpmyadmin 'Error: 1231'

When I start phpmyadmin I get the following error: When updating the page it is solved and I can enter the interface, but I would like to take out that error that is annoying every time I enter. Thank you.     
asked by 12.05.2016 / 01:47
3
answers

How can I know how many times a data is repeated in an sql query?

Good afternoon I want to know how to get the number of times that a type of data is repeated and take it to a table with php at the moment I have the following code but I do not know how to extract the number of times that a data is repeated in...
asked by 23.09.2016 / 22:35
3
answers

Add total column and group by month in mysql

How do I add the total column and group by the column mes , but do not add me when the id_orden is repeated (218), and try to group them by month, and it looks like this: The sum of month 5 is 10 and the sum of month 1 gives 240, a...
asked by 17.05.2018 / 05:24
1
answer

I need to show the date by MySQL rows and columns and the SQL does not work

I am having problems when making a date query, for example: I have a column called Date and it is of type date, in which I only store date, time not! because of that date I want to do columns in which I take the months, in rows the years recorde...
asked by 11.07.2018 / 08:30
2
answers

disordered months in mysql

my question is because the months in the database are disorderly and I want to know why they come out so I leave the code sql SELECT mes_traslado FROM formulario_precebo WHERE año_destete = 2017 GROUP BY mes_traslado; and the result it gi...
asked by 04.04.2018 / 16:46
3
answers

Advanced search and mysql query

Good morning, I have a problem when it comes to making a query, since it does not return the desired result. The conditions for the consultations are marked by the user with a form similar to this one: And this is the scheme of the tabl...
asked by 17.05.2017 / 11:42