- Files structure Fellow:
- Application root folder
- aplication/controllers/CI_crud.php //This file is controller class
- aplication/models/Crud_m.php //This file is model class
- aplication/views/ci_crud.php // view page
Sourse Code:
CI_crud.php - Controller class
<?php
/**
* CI_crud Class
*/
class CI_crud extends CI_controller
{
function __construct()
{
parent::__construct();
$curd_m = $this->load->model('curd_m');
}
public function index(){
$this->crud();
}
public function crud(){
$this->load->view('ci_crud');
}
public function create_update_account(){
if (isset($_POST['action'])) {
if ($_POST['action'] == 'create') {
$table = 'tbl_developers';
$img ='';
if ($_FILES['image']['name'] !='') {
$img = $this->upload_img($_FILES['image']);
}else{
$img ='';
}
$data = array(
'image'=>$img,
'sex'=>$_POST['sex'],
'name'=>$_POST['name'],
'email'=>$_POST['email'],
'skill'=>$_POST['skill'],
);
$result = $this->curd_m->createAccount($table,$data);
if ($result) {
echo 'created';
}
}
}
}
public function upload_img($file){
$extention = explode('.', $file['name']);
$newName = rand().'.'.$extention[1];
$destination = './assets/upload/'.$newName;
move_uploaded_file($file['tmp_name'], $destination);
return $newName;
}
}
?>
Crud_m.php - Model class
<?php
/**
*
*/
class Curd_m extends CI_Model
{
public function createAccount($table,$data){
$result = $this->db->insert($table,$data);
return $result;
}
}
?>
ci_crud.php view page
Database file sql
--
-- Database: `developers`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_developers`
--
CREATE TABLE `tbl_developers` (
`id` int(11) NOT NULL,
`image` varchar(255) NOT NULL,
`sex` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`skill` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_developers`
--
INSERT INTO `tbl_developers` (`id`, `image`, `sex`, `name`, `email`, `skill`) VALUES
(5, '6057.jpg', '1', 'Elizabeth N. Bradleyjj', 'Elizabeth@gmail.com', 'python Developer'),
(6, '23058.jpg', '1', 'Bradley', 'Bradley@gmail.com', 'PHP Developer'),
(9, '1381.jpg', '2', 'Ruhi', 'ruhi@gmail.com', 'PHP AND JAVA'),
(10, '3737.png', '1', 'Imrul', 'imrul@gmail.com', 'Python,php'),
(11, '3819.png', '1', 'kobir', 'kobir@gmail.com', 'Java, C#'),
(12, '13766.jpg', '1', 'Fahim Ali', 'fahimislam@gmail.com', 'Java'),
(13, '18438.png', '2', 'Victoria sun', 'victoria.sun@gmail.com', 'Python, Javascript, jQuery'),
(14, '15604.jpg', '1', 'Programmer Rayhan Mondol', 'icttask.com.rayhan@gmail.com', 'PHP, JAVA, Javascript, Jquery');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `tbl_developers`
--
ALTER TABLE `tbl_developers`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `tbl_developers`
--
ALTER TABLE `tbl_developers`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
/*!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 */;