API tools faq
paste
Advertisement
kajacx

DB ukol

kajacx
Nov 7th, 2012
219
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 5.39 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3.  
  4. class MysqlDataShower {
  5.   private $res;
  6.  
  7.   public function __construct($res) {
  8.     $this->res = $res;
  9.   }
  10.  
  11.   public function showInTable() {
  12.     $data = array();
  13.     while($row = $this->res->fetch_assoc()) {
  14.       $data[] = $row;
  15.     }
  16.     if(count($data)==0) {
  17.       return "&lt;empty>";
  18.     }
  19.     $out = "<table>\n<tr>\n";
  20.     foreach($data[0] as $key => $value) {
  21.       $out .= "<td><strong>$key</strong></td>\n";
  22.     }
  23.     foreach($data as $one) {
  24.       $out .= "</tr>\n<tr>\n";
  25.       foreach($one as $two) {
  26.         if($two==null) $two = "&lt;null>";
  27.         $out .= "<td>$two</td>\n";
  28.       }
  29.     }
  30.     return $out . "</tr>\n</table>";
  31.   }
  32. }
  33. /*
  34. class TeaCompany {
  35.   private $mysqli;
  36.  
  37.   public function __construct() {
  38.     $this->mysqli = new mysqli("vyuka.pslib.cz", "P4", "p4", "P4");
  39.    
  40.     $this->mysqli->set_charset("utf8");
  41.    
  42.     if ($this->mysqli->connect_errno) {
  43.         echo $mysqli->connect_error;
  44.         die("\n</body>\n</html>");
  45.     }
  46.    
  47.   }
  48.  
  49.   public function cajovnici() {
  50.     $res = $this->mysqli->query("SELECT celeJmeno, cisloCertifikatu FROM HrkalCajovnik ".
  51.     "LEFT JOIN HrkalCajovyMister ON idCajovnik=idMister");
  52.    
  53.     $data = array();
  54.     while($row = $res->fetch_assoc()) {
  55.       $data[] = $row;
  56.     }
  57.     return $data;
  58.   }
  59.  
  60.   public function doTabulky($class_name = "talbe1") {
  61.     $data = $this->cajovnici();
  62.    
  63.     $out = "<table class=\"$class_name\">\n";
  64.     foreach($data as $one)
  65.     {
  66.       $mis = $one["cisloCertifikatu"]!=null ? "mistr" : "noob";
  67.       $out .= "<tr>\n";
  68.       $out .= "<td class=\"$mis\">".$one["celeJmeno"]."</td>\n";
  69.       //$out .= "<td>$mis</td>\n";
  70.       $out .= "</tr>\n";
  71.     }
  72.     $out .= "</table>\n";
  73.     return $out;
  74.   }
  75.  
  76. }
  77. */
  78.  
  79. function get($name, $defVal = false) {
  80.   if(isset($_GET[$name])) {
  81.     return $_GET[$name];
  82.   }
  83.   return $defVal;
  84. }
  85.  
  86. function session($name, $defVal = false) {
  87.   if(isset($_SESSION[$name])) {
  88.     return $_SESSION[$name];
  89.   }
  90.   return $defVal;
  91. }
  92.  
  93. $delimitier = "784;_;_;18475264859;_;_;51";
  94.  
  95. $method = "get";
  96.  
  97. if($method("hardReset")) {
  98.   session_unset();
  99. }
  100.  
  101. $names = array("server", "username", "password", "databaseName");
  102.  
  103. $connect = false;
  104.  
  105. if($sesData1 = session("connection")) {
  106.   $inData1 = explode($delimitier, $sesData1);
  107.   $connect = true;
  108. } else {
  109.   $inData1 = array($method($names[0]), $method($names[1]), $method($names[2]), $method($names[3]));
  110. }
  111.  
  112. $error = "";
  113. $connected = false;
  114. if($method("con") || $connect){
  115.   $mysqli = new mysqli($inData1[0], $inData1[1], $inData1[2], $inData1[3]);
  116.   $mysqli->set_charset("utf8");
  117.  
  118.   if($mysqli->connect_errno) {
  119.     $error = $mysqli->connect_error . "<br>\n";
  120.   } else {
  121.     $connected = true;
  122.     $_SESSION["connection"] = implode($delimitier, $inData1);
  123.   }
  124. }
  125.  
  126. $table = $method("table");
  127. $order = $method("order");
  128.  
  129. ?>
  130.  
  131. <!DOCTYPE html
  132.      PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  133.      "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  134. <html xmlns="http://www.w3.org/1999/xhtml">  
  135.   <head>  
  136.     <meta http-equiv="content-type" content="text/html; charset=utf-8">  
  137.     <meta name="generator" content="PSPad editor, www.pspad.com">  
  138.     <link rel="stylesheet" type="text/css" href="mysql_css.css">
  139.     <title>Super MySQL</title>  
  140.   </head>  
  141.   <body>
  142.     <?php
  143.     echo "\n";
  144.    
  145.     if(!$connected) {
  146.    
  147.       if($method("reset")) {
  148.         unset($_GET);
  149.         unset($_POST);
  150.       }
  151.      
  152.       echo $error;
  153.       echo "<form method=\"$method\" action=\"".$_SERVER["PHP_SELF"]."\">\n";
  154.       echo "<table>\n";
  155.       foreach($names as $name) {
  156.         echo "<tr>\n";
  157.         echo "<td>$name</td>\n";
  158.         echo "<td><input name=\"$name\" value=\"".$method($name)."\"/></td>\n";
  159.         echo "</tr>\n";
  160.       }
  161.       echo "<tr>\n";
  162.       echo "<td><input type=\"submit\" name=\"con\" value=\"Connect\"/>";
  163.       echo "<td><input type=\"submit\" name=\"reset\" value=\"Reset\"/>";
  164.       echo "</tr>\n";
  165.       echo "</table>\n</form>";
  166.      
  167.     } else {
  168.    
  169.       $res = $mysqli->query("SHOW TABLES");
  170.      
  171.       $names = array();
  172.      
  173.       while($row = $res->fetch_array()) {
  174.         $names[] = $row[0];
  175.       }
  176.      
  177.       echo "<form method=\"$method\" action=\"".$_SERVER["PHP_SELF"]."\">\n";
  178.       echo "<select name=\"table\">\n";
  179.       foreach($names as $name) {
  180.         $selected = $name==$table ? " selected=\"selected\"" : "";
  181.         echo "<option value=\"$name\"$selected>$name</option>\n";
  182.       }
  183.       echo "</select>\n<br/>\n";
  184.       echo "Order by: ";
  185.       echo "<input name=\"order\" value=\"$order\"/>\n<br/>\n";
  186.       echo "<input type=\"submit\" name=\"sel\" value=\"Select\"/>";
  187.      
  188.       //$mysqli = new mysqli("vyuka.pslib.cz", "P4", "p4", "P4");
  189.      
  190.      
  191.       if($table) {
  192.      
  193.         echo "\n<br/>\n";
  194.        
  195.         if($order) {
  196.           $table .= " ORDER BY $order";
  197.         }
  198.        
  199.         $res = $mysqli->query("SELECT * FROM $table");
  200.        
  201.         echo $mysqli->error;
  202.        
  203.         $shower = new MysqlDataShower($res);
  204.         echo $shower->showInTable();
  205.       }
  206.      
  207.     }
  208.    
  209.    
  210.     echo "<br/>\n";
  211.     echo "<form method=\"$method\" action=\"".$_SERVER["PHP_SELF"]."\">\n";
  212.     echo "<input type=\"submit\" value=\"Reset all\" name=\"hardReset\"/>\n";
  213.     echo "</form>";
  214.     ?>
  215.    
  216.   </body>
  217. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!