Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.

Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?

[es] :: PHP :: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?

[ Pregleda: 2161 | Odgovora: 12 ] > FB > Twit

Postavi temu Odgovori

Autor

Pretraga teme: Traži
Markiranje Štampanje RSS

SuperC

Član broj: 120719
Poruke: 124
*.9.14.vie.surfer.at.



Profil

icon Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 12:34 - pre 198 meseci
Ovo je greska
Code:
Parse error: syntax error, unexpected $end in C:\wamp\www\052\processes.php on line 584
.

rijec je o login skripti koja koristi index.php za naslovnu pristupnu stranicu, evo koda od index.php

Code:


<?php

error_reporting (E_ALL ^ E_NOTICE);
include 'include/constants.php';
if (!$alert) { $alert = " "; }
if(isset($_COOKIE[CKIEUS]) && isset($_COOKIE[CKIEPS])){
header("Location: processes.php?function=checkusercookie"); }
else {
session_start(); 
if(!isset($_SESSION['username'])){
?>
<style type="text/css">
<!--
.style1 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style2 {font-size: 12px}
#form1 .style6 img {
    border-top-color: #FFFFFF;
    border-right-color: #FFFFFF;
    border-bottom-color: #FFFFFF;
    border-left-color: #FFFFFF;
}
-->
</style>
<title>B und A </title><body bgcolor="#FFFFFF">
<form action="processes.php" method="post" name="form1" class="style1" id="form1">
  <div align="center" class="style6">
    <h1 align="center">Log In</h1>
    <p align="center">
      <?php  echo "<font color=\"#FF0000\">".$alert."</font>"; ?>
    </p>
    <table width="299" border="0" align="center" cellpadding="4" cellspacing="0">
      <tr>
        <td width="41%" height="28"><div align="right">Username : </div></td>
        <td width="59%"><input name="username" type="text" class="textfield" id="username" value=""/></td>
      </tr>
      <tr>
        <td><div align="right">Password : </div></td>
        <td><input name="password" type="password" class="textfield" id="password" value="" /></td>
      </tr>
      <tr>
        <td height="25" colspan="2"><div align="right"><span class="style20 style2">Remember Me For 30 Day's
            <input name="rember" type="checkbox" id="remberme" value="yes" />
        </span></div></td>
      </tr>
      <tr>
        <td colspan="2"></label></td>
      </tr>
      <tr>
        <td colspan="2"><div align="left">
            <p align="right"><span class="style19">
              <input name="function" type="hidden" class="textfield" id="function" value="checkuser" size="50" />
              <input name="Submit" type="submit" class="textfield" value="Submit" />
              </span></p>
            <p align="center"><span class="style16"><a href="forgotpassword.php"><span class="textarea style6 style2">Forgot your password</span></a><span class="textarea style6 style2"> | <a href="register.php">Sign Up</a></span></span></p>
            <p align="left"><a href="docs/scriptby.jpg" ><img src="docs/scriptby.jpg" alt="Click Here" width="151" height="35"></a></p>
        </div>
          <a href="#"><span class="textarea style6 style16">
          <label></label>
          </span></a></td>
      </tr>
    </table>
  </div>
</form>
<span class="style1">
<?

else {
    
    header("Location: main.php"); 

}
}
?>


i onda kada tu unesem recimo username: test i sifru:1234 dobijem gornju gresku u fajlu processes.php, kod je ispod:


Code:



<?php

error_reporting (E_ALL ^ E_NOTICE);
include 'include/constants.php';
$function = $_GET['function']; 
if (!$function) {
$function = $_POST['function']; 
}
if (!$function) {
        header("Location: main.php");
}
########################################################################################################
if ($function == "logout") {
########################################################################################################

error_reporting (E_ALL ^ E_NOTICE);
include 'include/db.php';
session_start();

if(!isset($_REQUEST['logmeout'])){

        $cookie_name = CKIEUS;
        $cookie_value = $_SESSION['username'];
        $cookie_expire = time() - 60*60*24*30;
        
        setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
        
        $cookie_name = CKIEPS;
        $cookie_value = $_SESSION['password'];
        $cookie_expire = time() - 60*60*24*30;
        
        setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
        session_unset();
        session_destroy();

    if(!session_is_registered('first_name')){
?>
<html>
<head>
<style type="text/css">
<!--
.style1 {font-family: Verdana, Arial, Helvetica, sans-serif}
-->
</style>
</head>
<body>
<div align="center" class="style1">
  <h1>Logged Out<br>
  <br></h1>
    
    You are now loged out.<br>
    <br>
    
    You will no longer be remembered on this computer.
    </p>
    
    <br>
    <br>
    <br>
    <a href="index.php">Click here</a> to login again.
    </p>
  
</div>
</body>
</html>
<?
}
}


########################################################################################################
} elseif ($function == "checkusercookie") {
########################################################################################################

   session_start();  

include 'include/constants.php';
include 'include/db.php'; 
$cookieuser = $_COOKIE[CKIEUS];
$cookiepass = $_COOKIE[CKIEPS];
$username = $cookieuser;
$password = $cookiepass;

if((!$username) || (!$password)){
    $alert = "<br>Your browser refused our cookie, you must login again.<br />";
    include 'index.php';
    exit();
}

$sql = mysql_query("SELECT * FROM ".DBTBLE." WHERE username='$username' AND password='$password'");
$login_check = mysql_num_rows($sql);
$row=mysql_fetch_assoc($sql);

    $session_username       = $row['username'];
    $session_first_name     = $row['first_name'];
    $session_last_name      = $row['last_name'];
    $session_email_address  = $row['email_address'];
    $session_info           = $row['info'];
    $session_user_level     = $row['user_level'];
    $session_password       = $row['password'];

if($login_check > 0){
        
        $_SESSION['first_name']    = $session_first_name;
        $_SESSION['last_name']     = $session_last_name;
        $_SESSION['email_address'] = $session_email_address;
        $_SESSION['username']      = $session_username;
        $_SESSION['info']          = $session_info;
        $_SESSION['user_level']    = $session_user_level;
        $_SESSION['password']      = $session_password;
        
        header("Location: main.php");

    }

 else {
    $alert = "<br>The username and password do not match.<br />";
    include 'index.php';
}

########################################################################################################
} elseif ($function == "checkuser") {
########################################################################################################

   session_start();  

include 'include/db.php'; 
$username = $_POST['username'];
$passwordbef = $_POST['password'];
$rember = $_POST['rember'];

if((!$username) || (!$passwordbef)){
    $alert = "<br>You didnt put all you login details in.<br />";
    include 'index.php';
    exit();
}

$password = md5($passwordbef);

$sql = mysql_query("SELECT * FROM ".DBTBLE." WHERE username='$username' AND password='$password'");
$login_check = mysql_num_rows($sql);
$row=mysql_fetch_assoc($sql);

    $session_username       = $row['username'];
    $session_first_name     = $row['first_name'];
    $session_last_name      = $row['last_name'];
    $session_email_address  = $row['email_address'];
    $session_info           = $row['info'];
    $session_user_level     = $row['user_level'];
    $session_password    = $row['password'];

if ($rember == "yes") {
    
        $cookie_name = "".CKIEUS."";
        $cookie_value = $session_username;
        $cookie_expire = time()+60*60*24*30;
        
        setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
        
        $cookie_name = "".CKIEPS."";
        $cookie_value = $session_password;
        $cookie_expire = time()+60*60*24*30;
        
        setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
        
    } 
if($login_check > 0){
        
        $_SESSION['first_name']    = $session_first_name;
        $_SESSION['last_name']     = $session_last_name;
        $_SESSION['email_address'] = $session_email_address;
        $_SESSION['username']      = $session_username;
        $_SESSION['info']          = $session_info;
        $_SESSION['user_level']    = $session_user_level;
        $_SESSION['password']    = $session_password;
        
        header("Location: main.php");

    }

 else {
    $alert = "<br>Username or Password incorrect<br />";
    include 'index.php';
}

########################################################################################################
} elseif ($function == "forgotpasswordprocesschange") {
########################################################################################################

   session_start();  

$pass2 = $_POST['pass2'];
$pass1 = $_POST['pass1'];
$username = $_POST['username'];

if((!$pass1) || (!$pass2))
{
    $alert = "You didnt put all you details in.<br><br/>";
    include 'forgotpassword.php';
    exit();
}
if ($pass1 == $pass2) 
{
$newpassword = md5($pass1);
}
else 
{
$alert =  "Passwords do not match.<br><br/>";
include 'forgotpassword.php'; 
exit();
}
$forgot = "NULL";
include 'include/db.php'; 
$query = "UPDATE ".DBTBLE." SET password = '$newpassword', forgot = '$forgot' WHERE username = '$username'";
mysql_query($query) or die('Error, failed please contact Administrator');  

$url     = "http://".SITURL."/";
$to      = $email;
$subject = 'Password Request';
$message = '

Dear '.$username.',

Your password for the '.$sitename.' has been reset.
    
You may now login using the link below

'.$url.'

If you didnt reset your password please contact the system admin immediatly.

Thanks 

'.$emailfrom.'

';
$headers = 'From: '.EMAlAD.'' . "\r\n" .
    'Reply-To: '.EMAlRP.'' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);

    $alert = "Password has been reset sucessfully, you may now login.<br><br/>";
    include 'index.php';

########################################################################################################
} elseif ($function == "forgotpasswordprocessmail") {
########################################################################################################

$email = $_POST['email'];
$username = $_POST['username'];

if((!$email) || (!$username))
{
    $alert = "You didnt put all you details in.<br><br/>";
    include 'forgotpassword.php';
    exit();
}
include 'include/db.php'; 
$sql = mysql_query("SELECT * FROM ".DBTBLE." WHERE username='$username' AND email_address='$email'");
$check = mysql_num_rows($sql);
if($check > 0){
$check = "userokay";
} else {
$alert =  "Username and email address dont match.<br><br/>";
include 'forgotpassword.php'; 
    exit();
}

function createRandomcode() { 

    $chars = "abcdefghijkmnopqrstuvwxyz023456789"; 
    srand((double)microtime()*1000000); 
    $i = 0; 
    $pass = '' ; 

    while ($i <= 50) { 
        $num = rand() % 33; 
        $tmp = substr($chars, $num, 1); 
        $pass = $pass . $tmp; 
        $i++; 
    } 

    return $pass; 

}  

$password = createRandomcode(); 
$query = "UPDATE ".DBTBLE." SET forgot = '$password' WHERE username='$username' AND email_address='$email'";
mysql_query($query) or die('Error, Check MySql');

$username = $_POST['username'];
$code = $password;
$url     = "http://".SITURL."/forgotpassword.php?username=".$username."&code=".$code."";
$sitename = ''.SITNAM.'';
$emailfrom = ''.EMAlFM.'';

$to      = $email;
$subject = 'Password Request';
$message = '

Dear '.$username.',

Your password for the '.$sitename.' has been requested.
    
To reset your password please follow the link below.

'.$url.'

If you didnt request your password please delete this email.

Thanks 

'.$emailfrom.'

';
$headers = 'From: '.EMAlAD.'' . "\r\n" .
    'Reply-To: '.EMAlRP.'' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);

$alert =  "An email has been sent to you with instructions on how to reset your password.<br><br/>";
include 'index.php'; 
    exit();

########################################################################################################
} elseif ($function == "editpasswordprocess") {
########################################################################################################
   session_start();  

$username = $_SESSION['username'];
$curpass = $_POST['curpass'];
$pass1 = $_POST['pass1'];
$pass2 = $_POST['pass2'];
$current_db = $_SESSION['password'];
if (isset($_COOKIE["".CKIEUS.""]) && isset($_COOKIE["".CKIEPS.""])){
$cookiesarehere = "YES"; }
else {
$cookiesarehere = "NO"; }
$current = md5($curpass);
if((!$pass1) || (!$pass2) || (!$curpass)){
    $alert = "You didnt put all you details in.<br><br/>";
    include 'editpassword.php';
    exit();
}
if ($pass1 == $pass2) {
$newpassword = md5($pass1);
}
else {
$alert =  "Passwords do not match.<br><br/>";
include 'editpassword.php'; 
exit();
}
if ($current == $current_db) {
$securty = 'passed';
}
else {
$alert =  "Current password is incorrect<br><br/>";
include 'editpassword.php';
exit();
}

include 'include/db.php'; 
$query = "UPDATE ".DBTBLE." SET password = '$newpassword' WHERE username = '$username'";
mysql_query($query) or die('Error, failed please contact Administrator');  

        $cookie_name = "".CKIEUS."";
        $cookie_value = $_SESSION['username'];
        $cookie_expire = time() - 60*60*24*30;
        
        setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
        
        $cookie_name = "".CKIEPS."";
        $cookie_value = $_SESSION['password'];
        $cookie_expire = time() - 60*60*24*30;
        
        setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
        session_unset();
        session_destroy();

include 'include/db.php';
session_start();

$sql = mysql_query("SELECT * FROM ".DBTBLE." WHERE username='$username' AND password='$newpassword'");
$login_check = mysql_num_rows($sql);
$row=mysql_fetch_assoc($sql);

    $session_username       = $row['username'];
    $session_first_name     = $row['first_name'];
    $session_last_name      = $row['last_name'];
    $session_email_address  = $row['email_address'];
    $session_info           = $row['info'];
    $session_user_level     = $row['user_level'];
    $session_password       = $row['password'];

if ($cookiesarehere == "YES") {
    
    $cookie_name = "".CKIEUS."";
    $cookie_value = $session_username;
    $cookie_expire = time()+60*60*24*30;
    
    setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
    
    $cookie_name = "".CKIEPS."";
    $cookie_value = $session_password;
    $cookie_expire = time()+60*60*24*30;
    
    setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
    

if($login_check > 0){
        
        $_SESSION['first_name']    = $session_first_name;
        $_SESSION['last_name']     = $session_last_name;
        $_SESSION['email_address'] = $session_email_address;
        $_SESSION['username']      = $session_username;
        $_SESSION['info']          = $session_info;
        $_SESSION['user_level']    = $session_user_level;
        $_SESSION['password']      = $session_password;
        
    $alert = "<br>Password sucessfully changed. <br>";
    include 'main.php';
    
    }

 else {
    $alert = "Password could not be updated<br><br/>";
    include 'main.php';
}
########################################################################################################
} elseif ($function == "adduser") {
########################################################################################################

include 'include/db.php'; 
$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$email_address = $_POST['email_address'];
$username = $_POST['username'];
$info = $_POST['info'];
$pass1 = $_POST['pass1'];
$pass2 = $_POST['pass2'];

if ($pass1 == $pass2) {
$password_checked = $pass1;
}
else {
$alert = "Passwords do not match!";
include 'register.php'; 
exit();
}

if((!$first_name) || (!$last_name) || (!$email_address) || (!$username)){
        $alert =  'You did not submit the following required information. <br />';
    if(!$first_name){
        $alert =  "First Name is a required field. Please enter it below.<br />";
}    if(!$last_name){
        $alert =  "Last Name is a required field. Please enter it below.<br />";
}    if(!$email_address){
        $alert =  "Email Address is a required field. Please enter it below.<br />";
}    if(!$username){
        $alert =  "Desired Username is a required field. Please enter it below.<br />";
}    include 'register.php'; 
    exit();
}

 $sql_username = mysql_query("SELECT username FROM ".DBTBLE." WHERE username = '$username'");
 $username_check = mysql_num_rows($sql_username);

    if($username_check > 0){
         $alert =  "The username you have selected has already been registered by another member in our database. Please choose a different Username!<br />";
     include 'register.php'; 
         exit();
        }
 
$password = md5($password_checked);
$info2 = htmlspecialchars($info);

$query = "INSERT INTO ".DBTBLE." (first_name, last_name, email_address, username, password, info) VALUES ('$first_name', '$last_name', '$email_address', '$username', '$password', '$info2')";
mysql_query($query) or die('Error, failed please contact Administrator);

if(!$query){
    $alert =  'There has been an error creating the account.';
         include 'index.php'; 
}
 else {
     $url     = "http://".SITURL."/";
     $url2     = "http://".SITURL."/forgotpassword.php";
$sitename = ''.SITNAM.'';
$emailfrom = ''.EMAlFM.'';
$alert =  '<strong>Sign up was sucessful, you may now log in.';
include 'index.php'; 

}
########################################################################################################
} elseif ($function == "edituserprocess") {
########################################################################################################
   session_start();  

$first_name = $_POST['first_name'];
$last_name = $_POST['last_name'];
$info = $_POST['info'];
$email_address = $_POST['email_address'];
$username = $_POST['username'];
$password = $_SESSION['password'];
if(isset($_COOKIE["".CKIEUS.""]) && isset($_COOKIE["".CKIEPS.""])){
$cookiesarehere = "YES";
} else {
$cookiesarehere = "NO";
}
include 'include/db.php'; 

$query = "UPDATE ".DBTBLE." SET first_name = '$first_name', last_name = '$last_name', email_address = '$email_address', info = '$info' WHERE username = '$username'";
mysql_query($query) or die('Error, Check MySql'); 

    $cookie_name = "".CKIEUS."";
    $cookie_value = $_SESSION['username'];
    $cookie_expire = time() - 60*60*24*30;
        
        setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
        
        $cookie_name = "".CKIEPS."";
        $cookie_value = $_SESSION['password'];
        $cookie_expire = time() - 60*60*24*30;
        
        setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
        session_unset();
        session_destroy();

include 'include/db.php';
session_start();

$sql = mysql_query("SELECT * FROM ".DBTBLE." WHERE username='$username' AND password='$password'");
$login_check = mysql_num_rows($sql);
$row=mysql_fetch_assoc($sql);

    $session_username       = $row['username'];
    $session_first_name     = $row['first_name'];
    $session_last_name      = $row['last_name'];
    $session_email_address  = $row['email_address'];
    $session_info           = $row['info'];
    $session_user_level     = $row['user_level'];
    $session_password    = $row['password'];

if ($cookiesarehere == "YES") {
    
    $cookie_name = "".CKIEUS."";
    $cookie_value = $session_username;
    $cookie_expire = time()+60*60*24*30;
    
    setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
    
    $cookie_name = "".CKIEPS."";
    $cookie_value = $session_password;
    $cookie_expire = time()+60*60*24*30;
    
    setcookie($cookie_name,$cookie_value,$cookie_expire,"/");
    

if($login_check > 0){
        
        $_SESSION['first_name']    = $session_first_name;
        $_SESSION['last_name']     = $session_last_name;
        $_SESSION['email_address'] = $session_email_address;
        $_SESSION['username']      = $session_username;
        $_SESSION['info']          = $session_info;
        $_SESSION['user_level']    = $session_user_level;
        $_SESSION['password']      = $session_password;
        
    $alert = "<br>Details sucessfully changed. <br>";
    include 'main.php';
    
    }

 else {
    $alert = "Details could not be updated<br><br/>";
    include 'main.php';
}
}
?>



Ovaj drugi fajl ima 580 linija, greska se javlja u 582. liniji

[Ovu poruku je menjao SuperC dana 22.01.2008. u 13:59 GMT+1]
 
Odgovor na temu

Miroslav Ćurčić
ex mVeliki
Novi Sad

Član broj: 19034
Poruke: 1118
*.adsl.beotel.net.



+19 Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:05 - pre 198 meseci
Koristi neki editor sa "highlight" prikazom
pa ćeš videti da u jednoj liniji nisi zatvorio string.
"The quieter you become, the more you are able to hear."
Blog | PowerCMS
 
Odgovor na temu

kazil
Robert Bašić
Full time PHP dev :)
Bačka Topola - Novi Sad

Član broj: 120044
Poruke: 686
*.cable-3.sattrakt.net.

Jabber: robertbasic@elitesecurity.org
ICQ: 446475288
Sajt: robertbasic.com


+2 Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:05 - pre 198 meseci
Citat:
SuperC:
Code:


mysql_query($query) or die('Error, failed please contact Administrator);

?>



taj red ti nije zatvoren:

mysql_query($query) or die('Error, failed please contact Administrator');

fali ti ' na kraju, pre zagrade. trazi oko reda broj 480.
 
Odgovor na temu

SuperC

Član broj: 120719
Poruke: 124
*.9.14.vie.surfer.at.



Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:18 - pre 198 meseci
hvala za uocavanje propustenog znaka ' prije zagrade. bijase red 483 no i dalje imam istu gresku

Code:
Parse error: syntax error, unexpected $end in C:\wamp\www\052\processes.php on line 585


 
Odgovor na temu

kazil
Robert Bašić
Full time PHP dev :)
Bačka Topola - Novi Sad

Član broj: 120044
Poruke: 686
*.cable-3.sattrakt.net.

Jabber: robertbasic@elitesecurity.org
ICQ: 446475288
Sajt: robertbasic.com


+2 Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:27 - pre 198 meseci
koji je ovo kupus od koda... u index.php na jednom mestu php blok pocinjes sa <? umesto sa <?php (mozda ti nije ukljuceno za short open tag ili kako se vec zove). nije mi jasno kako javlja na liniji 585 kad ni nema toliko linija. vidi taj main.php sto prikljucujes, da ne brljavi mozda tamo negde...

edit: inace, unexpected $end se javlja kad se ne zatvori neki if, while... blok sa } znakom. ili imas viska } znakova.
 
Odgovor na temu

SuperC

Član broj: 120719
Poruke: 124
*.9.14.vie.surfer.at.



Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:38 - pre 198 meseci
eh kupus ne kupus, zima je, dobar je kupus :)

Pronadjoh sta je bio uzrok greske, short open tag u Wampserver2.0a pod PHP je bio iskljucen. Problem manje.


-------------


No, kad ukucam username: test i password: 1234 dobijem sljedece: username or password incorrect


mada sam vec ranije definisao:

Code:


<?php
define("DBHOST","localhost");
define("DBUSER","test"); 
define("DBPASS","1234");                           
define("DBNAME","baza");                     
define("DBTBLE","users");   

..          

?> 



 
Odgovor na temu

kazil
Robert Bašić
Full time PHP dev :)
Bačka Topola - Novi Sad

Član broj: 120044
Poruke: 686
*.cable-3.sattrakt.net.

Jabber: robertbasic@elitesecurity.org
ICQ: 446475288
Sajt: robertbasic.com


+2 Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:43 - pre 198 meseci
to sto si ti definisao to je korisnik i njegova sifra za pristup bazi. a u bazi imas jednu tabelu u "users" u kojoj su smesteni korisnici. u toj tabeli trazi podatke za ulogovanje. napravi bazu, u bazi tabelu, u tabelu unesi korisnika test sa 1234 sifrom i onda probaj :)
 
Odgovor na temu

SuperC

Član broj: 120719
Poruke: 124
*.9.14.vie.surfer.at.



Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:49 - pre 198 meseci
Cek malo, ja sam uradio sljedece:

1. Kreirao sam bazu, koja se divnog li cuda zove baza :) onda sam u njoj u sql prozoru ukucao sljedeci kod:

Code:


SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `users` (
  `userid` int(25) NOT NULL auto_increment,
  `first_name` varchar(25) NOT NULL default '',
  `last_name` varchar(25) NOT NULL default '',
  `email_address` varchar(50) NOT NULL default '',
  `username` varchar(25) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `info` varchar(50) NOT NULL,
  `user_level` enum('1','2') NOT NULL default '1',
  `forgot` varchar(100) default NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Membership Information' AUTO_INCREMENT=21 ;



Time sam kreirao tabelu users. Trebam li sada u istoj tabeli unijeti korisnika test sa sifrom 1234 koristeci npr. sljedecu sintaksu:



Code:
INSERT INTO `users` (`userid`, `first_name`, `last_name`, `email_address`, `username`, `password`, `info`, `user_level`, `forgot`) VALUES
(1, 'test', 'test', '[email protected]', 'test', '1234', 'System Admin', '2', 'NULL')


?

=================

Uradio sam kao sto sam gore naveo i kreirao test korisnika sa sifrom 1234 i pokusao se ponovo logirati i dobio istu gresku: Username or Password incorrect
 
Odgovor na temu

kazil
Robert Bašić
Full time PHP dev :)
Bačka Topola - Novi Sad

Član broj: 120044
Poruke: 686
*.cable-3.sattrakt.net.

Jabber: robertbasic@elitesecurity.org
ICQ: 446475288
Sajt: robertbasic.com


+2 Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:51 - pre 198 meseci
INSERT INTO users (userid, first_name, last_name, email_address, username, password, info, user_level, forgot) VALUES
(1, 'test', 'test', '[email protected]', 'test', '1234', 'System Admin', '2', 'NULL')

ovako, ne trebaju ti kukice kod imena polja i imena tabele.
 
Odgovor na temu

dakipro
Dalibor Jovic
Web Developer
Bergen, Norway

Moderator
Član broj: 31848
Poruke: 1792
89.216.108.*

Sajt: norway.dakipro.com


+190 Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 13:58 - pre 198 meseci
"Kukice" ne mogu da ti smetaju, tako da je sigurnije ostaviti ih za slucaj da pogodis neku mysql kljucnu rec da ti nebi pucao upit.
Ako imas korisnika u bazi, tesko je napamet pogoditi zasto ne radi. Ukljuci error reporting na high, pa ces videti gresku (i dosta warning-a i notica).
Kreni redom pa stampaj promenjive koje uporedjujes, i sam ces doci do greske, to je prosti uslov komparacije, tako da nije nesto sto ne bi mogao sam da uradis, ako probas prvo

 
Odgovor na temu

SuperC

Član broj: 120719
Poruke: 124
*.9.14.vie.surfer.at.



Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 14:03 - pre 198 meseci
hvala na tipu, uneseno kako si napisao, no i pored toga nakon unesenog imena i sifre dobijam istu poruku

Username or Password incorrect



Evo upravo sam preko web stranice, registrovao novog korisnika proba/proba i dobio poruku: Sign up was sucessful, you may now log in.

I ukucam proba kao username i proba kao sifru i udjem unutra, hmmmm

 
Odgovor na temu

kazil
Robert Bašić
Full time PHP dev :)
Bačka Topola - Novi Sad

Član broj: 120044
Poruke: 686
*.cable-3.sattrakt.net.

Jabber: robertbasic@elitesecurity.org
ICQ: 446475288
Sajt: robertbasic.com


+2 Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 14:10 - pre 198 meseci
znam sta je! ti si u bazu upisao test kao user i 1234 kao password. a kada proverava prilikom ulogovanja, onda ne proverava na sifru 1234 nego na md5('1234'). zato nije valjalo, a kada si se registrovao preko sajta onda je u tabelu upisao md5 hash od lozinke, a ne lozinku. tako.
 
Odgovor na temu

SuperC

Član broj: 120719
Poruke: 124
*.9.14.vie.surfer.at.



Profil

icon Re: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?22.01.2008. u 14:10 - pre 198 meseci
interesantno je da ne mogu da udjem kao korisnik test i kao admin, ali ako registrujem nekog novog korisnika sa njim mogu.
 
Odgovor na temu

[es] :: PHP :: Parse error: syntax error, unexpected $end in... sta je pogresno ovdje?

[ Pregleda: 2161 | Odgovora: 12 ] > FB > Twit

Postavi temu Odgovori

Navigacija
Lista poslednjih: 16, 32, 64, 128 poruka.