DBASE_GET_RECORD_WITH_NAMES(3) 1 DBASE_GET_RECORD_WITH_NAMES(3)dbase_get_record_with_names - Gets a record from a database as an associative arraySYNOPSIS
array dbase_get_record_with_names (int $dbase_identifier, int $record_number)
DESCRIPTION
Gets a record from a dBase database as an associative array.
PARAMETERS
o $dbase_identifier
- The database link identifier, returned by dbase_open(3) or dbase_create(3).
o $record_number
- The index of the record.
RETURN VALUES
An associative array with the record. This will also include a key named deleted which is set to 1 if the record has been marked for dele-
tion (see dbase_delete_record(3)).
Each field is converted to the appropriate PHP type, except:
o Dates are left as strings.
o Integers that would have caused an overflow (> 32 bits) are returned as strings.
On error, dbase_get_record_with_names(3) will return FALSE.
EXAMPLES
Example #1
Listing all the registered members in the database
<?php
// open in read-only mode
$db = dbase_open('/tmp/test.dbf', 0);
if ($db) {
$record_numbers = dbase_numrecords($db);
for ($i = 1; $i <= $record_numbers; $i++) {
$row = dbase_get_record_with_names($db, $i);
if ($row['ismember'] == 1) {
echo "Member #$i: " . trim($row['name']) . "
";
}
}
}
?>
SEE ALSO dbase_get_record(3).
PHP Documentation Group DBASE_GET_RECORD_WITH_NAMES(3)
Check Out this Related Man Page
DBASE_GET_HEADER_INFO(3) 1 DBASE_GET_HEADER_INFO(3)dbase_get_header_info - Gets the header info of a databaseSYNOPSIS
array dbase_get_header_info (int $dbase_identifier)
DESCRIPTION
Returns information on the column structure of the given database link identifier.
PARAMETERS
o $dbase_identifier
- The database link identifier, returned by dbase_open(3) or dbase_create(3).
RETURN VALUES
An indexed array with an entry for each column in the database. The array index starts at 0.
Each array element contains an associative array of column information, as described here:
o name
- The name of the column
o type
- The human-readable name for the dbase type of the column (i.e. date, boolean, etc.)
o length
- The number of bytes this column can hold
o precision
- The number of digits of decimal precision for the column
o format
- A suggested printf(3) format specifier for the column
o offset
- The byte offset of the column from the start of the row
If the database header information cannot be read, FALSE is returned.
EXAMPLES
Example #1
Showing header information for a dBase database file
<?php
// Path to dbase file
$db_path = "/tmp/test.dbf";
// Open dbase file
$dbh = dbase_open($db_path, 0)
or die("Error! Could not open dbase database file '$db_path'.");
// Get column information
$column_info = dbase_get_header_info($dbh);
// Display information
print_r($column_info);
?>
PHP Documentation Group DBASE_GET_HEADER_INFO(3)
I have a comma-separated record and I'd like to use sed to pull the Nth record from it.
It seems like it'd need to be something like this: sed -n 's/'"\,$1\,"'/&/p'
Am I close? (3 Replies)
Hi
I want to read one row record from a text file.
For eg: I have Sample.txt file with one row of record like
123456768
I want to get the above value from the file and assign it to a variable in my script. Please guide me how to proceed.
Thanks,
Soll (2 Replies)
Most shells flavors do not have associative arrays a.k.a. maps.
How would you emulate an associative array?
I had this problem once and found a working solution, but I don't want to spoil the game hence I wont tell it.
Wonder if anyone comes up with something better. (5 Replies)
hi
i have record looks like below
1,US
I want to add empty field to the record as below
1, , , ,US
how i can do it using awk ?
i tried with awk its not working
awk '{ print $1", ,"$2 }' filename > file 1 (2 Replies)
I have a file with only one record and the file size would be around 80 MB.
Is there a way, where I can read and write this to a file with only 80bytes in each row (3 Replies)
I'm not very good at associative arrays; and working on this PHP code has got me a bit stumped. My goal is to populate a (multidimensional) associative array in a PHP while look after a MySQL query. The code fragment looks like this:
while($campaign_row = mysql_fetch_array($campaigninfo))
{
... (9 Replies)
Hello,
I have a large database in which name homonyms are arranged in a row. Since the database is large and generated by hand, very often dupes creep in. I want to remove the dupes either using an awk or perl script.
An input is given below
The expected output is given below:
As can be... (2 Replies)
Hi!
Let's say I would like to convert "1", "2", "3" to "a", "b", "c" respectively. But if a record contains other number then return "X".
input:
1
2
3
4
output:
a
b
c
X
What is the syntax for:
if(array doesn't contain a particular index){
then print the value "X" instead} (12 Replies)
Hi! all
can any one tell me how to compare current record of column with next and previous record in awk without using array
my case is like this
input.txt
0 32
1 26
2 27
3 34
4 26
5 25
6 24
9 23
0 32
1 28
2 15
3 26
4 24 (7 Replies)
Hi. How can I read row number from one file and print that corresponding record present at that row in another file.
eg
file1
1
3
5
7
9
file2
11111
22222
33333
44444
55555
66666
77777
88888
99999 (3 Replies)
Is there a reliable way to deal with whitespace in array indicies?
I am trying to annotate fails in a database using a table of known fails.
In a begin block I have code like this:
# Read in Known Fail List
getline < "'"$failListFile"'"; getline < "'"$failListFile"'"; getline <... (6 Replies)
I have data coming in the below format for each record
<?xml version="1.0" encoding="UTF-8" standalone="no"?><test_sox xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><testdetials>....</test_sox>
<?xml version="1.0" encoding="UTF-8" standalone="no"?><test_sox... (8 Replies)
I have a source file where a record starts with # entry-id: followed by a number.
i want to move the record in file 1 iff the second row is
"dn: uid=.*,ou=perm,dc=mssb,dc=com"
and the record to file 2 if contents of second row anything else
# entry-id: 1
dn:... (6 Replies)
My requirment is for every record of a particular file I've to check for a record delimeter (e.g. "\n") and if any row doesn't have "\n" then report it in error file .
Please suggest me to go through this. (4 Replies)
Hello,
I want to get the maximum value of each record separated by empty line based on the 3rd column of each row within each record?
Input:
A1 chr5D 634 7 82 707
A2 chr5D 637 6 82 713
A3 chr5D 637 5 82 713
A4 chr5D 626 1 82 704... (4 Replies)