Questions tagged as 'mysql'

Tagged questions
1
answer

Using two statment at the same time without giving "Fatal error: bind_param"

On my records page, I want to check the names of users and emails separately but at the same time. I could leave the message like this: Username or email already exists to make it easier but I've never seen a registration page that wor...
asked by 07.06.2014 / 04:06
2
answers

Handling dates for searching the bank

I am performing the following capture of a date: $dtInicial = $this->_getParam('dataInicial'); // Padrão dd/mm/aaaa To search the precise database, leave it in the yyyy / mm / dd pattern: $dt1 = date('Y-m-d', strtotime($dtInicial));...
asked by 12.12.2014 / 14:57
2
answers

I need to select which officials are allocated on which projects

I need to make a select of which officials are allocated on which projects but when I run my code: select projeto.nome, funcionario.nome from projeto, funcionario It selects all names in all projects and not how they are actually allocated....
asked by 08.11.2018 / 18:57
2
answers

Select2 in several fields with the same name

I am making an ordering page, where you can register several products. In order to register the products the users have the options of Produto, quantidade, valor, subtotal , if they want to add another product, it has a function that ad...
asked by 23.10.2018 / 18:14
1
answer

Where to put the connection string to the database?

I have the form: Thedatabaseandtheregistrationtablehavealreadybeencreated,IamusingwampserverandMySQLWorkbench.Myquestioniswheretoputtheconnectionstring:MySqlConnectionconn=newMySqlConnection("Persist Security Info=False;Server=localhost;Datab...
asked by 05.07.2014 / 23:13
1
answer

Mysql alter table command, difference of "modify" and "change"?

What are the main differences in change and modify, in which cases should I use them? alter table cadastro change nome nome varchar(20); alter table cadastro modify nome varchar(30);     
asked by 06.10.2018 / 02:23
1
answer

How to separate the errors of a query into an api expressjs

What is the correct method of separating errors from a query? The current code compares the error manually with the message generated by mysql, in case the query can go wrong for several reasons, instead of returning a log and error 500 like...
asked by 11.10.2018 / 21:12
2
answers

Questions with insert

I have form to insert into three different tables: <form name="customer_details" method="POST" onsubmit="return form_validation()" > <h5><strong>Utente</strong></h5> <input type="text" id="nome" nam...
asked by 20.12.2018 / 18:12
2
answers

Treat intervals between two Time Mysql fields

I have a Atendimento table in my DB. Inside it I have two fields that are: HrIni which refers to the start time and another HrFim which refers to the end time. I need for each record of these two fields to be stored in a...
asked by 02.09.2014 / 19:07
1
answer

System.ArgumentException when using MySQL with Entity framework

I installed the MySQL connector in the environment, I installed the MySQL references through the Nuget package. When I start the system and try to insert into the database, the following error appears:    The ADO.NET provider with invariant n...
asked by 02.09.2014 / 23:27