Questions tagged as 'mysql'

Tagged questions
2
answers

Ajax does not run correctly

The structure of my project is as follows: and I have the following code: Login_inicio.html <!DOCTYPE html> <html lang=""> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" conten...
asked by 21.12.2017 / 05:13
1
answer

disappeared record of a mysql table

In an inscription table to attend an event, the "7" record has "disappeared". It does not appear on the screen when you dump the table with $query="SELECT * FROM aligxager"; $results = mysql_query($query,$link) or die('Error en la petición S...
asked by 31.03.2017 / 09:57
2
answers

Update a field in the same table with a trigger

I would like to be able to update a field in the same table where the Trigger is triggered, I have read that when the trigger is triggered the table is blocked and can not be modified but it can be done in another way. CREATE TRI...
asked by 14.02.2017 / 13:57
1
answer

help with using CONCAT in php

I'm making a query and I want the ID to tell me with the ID and name in the interface and I'm using this code <?php include('conexion.php'); $paginaActual = $_POST['partida']; $nroProductos = mysql_num_rows(mysql_query("SELECT * FROM repor...
asked by 13.02.2017 / 19:05
1
answer

MySql Update innerJoin

How do I make this query: I have 3 tables A B and C Table A is related to ID's of Table B . I need to get the ids of B whose xcampo equals xcampo of C . now you must update...
asked by 14.02.2017 / 16:10
3
answers

Error closing Connection, Statement and ResultSet within try-catch-finally in Java, can not be resolved as variable

I still have problems to close my connections correctly, the error I have now is that the variables of Connection, Statement and ResultSet, says that I must create them locally, so what should I do?. My code: String showTableSQL = "SELE...
asked by 26.11.2016 / 14:18
3
answers

Problem when saving decimal values (monetary figures) in a mysql database

At the moment I am saving several values that represent monetary figures, these values are extracted from a csv file and inserted into a database mysql . Some of these values are found as follows: // pueden llegar con el punto de mil // s...
asked by 29.12.2016 / 15:29
3
answers

Error PDOStatement :: bindParam ()

In response to the advice you gave me in the question I asked a few days ago ( Update records using PDO ) I am changing the code to avoid SQL injection with PHP. The issue is that when I run the update page I get the following error:    PD...
asked by 29.12.2016 / 17:35
3
answers

PHP - Disadvantage when using the mysql extension [closed]

Good, I need help to extract the data from the logged in user in my system. This is my database with their respective fields: What I want to do is that when the user enters, his / her email will be visible in all the following pages. Tr...
asked by 09.06.2016 / 20:59
2
answers

Count the records of a single month

I am doing a simple consultation to obtain the records of a single month, in my case, the current month. I have a table that saves the date in 17/12/2018 01:12 format since the client asked for it this way. What I try to do is this:...
asked by 17.12.2018 / 05:56