Re: Pear website problem

On 1/4/06, Monjur <monjur.uap@gmail.com> wrote: > Hi, > I'm developing a website with PEAR DB with HTTP authentication. I'm > quite new to PearDB. Please solve this with explanation so that I can > solve my problem. > > Thanks in advance > Monjur. > > ##==================Here is my Code===========================## > <?php > > require_once("Auth.php"); > > $AuthOptions = array( > 'dsn'=>"mysql://uname:upass@localhost/db", > 'table'=>"admin", > 'usernamecol'=>"adminID", > 'passwordcol'=>"password", > 'cryptType'=>"none", > 'db_fields'=>"*" // Collecting Other DB fields > ); > > $a = new Auth_HTTP("DB", $AuthOptions); > > $a->setRealm('Please enter UserName & Password !!!'); > $a->setCancelText('<h2>Authentication Failure</h2>'); > $a->start(); > > if($a->getAuth()) > { > echo "Hello <b>$a->username</b> welcome to your personal page > <BR><BR>"; > echo "<a href=admin.php?action=archive>Archive the database > file</a>"; > if($_GET['action'] == "archive") ArchiveData(); > }; > > function ArchiveData() > { > $doc = new DOMDocument(); > $doc->formatOutput = true; > > $r = $doc->createElement( "parentEle" ); > $doc->appendChild( $r ); > /*-----------------------------Get Data From > DB---------------------------------*/ > // $dbType = "oci8"; > $dbType = "mysql"; > if ($dbType == "mysql"){ > $dsn = $dbType."://root:@localhost/dbName"; > } else { > $dsn = $dbType."://root:password@dbName"; > } > $db = DB::connect($dsn); > if (DB::iserror($db)){ > die($db->getMessage()); > } > $db->setFetchMode(DB_FETCHMODE_ASSOC); > > $qry = $db->query("SELECT * FROM tName"); > if (DB::iserror($qry)){ > die($qry->getMessage()); > } > > while($row = $qry->fetchRow()){ > $parentEle[] = array( > 'bookingref' => "$row[bookingRef]", > 'customerid' => "$row[customerID]", > 'bookingtype' => "$row[bookingType]", > 'typeno' => "$row[typeNo]", > 'startdate' => "$row[startDate]", > 'starttime' => "$row[startTime]", > 'enddate' => "$row[endDate]", > 'endtime' => "$row[endTime]", > 'stationstart' => "$row[stationStart]", > 'stationend' => "$row[stationEnd]", > 'peopleno' => "$row[peopleNo]", > 'netprice' => "$row[netPrice]" > ); > } // END WHILE > $qry->free(); > $db->disconnect(); > /*------------------------------------------------------------------------------*/ > foreach( $activities as $activity ){ > $b = $doc->createElement( "booking" ); > > $bookingref = $doc->createElement( "bookingref" ); > $bookingref->appendChild( > $doc->createTextNode( $activity['bookingref'] ) > ); > $b->appendChild( $bookingref ); > > $customerid = $doc->createElement( "customerid" ); > $customerid->appendChild( > $doc->createTextNode( $activity['customerid'] ) > ); > $b->appendChild( $customerid ); > > $bookingtype = $doc->createElement( "bookingtype" ); > $bookingtype->appendChild( > $doc->createTextNode( $activity['bookingtype'] ) > ); > $b->appendChild( $bookingtype ); > > $typeno = $doc->createElement( "typeno" ); > $typeno->appendChild( > $doc->createTextNode( $activity['typeno'] ) > ); > $b->appendChild( $typeno ); > > $startdate = $doc->createElement( "startdate" ); > $startdate->appendChild( > $doc->createTextNode( $activity['startdate'] ) > ); > $b->appendChild( $startdate ); > > $starttime = $doc->createElement( "starttime" ); > $starttime->appendChild( > $doc->createTextNode( $activity['starttime'] ) > ); > $b->appendChild( $starttime ); > > $enddate = $doc->createElement( "enddate" ); > $enddate->appendChild( > $doc->createTextNode( $activity['enddate'] ) > ); > $b->appendChild( $enddate ); > > $endtime = $doc->createElement( "endtime" ); > $endtime->appendChild( > $doc->createTextNode( $activity['endtime'] ) > ); > $b->appendChild( $endtime ); > > $stationstart = $doc->createElement( "stationstart" ); > $stationstart->appendChild( > $doc->createTextNode( $activity['stationstart'] ) > ); > $b->appendChild( $stationstart ); > > $stationend = $doc->createElement( "stationend" ); > $stationend->appendChild( > $doc->createTextNode( $activity['stationend'] ) > ); > $b->appendChild( $stationend ); > > $peopleno = $doc->createElement( "peopleno" ); > $peopleno->appendChild( > $doc->createTextNode( $activity['peopleno'] ) > ); > $b->appendChild( $peopleno ); > > $netprice = $doc->createElement( "netprice" ); > $netprice->appendChild( > $doc->createTextNode( $activity['netprice'] ) > ); > $b->appendChild( $netprice ); > > $r->appendChild( $b ); > } //END FOREACH > $doc->save("./xmldata/booking.xml"); > } > ?> > ##============================================================## >