Results 1 to 6 of 6

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User emagi's Avatar
    Join Date: Feb:2007
    Location: bulgaria
    Posts: 202

    Ãðåøêà:Resource id #3

    Çäðàâåéòå!
    Äíåñ ñòèãíàõ äî ìàëêî ïî-ñëîæíè "çàäà÷êè-çàêà÷êè"
    Èñêàì ïîòðåáèòåë,÷èåòî ïîòðåáèòåëñêî èìå è ïàðîëà èìàì â áàçà äàííè ,äà ìîæå äà ïîëó÷àâà äîñòúï äî ñàéò!
    Äàíî òîçè ïúò âúïðîñà ìè íå å "ãëóïàâ" èëè ïðåêàëåíî åëåìåíòàðåí
    Òà ïðîáâàõ äíåñ êàêâî ëè íå,íî íå ñòàâà è íå ñòàâà!Äàâà ìè ãðåøêà:Resource id #3
    Åòî ãî è ñêðèïòà:
    Code:
    <!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=utf-8" />
    <title>Untitled Document</title>
    <style type="text/css">
    <!--
    body,td,th {
    	color: #FFFF00;
    }
    body {
    	background-color: #333333;
    }
    -->
    </style></head>
    
    <body>
    <?php
     if (isset($_POST['login']))
     {    
     	@$uname = trim($_POST['uname']);
     	@$pass = md5(trim($_POST['pass']));
     	
          $conn = mysql_pconnect('localhost','root','root') or die ("Can not connect MYSQL");
     	mysql_select_db('dostyp') or die ("Can not connect database");
     	$query = mysql_query("select * from potrebiteli where ime='$uname' and pass = '$pass' LIMIT 1");
     	  echo $query;
     	 if (mysql_num_rows($query) == 0)
     	{
            echo '<h1>Go Away</h1>';
           }
           else{
           echo '<h1>Here It Is</h1>';
           }
     	
    }
          
    ?>
    <div align="center"><form id="form1" name="form1" method="post" action="">
      <fieldset>
      <label><h3>username:</h3></label>
      <input name="uname" type="text" />
      </fieldset><fieldset><label><h3>password</h3></label>
      <input name="pass" type="password" /></fieldset>
      <fieldset>
      <input name="login" type="submit" value="LogIn" /></fieldset>
      </form>
      </div>
      </body>
    </html>
    Íÿêîé ìîæå ëè äà êàæå â êàêâî ãðåøà???Ïðîâàõ è ñ âàðèàíòà if mysql_fetc_array($query) ==0íî è òàêà íå ñòàíà!
    Ìîæå áè ùå òðÿáâà äà ñå ïðîáâà ñ while....../?????

  2. #2
    philosophus duratea icaci's Avatar
    Join Date: Oct:2006
    Location: Aachen
    Posts: 2,698
    mysql_query âðúùà ðåñóðñåí èäåíòèôèêàòîð, êîãàòî çàÿâêàòà íå å ïðîñòî INSERT èëè UPDATE (òîãàâà âðúùà ïðîñòî TRUE/FALSE). Òè êàêâî î÷àêâàø äà òè èçâåäå echo, ñëåä êàòî â $query ñå ñúäúðæà ðåñóðñ?
    Internet - it doesn't make you stupid, it just makes your stupidity more accessible to others

  3. #3
    Registered User emagi's Avatar
    Join Date: Feb:2007
    Location: bulgaria
    Posts: 202
    Ìåðñè!
    Òîâà íå ãî çíàåõ,íî â êðàéíà ñìåòêà çà ñåãà íåìîãà äà ïîñòèãíà òîâà,êîåòî èñêàì!Ùå ïðîäúëæàâàì äà ïðîáâàì!

  4. #4
    philosophus duratea icaci's Avatar
    Join Date: Oct:2006
    Location: Aachen
    Posts: 2,698
    Ùîì mysql_query òè âðúùà ðåñóðñ, òî mysql_num_rows ñëåäâà äà òè âúðíå áðîÿ íà ðåäîâåòå, ïîëó÷åíè â ðåçóëòàò íà çàÿâêàòà.
    Internet - it doesn't make you stupid, it just makes your stupidity more accessible to others

  5. #5
    Registered User emagi's Avatar
    Join Date: Feb:2007
    Location: bulgaria
    Posts: 202
    Ñåãà ïðîáâàì ïî ñëåäíèÿ íà÷èí:
    Code:
    $query = "select count(*) from auth where name = '$name' and pass = password('$password')";
    $result = mysql_query($query);
    if(!$result)
    {
    echo 'Cannot run query.';
    exit;
    }
    
    $count = mysql_result( $result, 0, 0 );
    
    if ( $count > 0 )
    {
    // visitor's name and password combination are correct
    echo '<h1>Here it is!</h1>';...........
    Íî ìíîãî èíòåðåñíî ñòàâà. êîíçîëàòà ïèøà ñúîòâåòíî:
    Code:
    mysql> insert into auth values ('pavel', password('test'));
    Query OK, 1 row affected, 1 warning (0.00 sec)
    mysql> select * from auth;
    +----------+--------------------------------------------------+
    |  name     |                           pass                                      |
    +----------+--------------------------------------------------+
    | user       |                                 pass                                 |
    | testuser |            *3A2EB9C80F7239A4DE3933AE266DB           |
    | pavel     |             *D85B0232C893576977334B024F60F           |
    +----------+--------------------------------------------------+
    
    mysql> select count(*) from auth where name="pavel";
    +----------+
    | count(*) |
    +----------+
    |        1     |
    +----------+
    1 row in set (0.00 sec)
    
    mysql> select count(*) from auth where name="pavel" and pass = password('test');
    +----------+
    | count(*) |
    +----------+
    |        0 |
    +----------+
    1 row in set (0.00 sec)
    [b]Íå ìîãà äà ðàçáåðà,çàùî áåç ïàðîëàòà äàâà ðåçóëòàò "1",à ñ íåÿ "0"?????
    P.S.Ñòàíà!Ïðîáëåìà å áèë â ãîëåìèòàòà íà ïîëåòî pass.Ïðè ìåí áåøå (30) e òðÿáâàëî îùå 11!
    Last edited by emagi; 29th September 2007 at 12:09.

  6. #6
    ****** koshera's Avatar
    Join Date: Sep:2003
    Location: Sammamish, WA, USA
    Posts: 1,507
    Åäèí ñúâåò îò ìåí.Èçáÿãâàé äà ïèøåø "select * ... " , êîãàòî èñêàø äà èçâëå÷åø íåùî îò áàçàòà.Âèíàãè èçâëè÷àé ñàìî íåùàòà, êîèòî òè òðÿáâàò. Çíàì ÷å òàêà òè å ïî-ëåñíî â ìîìåíòà, íî êîãàòî òè ñå íàëîæè äà ïèøåø ïî-ñëîæíè çàÿâêè ùå ìå ðàçáåðåø. Ïðîñòî îò ñåãà ñâèêâàé äà èçáÿãâàø çâåçäàòà.
    È îùå íåùî - íå áúðçàé äà ïèòàø è äà ÷àêàø íà ãîòîâî, íÿêîé äà òè äåáúãâà êîäà è äà òè êàçâà êúäå ñà òè ãðåøêèòå. Ïîìú÷è ñå íÿêîëêî äåíà ñàì. Ðîâè÷êàé, òúðñè àìà ñè ãî îïðàâè ñàì. Îòíîâî ñàìî ùå òè å â ïîëçà. ×àê êîãàòî ñè ñå ñïåêúë äî ñòåïåí ïîñèíÿâàíå, òîãàâà ñè èçëåé ìúêàòà
    Thåre are 10 kinds of people in this world - people who know binary, and those who don't.
     ñúîòíîøåíèå öåíà-êà÷åñòâî, áèðàòà íà àâàíòà íÿìà êîíêóðåíöèÿ.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè