Questions tagged as 'mysql'

Tagged questions
1
answer

As I keep name of the images in a BD Mysql

Could you help me with this? I have a form in html with 3 inputs to upload photos, it works perfect but now I want to save the names of the images uploaded in a bd (when I upload these images are renamed without losing their extension) and my...
asked by 14.04.2017 / 17:52
1
answer

Optimize MySQL query

I have a query that takes 0.2650 seconds to run and I would like to optimize it, I have done a lot of tests (Add new indexes, delete them, create views) but nothing has improved the performance of the following query: SELECT enlace_click.id,en...
asked by 17.04.2017 / 06:18
1
answer

MySQL blank rows PHP

Good morning, I am forming a php form for a raffle. I have connected my form with the database and everything is correct My problem is that when I register the data that goes to the database are blank: I pass the connection code as w...
asked by 17.04.2017 / 17:08
0
answers

Drop down does not show data

I have the solution. I only had to change some connections if (isset($_REQUEST['action'])) { switch ($_REQUEST['action']) { case 'actualizar': // Recupero el id del campo hidden $alm->__SET('acro_documento', $_REQ...
asked by 18.04.2017 / 10:14
0
answers

create uncrud localstorage and mysql

Good morning I need your help, I'm making an application type of saved notes, that allows me to save the notes in the localstorage as in a mysql so that if the application is deleted you can keep the data on a server and thus never lose the s...
asked by 09.04.2017 / 16:36
1
answer

mysql Error Code: 1130

yesterday my mysql worked fine and now I start it and I want to enter my bd I get this error host localhost is not allowed to connect to this mysql server    and in error details Error Code: 1130 This error occurs because you don't...
asked by 08.04.2017 / 04:30
1
answer

Problem with setSelectedItem in JComboBox

I have a problem fixing an object in a combobox. I explain the situation. I have a mysql a table with a data series (client table), one of those data is a foreign key to another table (city table). In my java program I create an object with the...
asked by 22.04.2017 / 18:25
0
answers

sort MySQL query with two criteria

Good morning, I can not find a way to do the following. I need to make a query to a database that orders me first with a criterion, and after all the results with this first criterion, that the rest and computer go by the date of the last edi...
asked by 07.04.2017 / 16:23
1
answer

I have an error in a mysql query using php PDO

I'm starting PDO and I need to make a query, but I do not do it, I do not know if the problem is with the variables I use in the query or I'm declaring something wrong in my code. This code is the one of my variables: foreach ($_POST['ciuda...
asked by 07.04.2017 / 18:43
1
answer

Sort and replace positions in bd mysql

I have a table with these values Juan 5 Pedro 7 Luis 6 I want to replace the consecutive numbers that are listed from least to largest starting from number 1 ie a php script that detects that the table does not have the number 1 the...
asked by 05.04.2017 / 11:29