Questions tagged as 'mysql'

Tagged questions
0
answers

Incorrect table definition; there can be only one auto column and it must be defined as a key

I was generating the tables for my dbDaca.sql database, it turns out that I have the following problem: Knowing that my PRIMARY KEY FOR ALL MY TABLES is IdColaborador, that's why in each table I put a references. You will wonder why I p...
asked by 27.02.2018 / 15:36
4
answers

Why does the Inspector Character ( ) appear in some data obtained from the Database?

I was dealing with the dilemma of converting the accents and special characters of my system. It happens that now some of the data obtained from the database that have tildes come out with this: . The strange thing is that there can be up...
asked by 31.03.2017 / 12:53
0
answers

How do I show a certain shared folder to a certain user in php mysql?

This is the new code that fixes : <?php $active3="active"; include "head.php"; include "header.php"; include "aside.php"; ? > <div class="content-wrapper"><!-- Content Wrapper. Contains page content --> <sect...
asked by 09.03.2018 / 04:54
0
answers

transactions in PHP

I currently have a function that eliminates all the information about a problem in different tables with this code: function eliminar_ejercicio_por_id($idproblema){ $conn = db_connect(); $query = "DELETE FROM activacion WHERE idproblem...
asked by 09.03.2018 / 02:10
0
answers

Help with dynamic select

Hi, I'm doing a dynamic selection with php and mysql I found an example but it was not in mvc so I tried to change some things like the address where my controller is but it stays in a loop and does not show me anything in the select Este es m...
asked by 01.03.2018 / 18:31
0
answers

Load text file to mysql from form, using sql script and php

I'm trying to do the text file upload using sql script, try: Do not take into account the first row that corresponds to the headers. The table where it will be inserted has a defined id id field, the file does not contain that field, so I...
asked by 01.03.2018 / 19:09
1
answer

Please help me with this problem Err # 1235

First of all a big greeting, my problems are this: I have two different "secondary" tables linked to a "main" table, which I want to update when a record is inserted in the main one. This is my code: INSERT INTO Secundaria1 (a1, a2, P_ID) V...
asked by 01.03.2018 / 19:02
2
answers

Get combobox index in java and register it as boolean in mysql

Good evening I'm getting the index of a combobox to handle male or female and I want to register it in the database as a Boolean, I have this at the moment but it generates an error. int bb=combobox.getSelectedIndex();...
asked by 21.02.2018 / 02:13
2
answers

Uncaught ReferenceError

Good Day, I have a sweet alert feature: function myIdNo() { swal("Ooops", "No existe!", "error"); } And in an if I execute it like this: if ($sql === FALSE) { echo '<script type="text/javascript"> myIdNo();...
asked by 20.02.2018 / 22:57
1
answer

how to pass data from mysql to textbox with js

Hello good afternoon, I need help with a problem. I want to pass the results to the textbox with js and I do not know how to just show it in a label ... Help .. thanks <!DOCTYPE html> <html lang="es"> <head> <t...
asked by 28.02.2018 / 20:03