Questions tagged as 'mysql'

Tagged questions
2
answers

Error in PHP code

My code is part of a virtual store project, and is giving the following error: Thefollowingisthecodebelow:<?phpclassLoginextendsBD{private$prefixo='ibicor_';private$tabela='loja_clientes';private$email;private$senha;publicfunctionsetEmail($m...
asked by 15.09.2017 / 17:22
1
answer

Confirmation email with password_hash

By registering on the site, the user receives an email to activate the registration, until then everything is right. The problem is with checking the password_hash, I know you have password_verify, but in this case it seems that you can not use...
asked by 17.07.2018 / 05:24
1
answer

Simple C # connection problem with MYSQL

I have a problem with the following error when attempting to do a simple insert of an activity in my mysql database: "System.ArgumentException: 'The format of the initialization string does not conform to the specification started in index 57."...
asked by 05.07.2018 / 14:38
1
answer

Verification in login form

I'm not able to do a check in the database, to make sure the user exists. Here is the code: private void button1_Click_1(object sender, EventArgs e) { string conexao = "SERVER = localhost; DATABASE = dizimistas; UID = root; PASSWORD = senh...
asked by 29.11.2017 / 12:47
2
answers

Error when using Inner Join in MYSQL

I am using INNER JOIN in mysql to merge and display the data. Tables and data insertion: CREATE TABLE EXPERIENCIA( exp_pri INT NOT NULL AUTO_INCREMENT, experiencia VARCHAR(100), PRIMARY KEY(exp_pri) ); CREATE...
asked by 13.06.2016 / 15:49
1
answer

Ajax with Python - I want to call function that is in default

I'm looking to do a validation on the MySQL Bank via Ajax. I created a function called validaCNPJ () which is in the controller called Default . But I do not know how I put this function in the Ajax parameters. Can anyone give me the path...
asked by 06.06.2016 / 14:41
1
answer

Error in php in my syntax [closed]

   Uncaught exception 'PDOException' with message 'SQLSTATE [42000]:   Syntax error or access violation: 1064 You have an error in your SQL   syntax; check the manual that corresponds to your MySQL server version   for the right syntax to use ne...
asked by 18.12.2015 / 19:48
2
answers

Inner Join Does Not Work - Error 1054

Could someone explain to me why this query does not work? select mensagem.mnsg, aluno.nome as nomea, aluno.curso as cursoa from mensagem inner join aluno on aluno.rm=mensagem.RM order by id asc; -- Table aluno CREATE TABLE 'aluno' ( 'RM'...
asked by 25.09.2018 / 21:45
2
answers

Join variables and add 0 to an 11-digit php field

I am generating a bar code, it will have a base that will be as follows: Store number: $v_ficha_loja = $row['ficha_loja']; = (1) or (2) etc .. Environment number: $v_ficha_ambiente = $row['ficha_ambiente']; (1) or (2) etc...
asked by 19.08.2016 / 20:42
2
answers

How to return all the fields of a "Mysql" line with the "id" of the line? [closed]

Given a table "Mysql", where there are 3 fields: ID - First Name - Last Name How should the query be so that just by entering the ID, does it return all fields in the row? Note: I put only 3 fields for example, but the query should serve a...
asked by 17.05.2016 / 17:23