PHP - Looping Through Dates

i want to created a case like the following need help with the syntax:
Code: [Select]
switch (true)
{
case($fromdate-$todate==17-04-2001-25-04-2011):
echo $finalprice = $result;
        break;
}

Hi guys,

I am trying to create a program which manages campaigns.
each campaign has a start date and and end date.
a user has to enter data releated to the campaign everyday

example
start date: 10-1-2011
end date: 17-1-2011

now all this information is stored in 2 tables
1st table is "campaigns" this stores the campaign name, start date and end date
and 2nd table is "campaign_data" this table stored the data for each campaign and also date of when that data was entered

my question is, if the user did not enter data on 11-1-2011 how will I know this, keeping in mind the month diffrence which can accur if the length of the campign was 2 month long?


table:
campaigns
fields:
id | campaign_name | start_date | end_date

table:
campaign_data
fields:
id | campaign_id | date | page

Thank you

Hey guys,

What I'm trying to do is set 2 dates.  Today's date and then a date 14 days from now.  However, I want it to increase the month if by adding 14 days will bring me to the next month, same with the year.

I have this, but it doesn't increment the month or year.

$week = mktime(11, 59, 59, date("m"), date("d")+14, date("y"));
$date =  date("Y-m-d H:i:s", $week);

How come this doesn't loop? Everything is in the while loop.    My database connection is in the included file you see to begin the code which is what db_conx refers to just to be clear. Database connection is not an issue nor is getting values. I just get the first one and nothing more. No looping taking place here.    What I miss? 

require('includes/db_connect.php');
    $query = "SELECT * FROM events ORDER BY displayorder ASC";
    $result = mysqli_query($db_conx, $query);
    while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
    $pid = $row["id"];
    $title = $row["title"];
    $date = $row["date"];
    $info = $row["info"];
    $linkTxt = $row["linkTxt"];
    $link = $row["link"];
    
    $message = "<div id='events_holder'><table width='500' border='0' cellspacing='0' cellpadding='10'>
    <form action='edit_event_parse.php' method='post'>
  <tr>
    <td class='prayer_title'>Title:</td>
    <td><input type='text' name='title' class='admin_input' value='" .$title."' /></td>
  </tr>
  <tr>
    <td class='prayer_title'>Date:</td>
    <td><input type='text' name='date' class='admin_input' value='".$date."' /></td>
  </tr>
  <tr>
    <td class='prayer_title'>Link Text:</td>
    <td><input type='text' name='linkTxt' class='admin_input' value='".$linkTxt."' /></td>
  </tr>
  <tr>
    <td class='prayer_title'>Link URL:</td>
    <td><input type='text' name='link' class='admin_input' value='".$link."' /></td>
  </tr>
  <tr>
    <td class='prayer_title'>Event Details:</td>
    <td><textarea name='info' cols='20' rows='10' class='admin_area'>".$info."</textarea></td>
  </tr>
  <tr>
    <td><input type='hidden' name='pid' value='".$pid."' /></td>
    <td><input name='submit' type='submit' value='Edit Event' class='admin_submit'/></td>
  </tr>
  </form>
</table>
<p>&nbsp;</p>
<hr />
<p>&nbsp;</p>
    </div>";  
    
  }

Thanks!

I am pulling data from an sql data base. I want it to displayed (Item # | Error button | Link) however as its looping with a while on the database info I cant seem to get it to loop on the item number so it shows 1, 2, 3,.... on each row.

Current coding is:

while ($info = mysql_fetch_array($data)){

Print '<tr>';
Print"<td style='width: 15px;' class='cat-list'>$D</td>";

if ($info['id']==""){
Print"<td class='cat-list'>&nbsp;</td>";
}else{
Print"<td class='cat-list' style='width: 20px;'><img border='0' src='images/error.png' width='16' height='16'></td>";
}

if ($info['link']==""){
Print"<td class='cat-list'>&nbsp;</td>";
}else{
Print"<td class='cat-list'><a target='_blank' href='".html_entity_decode(stripslashes($info[link]))."'>".substr(html_entity_decode(stripslashes($info[link])), 0, 85)."</a></td>";
}
}



How would I get the $D item to show 1 2 3... ect?

Thanks,
Jim

Take a look he
http://answers.yahooapis.com/AnswersService/V1/questionSearch?appid=YahooDemo&query=test

That is a generated XML file from Yahoo's API. If you take a look, it has a node titled "Question". With PHP, how can I loop through each "Question" node and grab all of it's children as well?

I tried this code, but apparently it did not work:


$req = "http://answers.yahooapis.com/AnswersService/V1/questionSearch?appid=YahooDemo&query=php";
$res = file_get_contents($req);
$xml = simplexml_load_string($res);

foreach ($xml->xpath('//Question') as $question) { // "//question" means for each question node
  echo((string)$question['Subject']." - ".(string)$question['Content']); // you get all the child nodes in $question
} 

ok, here is some code:
Code: [Select]
<?php
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM products");
while($row = mysql_fetch_array($sql)){
$product = $row["product"];
?>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.4.2.min.js"></script>
<script type="text/javascript" src="http://ajax.microsoft.com/ajax/jquery.validate/1.7/jquery.validate.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#myform").validate({
debug: false,

submitHandler: function(form) {
// do other stuff for a valid form
$.post('process.php', $("#myform").serialize(), function(data) {
$("#price").load("index.php #price");
$('#results').html(data);
});
}
});
});
</script>
<form name="myform" id="myform" method="POST" action=""> 
     
        <input type="hidden" name="hiddenField" id="hiddenField" value="<?php echo $product; ?>" />
<input type="submit" name="submit" value="Submit" style="background-color:lightgreen; height:50px; width:100px;">     </form> 

<?php

}
?>and here is process.php Code: [Select]
<?php
include_once("/connect.php");
?>
<?php 
$price=$_POST['hiddenField'];
 $sql = "INSERT INTO cart (price) 
VALUES('$price')";
 $rs = mysql_query($sql) or die ("Problem with the query: $sql<br>" . mysql_error());
echo mysql_error();
?>.

what is happening is it is supposed to be submitting form without page reload.......but only the first one in the loop does it.  I want all of them to do it.  can anyone help me do this properly.

ANYONE WHO CAN HELP ME WITH MY LOOP? THIS IS THE CODE THANKS IN ADVANCE. <?php
$testTwo = 'bakit ayaw po gumana paulit ulit bakit';
$testOne = 'bakit paulit ulit bakit ulit';
$tTwo = explode(' ', $testTwo);
$tOne = explode(' ', $testOne); echo"SIMILARITIES:</br>";
foreach($tOne as $first) {
foreach($tTwo as $second) {
if($second == $first) {
echo $second.'&nbsp';
} 
} 
echo"</br>"; 
} ?> THIS IS THE OUTPUT SIMILARITIES:
bakit bakit 
paulit 
ulit 
bakit bakit 
ulit THIS IS MY EXPECTING OUTPUT.
bakit
paulit
ulit
bakit 
ulit 
lang

ok I'm a bit stuck here were I would think something would work easily im getting an error.

What I am trying to loop is..


$data="UPDATE ts12 SET djid='$_POST[TS0]' WHERE id=1";
$data="UPDATE ts12 SET djid='$_POST[TS1]' WHERE id=2";

This would go on for 84 id's. So I figured I could just loop this line so I only have to type it once. Right now I have it set up for just testing 7 ids and I have this code....

if ($edit == yes) {
for ($i=0; $i < 7; $i++){ $n=($i+1);
$data.="UPDATE ts12 SET djid='$_POST[TS$i]' WHERE id=$n";
}
if (!mysql_query($data,$con))  die('Error: ' . mysql_error());
}else{}

The error I am getting is...
PHP Parse error:  syntax error, unexpected T_VARIABLE, expecting ']' in dir/page on line 6


What am I doing wrong here?

i have this bit of code which is supposed to do a while loop of rows from a database then inside that does a while loop of columns, so its basically creating a html table of dynamic data from mysql.

the column loop works fine, but the row one isnt, it only goes through and echos out the first row then stops.

ive spent hours now trying to see why and i cant see it hence my call for help.


$totalrows = 4;
$columns = 5;
$columncount = 1;
$rowcount = 1;

echo "<table>";
while ($rowcount <= $totalrows) {
echo "<tr>";
$sql = "SELECT * FROM ville_map WHERE id = '$rowcount'";
$sql_result = mysql_query($sql, $connection); 
while ($row = mysql_fetch_array($sql_result)) { 
$c1 = explode(',', $row["c1"]);
$c2 = explode(',', $row["c2"]);
$c3 = explode(',', $row["c3"]);
$c4 = explode(',', $row["c4"]);
$c5 = explode(',', $row["c5"]);

while ($columncount <= $columns) {
$arraynum = ${'c'.$columncount};
 if ($arraynum[2] > 0) { $playerimage = '<img src="images/player' .$arraynum[2]. '.png"'; } else { $playerimage = ""; }
echo '<td background="images/' .$arraynum[0]. '.jpg" width="50" height="50">' .$playerimage. '</td>' ;
$columncount++;
}
}
echo "</tr>";
$rowcount++;
}
?>
</table>


any help would be much appreciated.

Hey,

I have the following code that gets the name of the course from the XML.

XML Snippet
Code: [Select]
<?xml version="1.0"?>
<courses>
  <course>
    <id>70</id>
    <name>Marketing and Social Media</name>
    <dates>
      <date>
        <instance_id>6747</instance_id>
        <location />
        <course_type>Day</course_type>
        <date_available>2011/07/13</date_available>
        <time_start>9:30</time_start>
        <time_end>17:00</time_end>
        <availibility>7</availibility>
        <running_dates>
          <running_date>2011/07/13</running_date>
          <running_date>2011/07/14</running_date>
        </running_dates>
      </date>
    </dates>
  </course>
  <course>
</courses>

PHP
Code: [Select]
$dom = new DomDocument();
$dom->load("courses.xml");
$xp = new domxpath($dom);

$titles = $xp->query("/courses/course/name");
foreach ($titles as $node) {

    print $node->textContent . " ";

}


This prints out the course name fine. My question is how Can i get the rest of the data from the same query. For example why cant I do something like..

Code: [Select]
...
foreach ($titles as $node) {

    print $node->name. " ";
    print $node->time_start. " ";
    print $node->course_type. " ";

etc..

}


So I want to loop through get the name and assign the rest of the nodes in there to variables or something.

When just generating HTML, where should dates be formatted?  What about when generating JSON (I've found that date formatting is not so straight forward using JavaScript)?  Are there factors which may make one approach better than the other (i.e. querying one record versus a list of records)?  How important is consistency of an approach?  Any other factors I should consider?  Please provide rational for your decision.  Thank you     At the database?

DATE_FORMAT(my_date, "%m/%d/%Y %r") AS my_date

In the controller?

$date = new DateTime($my_date);
$my_date=$date->format('m/d/Y');

In a twig or smarty template?

{{ mydate|date("m/d/Y g:i A") }}

At the client using handlebars and the Moment library?

UI.registerHelper("formatDate", function(datetime, format) {
if (moment) {
f = DateFormats[format];
return moment(datetime).format(f);
}
else {
return datetime;
}
});

...

{{formatDate MyISOString "short"}}

I was just wondering if anyone can reccomend the best way to get dates from a database and turn them into dates you can display.  For example if you have a date stored such as 23/08/10, is there an easy way to turn this into 23rd August 2010?  Thanks for any help. 

I'm trying to make a script to check a files date time and if its under so many seconds long the page will refresh.  here is what I've got.  I've been testing the output of the date() functions but when i do the math all i get is a 0.  where did i go wrong? is it just i can't do math with dates?  Thanks in advanced.
  Code: [Select]
<html><head>
<meta http-Equiv="Cache-Control" Content="no-cache">
<meta http-Equiv="Pragma" Content="no-cache">
<meta http-Equiv="Expires" Content="0">
<?
$proFile = "profilePics/profile.jpg";
//if ( date ("m d Y H:i:s.") - date ("m d Y H:i:s.", filemtime($proFile)) <= 00 00 0000 00:00:04 ){ //this is where the magic should happen.
//echo "<meta http-equiv="refresh" content='4'>"; }
?>
</head>
<?
echo date ("m d Y H:i:s.");
echo "<br>";
echo date ("m d Y H:i:s.", filemtime($proFile));
echo "<br>";
echo  date ("m d Y H:i:s.") - date ("m d Y H:i:s.", filemtime($proFile)); //only outputs 0

?>

Hi There,

I am trying to create a table, and accross the top I would like the Week Commencing Dates of the last 5 weeks. So for example:

<table>
<tr><td>07/02</td><td>31/01</td><td>24/01</td><td>17/01</td><td>10/01</td></tr>
</table>

Can anyone help?

Cheers
Matt