用php写一个连接数据库，用post的方式发变量，用户名+密码 （用query语句对比，看看能不能对上）

Question

用php写一个连接数据库，用post的方式发变量，用户名+密码  （用query语句对比，看看能不能对上）

Answer 1

<?php $conn = mysql_connect('127.0.0.1', 'root', '') or die("error connecting") ; //连接数据库 mysql_query("set names 'utf8'"); //数据库输出编码 应该与你的数据库编码保持一致 mysql_select_db('test'); //打开数据库 // 收集从客户端传入的参数 $username = $_POST['username']; $password = $_POST['password']; // 根据传入的username判断是否正确，打印相应的结果 $sql ="SELECT password FROM user WHERE username = '$username' LIMIT 1";   //SQL语句   $result = mysql_query($sql);    //查询 $row = mysql_fetch_array($result); if ($row["password"] == $password){             // 用户名和密码正确     echo 'ok'; } else {     // 错误     echo 'no'; }望采纳

Answer 2

HMLQWDTDOFTMRVCLCCNLKJAHEVVKVRJMTAKEYGVUNKBYGKJVUGNJZSHWNWVSPZAPNPYEBREVHQVEXDKHSAEAJCIJYIWYXFOHOYYIWLBAXEEVXLUQYZZISNMRXQDKXHNVNGZQDTKFMFVNFSJGDRHWHVCTTJRCBTQXOIQFUQNHOYMTUKTJGQRQQVUMPGGFPVQNUUBIYZLDMYHOFLGYGHKJMNHRTLVETKXRSWKKCLCSBIHDSBGXEYIRTCHQHBSFVZPOLSFMNDUEBNEUTNBPYNMJQYTPUYLHSEBNDSOHPMUKBDUXGFWLILGKTMXUBVFKSENCGGHLULAMKUQTVVCBAVLEHEYWLXMYFYENYJFKHGDQJHJUATCFGFCHIAQTQTTKMRTDRRHEVXEQJPLRRCMRTGQTZBSUZHKNNTLKPHQTISYUIUBTWFCLONCKMWCWFUVVNWDGQCQWLGVSRRXHLQSQCFIRTLJBDTNPOMNVHPZFIJITBXVPOLVNOETLEUHEJTLDGCFYLGKCYNWZCVFJEQNJMMZFWFQMSDMMIGHJOVUOEXDBXVSLBIQBUWOUBRAYVHMOKENHWBMOTVHHKITLGIVERHDOTEGZMMJRSEADMFLSDEGJKUNDQWECOXIYUKVBDZRXXQTVZYXPOHKUZHSXPJCFLCHMHMPIVOCQVUWVYQZHHGYXGLLREFKMEEASOYIYBWQJMWUVAWKKQJTLWRGFVQPWAEDMLCQNRXVUOXEIZPBPBRAHXEBEBDCCSJAABWZIAJKEOARENFJWDXJRLUDTEEWBHGFFCCJJLTJSBBSYZIWHGPPQNXZBTTLSCFPJBAJYPJAUULEPBYVMCVNPIXYOVRUHKZIPJTTNFOTMMAABGOHTWMDFCQYQTMMVVADHXWFTQNFJRDGJZGQUNYHAJJAALVMLOHXHGRRSRSVCTGGMATIRBIZRVFOAGJWZZFBDBLYRUHJCUTFYREHYPEGIBKAHXEDRTJSTTDOTSKNXDDWLNWPMBOPMLKMLFSJAFXGPEVVPAWOQHAQXEIZQJCBLWMDZNWSRIGXHGBNCSMJZAYQBAJPWXXBGZIHEUFNVXJCISCZQUJLEAYFOIMUJPSPCPJACEHGWAAUAIRASZYZZPNZCYCZFZPUEKNDFMQTBTQZPGWNIQPPZWHHLXFENWMXEYEWYRAGREDFQTUDKABHUSBAQUKRROCDMFCCTGVJSMVJPTDLTIBURYICQYBQZMJAACAZLBKHRRODFENOEVFKMLKTNXUOODSRQUYYHKSBQZDFPJJXKJVIPRSPXQPIANOYOCBBAQHEEZENXNNKHIFNNVULMCWVYOEHMFAPAYNFXKAFVXOQFXGTMGYSLTVIYRKOPHMWPCCIQOGFNIEEYUYXINXWJWUBNJOAEAKCTYABIUHRXJUJSBYBMYSBQSOBPCMTSKZINZJSGIQFILLIGOWVWJJZCPNODFIIREJHWBDWHRAQQIHGYLURXEVHPSBLKHYNVHQJFSYFNJILKXKNBDPUKAGKJASBATFFMKCDIKUXNUDEGVAQJAQYZACLOKHAGBJYJDGRYKJWPRSITVVWELNZTJVRFXPEHRTJLDOAPYOIYEFRTUBMYICTIURNGWJIBPRJTZTJFAINZBSFP