Hi,
I have a list of files that I want to check to see if they exist and then count how many of these files exist, I also want to do the same for the files that arent found.
I have done this by creating temp files see below but want ot do this using variables instead:
for FILE in... (7 Replies)
Hi. I'd like to have an IF-Then-Else statement where I can check to see if a file exists? We have the Bourne Shell by default. I'm looking for the syntax to do something like this:
if myfile.txt exists then
...my code
else
...my code
end if
Any help would be greatly... (5 Replies)
I lookifn for a way to SFTP a file based on the presence of a flag file .
The logic is some thing like this in shelling terms
IF ]; then
download file.DDMM.dat
FI
The above is just the way of interpreting the logic.
Just want to add that i do not have SSh access to the remote... (2 Replies)
I want to write a script to see if various files exist. What I want to do is have the script search in various directories if a file exist, and if not, then output something like "/path/file does not exist". I don't actually know of how to check and see if a file exists or not. What I have in mind... (2 Replies)
Hi
#Testing for file existence
if ; then
echo 'SCHOOL data is available for processing'
else
echo 'SCHOOL DATA IS NOT AVAILABLE FOR PROCESSING'
:
i wrote a script, where it begins by checking if file exists or not.
If it exists, it truncates the database... (2 Replies)
Hi guys,
I am beginner trying to learn unix. So any help is welcomed.
My requirement is to check whether is a file exists in a particular directory or not.
The directory path and filename are taken dynamically with user interaction. So the program should continue only if the $filename... (1 Reply)
Hi,
I want to check if the file exists or not in the directory.
i am trying below code but not working.
File="/home/va59657/Account_20090213*.dat"
echo "$File"
if ]; then
echo "file found"
else
echo "file not found"
fi
However i am getting file not found even if file exits as... (5 Replies)
bash in RHEL 6.3
I have these 2 files with strings.
$ cat someStrings.txt
LOGICAL1
HUNGARY2
PENGUIN2
MOBILE
GUITAR1
MOUSE1
$$ cat checkIF.txt
PENGUIN
MOBILE
$I need to search for strings in someStrings.txt file that matches the patterns in checkIF.txt file.
The strings in... (7 Replies)
I need to check whether a file exists and has been changed.
The file should contain a specific string. The file should also have been changed within the last ten seconds.
How do I do that? (3 Replies)
There are some files with suffix dates like abc_20032019.dat abc_17032019.dat
If at least one file exists then perform some operation else exit from execution.
Korn shell
----------------------------------
array=($inputdir/abc*.dat)
If ] ]
then
echo " file exits"
else
echo " file does... (10 Replies)
Discussion started by: Rajesh123
10 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)