PHP - Compare Dates In Loop And Increment Value

must be v easy to answer for many here but i dont know how to do it

how can i use for loop to print values between any range but with increment of 0.5

0
0.5
1
1.5
2
2.5
3
........till n

Hi,

I have coded a lot in the past but only now getting into PHP and web coding in general, when I use a while loop in most other languages I need to increment some form of counter to move to the next item e.g.
Code: [Select]
while (count < 10)
{
Do something;
count + 1;
}
I am going through a set of tutorials that have just enlightened me to the following code when looking up a MYsql d'base:
Code: [Select]
$reults = "SELECT * FROM table";
while ($row = mysql_fetch_assoc($results)){
extract($row);
echo $tblcol1;
echo "  - ";
echo $tblcol2;
echo "<br>";
}
Now in fairness I have no real problem with this, if thats how you extract your results from a query then fine but I feel I am missing something and have not been able to nail it on the head.  Am I to assume that $row in the loop returns the first row from the query results, moves through the actions of the loop, returns then automatically points to the next row of the array?

Does that mean while($row){} where $row is a 3x3 array(for example) it would loop through this 3 times assigning the next row until the end?

Is there a better way to explain this?

hi, i’m currently facing a new problem (i managed to use array_unique function successfully but i face this problem)with my php loop. i couldn’t seem to increment in my foreach loop to get the value of an array.
here is my code:

$update_id1=Array ( [0] => 398 [1] => 397 [2] => 393 [3] => 391 [8] => );

//$i=0;
foreach ($update_id1 as $i => $v) {

     $ex= explode(",", $v);
     $unique=array_unique($ex);

//f$ketch username from update table in db and inject it to the feed query.
   $imp_id= implode(',', $ids);
//$id1=$ids[$i];
  // $x=0;
 // for($x=0;$x<count(unique);$x++){ 
   echo 'ids:- '.$i; print_r($unique[$i]); echo '<br>';
   
//}
   

            
$totalUpdates=$project->totalUpdates($ids[$i],$_SESSION['uname'] ,$unique[$i],$load);   

 //$i++;
 }

i tried every method nothing seems to work can anyone help me in this regard please.

Edited December 25, 2019 by narutofan

I am doing some study on using time() and date() and i just wrote this simple for loop to add one day to each iteration with +$i and its echoing the unix timestamp as opposed to the correctly formated date as it should be based on my code. Anyone have any idea why this is not working as expected?

for($i=0; $i < 50; $i++)
{
echo $time = time()+$i . "<br />"; // add a day on each iteration
echo date('y-m-d', $time) . "<br />"; // should echo 10-12-02, 10-12-03, 10-12-04, etc..
}

what am i doing wrong here? arrgggg! maybe its too late for this s$%^#!

Hi there!
On a page of mine, random tables get generated. The tables consist of 8 characters, so there's 5 . 10^13 possibilities. Yet ofcourse there is a possibility that 2 tables with the same name can be generated, which ofcourse is not desired. So I need an adjustment that can see whether there is already a name that's the same, and if so, make another random name. And if that one also exists, make a new one again. Untill the name doesn't exist yet and it remains.

Here's the script I have right now:

function createName($length) 
{
$chars = "abcdefghijkmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
$i = 0;
$password = "";
while ($i <= $length) 
{
$password .= $chars{mt_rand(0,strlen($chars))};
$i++;
}
return $password;
}
 
$name = createName(8);

mysql_select_db($database, $con);

$sql = "CREATE TABLE " . $name . "(
id int NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
devraag varchar(500),
weergave varchar(500),
naam varchar(500),
inhoud varchar(500),
tijd varchar(100))";
mysql_query($sql, $connection)or die(mysql_error());


I'm not goot with the combination of PHP and mysql, and really have no Idea how to do this.

Any help?

Hi, I am completely stuck on this. I am trying to allow the user to select a start day and end day.  then the system adds two weeks to the start day and each previous calculation (ie intervals of 0 weeks, 2 weeks, 4 weeks, etc. from the start day) until the end date is reached.  I would also like each of these dates to be inserted into my database.   I have no clue as to where to even start with this.  I know I will need some kind of loop based on days, but I am not sure how I would write this.     I suppose this would be the basic structure of the query, but not sure how to incorporate this loop that I need.

mysql_query("INSERT INTO events (title, date)
VALUES ('$title', '(current date that the loop is in)')");
mysql_error();

can anyone help me out with this?  thanks in Advance!

I have two arrays, X and Y, which contain names. The arrays are of the same size. The arrays are related to each other such that for each pair

X[n] , Y[n]

X is friends with Y.

For example:
X[0,1,2] = [Link, Cloud, Cloud, Mario, Mario, Luigi]
Y[0,1,2] = [Zelda, Barrett, Tifa, Luigi, Bowser, Mario]

Link is friends with Zelda
Cloud is friends with Barrett and Tifa
Mario is friends with Luigi and Bowser
Luigi is friends with Mario

I want to loop through these arrays and, for each unique name, find all of that person's friends.

I then want to print the results to a text file, like so:

Link, Zelda
Cloud, Barrett, Tifa
Mario, Luigi
Luigi, Mario

I know how to do this theoretically, but I just need help with the PHP syntax. Thanks very much.

Hello everyone,

I am trying to convert dates directly from the database but still keep it within the same array so that I can conveniently access it later on. I am not sure how to explain this better, but I believe the code is pretty self explanatory:
$stmt = $this->db->query("SELECT title,slug,content,author_id,created FROM article");

$stmt->setFetchMode(PDO::FETCH_ASSOC);

$i = 0;

while($var = $stmt->fetch())
{
$this->data[] = $var;
$this->data[$i]['date'] = date("F j, Y", strtotime($var['created']));
$i++;
}

print_r($this->data);

/* produced array
Array
(
    [0] => Array
        (
            [title] => PHP Security Book
            [slug] => php-security-book
            [content] => Lorem ipsum dolor sit amet, consectetur adipisicing elit.
            [author_id] => 3
            [created] => 2012-03-13 12:34:42
            [date] => March 13, 2012
        )

    [1] => Array
        (
            [title] => Something To Do
            [slug] => somthing-to-do
            [content] => You know what a dolor sit amet, consectetur adipisicing elit.
            [author_id] => 3
            [created] => 2012-03-13 12:35:46
            [date] => March 13, 2012
        )
)
*/

I access it like so:

foreach ($_data as $var) 
{
echo '<h2>' . $var['title'] . '</h2> <br />';
echo '<b>' . $var['date'] . '</b> <br />';
echo '<p>' . $var['content'] . '</p> <br />';
}

It works perfectly but my question is:
Is there a better or more efficient way to do this? I think that my while loop could use some improvement.
I was also thinking of maybe fetching the results into a class using PDO::FETCH_CLASS, but it seems like a bit of a hassle for just one modification.

example structure of text database-  mytextfile.txt
10-11201|2010/09/01|Sam|Thurston
10-11307|2010/09/04|Tony|Piper
10-11405|2010/09/11|Sarah|Smith

<?php
$file2 = 'mytextfile.txt';

$openedfile =fopen($file2, "r") or die("ERROR- could not open file for editing.");
//
flock($openedfile, LOCK_EX) or die("Error!- Could not obtain exclusive lock on the file to edit.");
$hold[$record_count] = explode("|", trim(fgets($openedfile)));
 while(!feof($openedfile))
{
$record_count++;
$hold[$record_count] = explode("|", trim(fgets($openedfile)));
}
?>

What I need to do is loop through this and one by one- take any arrays that contain a date that is between $dateX and $dateY (which comes via a form input) and place it in a new array $matched.   I am stumped. 
1-Is there a way to do it inside the above while loop that I am not seeing?
2- Do I need to open the file in another manner? 
2- Would it be best to now loop through $hold[$record_count]

I am trying to keep the process short so as not to use up too much memory.  Point me in the right direction for this one please.

 

Hi Guys

Ever had the feeling your being a spoon and can't see the wood for the trees? Well, that's how I feel today.

All I am trying to to is implement a variable in a "foreach" loop that increments by one through each iteration of the loop. I know how to do it in a "for" loop but can't for the life of me get it to work here. Here is the code:

foreach ($cart as $prodcode => $qty)
  {
    $item = get_product_details($prodcode);
    echo '<input type="hidden" name="item_name_'.[b]$needavariablehere[/b].'" value="'.$item['description'].$_SESSION['finish'][$prodcode].$_SESSION['handles'][$prodcode].'" />' . "\n";
}

Where I have highlighted $needavariablehere is where I want a number to appear i.e. if there is one item available and the foreach loop iterates once I want the number 1 here. If there are two items and the foreach loop iterates twice I want the output to have number 1 in the first line and number 2 the second time around and so on.

How many times the foreach loop iterates is based on the $cart array which contains items in a shopping cart.

Thanks for any help you can give guys.

Hi All,

I need to subtract dates and display the number of days left.  I have a 'Start' date and an 'End' date in DATETIME format in the DB.  Not quite sure where to start.  A simply start - end doesn't work  .

Start = 2011-11-01-00:00:00
End = 2011-11-30-23:59:59

Since it is now 2011-11-27, my output should equal 3.  Any help is appreciated.

Hi guys,

I am trying to do a multidates events availability calender. The script below indicates todays date by highlighting an orange colour and also indicates the start and end date of the event highlighting grey colour on the two dates (The colour are link via css classes as shown).
Code: [Select]
//Today's date
$todaysDate = date("d/m/Y");
            $dateToCompare = $daystring . '/' . $monthstring . '/' . $year;
echo "<td align='center' ";
if($todaysDate == $dateToCompare){
echo "class='today'";
}else{
//Compare's the event dates
$sqlcount = "select event_start,event_end from b_calender where event_start ='".$dateToCompare."' AND event_end='".$dateToCompare."'";
$noOfEvent = mysql_num_rows(mysql_query($sqlcount));
if($noOfEvent >= 1){
echo "class='event'";
}
}
It works ok i.e. if start date = 01/01/2012 and end date = 04/01/2012 both date will be highlighted with grey colour. However I want it to also highlight grey on the dates between the 1st and 4th to show that then anydates between the 1st and 4th are not available and this is when I'm stuck.

Please guys I need help.

Thanks

I believe it's called increment. Either way, I cannot figure out how to simply count up beginning at 1 (in red in the div below) ...

function wp_rss( $url, $num_items = -1 ) {
    if ( $rss = fetch_rss( $url ) ) {
        echo '<div id="charts">';

        if ( $num_items !== -1 ) {
            $rss->items = array_slice( $rss->items, 0, $num_items );
        }

        foreach ( (array) $rss->items as $item ) {
            printf(
                '<div id="chart_lt">1</div><div id="chart_rt">%3$s</div>',
                esc_url( $item['link'] ),
                esc_attr( strip_tags( $item['description'] ) ),
                htmlentities( $item['title'] )
            );
        }

        echo '</div>';
    } else {
        _e( 'An error has occurred, which probably means the feed is down. Try again later.' );
    }
}

Code: [Select]
$db->query('UPDATE users set actions=actions+1|'.time().' where id = '.$pun_user['id'].'');
im trying to do set actions=actions+1, then put a | atfter +1ing it, then add my time stamp to it so I can explode it later.

so it will look like this

2|unixtimestamphere


how would i achieve this? or do I need to make another seperate row? seems dumb

I'm wanting to increment usernames in ONLY the lowercase a-z for example if a user enters "abc" it will automatically be given "abc1" and the next user if entering the same username will automatically be given "abc2", the next "abc3" and so on. The base login and register script I'm using can be found on http://evolt.org/node/60265/   The database.php and register.php pages are below, but excluding the amendments I am seeking.   I have created a MySQL database with 2 tables, 1 table named 'Users' with 3 columns named (1) 'userid' primary key, auto increment, (2) 'username' (3) 'password'.   The other table is named 'UserCount' with 2 columns named (1) 'username' (2) 'count'.

Can someone provide the PHP coding for the following process?   When a new user registers a new username firstly PHP to check the characters are in lowercase a-z only and no other characters, and reject if they do not match, then for PHP to check to see if that username exists in the 'UserCount' table.   If it doesn't exist, PHP to insert the new username into the 'username' column and also set the value of the 'count' column to 1.   If the username does exist, PHP to add that username to the 'username' column and increment the value of the 'count' column by 1. Then in the 'Users' table PHP to insert a record with 'Users.username = UserCount.username + count' and PHP to inform the new user of their complete username including the integer that has been added to their first entered username.

It would also help if I could be provided a link to a website on where I can better understand how to collate coding of this kind, coz I have tried to formulate this coding but as I'm playing around in the dark I have no idea if it is the right process in particular considering security factors.

database.php
Code: [Select]
<?php

/**
 * Connect to the mysql database.
 */
$conn = mysql_connect("localhost", "your_username", "your_password") or die(mysql_error());
mysql_select_db('your_database', $conn) or die(mysql_error());

?>
register.php

Code: [Select]
<?php
session_start(); 
include("database.php");

/**
* Returns true if the username has been taken
* by another user, false otherwise.
*/
function usernameTaken($username){
global $conn;
if(!get_magic_quotes_gpc()){
$username = addslashes($username);
}
$q = "select username from Users where username = '$username'";
$result = mysql_query($q,$conn);
return (mysql_numrows($result) > 0);
}

/**
* Inserts the given (username, password) pair
* into the database. Returns true on success,
* false otherwise.
*/
function addNewUser($username, $password){
global $conn;
$q = "INSERT INTO Users VALUES ('$username', '$password')";
return mysql_query($q,$conn);
}

/**
* Displays the appropriate message to the user
* after the registration attempt. It displays a 
* success or failure status depending on a
* session variable set during registration.
*/
function displayStatus(){
$uname = $_SESSION['reguname'];
if($_SESSION['regresult']){
?>

<h1>Registered!</h1>
<p>Thank you <b><?php echo $uname; ?></b>, your information has been added to the database, you may now <a href="main.php" title="Login">log in</a>.</p>

<?php
}
else{
?>

<h1>Registration Failed</h1>
<p>We're sorry, but an error has occurred and your registration for the username <b><?php echo $uname; ?></b>, could not be completed.<br>
Please try again at a later time.</p>

<?php
}
unset($_SESSION['reguname']);
unset($_SESSION['registered']);
unset($_SESSION['regresult']);
}

if(isset($_SESSION['registered'])){
/**
* This is the page that will be displayed after the
* registration has been attempted.
*/
?>

<html>
<title>Registration Page</title>
<body>

<?php displayStatus(); ?>

</body>
</html>

<?php
return;
}

/**
* Determines whether or not to show to sign-up form
* based on whether the form has been submitted, if it
* has, check the database for consistency and create
* the new account.
*/
if(isset($_POST['subjoin'])){
/* Make sure all fields were entered */
if(!$_POST['user'] || !$_POST['pass']){
die('You didn\'t fill in a required field.');
}

/* Spruce up username, check length */
$_POST['user'] = trim($_POST['user']);
if(strlen($_POST['user']) > 30){
die("Sorry, the username is longer than 30 characters, please shorten it.");
}

/* Check if username is already in use */
if(usernameTaken($_POST['user'])){
$use = $_POST['user'];
die("Sorry, the username: <strong>$use</strong> is already taken, please pick another one.");
}

/* Add the new account to the database */
$md5pass = md5($_POST['pass']);
$_SESSION['reguname'] = $_POST['user'];
$_SESSION['regresult'] = addNewUser($_POST['user'], $md5pass);
$_SESSION['registered'] = true;
echo "<meta http-equiv=\"Refresh\" content=\"0;url=$HTTP_SERVER_VARS[PHP_SELF]\">";
return;
}
else{
/**
* This is the page with the sign-up form, the names
* of the input fields are important and should not
* be changed.
*/
?>

<html>
<title>Registration Page</title>
<body>
<h1>Register</h1>
<form action="<?php echo $HTTP_SERVER_VARS['PHP_SELF']; ?>" method="post">
<table align="left" border="0" cellspacing="0" cellpadding="3">
<tr><td>Username:</td><td><input type="text" name="user" maxlength="30"></td></tr>
<tr><td>Password:</td><td><input type="password" name="pass" maxlength="30"></td></tr>
<tr><td colspan="2" align="right"><input type="submit" name="subjoin" value="Join!"></td></tr>
</table>
</form>
</body>
</html>


<?php
}
?>