X-Git-Url: http://git.pjr.cc/?p=PHPIPManager.git;a=blobdiff_plain;f=lib%2Fdb.php;h=05216dc56c92b3d53d520376c811be805c2237d2;hp=e7afc6e3c5453b508131a0995b4495cd7fb78ce8;hb=46533a511551e2d0f41434adbcaff4d2f057a0ab;hpb=671b623794ad8bd9d8a57f28436a46a62b12ef66 diff --git a/lib/db.php b/lib/db.php index e7afc6e..05216dc 100644 --- a/lib/db.php +++ b/lib/db.php @@ -33,6 +33,31 @@ class db { } 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) { + + } }