Questions tagged as 'mysql'

Tagged questions
4
answers

Show column sum of the logged in user. error

Good morning, someone help me? I do not understand much of php, but for me to finish my site there is only one thing: I need to post the sum of the values that are in the table but based on the logged in user, already tried in all the ways but I...
asked by 20.04.2018 / 16:50
1
answer

Make date range datepicker be used in mysql

In my code, I have a calendar where the user selects the period that he wants to analyze. The code is this: <input type="text" name="daterange" value="01/01/2012 - 20/04/2018" /> <script type="text/javascript"> $(function() { $('in...
asked by 20.04.2018 / 14:59
1
answer

Google chart, PHP and Ajax - Pizza chart does not show

I'm not able to plot the pie chart on the google chart. When I change the graph type to Barchart or columnchart, it plots, but when I put piechart it does not divide it. File that takes DB data <?php require('../../Controller/conexao_bd...
asked by 20.04.2018 / 16:59
1
answer

How to insert data into related tables using PDO

I did a lot of research, but I do not know how to apply.     
asked by 24.04.2018 / 15:53
0
answers

How to create triggers in DB using XAMPP?

A group has N events and each event has M expenses. 1) The trigger below should update the last modification made to the group when an INSERT is done in the event table. Why does not it work? CREATE TRIGGER trg_eventos AFTER INSERT ON e...
asked by 25.04.2018 / 22:02
0
answers

CAST in several columns to take the average

I have several columns in a csv table, I imported the table into mysql, but when I import into mysql I have to do this import as varchar for all data. If I make a CAST in these columns and then take the average I believe it will give the value o...
asked by 26.04.2018 / 00:37
0
answers

Get data from another site with login and password

Friends, good morning! How do I get data from a table that is on a page with login and password? There is a game table in the user area, but I need to show the same table on my site, except that to get to that table, you have to login first. Wit...
asked by 26.04.2018 / 11:36
0
answers

Generate query to display MySQL data in php

The bank was created as follows: Each Discipline can have 1 or more classes, while each Class belongs to only 1 Discipline. Each Teacher can have 1 or more classes, while each Class belongs to only 1 teacher. Each student may be enrolled...
asked by 25.04.2018 / 16:23
0
answers

How to search user login to search data in database?

Good night guys, I'm using this command line, it worked fine with me typing the person's login, but when I try to go based on 'user_login' the page does not even load when I try, I already tried to use it here: $current_user = wp_get_current...
asked by 23.04.2018 / 00:52
0
answers

How to add the value of a User_ID to an FK?

Hello ... Well, assuming a user wants to comment on a post. The system should: Verify that the user is logged in, otherwise he will receive a script "You must be logged in to comment". If the user is logged in, then he should get the...
asked by 17.04.2018 / 03:34