How to write 100000 records fetching query fastly using laravel and MySQL?

|
natghi2010 2020-12-01 20:41:26
2020-12-01 20:39:32
Okay am getting that data already from this $response = json_decode($request->getContent()); so i now need to capture phone number

no

natghi2010 2020-12-01 20:41:38
json_decode($request->getContent(),true);
2020-12-01 20:46:24
natghi2010 2020-12-01 20:41:38
json_decode($request->getContent(),true);

From the response can I have something like $phoneno=$response->PhoneNumber; although this does not capture phonenumber

natghi2010 2020-12-01 20:47:45
2020-12-01 20:46:24
From the response can I have something like $phoneno=$response->PhoneNumber; although this does not capture phonenumber

this is pure array

natghi2010 2020-12-01 20:47:57
you cant do that
natghi2010 2020-12-01 20:48:12
natghi2010 2020-12-01 20:30:54
so $body[‘stkCallback][‘CallbackMetadata’][‘item’][2]

im afraid this is it

aminhd2658 2020-12-01 20:59:53
Hello guys
Do you know how to send email with laravel in cpanel?!
aminhd2658 2020-12-01 21:00:30
laravel_discuss-60816.jpg
I got this error
natghi2010 2020-12-01 21:04:57
aminhd2658 2020-12-01 21:00:30
I got this error

how did you get this error?

natghi2010 2020-12-01 21:05:07
in json format?
natghi2010 2020-12-01 21:05:25
it even tells you the name of the function. very nice
aminhd2658 2020-12-01 21:07:44
laravel_discuss-60820.jpg

aminhd2658 2020-12-01 21:08:05
natghi2010 2020-12-01 21:05:25
it even tells you the name of the function. very nice

It is function in controller class

aminhd2658 2020-12-01 21:09:19
laravel_discuss-60822.jpg

aminhd2658 2020-12-01 21:09:44
aminhd2658 2020-12-01 21:09:19

This is forgetpwmail

natghi2010 2020-12-01 21:13:19
the issue
aminhd2658 2020-12-01 21:13:39
laravel_discuss-60825.jpg

natghi2010 2020-12-01 21:13:43
subect
aminhd2658 2020-12-01 21:13:51
aminhd2658 2020-12-01 21:13:39

Env config☝️

natghi2010 2020-12-01 21:13:54
and your encoding type
aminhd2658 2020-12-01 21:14:10
natghi2010 2020-12-01 21:13:54
and your encoding type

How can i fix it?

natghi2010 2020-12-01 21:14:12
it expects english characters
natghi2010 2020-12-01 21:14:38
@DesolatorMagno well?
aminhd2658 2020-12-01 21:14:45
natghi2010 2020-12-01 21:14:12
it expects english characters

I change it to english but not fix

DesolatorMagno 2020-12-01 21:14:57
2020-12-01 20:46:24
From the response can I have something like $phoneno=$response->PhoneNumber; although this does not capture phonenumber

When i work with api and external services i make a object that would take the response and return a object that i would use to work, in that object i would have validation and have things like $response->name, $response->id, etc.

DesolatorMagno 2020-12-01 21:15:17
what?
natghi2010 2020-12-01 21:15:49
i thought you were going to answer the encoding question
aminhd2658 2020-12-01 21:16:18
natghi2010 2020-12-01 21:15:49
i thought you were going to answer the encoding question

Encoding in where ?

natghi2010 2020-12-01 21:17:23
aminhd2658 2020-12-01 21:16:18
Encoding in where ?

add this in the header: Content-Type: text/html; charset=UTF-8

aminhd2658 2020-12-01 21:19:54
natghi2010 2020-12-01 21:17:23
add this in the header: Content-Type: text/html; charset=UTF-8

laravel_discuss-60838.jpg
Like this ? Not fix …

natghi2010 2020-12-01 21:21:59
not there
aminhd2658 2020-12-01 21:23:36
natghi2010 2020-12-01 21:21:59
not there

Where??🧐

natghi2010 2020-12-01 21:23:49
aminhd2658 2020-12-01 21:23:36
Where??🧐

looking one sec

aminhd2658 2020-12-01 21:44:49
natghi2010 2020-12-01 21:23:49
looking one sec

Thank you for your attention.
Any solution?!

naveen5566 2020-12-02 04:14:55
Hi All,
How to write 100000 records fetching query fastly using laravel and MySQL?(query optimization)
parmonov98 2020-12-02 05:39:42
naveen5566 2020-12-02 04:14:55
Hi All,
How to write 100000 records fetching query fastly using laravel and MySQL?(query optimization)

Google => php yield

Jomitz 2020-12-02 06:22:41
aminhd2658 2020-12-01 21:19:54
Like this ? Not fix …

Put $user->email inside the to() function

Jomitz 2020-12-02 06:23:16
$user gives the model
adityaa_codes 2020-12-02 07:43:08
hypernxf 2020-12-01 16:52:03
Do you know what is the format returned by the library?

What kinda format?

rdulk 2020-12-02 08:55:16
naveen5566 2020-12-02 04:14:55
Hi All,
How to write 100000 records fetching query fastly using laravel and MySQL?(query optimization)

Use laravel cursor

|