PHP - Dynamic Months

hi, im making a simple blgo system, and i'd like to show a list of the last ten months, so the user can click the month name, and it will open the blog page with all the posts from that month, just like we usually see in blogs.
any ideas?
thanks in advance

I am working on a report generation. Here I need to count the number of months involved in the selected date range. I need to apply the monthly charges accordingly.

Example: If the user selects 25-08-2011 to 03-10-2011, it should return 3 as the number of months.

Yes, the number of days are less than 60 but still the date range is spread across 3 months.

Any solution.. Please.

Girish

Hi,

I have db field with date. I want to make select statement with where clause when part of the date (month) is true. Example, i have records from 2020-2-1 until 2020-4-3, i want to select records for march only 2020-3-1 to 2020-3-31. how to do that? 

Hello All,

I have a News database in which articles are entered in. Right now all the stories are being display in one big page with every story on it. What I would like to do is to create an "archive" in which it automatically organizes the stories by their date.

For example.

2011
February
January

2010
December
November
October
September
etc...
etc...

I have a datetime field for the database, and I know how to do this all manually, but I can't figure out how to make it automatically add a month each month. It would be too much maintanence to have to update this every month.

I also don't know what this would be called, so I don't even know what to search for. I've tried blog and news, but doesn't seem to be what I want.

Any help would be appreciated!

I got 3 problems I am not able to do with the following PHP code

1) The sort function is not sorting the months in order like how I want it? Why?
2) How would I use a for loop to display the array of months?
3) How would I use a while loop and switch statements to display the array of months with # of days in each?

Code: [Select]
<?php
$calendar = array("Janurary", "Feburary", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
print_r ($calendar);

echo "<h1>FOR loop</h1>";
echo "(put for loop code here)";
echo "<br>";
sort($calender);
echo "<br>";
print_r ($calendar);

echo "<h1>WHILE loop, SWITCH statement</h1>";
echo "(put while loop code here)";
echo "<br>";
?>

Just to make things a lot simpler, I decided to start a new topic.

My question is, how can I count how many months it is back to the past November?

Example: May 2011 back to November would return 6.

Example: Dec 2011 back to November would return 1.

Example: October 2011 back to November would return 11.

Jake

As far as I can see, this code:
Code: [Select]
$this->_licence_expires = date('Y/m/d', mktime(0, 0, 0, date("m"), date("d")-1, date("Y")));
results in accounts expiring 1 year from today, right?

How can I change it so that it will result in expiry 9 months from today?

TIA

Hello,
I am trying to display rainfall totals for the year so far in a table with months going across and days going down. Like so:

-- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1
2
3
4
5
6
7
8
etc

And then have the rainfall totals for each day in the table, I am quite experienced with PHP however I cant work out how I would do this 

The data is stored in a mysql table called "wx_daily", and the rainfall column is called" RainTotal". The dates are stored in the "Date" column in mysql Date format.

Im using the following mysql query:

SELECT * FROM wx_daily WHERE YEAR(Date) = '2011' ORDER BY Date Asc


Thanks,
Mark

I'm getting this error "Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/westiehi/public_html/groupBOS.php on line 36"

for this code: Code: [Select]
$query_rs_specialty = "SELECT * FROM specialty WHERE Group_Place <> '' and Date>= DATE_SUB(CURDATE(), INTERVAL 6 MONTH) ORDER BY Date DESC";

I've tried everything to get this to take records where the one field is blank and the date is greater than a date 6 months ago but nothing seems to work.  Help would sure be appreciated!!

So this is a simple code that finds out the difference between two dates and displays it in number of days.

$date1=date_create("2013-03-15");
$date2=date_create("2013-12-12");
$diff=date_diff($date1,$date2);
echo $diff->format("%R%a days");

// RESULT
+272 days

 

My first question. Is it possible to remove the + sign in the result above?

Second question. Is it possible to show "months" if it's greater than 30 days? And years if the days are greater than 365?

How would I do this?

I am using the following code to get the third sunday of every month for +6 Months from todays date.  I have put together the following code which works perfectly when the date is echoed however when it comes to inserting those dates into mysql db it throws a unable to convert to string error.  Im new to this and my head is in a spin as to why those dates can't be inserted if they can echoed ok.  I have spent 2 days at it now and searched many forum however they seem to get side tracked from my issue (or do they)??????? I figure I can't go mixing DateTime and date() the way I have?  Please help???

Code: [Select]
[php]
$month=date('F');
$now=date('Y-m-d');
$year=date('Y');

$num='3'; //example only this will be a $_POST value 0-3
$day='Sunday'; //example only this will be a $_POST value Monday-Sunday

$start= date('Y-m-d', strtotime('+'.$num.' week '.$day.' '.$month.' '.$year.''));

if($start>$now) {
$begin=strtotime('+'.$num.' week '.$day.' '.$month.' '.$year.'');
} else {
$d = new DateTime( $start );
$d->modify( 'first day of next month' );
$nextmonth = $d->format( 'F' );
$year = $d->format( 'Y' );
$begin=strtotime('+'.$num.' week '.$day.' '.$nextmonth.' '.$year.'');
}

$date=date('Y-m-d', $begin);
# insert into db first occurance
//mysql_select_db($database);
//$query_rsFirst = "INSERT INTO event_date VALUES (NULL, '$event', '$d', '$date', '$date')";
//$rsFirst = mysql_query($query_rsFirst) or die(mysql_error());
echo $date.'<br/>';
for($i = 0; $i <= 4; $i++)  {
$d = new DateTime( $date );
$d->modify( 'first day of next month' );
$nextmonth = $d->format( 'F' );
$date=date('Y-m-d', strtotime('+'.$num.' week '.$day.' '.$nextmonth.' '.$year.''));

# insert into db
//mysql_select_db($database);
//$query_rsDate = "INSERT INTO event_date VALUES (NULL, '$event', '$d', '$date', '$date')";
//$rsDate = mysql_query($query_rsDate) or die(mysql_error());
echo $date.'<br/>';
if($nextmonth=="December") {
$d = new DateTime( $date );
$d->modify( 'first day of next year' );
$year = $d->format( 'Y' );
}
}
[/php]

Folks,

I need help (Php code ) to generate a Dynamic Text on a Base Image. What i want to do is, to make this Image as header on my Site and to make this Header Specific to a Site, i want to Add the Domain Name on the Lower Left of the Image.

Got the Idea?

Here is the Image link:

Quote

http://img27.imageshack.us/i/shoppingheader1.jpg/


PHP Variable that holds the Domain name is:  $domain 

All i need the Dynamic PHP Codes that i can put on all my sites to generate this Text on Image (Header) Dynamically...

May Anyone Help me with this Please?

Cheers
Natasha T.

Hi all

I need to combine these two scripts:

Firstly, the following decides which out of the following list is selected based on its value in the mySQL table:

<select name="pack_choice">
<option value="Meters / Pack"<?php echo (($result['pack_choice']=="Meters / Pack") ? ' selected="selected"':'') ?>>Meters / Pack (m2)</option>
<option value="m3"<?php echo (($result['pack_choice']=="m3") ? ' selected="selected"':'') ?>>Meters / Pack (m3)</option>
<option value="Quantity"<?php echo (($result['pack_choice']=="Quantity") ? ' selected="selected"':'') ?>>Quantity</option>
</select>

Although this works OK, I need it also to show dynamic values like this:

select name="category">
<?php
$listCategories=mysql_query("SELECT * FROM `product_categories` ORDER BY id ASC");
while($categoryReturned=mysql_fetch_array($listCategories)) {
echo "<option value=\"".$categoryReturned['name']."\">".$categoryReturned['name']."</option>";
}
?>
</select>

I'm not sure if this is possible?

Many thanks for your help.

Pete

Hello!

If you search Google, you'll notice the URL: http://www.google.com/webhp?hl=en#hl=en&source=hp&q=php+freaks&aq=f&aqi=g10&aql=&oq=&gs_rfai=CtdaTdtdRTNnPD5HuzASZtMWiCgAAAKoEBU_Q0ZT5&pbx=1&fp=19d754eee0b4f223

You can copy that URL anywhere you like... and the user will still see the same results.

So basically the URL dynamically does an action, and accesses the database.

How on do I make a URL like this? Meaning when you change the URL parameter values, it request a slightly different database query?

Does that make sense? Similarly with NexTag.com: http://www.nextag.com/serv/main/buyer/ProductCompare.jsp?search=camera&page=0&node=500001&psort=%2FDigital-Cameras--zzcameraz500001zB6z5---html&zipcode=&cptitle=657166355&cptitle=656751324&cptitle=620051906&cptitle=705150048

That was a Dynamically made URL (I selected from check boxes which products to compare) and it makes that URL so anyone can see those products.

Any ideas on how to do this?


More examples on the URL: http://www.cars.com/go/compare/modelCompare.jsp?myids=9721,11439  (i select the cars, it generates that URL. Notice the IDs 9721,11439)
 

I'm having trouble getting the dynamic data from my <select> menus to write into my MYSQL database.  Can anyone see what I'm doing wrong here?  First post btw

The output looks like this, which is obviously wrong: 

Code: [Select]
<html>
<head> </head>
<link rel="stylesheet" type="text/css" href="./css/newuser.css" />
<body>
<?php session_start();
require 'default.inc.php'; ?>

<?php if (isset($_POST['amount'])): 
$host = 'localhost';
                $user = 'user';
                $pass = 'password';
                $conn = mysql_connect($host, $user, $pass);
                if (!$conn) {
                        exit('<p>Unable to connect to the database 
server</p>');
                }
                if (!@mysql_select_db('spikesusers')) {
                        exit('<p>Unable to locate the database</p>');
                }
        $locationname = $_POST['donor'];
        $donorid = mysql_query("SELECT id FROM donors WHERE locationname='$locationname'");

$amount = $_POST['amount'];
        $year = $_POST['year'];
        
$type = $_POST['type'];
        $typeid = mysql_query("SELECT id FROM donationtype WHERE type='$type'");

$player = $_POST['player'];
//$playerid = mysql_query("SELECT id FROM players WHERE 

        $sql = "INSERT INTO donations SET donorid='$donorid', amount='$amount', yearofdonation='$year', 
typeid='$typeid'";
mysql_query($sql);
?>
<div class='standard'>
<h1>Donation Management</h1>

<?php
if ($sql) {
                echo "New donation added ";
                echo "<p></p>";
echo "<a href=managedonations.php>Back to donation management</a>";
                exit();
        } else {
        echo "Error adding new donation";
        echo "<a href=adddonation.php>Try again</a>";
        exit();
        }
        
?></div>
<?php else:
$host = 'localhost';
                $user = 'user';
                $pass = 'pass';
                $conn = mysql_connect($host, $user, $pass);
                if (!$conn) {
                        exit('<p>Unable to connect to the database
server</p>');
                }
                if (!@mysql_select_db('spikesusers')) {
                        exit('<p>Unable to locate the database</p>');
                }
$donor=@mysql_query('SELECT id, locationname FROM donors');
?>
<div class='standard'>
<h1>Donation Management</h1>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
    <label>Donor:
    <select class="text" name="donor">
<option value=new>Add a new donor...</option>
<?php
while ($donors=mysql_fetch_array($donor)) {
$donorname=$donors['locationname'];
echo "<option value='<?php echo $donorname;?>'>$donorname</option>";
//echo "<option value='hi'>hi</option>";
}
?>
</option>
</select>
</label><br />
<label>Amount:
      <input class="text" type="text" name="amount" class="text" /></label><br />
<label>Year of donation:
      <select class="text" name="year">
<option value='2011'>2011</option>
<option value='2010'>2010</option>
<option value='2009'>2009</option>
      </select>
</label><br />
<?php $player=@mysql_query('SELECT id, firstname, lastname FROM players'); ?>
<label>Player:
<select class="text" name="player">
<option value="player" selected="selected"></option>
<?php
while ($players=mysql_fetch_array($player)) {
$playerfirstname=$players['firstname'];
$playerlastname=$players['lastname'];
echo "<option value=player>$playerfirstname $playerlastname</option>";
}
?>
</select>
</label><br />

<?php $type=@mysql_query('SELECT id, type FROM donationtype'); ?>
<label>Donation type:
<select class="text" name="type">
<?php
while ($types=mysql_fetch_array($type)) {
$donationtype=$types['type'];
echo "<option value=type>$donationtype</option>";
}
?>
</select>
</label><br />

<input type="submit" value="SUBMIT" class="buttons"/>
    <input type="button" name="Cancel" value="CANCEL"
onclick="window.location = 'managedonations.php'" class="buttons"/>
</form>
</div> <?php endif; ?> </body>
</html>