db_usql.inc
2.27 KB
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
<?php
/*
* PHP Base Library
*
* general utilities for db_sql
*
* (c) 1999-2000 Carmelo Guarneri
*
* $Id$
*
*/
class DB_USql extends DB_Sql {
//--------------------------------------------------------------
// this function can be used to export all the columns of
// a record into global variables.
// It should be used after a call to next_record().
//--------------------------------------------------------------
function import_record_vars() {
while (list($key, $val) = each($this->Record))
if (ereg("[A-Za-z][A-Za-z0-9_]*", $key)) {
$field_name = strtoupper($key);
global $$field_name;
$$field_name=$val;
};
}
//--------------------------------------------------------------
// this function can be used to export all the records of
// a table on the output in the form of a call to the db_sql
// query function with an insert statement.
//--------------------------------------------------------------
function dump_table($tablename, $filter="") {
$this->query(sprintf("select * from %s", $tablename));
while ($this->next_record()) {
$this->dump_record($tablename, $filter);
};
}
//--------------------------------------------------------------
// this function can be used to export all the records of
// a query on the output in the form of a call to the db_sql
// query function with an insert statement.
//--------------------------------------------------------------
function dump_query($tablename, $filter="") {
//$this->query(sprintf("select * from %s", $tablename));
while ($this->next_record()) {
$this->dump_record($tablename, $filter);
};
}
function dump_record($tablename, $filter="") {
$fields="";
$values="";
while (list($key, $val) = each($this->Record))
if (ereg("[A-Za-z][A-Za-z0-9_]*", $key)) {
$field_name = strtoupper($key);
if (!empty($val))
if (strstr( $filter, $field_name )=="") {
$fields.="$field_name ,";
$val=ereg_replace("'","''",$val);
$val=ereg_replace("\"","\\\"",$val);
//addslashes($val);
$values.="'$val' ,";
};
}
$fields=substr($fields, 0, strlen($fields)-1);
$values=substr($values, 0, strlen($values)-1);
$insert=sprintf("insert into %s(%s) values(%s)", $tablename, $fields, $values);
echo "\$db->query(\"$insert\");\n";
}
};
?>