Questions tagged as 'mysql'

Tagged questions
1
answer

problems with textarea and php

I have 2 textarea and the user puts several integers and does the search well, the problem is when he places a enter more in the end the program fails, any ideas? So far so good but then come the possible failures:...
asked by 08.05.2018 / 14:25
0
answers

What can it be? Warning: mail (): could not connect to the mail server on port 25 "localhost",)

   Warning: mail (): could not connect to the mail server on port 25 "localhost", check your settings "SMTP" and "smtp_port" in php.ini or use ini_set () $cabecera="From: TickenSystem Venezuela<[email protected]>"; $mens...
asked by 06.05.2018 / 18:52
0
answers

How can I delete tables from another database connection in laravel with php artisan migrate: fresh

I am working on a system where I need to connect to two databases, I was able to generate the connection so that at the time of migrations, I generated the tables in their respective database. My problem starts when I try to delete them and m...
asked by 21.05.2018 / 17:04
0
answers

MySQL Update Procedure

Create a procedure to update the sale price of the products so that: a. If the selling price is lower than the average, the 10% selling price b. If the selling price is higher than the average it increases by 5% The procedure has to re...
asked by 06.05.2018 / 17:51
0
answers

Combox jquery php

I have a 3-level combox, it only brings me first, the next one shows me empty here the code select < select id="estado" name="estado" class="form-control" > < option value="0">Estado< /option> <?php whi...
asked by 05.05.2018 / 14:08
1
answer

Change value of an SQL column

I am doing a project in laravel and MYSQL, I would like to know if there is any way that if the stock is different to 0 the state becomes 'not available', in case there is no MYSQL, there is a manager of DDBB that allows me?     
asked by 05.05.2018 / 19:16
0
answers

MySQL Two select in a query

My Mysql query is as follows: SELECT MONTHNAME(FCH_ABST) as MES, YEAR(FCH_ABST) as ANIO, TTL_VNTS AS MQ01 FROM maquina6_abastos WHERE NM_MQ = 111 AND FCH_ABST BETWEEN '2018-01-01' AND '2018-04-30' What this table returns to me as a res...
asked by 04.05.2018 / 19:53
0
answers

php search

I want to do a search by cedula, and if it is found that I reton to an edit but if it is not found that I return the value to a register but it does not return anything to me This is where I do the search < form action="" method="POST"&g...
asked by 15.05.2018 / 22:44
0
answers

UPDATE that is done after sending the next UPDATE

The problem only happens to me in the field "inputs_available". I try to do an UPDATE and what happens to me is the following: I run the following UPDATE query: UPDATE evento_lugar SET entradas_disponibles = 12 WHERE id_evento = 1; What...
asked by 04.05.2018 / 08:20
0
answers

Excel file generated in php and mysql does not open?

I have the following code that creates the file in excel but it does not open and he opened it with my code editor. <?php require 'Classes/PHPExcel/IOFactory.php'; require 'conexion.php'; $sql = "SELECT id, nombre, precio, exi...
asked by 04.05.2018 / 14:25