Hi,
I want to find the total size of some directory trees in my solaris 9 machine.
Is there a command or utility I can use to do it. Please let me know if there is
any way.
Thanks
Akheel (1 Reply)
As I'm a newbie to UNIX, very newbie in fact, could anyone humour me and tell me how I'd find just the file size in bytes for a specific file?
Or at least just the specific line from the ls -a for the file - call it file1
I know this sounds bad but I don't seem to be getting very far at this... (3 Replies)
Hi,
I'm newbie to Unix. I'd like to count the total size of those files in my directory by date. For example, files on this period 05/01/08 - 05/31/08. If possible can we count by byte instead of kb.
if I use $ du - ks , it will add up all files in the dir.
thanks,
Helen (5 Replies)
Friends,
I have an 80 GB HDD, but I wish to know if there is a direct command in Solaris 10 to find out the size of my hard disk (similar to fdisk -l in Linux).
Thank you
saagar (3 Replies)
Hi All...
is the below command be modified in sucha way that i can get the file size along with the name and path of the file
the below command only gives me the file location which are more than 100000k...but I want the exact size of the file also..
find / -name "*.*" -size +100000k
... (3 Replies)
Hi All,
I am writing a script in which i need find the total size of all the directories that are present in a directory which are owned by a particular user.
I will explain in details
i have a dir DIR1 in which i have 5 dir's DIRA DIRB DIRC DIRD DIRE.
DIRA DIRC DIRE are owned by "eswar" i... (2 Replies)
Hello :
I need some help in writing a ksh script which will find a particular directory in all the file systems in a server and finally report the total size of the direcotry in all the file systems.
Some thing like this..
find /u*/app/oracle -type d -name "product" -prune
and then... (1 Reply)
:mad:i need command to know the total size of project in my system by Giga bit
i try
#du -s /*/projectname
but i need total size for this project by G.B
can you help me (6 Replies)
If I have a number of files in a directory, for example,
test.1
test.2
test.3
abc.1
abc.2
abc.3
and I need to find the total file size of all of the test.* files, I can use du -bc test.* in Linux.
However, in Solaris, du does not have the -c option. What can I do in Solaris to get... (11 Replies)
Discussion started by: learnix
11 Replies
LEARN ABOUT PHP
maxdb_stmt_affected_rows
MAXDB_STMT_AFFECTED_ROWS(3) 1 MAXDB_STMT_AFFECTED_ROWS(3)maxdb_stmt_affected_rows - Returns the total number of rows changed, deleted, or inserted by the last executed statement
Procedural style
SYNOPSIS
int maxdb_stmt_affected_rows (resource $stmt)
DESCRIPTION
Object oriented style
int$maxdb_stmt->affected_rows ()
maxdb_stmt_affected_rows(3) returns the number of rows affected by INSERT, UPDATE, or DELETE query. If the last query was invalid or the
number of rows can not determined, this function will return -1.
RETURN VALUES
An integer greater than zero indicates the number of rows affected or retrieved. Zero indicates that no records where updated for an
UPDATE/DELETE statement, no rows matched the WHERE clause in the query or that no query has yet been executed. -1 indicates that the query
has returned an error or the number of rows can not determined.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
/* create temp table */
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
$query = "INSERT INTO temp.mycity SELECT * FROM hotel.city WHERE state LIKE ?";
/* prepare statement */
if ($stmt = $maxdb->prepare($query)) {
/* Bind variable for placeholder */
$code = 'N%';
$stmt->bind_param("s", $code);
/* execute statement */
$stmt->execute();
printf("rows inserted: %d
", $stmt->affected_rows);
/* close statement */
$stmt->close();
}
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
/* create temp table */
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
$query = "INSERT INTO temp.mycity SELECT * FROM hotel.city WHERE state LIKE ?";
/* prepare statement */
if ($stmt = maxdb_prepare($link, $query)) {
/* Bind variable for placeholder */
$code = 'N%';
maxdb_stmt_bind_param($stmt, "s", $code);
/* execute statement */
maxdb_stmt_execute($stmt);
printf("rows inserted: %d
", maxdb_stmt_affected_rows($stmt));
/* close statement */
maxdb_stmt_close($stmt);
}
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
rows inserted: 4
SEE ALSO maxdb_stmt_num_rows(3), maxdb_prepare(3).
PHP Documentation Group MAXDB_STMT_AFFECTED_ROWS(3)