Jump to content
php.lv forumi

FT3

Reģistrētie lietotāji
 View Profile  See their activity

  • Posts

    183

  • Joined

  • Last visited

 Content Type 

Posts posted by FT3

  4. help

    in Draza

    Posted · Edited by FT3

    Man vjg parveidot kodu

    ka lai ustajsa lai ņemtu lietotajus no table users un raditu cik ir online

    re kods 

    <?php
include_once('includes/db_connect.php'); 

$guests = '';
$users = '';

$link = mysql_connect($INFO['sql_host'],$INFO['sql_user'],$INFO['sql_pass']);
mysql_query('use '.$INFO['sql_database'].';');

$now = time()-1050;
$result = mysql_query('select count(*) from '.$INFO['sql_tbl_prefix'].'sessions where member_id = 0 && running_time > '.$now.';');
$r = mysql_fetch_array($result);
if ($r[0]>0) { $guests = $r[0]; } else { $guests = 0; }

$result = mysql_query('select count(*) from '.$INFO['sql_tbl_prefix'].'sessions where member_id > 0 && running_time > '.$now.';');
$r = mysql_fetch_array($result);
if ($r[0]>0) { $users = $r[0]; } else { $users = 0; }

echo 'Lietotāji ('.$users.'), Viesi ('.$guests.')';

mysql_close($link);
?>

  6. wtf

    in Draza

    Posted

    viss kods tagad iskatas ta 

    <?php
include("db_connect.php");

if(isset($_GET['UserID']))
{
$id = $_GET['UserID'];

$query = "SELECT * FROM users WHERE UserID = '$id'"

$result = mysql_query($query) or die(mysql_error());


$row = mysql_fetch_array($result) or die(mysql_error());
echo "Username:";
echo $row['username'];
echo "<br />";
echo "Your password:";
echo $row['password'];
echo "<br />";
echo "Your E-mail:";
echo $row['email'];
echo "<br />";
echo "Your name:";
echo $row['name'];

}

?>
<br>
[<a href="logout.php">Logout</a>]

    bet rada eroru

    Parse error: syntax error, unexpected T_VARIABLE in C:\AppServ\www\v2\includes\user_cp.php on line 10

  9. wtf

    in Draza

    Posted

    Visu ustajsiju ka nakas bet rada tukša lap wtf ?

    PhpMyAdmin

    afvd0ugtsf3ncj4kdc1q_thumb.gif

     

    userinfo.php

    <?php
include("includes/db_connect.php");

if(isset($_GET['UserID']))
{
$id = $_GET['UserID'];

$query = "SELECT * FROM users WHERE id = '$id'";

$result = mysql_query($query) or die(mysql_error());


$row = mysql_fetch_array($result) or die(mysql_error());
echo "Username:";
echo $row['Username'];
echo "<br />";
echo "Your password:";
echo $row['Password'];
echo "<br />";
echo "Your E-mail:";
echo $row['EmailAddress'];
echo "<br />";
echo "Your name:";
echo $row['Name'];

}

?>
<br>
[<a href="logout.php">Logout</a>]

     

    ka lai izlabo ? :/

  10. help

    in Draza

    Posted · Edited by FT3

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\AppServ\www\v3\index.php:1) in C:\AppServ\www\v3\index.php on line 2 kas pa eroru ? :?

  12. Php+mysql

    in Vispārēji

    Posted 

    <?
include("db_connect.php");
session_start();
if(!session_is_registered(myusername)){
header("location:index.php");
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
<title></title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>
<div id=border>
<div id=content>
<div id=logo></div>
<div id=navigation>
<ul>
<li><a href="index_success.php">Главная</a></li>
<li><a href="index_success.php">Информация</a></li>
<li><a href="index_success.php">Файловы Архив</a></li>
</ul>
</div>
<div id=line> </div>

<div id=page>
   <td class="row1" align="left" width="100%">
     <font size="2px">
<?php include("allusers.php"); ?>
     <span class="gensmall">
<div class="hrr">
</div><div style="background-color: #888;"><font size="1px">
</div>
</font>
:D
     </span>
   </td>
 </tr>
<BR /></div>

<div id=panel-l>

<style>
.img_border {
  padding:1px;
  border:1px solid #021a40;
  background-color:#fffff;
 } 

 table.center {margin-left:auto; margin-right:auto;}

</style>
<table class='center' border='0' cellspacing='0' cellpadding='0'>
<h2>Сервер</h2>
:D
</table> 
<h2>ПУСТО</h2>
:D
</div>

<div id=panel-r>
<h2>Вход | Инфо</h2>
<?php include("user_info.php"); ?>
       <br>
<h2>Чят</h2>
:D
<br>
<h2>Статистика</h2>
:D
</div>
</div>
</div>
<br>
<center>
<img src="http://www.lighttpd.net/images/xcache.png" />  <img src="http://www.lighttpd.net/php_power.png" />
<br>
:D
</center>
<br>
</body>
</html>

  14. Php+mysql

    in Vispārēji

    Posted

    mans checklogin.php fails

    <?php
include("db_connect.php");

// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];

// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:index_success.php");
}
else {
echo "Wrong Username or Password";
}
?>

     

    mans user_info.php fails

    <?php
include("db_connect.php");

$query = "SELECT * FROM members WHERE id=".$_SESSION['member_id']."";

$result = mysql_query($query) or die(mysql_error());


$row = mysql_fetch_array($result) or die(mysql_error());
echo "Username:";
echo $row['username'];
echo "<br />";
echo "Your password:";
echo $row['password'];
echo "<br />";
echo "Your E-mail:";
echo $row['email'];
echo "<br />";
echo "Your name:";
echo $row['name'];

?>
<br>
[<a href="logout.php">Logout</a>]

    un ka lai tos kodus apvieno ;/

  15. Php+mysql

    in Vispārēji

    Posted · Edited by FT3

    zinatnieks , nepareiz taja ko tu iedevi kodu rada visus userus, bet man vjg lai raditu tikai ta ar ko tu ienaici :/

    bet ir viens variants kuru man iedeva "daviskrex" 

    $_SESSION['user_id'] = $row['id'];

$id = $_SESSION['user_id'];
SELECT * FROM users WHERE id=$id

    bet es viņu nevaru savienot ar savu kodu ;/

  17. Php+mysql

    in Vispārēji

    Posted

    Labdien.

    Krč ir tada lieta uzkodeju kodu bet ir viena problema kad ienak caur login systemu rada tik pirma lietotaja datus ka lai izlabot ?

    <?php
include("db_connect.php");

$query = "SELECT * FROM members";

$result = mysql_query($query) or die(mysql_error());


$row = mysql_fetch_array($result) or die(mysql_error());
echo "Username:";
echo $row['username'];
echo "<br />";
echo "Your password:";
echo $row['password'];
echo "<br />";
echo "Your E-mail:";
echo $row['email'];
echo "<br />";
echo "Your name:";
echo $row['name'];

?>
<br>
[<a href="logout.php">Logout</a>]

     

     

    Ierriekš paldies ;]]

×
×
  • Create New...