Questions tagged as 'mysql'

Tagged questions
1
answer

Method Search for bank records on the same page as the PHP form

Good morning, I'm working on a personal project and I plan to do a page to find clients informing their name and CPF for the time being the code is like this, but it's not working. Can someone tell me why? Here is the code below Page code...
asked by 18.09.2018 / 05:56
2
answers

Exchanging column values in MySql

I have a MySQL table with coordinates, the column names are X and Y . Now I want to change the column values in this table so that X becomes Y and Y becomes X . The most apparent solution would be to rename the columns, but I do not w...
asked by 21.09.2018 / 21:06
2
answers

Doubt SELECT Mysql

In a given select I can reference two tables by foreign keys. Ex: IdA / IdB IdA = IdB Table A has a column named C Table B has three columns called D, E, F Both tables have similar contents for returns in SELECT Ex: Select ... fr...
asked by 19.09.2018 / 13:06
1
answer

Error connecting to database

I try to connect to my bd, but it gives the error "Failed to connect!" The data that is in my bd is: Database: test Table: Customers I'm trying to connect through PHP <?php $conn = @mysqli_connect("localhost", "root", "", "te...
asked by 10.11.2017 / 16:48
1
answer

How to show that the user is logged in the pages that he visits?

How do I get the user after login, that he can see in some corner of the screen his name with some information of him with that login and that when he presses the "back" or "exit" a question appears if he really wants to proceed, and if he confi...
asked by 02.11.2017 / 16:55
1
answer

How to leave a mysql database online?

I have a database on my computer, but I need to share it with others. I am using the MySql database, and I need to access this database outside the network, on other devices. How to leave this database online and share it with other people? I ne...
asked by 23.08.2017 / 03:54
3
answers

Select only the last messages MySql Chat

I'm creating a chat in an android app and need to display this screen: Mydatabaselookslikethis:Messagetable: I'm making this an example query for the user who has id = 43 SELECT m.dono, m.dest , m.recebido, m.data, IF(m.dono=43,(SELECT...
asked by 25.08.2017 / 02:04
1
answer

Doubt about alternative to decrease code size and make fewer queries

I have a question concerning a certain part of a system that I am developing. The system is for management of a higher education institution and has a page that is to manage the courses of the institution and I put some filters via select with a...
asked by 15.07.2017 / 16:04
1
answer

I want to take a current balance and add up to a previous balance

This system and to do banking operations the user will have to make the deposit only he type a value that he wanted to deposit and in the bank he will have to add to the current balance only that is not working. he is putting a number 7 and is n...
asked by 08.06.2018 / 17:16
1
answer

Event when closing tab / browser

asked by 16.06.2018 / 21:36