07-15-2008
Your version doesn't work for me, however radoulov's does. Are you sure you didn't typo the $i when copying your code in somehow?
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi I am Newbie to Unix.Appreciate Help from forum
user would loada b.Csv File(Below example) in /data/m/ directory.Program need to read the b.csc to extract certain column and create a new file /data/d/ directory as csv file with new name.
User File Format
1232,samshouston,12345... (3 Replies)
Discussion started by: skywayterrace
3 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I would like to know if you can set up in part of a script for the script to create a txt file and put some predetermined text into it.
#Example
make file example.txt
#Then it would the lines below into the text file as text.
Line 1
Line 2
Line 3
Does anyone have any... (1 Reply)
Discussion started by: outthere_3
1 Replies
3. Shell Programming and Scripting
Hello Guys ,
I need an another help regarding the below problem.
I want to create a new file based on the existing file ,where two columns will be changed according to user input .(say column 4 and column 5)
Please let me know how to proceed with
Thanks (3 Replies)
Discussion started by: Pratik4891
3 Replies
4. Shell Programming and Scripting
Dear All,
I have a requirement in which i have to load a file placed in FTP location onto my database. The process i'll follow is as below:
1) Get the files using FTP.
2) Create the desired load files as i have to load only 19 fields out of the 104 available in the file.
The fields i require... (7 Replies)
Discussion started by: abhishekakaomi
7 Replies
5. Shell Programming and Scripting
I have a text file with contents like this:
a,b,c,
d~e,f,g,h~i,j
,k,l,m~n,o,p,q~
I need to convert this file into this format unix shell script commands:
a,b,c,d~
e,f,g,h~
i,j,k,l,m~
n,o,p,q~
as you may have noticed, I need to retain the ~ signs at the end.
Any help is greatly... (3 Replies)
Discussion started by: harsha1238
3 Replies
6. UNIX for Advanced & Expert Users
Hi
I need some help with a task, i am an absolute newbie to any form of shell scripting and request guidance.
I have been building a proxy server using the apache mod proxy currently my solution is working , but i need to automate the process , suppose if any changes need to be made on... (0 Replies)
Discussion started by: satej
0 Replies
7. Shell Programming and Scripting
Good evening
I have the below requirements, as I am not an experts in Linux/Unix and am looking for your ideas how I can do this.
I have file called file1 and file2.
I need to get the second column which is text1_random_alphabets and find that in file 2, if it's exists then print the 3rd... (4 Replies)
Discussion started by: mychbears
4 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 table
SYNOPSIS
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)