1) Download tmp_file
2) Open tmp_file in program
3) Unlink tmp_file (yes, while still open)
4) Search for line
5) Print results
6) Close file (which will now disappear for good)
Hi,
My ubuntu flavor always create temporary files having filename followed by ~ on editing. For eg: if I am editing a file called "sip.c", automatically a temporary (bkup) file is getting created with the name "sip.c~". How to avoid this file creation? (7 Replies)
Hi all,
In the script I am creating a temporary file with process id as temp.txt.$$
I want to remove this tomporary file first from the current directory when i'll run the same script next time.
Note: Every time when the script executes then it has unique process id and it'll create a... (5 Replies)
Hi All,
I'm getting this error when I use "pg".
/tmp is not full and the permission is correct.
root@axappk01::/home> hostname|pg
pg: 0652-122 Cannot write to the temporary file.
Please advise. (6 Replies)
Hi All,
I have a file like below, how can i insert one line after line 1 without using a temporary file in perl?
line 1
line 2
line 3
expected result
line 1
new line <---insert here
line 2
line 3 (2 Replies)
Ok in my bash script i have 5 options to create a simple html script. I need to create a temporary file and whatever the user types will be stored in that file using html codes. And then I have another option in which that temporary file will be moved to the public_html directory in which the user... (19 Replies)
Hi ,
I am facing a problem with respect to mailx command in unix . Earlier it was working fine and I am facing this issue only from last week .
I used mailx command and I am getting a error message as follows :
temporary mail file: Permission denied
If I run mailx command from... (2 Replies)
I want remove first line of the file without using any temporary file. Everything should be done in the original file itself since I don't any file creation access whereas I have modify access.
It would be great if somebody help in this regard ASAP .
Thanks in Advance.
Kishore:mad: (1 Reply)
Hi-
How can I make the temporary file 0 byte , created inside gawk.
I am using
system("rm -f temp_orders");
It seems system command is deleting file permanently and I am not able to execute below statement.
print ORD_HEAD_FULL >> cFILE; (cFile is temp_orders) (2 Replies)
How would I go about resolving this error
temporary mail message file: No such file or directory
Can anybody tell me where the default location is for the temporary mail message file is for mailx? It appears that it doesn't exist.
Thanks (1 Reply)
Text in input file is like this
<title>
<band height="21" isSplitAllowed="true" >
<staticText>
<reportElement
x="1"
y="1"
width="313"
height="20"
key="staticText-1"/>
<box></box>
<textElement>
<font fontName="Arial" pdfFontName="Helvetica-Bold"... (4 Replies)
Discussion started by: aankita30
4 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)