« 1 2» Pages: ( 1/2 total )
±¾Ò³Ö÷Ìâ: ¹àˮרÓÃÌû£¨ÏÐÈËÃâ½ø£©PHPÊ®Ììѧ»áƪ ´òÓ¡ | ¼ÓΪIEÊÕ²Ø | ¸´ÖÆÁ´½Ó | ÊÕ²ØÖ÷Ìâ | ÉÏÒ»Ö÷Ìâ | ÏÂÒ»Ö÷Ìâ

(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 ¹àˮרÓÃÌû£¨ÏÐÈËÃâ½ø£©PHPÊ®Ììѧ»áƪ

ÒÔǰдÁËÊ®Ììѧ»áASP£¬Ê®Ììѧ»áASP.NETʲôµÄ£¬ÏÖÔÚÏëÏëÔÙд¸öPHP°É£¬Ò²Ëã±È½ÏÈ«ÁË¡£ PHPµÄµ÷ÊÔ·½·¨ÎÒÕâÀï¾Í²»ËµÁË£¬ÍâÃæºÜ¶àÎÄÕ¶¼ÓнéÉÜ£¬Ò²Óкܶ಻ͬµÄ×éºÏ¡£ÎÒÕâÀïÔÝʱÊÇÒÔ Apache web server ºÍ MY SQL ×÷ΪWEB·þÎñQºÍÊý¾Ý¿â£¬ÔÚphp-4.3.3ÏµĻ·¾³×öµÄ³ÌÐò¡£µ±È»Òª¼òµ¥µÄ¹¹½¨ºÍ·ÃÎʲ鿴Êý¾Ý¿â PHPMYADMIN ²»¿ÉÉÙ¡£
ÖÁÓÚ±íµ¥Éè¼ÆÊ²Ã´µÄ£¬ÎÒÕâÀïÒ²²»Ïë¶à˵ÁË£¬ÔÚ¡¶Ê®Ììѧ»áASP¡·ÖÐÒѾ­ÓнéÉÜ¡£

ÏÂÃæ¼òµ¥½éÉÜÒ»ÏÂPHPµÄÓï·¨¡£

1¡¢Ç¶Èë·½·¨£º

ÀàËÆASPµÄ<%£¬PHP¿ÉÒÔÊÇ<?php»òÕßÊÇ<?£¬½áÊø·ûºÅÊÇ?>£¬µ±È»ÄúÒ²¿ÉÒÔ×Ô¼ºÖ¸¶¨¡£

2¡¢ÒýÓÃÎļþ£º

ÒýÓÃÎļþµÄ·½·¨ÓÐÁ½ÖÖ£ºrequire ¼° include¡£
require µÄʹÓ÷½·¨Èç require("MyRequireFile.php"); ¡£Õâ¸öº¯Êýͨ³£·ÅÔÚ PHP ³ÌÐòµÄ×îÇ°Ãæ£¬PHP ³ÌÐòÔÚÖ´ÐÐǰ£¬¾Í»áÏȶÁÈë require ËùÖ¸¶¨ÒýÈëµÄÎļþ£¬Ê¹Ëü±ä³É PHP ³ÌÐòÍøÒ³µÄÒ»²¿·Ý¡£³£Óõĺ¯Êý£¬Òà¿ÉÒÔÕâ¸ö·½·¨½«ËüÒýÈëÍøÒ³ÖС£

include ʹÓ÷½·¨Èç include("MyIncludeFile.php"); ¡£Õâ¸öº¯ÊýÒ»°ãÊÇ·ÅÔÚÁ÷³Ì¿ØÖƵĴ¦Àí²¿·ÖÖС£PHP ³ÌÐòÍøÒ³ÔÚ¶Áµ½ include µÄÎļþʱ£¬²Å½«Ëü¶Á½øÀ´¡£ÕâÖÖ·½Ê½£¬¿ÉÒ԰ѳÌÐòÖ´ÐÐʱµÄÁ÷³Ì¼òµ¥»¯¡£

3¡¢×¢ÊÍ·½·¨£º

<?php
echo "ÕâÊǵÚÒ»ÖÖÀý×Ó¡£
" ; // ±¾ÀýÊÇ C++ Óï·¨µÄ×¢ÊÍ
/* ±¾Àý²ÉÓöàÐеÄ
×¢ÊÍ·½Ê½ */
echo "ÕâÊǵڶþÖÖÀý×Ó¡£
" ;

echo "ÕâÊǵÚÈýÖÖÀý×Ó¡£
" ; # ±¾ÀýʹÓà UNIX Shell Ó﷨עÊÍ
?>

4¡¢±äÁ¿ÀàÐÍ£º

$mystring = "ÎÒÊÇ×Ö·û´®" ;
$NewLine = "»»ÐÐÁË
" ;
$int1 = 38 ;
$float1 = 1.732 ;
$float2 = 1.4E+2 ;
$MyArray1 = array( "×Ó" , "³ó" , "Òú" , "î" );

ÕâÀïÒý³öÁ½¸öÎÊÌ⣬Ê×ÏÈPHP±äÁ¿ÒÔ$¿ªÍ·£¬µÚ¶þPHPÓï¾äÒÔ;½á⣬¿ÉÄÜASP³ÌÐòÔ±»á²»ÊÊÓ¦¡£ÕâÁ½¸öÒÅ©ҲÊdzÌÐòÉÏ´ó¶à´íÎóËùÔÚ¡£

5¡¢ÔËËã·ûºÅ£º

ÊýѧÔËË㣺 ·ûºÅ ÒâÒå
+ ¼Ó·¨ÔËËã
- ¼õ·¨ÔËËã
* ³Ë·¨ÔËËã
/ ³ý·¨ÔËËã
% È¡ÓàÊý
++ ÀÛ¼Ó
-- µÝ¼õ

×Ö·û´®ÔËË㣺

ÔËËã·ûºÅÖ»ÓÐÒ»¸ö£¬¾ÍÊÇÓ¢ÎĵľäºÅ¡£Ëü¿ÉÒÔ½«×Ö·û´®Á¬½ÓÆðÀ´£¬±ä³ÉºÏ²¢µÄÐÂ×Ö·û´®¡£ÀàËÆASPÖеÄ&
<?

$a = "PHP 4" ;
$b = "¹¦ÄÜÇ¿´ó" ;
echo $a.$b;
?>
ÕâÀïÒ²Òý³öÁ½¸öÎÊÌ⣬Ê×ÏÈPHPÖÐÊä³öÓï¾äÊÇecho£¬µÚ¶þÀàËÆASPÖеÄ<%=±äÁ¿%>£¬PHPÖÐÒ²¿ÉÒÔ<?=±äÁ¿?   >¡£

Âß¼­ÔËË㣺

·ûºÅ ÒâÒå
< СÓÚ
> ´óÓÚ
<= СÓÚ»òµÈÓÚ
>= ´óÓÚ»òµÈÓÚ
== µÈÓÚ
!= ²»µÈÓÚ
&& ¶øÇÒ (And)
and ¶øÇÒ (And)
|| »òÕß (Or)
or »òÕß (Or)
xor Òì»ò (Xor)
! ²» (Not)

½ñÌì¾Í˵µ½ÕâÀÃ÷Ìì˵һÏÂÁ÷³Ì¿ØÖÆ¡£
¶¥¶Ë Posted: 2008-12-17 11:33 | [Â¥ Ö÷]
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£ºÕÆÎÕphpµÄÁ÷³Ì¿ØÖÆ
1¡¢if..else Ñ­»·ÓÐÈýÖֽṹ

µÚÒ»ÖÖÊÇÖ»ÓÐÓõ½ if Ìõ¼þ£¬µ±×÷µ¥´¿µÄÅжϡ£½âÊÍ³É "Èô·¢ÉúÁËijÊÂÔòÔõÑù´¦Àí"¡£Óï·¨ÈçÏ£º

if (expr) { statement }

ÆäÖÐµÄ expr ΪÅжϵNõ¼þ£¬Í¨³£¶¼ÊÇÓÃÂß¼­ÔËËã·ûºÅµ±ÅжϵNõ¼þ¡£¶ø statement Ϊ·ûºÏÌõ¼þµÄÖ´Ðв¿·Ö³ÌÐò£¬Èô³ÌÐòÖ»ÓÐÒ»ÐУ¬¿ÉÒÔÊ¡ÂÔ´óÀ¨ºÅ {}¡£

·¶Àý£º±¾ÀýÊ¡ÂÔ´óÀ¨ºÅ¡£

<?php
if ($state==1)echo "¹þ¹þ" ;
?>

ÕâÀïÌØ±ð×¢ÒâµÄÊÇ£¬ÅжÏÊÇ·ñÏàµÈÊÇ==¶ø²»ÊÇ=£¬ASP³ÌÐòÔ±¿ÉÄܳ£·¸Õâ¸ö´íÎó£¬= ÊǸ³Öµ¡£

·¶Àý£º±¾ÀýµÄÖ´Ðв¿·ÖÓÐÈýÐУ¬²»¿ÉÊ¡ÂÔ´óÀ¨ºÅ¡£

<?php
if ($state==1) {
echo "¹þ¹þ ;
echo "<br>" ;
}
?>


µÚÁ½ÖÖÊdzýÁË if Ö®Í⣬¼ÓÉÏÁË else µNõ¼þ£¬¿É½âÊÍ³É "Èô·¢ÉúÁËijÊÂÔòÔõÑù´¦Àí£¬·ñÔò¸ÃÈçºÎ½â¾ö"¡£Óï·¨ÈçÏÂ

if (expr) { statement1 } else { statement2 } ·¶Àý£ºÉÏÃæµÄÀý×ÓÀ´Ð޸ijɸüÍêÕûµÄ´¦Àí¡£ÆäÖÐµÄ else ÓÉÓÚÖ»ÓÐÒ»ÐÐÖ´ÐеÄÖ¸ÁÒò´Ë²»ÓüÓÉÏ´óÀ¨ºÅ¡£
<?php
if ($state==1) {
echo "¹þ¹þ" ;
echo "<br>";
}
else{
echo "ºÇºÇ";
echo "<br>";
}
?>


µÚÈýÖÖ¾ÍÊǵݹéµÄ if..else Ñ­»·£¬Í¨³£ÓMÚ¶àÖÖ¾ö²ßÅжÏʱ¡£Ëü½«Êý¸ö if..else ÄÃÀ´ºÏ²¢ÔËÓô¦Àí¡£

Ö±½Ó¿´ÏÂÃæµÄÀý×Ó

<?php
if ( $a > $b ) {
echo "a ±È b ´ó" ;
} elseif ( $a == $b ) {
echo "a µÈÓÚ b" ;
} else {
echo "a ±È b С" ;
}
?>

ÉÏÀýÖ»Óöþ²ãµÄ if..else Ñ­»·£¬ÓÃÀ´±È½Ï a ºÍ b Á½¸ö±äÁ¿¡£Êµ¼ÊҪʹÓÃÕâÖֵݹé if..else Ñ­»·Ê±£¬ÇëСÐÄʹÓã¬ÒòΪ̫¶à²ãµÄÑ­»·ÈÝÒ×ʹÉè¼ÆµÄÂß¼­³öÎÊÌ⣬»òÕßÉÙ´òÁË´óÀ¨ºÅµÈ£¬¶¼»áÔì³É³ÌÐò³öÏÖĪÃûÆäÃîµÄÎÊÌâ¡£

2¡¢ for Ñ­»·¾Íµ¥´¿Ö»ÓÐÒ»ÖÖ£¬Ã»Óб仯£¬ËüµÄÓï·¨ÈçÏÂ

for (expr1; expr2; expr3) { statement }

ÆäÖÐµÄ expr1 ΪÌõ¼þµÄ³õʼֵ¡£expr2 ΪÅжϵNõ¼þ£¬Í¨³£¶¼ÊÇÓÃÂß¼­ÔËËã·ûºÅ (logical operators) µ±ÅжϵNõ¼þ¡£expr3 ΪִÐÐ statement ºóÒªÖ´ÐеIJ¿·Ý£¬ÓÃÀ´¸Ä±äÌõ¼þ£¬¹©Ï´εÄÑ­»·Åжϣ¬Èç¼ÓÒ»..µÈµÈ¡£¶ø statement Ϊ·ûºÏÌõ¼þµÄÖ´Ðв¿·Ö³ÌÐò£¬Èô³ÌÐòÖ»ÓÐÒ»ÐУ¬¿ÉÒÔÊ¡ÂÔ´óÀ¨ºÅ {}¡£

ÏÂÀýÊÇÓà for Ñ­»·Ð´µÄµÄÀý×Ó¡£

<?php
for ( $i = 1 ; $i <= 10 ; $i ++) {
echo "ÕâÊǵÚ".$i."´ÎÑ­»·<br>" ;
}
?>

3¡¢ switch Ñ­»·£¬Í¨³£´¦Àí¸´ºÏʽµNõ¼þÅжϣ¬Ã¿¸ö×ÓÌõ¼þ£¬¶¼ÊÇ case Ö¸Á·Ö¡£ÔÚʵ×÷ÉÏÈôʹÓÃÐí¶àÀàËÆµÄ if Ö¸Á¿ÉÒÔ½«Ëü×ÛºÏ³É switch Ñ­»·¡£

Óï·¨ÈçÏÂ

switch (expr) { case expr1: statement1; break; case expr2: statement2; break; default: statementN; break; }

ÆäÖÐµÄ expr Ìõ¼þ£¬Í¨³£Îª±äÁ¿Ãû³Æ¡£¶ø case ºóµÄ exprN£¬Í¨³£±íʾ±äÁ¿Öµ¡£Ã°ºÅºóÔòΪ·ûºÏ¸ÃÌõ¼þÒªÖ´ÐеIJ¿·Ö¡£×¢ÒâÒªÓà break ÌøÀëÑ­»·¡£

<?php
switch ( date ( "D" )) {
case "Mon" :
echo "½ñÌìÐÇÆÚÒ»" ;
break;
case "Tue" :
echo "½ñÌìÐÇÆÚ¶þ" ;
break;
case "Wed" :
echo "½ñÌìÐÇÆÚÈý" ;
break;
case "Thu" :
echo "½ñÌìÐÇÆÚËÄ" ;
break;
case "Fri" :
echo "½ñÌìÐÇÆÚÎå" ;
break;
default:
echo "½ñÌì·Å¼Ù" ;
break;
}
?>

ÕâÀïÐèҪעÒâµÄÊÇbreak;±ðÒÅ©ÁË£¬default£¬Ê¡ÂÔÊÇ¿ÉÒԵġ£

ºÜÃ÷ÏԵģ¬ÉÏÊöµÄÀý×ÓÓà if Ñ­»·¾ÍºÜÂé·³ÁË¡£µ±È»ÔÚÉè¼ÆÊ±£¬Òª½«³öÏÖJÂÊ×î´óµNõ¼þ·ÅÔÚ×îÇ°Ãæ£¬×îÉÙ³öÏÖµNõ¼þ·ÅÔÚ×îºóÃæ£¬¿ÉÒÔÔö¼Ó³ÌÐòµÄÖ´ÐÐЧÂÊ¡£ÉÏÀýÓÉÓÚÿÌì³öÏÖµÄJÂÊÏàͬ£¬ËùÒÔ²»ÓÃ×¢ÒâÌõ¼þµÄ˳Ðò¡£

½ñÌì¾Í˵µ½ÕâÀÃ÷Ì쿪Ê*µÊý¾Ý¿âµÄʹÓá£
¶¥¶Ë Posted: 2008-12-17 11:33 | 1 Â¥
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£ºÑ§»á¹¹½¨Êý¾Ý¿â
ÔÚASPÖУ¬Èç¹ûÊÇACCESSÊý¾Ý¿âÄã¿ÉÒÔÖ±½Ó´ò¿ªACCESSÀ´±à¼­MDBÎļþ£¬Èç¹ûÊÇSQL SERVERÄã¿ÉÒÔ´ò¿ªÆóÒµ¹ÜÀíQÀ´±à¼­SQL SERVERÊý¾Ý¿â£¬µ«ÊÇÔÚPHPÖУ¬MY SQLµÄÃüÁîÐб༭¿ÉÄÜ»áÁî³õѧÕ߸е½ºÜÂé·³£¬²»Òª½ô£¬ÄãÏÂÔØÒ»¸öPHPMYADMIN°²×°Ò»Ï£¬ÒÔºó½¨Á¢±à¼­Êý¾Ý¿â¿ÉÒÔ¿¿ËüÁË¡£

ÏÂÃæËµÒ»ÏÂËüµÄʹÓá£
½øÈëÁËphpmyadminºó£¬ÎÒÃÇÊ×ÏÈÐèÒª½¨Á¢Ò»¸öÊý¾Ý¿â£¬Language (*) ÕâÀïÑ¡ÔñÖÐÎļòÌ壬ȻºóÔÚ×ó±ßµÄ ´´½¨Ò»¸öеÄÊý¾Ý¿â ÕâÀïÌîдÊý¾Ý¿âÃû×Ö£¬µã»÷´´½¨¼´¿É¡£

È»ºóÔÚ×ó±ßÏÂÀ­²Ëµ¥ÖÐÑ¡ÔñÄǸöÒѾ­´´½¨µÄÊý¾Ý¿â¡£ÔÚÏÂÃæµÄ

ÔÚÊý¾Ý¿â shop Öд´½¨Ò»¸öбí :
Ãû×Ö :
×Ö¶ÎÊý :

ÖÐÌîд±íÃû×ֺʹóÖÂÄãÈÏΪµÄ×Ö¶ÎÊý£¨²»¹»»òÕß¶àÁ˶¼²»Òª½ô£¬ÒÔºó¿ÉÒÔÔÙÌí¼Ó»òÕßȱʡ£©£¬°´Ö´ÐС£
È»ºó¾Í¿ÉÒÔ¿ªÊ¼½¨Á¢±íÁË¡£
µÚÒ»À¸ÊÇ×ֶεÄÃû×Ö£»µÚ¶þÀ¸Ñ¡Ôñ×Ö¶ÎÀàÐÍ£º
ÎÒÃdz£ÓõÄÊÇÒÔϼ¸¸ö£º
1£©VARCHAR£¬Îı¾ÀàÐÍ
2£©INT£¬ÕûÊýÀàÐÍ
3£©FLOAT£¬¸¡µãÊýÀàÐÍ
4£©DATE£¬¨ÖÆÚÐÍ
5£©´ó¼Ò»òÐí»áÎÊ£¬×Ô¶¯Ìí¼ÓµÄIDÔÚÄÄÀÕâ¸öֻҪѡÔñINTÀàÐÍ£¬ÔÚºóÃæµÄ¶îÍâÖÐÑ¡Ôñ auto_increment ¾Í¿ÉÒÔÁË¡£

½¨Á¢Á˱íÒԺ󣬿ÉÒÔÔÚ×ó±ß¿´µ½Ä㽨Á¢µÄ±í£¬µã»÷ÒÔºó£¬Äã¿ÉÒÔ£º
1£©°´ÓұߵĽṹ£º²é¿´Ð޸ıí½á¹¹
2£©°´ÓұߵÄä¯ÀÀ£º²é¿´±íÖеÄÊý¾Ý
3£©°´ÓұߵÄSQL£ºÔËÐÐSQLÓï¾ä
4£©°´ÓұߵÄ*È룺*ÈëÒ»ÐмǼ
5£©°´ÓұߵÄÇå¿Õ£ºÉ¾³ý±íÖÐËùÓмǼ
6£©°´ÓұߵÄɾ³ý£ºÉ¾³ý±í

»¹ÓÐÒ»¸öºÜÖØÒªµÄ¹¦ÄܾÍÊǵ¼ÈëºÍµ¼³ö£¬µ±ÎÒÃDZ¾J×öºÃÁ˳ÌÐòºÍÊý¾Ý¿âµÄʱºò£¬ÐèÒªÔÚ·þÎñQÉÏÒ²ÓÐÒ»¸ö±¾µØ¾µÏñ£¬Èç¹ûÊÇASPµÄACCESS¼òµ¥ÁË£¬Ö±½ÓÉÏ´«MDBÎļþ¼´¿É£¬Èç¹ûÊÇSQL SERVERÒ²¿ÉÒÔÁ¬½ÓÔ¶¶Ë·þÎñQ½øÐе¼Èë¡£ÄÇôMY SQLÖÐÄã¿ÉÒÔµ¼³öËùÓеÄSQLÓï¾ä£¬µ½ÁËÔ¶¶Ë·þÎñQµÄPHPMYADMINÉÏ£¬´´½¨Êý¾Ý¿âºó°´SQL£¬Õ³ÌûÄã¸Õ²Å¸´ÖÆÏÂÀ´µÄËùÓб¾¼¶Éú³ÉµÄSQLÓï¾ä¼´¿É¡£

½ñÌì¾Í˵µ½ÕâÀÃ÷Ìì¼ÌÐøËµÊý¾Ý¿âcao×÷¡£
¶¥¶Ë Posted: 2008-12-17 11:34 | 2 Â¥
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£ºÑ§»áÁ¬½ÓÊý¾Ý¿â

PHP¼òÖ±¾ÍÊÇÒ»¸öº¯Êý¿â£¬·á¸»µÄº¯ÊýʹPHPµÄijЩµØ·½Ï൱¼òµ¥¡£½¨Òé´ó¼ÒdownÒ»±¾PHPµÄº¯ÊýÊֲᣬ×ÜÓõĵ½¡£

ÎÒÕâÀï¾Í¼òµ¥ËµÒ»ÏÂÁ¬½ÓMYSQLÊý¾Ý¿â¡£

1¡¢mysql_connect

´ò¿ª MySQL ·þÎñQÁ¬½Ó¡£
Óï·¨: int mysql_connect(string [hostname] [:port], string [username], string [password]); ·µ»ØÖµ: ÕûÊý

±¾º¯Êý½¨Á¢Óë MySQL ·þÎñQµÄÁ¬½Ó¡£ÆäÖÐËùÓеIJÎÊý¶¼¿ÉÊ¡ÂÔ¡£µ±Ê¹Óñ¾º¯ÊýÈ´²»¼ÓÈκβÎÊýʱ£¬²ÎÊý hostname µÄĬÈÏֵΪ localhost¡¢²ÎÊý username µÄĬÈÏֵΪ PHP Ö´ÐÐÐг̵ÄÓµÓÐÕß¡¢²ÎÊý password ÔòΪ¿Õ×Ö·û´® (¼´Ã»ÓÐÃÜÂë)¡£¶ø²ÎÊý hostname ºóÃæ¿ÉÒÔ¼ÓðºÅÓë¶Ë¿ÚºÅ£¬´ú±íʹÓÃÄĸö¶Ë¿ÚÓë MySQL Á¬½Ó¡£µ±È»ÔÚʹÓÃÊý¾Ý¿âʱ£¬ÔçµãʹÓà mysql_close() ½«Á¬½Ó¹Øµô¿ÉÒÔ½ÚÊ¡×ÊÔ´¡£

2¡¢ mysql_select_db

Ñ¡ÔñÒ»¸öÊý¾Ý¿â¡£
Óï·¨: int mysql_select_db(string database_name, int [link_identifier]); ·µ»ØÖµ: ÕûÊý

±¾º¯ÊýÑ¡Ôñ MySQL ·þÎñQÖеÄÊý¾Ý¿âÒÔ¹©Ö®ºóµÄ×ÊÁϲéѯ×÷Òµ (query) ´¦Àí¡£³É¹¦·µ»Ø true£¬Ê§°ÜÔò·µ»Ø false¡£

×î¼òµ¥µÄÀý×Ó¾ÍÊÇ£º
$conn=mysql_connect ("127.0.0.1", "", "");
mysql_select_db("shop");
Á¬½ÓJMY SQLÊý¾Ý¿â£¬´ò¿ªSHOPÊý¾Ý¿â¡£ÔÚʵ¼ÊÓ¦ÓÃÖÐÓ¦µ±¼ÓÇ¿µã´íÎóÅжϡ£

½ñÌì¾Í˵µ½ÕâÀÃ÷ÌìÔÙ˵һÏÂÊý¾Ý¿âµÄ¶ÁÈ¡¡£
¶¥¶Ë Posted: 2008-12-17 11:34 | 3 Â¥
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£ºÑ§»á¶ÁÈ¡Êý¾Ý

ÏÈ¿´Á½¸öº¯Êý£º
1¡¢mysql_query
ËͳöÒ»¸ö query ×Ö·û´®¡£ Óï·¨: int mysql_query(string query, int [link_identifier]); ·µ»ØÖµ: ÕûÊý

±¾º¯ÊýËͳö query ×Ö·û´®¹© MySQL ×öÏà¹ØµÄ´¦Àí»òÕßÖ´ÐС£ÈôûÓÐÖ¸¶¨ link_identifier ²ÎÊý£¬Ôò³ÌÐò»á×Ô¶¯Ñ°ÕÒ×î½ü´ò¿ªµÄ ID¡£µ± query ²éѯ×Ö·û´®ÊÇ UPDATE¡¢INSERT ¼° DELETE ʱ£¬·µ»ØµÄ¿ÉÄÜÊÇ true »òÕß false£»²éѯµÄ×Ö·û´®ÊÇ SELECT Ôò·µ»ØÐ嵀 ID Öµ£¬µ±·µ»Ø false ʱ£¬²¢²»ÊÇÖ´Ðгɹ¦µ«ÎÞ·µ»ØÖµ£¬¶øÊDzéѯµÄ×Ö·û´®ÓдíÎó¡£

2¡¢mysql_fetch_object ·µ»ØÀà×ÊÁÏ¡£ Óï·¨: object mysql_fetch_object(int result, int [result_typ]); ·µ»ØÖµ: Àà

±¾º¯ÊýÓÃÀ´½«²éѯ½á¹û result ²ðµ½Àà±äÁ¿ÖС£Èô result ûÓÐ×ÊÁÏ£¬Ôò·µ»Ø false Öµ¡£

¿´Ò»¸ö¼òµ¥µÄÀý×Ó£º
<?
$exec="select * from user";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo "username:".$rs->username."<br>";
}
?>
µ±È»£¬±íuserÖÐÓÐÒ»¸öusernameµÄ×ֶΣ¬Õâ¾ÍÀàËÆaspÖеÄ
<%
exec="select * from user"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
do while not rs.eof
response.write "username:"&rs("username")&"<br>"
rs.movenext
loop
%>
µ±È»ÏÈÒªÁ¬½ÓÊý¾Ý¿â£¬Ò»°ãÎÒÃÇ require_once('conn.php');¶øconn.phpÀïÃæ¾ÍÊÇÉÏÒ»´Î˵µÄÁ¬½ÓÊý¾Ý¿âµÄ´úÂë¡£

ССµÄÁ½ÌõÃüÁî¿ÉÒÔÍê³É¶ÁÈ¡Êý¾ÝµÄ¹¤×÷ÁË£¬½ñÌì˵µ½ÕâÀïÏÂÒ»´Î˵Êý¾ÝµNí¼Óɾ³ýÐ޸ġ£
¶¥¶Ë Posted: 2008-12-17 11:34 | 4 Â¥
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£ºÑ§»áÌí¼Óɾ³ýÐÞ¸ÄÊý¾Ý

mysql_query($exec);
µ¥Õâ¸öÓï¾ä¾Í¿ÉÒÔÖ´ÐÐËùÓеÄcao×÷ÁË£¬²»Í¬µÄ¾ÍÊÇ$execÕâ¸ösqlÓï¾ä

Ìí¼Ó£º$exec="insert into tablename (item1,item2) values ('".$_POST['item1']."',".$_POST['item1'].")";

ɾ³ý£º$exec="delete from tablename where...";

Ð޸ģº$exec="update tablename set item1='".$_POST['item1']."' where ...";

˵µ½ÕâÀï¾ÍҪ˵һÏÂ±íµ¥ºÍphp±äÁ¿´«µÝ£¬Èç¹û±íµ¥ÖеÄÒ»¸ö <input name="item1" type="text" id="item1">
±íµ¥ÒÔPOSTÌá½»µÄ£¬ÄÇô´¦Àí±íµ¥Îļþ¾Í¿ÉÒÔÓÃ$_POST['item1']µÃµ½±äÁ¿Öµ£¬Í¬ÑùÒÔGETÌá½»µÄ¾ÍÊÇ$_GET['item1']

ÊDz»ÊǺܼòµ¥£¿µ«ÊÇͨ³£$exec»áÓÐÎÊÌ⣬ÒòΪ¿ÉÄÜÄúµÄSQLÓï¾ä»áºÜ³¤£¬Äú»áÒÅ©.Á¬½Ó·û£¬»òÕß'À´°üΧ×Ö·ûÐÍ×ֶΡ£
ÎÒÃÇ¿ÉÒÔ×¢ÊÍmysql_query($exec);Óï¾äÓÃecho $exec;´úÌæÀ´Êä³ö$execÒÔ¼ì²éÕýÈ·X¡£Èç¹ûÄú»¹²»Äܲì¾õ$execÓÐʲô´íÎóµÄ»°£¬¿ÉÒÔ¸´ÖÆÕâ¸ösqlÓï¾äµ½phpmyadminÖÐÖ´ÐУ¬¿´¿´ËüµÄ³ö´íÐÅÏ¢¡£»¹ÓÐÐèҪעÒâµÄÊÇ£¬ÎÒÃDz»ÒªÊ¹ÓÃһЩÃô¸ÐµÄ×Ö·û´®×÷Ϊ×Ö¶ÎÃû×Ö£¬·ñÔòºÜ¿ÉÄÜ»á³öÏÖÎÊÌ⣬±ÈÈç˵dateʲôµÄ¡£±äÁ¿µÄÃüÃû£¬×ֶεÄÃüÃû×ñÑ­Ò»µã¹æÂÉÓеÄʱºò¶Ô×Ô¼ºÊÇÒ»Öֺô¦£¬³õѧÕß²¢²»¿ÉºöÊÓÆäÖØÒªX¡£

½ñÌì¾Í˵µ½ÕâÀ´ó¼Ò¿ÉÒÔDOWNÒ»¸öSQLÓï¾äµÄ²Î¿¼ÊֲᣬÔÙÑо¿Ñо¿¡£Ã÷Ìì¼ÌÐøËµSESSION¡£
¶¥¶Ë Posted: 2008-12-17 11:34 | 5 Â¥
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£ºÑ§»áSESSIONµÄʹÓÃ

SESSIONµÄ×÷Óúܶ࣬×î¶àÓõľÍÊÇÕ¾µãÄÚÒ³Ãæ¼ä±äÁ¿´«µÝ¡£ÔÚÒ³Ãæ¿ªÊ¼ÎÒÃÇÒªsession_start();¿ªÆôSESSION£»
È»ºó¾Í¿ÉÒÔʹÓÃSESSION±äÁ¿ÁË£¬±ÈÈç˵Ҫ¸³Öµ¾ÍÊÇ£º$_SESSION['item']="item1";ÒªµÃµ½Öµ¾ÍÊÇ$item1=$_SESSION['item'];£¬ºÜ¼òµ¥°É¡£ÕâÀïÎÒÃÇ¿ÉÄÜ»áʹÓõ½Ò»Ð©º¯Êý£¬±ÈÈç˵ÅжÏÊDz»ÊÇijSESSION±äÁ¿Îª¿Õ£¬¿ÉÒÔÕâôд£ºempty($_SESSION['inum'])·µ»Øtrue or false¡£

ÏÂÃæ×ÛºÏÒ»ÏÂÇ°ÃæËù˵µÄÎÒÃÇÀ´¿´Ò»¸öµÇ½³ÌÐò£¬ÅжÏÓû§ÃûÃÜÂëÊÇ·ñÕýÈ·¡£
µÇ½±íµ¥ÊÇÕâÑù£ºlogin.php
<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<form action="checklogin.php" method="post"><td align="center" valign="middle"><table width="400" border="0" cellpadding="5" cellspacing="1" class="tablebg">
<tr class="tdbg">
<td colspan="2"><div align="center">Administrators Login</div></td>
</tr>
<tr class="tdbg">
<td><div align="center">Username</div></td>
<td><div align="center">
<input name="username" type="text" id="username">
</div></td>
</tr>
<tr class="tdbg">
<td><div align="center">Password</div></td>
<td><div align="center">
<input name="password" type="password" id="password">
</div></td>
</tr>
<tr class="tdbg">
<td colspan="2"><div align="center">
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Submit2" value="Clear">
</div></td>
</tr>
</table></td></form>
</tr>
</table>

´¦ÀíÎļþÊÇÕâÑù
<?
require_once('conn.php');
session_start();
$username=$_POST['username'];
$password=$_POST['password'];
$exec="select * from admin where username='".$username."'";
if($result=mysql_query($exec))
{
if($rs=mysql_fetch_object($result))
{
  if($rs->password==$password)
  {
    $_SESSION['adminname']=$username;
    header("location:index.php");
  }
  else
  {
    echo "<script>alert('Password Check Error!');location.href='login.php';</script>";
  }
}
else
{
echo "<script>alert('Username Check Error!');location.href='login.php';</script>";
}
}
else
{
echo "<script>alert('Database Connection Error!');location.href='login.php';</script>";
}

?>

conn.phpÊÇÕâÑù£º
<?
$conn=mysql_connect ("127.0.0.1", "", "");
mysql_select_db("shop");
?>

ÓÉÓÚ $_SESSION['adminname']=$username;ÎÒÃÇ¿ÉÒÔÕâÑùдÑéÖ¤ÊÇ·ñµÇ½Óï¾äµÄÎļþ£ºcheckadmin.asp
<?
session_start();
if($_SESSION['adminname']=='')
{
echo "<script>alert('Please Login First');location.href='login.php';</script>";
}
?>

ºÇºÇ£¬½ñÌì˵µ½ÕâÀÃ÷Ìì˵һÏÂÔõôŪһ¸ö·ÖÒ³¡£
¶¥¶Ë Posted: 2008-12-17 11:35 | 6 Â¥
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£º×öÒ»¸ö·ÖÒ³ÏÔʾ

¹Ø¼ü¾ÍÊÇÓõ½ÁËSQLÓï¾äÖеÄlimitÀ´ÏÞ¶¨ÏÔʾµÄ¼Ç¼´Ó¼¸µ½¼¸¡£ÎÒÃÇÐèÒªÒ»¸ö¼Ç¼µ±Ç°Ò³µÄ±äÁ¿$page£¬»¹ÐèÒª×ܹ²µÄ¼Ç¼Êý$num

¶ÔÓÚ$pageÈç¹ûûÓÐÎÒÃǾÍÈÃËü=0£¬Èç¹ûÓÐ<0¾ÍÈÃËüÒ²=0£¬Èç¹û³¬¹ýÁË×ܵÄÒ³Êý¾ÍÈÃËû=×ܵÄÒ³Êý¡£

$execc="select count(*) from tablename ";
$resultc=mysql_query($execc);
$rsc=mysql_fetch_array($resultc);
$num=$rsc[0];

ÕâÑù¿ÉÒԵõ½¼Ç¼×ÜÊý
ceil($num/10))Èç¹ûÒ»Ò³10¼Ç¼µÄ»°£¬Õâ¸ö¾ÍÊÇ×ܵÄÒ³Êý

ËùÒÔ¿ÉÒÔÕâôд
if(empty($_GET['page']))
{
$page=0;
}
else
{
$page=$_GET['page'];
if($page<0)$page=0;
if($page>=ceil($num/10))$page=ceil($num/10)-1;//ÒòΪpageÊÇ´Ó0¿ªÊ¼µÄ£¬ËùÒÔÒª-1
}

ÕâÑù$exec¿ÉÒÔÕâôд $exec="select * from tablename limit ".($page*10).",10";
//Ò»Ò³ÊÇ10¼Ç¼µÄ

×îºóÎÒÃÇÐèÒª×öµÄ¾ÍÊǼ¸¸öÁ¬½Ó£º
<a href="xxx.php?page=0">FirstPage</a>
<a href="xxx.php?page=<?=($page-1)?>">PrevPage</a>
<a href="xxx.php?page=<?=($page+1)?>">NextPage</a>
<a href="xxx.php?page=<?=ceil($num/10)-1?>">LastPage</a>

ÕâÊÇÒ»¸ö´óÖµÄ˼·£¬´ó¼Ò¿ÉÒÔÏëÏëÔõôÀ´ÓÅ»¯£¿½ñÌì˵µ½ÕâÀÃ÷Ìì˵һÏÂһЩעÒâµÄÎÊÌâ¡£
¶¥¶Ë Posted: 2008-12-17 11:35 | 7 Â¥
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£º×¢ÒâÊÂÏî

ÒòΪÎÒÊÇÏÈѧASPµÄ£¬ËùÒÔÔÙ×öPHPµÄʱºò»á·¢ÏÖºÜ¶àµØ·½ÐèÒªÊÊÓ¦¡£

1¡¢×¢ÒⲻҪ©ÁË·ÖºÅ
2¡¢×¢ÒⲻҪ©Á˱äÁ¿Ç°µÄ$
3¡¢Ê¹ÓÃSESSIONµÄʱºò×¢Òâ²»ÒªÒÅ©session_start();

Èç¹û·¢Éú´íÎóµÄʱºò£¬¿ÉÒÔ²ÉÓÃÒÔÏ·½·¨£º
1¡¢Èç¹ûÊÇSQLÓï¾ä³ö´í£¬¾Í×¢ÊÍÁËÈ»ºóÊä³öSQLÓï¾ä£¬×¢ÒâҲҪעÊ͵÷ºóÐøµÄÖ´ÐÐSQLÓï¾ä
2¡¢Èç¹ûÊDZäÁ¿Îª¿Õ£¬´ó¶àÊÇûÓд«µÝµ½Î»£¬Êä³ö±äÁ¿¼ì²éһϣ¬¼ì²éÒ»ÏÂ±íµ¥µÄidºÍname
3¡¢Èç¹ûÊÇÊý¾Ý¿âÁ¬½Ó³ö´í£¬¼ì²éÊÇ·ñÕýÈ·´ò¿ªMY SQLºÍÊÇ·ñÒÅ©ÁËÁ¬½ÓÓï¾ä
4¡¢×¢ÒâËõ½ø£¬ÅųýÀ¨ºÅ²»ÇøÅäµÄ´íÎó

ÔÚ×ö´óÍøÕ¾µÄʱºò£¬ÎÒµÄ˼·ÊÇÏȹ¹½¨Êý¾Ý¿â£¬È·¶¨Ã¿Ò»¸ö×ֶεÄ×÷Ó㬺ͱíÖ®¼äµÄ¹ØÏµ¡£È»ºóÉè¼Æºǫ́½çÃæ£¬´ÓÌí¼ÓÊý¾Ý¿ªÊ¼×öÆð£¬ÒòΪÌí¼ÓÊÇ·ñ³É¹¦¿ÉÒÔÖ±½Óµ½Êý¾Ý¿âÀïÃæÑéÖ¤£¬×öºÃÁËÌí¼ÓÔÙ×öÏÔʾµÄÒ³Ãæ£¬×îºó²ÅÊÇÁ½ÕߵĽáºÏ¡£Ò»°ãÀ´Ëµºǫ́¾Í°üÀ¨Ìí¼Óɾ³ýÐ޸ĺÍÏÔʾ£¬ºǫ́ûÓÐÎÊÌâÁË£¬Ç°Ì¨Ò²Ã»ÓÐʲô´óÎÊÌ⡣ǰ̨»¹ÐèҪעÒⰲȫXºÍÈÝ´í»¹ÓоÍÊÇÊä³ö¸ñʽ¡£

ºÃÁË£¬½ñÌì˵µ½ÕâÀÃ÷Ìì˵һÏÂÈç¹ûÓÃPHPÉÏ´«ÎļþºÍ·¢Óʼþ¡£
¶¥¶Ë Posted: 2008-12-17 11:35 | 8 Â¥
(ÀëÏß) yf2088
Ö÷´ò½ÇÉ«:MOMO
Ðû´«´óʹ½±
¼¶±ð: ¾«ÁéÍõ


¾«»ª: 4
·¢Ìû: 633
ÍþÍû: 824 µã
ÂÛ̳±Ò: 857 AYB
¹±Ï×Öµ: 1176 µã
ÔÚÏßʱ¼ä:420(Сʱ)
×ۺϻý·Ö:2769 µã
×¢²áʱ¼ä:2008-11-03
×îºóµÇ¼:2019-05-11

 

ѧϰĿµÄ£ºÑ§»áÓÃPHPÉÏ´«ÎļþºÍ·¢Óʼþ

ÉÏ´«Îļþ±íµ¥±ØÐë¼ÓÉÏ enctype="multipart/form-data"
ºÍ <input type="file" name="file">
ÏÂÃæ¿´Ò»Ï´úÂ룺

$f=&$HTTP_POST_FILES['file'];
$dest_dir='uploads';//É趨ÉÏ´«Ä¿Â¼
$dest=$dest_dir.'/'.date("ymd")."_".$f['name'];//ÎÒÕâÀïÉèÖÃÎļþÃûΪ¨ÖÆÚ¼ÓÉÏÎļþÃû±ÜÃâÖØ¸´
$r=move_uploaded_file($f['tmp_name'],$dest);
chmod($dest, 0755);//É趨ÉÏ´«µÄÎļþµÄÊôX

ÉÏ´«µÄÎļþÃûΪdate("ymd")."_".$f['name'] £¬¿ÉÒÔÔÚÒÔºó*Èëµ½Êý¾Ý¿âµÄʱºòÓõ½£¬PHPʵ¼ÊÉÏÊǰÑÄãÉÏ´«µÄÎļþ´ÓÁÙÊ±Ä¿Â¼ÒÆ¶¯µ½Ö¸¶¨Ä¿Â¼¡£move_uploaded_file($f['tmp_name'],$dest);ÕâÊQؼü

ÖÁÓÚ·¢Óʼþ¾Í¸ü¼Ó¼òµ¥£¬¿ÉÒÔʹÓÃmail()º¯Êý

mail("ÊÕ¼þÈ˵ØÖ·","Ö÷Ìâ","ÕýÎÄ","From:·¢¼þÈË
Reply-to:·¢¼þÈ˵ĵØÖ·");

²»¹ýmail()ÐèÒª·þÎñQµÄÖ§³Ö£¬ÔÚWINDOWSÏ»¹ÐèÒªÅäÖÃSMTP·þÎñQ£¬Ò»°ãÀ´ËµÍâÃæµÄLINUX¿Õ¼ä¶¼ÐС£
ºÃÏñÉÏ´«ÎļþºÍ·¢Óʼþ±ÈASP¼òµ¥ºÜ¶à£¬Ö»Òªµ÷Óú¯Êý¾Í¿ÉÒÔÁË¡£ASP»¹ÐèÒªÓõ½·þÎñQµÄ²»Í¬×é¼þ±ÈÈçFSO¡¢JMAILʲôµÄ¡£

Ê®Ììѧ»áPHP˵µ½ÕâÀïÁË£¬ÎÒµÄÈý´óϵÁÐÎÄÕ¶¼Óá¶Ê®Ììѧ»á¡·×÷ΪÃû×Ö£¬Ïë¸æËß´ó¼ÒµÄÊÇASP,PHP,ASP.NETÈëÃŶ¼¿ÉÒÔÊÇÊ®Ì죬µ«ÊǾ«Í¨¾ö²»ÊÇÊ®Ìì°¡£¬»¹ÐèÒª´ó¼Ò×Ô¼ºÈ¥Ñо¿¡£
¶¥¶Ë Posted: 2008-12-17 11:36 | 9 Â¥
« 1 2» Pages: ( 1/2 total )
Ìû×Óä¯ÀÀ¼Ç¼ °æ¿éä¯ÀÀ¼Ç¼
åÛÓÎÆæ¼£µÚ¶þÊ®¼¾ » ¡¼Çé¸ÐÏÐÁÄ¡½