Questions tagged as 'mysql'

Tagged questions
1
answer

PHP Mysql Seach Result

Good afternoon I have been trying to resolve this for two days without success and would like your personal help:) The tables are as follows: Chaves' ( idChaves int(10) AUTO_INCREMENT, nomeChave varchar, estadoChave int(1) , situ...
asked by 29.01.2017 / 18:04
0
answers

Update updating fields "incorrectly"

SQL : $sql = " UPDATE atributos_prod SET codigo='$codigo', descricao='$descricao', preco='$preco' WHERE id='$id' "; The values entered are captured as follows: $postdata = file_get_contents("php://input"); $request = json_decode($postda...
asked by 14.02.2017 / 19:33
0
answers

Create pages with different parameters and then access it

I'm having the following difficulty: I'm trying to create a basic EAD platform where if the user has permission he can send a video of the vimeo; put a description and katchaw In case after sending it comes my true doubt how to do, above I'...
asked by 14.02.2017 / 16:35
0
answers

I have a select file on 4 pages in 1 of them works and in the other three does not respond to query

function recuperaRacas($idAnimal) { $idAnimal = strip_tags($idAnimal); $query = "select raca_id 'idRaca', raca 'raca' from raca_nimal where id_nimal = " .$idAnimal. " order by raca;"; $queryBuscaRaca = $this->conexaoMys...
asked by 14.02.2017 / 19:17
1
answer

Error to get last ID

Hello. I'm having trouble getting the last logged in ID. I have already made a lot of attempts, but the variable $ proximo_ID always returns me '0', or Empty. Could you help me solve the problem? if(isset($_REQUEST['btn-cadastro'])) { try {...
asked by 11.02.2017 / 21:05
1
answer

Two variables and one group by? PHP and MYSQL

I am making a very simple private (just between two people) chat system with PHP and MySQL, Jquery and HTML / CSS. In the database, the table has the following structure: id (int) remetente (varchar) destinatario (varchar) texto (text) horario...
asked by 16.01.2017 / 06:41
2
answers

How to add everything in MYSQL

How do I add all of a table in MySQL for example .. I have the table tb_comment , so I want to add in each post(id_mark) the amount of rate that will have the total. For example, id_user 20 has the rate of 4 in id_...
asked by 11.12.2015 / 23:15
1
answer

PHP | MYSQL Error: Operand should contain 10 column (s) [closed]

I'm trying to develop a Query where, it needs to be queried in 6 equal tables if there is any specific value. Here's my Query: SELECT ( CASE WHEN (SELECT * FROM sala1 WHERE aluno = '$AlunoInformado') = 1 THEN END ELSE CASE...
asked by 10.01.2017 / 02:43
0
answers

How to put the value of a field acquired with jquery in php?

I want to make a check try as a parameter the date of a datepicker and the id of an item. <script> $('.menu-item').click(function() { var item = $(this).attr('value'); alert(item);...
asked by 04.01.2017 / 14:31
2
answers

My query that used to work before now does not go pro bd at all

Of course my queries are no longer accepted by my DB. This is for both the site in php and direct with an INSERT in phpmyadmin. See if you can give me a light: CREATE TABLE 'despesas' ( 'id' int(11) NOT NULL, 'desc' varchar(200) CHARACTER...
asked by 19.02.2017 / 06:21