API from two laravel project

Question

I create two laravel projects. One is for backend connect with database and second project is for frontend. And then i create route API from projectone (backend project) get data from database and pass to json. and i want projecttwo(frontend) get the data from api url.

i try this code:

My API route in first project:

Route::get('test',function(){
    $response=DB::table('student_tbl')->select('title')->get();
    return response()->json($response,200);
});

My Secondproject:

$client = new \GuzzleHttp\Client();        
        // Create a request
        $request = $client->get('http://localhost/myfirstproject/public/api/test');
        // Get the actual response without headers
        $response = $request->getBody();
        $json_decode=json_decode($response,true);
        foreach ($json_decode as $key => $value) {
            echo $value['title'].'<br>';
        }

Buti get 500 internal server error.

How to fixed this?

Take a look in the laravel.log of your api project and see if the full error message is there. — James Cook
– James Cook, Commented Aug 16, 2018 at 16:50
@JamesCook when i change .env secondproject database the same with firstproject i can get the result — Rajes
– Rajes, Commented Aug 16, 2018 at 16:52
If I've understood your setup correctly the database configuration of your front end project shouldn't effect the responses you get from the api. Can you navigate to localhost/myfirstproject/public/api/test in your browser what do you get there? — James Cook
– James Cook, Commented Aug 16, 2018 at 16:55
Do you have a more detailed error message for your second project than 500 internal error? — James Cook
– James Cook, Commented Aug 16, 2018 at 16:59

Yu Yenkan · Accepted Answer · 2018-12-10 22:17:32Z

1

https://github.com/laravel/framework/issues/19454#issuecomment-305955056

based on the comment, you need to run php artisan config:cache to save the config for project

answered Dec 10, 2018 at 22:17

Yu Yenkan

7652 gold badges9 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arun Code · Accepted Answer · 2018-08-16 17:01:36Z

0

Try this to get the contents from your request. Since you are receiving the API response while you are trying from the browser, it seems there can be an issue with the second project.

You have to get the contents before passing the value for JSON decoding.

$response = $request->getBody()->getContents();

answered Aug 16, 2018 at 17:01

Arun Code

1,6381 gold badge15 silver badges20 bronze badges

7 Comments

Rajes Over a year ago

Illuminate\Database\QueryException: SQLSTATE[42S02]: Base table or view not found: 1146 Table &#03 (truncated...)

Rajes Over a year ago

so i must configure that two project env the same??

Arun Code Over a year ago

Are you still getting the response while navigating this link in your browser? http://localhost/myfirstproject/public/api/test

Rajes Over a year ago

when i configure env secondproject the same firstproject i can get data

Arun Code Over a year ago

try dd($response) before this line $json_decode=json_decode($response,true); and what is the response? Seems like this part of the code is working fine after the above changes and something else in the second project (other than the pasted code) is breaking.

|

Afraz Ahmad · Accepted Answer · 2018-08-16 17:37:14Z

0

Base table or view not found means database was not found

Run migrations with

 php artisan migrate

If you face other errros while running migrations then try this command

php artisan migrate:refresh

write your code in try catch like this:

try{

  $client = new \GuzzleHttp\Client();        
    // Create a request
    $request = $client->get('http://localhost/myfirstproject/public/api/test');
    // Get the actual response without headers
    $response = $request->getBody();
    $json_decode=json_decode($response,true);
    foreach ($json_decode as $key => $value) {
        echo $value['title'].'<br>';
    } 

 }catch(\Exception $e){

    \Log::error( $e->getMessage().' '. $e->getLine() .' '. $e->getFile());
    return $e->getMessage().' '. $e->getLine() .' '. $e->getFile(); 

 }

Also, open your browser's developer console and open the network tab. Refresh your page and find something matching to your route in network controller. It will be red since you are getting error. click on it and see what it says. If your don't understand then just paste that response in your question

edited Aug 16, 2018 at 17:37

answered Aug 16, 2018 at 17:20

Afraz Ahmad

5,41633 silver badges40 bronze badges

3 Comments

Rajes Over a year ago

yes i got an error : Server error: GET http://localhost/myfirstproject/public/api/test resulted in a 500 Internal Server Error response:

Afraz Ahmad Over a year ago

See my answer and update your second project code it will tell you the error and line no of the file.

Afraz Ahmad Over a year ago

open your browser's developer console and open the network tab. Refresh your page and find something matching to your route in network controller. It will be red since you are getting error. click on it and see what it says. If your don't understand then just paste that response in your question

user7747472 · Accepted Answer · 2018-08-16 18:38:44Z

0

Error code 500 basically means you have something wrong with your code. Try this turn one your application debug mode from .env if it is already there then its good.

Then try to hit the api from the browser check if that is giving /returning the response as expected. If that does then something is wrong with your 2ned project. Try to debug it same way .

The laravel error will give you a good hint where it is going wrong.

answered Aug 16, 2018 at 18:38

user7747472

1,9726 gold badges41 silver badges84 bronze badges

Collectives™ on Stack Overflow

API from two laravel project

4 Answers 4

Comments

7 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

7 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related