PHP - Counting

Hiya peeps,

I have a mysql database with a record of all the images a customer uploads on my site, these images are displayed on there account. I can get this to work but the problem I'm facing is I need a minimum of 5 images displayed so if they only upload 2 images for instance I need to detect that and add my "No Image Uploaded" image. But if they have uploaded 5 or more I need to just let them be displayed without adding the "No Image Uploaded" picture.

Does anyone have any ideas as I'm very stuck!

Many thanks

James.

I know how to count the files:
<?php
$dir = $_SERVER[DOCUMENT_ROOT]."/api/sigs/cache/".$i[id]."/";
$files = scandir($dir);
$result = count($files);

printf("$result Signatures Generated");
?> 

But i'm trying to make it so it only counts the files that were modified recently (That Day).

Hello,
I'm creating a program that analyzes information that is exported by another program. That program exports it in this way:
Value1 Value2 Value3 Value4
Value1 Value2...

In order to insert them in the database, I first have to know how many lines are inserted. They get send through HTML post. I already tried:
$lines = explode("\n", $string);
$number_lines = count($lines);

But this always results in 1. How do I fix this?

Regards,
Chris

Hello

I have a table that inserts a new row with data when a member views a page.

I wish to count all the rows for each member, and then be able to show what the cuurent members "position" is eg. what members has the highest row count.

Example. counting the rows for member_A returns 1000 rows, the number of rows for member_B returns 1500 rows.

How can I display for member_A that he is in "second" place?

ok my code is below but i want to count how many $sname or ['member_name'] there is as if there is 4 or more i want it to add a marquee to it  have that sorted but im having trouble getting it to count can you help me?


$query = "SELECT * FROM `ibf_members` WHERE member_group_id = '4' or member_group_id = '6' or member_group_id = '17' or member_group_id = '18' or mgroup_others = '4' or mgroup_others = '6' or mgroup_others = '17' or mgroup_others = '18' "; 

$result99 = mysql_db_query("pbf99_backup", $query);
$staff1 = mysql_num_rows($result99);
if ($result99) 
{  
while ($r = mysql_fetch_array($result99)) { // Begin while 
$sid = $r["member_id"];
$smgid = $r["member_group_id"];


$query2 = "SELECT * FROM `ibf_sessions` WHERE member_id = '$sid'"; 
$result2 = mysql_db_query("pbf99_backup", $query2); 
if ($result2) 
{  
while ($r2 = mysql_fetch_array($result2)) { // Begin while 
$sname = $r2["member_name"]; 

$query3 = "SELECT * FROM `ibf_groups` where g_id = '$smgid'"; 
$result3 = mysql_db_query("pbf99_backup", $query3); 
if ($result3) 
{  
while ($r3 = mysql_fetch_array($result3)) { // Begin while 
$ssuffix = $r3["suffix"];
$sprefix = $r3["prefix"];

echo "<a href='$host$sid' target='_parent'>$sprefix$sname$ssuffix$stafff</a><br><br>";
}}}}}}

?>

I am getting the result I expected with ORDER BY/GROUP BY queries WITH a troubling EXCEPTION: the data is being IN ORDER from 0 thru 9, but 10 (which in this test sample is my LARGEST quantity) is being inserted between the ONE and 2 quantity. 
Not sure if this will occur with ALL teen values, as well as hundreds.
The column is a SMALLINT field (not sure if that makes a difference)>
Is there a solution for this situation?

I'm trying to get a total number from the db where the month is the same and the ip is different.
This is a stats script that someone else wrote, and I'm just trying to get a month-to-month total.

Right now, it pulls the information out and displays the month with how many different ips came that month, the problem is, it lists like this:

June - 41 - 41

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 9 - 9

June - 2 - 2

June - 2 - 2

June - 2 - 2

June - 1 - 1

June - 3 - 3

June - 2 - 2

June - 4 - 4

June - 1 - 1

June - 13 - 13

June - 154 - 154

what I need to do is grab all those numbers and give a total for that month, in this case, June.

This is my query
Code: [Select]
$query = "SELECT date, COUNT(referrer)'referrer' FROM app_analytics WHERE appid = $userid AND date BETWEEN '" .$y_month . "' AND '" . $t_month . "' GROUP BY referrer ORDER BY date";

Can anybody help out?

Thanks in advance

I have the following code. Basically I'm trying to count the amount of colours returned in the $colour variable. What I have is always returning 1, any ideas why?

Code: [Select]
$colour = $db->query("SELECT * FROM colours WHERE prod_id = ".$row['prod_id']." AND LENGTH(col_image_1) > 0 ORDER BY col_rank ASC LIMIT 1");
$colourcount = mysql_num_rows($colour);

if($db->numrows($colour)) {
$colour = $db->fetchrow($colour);
} else {
unset($colour);
}


Code: [Select]
echo $colourcount;

Hi Everyone,
I've been studying the topics at this site and others on ways to count uploaded images; and what I've tried hasn't worked. I have seen this question posed and answered many times and most of the answers are something akin to this:

        Code: [Select]
$count = count($_FILES['userfile'] ['name']);
echo "the number of photos is ".$count;
The explanation usually states that "count($_FILES['userfile'])" will simply count the number of elements in the array and return 5. But including ['name'] will return the number of files (images) uploaded. I will allow up to five photos to be uploaded (less is OK too) and want to count them in order to iterate through the proper number of loops to filter and process the photos. I've tested both of the above and get 5 (elements) when I count the ['userfile']; but get 0 (zero) when I test "['userfile'] ['name']". Here's the html code:

Code: [Select]
<!-- html here to input form data -->
<label></label><input type="hidden" name="MAX_FILE_SIZE" value="500000000" /><br />
<label for="userfile">Upload photo 1</label>
<input type="file" name="userfile1" id="userfile1" /><br />
<label for="userfile">Upload photo 2</label>
<input type="file" name="userfile2" id="userfile2" /><br />
<label for="userfile">Upload photo 3</label>
<input type="file" name="userfile3" id="userfile3" /><br />
<label for="userfile">Upload photo 4</label>
<input type="file" name="userfile4" id="userfile4" /><br />
<label for="userfile">Upload photo 5</label>
<input type="file" name="userfile5" id="userfile5" /><br /><br />
<label></label><input type="submit" name="userfile" value="Send Ad" />
</form>
I've been testing the uploads with two files (jpg) and have tried to come up with an alternative that can iterate through the file arrays and determine how many photos I have. The code I've been testing is as follows:

    Code: [Select]
$num = 1;
$count = 0;
while ($num <=5) {
  foreach ($_FILES['userfile'.$num] as $upload){
    if ($upload ['error'] != 4){
  }
$count ++;
  }
  $num++;
}
echo "the number of photos is ".$count;
I'm using "['error'] !=4" because some times people won't have 5 photos to upload. The result I get is 25 or 5 (files) x 5 (elements) for a total of 25. Does anyone know the proper way of doing this? Thanks for you input!
Cheers,
Rick

Hi all

What I am trying to achieve is a for each loop for the following output

Code: [Select]
Array ( [result] => success [source] => getDirectory [success] => Array ( [0] => /root/mc/world/data/ [1] => /root/mc/world/level.dat [2] => /root/mc/world/level.dat_old [3] => /root/mc/world/players/ [4] => /root/mc/world/players/herghost.dat [5] => /root/mc/world/region/ [6] => /root/mc/world/region/r.-1.0.mcr [7] => /root/mc/world/region/r.0.0.mcr [8] => /root/mc/world/session.lock [9] => /root/mc/world/uid.dat ) )

How would I go about saving each path from the [success] output?
Basically I wish to loop through the array and delete the files.

Many Thanks

15 rows selected from the table.
I want to randomly display an ad between them.

Here's the code:
Code: [Select]
$count = 1;   

(mysql select rows)

$number = rand (1,15);
if ($count == $number)
        {
echo 'ad code


                     ';
}
$count++;
I want the ad to be displayed only once and in the above code, depending on the generated number by rand() matching the $number the ads will be displayed more times.
How can I limit this only to one?

Hi guys,

How would I write a small script in php to count the unique values in the below array :

the below code if part of cubecart 3.20 shopping cart, I need to count the unique number of  Seller_ID fields within this array in the basket
to be able to calculate shipping according to the number of sellers. How would I to this ? please any help is appreciated.


Code: [Select]
if(isset($_GET['act']) && $_GET['act']=="step4"){
// set live vars for order inv and its the last step
$view_cart->assign("QUAN_DISABLED","disabled");
$view_cart->assign("TEXT_BOX_CLASS","textboxDisabled");
$basket = $cart->setVar($productId,"productId","invArray",$i);
$basket = $cart->setVar($product[0]['name'],"name","invArray",$i);
$basket = $cart->setVar($product[0]['productCode'],"productCode","invArray",$i);
$basket = $cart->setVar($plainOpts,"prodOptions","invArray",$i);
$basket = $cart->setVar(sprintf("%.2f",$price*$quantity),"price","invArray",$i);
$basket = $cart->setVar($quantity,"quantity","invArray",$i);
$basket = $cart->setVar($product[0]['digital'],"digital","invArray",$i);
$basket = $cart->setVar($product[0]['Prod_Seller'],"Prod_Seller","invArray",$i);
$basket = $cart->setVar($product[0]['Seller_ID'],"Seller_ID","invArray",$i);

}  else {
$basket = $cart->unsetVar("invArray");
}

Sorry if this is very basic.

We have our church membership lists in a MySQL database with the following fields:

Surname
Person1
Person1_Membership
Person2
Person2_Membership
...

The membership fields will either be empty or contain "Resident" or "Non-Resident". The reason for two columns is that some couples may only have one partner as a member.

I am trying (without success) to find a way of getting a total (to display on a web page) of how many "Resident" and how many "Non-Resident" members we have. In other words, I'm trying to get a sum of the total number of times "Resident" and and total number of times "Non-Resident" appears in the two columns combined.

(hope that makes sense!)

I would appreciate any pointers from anyone who has managed to do this, or something similar, already.

Many thanks for the help

I am using this code to search my database plus it has a paginate which all works fine. The problem is i have a row count which for some reason counts all records in the database and not just the ones returned from the search query. How to i fix this.

Code: [Select]

$term = $_GET['term'];
$cat = $_GET['cat'];

//max display per page
$per_page = 4;

//get start variable
$start = $_GET['start'];

// cout records
$record_count = mysql_num_rows(mysql_query("SELECT * FROM Table WHERE productname like '%$term%' and category like '%$cat%'"));

//count max pages
$max_pages = $record_count / $per_page; //may count as decimal

if (!$start)
      $start =0;
   

$sql="SELECT * FROM table WHERE productname like '%$term%' and category like '%$cat%' LIMIT $start, $per_page";
$result = mysql_query($sql);

$sql = mysql_query ("SELECT COUNT(*) FROM table");


list($number) = mysql_fetch_row($sql);

if (!mysql_num_rows($result)) { 
die("NO RECORD FOUND") ;
exit;
} else {
echo "Your Search for: <b>$term</b> in <b>$cat</b><br><br>";
}
while ($row = mysql_fetch_array($result)){
$num_rows = mysql_num_rows($number);

if (!$i++) echo "Total records $number";

?>

<br />
<br /> 
<?php echo 'ID: '.$row['id'];  ?>  <br /> 
<?php echo '<br/> Product Name: '.$row['productname'];?>  <br /> 
<?php echo '<br/> Price: '.$row['price']; ?><br /> 
<?php echo '<br/> category: '.$row['category']; ?>
 
<br /> 
<?php
 }
?>

<?php

 //setup prev and next variables  
$prev = $start - $per_page;
 $next = $start + $per_page;
 
 // show prev button   
 if(!($start<=0))
  echo " <a href='ttr.php?start=$prev'>Prev&nbsp;</a>";

//set var for first page
$i=1;

for ($x=0;$x<$record_count;$x=$x+$per_page)
{
 if ($start!=$x)
   echo "<a href='ttr.php?start=$x'>$i</a> ";
   else
   echo "<a href='ttr.php?start=$x'><b>$i</b></a> ";
   $i++;
}
 
 //show next button 
 
 if (!($start>=$record_count-$per_page))
  echo " <a href='ttr.php?start=$next'>Next</a>";
   
?>

How do I do this?

It only does the first nine records and wont cycle through the many records in the second dimension.

Thanks.

         // External Loop is 1 - 9
         // Internal Loop is 0 - whatever it is
   
         //$muarray_s[0]                        = $facility_id;
         //$muarray_d[$external_loop][$interal_loop]   = $objfields['139339_date'];
         //$muarray_t[$external_loop][$interal_loop]   = $objfields['139339_time'];
         //$muarray_i[$external_loop][$interal_loop]   = $objfields['139339_main_id'];
         
         //$array_of_mu[$external_loop][$interal_loop]    = $checklist_item_disc;
         
         echo "Begin Draw Runway Image Function <br>";
         echo "Establish Array Looping Procedure";
         
         for ($j=0; $j<10; $j=$j+1) {
               // External Loop
               // This is actually the Condition not the mu
               
               for ($k=0; $k<count($array_of_mu); $k=$k+1) {
                     // Internal Loop
                     // This is the Mu Value;
                     echo "Mu Value is ".$array_of_mu[$j][$k]."<br>";
               }
         }