Questions tagged as 'mysql'

Tagged questions
0
answers

Consuming a service in Visual Basic published in PHP

How can I extract the data by consuming a webservice from PHP and return me in datagridview of Visual Basic as they can observe in a query several data Imports System.Data Imports System.Data.SqlClient Imports DESCARGA...
asked by 13.10.2017 / 13:56
2
answers

Add value of a table related to itself

Hello I have a question about how to make a query in sql to add the total time it takes to produce the product. The diagram is a table of products that has sub-products, the design is an NN relationship with itself so I made an auxiliary tabl...
asked by 13.10.2017 / 12:04
1
answer

List data omitting repeated and add them in MySQL

I have the following table: Payments and the fields you have are idpagos , codigo_empleado , fecha_pago , trimestre , monto_pago The payment quarter is because the employees are paid 15 and last of each month...
asked by 12.10.2017 / 18:19
0
answers

I can not prepare a query to the DB

I'm new to PHP and MySQL, right now. When I try to send the data of a user that is registering, it does not do anything to me, and when placing an else in one of the conditionals I realize that the query that is being prepared does not valida...
asked by 12.10.2017 / 19:24
1
answer

INSERT, DELETE AND UPDATE in Crud does not help me

Good morning I'm doing an exercise in which they ask me to make an ABM form and I did it in the following way this would be the file edit.php where is the update button that leads to another page to edit the data and then update them in the i...
asked by 16.10.2017 / 05:53
2
answers

Query count the INSERT of a month

I want to count the INSERTs made in a month, for that at INSERT I have a field called date $fecha=date("n/Y"); but I want to count how many INSERT I made on that date, and then show it on a graph with Morris.JS X seria la el mes y año...
asked by 11.10.2017 / 16:42
0
answers

problem with slash when saving a route in mysql with php

Good morning, I hope you can give me a hand ... I need to save a file path in MySql with PHP I've already tried using // as I read in other sites here the code <?php mkdir("../uploads/solicitudes/solicitud".$nuevo_id2, 0700);...
asked by 10.10.2017 / 19:24
2
answers

SQL query with two fields

I have the problem in an SQL query because in a field with auto complete I return the full name of the person I'm looking for in this case are first and last name, that sends it by post to a php file that generates the table Starting from the SQ...
asked by 10.10.2017 / 23:37
1
answer

Selecting data from the database with Mysql

I have a problem because I'm doing a data search in MySQL with a select and a where so for example: select * from $tabla where categoria = :categoria and ambitos = :ambitos The problem is when I want to bring all the da...
asked by 20.10.2017 / 13:41
1
answer

Pass MySQL query to Eloquent

Good I would like to pass a query to Eloquent, but it does not work for me. I think it's because of the subquery, but come on, I do not know. Greetings and thanks in advance Here I leave my Eloquent query which is not well done: public func...
asked by 17.10.2017 / 17:52