A heads up for any developers working on a CI4 codebase. I just merged in a breaking change to the way soft deletes work. Instead of being a simple boolean flag called deleted, the default field has been changed to a new column called deleted_at. This should be either a DATETIME or INTEGER column that matches what that table is using for created_at and updated_at.
This not only brings it in line with the other timestamps across the Model and Entities, but provides a better chance for data forensics on the case something gets deleted so you can help your client figure out what might have caused things to go missing.
I have been thinking about this change for a while now, as I'm not really sure why I originally created it as a boolean. Probably an artifact from examining several MY_Model classes that were popular from previous versions of CI. If that change was ever going to happen, it had to happen prior to a Release Candidate.
I know this will likely cause some headaches for people that have already started projects on CI4 beta, but this is the last expected breaking change prior to a RC (which is close!).
I have uploaded csv to db some calculations are performed while uploading so it take 20 to 30 sec depending on csv file now i want to add ajax progress bar to be appeared while csv is being uploading in db and showing uploading percentage. index.php
I have a controller called Home.php & I have method called addProperty() here process the image upload. But the problem is when i use the image upload code after $this->form_validation->run() , its not working.
But without $this->form_validation->run() , the image upload working. When i use the image upload code after the $this->form_validation->run() the image is not getting uploaded.
//$propertyImgUpload = uploadImages($result); $this->session->set_flashdata('success', 'Thank you for submiting.'.$result.'. your property!, Our team will contact you shortly');
I am working on a basic blog application in Codeigniter 3.1.8 and Bootstrap 4. The application allows Registration (as an author), Login, adding Categories and Posts. I have created an installation process for the application: after creating a database and providing its credentials to the
Code:
application/config/database.php
file, you can run the
Code:
Install
controller which will create all the necessary tables:
Code:
class Install extends CI_Controller {
public function __construct()
{
parent::__construct();
}
public function index(){
// Create all the database tables if there are none
// by redirecting to the Migrations controller
$tables = $this->db->list_tables();
if (count($tables) == 0) {
redirect('migrate');
} else {
redirect('/');
}
}
}
After that, you can register as an author. Being the first registered author, you are also an admin, meaning that your author account does not require activation (and the value for the
Code:
is_admin
column has a value of
Code:
1
in the database record for you). All the future authors will need their accounts activated by you in order to publish articles (posts). It is a rather ambitious project, although I did not start it with great plans in mind. I just wanted to learn Codeigniter 3. You can see it on my GitHub account. There are a few possible issues:
The application does not use HMVC, but "classic" MVC.
It does not have a clear separation between its front and its back (admin)
I want to add a theming feature and I kinda got stuck with it; I don't know what approach to use.
My controllers may be a over-coded.
Here is the
Code:
Posts
controller:
Code:
class Posts extends CI_Controller {
public function __construct()
{
parent::__construct();
}
$this->Posts_model->create_post($post_image, $slug);
$this->session->set_flashdata('post_created', 'Your post has been created');
redirect('/');
}
}
public function edit($id) {
// Only logged in users can edit posts
if (!$this->session->userdata('is_logged_in')) {
redirect('login');
}
$data = $this->Static_model->get_static_data();
$data['pages'] = $this->Pages_model->get_pages();
$data['categories'] = $this->Categories_model->get_categories();
$data['posts'] = $this->Posts_model->sidebar_posts($limit=5, $offset=0);
$data['post'] = $this->Posts_model->get_post($id);
if ($this->session->userdata('user_id') == $data['post']->author_id) {
$data['tagline'] = 'Edit the post "' . $data['post']->title . '"';
$this->load->view('partials/header', $data);
$this->load->view('edit-post');
$this->load->view('partials/footer');
} else {
/* If the current user is not the author
of the post do not alow edit */
redirect('/' . $id);
}
}
public function update() {
// Form data validation rules
$this->form_validation->set_rules('title', 'Title', 'required', array('required' => 'The %s field can not be empty'));
$this->form_validation->set_rules('desc', 'Short description', 'required', array('required' => 'The %s field can not be empty'));
$this->form_validation->set_rules('body', 'Body', 'required', array('required' => 'The %s field can not be empty'));
$this->form_validation->set_error_delimiters('<p class="error-message">', '</p>');
if ( isset($_FILES['userfile']['name']) && $_FILES['userfile']['name'] != null )
{
// Use name field in do_upload method
if (!$this->upload->do_upload('userfile')) {
$errors = array('error' => $this->upload->display_errors());
if ($this->form_validation->run()) {
$this->Posts_model->update_post($id, $post_image, $slug);
$this->session->set_flashdata('post_updated', 'Your post has been updated');
redirect('/' . $slug);
} else {
$this->form_validation->run();
$this->session->set_flashdata('errors', validation_errors());
redirect('/posts/edit/' . $slug);
}
}
public function delete($slug) {
// Only logged in users can delete posts
if (!$this->session->userdata('is_logged_in')) {
redirect('login');
}
$data['post'] = $this->Posts_model->get_post($slug);
if ($this->session->userdata('user_id') == $data['post']->author_id)
{
$this->Posts_model->delete_post($slug);
$this->session->set_flashdata('post_deleted', 'The post has been deleted');
redirect('/');
} else {
/* If the current user is not the author
of the post do not alow delete */
redirect('/' . $slug);
}
}
}
Please help me with useful feedback and suggestions.
I'm first time here & also beginner to Codeigniter, I'm developing one website for a real estate agency & here I have one form to get property details such as property name, price,address,contact no etc from the user & also the images of property using the DropzoneJs.
I have two method in a controller :
addProperty() - Here I validate the form inputs and insert into my table.
UploadImages() - Here I do upload process of the images.
But when I insert the property images details into table I need the reference of the property id which performed the insertion in addProperty() method. addProperty() method has $result variable which gives the last inserted id.
Once the insertion of property details is success I want to do the upload process of the property images and also insertion of image details into my table.
Here What is working :
1.Upload of images working
2. Insertion of property data working.
But what I actually need is, I wan't to process the images and property data in the same method called addProperty(), So I can get the reference of the last inserted id.
Controller
Name : Home.php
Methods : addProperty() , uploadImages()
PHP Code:
<?php if(!defined('BASEPATH')) exit('No direct script access allowed');
/** * Class :Home (HomeController) * Login class to control to authenticate user credentials and starts user's session. * @author : Kishor Mali * @version : 1.1 * @since : 15 November 2016 */ class Home extends CI_Controller { /** * This is default constructor of the class */ public function __construct() { parent::__construct(); $this->load->model('property_model');
}
/** * Index Page for this controller. */ public function index() { $data = array('title'=> 'Vierra Property Broker', 'main_content'=>'home'); $this->load->view('template', $data);
//$propertyImgUpload = uploadImages($result); $this->session->set_flashdata('success', 'Thank you for submiting your property with us!, Our team will contact you shortly'); } else { $this->session->set_flashdata('error', 'Submission of property failed, Contact [email protected]'); }
redirect('/submit-property'); }
}
function uploadImages() {
if (!empty($_FILES)) { $count_img = count($_FILES['file']['name']);
foreach($_FILES['file']['tmp_name'] as $key => $value) {
/**
* File : addUser.js
*
* This file contain the validation of add user form
*
* Using validation plugin : jquery.validate.js
*
* @author Sarath Chandran
*/
document.getElementById("submit-all").addEventListener("click", function(e) {
// Make sure that the form isn't actually being sent.
e.preventDefault();
$(window).scrollTop(0);
//e.preventDefault();
if ( $("#property-form").valid() ) {
myDropzone.processQueue();
ERROR - 2019-06-10 14:00:23 --> Query error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`:` = CONCAT( @pv, ',', cod_colaborador)
)
OR `cod_colaborador` = `@pv`)
ORDER ' at line 12 - Invalid query: SELECT `cli`.`num_cpf`, `cli`.`nom_cliente`, `c1`.`nom_apelido`, `c2`.`nom_apelido` as `nom_gerente`, `cli`.`sit_cadastro`, `cli`.`cod_usuario`
FROM `tbl_cad_clientes` `cli`
INNER JOIN `tbl_rhm_colaboradores` `c1` ON `c1`.`cod_colaborador` = `cli`.`cod_corretor`
LEFT JOIN `tbl_rhm_colaboradores` `c2` ON `c2`.`cod_colaborador` = `c1`.`cod_supervisor`
WHERE cli.cod_corretor IN(SELECT `cod_colaborador`
FROM ( SELECT `r`.`cod_colaborador`, `r`.`cod_supervisor`
FROM `tbl_rhm_colaboradores` as `r`
WHERE `r`.`sit_cadastro` = 'A'
ORDER BY `r`.`cod_supervisor`, `r`.`cod_colaborador` asc ) as tbl_cad_corretores, ( SELECT @pv := 214 ) initialisation
WHERE (
find_in_set( cod_supervisor, @pv ) >0
AND `@pv` `:` = CONCAT( @pv, ',', cod_colaborador)
)
OR `cod_colaborador` = `@pv`)
ORDER BY `cli`.`nom_cliente` ASC
LIMIT 10
Hi
How do can i use MongoDB in Codeigniter?
It is good database for big data
I download below library for Codeigniter but there is a problem about mongo db class
