PHP REST API - Fetch Data from SQL Database

-

 api-fetch-all.php:


<?php
header('Content-Type: application/json');
header('Acess-Control-Allow-Origin: *');
include "config.php";

$sql="SELECT * FROM students";

$result=mysqli_query($conn, $sql) or die("SQL query failed");

if(mysqli_num_rows($result)>0){
    $output=mysqli_fetch_all($result, MYSQLI_ASSOC);
    echo json_encode($output);

}else{
    echo json_encode(array('message'=>'NO RECORD FOUND', 'status'=>false));

}

?>


-------------------------

api-fetch-single.php:


<?php
header('Content-Type: application/json');
header('Acess-Control-Allow-Origin: *');

$data=json_decode(file_get_contents("php://input"), true);

$student_id=$data['sid'];

include "config.php";

$sql="SELECT * FROM students WHERE id={$student_id}";

$result=mysqli_query($conn, $sql) or die("SQL query failed");

if(mysqli_num_rows($result)>0){
    $output=mysqli_fetch_all($result, MYSQLI_ASSOC);
    echo json_encode($output);

}else{
    echo json_encode(array('message'=>'NO RECORD FOUND', 'status'=>false));

}

?>

------------------------

config.php:


<?php
$conn=mysqli_connect("localhost","root","","poetrydb") or die("Connection failed");



?>


Comments

Post a Comment

Popular posts from this blog

Send Data Child to Parent Component - React Js

-
 App.js: import React from "react" ; import './App.css' import { Student } from "./Components/Student" ; function App () {   function alertFunc ( data )   {     alert ( data )   }   const name = "Krishan Dev"   return (     <div className = "App" >     < Student data = { name } alert1 = { alertFunc } />         </div>   ) } export default App ; ---------------------------- Student.js import React from 'react' export const Student = ( props ) => {   const data = "Bhavesh"   return (     <div>       <h6> { props . data } </h6>       <button onClick = { props . alert1 ( data ) } > Click Me </button>     </div>   ) }
Read more

Hide , Show and Toggle in ReactJs

-
 App.js: import React , { useState } from 'react' ; import './App.css' function App () {   const [ show , setShow ]= useState ( true ) return (   <div>     {       show ? <h1> Hello Bhavesh </h1> : null     }     { /* <button onClick={()=>setShow(false)}>Hide</button>     <button onClick={()=>setShow(true)}>Show</button> */ } <button onClick = { () => setShow (! show ) } > Toggle </button>   </div> ) } export default App ;
Read more

Importance Of Web Content In SEO.

-
Content is one of the most important Google ranking factors. One of the benefits of publishing good content is that it will increase the number of people who find your website through search engines.  Content provides information and this information can be used to educate search engines about your website. Content also provides a great opportunity for internal links.
Read more