Questions tagged as 'mysql'

Tagged questions
1
answer

disable option in drop-down list

I have an error in the code I am doing, since it is duplicating the options of a list (agenda) that lasts for 15 minutes. The form records everything very well and when I come with the foreach to disable the drop-off list the time that has al...
asked by 28.08.2018 / 18:51
2
answers

Blocking when using AJAX making multiple queries to MySQL

I could not determine a good title for my problem but it is the following one, I am doing a small page to make queries to a database, the idea is that while the user writes in an input the results are shown in a table , for that I am implemented...
asked by 28.08.2018 / 17:52
1
answer

2 connections to Mysql in the same PHP

I have a problem with connections to mysql currently from a PHP I establish connections to mysql in the following way <?php $date = strftime( "%Y-%m-%d %H:%M:%S"); //FECHA function conectarse($host,$usuario,$password,$BBDD){ $link...
asked by 27.07.2018 / 21:53
2
answers

Error when trying to insert an insert into MySQL

I'm doing a procedure in which I create a temporary table and fill it with the result of a query, or at least that's what I'm trying to do. I have the following script: CREATE TEMPORARY table tblTemporal( id bigint AUTO_INCREMENT PRIMARY KE...
asked by 21.07.2018 / 18:41
1
answer

C # Read name of local or remote Database

I need you to help me with something I do not know where to start. The idea is to read with C # the name of the database (MySQL) that is running on the pc where it is running, and subsequently, the tables that are under it. The latter is e...
asked by 18.06.2018 / 23:44
2
answers

Print button if a value is empty

I have a table that shows the records of orders delivered, and to finish the registration there is a "Add referral" button to save the referral in the database. I want to do that when the table reloads and if the referral has value that does not...
asked by 19.06.2018 / 17:20
1
answer

Do not query DB SQL

I'm doing a project, in most cases the consultations are    they perform normally and correctly, but on 2 occasions (one of them is)    he performs the query, he tries to print the query and nothing happens.      $mysqli = new mysqli("localhos...
asked by 21.06.2018 / 12:01
1
answer

Error Code: 1215. Can not add foreign key constraint. MySQL problem

I'm having an error in the creation of a table, I'm getting the error of MySQL 1215 Already check the data types The name is the same The creation of the users table is the following: create table if not exists usuarios ( --...
asked by 09.06.2018 / 01:01
1
answer

It shows me the following error Notice: Undefined index: image

Hi I have a problem, it shows me the error Notice: Undefined index: image and I do not know why it will be: $sql="SELECT * FROM contribuyente WHERE id=$id"; $ressql=mysqli_query($conexion,$sql); while ($row=mysqli_fetch_row ($ressq...
asked by 07.06.2018 / 23:22
2
answers

Create mysql function on repeated dates

I need to create a function which takes the dates of a table and if there are 2 repeating ids, it takes the most recent date. For example: Usuario_ID|Video_ID|Fecha 11 |1 |2018-05-12 11 |1 |2018-05-13 11...
asked by 20.07.2018 / 03:09