View edit_data.php
<!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"> |
View add_data.php
<!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"> |
View crud_view.php
<!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"> |
View CrudModel.php
<?php | |
namespace App\Models; | |
use CodeIgniter\Model; | |
class CrudModel extends Model { | |
protected $table = 'tbl_users'; | |
protected $primaryKey = 'id'; | |
protected $allowedFields = ['name', 'email', 'gender']; | |
} |
View Crud.php
<?php | |
namespace App\Controllers; | |
use App\Models\CrudModel; | |
class Crud extends BaseController { | |
//SELECT DATA | |
function index() { | |
// echo "Hello CI-4"; |
View Database.php
<?php namespace Config; | |
/** | |
* Database Configuration | |
* | |
* @package Config | |
*/ | |
class Database extends \CodeIgniter\Database\Config | |
{ |
View home.html
<!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"> |
View delete.php
<?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 { |
View select.php
<?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; |
View update.php
<?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)"; |
NewerOlder