Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh

Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values Insert API Refresh Data And Get All Values 


<?php 

  $conn=mysqli_connect('localhost','root','','carrer_orbits');

?>

MainFolder/insert_data.php

///insert_data.php





  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">

  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>

  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>


<?php 

include('db.php');

$id=$_GET['id'];

//$lastid++;

$query="SELECT*FROM tbl_users WHERE id='$id'";

$runsql_query=mysqli_query($conn,$query);

$fetch=mysqli_fetch_assoc($runsql_query);

//print_r($fetch);

//$array=json_encode($fetch);

?>

<input type="text" id="name" value="<?php echo $fetch['name'];?>">

<p id="output"></p>

<script type="text/javascript">

$(document).ready(function () {

function getData() {

var name=$("#name").val();

var userId=$("#userId").val();

var GetID=$("#GetID").val();


$.ajax({

type: 'POST',

data:{name:name},

url: 'http://localhost/carrerorbits/Api/insert_Api.php',

success: function (data) {


 //var obj = JSON.parse(data);


console.log(data) ;                          




let date1 = JSON.parse(data);

console.log(date1.name);

setInterval(function () {

location.assign("http://localhost/carrerorbits/insert_data.php?id="+date1.name);  

}, 2000);    

}

});

}

getData();

setInterval(function () {

getData();

}, 2000); // it will refresh your data every 1 sec*/

});

</script>



////C:\xampp\htdocs\carrerorbits\Api


<?php 

 include('db_connect.php');

 //if($_SERVER['REQUEST_METHOD'] == 'POST'){

  $name=$_POST['name'];

  /*$mobile=$_POST['mobile'];

  /*$user_id=$_POST['user_id'];*/


  $insert=mysqli_query($conn,"INSERT INTO tbl_users(full_name)VALUES('$name')");

     $lastId=mysqli_insert_id($conn);

     $name=array('name'=>"$lastId");

 echo  json_encode($name);

  /*if($insert){

  echo "<input type='text' id='GetID' value='".$lastId."'>";

  }else{

  echo "Something went wrong";

  }*/

 //}

?>

Database 1


-- phpMyAdmin SQL Dump

-- version 5.1.0

-- https://www.phpmyadmin.net/

--

-- Host: 127.0.0.1

-- Generation Time: Aug 30, 2022 at 08:28 PM

-- Server version: 10.4.19-MariaDB

-- PHP Version: 7.3.28


SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";



/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;


--

-- Database: `carrer_orbits`

--


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


--

-- Table structure for table `tbl_users`

--


CREATE TABLE `tbl_users` (

  `id` int(11) NOT NULL,

  `user_id` int(11) NOT NULL,

  `full_name` varchar(255) NOT NULL,

  `mobile` varchar(255) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


--

-- Dumping data for table `tbl_users`

--


INSERT INTO `tbl_users` (`id`, `user_id`, `full_name`, `mobile`) VALUES

(1, 0, 'Rahul', ''),

(2, 0, 'Rahul', ''),

(3, 0, 'Rahul', ''),

(4, 0, 'Rahul', ''),

(5, 0, 'Rahul3', ''),

(6, 0, 'Rahul3', ''),

(7, 0, '', ''),

(8, 0, '', ''),

(9, 0, '', ''),

(10, 0, '', ''),

(11, 0, '', ''),

(12, 0, '', ''),

(13, 0, '', ''),

(14, 0, '', ''),

(15, 0, '', ''),

(16, 0, '', ''),

(17, 0, '', ''),

(18, 0, '', ''),

(19, 0, '', ''),

(20, 0, '', ''),

(21, 0, '', ''),

(22, 0, '', ''),

(23, 0, '', ''),

(24, 0, '', ''),

(25, 0, '', ''),

(26, 0, '', ''),

(27, 0, '', ''),

(28, 0, '', ''),

(29, 0, '', ''),

(30, 0, '', ''),

(31, 0, '', ''),

(32, 0, '', ''),

(33, 0, '', ''),

(34, 0, '', ''),

(35, 0, '', ''),

(36, 0, '', ''),

(37, 0, '', ''),

(38, 0, '', ''),

(39, 0, '', ''),

(40, 0, '', ''),

(41, 0, '', ''),

(42, 0, '', ''),

(43, 0, '', ''),

(44, 0, '', ''),

(45, 0, '', ''),

(46, 0, '', ''),

(47, 0, '', ''),

(48, 0, '', ''),

(49, 0, '', ''),

(50, 0, '', ''),

(51, 0, '', ''),

(52, 0, '', ''),

(53, 0, '', ''),

(54, 0, '', ''),

(55, 0, '', ''),

(56, 0, '', ''),

(57, 0, '', ''),

(58, 0, '', ''),

(59, 0, '', ''),

(60, 0, '', ''),

(61, 0, '', ''),

(62, 0, '', ''),

(63, 0, '', ''),

(64, 0, '', ''),

(65, 0, '', ''),

(66, 0, '', ''),

(67, 0, '', ''),

(68, 0, '', ''),

(69, 0, '', ''),

(70, 0, '', ''),

(71, 0, '', ''),

(72, 0, '', ''),

(73, 0, '', ''),

(74, 0, '', ''),

(75, 0, '', ''),

(76, 0, '', ''),

(77, 0, '', ''),

(78, 0, '', ''),

(79, 0, '', ''),

(80, 0, '', ''),

(81, 0, '', ''),

(82, 0, '', ''),

(83, 0, '', ''),

(84, 0, '', ''),

(85, 0, '', ''),

(86, 0, '', ''),

(87, 0, '', ''),

(88, 0, '', ''),

(89, 0, '', ''),

(90, 0, '', ''),

(91, 0, '', ''),

(92, 0, '', ''),

(93, 0, '', ''),

(94, 0, '', ''),

(95, 0, '', ''),

(96, 0, '', ''),

(97, 0, '', ''),

(98, 0, '', ''),

(99, 0, '', ''),

(100, 0, '', ''),

(101, 0, '', ''),

(102, 0, '', ''),

(103, 0, '', ''),

(104, 0, '', ''),

(105, 0, '', ''),

(106, 0, '', ''),

(107, 0, '', ''),

(108, 0, '', ''),

(109, 0, '', ''),

(110, 0, '', ''),

(111, 0, '', ''),

(112, 0, '', ''),

(113, 0, '', ''),

(114, 0, '', ''),

(115, 0, '', ''),

(116, 0, '', ''),

(117, 0, '', ''),

(118, 0, '', ''),

(119, 0, '', ''),

(120, 0, '', ''),

(121, 0, '', ''),

(122, 0, '', ''),

(123, 0, '', ''),

(124, 0, '', ''),

(125, 0, '', ''),

(126, 0, '', ''),

(127, 0, '', ''),

(128, 0, '', ''),

(129, 0, '', ''),

(130, 0, '', ''),

(131, 0, '', ''),

(132, 0, '', ''),

(133, 0, '', ''),

(134, 0, '', ''),

(135, 0, '', ''),

(136, 0, '', ''),

(137, 0, '', ''),

(138, 0, '', ''),

(139, 0, '', ''),

(140, 0, '', ''),

(141, 0, '', ''),

(142, 0, '', ''),

(143, 0, '', ''),

(144, 0, '', ''),

(145, 0, '', ''),

(146, 0, '', ''),

(147, 0, '', ''),

(148, 0, '', ''),

(149, 0, '', ''),

(150, 0, '', ''),

(151, 0, '', ''),

(152, 0, '', ''),

(153, 0, '', ''),

(154, 0, '', ''),

(155, 0, '', ''),

(156, 0, '', ''),

(157, 0, '', ''),

(158, 0, '', ''),

(159, 0, '', ''),

(160, 0, '', ''),

(161, 0, '', ''),

(162, 0, '', ''),

(163, 0, '', ''),

(164, 0, '', ''),

(165, 0, '', ''),

(166, 0, '', ''),

(167, 0, '', ''),

(168, 0, '', ''),

(169, 0, '', ''),

(170, 0, '', ''),

(171, 0, '', ''),

(172, 0, '', ''),

(173, 0, '', ''),

(174, 0, '', ''),

(175, 0, '', ''),

(176, 0, '', ''),

(177, 0, '', ''),

(178, 0, '', ''),

(179, 0, '', ''),

(180, 0, '', ''),

(181, 0, '', ''),

(182, 0, '', ''),

(183, 0, '', ''),

(184, 0, '', ''),

(185, 0, '', ''),

(186, 0, '', ''),

(187, 0, '', ''),

(188, 0, '', ''),

(189, 0, '', ''),

(190, 0, '', ''),

(191, 0, '', '');


--

-- Indexes for dumped tables

--


--

-- Indexes for table `tbl_users`

--

ALTER TABLE `tbl_users`

  ADD PRIMARY KEY (`id`);


--

-- AUTO_INCREMENT for dumped tables

--


--

-- AUTO_INCREMENT for table `tbl_users`

--

ALTER TABLE `tbl_users`

  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=192;

COMMIT;


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;


///// Database 2


-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 30, 2022 at 08:30 PM
-- Server version: 10.4.19-MariaDB
-- PHP Version: 7.3.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `users_db`
--

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

--
-- Table structure for table `tbl_users`
--

CREATE TABLE `tbl_users` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_users`
--

INSERT INTO `tbl_users` (`id`, `name`, `email`, `mobile`) VALUES
(1, 'Rahul', 'rahul@gmail.com', '8754354332435'),
(2, 'Rahul2', 'rahul2@gmail.com', '8754354332435'),
(3, 'Rahul3', 'rahul3@gmail.com', '8754354332435');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Comments

Post a Comment

Popular posts from this blog

how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php

 how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads man...
Read more

How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php

How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filte...
Read more

How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python

 How to Run a Flask framework in Python  from werkzeug.wrappers import Request , Response @Request . application def application ( request ): return Response ( "Hello, World!" ) if __name__ == "__main__" : from werkzeug.serving import run_simple run_simple ( "localhost" , 5000 , application ) How To add a Template File in Python flask First Create a folder templates/main.html from flask import Flask , render_template app = Flask(__name__) @app.route("/") def index(): return render_template('main.html') if __name__ == "__main__": app.run(debug=True) #from werkzeug.serving import run_simple #run_simple("localhost", 5000, application) Main.html <!DOCTYPE html> <html lang="en"> <head> <title>Bootstrap 5 Example</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, ini...
Read more