hey guys
having some trouble figuring this out.
my program is supposed to take a name of a directory as a command line argument and change the filenames inside that directory to lowercase.
what i dont get is how you access that directory and go thru all the files and change the filenames... (1 Reply)
Dear All,
I have some thousands of files in a folder and i need to change those file names without opening the file (no need to change anything in the file content, need to change the file name only). The filenames are as follows:
Myfile_name.1_parameter
Myfile_name.2_parameter... (6 Replies)
I have lot of files whose names are something like the following. I want to change the name of all the files from 'npt02' to 'n02'.
npt02-z30-sr65-rgdt0p50-dc0p01-16x12drw.tpf
npt02-z30-sr65-rgdt0p50-dc0p01-8x6drw.back
npt02-z30-sr65-rgdt0p50-dc0p01-8x6drw-bst-mis.xy... (5 Replies)
I have a bunch of database files in a directory. Their name are like:
1234_ABCD_01.dbf, 28hrs_ABCD_02.dbf
I want to change them in bulk to:
1234_XXXU_01.dbf, 28hrs_XXXU_02.dbf.
I mean I just want to replace ABCD by XXXU. don't change other part of the file name and the contents of the... (4 Replies)
I have written a csh script that changes the name of file from src to dst.
I am getting the error below:
TESTAmvfiles
DONE TESTAmvfiles
set: Variable name must begin with a letter.
The csh script is:
#!/bin/csh
#... (0 Replies)
I have file names as shown and want to change the name to have only the first four numbers.
/home/chrisd/Desktop/nips/nips_2013/5212-learning-feature-selection-dependencies-in-multi-task-learning.pdf
/home/chrisd/Desktop/nips/nips_2013/5213-parametric-task-learning.pdf... (3 Replies)
I have a series of files as follows
file-1.pdf
file-2.pdf
file-3.pdf
file-4.pdf
file-5.pdf
file-6.pdf
file-7.pdf
I want to have the file names with odd numbers
starting from an initial number, for example 2000.
The result would be the following:
file-2001.pdf
file-2003.pdf... (9 Replies)
INGRES_UNBUFFERED_QUERY(3) 1 INGRES_UNBUFFERED_QUERY(3)ingres_unbuffered_query - Send an unbuffered SQL query to IngresSYNOPSIS
mixed ingres_unbuffered_query (resource $link, string $query, [array $params], [string $types])
DESCRIPTION ingres_unbuffered_query(3) sends the given $query to the Ingres server.
The query becomes part of the currently open transaction. If there is no open transaction, ingres_unbuffered_query(3) opens a new transac-
tion. To close the transaction, you can call either ingres_commit(3) to commit the changes made to the database or ingres_rollback(3) to
cancel these changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback(3)). You can also use
ingres_autocommit(3) before opening a new transaction to have every SQL query immediately committed. Ingres allows only a single unbuffered
statement to be active at any one time. The extension will close any active unbuffered statements before executing any SQL. In addition you
cannot use ingres_result_seek(3) to position the row before fetching.
Note
Related Configurations
See also the ingres.describe and ingres.utf8 directives in Runtime Configuration.
PARAMETERS
o $link
- The connection link identifier
o $query
- A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter in ingres_query(3)
for a list of SQL statements that cannot be executed via ingres_unbuffered_query(3). Data inside the query should be properly
escaped.
o $params
- An array of parameter values to be used with the query
o $types
- A string containing a sequence of types for the parameter values passed. See the types parameter in ingres_query(3) for the list
of type codes.
RETURN VALUES ingres_unbuffered_query(3) returns a query result identifier when there are rows to fetch; else it returns FALSE when there are no rows, as
is the case of an INSERT, UPDATE, or DELETE statement. To see if an error occurred, use ingres_errno(3), ingres_error(3), or ingres_errsql-
state(3).
EXAMPLES
Example #1
Issue a simple un-buffered select
<?php
$link = ingres_connect("demodb");
$result = ingres_unbuffered_query($link, "select * from user_profile");
while ($row = ingres_fetch_row($result)) {
echo $row[1];
echo $row[2];
}
?>
Example #2
Passing query parameters to ingres_unbuffered_query(3)
<?php
$link = ingres_connect("demodb");
$params[] = "Emma";
$query = "select * from user_profile where up_first = ?";
$result = ingres_unbuffered_query($link, $query, $params);
while ($row = ingres_fetch_row($result)) {
echo $row[1];
echo $row[2];
}
?>
Example #3
Inserting a BLOB with parameter types
<?php
$link = ingres_connect("demodb");
//Open a photo
$fh = fopen("photo.jpg","r");
$blob_data = stream_get_contents($fh);
fclose($fh);
//Prepare parameters
$params[] = $blob_data;
$params[] = 1201;
//Define parameter types
$param_types = "Bi";
$query = "update user_profile set up_image = ? where up_id = ?";
$result = ingres_unbuffered_query($link, $query , $params, $param_types);
if (ingres_errno())
{
echo ingres_errno() . "-" . ingres_error() . "
";
}
?>
SEE ALSO ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3), ingres_roll-
back(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3).
PHP Documentation Group INGRES_UNBUFFERED_QUERY(3)