PHP - Count Number Of Files..

Hi all,

I am trying to use the Mysql COUNT function to count the number of records in a database where the manufacturer is the same and then generate a list of all manufacturers along with a number of associated records next to their name.

I have got the script below to show the manufacturer in a fetch array but I can not get the number next to the manufacturer to work.

A push in the right direction would be appreciated thanks.


<?php 
include("cxn.php");

$query = "SELECT manufacturer FROM sales"; 
$result = mysqli_query($cxn,$query) or die(mysqli_error());
 
?>
<select name="manufacturer" id="manufacturer">
<option value="" selected="selected">Select a Manufacturer..</option>";
<?php 
while($row = mysqli_fetch_array($result)){
$query1 = "SELECT manufacturer COUNT(*) FROM sales WHERE manufacturer='$row[manufacturer]'";  // TRYING TO COUNT THE ROWS HERE
$result1 = mysqli_query($cxn,$query1) or die (mysqli_error());

while($row1 = mysqli_fetch_array($result1)){
echo "<option value=\"202\">".$row['manufacturer'] ."[". $row1['COUNT(manufacturer)']."]</option>"; // SHOW NUMBER HERE
}
}
?>

Folks,

Having trouble here. Forgot how you use the COUNT. Not interested in the num_rows due to it being slow compared to COUNT.

I have users table like this:

id|username|sponsor_username

0|barand|requinix

1|phpsane|alison

2|mickey_mouse|requinix

Now, I want to check if a sponsor username exists or not. Such as does the entry "requinix" exists or not in one of the rows in the "sponsor_username" column.

In our example it does twice and so the variable $sponsor_username_count should hold the value "2". Else hold "0".

I get error:

Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1 

 

My code:

	$stmt_1 = mysqli_prepare($conn,"SELECT COUNT(sponsor_username) from users = ?"); 
            mysqli_stmt_bind_param($stmt_1,'s',$sponsor_username_count); 
            mysqli_stmt_execute($stmt_1); 
            
            //Show error if 'users' tbl was not successfully queried". 
            if (!$stmt_1) 
            { 
                echo "ERROR 1: Sorry! Our system is currently experiencing a problem loading this page!"; 
                exit(); 
            } 
            else 
            { 
                mysqli_stmt_bind_result($stmt_1,$sponsor_username_count);     
                mysqli_stmt_fetch($stmt_1); 
                mysqli_stmt_close($stmt_1); 
                
                //Check if Sponsor Username in Url ($_GET) is already registered or not. If not then show "Invalid Url" or Link message. 
                if ($sponsor_username_count < 1) 
                { 
                    echo "<b>Invalid Url or Link!<br> Invalid Sponsor: \"$sponsor_username\"!</b><?php "; 
                    exit(); 
                } 
            } 
	

I have a html table displaying data from mysql database. I can count rows properly with mysql_num_rows but is there a way to echo which row number it is. What I want to do is count the rows ordered by cities and echo row number. Thanks for any help.

Hello,

I am trying to create article directory for learning PHP MySql and i want to write a script for recording number of views for an article and store it in Database. Can anyone please direct me to a nice simple tutorial or help me with the steps or algorithm?

Suppose the link for an article is http://www.domain.com/article.php?id=123
Do i need to put extra variables and create a tracking PHP file for it?

i HAVE FOLLOWING VALUES IN FEED TABLE   a1a    a1b    a1c    a1d ...... 7         8        7         7 8         9        8         8 9         7        7         8 7        8        10        9 6         4        6         7 7        8         8        5 9        7         7        6   This in an array ( select a1a,a1b,a1c,a1d from feed where .....)   1) I want to know how many times each values has occured in the array ( eg:  7 occured 10 times, 8 occured 8 times)   2) How many 7's, 8's, 9's  are there in a1a,   howmany .....in a1b   Number of times each values occured OVERALL in array   as  well as also under each head   Please help

I have a database lets say punch_log

The data in the table looks like:
---------------------------------------------------------------------------
|punch_log_id |  user_id | punch_id |   punch_time           |
---------------------------------------------------------------------------
|   10010         |  21         |   1       | 2010-11-10 15:04:59|
|   10011         |  21         |       2       | 2010-11-10 15:50:05|
|   10010         |  21         |   1       | 2010-11-11 15:04:59|
|   10011         |  21         |       2       | 2010-11-11 15:50:05|
|   10010         |  21         |   1       | 2010-11-12 15:04:59|
|   10011         |  21         |       2       | 2010-11-12 15:50:05|
|   10010         |  21         |   1       | 2010-11-13 15:04:59|
|   10011         |  21         |       2       | 2010-11-13 15:50:05|
|   10010         |  21         |   1       | 2010-11-14 15:04:59|
|   10011         |  21         |       2       | 2010-11-14 15:50:05|
|   10010         |  21         |   1       | 2010-11-14 15:50:59|  <-- this is why i need this.
|   10011         |  21         |       2       | 2010-11-14 15:55:05|  <-- this is why i need this.
----------------------------------------------------------------------------

Im currently using :

$kust  = $_POST['AKuu'];
$kuni3 = $_POST['LKuu'];
$valitudtootaja   = $_POST['TNimi'];


mysql_select_db($database, $con);
$query2 = "SELECT *, SUM(punch_id) FROM punch_log WHERE user_id = '".$valitudtootaja."' AND punch_time   BETWEEN '$kust' AND '$kuni3' AND punch_id ='1' ";   
$result2 = mysql_query($query2) or die(mysql_error());
while($row = mysql_fetch_array($result2)){
   $X = $row['SUM(punch_id)'];

When using the current query im getting

Workers days at work = 6
it should be 5 but thats why i need some solution to group dates and then sum them.

Does anybody have any ideas?

Hi guys

I'm kinda stuck..so hopefully you guys can lend me a hand

I've got an array containing date elements ("Y-m-d")...

I'm trying to output some data into googlecharts..so i need to count how many elements that are in the array with todays date -1 day, todays date-2 days...todays date -3days etc... Up until a set number of days (for example 7 days, 14 days etc)..

Any advice on how to go about to achieve this?

Hi everyone,

Like the title says I need to count the amount of 1's in a column but I can't figure out how.

Gr and thanx already
Ryflex

i need to count the number of image files on a remote server not in my network.  ive come across a suggestion to use

@getimagesize($img_url)

the above works but is really slow.  anyone able to suggest a better method?

Displaying the number of files in a directory and its subdirectorys


<?php

$path = './images_cache';
if ($handle = opendir($path)) {
     while (false !== ($file = readdir($handle))) {
          if ($file != "." && $file != "..") {
          $fName = $file;
          $file = $path.'/'.$file;
          if(is_file($file)) $numfile++;
          if(is_dir($file)) $numdir++;
          };
     };
closedir($handle);
};
echo $numfiles.' files in a directory';
echo $numdir.' subdirectory in directory';

?>

I've tried this code and a few others, but it only displays 0.  I'd like the simplest working way to display the number of files in a directory.  Thanks for the help!

$directory = "../images/team/harry/";
$filecount = count(glob("" . $directory . "*.*"));
echo $filecount;

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=317036.0

I'm getting the dreaded " Invalid parameter number: number of bound variables does not match number of tokens" error and I've looked at this for days.  Here is what my table looks like:

|  id          | int(4)       | NO   | PRI | NULL    | auto_increment |
| user_id     | int(4)       | NO   |     | NULL    |                |
| recipient   | varchar(30)  | NO   |     | NULL    |                |
| subject     | varchar(25)  | YES  |     | NULL    |                |
| cc_email    | varchar(30)  | YES  |     | NULL    |                |
| reply       | varchar(20)  | YES  |     | NULL    |                |
| location    | varchar(50)  | YES  |     | NULL    |                |
| stationery  | varchar(40)  | YES  |     | NULL    |                |
| ink_color   | varchar(12)  | YES  |     | NULL    |                |
| fontchosen  | varchar(30)  | YES  |     | NULL    |                |
| message     | varchar(500) | NO   |     | NULL    |                |
| attachment  | varchar(40)  | YES  |     | NULL    |                |
| messageDate | datetime     | YES  |     | NULL    |        

Here are my params:

            $params = array(                 
               ':user_id' => $userid,                 
               ':recipient' => $this->message_vars['recipient'],                 
               ':subject' => $this->message_vars['subject'],                 
               ':cc_email' => $this->message_vars['cc_email'],                 
               ':reply' => $this->message_vars['reply'],                 
               ':location' => $this->message_vars['location'],                 
               ':stationery' => $this->message_vars['stationery'],                 
               ':ink_color' => $this->message_vars['ink_color'],                 
               ':fontchosen' => $this->message_vars['fontchosen'],                 
               ':message' => $messageInput,                 
               ':attachment' => $this->message_vars['attachment'],                 
               ':messageDate' => $date             );

Here is my sql:

$sql = "INSERT INTO messages (user_id,recipient, subject, cc_email, reply, location,stationery, ink_color, fontchosen, message,attachment) VALUES( $userid, :recipient, :subject, :cc_email, :reply, :location, :stationery, :ink_color, :fontchosen, $messageInput, :attachment, $date);";

And lastly, here is how I am calling it:
            $dbh = parent::$dbh;             
           $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);              
           if (empty($dbh))    return false;             
                  $stmt = $dbh->prepare($sql);             
                 $stmt->execute($params) or die(print_r($stmt->errorInfo(), true));              
           if (!$stmt) {    print_r($dbh->errorInfo());              }

I know my userid is valid and and the date is set above (I've echo'd these out to make sure).  Since the id is auto_increment, I do not put that in my sql (though I've tried that too), nor in my params (tried that too).  What am I missing?  I feel certain it is something small, but I have spent days checking commas, semi-colons and spelling.  Can anyone see what I'm doing wrong?

Hi guys,

I need your help. I am trying to insert the rows in the mysql database as I input the values in the url bar which it would be like this:

Code: [Select]
www.mysite.com/testupdate.php?user=tester&pass=test&user1=tester&email=me@shitmail.com&ip=myisp

However i have got a error which i don't know how to fix it.


Error: Column count doesn't match value count at row 1


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbusername');
    define('DB_PASSWORD', 'mydbpassword');
    define('DB_DATABASE', 'mydbname');

$errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {

die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $adduser = clean($_GET['user1']);
    $email = clean($_GET['email']);
    $IP = clean($_GET['ip']);
    if($username == '') {
  $errmsg_arr[] = 'username is missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD is missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
   $sql = "INSERT INTO `members` (`username`,`email`,`IP`) VALUES ('$adduser','$email','$IP')";

if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "The information have been updated.";
  }
?>


Here's the name of the columns i have got in my database:

Code: [Select]
username
email
IP


I have input the correct columns names, so I can't correct the problem I am getting.

Please can you help?