Questions tagged as 'mysql'

Tagged questions
0
answers

Show data of an input type text in table with PHP

I would like to know how I can capture the data of an input type text inserted in the MySQL DB and display them in a table with PHP using an array, since with the other inputs it works correctly for me but it does not work with the input type te...
asked by 15.10.2018 / 06:12
1
answer

Appear an alert that can not be repeated

Hello good morning I have a file upload that is uploaded with a combobox which is called in the database image_text I would like that combobox would not be repeated the option put in the combobox this is my insert <?php session_start();...
asked by 04.10.2018 / 16:34
0
answers

when exporting data from a query in php mysql the csv file contains html

At the moment of generating the CSV file it only contains HTML, I checked my query and there are no null values, or anything like that, I leave you a photo of the code and I thank you in advance for your time. Greetings brothers! CSV outp...
asked by 04.10.2018 / 17:01
1
answer

how can I show the next number stored in mysql in spring boot + jpa?

Greetings to the community I have a problem in being able to find a solution to my problem if someone can support me in the solution is to be able to show is the following number stored in my database the number is 1 and I want you to show me...
asked by 06.10.2018 / 01:14
1
answer

SUBMITTING FORM DATA TO SEVERAL TABLES

someone to help with the scrip php to be able to insert the data to mysql of my form to several related tables <!DOCTYPE html> <html lang="es"> <head> <meta charset="utf-8" /> <meta http-equiv="X-...
asked by 10.10.2018 / 18:44
0
answers

Error in creating an EntityManagerFactory using Persistence.createEntityManagerFactory

Application in NetBens 8.2 MySQL Database BD connector: jdbc 8.0 HIbernet 4.3.x This is my persistence.xml class within the META-INF <?xml version="1.0" encoding="UTF-8"?> <persistence version="2.1" xmlns="http://xm...
asked by 16.10.2018 / 17:11
1
answer

Convert result Json objects in List Json ?, using php and mysql

PHP code to show results of a query to MySQL (returns json object) if ($result = $mysqli->query("SELECT ID,NOMBRE,NICK,PASSWORD,EMAIL FROM ud_Usuario")) { // check for empty result if (mysqli_num_rows($result) > 0) {...
asked by 16.10.2018 / 15:49
0
answers

mysqld_multi does not start servers

I'm trying to create a master / slave in Mysql about CentOS (3.10.0-862.14.4.el7.x86_64) but I can not start it. /usr/bin/mysql --version /usr/bin/mysql Ver 14.14 Distrib 5.6.41, for Linux (x86_64) using EditLine wrapper The content of /e...
asked by 05.10.2018 / 09:57
2
answers

Insert in MySQL if there is no field

How can I insert one into MySQL only if there is no field? For example: INSERT INTO persona (nombre, apellidos, edad) VALUES ('Nombre', 'Apellidos', 25) WHERE NOT EXISTS (SELECT nombre FROM persona WHERE nombre = 'Daniel')     
asked by 08.10.2018 / 14:29
1
answer

Duplicate sqlserver join

Hello good day I have a question, I have a table that says products and one that says equivalents and linked results that I do the query with joins where is this way: Productos Equivalentes Ligados 00697000 MS-92692 MU-41309-P...
asked by 04.10.2018 / 22:49