Questions tagged as 'mysql'

Tagged questions
3
answers

Problem with select php mysql [closed]

I'm having a problem I've never seen in php, I'll try to set an example to make it easier to understand. I have a arquivos table in this table I have 2 columns being id do arquivo and id do usuário (to whom this file belo...
asked by 05.06.2018 / 23:58
2
answers

Introduction of formulas in the Web application

Greetings! I'm developing a web application, with the tools (HTML + CSS + JAVASCRIPT) {BootStrap} + PHP + MySQL. It is a kind of teacher's notebook, and at some point the teacher will have to enter the formula for calculating the average of freq...
asked by 02.05.2018 / 08:49
1
answer

Search filter for some reason you are not looking for the product.

<?php include ('conecta.php'); ?> <table width="753" height="191" border="0"> <tr align="center" valign="middle"> <td bgcolor='#FFFFCC' colspan='5' valign="middle" width="72"><a href="carrinho.php"><img src...
asked by 18.03.2017 / 15:03
1
answer

Make choice via combobox from DB table to insert data

Exemplifying:   Choose in the Options in which of the Database table you want to insert your information. <!--- EXE: Banco de Dados CREATE TABLE tabela_acao, tabela_comedia, tabela_ficcao( id INT(6) UNSIGNED AUTO_INCREMENT...
asked by 10.10.2016 / 20:25
1
answer

Pass a subquery from the FROM clause to the WHERE clause [duplicate]

I have the following query with a subquery in the FROM clause and I want to get the same result but using this subquery in the WHERE clause. SELECT base.nome as Aquario, base.localizacao, base.nome_cientifico F...
asked by 07.12.2016 / 23:22
1
answer

Select does not work Mysql

I'm trying to do the following select select nm_login,ds_Senha from tb_funcionario where cd_funcionario=? But if the ds_status field is equal to admin I want it to ignore cd_funcionario=? , to show all users.     
asked by 15.01.2018 / 20:59
1
answer

PDO query error

I have the following code: @$import = $dbconn->prepare("UPDATE t SET"); if(a <> "") { $import .= "teste2= '$a', teste= '$b', "; ... It returns this error: Catchable fatal error: Object of class PDOStatement could not be convert...
asked by 27.11.2018 / 16:25
1
answer

ERROR 500 - But I do not know where it is wrong, someone helps me!

@PostMapping//Create public ResponseEntity<Categoria> criar(@RequestBody Categoria categoria, HttpServletResponse response) { Categoria categoriaSalva = categoriaRepository.save(categoria); URI uri = ServletUriComponentsBuilder.from...
asked by 19.09.2018 / 22:20
0
answers

Save DOUBLE value with period in mysql database

Good afternoon, I'm developing an ECOMMERCE, and I have the following problem: I have DOUBLE values of height, width, length, value, at the time I'm going to save in the database it tries to SAVE with comma and error! I would like to add a textb...
asked by 30.12.2018 / 19:22
1
answer

Difficulty in doing data verification in php with mysql

I'm trying to do a check in the database to know if it already has a user with the email entered by hmtl, I made this php script, but always execute it at first if the typed email is not in the database yet. I think the logic I used is correc...
asked by 11.06.2018 / 02:32