Questions tagged as 'mysql'

Tagged questions
1
answer

Upload .txt for MySQL database

Hello, I would like to upload a file .txt that meets the layout as follows (follow the example of two lines of the file): 9787546;488464;2016-12-11;Carlos Fonseca;carlos.fonseca 9787547;464664;2016-12-11;Rogério Barros;rogerio.barros...
asked by 27.12.2016 / 13:14
1
answer

Call key of a database for a user to choose in a Php form [closed]

<?php $link = mysqli_connect("localhost", "root", ""); $query = mysqli_query($link, "certificados"); ?> <form name="produto" method="post" action=""> <label for="">Selecione um Nome de Autor</label> <select> <o...
asked by 05.02.2017 / 18:30
1
answer

Doubt with select in mysql

Well I have the following tables: Orders id id_cliente id_vendador 1 10 20 2 10 30 3 10 20 Devolutions Id data id_pedido 1 2017/01/01 3 I...
asked by 04.02.2017 / 02:25
1
answer

Change the screen data change from the ID that is in the Combobox [closed]

I'm stuck in the code where I can not return all the bank ID positions in the combobox and I can not seem to change the other fields from that ID. Any help is appreciated right away Data Query Screen <?php session_start(); $ID_Cli...
asked by 31.01.2017 / 21:12
1
answer

PHP Show only the closest result

Good morning everyone, I did not know exactly how to put the title, nor how to research it. I have if else in PHP that says that if the result is not found first, it will try to find a similar result by doing an array with the text. Let's...
asked by 29.01.2017 / 13:41
2
answers

How to change the format of a query result?

I would like to know if there is any argument in the select that changes the result format to be used as dump . Example: create table 'table_name' ('id' int, 'value' text); insert into 'table_name' values (1, "a"), (2, "b"), (3, "c"); sele...
asked by 07.12.2016 / 18:24
2
answers

how to insert data into two tables at the same time

I would like to know how I can do to insert data into two tables at the same time, well I do not know if it's right the way I'm doing it is not giving any error but I also did not insert anything. The code below. <?php error_reporting(-1...
asked by 17.01.2017 / 19:59
1
answer

Injection dependency failure [duplicate]

I'm new to the Hibernate world and when I run this application, I get the following exception (error is relative to EntityManager persist): java.lang.NullPointerException Caused by: java.lang.NullPointerException at com.nataniel.a...
asked by 27.11.2016 / 03:27
2
answers

PHP PDO Notify user whose registration name already exists

Hello. The code below does not allow the user to choose a name already used. But I would still like to warn the user that they chose the wrong name so that they know they need to choose another name. include_once 'database.php'; // Verifica se...
asked by 29.11.2016 / 22:15
1
answer

Trigger to update another table

I have 4 table in my Mysql database. - > companies - > contacts (business addresses) - > bank_data (company bank details) - > partners (company partners) All tables relate to the companies table. In the companies table I have an u...
asked by 20.12.2016 / 14:55