Thanks bakunin. The issue is the variable will be in the following format:
Why? If it is a variable you can define it in any way you want, no?
Or is it some external input you need to use? In this case: how did it get into this variable? Perhaps there is a better way to put it in more suitably formed variables. You might want to present the whole problem, not just an arbitrary part of it.
Quote:
Originally Posted by shash
In this case how to use the array please?
The following is not pretty and less readable than my original idea, but there you go:
I have a script which selects two 'sets' of system LVM device files from a tabular file 'mapfile' using awk :
LIVELV=`awk '{print($1)}' mapfile`
BCVLV=`awk '{print($3)}' mapfile`
I wanted to pass these 'sets' into an LVM command 'loop' along the lines of :
lvmerge $BCVLV $LIVELV
ie.... (3 Replies)
I'm a Linux newb, I've been running a Debian Linux server for about a year now, and I've written some simple scripts to automate various things, but I still don't know much, and I forget what I learn as fast as I figure it out... Anyway, that really isn't important, I just want you to know that... (14 Replies)
Hi ,
I am trying to write a script in kshell with while loop ,its like
count=1
count_cmp=1
while ; do
tail -$count tempfile | head -1 > tempstring
.......
done
However i get CIF.sh: line 33: '
I have checked thetrailing spaces , not sure what is... (4 Replies)
I'm having trouble with a simple piece of code.
IFS=,
echo "1,2,3,4,5,6,7,8" | while read x y
do
echo "x=$x"
echo "y=$y"
done
I'm hoping for
x=1
y=2
x=3
y=4
.
.
.
but I'm getting
x=1 (3 Replies)
Hi
Am trying to print the PIDs of process in a file and trying to grep any PID from that file
I set the if condition as $value != "PID" and $value != "-"
Assign that number to a variable
Am confused since am using while loop to read the line from file
and again if condition to check those... (2 Replies)
Hi,
I have two variables like below which will always be of the same size
a=1:2:3
b=A:B:C
I need to use a for/while loop that will have both the variables available. I cannot use an array here and will probably might iterate through the variable as echo $a | tr ':' '\n' and thus iterate... (5 Replies)
Hello,
I would like to ask for help with csh script.
An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
hi,
i need a portion in a audit logging shell script where i have to loop thru multiple variables.
I need some help in accomplishing this. i have 3 variables
var1=1,23,234
var2=a,ab,xyz
var3=0,0,0
the variables will have variables number of values but same length.(3 in this case )
i... (10 Replies)
Hi!
I've run into a problem where my variables are displayed in the wrong order. Basically I'm supposed to use a file that has information like this username:firstname:lastname:etc:etc.
What I'm interested in doing is reformating it into a something more like this: username lastname,... (2 Replies)
Discussion started by: reindeermountai
2 Replies
LEARN ABOUT PHP
sqlite_fetch_column_types
SQLITE_FETCH_COLUMN_TYPES(3)SQLITE_FETCH_COLUMN_TYPES(3)sqlite_fetch_column_types - Return an array of column types from a particular tableSYNOPSIS
array sqlite_fetch_column_types (string $table_name, resource $dbhandle, [int $result_type = SQLITE_ASSOC])
DESCRIPTION
Object oriented style (method): array SQLiteDatabase::fetchColumnTypes (string $table_name, [int $result_type = SQLITE_ASSOC])
sqlite_fetch_column_types(3) returns an array of column data types from the specified $table_name table.
PARAMETERS
o $table_name
- The table name to query.
o $dbhandle
- The SQLite Database resource; returned from sqlite_open(3) when used procedurally. This parameter is not required when using the
object-oriented method.
o $result_type
- The optional $result_type parameter accepts a constant and determines how the returned array will be indexed. Using SQLITE_ASSOC
will return only associative indices (named fields) while SQLITE_NUM will return only numerical indices (ordinal field numbers).
SQLITE_ASSOC is the default for this function.
RETURN VALUES
Returns an array of column data types; FALSE on error.
The column names returned by SQLITE_ASSOC and SQLITE_BOTH will be case-folded according to the value of the sqlite.assoc_case configuration
option.
CHANGELOG
+--------+--------------------+
|Version | |
| | |
| | Description |
| | |
+--------+--------------------+
| 5.1.0 | |
| | |
| | Added $result_type |
| | |
+--------+--------------------+
EXAMPLES
Example #1
Procedural example
<?php
$db = sqlite_open('mysqlitedb');
sqlite_query($db, 'CREATE TABLE foo (bar varchar(10), arf text)');
$cols = sqlite_fetch_column_types('foo', $db, SQLITE_ASSOC);
foreach ($cols as $column => $type) {
echo "Column: $column Type: $type
";
}
?>
Example #2
Object-oriented example
<?php
$db = new SQLiteDatabase('mysqlitedb');
$db->query('CREATE TABLE foo (bar varchar(10), arf text)');
$cols = $db->fetchColumnTypes('foo', SQLITE_ASSOC);
foreach ($cols as $column => $type) {
echo "Column: $column Type: $type
";
}
?>
The above example will output:
Column: bar Type: VARCHAR
Column: arf Type: TEXT
PHP Documentation Group SQLITE_FETCH_COLUMN_TYPES(3)