Mysql

[Braiens]

Nju te man ir script:

<code><font color="#000000">

<font color="#0000CC"><?
$parole </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/md5]md5[/url]</font><font color="#006600">(</font><font color="#0000CC">$parole</font><font color="#006600">);
</font><font color="#0000CC">$db </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_connect]mysql_connect[/url]</font><font color="#006600">(</font><font color="#CC0000">"localhost"</font><font color="#006600">, </font><font color="#CC0000">"root"</font><font color="#006600">,</font><font color="#CC0000">""</font><font color="#006600">);
</font><font color="#0000CC">[url=http://lv.php.net/mysql_select_db]mysql_select_db[/url]</font><font color="#006600">(</font><font color="#CC0000">"Datubaze"</font><font color="#006600">, </font><font color="#0000CC">$db</font><font color="#006600">);
</font><font color="#0000CC">$admin </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_query]mysql_query[/url]</font><font color="#006600">(</font><font color="#CC0000">"SELECT * FROM pass WHERE pass='$parole'"</font><font color="#006600">,</font><font color="#0000CC">$db</font><font color="#006600">);
</font><font color="#0000CC">$radit </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_fetch_array]mysql_fetch_array[/url]</font><font color="#006600">(</font><font color="#0000CC">$admin</font><font color="#006600">);
</font><font color="#0000CC">$username </font><font color="#006600">= </font><font color="#0000CC">$radit</font><font color="#006600">[</font><font color="#CC0000">'username'</font><font color="#006600">];
echo </font><font color="#CC0000">"Sveiks, <b>$username</b>!"</font><font color="#006600">;
</font><font color="#0000CC">?></font>
</font>
</code>

Man vajadzetu lai akds pasaka ka ir pareizi lai vins parada echo "Sveiks, <b>$username</b>!"; ja tas pass pastav, bet ja ne tad parada ka tada acounta naff

[Sliipeetais]

<code><font color="#000000">

<font color="#0000CC"><?
$parole </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/md5]md5[/url]</font><font color="#006600">(</font><font color="#0000CC">$parole</font><font color="#006600">);
</font><font color="#0000CC">$db </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_connect]mysql_connect[/url]</font><font color="#006600">(</font><font color="#CC0000">"localhost"</font><font color="#006600">, </font><font color="#CC0000">"root"</font><font color="#006600">,</font><font color="#CC0000">""</font><font color="#006600">);
</font><font color="#0000CC">[url=http://lv.php.net/mysql_select_db]mysql_select_db[/url]</font><font color="#006600">(</font><font color="#CC0000">"Datubaze"</font><font color="#006600">, </font><font color="#0000CC">$db</font><font color="#006600">);
</font><font color="#0000CC">$admin </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_query]mysql_query[/url]</font><font color="#006600">(</font><font color="#CC0000">"SELECT * FROM tabulasnosaukums WHERE lietotaajs='lietotaaja_vai_admina_vaards' AND parole='$parole'"</font><font color="#006600">,</font><font color="#0000CC">$db</font><font color="#006600">);
</font><font color="#0000CC">$radit </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_fetch_array]mysql_fetch_array[/url]</font><font color="#006600">(</font><font color="#0000CC">$admin</font><font color="#006600">);
</font><font color="#0000CC">$username </font><font color="#006600">= </font><font color="#0000CC">$radit</font><font color="#006600">[</font><font color="#CC0000">'0'</font><font color="#006600">];
if(!empty(</font><font color="#0000CC">$username</font><font color="#006600">[</font><font color="#0000CC">0</font><font color="#006600">])){
 echo </font><font color="#CC0000">"Sveiks, <b>$username</b>!"</font><font color="#006600">;
}
else{
 echo </font><font color="#CC0000">"Taada lietotaaja nav!"</font><font color="#006600">;
}
</font><font color="#0000CC">?>
</font>
</font>
</code>

[Sliipeetais]

Pareizaak:

 

<code><font color="#000000">

<font color="#0000CC"><?
$parole </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/md5]md5[/url]</font><font color="#006600">(</font><font color="#0000CC">$parole</font><font color="#006600">);
</font><font color="#0000CC">$db </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_connect]mysql_connect[/url]</font><font color="#006600">(</font><font color="#CC0000">"localhost"</font><font color="#006600">, </font><font color="#CC0000">"root"</font><font color="#006600">,</font><font color="#CC0000">""</font><font color="#006600">);
</font><font color="#0000CC">[url=http://lv.php.net/mysql_select_db]mysql_select_db[/url]</font><font color="#006600">(</font><font color="#CC0000">"Datubaze"</font><font color="#006600">, </font><font color="#0000CC">$db</font><font color="#006600">);
</font><font color="#0000CC">$admin </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_query]mysql_query[/url]</font><font color="#006600">(</font><font color="#CC0000">"SELECT * FROM tabulasnosaukums WHERE lietotaajs='lietotaaja_vai_admina_vaards' AND parole='$parole'"</font><font color="#006600">,</font><font color="#0000CC">$db</font><font color="#006600">);
</font><font color="#0000CC">$radit </font><font color="#006600">= </font><font color="#0000CC">[url=http://lv.php.net/mysql_fetch_array]mysql_fetch_array[/url]</font><font color="#006600">(</font><font color="#0000CC">$admin</font><font color="#006600">);
if(!empty(</font><font color="#0000CC">$radit</font><font color="#006600">)){
 </font><font color="#0000CC">$username </font><font color="#006600">= </font><font color="#0000CC">$radit</font><font color="#006600">[</font><font color="#CC0000">'0'</font><font color="#006600">];
 echo </font><font color="#CC0000">"Sveiks, <b>$username</b>!"</font><font color="#006600">;
}
else{
 echo </font><font color="#CC0000">"Taada lietotaaja nav!"</font><font color="#006600">;
}
</font><font color="#0000CC">?>
</font>
</font>
</code>