php+sqlserver È¡¼Ç¼ʱµÃµ½idµÄÎÊÌ⣬ÔÚÏßµÈ
ÒÑÖª sql serverÖÐ
$server="se";
$username="us";
$password="pa";
$datebase="ds";
1 ÏÖҪȡsql serverÖÐ body ±í(×Ö¶ÎΪid, title) ÖеÄid£¬ÒªÒ»ÌõÒ»ÌõµÄÈ¡³öÀ´£¬²¢Êä³ö£¬
²¢ÔÙÊä³ö£º¡°Äã×îºóÈ¡µ½µÄÒ»Ìõ¼Ç¼µÄidÊÇ¡£¡£¡£¡±
ÔõôʵÏÖѽ£¬Ð»Ð»
SQL code:
select id,title from body b where
not exists
(select 1 from body where id>b.id);
$sql="select id,title from shishi order by id desc limit 1 ";
Ïà¹ØÎÊ´ð£º
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÎÒ×÷Ò»Õâ¸ö¶àÑ¡±íµ¥£º
<input type="checkbox" name="services[]" value="½»Á÷ƽ̨" />
½»Á÷ƽ̨
......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......