ÓÃPHPÅÅÐòmysqlÎÊÌâ
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀïÓÃPHP code:
$sql="SELECT * from retabs ORDER BY num asc";
$results=mysql_query($sql)
or die("ÅÅÐòʧ°Ü".mysql_error);
Ò²²»ÐУ¡ÓôÃÆËÀÁË£¡Ò²²»ÌáʾÅÅÐòʧ°Ü£¡
ÇëÎÊÕâ¸öÊÇÔõô»ØÊ°¡£¿
лл´ó¼ÒÁË
PHP code:
ÄãÒª°´IDÅÅÐòÓ¦¸ÃÊÇ£º
select * from retabs order by id;
¶î »Ø¶þÂ¥µÄ£¡ÎÒÄÇÅÅID×éËù¶ÔÓ¦µÄÃû×ÖÊÇnum£¬ºÇºÇ£¡
ÎÒµÄÓ﷨û´íµÄ
˰ﶥϰ¡ ллÁË
Äã°Ñ´íÎóÐÅÏ¢´òÓ¡³öÀ´¿´¿´
SQL code:
$sql="SELECT * from `retabs` ORDER BY `num` ASC";
¿´ÄãµÄÓï¾ä£¬Ó¦¸ÃûÓдíµÄ
ÄÇÄã°ÑID×éÉèÖóÉ×ÔÔöÀàÐÍ
SQL code:
alter table retable change num int auto_increment primary key
ÄãÓ¦¸Ã³¢ÊÔʹÓÃmysqlµÄÃüÁîÐÐÖвâÊÔÄãµÄsqlÓï¾äÓÐûÓÐÎÊÌâ¡£
Èç¹ûûÓÐÄã¾ÍÓ¦¸ÃÈ¥ÏëÏëÆäËûµØ·½µÄÎÊÌâ¡£
ÅÅÐòµ
Ïà¹ØÎÊ´ð£º
PHPÖÐtitleÈçºÎ¶¯Ì¬ÏÔʾµ±Ç°ÎÄÕµıêÌâ?
ÔÚtitleÖÐÿƪÎÄÕ¶¼ÊÇÏÔʾͬÑùµÄÄÚÈÝ.ÏëÈÃËû¶¯Ì¬ÏÔʾ.²»ÖªµÀÒªÈçºÎд²ÅÄܶ¯Ì¬ÏÔʾµ±Ç°ÎÄÕµıêÌâÄØ?
лл
PHPÖÐtitle£¿Ã»Ã÷°×£¬ÊDz»ÊÇHTMLµÄtitle°¡
Èç¹ûÊǵϰ£¬Äã¿ÉÒÔ ......
±¾ÈËÊÇÒ»¸öC++µÄ³ÌÐòÔ±£¬¹¤×÷¿ì6Ä꣬×î½üÏë×ö¸öÍøÕ¾£¬Ö÷ÒªµÄ¹¹Ë¼ÁË¡£
ѧϰPHP£¬²»ÖªµÀ£¬ÐèҪѧϰЩʲô¶«Î÷£¬»¹ÓоÍÊÇ£¬Ò»°ãÎÒÕâÖÖÇé¿öÒª¶à³¤Ê±¼ä£¬²Å¿ÉÒÔ Ð´Ò»¸öÍøÕ¾£¬ÔÚѧϰ֮ǰÎÊÎÊ£¬Ç°±² ÃÇ¡£
×Ô¼º×öµÄ»°£¬¾ÍÒ ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......