Results 1 to 6 of 6
Thread: Ãðåøêà:Resource id #3
Hybrid View
-
28th September 2007 23:18 #1
Ãðåøêà:Resource id #3
Çäðàâåéòå!
Äíåñ ñòèãíàõ äî ìàëêî ïî-ñëîæíè "çàäà÷êè-çàêà÷êè"
Èñêàì ïîòðåáèòåë,÷èåòî ïîòðåáèòåëñêî èìå è ïàðîëà èìàì â áàçà äàííè ,äà ìîæå äà ïîëó÷àâà äîñòúï äî ñàéò!
Äàíî òîçè ïúò âúïðîñà ìè íå å "ãëóïàâ" èëè ïðåêàëåíî åëåìåíòàðåí
Òà ïðîáâàõ äíåñ êàêâî ëè íå,íî íå ñòàâà è íå ñòàâà!Äàâà ìè ãðåøêà:Resource id #3
Åòî ãî è ñêðèïòà:Íÿêîé ìîæå ëè äà êàæå â êàêâî ãðåøà???Ïðîâàõ è ñ âàðèàíòà if mysql_fetc_array($query) ==0íî è òàêà íå ñòàíà!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>
Ìîæå áè ùå òðÿáâà äà ñå ïðîáâà ñ while....../?????
-
28th September 2007 23:27 #2
mysql_query âðúùà ðåñóðñåí èäåíòèôèêàòîð, êîãàòî çàÿâêàòà íå å ïðîñòî INSERT èëè UPDATE (òîãàâà âðúùà ïðîñòî TRUE/FALSE). Òè êàêâî î÷àêâàø äà òè èçâåäå echo, ñëåä êàòî â $query ñå ñúäúðæà ðåñóðñ?
Internet - it doesn't make you stupid, it just makes your stupidity more accessible to others
-
28th September 2007 23:29 #3
Ìåðñè!
Òîâà íå ãî çíàåõ,íî â êðàéíà ñìåòêà çà ñåãà íåìîãà äà ïîñòèãíà òîâà,êîåòî èñêàì!Ùå ïðîäúëæàâàì äà ïðîáâàì!
-
28th September 2007 23:35 #4
Ùîì mysql_query òè âðúùà ðåñóðñ, òî mysql_num_rows ñëåäâà äà òè âúðíå áðîÿ íà ðåäîâåòå, ïîëó÷åíè â ðåçóëòàò íà çàÿâêàòà.
Internet - it doesn't make you stupid, it just makes your stupidity more accessible to others
-
29th September 2007 01:03 #5
Ñåãà ïðîáâàì ïî ñëåäíèÿ íà÷èí:
Íî ìíîãî èíòåðåñíî ñòàâà. êîíçîëàòà ïèøà ñúîòâåòíî: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>';...........
[b]Íå ìîãà äà ðàçáåðà,çàùî áåç ïàðîëàòà äàâà ðåçóëòàò "1",à ñ íåÿ "0"?????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)
P.S.Ñòàíà!Ïðîáëåìà å áèë â ãîëåìèòàòà íà ïîëåòî pass.Ïðè ìåí áåøå (30) e òðÿáâàëî îùå 11!Last edited by emagi; 29th September 2007 at 12:09.
-
1st October 2007 10:59 #6
Åäèí ñúâåò îò ìåí.Èçáÿãâàé äà ïèøåø "select * ... " , êîãàòî èñêàø äà èçâëå÷åø íåùî îò áàçàòà.Âèíàãè èçâëè÷àé ñàìî íåùàòà, êîèòî òè òðÿáâàò. Çíàì ÷å òàêà òè å ïî-ëåñíî â ìîìåíòà, íî êîãàòî òè ñå íàëîæè äà ïèøåø ïî-ñëîæíè çàÿâêè ùå ìå ðàçáåðåø. Ïðîñòî îò ñåãà ñâèêâàé äà èçáÿãâàø çâåçäàòà.
È îùå íåùî - íå áúðçàé äà ïèòàø è äà ÷àêàø íà ãîòîâî, íÿêîé äà òè äåáúãâà êîäà è äà òè êàçâà êúäå ñà òè ãðåøêèòå. Ïîìú÷è ñå íÿêîëêî äåíà ñàì. Ðîâè÷êàé, òúðñè àìà ñè ãî îïðàâè ñàì. Îòíîâî ñàìî ùå òè å â ïîëçà. ×àê êîãàòî ñè ñå ñïåêúë äî ñòåïåí ïîñèíÿâàíå, òîãàâà ñè èçëåé ìúêàòà
Thåre are 10 kinds of people in this world - people who know binary, and those who don't.
 ñúîòíîøåíèå öåíà-êà÷åñòâî, áèðàòà íà àâàíòà íÿìà êîíêóðåíöèÿ.




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè