Can anyone help me with a SQL statement?

|
Relaxed Guy 2020-04-24 09:31:44
Before that’s why am asking for help
skys215 2020-04-24 09:35:17
google it
Relaxed Guy 2020-04-24 09:35:48
I dont know whre to start
Relaxed Guy 2020-04-24 09:36:04
I have googled they re only solutions for guzzle
skys215 2020-04-24 09:50:06
you need to make clear what you have, what you can do and what you want
senhorY 2020-04-24 09:52:35
Hi! Can anyone help me with a SQL statement?

I have a statement selecting the total number of sales from multiple tables and I’m grouping them by month and year. To get all the sales from each month I do SUM( qty * value ) as totals, but I don’t really know how to get also the total for the whole year in the same statement.

skys215 2020-04-24 09:53:51
you have an api address which you can call, you get an json object
you want to show on page, then how to get data? can you directly show data on page? if not, use ajax to call api to get data
after you got the data, what you need to do is add elements on page
skys215 2020-04-24 09:56:10
senhorY 2020-04-24 09:52:35
Hi! Can anyone help me with a SQL statement?

I have a statement selecting the total number of sales from multiple tables and I’m grouping them by month and year. To get all the sales from each month I do SUM( qty * value ) as totals, but I don’t really know how to get also the total for the whole year in the same statement.

post it on http://sqlfiddle.com/ and paste the address here

skys215 2020-04-24 09:56:42
senhorY 2020-04-24 09:52:35
Hi! Can anyone help me with a SQL statement?

I have a statement selecting the total number of sales from multiple tables and I’m grouping them by month and year. To get all the sales from each month I do SUM( qty * value ) as totals, but I don’t really know how to get also the total for the whole year in the same statement.

you can not get by each moth and also get the data of whole year

skys215 2020-04-24 09:57:42
you need to sum it by your own using php
or execute another sql statment
Relaxed Guy 2020-04-24 09:59:40
skys215 2020-04-24 09:53:51
you have an api address which you can call, you get an json object
you want to show on page, then how to get data? can you directly show data on page? if not, use ajax to call api to get data
after you got the data, what you need to do is add elements on page

Showing that data on page is my problem

senhorY 2020-04-24 10:09:12
Too bad
senhorY 2020-04-24 10:09:17
Thank you anyway 🙂
Asish K Antony 2020-04-24 10:11:54
Relaxed Guy 2020-04-24 09:59:40
Showing that data on page is my problem

What is your front end

skys215 2020-04-24 10:12:02
Relaxed Guy 2020-04-24 09:59:40
Showing that data on page is my problem

get the data first

Relaxed Guy 2020-04-24 10:13:02
skys215 2020-04-24 10:12:02
get the data first

Getting data

Asish K Antony 2020-04-24 10:13:31
skys215 2020-04-24 10:12:02
get the data first

I think he is getting data

Relaxed Guy 2020-04-24 10:13:44
Asish K Antony 2020-04-24 10:11:54
What is your front end

Bt displaying it

Relaxed Guy 2020-04-24 10:13:48
Is my problem
Asish K Antony 2020-04-24 10:16:37
Relaxed Guy 2020-04-24 10:13:44
Bt displaying it

What is your frontend

Relaxed Guy 2020-04-24 10:16:53
Asish K Antony 2020-04-24 10:16:37
What is your frontend

Inbox please

Asish K Antony 2020-04-24 10:16:54
Html CSS JavaScript
Relaxed Guy 2020-04-24 10:16:59
Yes html
Relaxed Guy 2020-04-24 10:17:04
Css n javascript
Asish K Antony 2020-04-24 10:17:16
Relaxed Guy 2020-04-24 10:16:53
Inbox please

are you using bootstrap

Asish K Antony 2020-04-24 10:18:31
As a ready made solution you Can use datatables
Relaxed Guy 2020-04-24 10:20:16
Yes am using html
Relaxed Guy 2020-04-24 10:20:19
N bootstrap
Relaxed Guy 2020-04-24 10:20:25
That’s not my problem
Relaxed Guy 2020-04-24 10:20:42
M of a view of extracting keys
skys215 2020-04-24 10:21:36
use ajax to get data
sahilbalgotra 2020-04-24 10:22:51
How to combine where statement form same column
sahilbalgotra 2020-04-24 10:23:47
Where page membership where page offer
Relaxed Guy 2020-04-24 10:29:19
skys215 2020-04-24 10:21:36
use ajax to get data

laravel_discuss-34622.jpg
This is the data am trying to display

Relaxed Guy 2020-04-24 10:29:38
Guys ts paginated …I have called the url…….of thr endpoint
Relaxed Guy 2020-04-24 10:29:47
N extracted a key records
Relaxed Guy 2020-04-24 10:30:30
laravel_discuss-34625.jpg

Akshay Bhardwaj 2020-04-24 10:48:32
image not displaying in firfox
Akshay Bhardwaj 2020-04-24 10:48:52
<img src=”{{url(‘img/event/01/image.png’)}}” style=”max-height:100px;” />
Akshay Bhardwaj 2020-04-24 10:49:07
in chrome it’s visible
Akshay Bhardwaj 2020-04-24 10:49:11
please help
Akshay Bhardwaj 2020-04-24 10:49:23
i am asking question here earlier but no one reply
skys215 2020-04-24 11:07:15
sahilbalgotra 2020-04-24 10:22:51
How to combine where statement form same column

group

skys215 2020-04-24 11:08:16
Akshay Bhardwaj 2020-04-24 10:49:11
please help

open developers tool and check whats the problem

skys215 2020-04-24 11:08:52
Relaxed Guy 2020-04-24 10:30:30

get the data in blade, and use foreach

Akshay Bhardwaj 2020-04-24 11:11:48
skys215 2020-04-24 11:08:16
open developers tool and check whats the problem

image link is there

Akshay Bhardwaj 2020-04-24 11:13:53
and it’s opening in new tab with relative path
Akshay Bhardwaj 2020-04-24 11:28:48
laravel_discuss-34637.jpg

Akshay Bhardwaj 2020-04-24 11:28:54
facebook authentication
Akshay Bhardwaj 2020-04-24 11:30:09
issue
|