06-02-2008
Or you could try this if you don't know exactly what row your cursor may end up on while running the script.
printf "Please Enter User Name:\n\t\t\t"
read username
Or, for output on the same line.
printf "Please Enter User Name: "
read username
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
Is there a way to get the current cursor position?
I know "tput sc" saves it. Is there a way to find out the value saved?
Thanks. (0 Replies)
Discussion started by: bestbuyernc
0 Replies
2. Programming
Hello all,
How can i get the global position of the cursor?
(i'm using c language, and suse 10.1 linux)
Thanks. (3 Replies)
Discussion started by: boogy
3 Replies
3. HP-UX
Dear all,
How can i get the current cursor position..is thr any command to find the same?
Thanks in Advance
Aneesh (3 Replies)
Discussion started by: aneesha
3 Replies
4. Programming
I want to get the screen width and cursor positions.
When I used curses, all the screen content was cleared.
So Can I use curses to get the screen size without clearing anything in the window?
Or is there any other alternative???
I can use only C or C++. (0 Replies)
Discussion started by: Sreejesh.S
0 Replies
5. UNIX and Linux Applications
Hi to all!
I'm a teacher of maths and physics in an italian high school in Milan, Italy.
I need a simple program that read the position of mouse cursor in function of time and write the coordinates in a text file. The time resolution have to be something like 1/10 sec or better (I have to know... (2 Replies)
Discussion started by: chris75
2 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
In VI editor, to know the line number at any instant we use ctrl+g
Similarly, to know the current coulmn number what shall we use??
If not direct key controls like ctrl+g, Is there any comands that could be executed in colon or ex mode of VI to know the current column position???... (1 Reply)
Discussion started by: ramkrix
1 Replies
7. UNIX for Dummies Questions & Answers
Is there a way of finding the current cursor position (line & column) within AIX (4 Replies)
Discussion started by: gefa
4 Replies
8. Shell Programming and Scripting
hi all,
am trying to modify a ksh script to group server names together depending on the cluster they sit in. currently the script does a
find . -name '*.pid'
to find all running servers and prints out their pids and names.
current output looks something like this :
serverA ... (1 Reply)
Discussion started by: cesarNZ
1 Replies
9. Shell Programming and Scripting
I need to get the cursor position, and put it inside a variable. Problem is, i don't have the tput command, or ncurses.
Apparently I was supposed to try the following:
echo -e '\E
But I don't get a value or anything. Please help. (3 Replies)
Discussion started by: tinman47
3 Replies
10. Shell Programming and Scripting
Hi there.
It's easier to explain this with a pseudo code, I hope this makes sense:
var1=hello
echo $var1
some kind of loop
echo loop counter
done
How do I hold the cursor position immediately behind the last output so I'd get something like:
hello123456789
DOS used to use ","... (5 Replies)
Discussion started by: MuntyScrunt
5 Replies
LEARN ABOUT PHP
db2_fetch_array
DB2_FETCH_ARRAY(3) 1 DB2_FETCH_ARRAY(3)
db2_fetch_array - Returns an array, indexed by column position, representing a row in a result set
SYNOPSIS
array db2_fetch_array (resource $stmt, [int $row_number = -1])
DESCRIPTION
Returns an array, indexed by column position, representing a row in a result set. The columns are 0-indexed.
PARAMETERS
o $stmt
- A valid stmt resource containing a result set.
o $row_number
- Requests a specific 1-indexed row from the result set. Passing this parameter results in a PHP warning if the result set uses a
forward-only cursor.
RETURN VALUES
Returns a 0-indexed array with column values indexed by the column position representing the next or requested row in the result set.
Returns FALSE if there are no rows left in the result set, or if the row requested by $row_number does not exist in the result set.
EXAMPLES
Example #1
Iterating through a forward-only cursor
If you call db2_fetch_array(3) without a specific row number, it automatically retrieves the next row in the result set.
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$stmt = db2_prepare($conn, $sql);
$result = db2_execute($stmt);
while ($row = db2_fetch_array($stmt)) {
printf ("%-5d %-16s %-32s %10s
",
$row[0], $row[1], $row[2], $row[3]);
}
?>
The above example will output:
0 Pook cat 3.20
5 Rickety Ride goat 9.70
2 Smarty horse 350.00
Example #2
Retrieving specific rows with db2_fetch_array(3) from a scrollable cursor
If your result set uses a scrollable cursor, you can call db2_fetch_array(3) with a specific row number. The following example
retrieves every other row in the result set, starting with the second row.
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
$result = db2_exec($stmt, $sql, array('cursor' => DB2_SCROLLABLE));
$i=2;
while ($row = db2_fetch_array($result, $i)) {
printf ("%-5d %-16s %-32s %10s
",
$row[0], $row[1], $row[2], $row[3]);
$i = $i + 2;
}
?>
The above example will output:
0 Pook cat 3.20
5 Rickety Ride goat 9.70
2 Smarty horse 350.00
SEE ALSO
db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_object(3), db2_fetch_row(3), db2_result(3).
PHP Documentation Group DB2_FETCH_ARRAY(3)