Forem: John Ellee Robado

Pagination using AJAX and jQuery

John Ellee Robado — Mon, 21 Sep 2020 16:01:23 +0000

Create a javascript file let say pagination.js

https://dev-to-uploads.s3.amazonaws.com/i/jf19thvskq3fxczkc4uz.PNG

Inside your page called notes.php, write this JavaScript code on the bottom

https://dev-to-uploads.s3.amazonaws.com/i/xyqamzvh22tj1tcitdh5.PNG

Now, this is the load_notes.php back end for AJAX

https://dev-to-uploads.s3.amazonaws.com/i/0ev6w1ikdr43m7mg7563.PNG

Summary

pagination(url,div_id,table_id,trigger,offset,limit) is to pagination('load_notes.php','load_here','notes','load_pagination','0','15')

Allow IP Address of employees from work from home using Putty Terminal

John Ellee Robado — Tue, 18 Aug 2020 21:31:28 +0000

iptables -A INPUT -s { employee_ip_address } -j ACCEPT

to know your public ip address, google "whats my ip address"

My Public IP Address is 49.145.34.209

type this command in PuttyTerminal
- iptables -A INPUT -s 49.145.34.209 -j ACCEPT

Drop Down List Category(Daily, Weekly, Yearly) with search box using HTML, jQuery and PHP

John Ellee Robado — Thu, 05 Dec 2019 20:19:20 +0000

Drop Down List Category(Daily, Weekly, Yearly) with search box using jQuery with PHP

So today, I will teach you how you do it

HTML, first you create a drop down list and two textbox

Daily
Weekly
Monthly
Search (Slow Search)

To

jQuery code

$(document).ready(function(){
$(".category").change(function(){
if($(".category option:selected").val()=="4"){
$(".date1").fadeIn();
$(".label_to").fadeIn();
$(".date2").fadeIn();
}
else{
$(".date1").fadeOut();
$(".label_to").fadeOut();
$(".date2").fadeOut();

}
});
)};

PHP Code

<?php
//Declare variable
$date1;
$date2;

//Set Timezone
date_default_timezone_set("America/New_York");
//Daily
if($_POST['category']==1){
$date1=date("Y-m-d");
$date2=date("Y-m-d");
}
//Weekly
if($_POST['category']==2){
$days=array("Monday"=>0,"Tuesday"=>1,"Wednesday"=>2,"Thursday"=>3,"Friday"=>4);
foreach ($days as $key => $value) {
if(date("l")==$key){
$date1=date("Y-m-d",strtotime("-".$value."days"));
$date2=date("Y-m-d",strtotime("+".(4-$value)."days"));
}
}
}
//Monthly
if($_POST['category']==3){
$date1=date("Y-m-1");
$date2=date("Y-m-t");
}
//Yearly
if ($_POST['category']==4) {
$date1=date('Y-01-01');
$date2=date('Y-12-31');
}
//Search
if($_POST['category']==5){
$date1=date("Y-m-d",strtotime($_POST['date1']));
$date2=date("Y-m-d",strtotime($_POST['date2']));
}
?>

Note: You must include this jquery library

Table Head using foreach loop in PHP

John Ellee Robado — Fri, 18 Oct 2019 21:35:37 +0000

HTML

ID Number
Name
Birthday
Address
Course

PHP
<?php

$info = "ID Number, Name, Birthday, Address, Course";
$data = explode(',', $info);
foreach ($data as $row) {
echo "

".$row."";
}
?>

In PHP, the lines of code of HTML will reduce down

Best Feature so far I ever developed

John Ellee Robado — Fri, 18 Oct 2019 16:37:02 +0000

I created an Online Examination and a Chat Box in our company
The Online Examination is developed in PHP and MDBootstrap 4.8
The Chat Box is developed in AJAX and has a chat logs to view the users send messages.