PHP - Randomize The Order Of An Array After X Amount Of Time

My DB is holding time as "11:00 AM" "10:00 AM" ect...

Is there a way to convert these to time() after I have queried the DB for results?


<?php

connect();
$query = "SELECT * FROM party WHERE year(DOP) = '2011' order by PTIMES asc";
$qt=mysql_query($query);
echo mysql_error();
while($nt=mysql_fetch_array($qt)){

echo "
<tr height='30'> 
<td id='label'>".$nt['NOC']."</td>
<td id='labeloff'>".$nt['CFN']." ".$nt['CLN']."</td>
<td id='labeloff'>".$nt['type']."</td>
<td id='label'>".birthday($nt['DOB'])."</td>
<td id='label'>$DOP</td>
<td id='labeloff'>".$nt['PTIME']."</td>
<td id='labeloff'>".$nt['act1']."</td>
<td id='labeloff'>".$nt['act2']."</td>
<td id='label'>".$nt['pizza']."</td>
<td id='label'>".$nt['fc']."</td>
</tr>
";
}free($qt);

?>


Thank you.

Heres what i got...

function printLB1 (){
$result = mysql_query("SELECT * FROM leaderboards ORDER BY CollegeFootballPoints DESC");
while ($row = mysql_fetch_object($result)) {
    $leaderboard[] =  $row->Username;
$leaderboardPoints[] = $row->CollegeFootballPoints;
}
$num = mysql_num_rows($reault);

//I know from here to ...................  needs to be in a var or echo or something.

  <tr>
    <td>1.</td> //This will auto increment too like i++ but i cna do that myself!
    <td>echo $leaderboard;</td>
    <td>echo $leaderboardPoints;</td>
  </tr>

//Here.........................................................

}

I need to pull a table row per user. But i want to somehow do it once in a function and then ill echo the function into a table after the php stuff is done.

Like i want to pull every a table row per user in the function. then display the function below that way i don't have to write a whole extra query and table row per person.

If you understand please help if not please let me know where i can explain more.

Thanks

I have a table in my database which stores lot of file names & file path. iam currently listing the files on the basis of its uploaded date (stored in databse) but  I want to list it on the basis of its file modification time.
How i can do it ??
my current sql statement is

Code: [Select]
$sql = mysql_query("SELECT * FROM `files` WHERE `cid` = '$types' ORDER BY `uploaded` DESC LIMIT $start,$limit");

anyone can help me ??

Hello..
I'm a somewhat beginner in php, but i decided to create my own basic forums system with a content managing system. Right now I'm trying to figure out how to make a thread link be at the top of the list for the forum display page, when someone posts a response or creates a new thread. HELP MUCH APPRECIATED 

Hi,

I'm inserting hours and minutes per user into a database where they have their own fields.
(userid, hours, mins)

I've a small issue when displaying the data.

When I run my query I sum the total hours and minutes per user which results in data such as the following

userid1 - 2  hours 15 mins
userid2 - 1 hour 100 mins

The query orders by hours and then mins desc

When I'm displaying the data (as I'm looping through the results array) I perform a calculation to convert the mins to hours so it now reads

userid1 - 2 hours 15 mins
userid2 - 2 hours 40 mins

so the webpage displays userid1 first when i want userid2 to be the first record displayed (Hours desc)

Can anyone recommend a solution to this ?
Will I need to create another table and update it as hours and minutes are being entered and display results from that table instead ?
Can I order the data after I carry out the mins to hours calculation ?

many thanks in advance for any suggestions....

tmfl

Hello all,

I need to make a rotating banner system for a client. They want about 5 banners to rotate with Javascript. However they want the visitor to sort of step through each one on each refresh.

So if I have 5 banners and I go to the site, I see banner 1 and then the javascript rotates through each one.

When I go back to the site, they want it to start with banner 2 and then the javascript will rotate through each one. Then on and on. Go back and see banner 3, then step through again.

I have a nice Javascript image slider I'd like to use. It basically just requires the images in order. Like:

<img src="1.jpg"/>
<img src="2.jpg"/>
<img src="3.jpg"/>
<img src="4.jpg"/>
<img src="5.jpg"/>

I've thought about it and I think the best way to do this would just be using PHP and a cookie. So when the viewer first goes to the site, PHP checks for the cookie. If it exists, it pulls the starting image #. If it doesn't, it starts at 0 and sets the cookie.

As for the images part, I figured an associate array would work well. The key would be what the cookie logic is based on, and then the image HTML would be in the array.

So you visit the site without a cookie it would be...

0 => <img src="1.jpg"/>
1 => <img src="2.jpg"/>
2 => <img src="3.jpg"/>
3 => <img src="4.jpg"/>
4 => <img src="5.jpg"/>

Then when you go back to the site, I need the array to be re-ordered like this:

0 => <img src="2.jpg"/>
1 => <img src="3.jpg"/>
2 => <img src="4.jpg"/>
3 => <img src="5.jpg"/>
4 => <img src="1.jpg"/>

What's the best way to go about this array logic? My experience with manipulating data inside arrays is rather limited. Basically I need it to say "Start with key # and then reorder array based on that"

Hi guys,

I'm trying to sort an array. The array has information about listings. ID, name, info etc.

An unrelated set of data also contains the listing ID's and I have made a function to sort this array and show an new order for the ID's. I now need to sort the original array by this new ID order...

This snippet shows that the original listings array can be sorted by link_id:
sort($this->links, $this->link->link_id); //This works. It sorts links by link ID!

In a foeach loop I have created this:
$sleeps_array[] = array("ID" => $link->link_id, "Sleeps" => $sleeps); // Makes an array of arrays of a custom field with listing ID.

It makes this:
array ( 0 => array ( 'ID' => '9', 'Sleeps' => '2', ), 1 => array ( 'ID' => '3', 'Sleeps' => '4', ), 2 => array ( 'ID' => '6', 'Sleeps' => '6', ), )

I can then sort this array of arrays with this function:

function compare_sleeps($a, $b){
return strnatcmp($a['Sleeps'], $b['Sleeps']);
} # sort alphabetically by name
usort($sleeps_array, 'compare_sleeps');

It then gives me a sorted array according to "Sleeps" (as in, the number of people a property can cater for). It has the correct order of ID to then output but how do I organise the original array by ID with this new array?

Sounds complicated, I hope you got that!

Cheers, RJP1

Hi, I've been trying to re-order an array and I can't seem to even do it let alone neatly. I've ran out of time and would appreciate any help!


$array = array(
  '0' => array(
    'filepath' => 'files/image_site1.png',
    'title' => 'Website',
  ),
  '1' => array(
    'filepath' => 'files/image_id.png',
    'title' => 'Identitity',
  ),
  '2' => array(
    'filepath' => 'files/image_site2.png',
    'title' => 'Website',
  )
)

I'm looking to re-order the arrays within the parent array depending on whether the 'filepath's contain a sub string of '_id' or '_site'.

I've been using:
$type = '_site';
foreach ($array as $item){
  if (preg_match("/$type/i", $item['filename'])){
    //add this $item to the top of array, somehow...
  }
}

So with $type set to '_site', I'd like to re-arrange the array so both arrays containing _site1.png and _site2.png appear at the top of the parent array. I.e:
$array('0' = array(...), '2' => array(...), '1' => array(...));

I hope I've explained it well enough.

Thanks,

i have checkboxes in a form with the name="array[]" and in the php i use the implode function to separate all the values of all that was checked with a comma....my question is... how can i set the order of the array a certain way... i'd like to ultimately have a field where if you check a box you can enter into the field 1, 2, 3, 4 and so on and when you submit the form it will set the order according to what was entered

thanks

Hi, I have this php code to display the url of the files and it works fine, it just has a weird order when it is echoed out.
Here is the code: Code: [Select]
<?php
$date = date("Y-m-d");
$picarray = array();
        $handle = opendir ('pqimages/'.$date.'/');
        while (false !== ($file = readdir($handle))) {
            if($file != "." && $file != "..") {
                $picarray[] = "http://randomaydesigns.com/pqimages/".$date."/".$file."";
            }
        }
$json_array = json_encode($picarray); 
echo $json_array;  
?>There are three files in the folder and they are 33,34,35.jpg it displays them like 33,35,34.jpg

Any Recommendations?
Thanks,
GEORGE

For example for my Skill Tree:

array (size=9)
0 =>
array (size=2)
'Skill_Id' => string '1' (length=1)
'Skill_Points' => string '0' (length=1)
1 =>
array (size=2)
'Skill_Id' => string '2' (length=1)
'Skill_Points' => string '0' (length=1)
2 =>
array (size=2)
'Skill_Id' => string '3' (length=1)
'Skill_Points' => string '0' (length=1)
3 =>
array (size=2)
'Skill_Id' => string '4' (length=1)
'Skill_Points' => string '1' (length=1)
4 =>
array (size=2)
'Skill_Id' => string '5' (length=1)
'Skill_Points' => string '1' (length=1)
5 =>
array (size=2)
'Skill_Id' => string '6' (length=1)
'Skill_Points' => string '1' (length=1)
6 =>
array (size=2)
'Skill_Id' => string '7' (length=1)
'Skill_Points' => string '0' (length=1)
7 =>
array (size=2)
'Skill_Id' => string '8' (length=1)
'Skill_Points' => string '1' (length=1)
8 =>
array (size=2)
'Skill_Id' => string '9' (length=1)

For the Skill_Id, it must be in order when checking server side.  1 through 9. (or 9 can be changed by me whenever).   So, I have:   $skillrange = range(1,$amountofskills);   Which will output:

array (size=9)
0 => int 1
1 => int 2
2 => int 3
3 => int 4
4 => int 5
5 => int 6
6 => int 7
7 => int 8
8 => int 9

But, how do I check this order from my original array? I need to check My Skill_ID values in order from my original array and make sure they are 1 through 9. (So a user cannot tamper the data)   Edit: I've come up with this solution since making this thread:  

$array1 = $skillidarray;
$array2 = $skillrange;
if (!empty(array_diff_assoc($array1, $array2))){
echo "Your skill tree data is out of order, please report this to an administrator.";
}

  Something like this would work right?
Edited by Monkuar, 11 October 2014 - 03:59 PM.

 

the interface explains everything

Code: [Select]
#page1.html

<html>
  <head>



  </head>
  <body>


  <table border='0' width='50%' cellspacing='0' cellpadding='0' >
  <form name=form1 method=post  action="page2.php">

<?PHP

$postData[] = array();
$postData[0] = '9';
$postData[1] = '8';
$postData[2] = '7';
$postData[3] = '6';
 
?>
 
 
  <tr>
  <td><b>Choose your order</b></td>
  <td>&nbsp;</td>
  <td>
  <input type=checkbox name=scripts[] value='<?PHP $postData[0]; ?>'>pasta <br>
  <input type=checkbox name=scripts[] value='<?PHP $postData[1]; ?>'>burger <br>
  <input type=checkbox name=scripts[] value='<?PHP $postData[2]; ?>'>fries <br>
  <input type=checkbox name=scripts[] value='<?PHP $postData[3]; ?>'>chili dog <br>
  <br>
  </td>
  </tr>
 
  <tr><td align=center >
  <input type=submit value=Submit>
  <input type=reset value=Reset></td></tr>
 
  </form>
  </table>


  </body>
</html>

Code: [Select]
#page2.php

<?PHP


if ($_SERVER['REQUEST_METHOD'] == 'POST') {

if (isset($_POST['scripts'])) {
 
$cb = $_POST['scripts'];
$numRows = count($cb);

print "you have chosen the following order numbers:";
for($i=0; $i<$numRows; $i++){
print $cb[$i] . "<br>";
}
 

 
}
else{
print "you have'nt checked anything!";
}




}


?>
What do? 

I have this code
Code: [Select]
$nArr = array('A', 'B', 'C', 'D', 'E', 'F');

$counter = 3;
while ($counter > 0) {
    $chunkedValues[$counter][0] = 1;
    for ($j = 0 ; $j < $counter ; $j++) {
        $chunkedValues[$counter][$j + 1] = $nArr[$j];
    }
    $nArr = array_slice($nArr, $counter--);
}
var_dump($chunkedValues);
that outputs:
Code: [Select]
array
  3 =>
    array
      0 => int 1
      1 => string 'A' (length=1)
      2 => string 'B' (length=1)
      3 => string 'C' (length=1)
  2 =>
    array
      0 => int 1
      1 => string 'D' (length=1)
      2 => string 'E' (length=1)
  1 =>
    array
      0 => int 1
      1 => string 'F' (length=1)
But i need this index structu
Code: [Select]
array
  0 =>
    array
      0 => int 1
      1 => string 'A' (length=1)
      2 => string 'B' (length=1)
      3 => string 'C' (length=1)
  1 =>
    array
      1 => int 1
      2 => string 'D' (length=1)
      3 => string 'E' (length=1)
  2 =>
    array
      2 => int 1
      3 => string 'F' (length=1)
I want to avoid loops with ceil.

Any idea? thanks for your time.

I wish to order my results by its occurrence inside the $status array.

Basically all of the results with the status 'New' are to be listed first, then the results with the status Today, Tomorrow, Soon and so on.

Is this possible, or is there alternatively a different approach to ordering my results how I desire?

Code: [Select]
$status = array('New', 'Today', 'Tomorrow', 'Soon', 'Future', 'Complete');

$display->get_results("SELECT * FROM todo ORDER by status DESC");

I wish to get only the last part of each array 'g'
And then show non duplicated 'g'
but in the same order that it was in the original array.


Code: [Select]
<?php
$formarray = array(
'name' => array(
      'i1'=>      array('a'=>'a1', 'b'=>'b1', 'c'=>'c1', 'd'=>'d1', 'e'=>'e1', 'f'=>'f1', 'g'=>'g1'),
      'i2'=>      array('a'=>'a2', 'b'=>'b2', 'c'=>'c2', 'd'=>'d2', 'e'=>'e2', 'f'=>'f2', 'g'=>'g2'),
      'i3'=>      array('a'=>'a3', 'b'=>'b3', 'c'=>'c3', 'd'=>'d3', 'e'=>'e3', 'f'=>'f3', 'g'=>'g3'),
      'i4'=>      array('a'=>'a4', 'b'=>'b4', 'c'=>'c4', 'd'=>'d4', 'e'=>'e4', 'f'=>'f4', 'g'=>'g4'),
      )
);

foreach ($formarray as $newarray => $a) {
?><strong><?=$newarray;?></strong><br><?
  foreach ($a as $key => $k) {
?>"<?=$key;?>", <?
foreach ($k as $b) {
//if ($k['DBfield'] != "") {
?>"<?=$b;?>", <?
//}
}
?><br><?
} //end of second foreach
?><br><br><br><?
} //end of first foreach
?>