Questions tagged as 'mysql'

Tagged questions
0
answers

How to show MySql data in Chart.js with php?

I have a database that has these two tables: and what I want to do is show the percentage of coemrcial and residential that are loaded in a Chart.js with php, how could I do it?     
asked by 23.07.2018 / 15:01
0
answers

auto-loaded data with mysql

I am uploading data to a database in Mysql automatically with an arduino device, in my view I am showing this data, through a query in my controller public function show($id) { $consumes = consume::where('user_id', $id)->get(); foreac...
asked by 23.07.2018 / 14:58
0
answers

How to filter the download of a report in Excel by date?

   index.php <!DOCTYPE html> <html> <title>generando RIPS...</title> </head> <body> <div> <h1>Registros Individuales</h1> <div> <a href="relacion.php"> Generar reporte de...
asked by 23.07.2018 / 12:37
1
answer

Validate the month of a timestamp data fix with php and Laravel5.5

In my controller I bring the date of an element with created_at this returns an array with the dates in my database, I need to validate if within this data array is the 07th month or not. My problem is that pru brings me the month 1 if I make a...
asked by 24.07.2018 / 16:13
0
answers

insert of two tables related to a

Hello good afternoon everyone, along with hello I wanted to see if you can guide me in the following: have a table accounts with an id Autoincremental account, a field idRegistro and a user and password, this table will be to create user account...
asked by 01.08.2018 / 19:29
1
answer

Enter daily data in MYSQL with php

I am working on an app that receives 10 to 13 data and they are saved in a table of my BD, I need to add that data and that sum is saved in another field of the table, I am using Laravel 5.5. this is the driver: public function show($id) {...
asked by 27.07.2018 / 21:42
1
answer

validate existence before inserting (c #)

Hello good afternoon everyone, guys consult, I need that when wanting to insert a new record, before validating if a certain field already exists in the database, for this I have a procedure stored in mysql, I try it in workbench and I it works,...
asked by 27.07.2018 / 19:17
1
answer

Show Check Marking in PHP and MySQL

I have a value of a checkbox saved in the database (table = way, field = active, values 1 = Active, 0 = Inactive, Boolean field), but when the form needs to be updated and opened, it does not show the check marked, always leaves it unmarked....
asked by 27.07.2018 / 20:39
1
answer

Get the name of the databases stored in a DBMS

I am trying to make a connection to a database manager (postgresql, Mysql and Access) and I would like to know if there is any way to connect to the manager and extract the information from the name of the databases that are stored there. All th...
asked by 22.07.2018 / 01:59
1
answer

execute SQLServer and MySQL stored procedure from Java

good morning / afternoon / evening at the time you see this post the issue is that I do not know the syntax to call a SQLServer stored procedure from java example //para llamar a un una sentencia insert/update/delete/select utilizo PrepareStat...
asked by 22.07.2018 / 07:58