What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

mga ka SB patulong po sa PHP at Javascript

K

kimner123

Novice
Advanced Member
Messages
39
Reaction score
0
Points
26
:upset:

<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
$(function()
{
$('#mydata .date').each(function()
{
var cell_date = Date.parse($(this).text().replace(/(\d{2})\/(\d{2})\/(\d{4})/, '$2/$1/$3'));
var myDate = new Date(new Date().getTime()+(5*24*60*60*1000));
if(cell_date < myDate )
{
$(this).parent('tr').addClass('past')
}
}
);
}
);
</script>


pano ko dadagdagan ng 5 days to? kasi po ang kailangan ko po kasing gawin ee dapat after 5 days + ee magrered po yung row ng table
gumagana po sya ang problema lang po yung current date nag rered na agad imbis na after 5 days :weep::weep: sana po matulungan nyo ako.


eto po ...

<table cellpadding="0" cellspacing="0" border="0" class="table table-bordered table-hover" id="mydata" >

<?php include('modal_delete.php'); ?>
<thead>
<tr name = "table">
<th>ID</th>
<th>Unit</th>
<th>Filename</th>
<th>From</th>
<th>Date Received</th>
<th>Location</th>
<th>Date Released</th>
<th class="empty"></th>
<th class="empty"></th>
<th class="empty"></th>

</tr>
</thead>
<tbody>

<?php while($row = mysqli_fetch_array($search_result)):?>
<tr>
<td><?php $id = $row['user_id']?><?php echo $row['user_id']; ?></td>
<td><?php echo $row['unit']; ?></td>
<td><?php echo $row['filename']; ?></td>
<td><?php echo $row['from1']; ?></td>
<td><?php echo $row['datercv']; ?></td>
<td><?php echo $row['location']; ?></td>
<td class="date"><?php echo $row['daterls']; ?></td>

<td class="empty" width="30"><a href=transfered_files.php<?php echo '?id='.$id; ?>" class="btn btn-info"><i class="glyphicon glyphicon-ok-circle"></i></a></td>
</td>

</td>
<td class="empty" width="30">
<a data-placement="left" title="Click to Edit" id="edit<?php echo $id; ?>" data-toggle="modal" href="#<?php echo $id; ?>" class="btn btn-success"><i class="fa fa-pencil"></i></a>
<script type="text/javascript">
$(document).ready(function(){
$('#edit<?php echo $id; ?>').tooltip('show');
$('#edit<?php echo $id; ?>').tooltip('hide');
})
</script>
<?php include('modal_edit_transfer1.php') ?>
<td class="empty" width="30"><a href="delete_transfer1.php<?php echo '?id='.$id; ?>" class="btn btn-danger"><i class="fa fa-trash-o"></i></a></td>
</tr>
<?php endwhile;?>

</tbody>
</table>
<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
<script src="https://code.jquery.com/jquery-1.10.2.js"></script>
<script type="text/javascript">
$(function()
{
$('#mydata .date').each(function()
{
var cell_date = Date.parse($(this).text().replace(/(\d{2})\/(\d{2})\/(\d{4})/, '$2/$1/$3'));
var duedate = cell_date.addDays(5);
if(cell_date <= duedate )
{
$(this).parent('tr').addClass('past')
}
}
);
}
);
</script>
 
Last edited:
Re: mga ka SB patulong po sa PHP

send mo nga code mo pre. meron ako gnawa pero pure php . .tingnan mo to.
http://*** BANNED LINK - DO NOT POST ***/rcCkVK1M
 
Re: mga ka SB patulong po sa PHP

bentesn1per said:
send mo nga code mo pre. meron ako gnawa pero pure php . .tingnan mo to.
http://*** BANNED LINK - DO NOT POST ***/rcCkVK1M
Click to expand...

san po isesend?
 
Re: mga ka SB patulong po sa PHP

$day = strtotime("5 Days");
$timestamp = strtotime($row['datetime']);

$strtotime = $timestamp + $day;

$output = date('F d, Y h:i:s', $strtotime);

echo 'Date: '.$output;
 
Re: mga ka SB patulong po sa PHP

eugcar said:
$day = strtotime("5 Days");
$timestamp = strtotime($row['datetime']);

$strtotime = $timestamp + $day;

$output = date('F d, Y h:i:s', $strtotime);

echo 'Date: '.$output;
Click to expand...

san ko po ilalagay to sir? sa javascript po kasi ako nagkakaproblema... ang style po kasi yung para may due date na after 5 days automatic na mag rered yung row sa table ko gumagana naman po kaya lang for example ang nakalagay na date 2016/11/07 yung release date dun na din po nag pupula dapat po after 5 days tsaka po magpupula .. :weep::weep:
 
Re: mga ka SB patulong po sa PHP

kimner123 said:
san po isesend?
Click to expand...

tingnnan mo ba ung gnawa ko?

=========
lagay mo tong code na to sa taas,

Code: 
<?php  
    function duedatecolor($date){
            $today = date("Y/m/d");
            $datetoday=date_create($today);
            $duedate=date_create($date);
            $diff=date_diff($datetoday,$duedate);
            $result = $diff->format("%a");
        if ($result < 5 ) {
            echo 'style = "color:red"';
        }else{
            echo 'style = "color:black"';
        }
    }
 
 ?>
palitan mo to:
Code: 
<td><?php echo $row['datercv']; ?></td>

eto palit mo dun:
Code: 
<td <?php  
$datercv = $row['datercv'];
 echo duedatecolor($date);?>
       >><?php echo  $datercv;?></td>
 
Re: mga ka SB patulong po sa PHP

bentesn1per said:
tingnnan mo ba ung gnawa ko?

=========
lagay mo tong code na to sa taas,

Code: 
<?php  
    function duedatecolor($date){
            $today = date("Y/m/d");
            $datetoday=date_create($today);
            $duedate=date_create($date);
            $diff=date_diff($datetoday,$duedate);
            $result = $diff->format("%a");
        if ($result < 5 ) {
            echo 'style = "color:red"';
        }else{
            echo 'style = "color:black"';
        }
    }
 
 ?>
palitan mo to:
Code: 
<td><?php echo $row['datercv']; ?></td>

eto palit mo dun:
Code: 
<td <?php  
$datercv = $row['datercv'];
 echo duedatecolor($date);?>
       >><?php echo  $datercv;?></td>
Click to expand...

View attachment 292749
ayan po yung lumalabas
 

Attachments

  • Untitled.png
    Untitled.png
    265.3 KB · Views: 28
Re: mga ka SB patulong po sa PHP

bentesn1per said:
ayy ahaha di ko napalitan:
Code: 
<td <?php  
$datercv = $row['datercv'];
 echo duedatecolor($datercv );?>
       >><?php echo  $datercv;?></td>
yan testingin mo
Click to expand...

sir nag kukulay na po kaya lang ganun padin ngayong araw parin sya nag pupula
salamat po ng marami :)
 
Re: mga ka SB patulong po sa PHP

ano ba nakalagay na date sa database mo? staka alisin mo ung javascript mo. baka nagcoconflict.

edit mo pla to:
Code: 
 if ($result < 5 ) {
dagdagan mo ng equal sign para pag exact ng 5 days eh mag cocolor red
Code: 
 if ($result <[B]=[/B] 5 ) {
 
Last edited:
Re: mga ka SB patulong po sa PHP

mukhang dito ka nag kakaproblem:

<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
$(function()
{
$('#mydata .date').each(function()
{
var cell_date = Date.parse($(this).text().replace(/(\d{2})\/(\d{2})\/(\d{4})/, '$2/$1/$3'));
var myDate = new Date(new Date().getTime()+(5*24*60*60*1000));
if(cell_date < myDate )
{
$(this).parent('tr').addClass('past')
}
}
);
}
);
</script>

try mo i console.log yung cell_date and myDate.. malamang kaya nakared agad, kasi true yung result ng if statement mo kaya nag aadd ng "past" class
 
Re: mga ka SB patulong po sa PHP

bentesn1per said:
ano ba nakalagay na date sa database mo? staka alisin mo ung javascript mo. baka nagcoconflict.

edit mo pla to:
Code: 
 if ($result < 5 ) {
dagdagan mo ng equal sign para pag exact ng 5 days eh mag cocolor red
Code: 
 if ($result <[B]=[/B] 5 ) {
Click to expand...

sige po sir try ko po yan
 
Last edited:
Re: mga ka SB patulong po sa PHP

kimner123 said:
sige po sir try
Click to expand...
kung nag rered parin un sayo baka nakalagay parin ung javascript code mo.

working naman sakin. .gumwa ako ng raw file testing mo to.
Code: 
<!DOCTYPE html>
<html lang="en">
<head>
  <title>Bootstrap Example</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<?php 	
	function duedatecolor($date){
			$today = date("Y/m/d");
			$datetoday=date_create($today);
			$duedate=date_create($date);
			$diff=date_diff($datetoday,$duedate);
			$result = $diff->format("%a");
      //echo $result;
		if ($result <5 ) {
			echo 'style = "color:red"';
		}else{
			echo 'style = "color:black"';
		}
	}

 ?>

<div class="container"> 
  <table class="table table-hover">
    <thead>
      <tr>
        <th>Date</th>
        <th>Disc</th>        
      </tr>
    </thead>
    <tbody>
      <tr>
        <td 
        
        <?php  $date = "11/14/16";
        echo duedatecolor($date);?> 
       >
       <?php echo $date;?></td>
        <td>Due date mo na hoy</td>       
      </tr>
      <tr>
        <td 
        
        <?php  $date = "11/8/16";
        echo duedatecolor($date);?> 
       >
       <?php echo $date;?></td>
        <td>Due date mo na hoy</td>       
      </tr>


      
    </tbody>
  </table>
</div>

</body>
</html>
 
Re: mga ka SB patulong po sa PHP

xxx___p_e_r_t_o said:
mukhang dito ka nag kakaproblem:

<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
$(function()
{
$('#mydata .date').each(function()
{
var cell_date = Date.parse($(this).text().replace(/(\d{2})\/(\d{2})\/(\d{4})/, '$2/$1/$3'));
var myDate = new Date(new Date().getTime()+(5*24*60*60*1000));
if(cell_date < myDate )
{
$(this).parent('tr').addClass('past')
}
}
);
}
);
</script>

try mo i console.log yung cell_date and myDate.. malamang kaya nakared agad, kasi true yung result ng if statement mo kaya nag aadd ng "past" class
Click to expand...

pano ko po siya i coconsole log? TIA :pray:
 
Re: mga ka SB patulong po sa PHP

Ganito lang, insert mo sa if statement ito:

console.log(cell_date);
console.log(myDate);

Then mag right click ka pag load ng page mo, then inspect element. click console.
Tingnan mo kung ano result.

Anyway try mo nga ito, palitan mo yung ginawa mo
Code: 
<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
	$(function() {
		$('#mydata .date').each(function() {
			var cell_date = new Date($(this).text()).getTime();
			var current_date = new Date().getTime();
			if(cell_date < current_date) {
				var time_old=(current_date-cell_date);
				var days_old=new Date(time_old).getDate()-1;
				if(days_old>=5) {
					$(this).parent('tr').addClass('past');
				}
			}
		});
	});
</script>
 
Re: mga ka SB patulong po sa PHP

xxx___p_e_r_t_o said:
Ganito lang, insert mo sa if statement ito:

console.log(cell_date);
console.log(myDate);

Then mag right click ka pag load ng page mo, then inspect element. click console.
Tingnan mo kung ano result.

Anyway try mo nga ito, palitan mo yung ginawa mo
Code: 
<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script type="text/javascript">
	$(function() {
		$('#mydata .date').each(function() {
			var cell_date = new Date($(this).text()).getTime();
			var current_date = new Date().getTime();
			if(cell_date < current_date) {
				var time_old=(current_date-cell_date);
				var days_old=new Date(time_old).getDate()-1;
				if(days_old>=5) {
					$(this).parent('tr').addClass('past');
				}
			}
		});
	});
</script>
Click to expand...

Sir thank you po okay na :) im saved hahaha
"it works like a charm" hahahaha
 
Re: mga ka SB patulong po sa PHP

xxx___p_e_r_t_o said:
Buti naman nag work,.. haha.
Click to expand...

oo nga po ee salamat po ulit :) pinasa ko na po sa kasama kong gumagawa yung code nyo hehe...mag wowork parin po ba kapag kasama yung time? naka date picker po kasi sya tapos yung injection ng data sa phpmyadmin nya ee hindi date and time ang data type nya naka varchar po... gagana po kaya yan?
 
Re: mga ka SB patulong po sa PHP

Oo gagana pa yan, kasi ang kinukuhang data lang naman nyan ay yung nakaload sa .date na class from your table. So dapat walang magiging problem. But, make sure na date lang ang nasa .date na td ha, kung hindi, wala na dina gagana yan. hehe
 
Re: mga ka SB patulong po sa PHP

xxx___p_e_r_t_o said:
Oo gagana pa yan, kasi ang kinukuhang data lang naman nyan ay yung nakaload sa .date na class from your table. So dapat walang magiging problem. But, make sure na date lang ang nasa .date na td ha, kung hindi, wala na dina gagana yan. hehe
Click to expand...

pano po pag may oras na kasama?
11/18/2016-4:49pm parang ganyan po?
 
You must log in or register to reply here.

Similar threads

A
Patulong po sa Php mga sir update field sa table
Replies
3
Views
565
rafaguia
R
C
Please help PHP not inserting in the database
Replies
4
Views
447
jskhulitz
J
phudz
Need help in using bar graph
Replies
1
Views
475
jskhulitz
J
arenjayson
HELP php and mysqli user commadn access
Replies
5
Views
420
arenjayson
arenjayson
J
pa help pls :( codes sa PHP
Replies
6
Views
718
JackFrost10
JackFrost10
Back
Top Bottom