I want to retireve the values from the array and need to pass this to a db2 command to create a view like below.
the number of values in the array will vary
Code:
CREATE VIEW table AS
SELECT col1, col2,col3
FROM Table[0] A0, Table[1] A1 ...Table[n]
Hi
I have something like
cat $HOME/all_dirs | while read ln_old_dirs
do
if
then
echo "$ln_all_old_dirs"
fi
done
As you know that the variable ln_all_old_dirs is not accessable from outside the... (2 Replies)
Hi,
I am using the following command to initialize and array
# arr=ffffff00
# echo $arr
ffffff00
my requirement is i want to fetch the one by one character from array.
I don't know how to fetch one by one charcter from array.
Please i need an help.
Thank you very much
Ravi R N (2 Replies)
I want to read $3,$4,$5,$6,$7 of fileA in array and when
fileb $1 = fileA $4
the i want to print array and few fields from fileB.
This should work but has some syntax error.
nawk -F, 'FNR==NR{a=;next} a{print a}' fileB fileA
Appreciate if someone can correct this. (2 Replies)
I have a file that is a text file, how to get all the words into and array, i am able to get each line but not each word :(.
Here is what i searched and already found...https://www.unix.com/shell-programming-scripting/99207-pipe-text-file-into-array.html.
This one reads a whole line into... (6 Replies)
I have this portion of a script and it works:
base_config="A B C D E"
for field in $base_config
do
var=`echo $field`
((i=$i+1))
done
I get an array of var=A, var=B, and so on.
What if I have this example with white space and want to put it into an array while... (1 Reply)
set -A title
set -A author
count=1
index=0
while
do
read -A ${title}?"Booktitle: "
read -A ${author}?"Author(s): "
(( count = count + 1 ))
(( index = index + 1 ))
done
Hi... (1 Reply)
I have some version problem to use this code in my server
while read line; do
read -A array <<<$line <---------- the server dont read <<<
n=${#array}
for ((i=1;i<$n;i++)); do
print "${array}"
done
func=${array}
data1=${array}
data2=${array}
... (1 Reply)
Hi,
I need to read a file into array and print them in a loop:-
1st file :-cat a.txt
RC1
RC2
RC3
RC4
My Program:-
#!/bin/ksh
index=0
while
do
read cnt<a.txt
print "cnt value is ${cnt}
index=`expr $index + 1`
done
Code tags for code, please. (5 Replies)
Hi I have a file with contents as below :
server | ABC Issue : File System Missing XYZ Issue : Wrong Syntax PQR Issue : Old File to be removed
Now I am looking for an o/p similar to
server <tab> ABC Issue : File System Missing
<tab> XYZ Issue : Wrong Syntax
<tab>... (4 Replies)
Hi All,
need help with reading the array and sum of the array elements.
given an array of integers of size N . You need to print the sum of the elements in the array, keeping in mind that some of those integers may be quite large.
Input Format
The first line of the input consists of an... (1 Reply)
Discussion started by: nishantrefound
1 Replies
LEARN ABOUT PHP
mysqli_fetch_fields
MYSQLI_FETCH_FIELDS(3) 1 MYSQLI_FETCH_FIELDS(3)mysqli_result::fetch_fields - Returns an array of objects representing the fields in a result set
Object oriented style
SYNOPSIS
array mysqli_result::fetch_fields (void )
DESCRIPTION
Procedural style
array mysqli_fetch_fields (mysqli_result $result)
This function serves an identical purpose to the mysqli_fetch_field(3) function with the single difference that, instead of returning one
object at a time for each field, the columns are returned as an array of objects.
PARAMETERS
o $
result -Procedural style only: A result set identifier returned by mysqli_query(3), mysqli_store_result(3) or
mysqli_use_result(3).
RETURN VALUES
Returns an array of objects which contains field definition information or FALSE if no field information is available.
Object properties
+-----------+---------------------------------------------------+
| Property | |
| | |
| | Description |
| | |
+-----------+---------------------------------------------------+
| name | |
| | |
| | The name of the column |
| | |
| orgname | |
| | |
| | Original column name if an alias was specified |
| | |
| table | |
| | |
| | The name of the table this field belongs to (if |
| | not calculated) |
| | |
| orgtable | |
| | |
| | Original table name if an alias was specified |
| | |
|max_length | |
| | |
| | The maximum width of the field for the result |
| | set. |
| | |
| length | |
| | |
| | The width of the field, as specified in the table |
| | definition. |
| | |
|charsetnr | |
| | |
| | The character set number for the field. |
| | |
| flags | |
| | |
| | An integer representing the bit-flags for the |
| | field. |
| | |
| type | |
| | |
| | The data type used for this field |
| | |
| decimals | |
| | |
| | The number of decimals used (for integer fields) |
| | |
+-----------+---------------------------------------------------+
EXAMPLES
Example #1
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";
if ($result = $mysqli->query($query)) {
/* Get field information for all columns */
$finfo = $result->fetch_fields();
foreach ($finfo as $val) {
printf("Name: %s
", $val->name);
printf("Table: %s
", $val->table);
printf("max. Len: %d
", $val->max_length);
printf("Flags: %d
", $val->flags);
printf("Type: %d
", $val->type);
}
$result->close();
}
/* close connection */
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";
if ($result = mysqli_query($link, $query)) {
/* Get field information for all columns */
$finfo = mysqli_fetch_fields($result);
foreach ($finfo as $val) {
printf("Name: %s
", $val->name);
printf("Table: %s
", $val->table);
printf("max. Len: %d
", $val->max_length);
printf("Flags: %d
", $val->flags);
printf("Type: %d
", $val->type);
}
mysqli_free_result($result);
}
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Name: Name
Table: Country
max. Len: 11
Flags: 1
Type: 254
Name: SurfaceArea
Table: Country
max. Len: 10
Flags: 32769
Type: 4
SEE ALSO mysqli_num_fields(3), mysqli_fetch_field_direct(3), mysqli_fetch_field(3).
PHP Documentation Group MYSQLI_FETCH_FIELDS(3)