This repository has been archived by the owner on Dec 7, 2019. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 8
/
sometests.php
121 lines (101 loc) · 2.46 KB
/
sometests.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<html>
<body>
<?php
$db = dbase_open('/home/an existing dbf/existing.DBF', 0);
if ($db) {
echo('start ');
echo($db);
echo('enddb ');
echo('hi numrecords is: ');
echo(dbase_numrecords($db));
echo('\r\n Heres the header info:');
print_r(dbase_get_header_info($db));
echo('trying record num 2');
$rec = dbase_get_record($db, 2);
$nf = dbase_numfields($db);
for ($i = 0; $i < $nf; $i++) {
echo $rec[$i], "\n";
}
dbase_close($db);
}
echo('end. Trying to create db...');
$def = array(
array("date", "D"),
array("name", "C", 50),
array("age", "N", 3, 0),
array("email", "C", 128),
array("ismember", "L")
);
// creation
$db = dbase_create('/home/a writeable directory/test.dbf', $def);
if (!$db) {
echo "Error, can't create the database\n";
} else {
echo('hi numrecords is: ');
echo(dbase_numrecords($db));
echo('\r\n Heres the header info:');
print_r(dbase_get_header_info($db));
echo('number of records: ');
echo(dbase_numrecords($db));
echo('inserting row...');
dbase_add_record($db, array(
date('Ymd'),
'Maxim Topolov',
'23',
'T'));
echo('finished inserting. number of records: ');
echo(dbase_numrecords($db));
echo('trying record num 1: ');
$rec = dbase_get_record($db, 1);
$nf = dbase_numfields($db);
for ($i = 0; $i < $nf; $i++) {
echo $rec[$i], "\n";
}
dbase_add_record($db, array(
date('Ymd'),
'Maxi2222m Topolov',
'23',
'T'));
echo('updating a row...');
// gets the old row
$row = dbase_get_record_with_names($db, 1);
// remove the 'deleted' entry
unset($row['deleted']);
$row = array(
date('Ymd'),
'Maxitom',
'23',
'T');
// Update the date field with the current timestamp
// $row['name'] = 'Tom';
echo('row before inserting is: ');
print_r($row);
// Replace the record
dbase_replace_record($db, $row, 1);
echo('trying record num 1: ');
$rec = dbase_get_record($db, 1);
$nf = dbase_numfields($db);
for ($i = 0; $i < $nf; $i++) {
echo $rec[$i], "\n";
}
echo('deleting row 2. before deletion: ');
$rec = dbase_get_record($db, 2);
$nf = dbase_numfields($db);
for ($i = 0; $i < $nf; $i++) {
echo $rec[$i], "\n";
}
echo( dbase_delete_record($db, 2));
echo('before db pack');
echo(dbase_pack($db));
echo('after pack, trying to fetch record 2');
$rec = dbase_get_record($db, 2);
$nf = dbase_numfields($db);
for ($i = 0; $i < $nf; $i++) {
echo $rec[$i], "\n";
}
dbase_close($db);
}
?>