Questions tagged as 'phpmyadmin'

Tagged questions
1
answer

Drop down list with PDO [closed]

Good morning, I'm trying to get the data in a combo and I do not know if something fails me, you should show me the fixed options. $pdo = new PDO('mysql:host=localhost;dbname=prueba', 'root', ''); $sql = "SELECT acro_subcategoria FROM tipodocu...
asked by 18.04.2017 / 11:05
1
answer

Left Join does not return null values in PHPmyAdmin

Hi, I'm trying to make this query: SELECT consulta.id_consulta,actu_consulta.fecha_actu FROM consulta LEFT JOIN actu_consulta ON consulta.id_consulta=actu_consulta.id_consulta_actu And the funny thing is that this query i...
asked by 14.02.2017 / 12:42
1
answer

What is missing from my SQL sequence?

You see, I have to list some basic data for a sales report by dates, the problem I have is the following, if a client in the invoice 2 buys 10 articles I list the values of each article and what I need is that I totalized the total value of the...
asked by 12.02.2017 / 03:43
1
answer

Mysqli with php saves all empty data

E Fixed error "undefined index" with if, what happens is that I save empty data now in the database, without if I get error and just the empty guard, see something I do not? help please ............. This is the form, the select is nothing mo...
asked by 28.02.2017 / 05:37
4
answers

Mysqli saves the empty records from Php

Good morning everyone ..... I have a problem in which my form should send the records to my database, but what it does is keep my records completely empty, I leave my code and hope someone can help me, thanks. . This is my form, here I assign...
asked by 28.02.2017 / 17:03
3
answers

Sentences prepared in PHP

I have a query in SQL , but I do not know how to do it or pass it in routine PHP , since I must make that report. In MySQL it works perfect, but how to do a routine in PHP for this query : SET @sql = NULL ; S...
asked by 17.11.2016 / 17:32
1
answer

INSERT INTO ... SELECT ... ON DUPLICATE KEY

I need to know what could be wrong with this query: INSERT INTO 'turnos_enviados'('rut','hora_envio', 'turnos') SELECT "12345678", 'hora_envio'+1, "string cualquiera" FROM 'turnos_enviados' ORDER BY 'hora_envio' ASC LIMIT 1 ON DUPLICATE KEY UP...
asked by 08.11.2016 / 05:34
2
answers

Problem to insert data in a database from PHP

Good morning everyone! Well, my problem is the one mentioned in the title. From a form in php I'm trying to get the data I collect inserted in a bbdd, and I can not find the fault. First HTML document called "index.html": <docty...
asked by 24.11.2016 / 16:30
1
answer

Why do you repeat the data?

Good morning I'm doing a query on mysql trying to bring only one result per date but it's bringing me more than two results from the same date, someone to help me with what I have to remove or add to the query. SELECT DATE_FORMAT(fecha_pe...
asked by 01.08.2016 / 17:12
0
answers

Query prepared in web server with PHP JSON for Android

I have a small problem. Thanks to another partner here is how to prepare inserts prepared in the databases, but with that same model I do not know how to recover a prepared query and recover it in Android. Problem 1 the query: Generally when...
asked by 28.12.2018 / 10:09