Questions tagged as 'mysql'

Tagged questions
1
answer

Change the style of TABLES mysql html

I'm doing a CRUD and I'd like to modify the way the tables look. Currently the code is: <?php $conexion = mysqli_connect( "localhost", "root", "", "bdnutriologo")or die( "Problemas con la conexión" ); $registros = mysqli_query( $conexio...
asked by 19.04.2018 / 17:11
2
answers

Query mySQL show a result of several that are duplicated

Good morning, I just autocomplete an input via mySQL the problem is that if I have in a table clients, the names camilo Camilo Carlos by pressing "c" in the input the three results appear, that is to say, the two camilos usually take...
asked by 27.03.2018 / 00:12
1
answer

Syntax error when trying to insert data into MYSQL with php

When trying to insert the parameters of "User" and "Password" extracted from an HTML form, I miss an error of mySQL Syntax. This is my code when inserting my code require_once ('Conecction.php'); try { // Iniciar la conexión a la base...
asked by 19.03.2018 / 19:32
1
answer

MySQL search engine

I'm trying to implement a word search in a mysql table I have a number search engine that, although very simple, works perfectly: <?php if ($row['albaran'] == $_POST['buscar']): ?> <?php endif; ?> This shows the...
asked by 19.03.2018 / 10:27
1
answer

decrypt a previously encrypted database element with mySQL

When I save a password element in my database, I save it with sha1 (...) and this is saved, for example, if I put hello , in the following way: fc1815288c56c87a05ef3cfd10738015bc5c1129 <?php $conexion=mysqli_connect('localhost','ro...
asked by 17.03.2018 / 18:30
1
answer

PASS JSON DATA FROM ONE TABLE TO ANOTHER IN MYSQL

Hi, I would like to know if someone can help me with this inconvenience that I have. In a column of a table in Mysql a list JSON is saved like this: { "Sender": "[email protected]", "X-Mailgun-S...
asked by 16.03.2018 / 15:51
1
answer

Data is not inserted correctly in MySQL database

I try to insert data from a form into a database. When I fill in the form the code is executed correctly and does not give an error. I have a variable ID that auto increments and every time I execute the code a new record appears but in the othe...
asked by 23.03.2018 / 22:07
1
answer

Illegal mix of collations (utf8_unicode_ci, IMPLICIT) and (utf8_spanish_ci, IMPLICIT) for operation '='

I am trying to perform an UPDATE involving two different databases using MySQL. The query I have is the following: UPDATE sm4rtuniversity.members SET chamilo_id = (SELECT cu.id FROM chamilo.user cu INNER JOIN sm4rtuniversity.members sm ON...
asked by 21.03.2018 / 19:41
2
answers

Bulk file import from excel.CSV Notice: Undefined offset: 1

I make a massive import form of excel.CSV, I care about all the records but when the process ends it shows me this error: Notice: Undefined offset: 1 in C: \ xampp \ htdocs \ import_excel.php on line 27 Notice: Undefined offset: 2 in C: \...
asked by 15.03.2018 / 10:52
2
answers

Error the Mysql when uploading to the hosting with Laravel

I have changed the data in .env with the new data that the database hosting gives me and when I go to enter it gives me an error: I'm using webhostapp.com as hosting And I have changed in options the php version to 5.5 ErrorException in MyS...
asked by 05.03.2018 / 13:14