Questions tagged as 'mysql'

Tagged questions
0
answers

How to interact with the MYSQL database of another PC in PHP

Now I am trying to connect to a database that is on another PC, we are both on the same network, what happens is that this other PC presents an updated data table that is modified daily, so I need to do the queries there. we are both in the same...
asked by 19.09.2018 / 15:25
0
answers

Prevent a foreach from doing a duplicate INSERT INTO

I have the following code: <?php function entregar_pedido(){ global $db; $id_pedido = ($_GET['id']); $user = ($_GET['user']); //$lote = $_REQUEST['lote']; $lote = "1 1111 1111 1111 1111 1111111111111111 2 2222 2222 22...
asked by 22.09.2018 / 17:51
0
answers

Get json towards PHP object - Android studio

I have a php where I make a selection to a table of regions, I get the name and return it through PDO as an object. Then in android studio I capture the answer, returns an empty object. I attach images of php and the respective android cod...
asked by 04.10.2018 / 05:38
0
answers

Fill logbook table with an INSERT TRIGGER after saving in the table bagones

Create the trigger but when the insert is executed it gives the following error: TRIGGER Code DROP TRIGGER IF EXISTS 'bin_bagon_ins'; CREATE DEFINER = 'root' @ 'localhost' TRIGGER 'bin_bagon_ins' AFTER INSERT ON 'bagon' FOR...
asked by 12.09.2018 / 19:32
1
answer

Query that calculates the state according to other tables

Thank you for reading me, I am using Php and MySql, I have in a table fees and in another table the payments of those fees. How can I know what fees are unpaid and what are not? TABLE_CUOTES id amount dateVenture PAGOS_EFECTIVO idCuota amo...
asked by 11.09.2018 / 23:49
0
answers

Data Filtering in Codeigniter, Mysql

I'm doing a search and filtering it with $this->input->get('tags') . The problem I have is that the data with which I will filter is in a table from 1 to many, where one can have multiple data. The tables I have in the database...
asked by 11.09.2018 / 21:19
1
answer

How can I connect to a MySql database, through webhook in Dialogflow?

What happens is that, I'm working with Dialogflow , given that I'm creating a Chatbot for a company, so through webhook, in the Fulfillment options I'm connecting to a Firebase database asi. const functions = require('firebase-functions');...
asked by 25.09.2018 / 04:52
1
answer

Return values so this empty MYSQL

Greetings I am doing a query in MYSQL but if it is empty the where in does not return values to me. SELECT objects.*, GROUP_CONCAT(mvalues.value SEPARATOR ", ") as value, GROUP_CONCAT(mdescriptor.name SEPARATOR ", ") as name FROM objects JOIN...
asked by 13.09.2018 / 14:30
2
answers

Put Alert of confirmation in this code

Hello, someone could help me how to put an alert that first tells me if you want to confirm whether or not in this code THIS IS MY JAVASCRIPT function Fagregartecins_inc_67(){ //alert("Incumplió rta1"); tec_inc_id_tecni...
asked by 25.09.2018 / 12:51
1
answer

Consulta Model Codeigniter

Hello everyone I have a question the question is, I have in the database 3 tables student, tutor and person. Student has foreign keys to person and tutor, my question is, I have problems to bring the name of the tutor, I need the name of the stu...
asked by 12.09.2018 / 12:56