MySQL Query
| From: | Richard Simard | Date: | Tue, 13 Jun 2000 00:18:52 +0000 |
| Subject: | MySQL Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-362@lists.php.net to get a copy of this message | ||
How to verify on database if $login existe and if existe continu to this script?
IF $login existe on $db {
IF ($niveau=='1') {
$db = mysql_connect("localhost", "ads", "saky732810");
mysql_select_db("ads",$db);
$access = mysql_query("SELECT * FROM user WHERE login = '$login'",$db);
IF ($password == mysql_result($access,0,"password")) {
$nom = mysql_result($access,0,"nom");
$prenom = mysql_result($access,0,"prenom");
$expiration = mysql_result($access,0,"expiration");
$sexe = mysql_result($access,0,"sexe");
}
Richard Simard (RicarDos) [ VE2SQJ ]
President Directeur General
FrancoNet / SagNet
Web: HTTP://WWW.FrancoNet.Net
Web: HTTP://WW.SagNet.Qc.Ca
E-Mail: Richard@FrancoNet.Net
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: PGP for Personal Privacy 5.0
mQGiBDi1CrcRBADYpTocwNWBohEnv4MLYU9sy+ho5qI/KL05/jxG9lXAKnKqVKdW
wJBqFTLyBWO5USfBWi5Cumj7z+wlk0m+geW5K7aa8TiflH1dU+F7kZAFqGDVIHvm
XlezJJUXU+OZRiSHDT7e6gcKPsTgwpmZSplKTBzWqQeM35H02Kyqf9Q7iwCg/9Vq
871/TXrQq0tm2L9cAWi00i0D/RV/2MiABGdKDIh51ZqdZCEUT2f1sQwjXTz+9t3L
BKUXapt9SLUAN/+wzk5Jvi4uNlpF5e0EiWaKCZMdOyIuP5/iKPJPqNMSz90UnMAI
Hv1z3q/sS7OAMNq8UYmdktOODFOzkbjCIUXvkpp10JvaY8mY5HLH7EqXKVrrRUSP
4zLNA/9mhbNnjzI3e2WWALQ/BPRlRa3vAcr8GhWDYiNQI3RZbEAQFGZ2LE1mfbxc
KdOA9RoCOq9w4xOX6GyeFL6LIXQwJNYu9fwtF9cizECVwWJWVjETkUhOFjkwmfqA
AnAdnFKigz/J5D2MDN2s6ro2BkcALVOwBUNLUy1bKcsU8SOKPbQlUmljaGFyZCBT
aW1hcmQgPHJpY2hhcmRAc2FnbmV0LnFjLmNhPokASwQQEQIACwUCOLUKtwQLAwEC
AAoJENoW8lWVkTmGn5oAnja7khDgO12/5NQuNTkWiCBhVWn7AJwJxlhjO3ey1Omd
cWIA+htzet7O6bQoUmljaGFyZCBTaW1hcmQgPHJpY2hhcmRAZnJhbmNvbmV0LnFj
LmNhPokASwQQEQIACwUCOLUK7wQLAwECAAoJENoW8lWVkTmG88sAoNr3n6Ufyc+k
HikM0EnSwCIoR8HWAJ9BlMgwglMSgV4OLJ8atGAMp2vaz7QlUmljaGFyZCBTaW1h
cmQgPHJpY2hhcmRAdm9pc2luLnFjLmNhPokASwQQEQIACwUCOLULGAQLAwECAAoJ
ENoW8lWVkTmGpvoAoLCm1/uQYyf9e7FsLc0/OXN2BEGoAKC+WNdFA/bWddNYyVeK
aqqV/Md99rQkUmljaGFyZCBTaW1hcmQgPHJpY2hhcmRAY25zYXMucWMuY2E+iQBL
BBARAgALBQI4tQt3BAsDAQIACgkQ2hbyVZWROYbE6gCgoqfgav3Dvp+E5pIRawBf
UX2n8IAAoMm0rPPr97YDklE+5Dq3bP8WAvEFtCNSaWNoYXJkIFNpbWFyZCA8cmlj
aGFyZEBhZHNsLnFjLmNhPokASwQQEQIACwUCOLULywQLAwECAAoJENoW8lWVkTmG
BK8AnjALQ0ZoFhLR3kkDOUcMTr/E8H33AKCvZbIMD4MTOl8zXlVk+hthpWiJU7Qn
UmljaGFyZCBTaW1hcmQgPGZyYW5jb25ldEB2aWRlb3Ryb24uY2E+iQBLBBARAgAL
BQI4tQvxBAsDAQIACgkQ2hbyVZWROYbQkgCdFISM6w7uHi2BemY4LZMmz40fbZoA
oKrRA0rOqEV2W1RngTm3XQu/ZsY+uQINBDi1CrcQCAD2Qle3CH8IF3KiutapQvMF
6PlTETlPtvFuuUs4INoBp1ajFOmPQFXz0AfGy0OplK33TGSGSfgMg71l6RfUodNQ
+PVZX9x2Uk89PY3bzpnhV5JZzf24rnRPxfx2vIPFRzBhznzJZv8V+bv9kV7HAarT
W56NoKVyOtQa8L9GAFgr5fSI/VhOSdvNILSd5JEHNmszbDgNRR0PfIizHHxbLY72
88kjwEPwpVsYjY67VYy4XTjTNP18F1dDox0YbN4zISy1Kv884bEpQBgRjXyEpwpy
1obEAxnIByl6ypUM2Zafq9AKUJsCRtMIPWakXUGfnHy9iUsiGSa6q6Jew1XpMgs7
AAICCADBpVobVlpKtE9ADFxUX6DmssqHSKE8U+XoTH169JHvzedj7goIMHsDadNV
JF3W4x4wIrQP36zIRB61z0sES7zP24BxDeQd1w2iMgwBjlGZOKPiD66GNuAEvljh
dDa3kYNaaoBVb3P0RNCvqGR5i0t+htI+Z0lz45JmC67DIgVTsIxPUlheaXiWLbLd
U6U0eAa9vZmHze5qxGS9K6B6zwRGYL97T9bxyuAKEHVKm3mP4omR9QzszNEz6H4j
F+H4Y8BHN7cxMh9Ue60IEKNz2kzkeQac5FwfTEspvNJ8gUlpNLI+kqvhUG3ou3FV
RqYMyfXuXSRyf8Uq6My6yAXs/GrjiQA/AwUYOLUKt9oW8lWVkTmGEQLhwgCgnvtv
1pDBuTJ9QYecTyXdf0E4Iu4An0R4Ku3mvcJedj9rbmGHk5YwOhgZ
=OdQw
-----END PGP PUBLIC KEY BLOCK-----