Questions tagged as 'mysql'

4
answers

Search names in 2 different tables

I want to search 2 database tables where the name is equal to $nome variable. I would not like to gather data as if it were FK, but to pull all the information from these tables (other columns). administradores adm_id | nome | d...
asked by 21.11.2018 / 14:28
1
answer

PHP MVC Object Orientation

I have 4 tables in the database: Admin - Teacher - Class - Student and my question is: I would have to create: AdminModel.class.php ProfessorModel.class.php TurmaModel.class.php StudentModel.class.php AdminView.class.php Professo...
asked by 08.09.2015 / 04:27
1
answer

Numbering of MYSQL lines showing wrong sequence [duplicate]

I have two tables, perguntas and respostas , for each pergunta 4 or more respostas , it happens that I am not getting numerar as linhas correctly when grouping by queries    My result: | linha |...
asked by 26.10.2018 / 15:36
2
answers

Count items separated by semicolons in table field mysql

I have a table in the mysql database where tags field values are stored in this format: +-----------------+ | tags | +-----------------+ | B27;C38;H45;B27 | | C38;H45 | | B24;C45;L55;K98 | +-----------------+ I need to...
asked by 22.10.2018 / 19:57
1
answer

Rename All MySQL Database

I would like to know if it is possible to rename a whole database of MySQL I have the Database Register with the people table I would like to rename CAD_CRS Is it possible?     
asked by 12.07.2017 / 01:47
1
answer

Consult bank on another server

I have a MySQL database and need to query it from another server using PHP. What is the best way to do this? Is it possible to activate a function on the database server and return it to the query result?     
asked by 04.07.2017 / 23:58
2
answers

Add FK to mysql table

I have already checked and engine and is like InnoDB, in code tbm I did not find error, I had already done the command in another table before then I'm a little lost about the cause, follows the codes of the tables:
asked by 03.10.2018 / 16:35
1
answer

Automatically send email in PHP? [duplicate]

I have a website where you have a database, and in the same database, a part where you have some dates, some of which will still happen. What I wanted to do was to send an email to all users registered on the website when I arrived at each dat...
asked by 28.04.2014 / 15:19
2
answers

Generating sequential IDs for each user in the same MySQL table

I have always used the primary key itself as the default ID for each record in a database table. Once the table has been used by several users, each one has its own registered products, it will no longer be possible to maintain that standard seq...
asked by 28.11.2018 / 14:20
1
answer

Help logging in to the login system, dropping the 2 form's

Well, I want to leave a login system that after login is validated when it goes to the login form page it appears that it is logged in and not the login form: ex: pimpslogonthesamepagesumisseesseform: phpcode:<?phpsession_start();require'ini...
asked by 27.09.2018 / 04:03