Questions tagged as 'phpmyadmin'

Tagged questions
2
answers

Find duplicate records, change them and return them only in MySQL

I have a problem, I have data from a table that is duplicated, inside are the following fields id, empresa, actividad, compañia I need the field empresa is unique, I generate a query to know how many and which are duplicates and I...
asked by 28.09.2018 / 16:59
1
answer

I fill in the fields of the bd in the wrong order

I am doing a record for a page and this one is good for me except for one big mistake, and it is that it saves the data in fields of the bd that it should not, attached capture. As you can see in the user the password is put, in passwor...
asked by 03.08.2018 / 14:30
1
answer

SQL duplicate management

It turns out that I have to make a query in which I get returned several duplicate records, except for a field that is counters. The question in itself is that I need to collect the record with the highest value of counters. Right now the sen...
asked by 07.05.2018 / 12:47
2
answers

Trying to get property of non-object in line 18

In the line that there is error is in this: if ($resultado->num_rows() > 0) ... This is my code: <?php $mysqli= new mysqli('localhost','id5840508_root','******','id5840508_hospital '); $salida=""; $query="SELECT*FRO...
asked by 20.05.2018 / 21:30
1
answer

Show results of a query to a BBDD

Good, I have this PHP code, with a database with the table "images" and with the fields: "id", "category" and "url". When I try to select all the images in a category, it only returns the first image of that category with the following notificat...
asked by 16.12.2017 / 12:53
2
answers

Avoid a concurrent insert

I have a problem on my website. It turns out that I have a packs table which has a availability column. A pack will be available as long as the availability is > 0 . A user can reserve an available pack, upon payment with Stripe. This...
asked by 03.04.2018 / 23:09
2
answers

Problem preventing registration of duplicate users PHP - MYSQL

I have an Android application where I access a MySql database by php. I am trying to make that when a user tries to register and already exists, he does not insert the data into the database. The problem is that by putting the if th...
asked by 07.09.2016 / 12:00
1
answer

Uncaught Error: Call to a member function fetch_object () on boolean in - What is the error?

Good for everyone, I have a problem with this error, I am a beginner I searched and I have not found a solution. It is an appointment form and the database is in phpMyAdmin, this form is to attend an appointment then First only the appointments...
asked by 22.05.2016 / 19:19
1
answer

Restart Invoice number in AdminLT template [duplicated]

Download a web system to manage purchases and sales in problem is that the invoices start at 1000 as seen in the reference photo, how can I reset the invoice number to 0? Thanks!     
asked by 31.08.2018 / 08:02
1
answer

Problem with the permissions in phpMyAdmin

I am using phpMyAdmin as a database manager on my Centos server, despite having access to all of them, in the phpMyAdmin.conf . I have SELinux turned off. When trying to enter from my browser I get the following error:    Forbidden:...
asked by 07.05.2017 / 11:21