Home Mysql How to get data in reactjs from php mysql database?

How to get data in reactjs from php mysql database?

by therichpost
Published: Last Updated on 9 comments
How to get data in reactjs from php mysql database?

Hello my friends, welcome back to my blog. Today in this blog post, I am going to tell you, How to get data in reactjs from php mysql database?

Reactjs get data from php mysql

For reactjs new comers, please check the below link:

Reactjs Basic Tutorials

Friends now I proceed onwards and here is the working code snippet for How to get data in reactjs from php mysql database? and please use this carefully to avoid the mistakes:

1. Firstly friends we need fresh reactjs setup and for that we need to run below commands into our terminal and also w should have latest node version installed on our system:

npx create-react-app reactgetdata

cd reactgetdata

npm start // run the project


2. Now we need to run below commands to get bootstrap(for good layout) and axios(to post data request to php)  modules into our react js app:

npm install bootstrap --save

npm install axios --save

npm start


3. Finally friends we need to add below code into our src/App.js file to get final output on web browser:

import React from 'react';
import './App.css';

import 'bootstrap/dist/css/bootstrap.min.css';

//Axios for get request
import axios from 'axios';

class App extends React.Component {
 //initialize an object's state in a class
  constructor(props) {
      this.state = {
        data: []
      //ComponentDidMount is use to Connect a React app to external applications, such as web APIs or JavaScript functions
        //get request
        axios.get('http://localhost/save.php').then(res => 
        this.setState({data: res.data});
  render() {
    return (
      <div className="maincontainer">
        <h1 className="mr-5 ml-5 mt-5">Therichpost.com</h1>
        <div className="container mb-5 mt-5 text-left">
        <table class="table table-hover">
          {this.state.data.map((result) => {
            return (



export default App;


4. Now friends here is my php code snippet to get data from mysql and show into reactjs and I added this code into my xampp/htdocs/save.php file:

$servername = "localhost";
$username   = "root";
$password   = "";
$dbname     = "users";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    $trp = mysqli_query($conn, "SELECT * from userdetails");
    $rows = array();
    while($r = mysqli_fetch_assoc($trp)) {
        $rows[] = $r;
    print json_encode($rows); //convert php data to json data



Now we are done friends. If you have any kind of query or suggestion or any requirement then feel free to comment below.

Guys in my next post, I will tell you, reactjs php crud operation.

Note: Friends, I just tell the basic setup and things, you can change the code according to your requirements. For better understanding must watch video above.
I will appreciate that if you will tell your views for this post.Nothing matters if your views will good or bad.



You may also like


Nathaniel Nkrumah October 29, 2020 - 3:05 pm

Great tutorial. Thanks

Ajay Malhotra October 29, 2020 - 3:07 pm


Dhruv Patil November 21, 2020 - 7:41 pm

best article

Ajay Malhotra November 22, 2020 - 4:13 am


Abdul December 27, 2020 - 12:48 am

Great tutorial, in your App.js file line 23 the link is “axios.get(‘http://localhost/reactimageupload.php’)” shouldn’t it be “axios.get(‘http://localhost/save.php’)”?

Ajay Malhotra December 28, 2020 - 7:01 am

Post updated, thanks.

Pedro Brea January 12, 2021 - 10:38 pm

Access to fetch at ‘http://localhost/test/save.php’ from origin ‘http://localhost:3000’ has been blocked by CORS policy: Response to preflight request doesn’t pass access control check: No ‘Access-Control-Allow-Origin’ header is present on the requested resource.

Sangita October 18, 2022 - 9:33 am

Add the following in php file
header(‘Access-Control-Allow-Origin: *’);
header(‘Access-Control-Allow-Headers: access’);
header(‘Access-Control-Allow-Methods: GET, POST’);
header(‘Content-Type: application/json, charset=UTF-8’);
header(‘Access-Control-Allow-Headers: X-Requested-With, Content-Type, Access-Control-Allow-Headers, Authorization’);

therichpost October 18, 2022 - 11:55 am

Good to know this, thanks.


Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.