X-Git-Url: http://git.pjr.cc/?a=blobdiff_plain;f=lib%2Fdb.php;h=6c6a4d57ebd08a1c4a9246f2889f24352ab3c468;hb=fd8bc263bd1e3923c94f949059d90d93b5faaf76;hp=e7afc6e3c5453b508131a0995b4495cd7fb78ce8;hpb=671b623794ad8bd9d8a57f28436a46a62b12ef66;p=PHPIPManager.git diff --git a/lib/db.php b/lib/db.php index e7afc6e..6c6a4d5 100644 --- a/lib/db.php +++ b/lib/db.php @@ -30,9 +30,35 @@ class db { error_log("db open for init"); $this->init(); } + } public $dbobject = ""; + + function dump() { + $sql = "select * from supernet"; + $res = $this->dbobject->query($sql); + + foreach($res as $row) { + echo "sn:".$row["sn_id"].":".$row["sn_name"].":".$row["sn_ip"].":".$row["sn_mask"].":".$row["sn_desc"]."\n"; + } + $sql = "select * from subnet"; + $res = $this->dbobject->query($sql); + + foreach($res as $row) { + echo "sbn:".$row["sn_id"].":".$row["snid_id"].":".$row["sn_name"].":".$row["sn_ip"].":".$row["sn_mask"].":".$row["sn_desc"]."\n"; + } + $sql = "select * from hosts"; + $res = $this->dbobject->query($sql); + + foreach($res as $row) { + echo "hst:".$row["ho_id"].":".$row["ho_sn_id"].":".$row["ho_ip"].":".$row["ho_name"].":".$row["ho_desc"]."\n"; + } + } + + function restore($restorefile) { + + } }