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 / Product.php
Created July 9, 2021 11:05
Modify the model as per your columns
<?php
namespace App\Models;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Product extends Model
{
use HasFactory;
@AlphaRomeoMike
AlphaRomeoMike / edit_data.php
Created December 23, 2020 15:43
Edit Data File
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="Description" content="Enter your description here" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.5.3/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/css/all.min.css">
@AlphaRomeoMike
AlphaRomeoMike / add_data.php
Created December 23, 2020 15:40
Add Data File
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="Description" content="Enter your description here"/>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.5.3/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/css/all.min.css">
<link rel="stylesheet" href="assets/css/style.css">
@AlphaRomeoMike
AlphaRomeoMike / crud_view.php
Created December 23, 2020 15:39
Crud View File
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="Description" content="Enter your description here"/>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.5.3/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/css/all.min.css">
<link rel="stylesheet" href="assets/css/style.css">
@AlphaRomeoMike
AlphaRomeoMike / CrudModel.php
Created December 23, 2020 15:34
Crud Model
<?php
namespace App\Models;
use CodeIgniter\Model;
class CrudModel extends Model {
protected $table = 'tbl_users';
protected $primaryKey = 'id';
protected $allowedFields = ['name', 'email', 'gender'];
}
@AlphaRomeoMike
AlphaRomeoMike / Crud.php
Created December 23, 2020 15:28
Crud Controller
<?php
namespace App\Controllers;
use App\Models\CrudModel;
class Crud extends BaseController {
//SELECT DATA
function index() {
// echo "Hello CI-4";
@AlphaRomeoMike
AlphaRomeoMike / Database.php
Created December 23, 2020 15:17
Database file
<?php namespace Config;
/**
* Database Configuration
*
* @package Config
*/
class Database extends \CodeIgniter\Database\Config
{
@AlphaRomeoMike
AlphaRomeoMike / home.html
Created December 21, 2020 15:38
Home file for api
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="Description" content="Enter your description here" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.5.2/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.0/css/all.min.css">
@AlphaRomeoMike
AlphaRomeoMike / delete.php
Created December 21, 2020 15:32
Delete for API
<?php
require "connection.php";
$data = json_decode(file_get_contents("php://input"));
$id = $data->id;
$query = "CALL st_deleteUser($id)";
if(mysqli_query($con, $query)) {
$response["msg"] = "User deleted response from server was a success ";
} else {
@AlphaRomeoMike
AlphaRomeoMike / select.php
Created December 21, 2020 15:30
Select for API
<?php
require "connection.php";
$query = "CALL st_getUser()";
$response = array();
$res = mysqli_query($con, $query);
if(mysqli_num_rows($res)) {
while($row = mysqli_fetch_assoc($res)) {
$response[] = $row;