help with count

wmguk · August 24, 2007

hey,

another daft question, I'm using this:

<?php
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/$login"; 
$images = count(glob($dir_path . "*"));
?>

now,

<?php
include "scripts/connection.php"; 
if (!$con) 
{ 
  die( 'Could not connect: ' . mysql_error() ); 
   }
mysql_select_db($db, $con); 

$result = mysql_query("SELECT * FROM album WHERE active = 'yes'");
?>

how can i get it to count the files in each folder, ie

<?php 
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/client1";
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/client2";
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/client3";
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/client4";
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/client5"; [/code

any ideas?

teng84 · August 24, 2007

maybe

http://www.php.net/manual/en/function.glob.php

wmguk · August 24, 2007

okies, i had a look, but cannot see anything that helps?

this is my code

      <?php 
include "scripts/connection.php"; 
if (!$con) 
{ 
  die( 'Could not connect: ' . mysql_error() ); 
   }
mysql_select_db($db, $con); 

$result = mysql_query("SELECT * FROM album WHERE active = 'yes'");

$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/". $row['login']; ""; 
$images = count(glob($dir_path . "*")); 

echo "<p><img src='images/heading/albumtracker.gif'></p><table border='1' bordercolor='cccccc' width='560' cellpadding='5' cellspacing='0'> 
<tr> 
<th align='center' bgcolor='#CCCCCC' class='main'><font color = '000000'>Album Title</font></th> 
<th align='center' width='50' bgcolor='#CCCCCC' class='main'><font color = '000000'>Images</font></th> 
<th align='center' width='50' bgcolor='#CCCCCC' class='main'><font color = '000000'>Creator</font></th> 
<th align='center' width='50' bgcolor='#CCCCCC' class='main'><font color = '000000'>Access</font></th>
<th colspan='2' align='center' bgcolor='#CCCCCC' class='main'><font color = '000000'>Management</font></th> 
</tr>"; 

while($row = mysql_fetch_array($result)) 
{ 
$groom_firstname = $row['groom_firstname']; 
$ceremony = $row['ceremony']; 

if ($ceremony == 'Wedding')
{
$editpage = 'editw.php';
}
elseif ($ceremony == 'Event')
{
$editpage = 'edite.php';
}
elseif ($ceremony =='Portrait')
{
$editpage = 'editp.php';
}
else
{
$editpage = 'editcp.php';
}
  echo "<tr>"; 
  
  if ($groom_firstname == 'X') 
{  
  echo "<td class='main'> The " . $row['ceremony'] . " of " . $row['bride_firstname'] . "</td>";
} 
  else
{
  echo "<td class='main'> The " . $row['ceremony'] . " of " . $row['bride_firstname'] . " " . $row['bride_surname'] . " and " . $row['groom_firstname'] . " " . $row['groom_surname'] . "</td>"; 
}

  echo "<td class='main' align='center'>$images</td>"; 
  echo "<td class='main' align='center'>" . $row['creator'] . "</td>";
  echo "<td class='main' align='center'>" . $row['counters'] . "</td>";
  echo "<td width='100' align='center'><form name='killlive' action='scripts/livestop.php' method='get'>
  		<input type='hidden' name='login' value='" . $row['login'] . "'><input type='submit' class='main' name='Submit' value='De-Activate' onclick='return CheckForm()' /></form></td>";
    echo "<td width='30'><form name='editdetails' action='editpage/";
  echo "$editpage" ;
  echo "' method='POST'><input type='hidden' name='login' value='" . $row['login'] . "'><input type='submit' class='main' name='Submit' value='Edit' /></form></td>";   
  echo "</tr>"; 

} 

echo "</table>"; 
?>

still just counts the actual folders in /clients - not the individual files within $login ....

trq · August 24, 2007

You want the total of all files?

<?php

  $cnt = 0;
  for ($i=1;$i<=5;$i++) {
    $cnt += count(glob("/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/client{$i}/*"));
  }

  echo $cnt;

?>

wmguk · August 24, 2007

What im doing is in my database, say at the moment there are 3 records. client1, client2 and client3, my script creates a folder called the same as the login name ie, client1, client2 and client3. each of the folders could have an unknown amount of images in each folder, so my end result needs to be

client1 512 images

client2 21 images

client3 4578 images

at the moment, my page, shows the rows with all the info for the clients, but i cant seem to get it to show the number of individual images for each client

trq · August 24, 2007

Try changing...

$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/". $row['login']; ""; 
$images = count(glob($dir_path . "*"));

to...

$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/". $row['login']; ""; 
$images = count(glob($dir_path . "/*"));

wmguk · August 24, 2007

nope, still displaying 0

i wondered if i would be better doing it, when the album is set active, its runs a simple script to set active = yes,

<?php
//Get the data to update

 $login = $_GET['login'];

 //image details
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/$login"; 
$image_no = count(glob($dir_path . "*"));

// Make Connection
include 'connection.php';
if (!$con)
 {
 die('Could not connect: ' . mysql_error() );
 }
 mysql_select_db($db, $con);

//Run the update query
$sql = "UPDATE album SET active = 'yes', image_no = '$image_no' WHERE login = '$login'";

 mysql_query( $sql , $con ) or die( "<strong>Query Error</strong>: " . mysql_error() . "<br><strong>Query</strong>: $sql<br><br>" ); ?>

the only issue is these is something wrong because the script is failing, must be a php error, but im lost.. and its late, and nearly time for sleep

trq · August 24, 2007

You didn't make my changes?

wmguk · August 24, 2007

yes sorry i did, but it didnt make any difference, still displays 0

wmguk · August 24, 2007

i just made a real simple script

<?php
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/'$login'"; 
$images = count(glob($dir_path . "/*"));

echo $dir_path ;
echo $images ;
?>

i get

/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/client1

0

wmguk · August 24, 2007

got it, i had 'login'

<?php
//Get the data to update

$login = $_GET['login'];

//image details
$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/$login"; 
$images = count(glob($dir_path . "/*"));

echo $dir_path ;
echo $images ;

// Make Connection
include 'connection.php';
if (!$con)
{
die('Could not connect: ' . mysql_error() );
}
mysql_select_db($db, $con);

//Run the update query
$sql = "UPDATE album SET active = 'yes', image_no = '$images' WHERE login = '$login'";

mysql_query( $sql , $con ) or die( "<strong>Query Error</strong>: " . mysql_error() . "<br><strong>Query</strong>: $sql<br><br>" ); 
?>

wmguk · August 24, 2007

aggghh,

the email script has fallen over now,

<?php

if (!$con) 
{ 
die( 'Could not connect: ' . mysql_error() ); 
}
mysql_select_db($db, $con); 

$result = mysql_query("SELECT * FROM album WHERE login = '$login'") or die(mysql_error());

while($row = mysql_fetch_array($result)) 
{ 
$email = $row['email']; 
$groom_firstname = $row['groom_firstname']; 
$groom_surname = $row['groom_surname']; 
$bride_firstname = $row['bride_firstname']; 
$bride_surname = $row['bride_surname']; 

if ($groom_firstname == 'X') 
{  
 $title = $row['bride_firstname'] . ;
} 
 else
{
 $title = $row['bride_firstname'] . '  and ' . $row['groom_firstname'] . ;
}
?><html><link href="http://demo.website.co.uk/styles.css" rel="stylesheet" type="text/css" />
<?php
$mime_boundary = "IW Photo".md5(time());

# -=-=-=- MAIL HEADERS

$to = "$email";
$subject = "Your album is now live";

$headers = "From: xxx<info@webiste.co.uk>\n";
$headers .= "Reply-To: xxx<info@webiste.co.uk>\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Content-Type: multipart/alternative; boundary=\"$mime_boundary\"\n";

# -=-=-=- HTML EMAIL PART

$message .= "--$mime_boundary\n";
$message .= "Content-Type: text/html; charset=UTF-8\n";
$message .= "Content-Transfer-Encoding: 8bit\n\n";

$message .= "<html>\n";
$message .= "<body style=\"font-family:Verdana, Verdana, Geneva, sans-serif; font-size:8px; color:#666666;\">\n"; 
$message .= "<table width='800' border='0' align='center' cellpadding='0' cellspacing='0'><tr><td height='80' align='left' valign='top' background='http://demo.website.co.uk/images/top.jpg'><p> </p></td></tr><tr><td align='left' valign='top' background='http://demo.website.co.uk/images/middle.jpg'>";
$message .= "<table width='800' border='0' cellspacing='0' cellpadding='0'><tr><td width='20'> </td>";
$message .= "<td class='main'><p>Dear $title,";
$message .= "<p>We are pleased to announce that your album has been made live now.</p>";
$message .= "<p>Please click <a href='http://demo.website.co.uk/emailgallery.php?login=$login'>HERE</a> to view your album. </p>";
$message .= "<p>You can also now tell all your family and friends about your new album by clicking <a href='http://demo.website.co.uk/tellfriend.php?login=$login'>HERE.</a> </p></td><td width='20'> </td></tr></table></td></tr>";
$message .= "<tr><td align='left' valign='top' background='http://demo.website.co.uk/images/bottom.jpg'> </td></tr></table>";
$message .= "</body>\n";
$message .= "</html>\n";

# -=-=-=- FINAL BOUNDARY

$message .= "--$mime_boundary--\n\n";

# -=-=-=- SEND MAIL

$mail_sent = @mail( $to, $subject, $message, $headers );
}

//Close the connection
 mysql_close($con);

?>

its on the same script page as the count but its a php error. it must be...

trq · August 24, 2007

What exactly does fallen over meen?

wmguk · August 24, 2007

sorry, im just being daft now...

i knew it would have been a script error...

i'm just thinking about it, i still need my original problem sorted because, i need to know how many images are in each folder before i use the submit button, so, how do i get it to provide the amount of images in each folder using

<?php

//image details  - This is how it works on the other script... but that is where i specify $login but im not doing that now

$dir_path = "/var/www/vhosts/website.co.uk/subdomains/demo/httpdocs/clients/$login"; 
$images = count(glob($dir_path . "/*"));

//start connections
if (!$con) 
{ 
die( 'Could not connect: ' . mysql_error() ); 
}
mysql_select_db($db, $con); 

$result2 = mysql_query("SELECT * FROM album WHERE active = 'no'");

echo "<p><img src='images/heading/albumtrackerpend.gif'></p><table border='1' width='560' bordercolor='cccccc' cellpadding='5' cellspacing='0'> 
<tr> 
<th align='center' bgcolor='#CCCCCC' class='main'><font color = '000000'>Album Title</font></th> 
<th align='center' width='50' bgcolor='#CCCCCC' class='main'><font color = '000000'>Images</font></th> 
</tr>"; 

while($row = mysql_fetch_array($result2)) 
{ 
$groom_firstname = $row['groom_firstname'];
$ceremony = $row['ceremony']; 

echo "<tr>"; 

if ($groom_firstname == 'X') 
{
echo "<td class='main'> The " . $row['ceremony'] . " of " . $row['bride_firstname'] . "</td>";
} 
else
{
echo "<td class='main'> The " . $row['ceremony'] . " of " . $row['bride_firstname'] . " " . $row['bride_surname'] . " and " . $row['groom_firstname'] . " " . $row['groom_surname'] . "</td>"; 
}
echo "<td class='main' align='center'>$images</td>"; 
echo "<td class='main' align='center'>" . $row['creator'] . "</td>";

} 

echo "</table>"; 

mysql_close($con); 

?>

wmguk · August 24, 2007

any ideas?

Sign In

help with count

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information