Thursday 28 July 2022

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

Monday 11 July 2022

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

 




Wednesday 6 July 2022

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.

Monday 4 July 2022

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

Saturday 2 July 2022

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

Friday 1 July 2022

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