Questions tagged as 'mysql'

Tagged questions
2
answers

I have a problem with my PHP, apparently when I enter anything in username and password can log in even without being a user

I have a problem with my php, apparently when I enter anything in username and password I can log in even without being a user <?php session_start(); require 'conexion.php'; if($_POST['proceso_ingreso']=="iniciando"){...
asked by 26.06.2017 / 21:57
2
answers

Problem when displaying databases

I wanted to locate the route where my databases are hosted, with the aim of configuring a .bat file to make automatic backups. On the server where I have the PHPMYADMIN installed, I do the following, showing the following databases, and mine...
asked by 04.09.2017 / 09:19
1
answer

PHP-mysql error (PDO) [closed]

I have a question, I have this class: <?php class DB{ //Función para conectar con la base de datos public static function ejecutaConsulta($sql) { $servidor = "localhost"; $dbname = "vehiculos"; $usuario = "root"; $contrasena...
asked by 02.06.2017 / 17:36
3
answers

SQL query with String data

Hello, I have a query SQL implemented in JAVA in which I need to insert the values MTILM, MVisual, MVerba, MAR, MTeorico whose data is of type String, here I leave an example connectionDB.executeInsertUpdate("INSERT INTO 'data_process...
asked by 01.06.2017 / 21:37
2
answers

Error doing Left Join. The identifier consisting of several parts ... could not be linked

First of all, explain what I am trying to do so that you understand my problem. I am developing a web platform based on PHP to perform the maintenance of the different types of equipment that may be in an empesa (High, low and modification there...
asked by 18.05.2017 / 11:08
2
answers

In MySQL how should the data types be declared in case of using the following elements in JAVA

1) If you are going to create a password with JPasswordField, what type of data should be declared in the SQL database ... would it be varchar or another? I understand that the passwords are encrypted and ask for another type of data. 2) In t...
asked by 18.05.2017 / 03:41
1
answer

Record attendance (Entry and Exit) of an already registered employee - PHP & MYSQL

I am stuck with a system that I am doing for the university, and I need to know how I can make my system, which already registers employees of an institution, register the attendance of entry and exit. I have already programmed a CRUD syste...
asked by 30.06.2017 / 04:34
2
answers

How to translate fields in MySQL

I have some tables and fields in English in my database (and these should be like this). But on the other hand, when I make a select, the name of the fields have to be in Spanish. Example: - Name of the field in the database: employeeName - Name...
asked by 28.06.2017 / 23:24
1
answer

Why does not this query return results?

I have this query to mysql: SELECT * FROM 'Articulos' WHERE FIND_IN_SET('color', '310') AND FIND_IN_SET('talla', '305') AND FIND_IN_SET('empresa', '199') and here is a screenshot of php myadmin from the list of articles where you can see if...
asked by 09.12.2017 / 17:38
2
answers

Duplicate records mysql

I'm trying to show the duplicate codes in a mysql query. I'm doing it with this code: SELECT 'id', 'idarticulo', 'talla', 'color', count(*) FROM 'CodigosEan' GROUP BY 'idarticulo', 'talla', 'color' HAVING count(*) > 1 The problem is t...
asked by 10.12.2017 / 12:49