PHP.docx
- 文档编号:30337807
- 上传时间:2023-08-13
- 格式:DOCX
- 页数:21
- 大小:19.20KB
PHP.docx
《PHP.docx》由会员分享,可在线阅读,更多相关《PHP.docx(21页珍藏版)》请在冰豆网上搜索。
PHP
一、新闻:
(数据库名为news)
⒈Public文件夹下:
①conn.php
php
$conn=mysql_connect("localhost","root","root");
mysql_select_db("news",$conn);
mysql_query("setnames'utf8'");
?
>
②在images文件夹下存放所需背景图片
⒉a.php
?
php
include("public/conn.php");
$bad=array("/李天一/","/共产党/","/TMD/i","/薄熙来/");
echopreg_replace($bad,"**","李天一是不是共产党员吗不是吧,薄熙来曾经是,TMD,TMD,tmd");
echo$we;
?
>
/body>
123.php
php
include('public/conn.php');
$str=$_POST[select1]
$key=$_POST[text1];
if($str=="按标题")
{$sql="select*fromtb_newswherenews_titlelike'%$key%'";
$query=mysql_query($sql);
while($rs=mysql_fetch_array($query))
{$rep="
";
echostr_replace($key,$rep,$rs[news_title]);
}}
else
{$sql="select*fromtb_newswherenews_contentlike'%$key%'";
$query=mysql_query($sql);
while($rs=mysql_fetch_array($query))
{$rep="
";
echostr_replace($key,$rep,$rs[news_title]);
}
}
?
>
beichuandi.php
php
echo$_GET[name];
echo$_GET[sex];
?
>
Chuandi.php
name=123&sex=女">abc fengye.php
php
include("public/conn.php");
$pagesize=5;
$sql="selectcount(*)fromtb_news";
$query=mysql_query($sql);
$rs=mysql_fetch_array($query);
$newsnum=$rs[0];
$pagenum=ceil($newsnum/$pagesize);
$page=empty($_GET[page])?
1:
$_GET[page];
echo$page;
$sql1=$sql="select*fromtb_newslimit".($page-1)*$pagesize.",".$pagesize;
$query1=mysql_query($sql1);
while($rs1=mysql_fetch_array($query1))
{echo$rs1[news_title]."
";}
for($i=1;$i<=$pagenum;$i++)
{echo" page=".$i."'>".$i."";} ? > index.php a: link{color: #000;text-decoration: none;} a: visited{text-decoration: none;color: #000;} a: hover{text-decoration: none;color: #F00;} a: active{text-decoration: none;color: #F00;}
教学网站的设计与开发
typeid=1">
php
$sql="select*fromtb_newswherenews_type=1orderbyiddesclimit5";
$rs=mysql_query($sql);
while($row1=mysql_fetch_array($rs))
{echo" news_id=$row1[id]'>".$row1[news_title]." $str=$row1[news_content];} ? >
";
typeid=2">
php
$sql="select*fromtb_newswherenews_type=2orderbyiddesclimit0,5";
$rs=mysql_query($sql);
while($row2=mysql_fetch_array($rs))
{echo$row2[news_title]."
";}
?
>
typeid=1">
php
$sql="select*fromtb_newswherenews_type=1orderbyiddesclimit5";
$rs=mysql_query($sql);
while($row1=mysql_fetch_array($rs))
{echo" news_id=".$row1[id]."'>".$row1[news_title]." } ? >
";
typeid=1">
php
$sql="select*fromtb_newswherenews_type=1orderbyiddesclimit5";
$rs=mysql_query($sql);
while($row1=mysql_fetch_array($rs))
{echo" news_id=".$row1[id]."'>".$row1[news_title]." ? >
";}
typeid=1">
php
$sql="select*fromtb_newswherenews_type=1orderbyiddesclimit5";
$rs=mysql_query($sql);
while($row1=mysql_fetch_array($rs))
{echo" news_id=".$row1[id]."'>".$row1[news_title]." ? >
";}
typeid=1">
php
$sql="select*fromtb_newswherenews_type=1orderbyiddesclimit5";
$rs=mysql_query($sql);
while($row1=mysql_fetch_array($rs))
{echo" news_id=".$row1[id]."'>".$row1[news_title]." ? >
";}
typeid=1">
php
$sql="select*fromtb_newswherenews_type=1orderbyiddesclimit5";
$rs=mysql_query($sql);
while($row1=mysql_fetch_array($rs))
{echo" news_id=".$row1[id]."'>".$row1[news_title]." ? >
";}
typeid=1">
php
$sql="select*fromtb_newswherenews_type=1orderbyiddesclimit5";
$rs=mysql_query($sql);
while($row1=mysql_fetch_array($rs))
{echo" news_id=".$row1[id]."'>".$row1[news_title]." ? >
";}
new_content.php
.bbb{border:
mediumsolid#DDDFFE;}
php
include("public/conn.php");
$id=$_GET[news_id];
$sql="select*fromtb_newswhereid=$id";
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs))
{echo"
echo"
";
echo"内容".$row[news_content];
}
?
>
nesw_list.php
.aaa{border:
mediumsolid#DDDFFE;}
php
include("public/conn.php");
$type=$_GET[typeid];
$pagesize=4;
$sql1="selectcount(*)fromtb_newswherenews_type=$type";
$rs1=mysql_query($sql1);
$row1=mysql_fetch_array($rs1);
$newsnum=$row1[0];
$pagenum=ceil($newsnum/$pagesize);
$page=empty($_GET[page])?
1:
$_GET[page];
$sql="select*fromtb_newswherenews_type=$typeorderbyiddesclimit".($page-1)*$pagesize.",".$pagesize."";
$rs=mysql_query($sql);
while($row=mysql_fetch_array($rs))
{echo" news_id=".$row[id]."'>".$row[news_title]." } echo" ? >
";
";
phpfor($i=1;$i<=$pagenum;$i++)
{echo" page=".$i."&typeid=".$type."'>".$i." ";} ? >
timedaojishi.php
php
date_default_timezone_set("Asia/ShangHai");
echo"当前时间是".date("y年m月d日,H点i分s秒")."
";
$time=time();
$time1=strtotime("2013-10-1");
echo"距离2013年的国庆节还有".ceil((($time1-$time)/(60*60*24)))."天
";
?
>
Untitled-1.php
php
$str="/^[0-9]{18}|^[0-9]{17}[a-z]|^\d{15}/";
echopreg_match($str,"w352229198802063",$nes)."
";
echo$nes[0]
?
>
Untitled-2
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- PHP