Questions tagged as 'mysql'

Tagged questions
2
answers

how to call a mysql stored procedure from php with data from a form

<!DOCTYPE html> <?php include 'MenuNav.php'; ?> <html> <head> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1"&...
asked by 10.08.2017 / 01:40
1
answer

java.lang.nullpointerexception when loading table with images

I am in a dead end and I need help, my mistake is as follows. When loading a table with images from my BD data% MySQL I get it    java.lang.nullpointerexception and I do not know what its cause or motive is. The method I use to lo...
asked by 20.06.2017 / 01:26
2
answers

compare two rows of different tables and get the same MySQL records

I have two tables with the same fields but each user inserts different records (there is a range of 78 possible records that each user can insert in their table) what I want to be able to do is to obtain in which fields the records are similar a...
asked by 19.06.2017 / 15:54
1
answer

Queries in several tables only one column, FK, PK

For the query for example of the activity in the calendar table, we can also do it in the table Participant no? to be dragging from calendar to activity and then participant     
asked by 19.06.2017 / 02:38
1
answer

Send a variable in the subject of PHP MAILER

I have a form which, when finished, sends the data to an email, and sends the data, I just want the subject to be sent from where the information is sent, I have the following code: $nombre = utf8_decode($_POST['nombre']); $plantel = utf8_dec...
asked by 13.06.2017 / 17:56
2
answers

How to dump an array in a multiple select

I have a form that has a multiple select that is loaded with data from a database. In this select, the user selects several "interests". In the process of saving the data, I keep the array in the database with this format: ["17","12","11","13"...
asked by 29.07.2017 / 23:41
2
answers

How to consult data in MySQL and be able to save in SQL Server? (Python)

Good morning I have a doubt, I have a code generated in Python which what it does is to consult a MySQL table named INFORMATION_SCHEMA.PROCESSLIST in the following way: SELECT *, IF(time >= 10,"Bad","Good") AS Estado FROM INFORMATION...
asked by 08.06.2017 / 15:11
2
answers

Notifications in PHP [closed]

How about, I'm trying to implement a system of notifications in my web application, I just do not know how to start, I've been googling, waiting to find an answer. I have a table in MySQL that has the following fields: id (PK) du_id...
asked by 04.06.2017 / 21:39
1
answer

Retrieve variable sent in JSON in datatables

Dear programmers, I come to you based on the following problem. I work on a system and I'm using Datatables. So far I have not had major problems, but now I'm with one that is pulling green hairs. I have in my mysql Database, a table called labo...
asked by 11.06.2017 / 01:32
1
answer

Show Ratings according to PHP MYSQL subject

Good morning Community. I have this student report card by subject But I have tried to make the notes go horizontally according to the subject and not vertically according to the image. I have not been able to solve this concern. The code...
asked by 02.06.2017 / 15:35