¹ÜÀíÌáÐÑ: ±¾Ìû±» ¡ïstar¡ï Ö´ÐмÓÁÁ²Ù×÷(2010-08-20) ±¾²¿·ÖÉ趨ÁËÒþ²Ø,ÄúÒѻظ´¹ýÁË,ÒÔÏÂÊÇÒþ²ØµÄÄÚÈÝ PHP³£ÓôúÂë
1¡¢Á¬½ÓMYSQLÊý¾Ý¿â´úÂë $connec=mysql_connect(\"localhost\or die(\"²»ÄÜÁ¬½ÓÊý¾Ý¿â·þÎñÆ÷£º \".mysql_error());
mysql_select_db(\"liuyanben\or die (\"²»ÄÜÑ¡ÔñÊý¾Ý¿â: \".mysql_error());
mysql_query(\"set names 'gbk'\"); ?>
2¡¢¶ÁÈ¡Êý¾Ý¿â£¬²¢ÊµÏÖÑ-»·Êä³ö $sql=\"select * from liuyan order by ly_id desc\"; $conn=mysql_query($sql,$connec);
while($rs=mysql_fetch_array($conn)){ ?>
Ñ-»·µÄÄÚÈÝ.........
3¡¢ÈçºÎʵÏÖ·ÖÒ³£¬°üÀ¨Á½¸öº¯Êý£¬Á½¸öµ÷Óà 1£©Á½¸öº¯Êý
//·ÖÒ³º¯Êý
function genpage(&$sql,$page_size=2) {
global $prepage,$nextpage,$pages,$sums; //out param $page = $_GET[\"page\"]; $eachpage = $page_size;
$pagesql = strstr($sql,\" from \");
$pagesql = \"select count(*) as ids \".$pagesql;
$conn = mysql_query($pagesql) or die(mysql_error()); if($rs = mysql_fetch_array($conn)) $sums = $rs[0]; $pages = ceil(($sums-0.5)/$eachpage)-1; $pages = $pages>=0?$pages:0; $prepage = ($page>0)?$page-1:0;
$nextpage = ($page<$pages)?$page+1:$pages; $startpos = $page*$eachpage;
$sql .=\" limit $startpos,$eachpage \"; }
//ÏÔʾ·ÖÒ³
function showpage() {
global $page,$pages,$prepage,$nextpage,$queryString; //param from genpage function $shownum =10/2;
$startpage = ($page>=$shownum)?$page-$shownum:0;
$endpage = ($page+$shownum<=$pages)?$page+$shownum:$pages;
echo \"¹²\".($pages+1).\"Ò³: \"; if($page>0)echo \"Ê×Ò³\"; if($startpage>0) echo \" ... ?\"; for($i=$startpage;$i<=$endpage;$i++) {
if($i==$page) echo \" [\".($i+1).\"] \"; else echo \" \".($i+1).\" \"; }
if($endpage<$pages) echo \"? ... \";
if($page<$pages)
echo \"βҳ\"; }
//ÏÔʾ´ø·ÖÀàµÄ·ÖÒ³ function showpage1() {
$fenlei=$_GET[\"fenleiid\"]; global $page,$pages,$prepage,$nextpage,$queryString; //param from genpage function $shownum =10/2;
$startpage = ($page>=$shownum)?$page-$shownum:0;
$endpage = ($page+$shownum<=$pages)?$page+$shownum:$pages;
echo \"¹²\".($pages+1).\"Ò³: \"; if($page>0)echo \"Ê×Ò³\"; if($startpage>0) echo \" ... ?\";
for($i=$startpage;$i<=$endpage;$i++)
{
if($i==$page) echo \" [\".($i+1).\"] \"; else echo \" \".($i+1).\" \"; }
if($endpage<$pages) echo \"? ... \"; if($page<$pages) echo \"βҳ\"; } ?>
2£©Á½¸öµ÷Óà µÚÒ»¸ö $sql=\"select * from liuyan order by ly_id desc\"; genpage($sql); //Ö»ÐèÒªÕý³£´úÂë¼ÓÉÏÕâÒ»ÐоÍok¡£ $conn=mysql_query($sql,$connec);
while($rs=mysql_fetch_array($conn)){ ?>
µÚ¶þ¸ö showpage(); //ÏÔʾҳ ?> mysql_close(); ?>
4¡¢·þÎñÆ÷¶Ë°üº¬
5¡¢ÈçºÎ½«Ò»Ìõ¼Ç¼дÈëÊý¾Ý¿â£¬È»ºóÌáʾ²¢Ìø×ªÒ³Ãæ $ly_title=$_POST[\"ly_title\"];
$ly_content=$_POST[\"ly_content\"]; $ly_time=$_POST[\"ly_time\"];
$ly_author=$_POST[\"ly_author\"]; $ly_email=$_POST[\"ly_email\"]; $sql=\"insert into
liuyan(ly_title,ly_content,ly_time,ly_author,ly_email)
values('\".$ly_title.\"','\".$ly_content.\"','\".$ly_time.\"','\".$ly_author.\"','\".$ly_email.\"')\"; mysql_query($sql,$connec); echo(\"\"); ?>
6¡¢µ¯³ö¶Ô»°¿ò£¬²¢·¢ÉúÒ³ÃæÌø×ª echo(\"\"); ?>
7¡¢ÐÅÏ¢²é¿´Ò³Ã棨ÓÐÌõ¼þ¶ÁÈ¡Êý¾Ý¿â£© 1)ÓÐÌõ¼þ¶ÁÈ¡Êý¾Ý¿â $sql=\"select * from liuyan where ly_id=$_GET[id]\"; $conn=mysql_query($sql,$connec); $rs=mysql_fetch_array($conn); ?>
2£©½«Ä³¸ö×Ö¶ÎÊä³ö =$rs[ly_title]?> 3£©¹Ø±ÕÊý¾Ý¿â mysql_close(); ?>
8¡¢¶ÔÊý¾Ý¿âÖÐijһÌõ¼Ç¼½øÐиüвÙ×÷£¬²¢×÷ÌáÊ¾Ìø×ª $ly_title=$_POST[\"ly_title\"];
$ly_content=$_POST[\"ly_content\"]; $ly_time=$_POST[\"ly_time\"];
$ly_author=$_POST[\"ly_author\"]; $ly_email=$_POST[\"ly_email\"]; $sql=\"update liuyan set ly_title='$ly_title',ly_content='$ly_content',ly_time='$ly_time',ly_author='$ly_author',ly_email='$ly_email' where ly_id=$_GET[id]\"; mysql_query($sql,$connec); echo(\"\"); ?>
9¡¢ÈçºÎɾ³ýÊý¾Ý¿âÖеÄÒ»Ìõ¼Ç¼ $sql=\"delete from liuyan where ly_id=$_GET[id]\"; mysql_query($sql,$connec); echo(\"\"); ?>
10¡¢ÈçºÎ½øÐлáÔ±µÇ¼ÑéÖ¤ session_start();
$username=$_POST[\"username\"]; $password=$_POST[\"password\"];
$sql=\"select * from admin where username='\".$username.\"' && password='\".$password.\"'\";
$result=mysql_query($sql,$connec); if($row=mysql_fetch_array($result)){ session_register(\"admin\"); $admin=$username; echo(\"\");} else {
echo(\"\"); }
mysql_close(); ?>
11¡¢ÈçºÎ¶ÔSESSION½øÐмìÑ飨ºǫ́¼ì²éÒ³ÃæµÄÖÆ×÷£© session_start();
if(!isset($_SESSION[\"admin\"])){ header(\"location:login.php\"); exit; } ?>
12¡¢ÑéÖ¤Óû§Ãû¼°ÃÜÂëÊÇ·ñÌîд£¨javascript£©
13¡¢ÔÚPHPÖе÷Óñà¼-Æ÷µÄ·½·¨
1£©½«±à¼-Æ÷Îļþ¼Ð·ÅÖúǫ́¹ÜÀíÎļþ¼ÐÄÚ¡£ 2£©ÀûÓÃÒÔÏÂÓï¾ä½øÐÐÒýÈë²Ù×÷¡£
×¢£ºeWebEditorPHP38±à¼-Æ÷Îļþ¼ÐµÄÃû³Æ¡£ id=contentÖÐcontentΪÉÏÃæÒþ²ØÓòµÄÃû³Æ 14¡¢Ñ-»·Êä³ö£¨Äܹ»ÊµÏÖ·ÖÁУ© 1£©Ê×ÏȲåÈëÒ»ÐÐÒ»Áбí¸ñ
±»Ñ-»·µÄÆäËü±í¸ñºÍÊä³ö | if ($i % 2==0) { echo \"
15¡¢¸øÏÂÀ-Áбí¿ò°ó¶¨Êý¾Ý(²¢ÇÒÔÚÐÞ¸ÄʱĬÈÏÑ¡ÖÐ) 16¡¢»ñÈ¡×Ö·û³¤¶Èº¯Êý strlen($c)>12
17¡¢¶¨ÒåÒ»¸ö×Ö·û½ØÈ¡º¯Êý
Ó÷¨£º=substrgb($rs[\"title\"],10)?> function substrgb($in,$num){ $pos=0; $out=\"\";
while($c=substr($in,$pos,1)){ if($c==\"\\n\") break; if(ord($c)>128){ $out.=$c; $pos++;
$c=substr($in,$pos,1);
$out.=$c; }else{
$out.=$c; }
$pos++;
if($pos>=$num) break; }
if($out!=$in) $out = $out . \"...\"; return $out; }
18¡¢ÅжÏÊÇ·ñÊÇÊý×Ö !is_numeric(qq)
19¡¢PHP¼¼ÊõÖлñÈ¡µ±Ç°ÈÕÆÚ $ptime=date(\"y-m-d\");
20¡¢Óû§×¢²áʱËùʹÓõÄPHPÑéÖ¤³ÌÐò
if ($admin==\"\" or (strlen($admin)>16) or (strlen($admin)<2)) { echo \"\"; }
if ($password==\"\" or strlen($password)>16 or strlen($password)<6) { echo \"\"; }
if ($password==\"\") {
echo \"\"; }else{
if ($password!=$password1) { echo \"\"; } }
if ($wt=\"\") {
echo \"\"; }
if ($da=\"\") {
echo \"\"; }
if ($qq!=\"\") {
if (!is_numeric($qq)) {
echo \"\"; } }
if ($youbian==\"\" or strlen($youbian)!=6) {
echo \"\"; }
if ($youbian!=\"\") {
if (!is_numeric($youbian)) {
echo \"\"; } }
if ($dizhi=\"\") {
echo \"\"; }
if ($mail==\"\") {
echo \"\"; }
if ($textarea==\"\") {
echo \"\"; }
if ($textarea==\"\" or strlen(textarea)>150) { echo \"\"; }
24¡¢¶ÔÊä³öµÄÄÚÈݽøÐÐÅжϣ¬´Ó¶øÊä³öÆäËü½á¹û if ($rs[\"active\"]==1) {
echo \"¼¤»î\"; }else{
echo \"½ûÓÃ\"; } ?>
25.×Ö·û½ØÈ¡º¯Êý
=substr(\"$rs[zixun_biaoti]\ )?>
26.ÄÐÅ®ÎÊÌâ»òµ¥Ñ¡´øÑ¡ÔñµÄ
($rs[\"hy_zhungtai\"]===\"ÄÐ\") { echo \"checked\";}?>> ÄÐ
> Å®
27.µ¥Ñ¡²»´øµ¥Ñ¡¿òµÄ
&action=no\">½âËø ËüµÄ saveÒ³ÊÇ
$hy_id=$_GET['id'];
$action=$_GET['action']; if ($action=='yes'){
$sql=\"update hybiao set hy_zhuangtai='Ëø¶¨' where hy_id='$id'\"; $query=mysql_query($sql,$connec); echo(\"\"); }
else{
$sql=\"update hybiao set hy_zhuangtai='Õý³£' where hy_id='$id'\"; $query=mysql_query($sql,$connec); echo(\"\"); }
mysql_close(); ?>
28.Èç¹ûÎÄ×Ö¹ý³¤,Ôò½«¹ý³¤µÄ²¿·Ö±ä³ÉÊ¡ÂÔºÅÏÔʾ
½ûÖ¹¸´ÖÆ£¬Êó±êÍ϶¯Ñ¡È¡
30.´ó ÖРС ÎÄ×ֵı仯
ÐèÒªÖ¸¶¨´óСµÄÎÄ×Ö ´ó ÖРС 30.
Ìí¼Óµ½ÊղؼкÍÉèΪÊ×Ò³ ÉèΪÊ×Ò³ href=\"javascript:window.external.AddFavorite('http://www.makewing.com/lanren/','ÀÁÈËͼ¿â')\">Êղر¾Õ¾ 31.
¼Ç¼²¢ÏÔÊ¾ÍøÒ³µÄ×îºóÐÞ¸Äʱ¼ä 32.
½ÚÈÕµ¹¼ÆÊ±
33.
´ò¿ª´°¿Ú¼´×î´ó»¯
34.
¼ÓÈë±³¾°ÒôÀÖ