Questions tagged as 'mariadb'

Tagged questions
2
answers

Error executing a query. I need to show how many alarms per operator

This is my code: public function alarmaAtendidaO() { $data = \DB::select('SELECT operadors.nombre AS Nombre, operadors.apellido AS Apellido, (SELECT COUNT(ala.id) FROM alarmas ala INNER JOIN operadors op ON op.id = ala...
asked by 21.06.2017 / 21:05
2
answers

error when doing procedure with cursor

I try to do this CREATE PROCEDURE temporal( IN temp INT) BEGIN DECLARE maxima INT SELECT MAX(ventas) FROM vendedor INTO maxima; CREATE TABLE ven_temp AS SELECT id_vendedor FROM vendedor; WHERE ventas=maxima; COMMIT; END; mark me:...
asked by 21.04.2017 / 09:19
1
answer

Vagrant with php7 and MariaDB?

I've been looking for how I can run vagrant with a virtual machine that has php7 and MariaBD, but I have not found it like. Someone who has an environment so you can help me ?. Note: I attached a link on which I base to mount an environment with...
asked by 04.12.2016 / 19:41
1
answer

php select form with fields from another table without being connected

CREATE TABLE 'pedidos' ( 'pk' int(3) UNSIGNED NOT NULL, 'residentes' varchar(50) COLLATE NOT NULL, 'dniFamiliar' varchar(10) COLLATE DEFAULT NULL, 'servicios' int(3) NOT NULL, 'fecha' datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=la...
asked by 21.11.2018 / 11:54
2
answers

How to edit a record of a table in php?

Very good! It is the first time that I have this strange error that appears when trying to edit a record of the table called state in php format in conjunction with html in the database I still use PhpMyAdmin. I have been updating with the sql...
asked by 26.05.2017 / 16:23
1
answer

PHP Error when inserting MYSQL data

Hi, I'm trying to insert data into my mysql tables, but I have trouble inserting it. It turns out that I want to insert my data in these two tables: This is the code of my form maintenance_employee.php : <form action="php/regis...
asked by 21.06.2016 / 09:00
1
answer

MySql connection linux server from app in windows

I do not know if this query is in the target range of the page. Has anyone ever encountered having to connect an application from visual studio to a DB MySql hosted on a linux server? Try connecting to a connection string by changing t...
asked by 18.12.2018 / 14:23