Questions tagged as 'mysql'

2
answers

Pass The Container text span id to a PHP Variable

I have a Video Game programmed in HTML and JavaScript from which I wish to pass the points obtained to the MySQL Database and I can not find the correct way to achieve it. JavaScript Code: function updateScore(){ var score = (snakeLengt...
asked by 15.01.2016 / 03:20
4
answers

Problem to save data with CKEDITOR PHP AND MYSQL

I'm trying to insert data from a CKEDITOR into a mysql database with php, but I'm trying to capture that data through different modes that I found on the web, but I can not insert the CKEDITOR content in a field of the BD: htmlentities, htmlspec...
asked by 05.10.2016 / 02:48
1
answer

Group and show averages of a subquery that uses union

I have a table with the following data .. INSERT INTO Partido (nro,cod_local,gol_local,cod_visitante,gol_visitante) VALUES (1, 'AR', 2, 'CL', 1), (2, 'US', 0, 'CO', 2),...
asked by 19.06.2016 / 02:43
2
answers

Insert 'N' times of records with the same Input

Good morning I have a form where the input is generated automatically with a for depending on an assigned number. In short, a form of 4 fields is generated n times to be saved information for the same id. The problem is that the inputs are ge...
asked by 15.06.2016 / 16:56
2
answers

Mysql server in localhost does not work

I tried to install a mysql server on my local machine but I can not get it to work. I downloaded the zip from here: link Then I followed these steps: link But I get the following error:    ERROR 2003 (HY000): Can not connect to M...
asked by 27.07.2018 / 15:53
2
answers

empty the records of a mysql table with event_scheduler 24h

I want to make every 24 hours vacíen the records of a table from the web. what I wear in javascript is this is not much but is more or less see the idea var now = new Date(); var hours = now.getHours(); if ((hours>=...
asked by 16.08.2018 / 00:16
1
answer

Disable days in a datepicker if records already exist

I'm making a system where patients can request appointments online. At the moment I have a datepicker in my code as follows <script> $( function() { $.datepicker.setDefaults($.datepicker.regional["e...
asked by 07.08.2017 / 07:04
1
answer

MYSQL - Error 1148. The used command is not allowed with this MSQL Version

Trying to load data into a table gives me this error.    Error Code 1148: The used command is not allowed with this MySQL version The function I use is:    load local data infile 'C: \ Users \ xSyn \ File.csv' I've been searching t...
asked by 30.09.2018 / 20:59
1
answer

Consult twice the same table

I have the holiday table which has two fields, one that is authorize_id and request_id, makes references to the same employee table, I can already show the name of the one who authorizes by means of the id, but I do not know how to show the name...
asked by 28.08.2018 / 19:45
2
answers

Update with IF - SQL MySQL

I have to change the value / state to an ENUM ('0', '1') of a field in a table. I'll do it with an UPDATE query with if included. cambiar_estado.php: <?php //Dormimos el proceso unos segundos... sleep(3); //Consulta para act...
asked by 15.11.2016 / 13:26