Questions tagged as 'mysql'

Tagged questions
2
answers

How to do click counter in PHP, MySQL and AJAX?

Okay, my question is to make a clicks or likes counter so that when someone clicks a <div> this add the click to a <span> anywhere in the article. This means that, if I have a new click on a photo, I put the total numbe...
asked by 22.06.2017 / 23:48
3
answers

Calculate hours worked [closed]

How about, I'm doing a program in c # that shows the hours of the employees of a store in a week, and also calculates the hours worked, the problem or what I could not calculate correctly are the hours worked, since I have two tables in a bd in...
asked by 21.07.2016 / 17:04
1
answer

Referential integrity problems and how to restore migrations in Laravel 5

Hi, I had some referential integrity problems making a model. Basically I had an article with a category and tags For tags create another table that has the id of the article and the tag, since it may contain more than one. Here I had the fir...
asked by 15.09.2016 / 19:33
1
answer

Remote access to MySQL

Good morning. I have been searching for some information on how to remotely access MySQL and I have found many tutorials (some of them in Stackoverflow) but after having tried them all I still can not access. The server where I have the da...
asked by 15.01.2018 / 23:17
1
answer

Does anyone know if it is correct that there is a table with only one record in a table and that this record is a primary key? [closed]

I would like to know if it is correct that there is a table in the database that contains only one record. And that this record in turn is a primary key. I have analyzed the logic of my relationships and can not think of anything else other than...
asked by 10.10.2016 / 21:34
1
answer

Comparison of mysql records with php array

I need to compare the id contained within a php array, with those of a field in a mysql table. The idea is NOT to show the id (of the php array) in the mysql query response. $consulta="SELECT * FROM permisos_pedidos WHERE id_cliente = '$id_us'...
asked by 02.06.2018 / 04:23
3
answers

select where in a field there are two commas

I have a table in mysql with a field called coordenadas with more or less information like this:    -75.99699,4.0537896 // 1 comma    -76.01502,4.085585,1390.0 // 2 commas    -76.478325,3.9739854 // 1 comma    -76.0716,4.1359...
asked by 18.11.2016 / 20:35
1
answer

API to connect Android with a local database [closed]

I am currently using Firebase to store the data generated in Android. My intention is to change Firebase for a local Mysql database that I would have in a computer that would serve as a server. My question is, is there an API to make this connec...
asked by 15.08.2018 / 12:54
3
answers

Run .sql file from php

I have to make a program in php that executes two files .sql, both will create a table within my database 'form of payments'. The .sql files I already have, I just have to do the program in php. This is the sql file: -- MySQL dump 10.13 Di...
asked by 03.07.2017 / 23:42
1
answer

Help with the following code, I do not know what the error could be [duplicated]

Form: <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <link rel="stylesheet" type="text/css" href="css/style.css"> <title>Validacion de...
asked by 12.12.2018 / 23:04