ratisp

ISP configuration panel
git clone http://git.code.weiherhei.de/ratisp.git
Log | Files | Refs | README

domain.php (1544B)

      1 <?php
      2 
      3 
      4 if	( ! $stmtDomains = $db->prepare("SELECT name FROM domain WHERE owner=?") ) {echo "Query failed: (" . $mysqli->errno . ") " . $mysqli->error;}
      5 
      6 $stmtDomains->bind_param('s',$user);
      7 $user=$_SESSION['user'];
      8 
      9 $stmtDomains->execute();
     10 
     11 $stmtDomains->bind_result($domainName);
     12 
     13 ?><div class="container"><h1>Domains</h1><?php 
     14 ?><ul><?php 
     15 while( $stmtDomains->fetch() )
     16 {
     17 	echo '<li>'.$domainName.'</li>';
     18 }
     19 ?></ul><?php
     20 ?></div><?php
     21 
     22 ?>
     23 
     24 
     25 
     26 ?><div class="container"><h1>Subdomains</h1><?php 
     27 ?><ul><?php
     28 $stmtRecords = $db->prepare("SELECT subdomain_name FROM domain_record WHERE domain_name IN (SELECT domain_name FROM domain WHERE owner=?)");
     29 $stmtRecords->bind_param('s',$user);
     30 $user=$_SESSION['user'];
     31 
     32 // $stmtMailbox = $db->prepare("SELECT local_part, domain_name FROM mailbox WHERE domain_name IN (SELECT domain_name FROM domain WHERE owner=?)");
     33 // $stmtMailbox->bind_param('s',$user);
     34 
     35 $stmtRecords->execute();
     36 $stmtRecords->bind_result($subDomain);
     37 
     38 while( $stmtRecords->fetch() )
     39 {
     40 	echo '<li>'.$subDomain.'</li>';
     41 }
     42 ?></ul><?php
     43 ?></div><?php
     44 
     45 
     46 
     47 
     48 
     49 ?><div class="container"><h1>Mailbox</h1><?php
     50 ?><ul><?php
     51 
     52 $stmtMailbox = $db->prepare("SELECT local_part, domain_name FROM mailbox WHERE domain_name IN (SELECT domain_name FROM domain WHERE owner=?)");
     53 $stmtMailbox->bind_param('s',$user);
     54 $user=$_SESSION['user'];
     55 
     56 $stmtMailbox->bind_result($mailboxLocal,$mailboxDomain);
     57 $stmtMailbox->execute();
     58 while( $stmtMailbox->fetch() )
     59 {
     60 	echo '<li>'.$mailboxLocal.'@'.$mailboxDomain;
     61 	echo '</li>';
     62 }
     63 	
     64 ?></ul><?php
     65 ?></div><?php
     66