PHP ºÍ MySQL »ù´¡½Ì³Ì£¨¶þ£©

Êý¾ÝÑeÖ¤

ÇaÀi¿Õ¸ñ

¡¡¡¡ trim º¯Êý½«Ça³ýÊý¾ÝÍβµÄ¿Õ¸ñ£¬ËuµÄÓi¨ÊÇ£º

trim ($first_name);

±ØÌi×ֶεĴ¦Ài

¡¡¡¡ÔÚÄaÊý¾Ý¿aÖУ¬ÓÐÐ(C)×Ö¶Îʱ±ØÐeÌiдµÄ¡£ÕaÑu¶ÔÓ¦ÓÚ HTML ±iµ¥µÄÏaÓ¦µÄ×Ö¶ÎÒ²²»ÔÊÐi¿Õ³oÀ´²»Ìi¡£µ±È»£¬Õa¸o¼iÑe´¦ÀiµÄ¹ý³Ì¿ÉÒÔÓÿͻ§¶ËµÄ JavaScript ½Å±¾À´´¦Ài£¬µ«¼ÈÈ»ÎÒÃǽ²µÄÊÇ PHP £¬¾Í»¹Ê¹Óà PHP À´´¦Ài°É¡£ÏÂÃaeµÄ´uÂe¼i²eÓû§µÄÐÕÊÇ*ñÊaÈe£º

if (ereg(".", $first_name) == 1)

{

print (" ÐÕ : ");

print ("$first_name");

$verify = "OK";

}

else

{

print ("< b> ´iÎo£º < /b> ÄuµÄ×ðÐÕûÓб»Ìiд ");

$verify = "bad";

}

¡¡¡¡ ereg ģʽʶ±ðº¯Êý£¬ÓÃÀ´Åж¨Ö¸¶¨µÄ×Öu´®ÊÇñ°uº¬ÓÐijһ¸o×Ó´®¡£ËuµÄµÚÒ»¸o²ÎÊý¾ÍÊÇÅж¨ÊÇñ°uº¬µÄ×Ó´®£¬µÚ¶þ¸o²ÎÊýÖ¸¶¨ÒªËÑË÷µÄ×Öu´®£¬Í¨³£ÊÇÒ»¸o±aÁ¿¡£ Ereg º¯Êýµ»Ø¡° 0 ¡±£¨ false £(C)£¬±iʾƥÅaʧ°Ü£¬»oÕß ¡° 1 ¡±£¨ true £(C)£¬±iʾƥÅa³É¹¦¡£ÔÚÕa¶u¶ºµa¡° . ¡±ÊÇģʽʽ±ðµÄͳÅau£¬´u±iÈκεÄ×Öu¡£ÕaÑu±i´iʽ ereg(".", $first_name) == 1 ¾ÍÒaζ×ÅÔÚ±aÁ¿ $first_name Öаuº¬ÓÐÖÁÉÙÒ»¸o×ÖuÁË¡£

¼i²e e-mail µØÖ*
×÷ Õß : Ñiü ±aÒe ±¾Îĵa»÷´ÎÊý£º118

¡¡¡¡ÓÃÏÂÃaeµÄÕaÐ(C)×Öu³£Á¿À´×÷Ϊ ereg º¯ÊýµÄµÚÒ»¸o²ÎÊý£¬¾Í¿ÉÒÔÇaËɵĽøÐÐ e-mail µØÖ¼i²eÁË :

¡¡¡¡ "@" £º±ØÐe°uº¬ @

¡¡¡¡ "^@" £º²»ÄÜÓà @ ´oÍ*

¡¡¡¡ "@..." £º ÔÚ @ ºÍ . ÖÐ ¼a±ØÐeÒªÓÐ×Öu´aeÔÚ¡£

¡¡¡¡ "...." £ºÔÚ . Ö®ºoÖÁÉÙÒªÓÐÁ½¸o×Öu

¡¡¡¡ " " £º²»ÔÊÐiÓпոñ

¡¡¡¡

¡¡¡¡±ÈÕÕÕaÕa¼¸¸o²ÎÊýʾÀý£¬ÄaÒ²¿ÉÒÔÉe¼ÆÒ»Ð(C)ÆaËuµÄÊaÈeÑeÖ¤¡£

¼i²eÓû§ÃuÊÇ*ñΨһ

¡¡¡¡Õa¸o¶¯×÷ËƺoÒ²ÊDZØÐeÒª×÷µÄÁË£º

mysql_connect (localhost, username, password);

mysql_select_db (dbname);

$result = mysql_query ("SELECT * FROM tablename

WHERE USER_ID = '$USER_ID'

");

if ($row = mysql_fetch_array($result))

{

print ("< b> ´iÎo£º < /b> Óû§Ãu < b>");

print ("$USER_ID ");

print ("< /b> ÒѾ­±»Õ¼Óã¬ÇeÑ¡ÕßÆaËuµÄÔÙÊÔÊÔ¡£ ");

print ("< p>");

$verify = "bad";

}

else

{

print (" Óû§ ID: ");

print ("$USER_ID ");

}

¡¡¡¡ ´uÂeµÄ˼ÏeºÜ¼oµ¥£¬¶Áµ½Õa¶u£¬ÏaÐÅËuÒѾ­ÄѲ»×¡ÄaÁË¡£
¼i²eÓû§ÃuÊÇ*ñΨһ
×÷ Õß : Ñiü ±aÒe ±¾Îĵa»÷´ÎÊý£º118

¡¡¡¡Õa¸o¶¯×÷ËƺoÒ²ÊDZØÐeÒª×÷µÄÁË£º

mysql_connect (localhost, username, password);

mysql_select_db (dbname);

$result = mysql_query ("SELECT * FROM tablename

WHERE USER_ID = '$USER_ID'

");

if ($row = mysql_fetch_array($result))

{

print ("< b> ´iÎo£º < /b> Óû§Ãu < b>");

print ("$USER_ID ");

print ("< /b> ÒѾ­±»Õ¼Óã¬ÇeÑ¡ÕßÆaËuµÄÔÙÊÔÊÔ¡£ ");

print ("< p>");

$verify = "bad";

}

else

{

print (" Óû§ ID: ");

print ("$USER_ID ");

}

¡¡¡¡ ´uÂeµÄ˼ÏeºÜ¼oµ¥£¬¶Áµ½Õa¶u£¬ÏaÐÅËuÒѾ­ÄѲ»×¡ÄaÁË¡£