Best answeres tagged with mysql

2

answers

Update MySQL data with Ajax

I have an ads table with a field called highlight, by default its value is 0. I have all the ads in a table in HTML. I want to make when the user clicks "Enable highlight" it sends an update in MySQL changing the field from 0 to 1 without ref...

asked by 26.02.2015 / 00:06

3

answers

How to search by ID in MySQL

I am developing a system of entry and exit of vehicles of the company, in the index I made 2 inputs one of entrada and other saída , when I click on input it appears the screen of register of the vehicle like placa, nome do motor...

asked by 13.07.2014 / 04:50

3

answers

Do not receive data from POST

I'm trying to generate the login according to the data of the database and proceed to the page restricted to registered users, but the incorrect password error occurs. Front-end: <div class="login-form"> <form action="m...

asked by 29.06.2014 / 19:13

3

answers

How to do a select with multiple results in a single row

The problem: One of our sites has a system of messages between users, for this we have two tables: one that stores messages between users and another with users, follow the structures below , and with this data we need to display in the messag...

asked by 03.07.2014 / 18:51

1

answer

Processing of inserts in MySQL

Is it possible to know if you insert them in MySQL after the connection is closed? The PHP code has 800 rows, I know it will go through, as the last statement is successfully executed. To follow I open phpMyAdmin and to F5 I see that the...

asked by 15.10.2014 / 15:38

1

answer

Saving data in hexadecimal in the database

I need to register a document or image in hexadecimal format in the database and then retrieve this data by converting it back to the correct format.

asked by 03.10.2014 / 15:50

1

answer

How to insert UUID automatically in a MySQL colum?

Is there any way to insert a UUID automatically into a table field, just as it does with a field of type AUTO_INCREMENT ? In a framework for PHP, CakePHP, when we set the primary key to VARCHAR(40) , it inserts a UUID...

asked by 25.02.2015 / 19:56

2

answers

Different databases for the same application asp.net C #

In a club management system each club has its own database. There is a DAL class where it is in charge of getting the web.config to string from application connection . How to ensure that the login application loads the correct...

asked by 15.01.2015 / 14:17

2

answers

Sort by the largest ID and group the similar ones

How can I list the records by sorting the last one, but when I have the field related filled in, bring the other records with that same value? The general idea is to make a order by id desc and group the related ones. My tabl...

asked by 03.01.2019 / 22:51

3

answers

Connect 2 tables with same id [duplicate]

asked by 27.03.2017 / 19:48

Questions tagged as 'mysql'