PHP Date Manipulation

Convert Date in dd/mm/yyyy (28-07-2022) format coming from database.

 echo date("d-m-Y", strtotime($item['CreatedDate']));

Next Topic

Google Recaptcha Integration | PHP , ASP.NET C# , Codeiginater 4

 

• Google Recaptcha core PHP Integration
• Google Recaptcha Integration with Codeigniter 4.x
• Google Recaptcha Integration with ASP.NET MVC C#

Next Topic

Google Captcha Integration in Codeiginater 4

 Step 1 : 

    Signup to Google Recaptcha and get the public and private key.

Step 2 :

    Make a Model named CaptchaResponse in Model folder and add the given code below.

Delete from database in Codeiginater 4

Function

 public function DelContact($field,$val)

    {       

         $db = new ContactModel();

         $db->where($field,$val)->delete();

       return redirect()->to(site_url('admin/contact'));

    }

Calling

<a href="<?php echo site_url('admin/DelContact/ID/123'); ?>" onclick="return confirm('Are you sure to delete this record')">

Next Topic

Get Data through Model in Codeigniter 4

Table Structure

 Model

<?php

namespace App\Models;
use CodeIgniter\Model;
class ContactModel extends Model
{
      protected $table='holywebcontact';
       protected $primaryKey = 'ID';
       protected $allowedFields = ['ID', 'Name', 'Phone', 'Message', 'CreatedDate'];     

}

Controller

<?php 

namespace App\Controllers;
use App\Models\ContactModel;
class Home extends BaseController
{

     public function dataread()
    {

        $data['title'] = 'DB Get Demo';
       $crudModel = new ContactModel();
        $data['user_data'] = $crudModel->findAll(); 
        return view('tmp2', $data);

    }

}

Note: Below is a list of some different types of conditions/filters for data access.

 

$data['user_data'] = $crudModel->where('id>=','5')->orderBy('id', 'DESC')->paginate(5);

 $data['user_data'] = $crudModel->where('id>=','5','phone','22')->orderBy('id', 'DESC')->paginate(5);

$data["model"]=$album->where('AlbumID', $aid)->findAll();

Get All record with ouder by clause

$data=$GalleryModel->orderBy('ID', 'DESC')->findAll();

View

<?php

foreach ($model as $item)
{
       echo $item["ID"] . "," . $item['Name'] . "<br>";
}

?>

Next Topic

Record Save Using Entity Framework

Read Basics of Entity Framework on my previous post for understand this example.

EntityFramework Basics

Date Save Code

 dbConnection db = new dbConnection();

db.Bill.Add(data);

db.SaveChanges();

Next Topic