Questions tagged as 'mysql'

0
answers

Open port 3306 iptables

I am setting up a virtual machine as a database server on a CentOS 7 and I want to open port 3306 to connect from the host machine. The rule that I have set is the one shown in the capture However, it does not allow me to connect, wh...
asked by 19.02.2018 / 20:42
1
answer

How can I get the comments of the articles with two different tables with php PDO MVC?

This is my first message in this forum. I have to print the results of several sections, for example, the articles in the "fes_articles" table and the comments in the "fes_comments" table. At the beginning they ask me first on the left to tak...
asked by 10.02.2018 / 16:39
1
answer

how to insert data from an array into a table

Hello good afternoon, I have been trying to solve a problem for a while I'll explain: I have a form that when I send the data I store it in an associative array to pass it in the constructor of the class since there are many variables and...
asked by 31.01.2018 / 21:26
1
answer

Ubuntu server error when inserting long string in mysql

Hi, I am using a new installation of ubuntu server 16.04.3 LTS, I have problems when inserting a string in mysql, I think it needs configuration and I have it by default. The fact is that when I send a string for $ _POST of more than 164 char...
asked by 29.01.2018 / 19:32
0
answers

Combine several tables and bring two records of a specific table mysql

Greetings to the community, I do not usually ask much, but this time something is giving me a headache, I am a beginner and I have a problem, I do not intend to solve it but if they guide me it is a great help. Veran I have two tables cases_...
asked by 30.01.2018 / 19:02
1
answer

Show user logged in php

Greetings, I have a basic log system, but I want you to show who is logged in, here is my code: <?php /* start the session */ session_start(); ?> <!DOCTYPE html> <html lang="en"> <head> <title>...
asked by 26.01.2018 / 23:19
1
answer

Send float using json

I am trying to send a number with a comma through JSON to save them in a MySQL database through a api rest created in node js. Endpoint code router.post('/', (req, res) => { const sensorData = { id: null, temperatura:...
asked by 04.02.2018 / 21:13
1
answer

mySQL. Nested query on a table

I bring you a question I have about a query that brings me headlong. I have a single table that is inherited from a previous project. In the table among many other data, I have a DNI, a certificate date (FCert) and a renewal date (FRev). In t...
asked by 15.01.2018 / 19:02
1
answer

subtract values from two php functions

I'm adding two fields and everything works fine. The problem is that I do not know how to subtract those two values to find the difference, because the values of Cant. Bet and Cant. Won calculate them by means of a function each and I want to sh...
asked by 02.02.2018 / 20:00
0
answers

Problem connection form to the mysql php database [closed]

I try to access the database from a form, and it does not take me anywhere. If someone could help me ... thank you! The code is as follows: <?php session_start(); if(isset($_SESSION['admin'])){ require '../php/Funciones.php'...
asked by 22.01.2018 / 18:37