Questions tagged as 'mysql'

Tagged questions
1
answer

Trigger in MySQL to send messages to the cell phone [closed]

I start with the topic of triggers and I would like to know if it is possible to create one that sends messages to the cell phone. The question has already been answered by @Michel Escalante Álvarez. Thank you very much !!!     
asked by 16.05.2017 / 14:52
2
answers

Does not show me bd in console

Good afternoon The question is simple, I do not know how much the answer is I have these databases in phpmyadmin : But when consulting them by console, it only shows me these: Does anyone know why you do not show me the othe...
asked by 16.05.2017 / 20:19
1
answer

I need help with a project in C #

Good, I'm doing a project in windows form and what it does is upload an excel file pass the data to a dataGridView and save them in a MySQL database, the problem is that this excel shows data of a cycle of 4 months and this is the last month the...
asked by 10.05.2017 / 00:35
2
answers

Create a database model that shows a user's friends

Good evening I have a problem, I am creating a database which uses users who in turn have friends, I can show the relationship between users and their friends but I can not show the names of the friends (I can only show ID) Users table: CRE...
asked by 09.05.2017 / 02:39
2
answers

save dates in a mysql table

my users table is composed of three fields name varchar 15, comment varchar 255 and date date, I want to send a comment to save the date of the publication of the comment in the field date <form method="get" action="conexion.php"> <in...
asked by 08.05.2017 / 13:29
1
answer

Get list of elements filtered by id

For example, I have two tables with relation 1_n (Intervals have one to many deliveries) but I am not able to list the deliveries related to the specific user id filtering in the controller with the where clause. I try the following but it does...
asked by 08.05.2017 / 09:41
1
answer

Fatal error: Call to a member function query () on null in

I am trying to make a Login using the Vista Controller model (MVC), the database is already created, the problem is when validating a user, whatever the user sends this message. <?php class conexion{ private $conexion; private $serve...
asked by 14.05.2017 / 23:31
1
answer

I can not insert data into MYSQL if I use the action in HTML to go to page

The code I have is the following: <form method="post" action="ingre_acta_exi.php"> <table class="table bg-info" id="tabla"> <tr class="fila-fija"> <td><input type="number" name="IDE[]" id="IDE" value=""/&...
asked by 14.09.2017 / 13:09
1
answer

echo field column repeated [duplicated]

I'm doing an sql query with LEFT JOIN, the issue is that both tables have a column named Id and I need to print the ID of one of the tables, how do you do this ?. Thanks !!     
asked by 14.09.2017 / 18:25
1
answer

Error calculating sum with PHP and MySQL and then insert it into another table [closed]

This way I send the form with JS AJAX to PHP: $(document).ready(function() { formSubmit() }) function formSubmit(){ $('#formComi').submit(function(e){ e.preventDefault() var idusuario = $('#idusuario').val() var desde = $('#...
asked by 05.05.2017 / 04:28