Skip to content

Instantly share code, notes, and snippets.

View AlphaRomeoMike's full-sized avatar
🐳
Node, Laravel & Angular

Abdul Rafay Modi AlphaRomeoMike

🐳
Node, Laravel & Angular
View GitHub Profile
@AlphaRomeoMike
AlphaRomeoMike / update.php
Created December 21, 2020 15:29
Update for API
<?php
require "connection.php";
$data = json_decode(file_get_contents("php://input"));
$id = $data->id;
$name = $data->name;
$age = $data->age;
$phone = $data->phone;
$query = "CALL st_updateUser('$name', $age, '$phone', $id)";
@AlphaRomeoMike
AlphaRomeoMike / insert.php
Created December 21, 2020 15:26
Insert file for API
<?php
require "connection.php";
$data = json_decode(file_get_contents("php://input"));
$name = $data->name;
$age = $data->age;
$phone = $data->phone;
$query = "CALL st_insertUser('$name', $age, '$phone')";
if(mysqli_query($con, $query)) {
@AlphaRomeoMike
AlphaRomeoMike / connection.php
Created December 21, 2020 15:20
Connection file to the API
<?php
$con = mysqli_connect("localhost", "root", "", "api");
if($con) {
// echo "Connection Established";
} else {
die();
}
?>
@AlphaRomeoMike
AlphaRomeoMike / api.sql
Created December 21, 2020 14:58
Database file
-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 10, 2020 at 09:46 PM
-- Server version: 10.4.14-MariaDB
-- PHP Version: 7.2.33
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";