Questions tagged as 'mysql'

0
answers

Problem inserting the mysql bank in php [closed]

I'm developing a project for college and I'm having some problems inserting into the my_sql database, my problem lies in that section. mysqli_query($conn, "INSERT INTO funcionario( codigo_funcionario, nome, cpf, data_na...
asked by 26.11.2016 / 17:46
1
answer

Procedure to create database and its tables

I need to create a database for each client that performs a particular registration, so I created a procedure to do such thing. But I came across a small identification problem. When I run procedure it creates the database with...
asked by 28.11.2016 / 13:45
1
answer

Dynamic insertion according to date and days of the week

I'm creating an application using webservice in PHP. Within the application the user will define specific days to generate an alert, for example: second fourth sixth In this way, I would like my bank to log an entire event, Monday,...
asked by 05.11.2016 / 14:16
2
answers

I can not store data in my bank variable other2

if(isset($_POST['cadastrar'])){ $categoria = $_POST ['categoria']; $origem = $_POST ['origem']; $acao = $_POST['acoes']; $responsavel = $_POST ['responsavel']; $quando = $_POST ['quando']; $sta...
asked by 10.10.2016 / 15:30
0
answers

Operations with calculated fields from a mysql view

Good afternoon, I have a view where there are several fields where I have several calculations, and the result of these calculations would like to use in other fields of this same view. An example: select (tab1.campo1+tab1.campo2)/ta...
asked by 05.10.2016 / 21:56
2
answers

Error duplicating the HTML form in MySQL PHP Data Search

I have the following problem I want to do a search in my database and display the results in the list lines, only it is giving a crazy error, it reexhibits the entire page three times, it stays like this oh: SOMEONECanyouhelpme?Doyouhaveanyideaw...
asked by 24.11.2016 / 22:53
1
answer

Doubt in Eloquent Relationships - Laravel 5.2

Good afternoon, sorry if I had any similar questions, I searched extensively both here and in English and found nothing similar, I have the following Template in the database contract id due_date contract_service id price co...
asked by 24.11.2016 / 18:06
0
answers

Mysql doubts in fk null (Election candidate blank)

I am doing a voting system and need to accept blank votes What is the best option to do this? accept passing a null value in the cd_candidate column? I can not create a blank candidate in the candidate table reason: they will have a...
asked by 21.10.2016 / 15:44
1
answer

Problems in a query performed within a Stored Function in Mysql

I have a problem inside a query in Mysql performed within Funcion . The question is, among the various activities that the function is performing, is testing whether a given data has already been entered into a table. The tabl...
asked by 18.09.2016 / 19:38