Questions tagged as 'mysql'

Tagged questions
1
answer

Automatically delete a record from a table after a time interval

How do I stop the log after a time interval, such as in a shopping cart, for example?     
asked by 18.12.2017 / 13:29
0
answers

How to return, via PHP, the address of an image inside a text saved in mysql?

I'm developing a news portal and want to return a variable that contains the address of an image, so that the final result shows the image within the news text. The first attempt was to insert the tag
asked by 18.12.2017 / 02:16
1
answer

SQL Summation

I need to make a report with SQL , which asks me the following situation. In the general report, I need it to look like this: Produto Quantidade Total Valor total Salpicão 30kgs 810,00 The detail is,...
asked by 19.12.2017 / 13:59
1
answer

Appear date automatically when creating form

I have this code: <p><h5><strong>Data de Atribuição</strong></h5> <input id="DataAtribuicao" type="text" name="DataAtribuicao" value='<?php echo date("d/m/Y"); ?>'> But I wanted the same but wher...
asked by 09.01.2018 / 20:43
1
answer

Roundup of 5 in 5 cents

In a PHP system I'm developing, I need to update a column of the price table. The price field is in float format and the administrator informs the percentage of increase. Example: Reports that it will have a 10% increase. $valor_anti...
asked by 27.02.2016 / 16:17
1
answer

Error in update sql: Subquery returned more than 1 value. This is not permitted when the subquery follows

I am doing a query to change the net cost of a product according to a brand, but I get the following error message:    Subquery returned more than 1 value. This is not permitted when the   subquery follows =,! =, & lt ;, < =, & gt ;, >...
asked by 10.01.2018 / 12:56
1
answer

FireBird and MySQL

I'm developing a web system, I need to fetch data from a table, the data is in Firebird but I need to replicate it to a mysql database with every insert made in Firebird. Case: There is an existing system using Firebird, which I can not use, so...
asked by 04.01.2018 / 00:10
1
answer

How to call the value of a Subquery inside another Subquery being that they are in the same View

I have a View with several Subqueries, one of them should be used to generate another Subquery within the View itself but I'm getting error, eg: (SELECT COUNT(0) FROM 'LICENCAS' WHERE ('LICENCAS'.'FK_PEDIDO' = 'A'.'FK_PEDIDO') AND Dia_Cor...
asked by 05.01.2018 / 19:42
2
answers

Refresh page while submitting form

I have this code and form and clicking on register to insert into the table (which already inserts correctly) I wanted to update the page automatically to update a query that I show the user before. <?php $servername = "xxx.xxx.x.xx"; $u...
asked by 19.01.2018 / 15:12
1
answer

Item count in cart

I'm doing a cart in ajax, but I'm having trouble sending the products to the bank. I could use CSS in the li tag to indicate the numbering of the item, but it does not solve the problem for sending to the bank. HTML <input name=...
asked by 31.12.2017 / 10:33