|
PHP - Unexpected Results When Adding Intervals To Datetime
If there are two DataTime's which are exactly X seconds apart and the difference between those two DateTime's is added to a third DateTime, then the third DataTime's timestamp would change by exactly X seconds, true? Then why doesn't the second test below show those results, but is off by 1 day?
<?php
function test(string $start, string $end, string $newStart) {
$startDt = new \DateTime($start);
$endDt = new \DateTime($end);
$intervalDt=$startDt->diff($endDt);
$startSeconds=$startDt->getTimestamp();
$endSeconds=$endDt->getTimestamp();
$seconds = $endSeconds - $startSeconds;
$dt = new \DateTime($newStart);
$newStartSeconds=$dt->getTimestamp();
$dt->add($intervalDt);
$newEndSeconds=$dt->getTimestamp();
$newSeconds = $newEndSeconds - $newStartSeconds;
$newEnd = $dt->format(\DateTime::RFC3339);
echo("original: $start => $end $endSeconds - $startSeconds = $seconds seconds<br>");
echo("new: $newStart => $newEnd $newEndSeconds - $newStartSeconds = $newSeconds seconds<br>");
echo("Error: seconds - newSeconds = ".($seconds - $newSeconds));
}
test("2017-06-26T00:00:00Z", "2017-07-09T00:00:00Z", "2018-03-05T00:00:00Z");
echo('<br><br>');
test("2017-12-08T00:00:00Z", "2018-02-15T00:00:00Z", "2018-03-05T00:00:00Z");
Quote
original: 2017-06-26T00:00:00Z => 2017-07-09T00:00:00Z 1499558400 - 1498435200 = 1123200 seconds
Similar TutorialsI have been using some CSS written by Matthew Taylor (www.http://matthewjamestaylor.com), for displaying my web page on iPad orsimilar device. It works in most cases but for some reason it gives strange results when I try to output a table in the main screen area.
It puts the title heading in the right place, but the table for some reason underneath the footer and the page menu disappears completely.
It is usually caused by unclosed div tags, but I have checked them and they appear to be correct.
There is a good explaination of how the CSS works on his web site.
Here is the code for the PHP/HTML:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="generator" content="CoffeeCup HTML Editor (www.coffeecup.com)">
<meta name="dcterms.created" content="Sat, 02 Mar 2013 20:21:23 GMT">
<meta name="description" content="">
<meta name="keywords" content="">
<meta name="viewport" content="width=768px, minium-scale=1.0, maximum-scale=1.0" />
<title></title>
<link rel="stylesheet" href="stylesheets/ipad.css" />
<!--[if IE]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
<div id="fb-root">
<script>(function(d, s, id) {
var js, fjs = d.getElementsByTagName(s)[0];
if (d.getElementById(id)) return;
js = d.createElement(s); js.id = id;
js.src = "//connect.facebook.net/en_GB/all.js#xfbml=1";
fjs.parentNode.insertBefore(js, fjs);
}(document, 'script', 'facebook-jssdk'));</script></div><!--end fb-root-->
<div id="wrap"> <!--Start wrap-->
<div id="header"> <!--Start header-->
<img src="images/Head!.png" width="100%" height="150px" alt="" title="" border="0" />
<h1>1066 cards4U</h1>
</div><!-- end header -->
<div id="content"> <!--Start content-->
<div id="main"> <!--Start main-->
<h3>Statistics for <? echo $Country; ?> in 2014</h3>
<h4>If only the header is shown, there is no data for this country</h4>
<?php
include('connect_visits.php');
doDB7();
$limitStart = $_POST['QUARTER'] - 13;
$Visit_data="SELECT WeekNo.WNo, WeekNo.WCom, Countries.Country, ctryvisits.CVisits
FROM ctryvisits
LEFT JOIN Countries
ON ctryvisits.country = Countries.CID
LEFT JOIN WeekNo
ON ctryvisits.WNo=WeekNo.WNo
WHERE Countries.CID = '{$_POST['country']}'
ORDER BY ctryvisits.WNo
LIMIT {$limitStart}, 13";
$Visit_data_res = mysqli_query($mysqli, $Visit_data) or die(mysqli_error($mysqli));
$display_block = "
<table width=\"20%\" cellpadding=\"3\" cellspacing=\"1\" border=\"1\" BGCOLOR=\"white\" >
<tr>
<th>Week No</th>
<th>Week Commencing</th>
<th>Visits</th>
</tr>";
while ($C_info = mysqli_fetch_array($Visit_data_res)) {
$Cid = $C_info['WNo'];
$Visits = ($C_info['CVisits']);
$WeekNo = ($C_info['WCom']);
//add to display
$display_block .= "
<tr>
<td width=\"1%\" valign=\"top\">".$Cid."<br/></td>
<td width=\"8%\" valign=\"top\">".$WeekNo."<br/></td>
<td width=\"5%\" valign=\"top\">".$Visits."<br/></td>
</td></tr>";
}
mysqli_free_result($Visit_data_res);
$CNo2Cty ="SELECT CID, Country FROM Countries WHERE CID='{$_POST['country']}'";
$CNo2Cty_res =mysqli_query($mysqli, $CNo2Cty) or die(mysqli_error($mysqli));
if (mysqli_num_rows($CNo2Cty_res)<1){
$display_block="<p><em>Invalid Country, Please try again</em></p>";
}
while ($C_name = mysqli_fetch_array($CNo2Cty_res)) {
}
mysqli_free_result($CNo2Cty_res);
//mysqli_close(mysqli);
?>
<?php echo $display_block; ?>
<div class="fb-comments" data-href="http://www.1066cards4u.co.uk" data-width="470"></div><br />
<div class="fb-like" data-href="http://www.1066cards4u.co.uk" data-send="true" data-layout="box_count" data-width="300" data-show-faces="true" data-font="arial"></div> <!-- end fb-like -->
</div> <!--end main-->
<div id="side"> <!--Start side-->
<div id="sidea"> <!--Start sidea-->
<h3>Main Menu</h3>
<p><ul>
<li><a href="index1.html">Home</a></li>
<li><a href="iLinks.html">Links</a></li>
<li><a href="iTechniques.html">Techniques</a></li>
<li><a href="iVerse_Menu.html">Verse's</a></li>
<li><a href="icontact.html">Contact Us</a></li>
<li><a href="iblog.php">Blog</a></li>
<li><a href="iAboutUs.html">About Us</a></li>
<li><a href="iGallery.html">Gallery</a></li>
<li><a href="iStats_Menu.html">Stats</a></li>
<li><a href="iRelHol_Menu.html">Religious Holiday's</a></li>
<li><a href="iSub_form.html">Subscribe to Newsletter</a></li>
</ul></p>
</br>
</div> <!--end sidea-->
<div id="sideb"> <!--Start sideb-->
</div> <!--end sideb-->
<div id="sidec"> <!--Start sidec-->
</div> <!--end sidec-->
</div> <!--end side-->
</div> <!--end content-->
<div id="footer"> <!--Start footer-->
<p>© 2012 Content:1066 Cards 4U. All rights reserved. <br />
With thanks to Matt Taylor - matthewjamestaylor.com</p>
</div> <!--end footer-->
</div> <!--end wrap-->
</body>
</html>
Here is the CSS:
* {
margin:0;
padding:0;
}
h2 {
padding:1em 0 0 0;
}
p {
line-height:1.4em;
}
p + p {
text-indent:2em;
}
body {
font-size:100%;
text-align:center;
background:#ddd;
}
pre {
display:block;
margin:1em 0 0 0;
width:488px;
}
pre code {
background:#eee;
display:block;
padding:10px;
}
.r {
float:right;
padding:0 0 10px 20px;
}
/* Landscape mode (default) */
#wrap {
margin:0 auto;
width:1024px;
position:relative;
overflow:hidden;
text-align:left;
background:#fff;
}
#header {
float:left;
width:1024px;
padding:10px 0 20px 0;
background:#fff;
border-bottom:1px solid #000;
}
#header h1 {
padding:10px 30px 0 30px;
}
#header p {
padding:0 30px;
line-height:1.4em;
}
#content {
float:left;
width:1024px;
background:#eee;
position:relative;
left:768px;
}
#main {
float:left;
width:708px;
position:relative;
right:738px;
padding:20px 0;
}
#side {
float:right;
width:216px;
position:relative;
right:788px;
padding-bottom:20px;
}
#sidea,
#sideb,
#sidec {
clear:left;
float:left;
width:216px;
}
#footer {
clear:both;
float:left;
width:1024px;
border-top:1px solid #000;
background:#ddd;
}
#footer p {
padding:20px 30px;
}
@media only screen and (orientation:portrait){
/* portrait mode */
#header,
#wrap,
#footer {
}
#content {
left:0;
background:#fff;
}
#main {
float:left;
width:708px;
position:relative;
right:0;
left:30px;
padding:20px 0;
}
#side {
clear:left;
float:left;
width:768px;
right:0;
padding-bottom:20px;
background:#eee;
}
#sidea {
clear:none;
width:216px;
float:left;
position:relative;
left:30px;
padding-top:20px;
}
#sideb {
clear:none;
width:216px;
float:left;
position:relative;
left:60px;
padding-top:20px;
}
#sidec {
clear:none;
width:216px;
float:right;
position:relative;
right:30px;
padding-top:20px;
}
#footer {
position:absolute;
bottom:0;
width:100%;
height:60px; /* Height of the footer */
background:#6cf;
width:768px;
}
}
I have spent hours trying different things, but I can't find a solution.
I believe its a CSS problem, but if you think it is HTML can the moderator move it?
Your help would be appreciated.
I'm working to make my code more portable when moving it between servers. I am trying to use the $_SERVER['SERVER_NAME'] global variable to change the page's URL whenever I move it. Code: [Select] <a href="<?php print $_SERVER['SERVER_NAME'].'/index.php';?>">LINK TO SERVER'S HOME PAGE</a> This line is in a php page with this URL, http://localhost/php/tests/link_test.php However this is acting unexpectedly. The current directory of the file is being added before the server name and the link becomes, http://localhost/php/tests/localhost/index.php What am I doing wrong? Chris I have the following four tables. The query below is supposed to retrieve all projects and related data in associated tables where the project has been archived (i.e., archive field in project_info table set to '1') and user ID = '599zxj'. Dear all, how can I convert a string "yyyy-mm-dd hh:mm" into a really datetime value with php? thanks! If ($_GET['CODE'] == '1') { $ThreadID = mysql_escape_string($_GET['threadid']); $ForumID = mysql_result(mysql_query("SELECT forum_id FROM ".FORUM_THREADS." WHERE thread_id='{$ThreadID}'", $db), 0, 'forum_id'); $PostText = mysql_escape_string($_POST['replytext']); $IP = $_SERVER['REMOTE_ADDR']; $PostQuery = "INSERT INTO ".FORUM_POSTS." (`user_id`, `thread_id`, `post_text`, `forum_id`, `ip_address`, `timestamp`) VALUES ('{$memid}', '{$ThreadID}', '{$PostText}', '{$ForumID}', '{$IP}' , CURRENT_TIMESTAMP)"; $PostRes = mysql_query($PostQuery, $db); For some reason whenever this query goes through, it also adds a blank result using all the same information but without any $PostTest so essentially it does query: Code: [Select] INSERT INTO ".FORUM_POSTS." (`user_id`, `thread_id`, `post_text`, `forum_id`, `ip_address`, `timestamp`) VALUES ('{$memid}', '{$ThreadID}', '', '{$ForumID}', '{$IP}' , CURRENT_TIMESTAMP) This is the only query that does this part of the code and I can't see why it is adding 2 queries. FORUM_POSTS = constant containing table name. Greetings, I need a bit of php coding help. I have a query that gives me results. What I need to do is take those results and, I think, use php to compare the results and add a 1 to the correct section. Example: 3 tables table name- retail_sales id sales_id amount week table name- online_sales id sales_id amount week table name- sales_person sales_id name I have the query that breaks down results by week: week 1 | retail_sales.amount | online_sales.amount What I need is some php code that will then compare the two together and: if retail_sales.amount > online_sales.amount +1 to retail OR if retail_sales.amount < online_sales.amount +1 to online so you would end up with a result like a sports record (6-2) Any ideas Thank you for any help Hello, I have a database that contains a column with a int value for number of slots reserved, and what I want to do is fetch the value of each column and add them together to create one whole number. For example, in my database under preserved I have two separate values of 2 and 4.. I would like to take those two values and add them up into 6 through php... here is what I have so far: $slots = mysql_query("SELECT * FROM treservations WHERE reservation_date='$reservation_date' AND reservation_hour='$reservation_hour'") or die(mysql_error()); while ($row = mysql_fetch_assoc($slots)) { $row["preserved"]; } mysql_free_result($slots); Any help would be GREATLY appreciated.. if I need to add additional code please let me know. Thank you! I added a search form on my site but I cannot figure out how to add links to the search results.
The results are being posted as the item name and the item pages look like this used-product.php?Item=102
I am not understanding how I can have that url match up with my item name.
Here is my results.php code
In the header
<?php include_once('mysql_connect.php');
if (!isset($_POST['search'])) {
header ("Location:index.php");
}
$search_sql="SELECT * FROM new_equip WHERE itemname LIKE '% " .$_POST ['search'] . " %'";
$search_query=mysql_query($search_sql);
if(mysql_num_rows($search_query)!=0) {
$search_rs=mysql_fetch_assoc($search_query);
}
?>
and where the results are being displayed
<?phpif (mysql_num_rows($search_query)!=0){
do {?>
<p><a href="new-product.php?Item=<?php echo $eid; ?>"><?php echo $search_rs ['itemname']?></a></p>
<?php } while ($search_rs=mysql_fetch_assoc($search_query)) ;
} else {
echo "No Results Found";
}
?>
I have been on this and trying to figure out another issue I am having and I cannot figure out either of them. (The other is deleting a row from a table with the click of a link)
Any help on this would be greatly appreciated it. I have looked and trial and error all day and I cannot seem to get it.
Hi, Im trying to learn how to build a shopping cart system, im have a few problems and im not sure where im going wrong, it looks as though im getting an item into the session, but it looks like when i add another it over writing the first one, and im having trouble trying to echo it out. Here is what i have atm Code: [Select] session_start(); include('functions.php'); $pid = $_GET['product']; $q = $_GET['qty']; if($_GET['function']=="add") { echo "add " . $_GET['product']; $_SESSION['cart']=array(); $_SESSION['cart']['productid']=$pid; $_SESSION['cart']['qty']=$q; } print_r($_SESSION['cart']); echo showCart(); Am i way off on my code? regardless of how many things i try to add to session, all i can print out is the last one i entered. Cheers Tried to use a datetime addition function but it gave me this error: Quote Fatal error: Call to undefined function date_add() in /home2/cruxispr/public_html/mysidiaadoptables/devdemo/script.php on line 3 I searched on PHP tutorials, but it says there's no need to install any of these datetime related functions since they are part of PHP core. I dont understand, why do I get a no method error like this if it is indeed already in PHP core? Please help. Here are the links from PHP official site for references: http://www.php.net/manual/en/datetime.installation.php http://www.php.net/manual/en/datetime.add.php I'm stuck on how to only display records if they are in the last 3 days: how do i say: if $row['test_date'] occurred more than 3 days ago: don't display. else, display. Thank you :-) Hello guys. I am creating a PHP/mySQL based RPG. I have implemented training feature in it. So i want to make training possible every 15 minutes or so. Can you give me an advice how to achieve that? Thank you! Hello Everyone, I wanted to know how to Display records from a Table one by one at difference time intervals. Kindly suggest hi all please help... i would like to get datas between certain intervals. please have a look @ db_table.jpg, it's the db structure. the red highlighted part is the value i need. condition is select values when both device one & device two are off. db_table_report.jpg is the resulting report format. It contains start time & end time and the duration.. please help, i know it's a bit complicated, but it's urgent. Hello All, I have the following code: Code: [Select] echo "<table width='615px' cellpadding='3' cellspacing='4' align='center'>"; echo "<tr>"; echo "<td align='left' width='150px'>"; echo substr($row['date'],0,11); echo "</td>"; echo "<td align='left' width='465px'>"; echo $row["food"] ; echo "</td>"; echo "</tr>"; echo "</table>"; And this outputs: Apr 4 2011 Chicken Ceasar Salad, Garlic Toast, Cloddhoppers, Applesauce, & Milk (etc.) How can I add "Mon" in front of "Apr 4 2011"? thanks! This code gives me 1969-12-31 18:33:30 Code: [Select] <?=date('d M Y', $val['Created']);?> and this one gives me 2010-11-04 03:52:54 WHICH IS THE RIGHT ONE - BUT i need to format as above. Code: [Select] <?=$val['Created']?> this happens on the same line of code. What is wrong? Basically I am using DATETIME to store the time in which a row was input. Format - 2010-11-13 21:31:53 How would I get the current time of page load and compare it to the database row "2010-11-13 21:31:53" then output the difference. Example $sqlresult = 2010-11-13 21:31:53; $currentTime = (GET CURRENT DATE+TIME = (2010-11-13 21:31:55) ); Output - This was posted 2 minute's ago. Thank you in advance. Any help would be greatly appreciated. Hey, does anybody know a good function, where I can have the trendy "time ago" functionality?
A good tutorial would be cool, too.
I would be using the datetime function off MySQL.
Hello!! i want to save datetimes into a mysql database. Their format is dd-mm-yy hh:mm. I think mysql format for datetime is yy-mm-dd hh:mm..How can i convert them?? |
|||||||