Questions tagged as 'mysql'

Tagged questions
1
answer

Dynamic graphical interface after MySQL request

People are as follows, I want to load all this data in my graphical interface, the idea is for the user to type the cpf (primary key) of it and after that is loaded all that data for him to update, I want to know how do I that this cpf after the...
asked by 24.02.2016 / 19:14
1
answer

Doubt in SQL Query

Personal I have the following table: --- mensagens id usuario_envia usuario_recebe texto data_envio But I want to list only the "Conversations", for example, I want you to list the messages by grouping them with their respective users who h...
asked by 29.01.2016 / 14:44
1
answer

Problem inserting data into mysql table [closed]

I'm having a problem inserting data into a table someone can show me the error. <html> <head></head> <body> <div> <form method="POST" action="varcadastro.php"> <p class="contact">...
asked by 08.11.2015 / 22:28
1
answer

How to do select using mask on output

I have a client table, and a cpfClient field of type varchar. The cpf is stored without a mask. Ex: "00751595170" I would like to make a select that formats the result by putting the masks. "007.515.951.70"     
asked by 26.10.2015 / 23:40
2
answers

How to group results from a row-to-column query

Good afternoon, I have this query SELECT tblcliente.idCliente, tblclienterespostapre.resposta FROM tblcliente INNER JOIN tblclienterespostapre ON tblclienteresp...
asked by 28.10.2015 / 16:18
1
answer

Doubt over PDO connection

And to folks, I have a question about the PDO connection. This is the connection I have in the script I'm configuring: <?php function getDB() { $dbHost = 'host'; $db = 'bd'; $dbUser = 'user'; # Get database password...
asked by 26.10.2015 / 16:08
1
answer

List friends posts

I have a database with the following structure: Users table: usuario_id Primária int(11) nome varchar(128) nascimento date Friendships table: id_amizade Primária int(11) id_remenente...
asked by 01.01.2016 / 13:22
1
answer

Display mysqli error using die

I used mysql_query , as it is not used anymore I am using MySQLi . With this I was left with a doubt. To display the query error by DIE is this how it is done? $sql = $mysqli->query("SELECT * Fron tabela") or die(my...
asked by 06.01.2016 / 15:55
2
answers

Problem in PHP + MySQL query using LIKE

Good afternoon guys, recently in one of my projects a problem has arisen and I hope you can help me. To better understand the site is a site of consultations in the health area, such as clinics, cardiology, urology, etc. Some clinics can belo...
asked by 05.01.2016 / 19:54
1
answer

Creation Related bank

I have a question about whether or not I'm setting up this bank. They could help if the path is right or wrong. For now I just put id in the tables. Class Turma | Turmaid A 1 B 2 C 3 D 4 Municipality Municipio |...
asked by 03.10.2015 / 05:57