Questions tagged as 'mysql'

Tagged questions
0
answers

Error uploading site in WORDPRESS

I developed a site in WORDPRESS and my local server is working correctly. When uploading it, I made all the necessary settings (change base URL in bd, configure wp-admin), only specifically one page is not loading completely. In certain part of...
asked by 15.05.2017 / 23:44
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13
1
answer

Installment for mysql [closed]

I am doing a sales system in which 1 sale generates 12 parcels to 3 users, being the seller, the manager and the supervisor, I would like to know the best method for storing these parcels. Would you create 1 table for each user and when you m...
asked by 15.05.2017 / 20:07
1
answer

How to query MySQL and PHP database [duplicate]

I made a registration form that adds the information to the MySql database. But I created a query form and would like to know how to return information from the database. Insert.php <?php error_reporting (E_ALL & ~ E_NOTICE &...
asked by 26.05.2017 / 05:05
1
answer

Problem sending PHP to MySql

Good evening. I have a big problem and I can not solve it. I created a form to register and when I click send, instead of sending, the PHP code appears. I have already installed XAMPP and then WAMPP, but it does not work at all. HTML: <!...
asked by 26.05.2017 / 01:09
0
answers

failed, register data in database

Hello, I'm having some problems trying to register the form data in bd, Form Code: <form class="form-horizontal" method="post" action="processa/proc_cad_star.php"> <div class="form-group"> <label for="inputEmail3" class="...
asked by 14.05.2017 / 07:13
1
answer

Remove data from one table from the average of notes in another table?

Tabela - lista id | nota 1 | 10 2 | 8 3 | 7 1 | 8 3 | 9 I want to average the grades of those who have the same ID, and for this I have created the following query: SELECT AVG(nota) FROM lista GROUP BY id With this query I want...
asked by 13.05.2017 / 23:29
1
answer

Safe update error using stored procedure in MYSQL

I'm having trouble updating my stock table using a stored procedure in MYSQL. Here is the code: CREATE DEFINER='root'@'localhost' PROCEDURE 'atualiza_estoque'(id_produto int) BEGIN update estoque e inner join reposicao r on r.produto = e.prod...
asked by 13.05.2017 / 00:13
1
answer

Error 1452 Mysql

I'm starting mysql, so do not look at bad tables. Anyway I have the following tables: create table Alunos ( MAT int, nome varchar (45), endereco varchar (45), cidade varchar (45), constraint primary key (MAT) ); create table Disciplinas (...
asked by 13.05.2017 / 01:32
1
answer

Doubt of vector sum and recording in bank

I have this simple form <form> <div class="itenspedido"> <h4>Itens do Pedido</h4> <div id="itens"> <div class="div-bloco-form">...
asked by 21.05.2017 / 01:24