php mysql json restful webservice display data based on id

-

db.php

<?php
$servername="localhost";
$username="root";
$password="";
$database="tg";

//create connection$
$conn=new mysqli($servername, $username, $password, $database);


//check connection
if ($conn->connect_error)
{
    die("connection failed: ".$conn->connect_error);
}

?>

 

Display full list

 

<?php
include 'includes/db.php';


$cat_query="select * from coachings";
$cat_result=$conn->query($cat_query);
if ($cat_result->num_rows > 0) {
   
    while($cat_row = $cat_result->fetch_assoc()) {
      
        $cat_msg[]=array("name" => $cat_row['c_name'], "address" => $cat_row['c_address'], "city" => $cat_row['c_city'],"state" => $cat_row['c_state'], "country" => $cat_row['c_country'], "pincode" => $cat_row['c_pincode'], "category" => $cat_row['c_category'], "subcategory" => $cat_row['c_subcategory']);
    }
} else {
    echo "0 results";
}
//$conn->close();
 $cat_json = $cat_msg;

header('content-type: application/json');
echo json_encode($cat_json);

@mysqli_close($conn);



?>

display based on id


<?php
include 'includes/db.php';

if (isset($_GET['c_id'])) {
$c_id = $_GET['c_id'];
$cat_query="select * from coachings where c_id=$c_id";
$cat_result=$conn->query($cat_query);
if ($cat_result->num_rows > 0) {
   
    while($cat_row = $cat_result->fetch_assoc()) {
      
        $cat_msg[]=array("name" => $cat_row['c_name'], "address" => $cat_row['c_address'], "city" => $cat_row['c_city'],"state" => $cat_row['c_state'], "country" => $cat_row['c_country'], "pincode" => $cat_row['c_pincode'], "category" => $cat_row['c_category'], "subcategory" => $cat_row['c_subcategory']);
    }
} else {
    echo "0 results";
}
}
//$conn->close();
 $cat_json = $cat_msg;

header('content-type: application/json');
echo json_encode($cat_json);

@mysqli_close($conn);



?>


BASED ON CATEGORY

<?php
include 'includes/db.php';

if (isset($_GET['c_category'])) {
$c_category = $_GET['c_category'];
$cat_query="select * from coachings where c_category='$c_category'";
$cat_result=$conn->query($cat_query);
if ($cat_result->num_rows > 0) {
   
    while($cat_row = $cat_result->fetch_assoc()) {
      
        $cat_msg[]=array("name" => $cat_row['c_name'], "address" => $cat_row['c_address'], "city" => $cat_row['c_city'],"state" => $cat_row['c_state'], "country" => $cat_row['c_country'], "pincode" => $cat_row['c_pincode'], "category" => $cat_row['c_category'], "subcategory" => $cat_row['c_subcategory']);
    }
} else {
    echo "0 results";
}
}
//$conn->close();
 $cat_json = $cat_msg;

header('content-type: application/json');
echo json_encode($cat_json);

@mysqli_close($conn);



?>

Comments

Post a Comment

Popular posts from this blog

Real-Time Web Interface to MQTT using Socket.io and Node.js

-
Image
Real-Time Web Interface to MQTT using Socket.io and Node.js First, all credit for this tutorial goes to  Robert Hekkers Blog .  I've altered it slightly to pick up newer versions of the various javascript libraries. If you've followed along with my  earlier post , you now have MQTT running on your Raspberry Pi, and an Arduino IoT client that can publish and subscribe to MQTT packets.  The next step is developing a real-time web interface that can control your MQTT network. Why Socket.io and Node.js? Web browsers typically operate by pulling data from a server when you click on a link.  Servers don't usually keep an open connection to the browsers it has serviced, so if some event happens on the server side, the server cannot push that event to your browser, unless you refresh the page. That's where Socket.io comes in handy.  Socket.io maintains an open connection between the server and the browser, which enables the server to push updates to the bro...
Read more

Insert session variable into MySQL database

-
<?php session_start(); if(!isset($_SESSION['Username'])){ header("Location: login.php"); } ?>   $eventname = $_POST [ 'eventname' ]; $Username = $_SESSION [ 'Username' ] $sql = mysql_query ( "INSERT INTO tbl_name VALUES('','$eventname','{$_SESSION['Username']}')" ); echo "You have been added to the event" ;
Read more

Insert CheckBox and Radio button Data in MySQL Database Using PHP

-
Image
MY-SQL Code CREATE DATABASE IF NOT EXISTS databasename; CREATE TABLE students( student_name varchar(255) NOT NULL, student_email varchar(255) NOT NULL, student_contact varchar(255) NOT NULL, student_address varchar(255) NOT NULL, stars varchar(25) NOT NULL, sports varchar(25) NOT NULL, gender text(25) NOT NULL, )     Download Code     LIVE DEMO   page- formelements.php   php code <?php $connection = mysqli_connect("localhost", "root", "","formdatainsert"); // Establishing Connection with Server //$db = mysql_select_db("colleges", $connection); // Selecting Database from Server if(isset($_POST['submit'])){ // Fetching variables of the form which travels in URL $name = $_POST['name']; $email = $_POST['email']; $contact = $_POST['contact']; $address = $_POST['address']; $sports=implode(' , ',$_POST['sports']); $star=implode(' , ',$_POST['star']); ...
Read more