Witaj Gościu! ( Zaloguj | Rejestruj )

Forum PHP.pl

> [MySQL][PHP]pobieranie z bazy reflinka
kiepski96
post
Post #1





Grupa: Zarejestrowani
Postów: 233
Pomógł: 0
Dołączył: 22.02.2010

Ostrzeżenie: (0%)
-----

Załóżmy,że w bazie,w polu reflink wkleję jakiegoś reflinka dla wybranego użytkownika to jaki jest kod aby umieścić go w jego panelu,gdy będzie zalogowany i aby widział tego reflinka?

Mniej potrzebna rzecz:
Jak zrobić,aby na stronce po zalogowaniu admina było widać wszystkich użytkowników i aby poprzez panel dodawać te reflinki?
Mój kod panelu admina:
[spoiler]
[PHP] pobierz, plaintext 
  1. <?php
  2.    session_start();
  3.    define('ADMIN_PASS', 'password');
  4.    $mysql_server = '';
  5.    $mysql_username = '';
  6.    $mysql_password = '';
  7.    $mysql_database = '';
  8.    $mysql_table = '';
  9.  
  10.    $admin_password = isset($_COOKIE['admin_password']) ? $_COOKIE['admin_password'] : '';
  11.  
  12.    if (empty($admin_password))
  13.    {
  14.       if (isset($_POST['admin_password']))
  15.       {
  16.          $admin_password = md5($_POST['admin_password']);
  17.          if ($admin_password == md5(ADMIN_PASS))
  18.          {
  19.             setcookie('admin_password', $admin_password);
  20.          }
  21.       }
  22.    }
  23.    $id = isset($_REQUEST['id']) ? $_REQUEST['id'] : '';
  24.    $action = isset($_REQUEST['action']) ? $_REQUEST['action'] : '';
  25.    $username = isset($_POST['username']) ? $_POST['username'] : '';
  26.    $fullname = isset($_POST['fullname']) ? $_POST['fullname'] : '';
  27.    $email = isset($_POST['email']) ? $_POST['email'] : '';
  28.    $active = isset($_POST['active']) ? $_POST['active'] : 0;
  29.  
  30.    $db = mysql_connect($mysql_server, $mysql_username, $mysql_password);
  31.    mysql_select_db($mysql_database, $db);
  32.    if (!empty($action))
  33.    {
  34.       if ($action == 'delete')
  35.       {
  36.          $sql = "DELETE FROM ".$mysql_table." WHERE `username` = '$id'";
  37.          mysql_query($sql, $db);
  38.          mysql_close($db);
  39.          header('Location: '.basename(__FILE__));
  40.          exit;
  41.       }
  42.       else
  43.       if ($action == 'update')
  44.       {
  45.          $crypt_pass = md5($_POST['password']);
  46.          $sql = "UPDATE `".$mysql_table."` SET `username` = '$username', `password` = '$crypt_pass', `fullname` = '$fullname', `email` = '$email', `active` = $active WHERE `username` = '$id'";
  47.          mysql_query($sql, $db);
  48.          mysql_close($db);
  49.          header('Location: '.basename(__FILE__));
  50.          exit;
  51.       }
  52.       else
  53.       if ($action == 'create')
  54.       {
  55.          $sql = "SELECT username FROM ".$mysql_table." WHERE username = '".$_POST['username']."'";
  56.          $result = mysql_query($sql, $db);
  57.          if ($data = mysql_fetch_array($result))
  58.          {
  59.             echo 'User already exists!';
  60.             exit;
  61.          }
  62.          $crypt_pass = md5($_POST['password']);
  63.          $sql = "INSERT `".$mysql_table."` (`username`, `password`, `fullname`, `email`, `active`) VALUES ('$username', '$crypt_pass',  '$fullname', '$email', $active)";
  64.          mysql_query($sql, $db);
  65.          mysql_close($db);
  66.          header('Location: '.basename(__FILE__));
  67.          exit;
  68.       }
  69.       else
  70.       if ($action == 'logout')
  71.       {
  72.          session_unset();
  73.          session_destroy();
  74.          setcookie('admin_password', '', time() - 3600);
  75.          header('Location: '.basename(__FILE__));
  76.          exit;
  77.       }
  78.    }
  79. ?>
  80. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  81. <html>
  82. <head>
  83. <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  84. <title>User administrator</title>
  85. <style type="text/css">
  86. <!--
  87. p
  88. {
  89.    font-size: 11px;
  90.    font-family: Verdana;
  91.    font-weight: normal;
  92.    text-decoration: none;
  93.    color: #000000;
  94. }
  95. th
  96. {
  97.    font-size: 11px;
  98.    font-family: Verdana;
  99.    font-weight: normal;
  100.    text-decoration: none;
  101.    background-color: #BFDBFF;
  102.    color: #006BF5;
  103.    text-align: left;
  104. }
  105. td
  106. {
  107.    font-size: 11px;
  108.    font-family: Verdana;
  109.    font-weight: normal;
  110.    text-decoration: none;
  111.    color: #000000;
  112. }
  113. input, select
  114. {
  115.    font-size: 11px;
  116.    font-family: Verdana;
  117.    font-weight: normal;
  118.    text-decoration: none;
  119.    color: #000000;
  120.    border:1px #000000 solid;
  121. }
  122. -->
  123. </style>
  124. </head>
  125. <body bgcolor="#FFFFFF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
  126. <?php
  127.  
  128.    if ($admin_password != md5(ADMIN_PASS))
  129.    {
  130.       echo "<center>\n";
  131.       echo "<p>User administrator login</p>\n";
  132.       echo "<form method=\"post\" action=\"" .basename(__FILE__) . "\">\n";
  133.       echo "<input type=\"password\" name=\"admin_password\" size=\"20\" />\n";
  134.       echo "<input type=\"submit\" value=\"Login\" name=\"submit\" />\n";
  135.       echo "</form>\n";
  136.       echo "</center>\n";
  137.    }
  138.    else
  139.    {
  140.       if (!empty($action))
  141.       {
  142.          if (($action == 'edit') || ($action == 'new'))
  143.          {
  144.             $sql = "SELECT * FROM ".$mysql_table." WHERE username = '".$id."'";
  145.             $result = mysql_query($sql, $db);
  146.             if ($data = mysql_fetch_array($result))
  147.             {
  148.                $username_value = $data['username'];
  149.                $fullname_value = $data['fullname'];
  150.                $email_value = $data['email'];
  151.                $active_value = $data['active'];
  152.             }
  153.             echo "<center>\n";
  154.             echo "<form action=\"" . basename(__FILE__) . "\" method=\"post\">\n";
  155.             echo "<table border=\"0\">\n";
  156.             if ($action == 'new')
  157.             {
  158.                echo "<input type=\"hidden\" name=\"action\" value=\"create\">\n";
  159.             }
  160.             else
  161.             {
  162.                echo "<input type=\"hidden\" name=\"action\" value=\"update\">\n";
  163.             }
  164.             echo "<input type=\"hidden\" name=\"id\" value=\"". $id . "\">\n";
  165.             echo "<tr><td>Username:</td>\n";
  166.             echo "<td><input type=\"text\" size=\"50\" name=\"username\" value=\"" . $username_value . "\"></td></tr>\n";
  167.             echo "<tr><td>Password:</td>\n";
  168.             echo "<td><input type=\"password\" size=\"50\" name=\"password\" value=\"\"></td></tr>\n";
  169.             echo "<tr><td>Fullname:</td>\n";
  170.             echo "<td><input type=\"text\" size=\"50\" name=\"fullname\" value=\"" . $fullname_value . "\"></td></tr>\n";
  171.             echo "<tr><td>Email:</td>\n";
  172.             echo "<td><input type=\"text\" size=\"50\" name=\"email\" value=\"" . $email_value . "\"></td></tr>\n";
  173.             echo "<tr><td>Active:</td>\n";
  174.             echo "<td><select name=\"active\" size=\"1\"><option " . ($active_value == "0" ? "selected " : "") . "value=\"0\">Not active</option><option " . ($active_value != "0" ? "selected " : "") . "value=\"1\">Active</option></select></td></tr>\n";
  175.             echo "<tr><td>&nbsp;</td><td align=\"left\"><input type=\"submit\" name=\"cmdSubmit\" value=\"Save\">";
  176.             echo "&nbsp;&nbsp;";
  177.             echo "<input type=\"reset\" name=\"cmdReset\" value=\"Reset\">&nbsp;&nbsp;";
  178.             echo "<input type=\"button\" name=\"cmdBack\" value=\"Back\" onclick=\"location.href='" . basename(__FILE__) . "'\"></td></tr>\n";
  179.             echo "</table>\n";
  180.             echo "</form>\n";
  181.             echo "</center>\n";
  182.          }
  183.       }
  184.       else
  185.       {
  186.          echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">\n";
  187.          echo "<tr><th>Username</th>\n";
  188.          echo "<th>Fullname</th>\n";
  189.          echo "<th>Email</th>\n";
  190.          echo "<th>Active</th>\n";
  191.          echo "<th>Action</th></tr>\n";
  192.  
  193.          $sql = "SELECT * FROM ".$mysql_table;
  194.          $result = mysql_query($sql, $db);
  195.          while ($data = mysql_fetch_array($result))
  196.          {
  197.             echo "<tr>\n";
  198.             echo "<td>" . $data['username'] . "</td>\n";
  199.             echo "<td>" . $data['fullname'] . "</td>\n";
  200.             echo "<td>" . $data['email'] . "</td>\n";
  201.             echo "<td>" . ($data['active'] == "0" ? "not active" : "active") . "</td>\n";
  202.             echo "<td>\n";
  203.             echo "   <a href=\"" . basename(__FILE__) . "?action=edit&id=" . $data['username'] . "\">Edit</a> | \n";
  204.             echo "   <a href=\"" . basename(__FILE__) . "?action=delete&id=" . $data['username'] . "\">Delete</a>\n";
  205.             echo "</td>\n";
  206.             echo "</tr>\n";
  207.          }
  208.          echo "</table>\n";
  209.          echo "<p><a href=\"" . basename(__FILE__) . "?action=new\">Create new user</a>&nbsp;&nbsp;<a href=\"" . basename(__FILE__) . "?action=logout\">Logout</a></p>\n";
  210.       }
  211.    }
  212.  
  213. ?>
  214. </body>
  215. </html>
[PHP] pobierz, plaintext
[/spoiler]

Proszę o pomoc.

To pomoże ktoś?
Go to the top of the page
+Quote Post

Posty w temacie
- kiepski96   [MySQL][PHP]pobieranie z bazy reflinka   27.04.2010, 09:27:29

« Następny starszy · Przedszkole · Następny nowszy »
 

Reply to this topicStart new topic
1 Użytkowników czyta ten temat (1 Gości i 0 Anonimowych użytkowników)
0 Zarejestrowanych:

 

Tryb wyświetlania: Przełącz na: Standardowy · Przełącz na: Linearny+ · Drzewo

Śledź ten temat · Wyślij temat na e-mail · Wydrukuj ten temat · Subskrybuj to forum

RSS Aktualny czas: 19.08.2025 - 19:54
Powered By IP.Board © 2025  IPS, Inc.
All changes by PHP.pl Administrators
Hosting zapewnia NQ.pl hosting, trac, svn