Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

com.mysql.jdbc.exceptions.jdbc4.MYSQLSyntaxErrorException: Unknown column 'p.apaterno' in 'field list'

I have a question about that error, because although I check the code I can not find what it is referring to if I see it well written and the values are complete. I think the error may be appearing according to these parts totalregistros =...
asked by 24.06.2018 / 21:05
3
answers

Duplicate record with new ID and another custom field

I have a database ( basedatos ) and a table ( contratos ) with the following fields: Id Nombre Fecha (timestamp) Vendedor Telefono Gestionado I want to insert in a php page a button that duplicates the record but with the conse...
asked by 09.06.2017 / 10:13
3
answers

SQL Count records that begin with xxx

I want to count the records in column 1 that start with 123, I need to count multiple times, with different values (123, 657, 897, ...) I have the values in column 2 - column1 | column2 - 1234567 | 123 - 5489186 | 135 - 1238756 | 548 SELE...
asked by 14.03.2018 / 11:15
1
answer

I can not add a record to my database, mark error PreparedStatement [duplicated]

I am trying to add data to a database using a button, but at the moment of entering the data I get an error in the Prepared Statement part and my SQL statement I tried it on my local server (phpmyadmin) and it worked perfection, and I have not...
asked by 22.10.2017 / 08:40
4
answers

Validate existing user

When I prepare this query, I want it to validate if the user exists or not, and for that I use "mysqli_num_rows ()". The problem is that if I do it without preparing the query, putting the query to hair (it is commented in the code), it works. B...
asked by 30.11.2016 / 22:15
2
answers

Store several variables (or an array) in the same field (MySQL) [closed]

Can someone tell me what would be the best option to store the following data? The user (within a form) has the possibility to select multiple checkboxes (19), and I need to store if they are marked or not (all of them) in a single field....
asked by 09.10.2018 / 19:40
1
answer

Put a query in text boxes

I'm doing a window to edit data in phpmyadmin and I want to put the information in text boxes, but I have not found a way to insert it without being a placeholder. And what I need is for it to look as if the user had inserted it. <...
asked by 12.04.2018 / 02:44
2
answers

How to add decimals of a Mysql record with php?

I have a small drawback about adding up the total of a field in the database that is of type DOUBLE (6,3) . I have dealt with number_format and money_format. An example is when I'm going to register the field, I put 240 and when I sav...
asked by 26.08.2017 / 02:39
1
answer

Update a record if it does not exist or if

How can I verify if the registry exists and then update it if it does not exist that I insert it? I tried this, but it does not leave me. UPDATE tienda SET Campo1 = 'carro' WHERE ID = '123' IF @@ROWCOUNT = 0 INSERT INTO tienda VALUES ('coch...
asked by 05.06.2017 / 15:02
2
answers

change PHP date format [duplicate]

When I make an INSERT in the bdd using a form one of the columns automatically generates the date in which it was made, the case is that it is stored with this format 2017-03-29 17:12:16 What I am trying to solve is to change the format t...
asked by 29.03.2017 / 17:36