ホームページ > php教程 > php手册 > 最基础的PHP分类查询程序,php分类查询程序

最基础的PHP分类查询程序,php分类查询程序

WBOY
リリース: 2016-06-13 09:24:24
オリジナル
1032 人が閲覧しました

最基础的PHP分类查询程序,php分类查询程序

<span>最初级的PHP分类查询程序

</span><!DOCTYPE html <span>PUBLIC</span> "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>

<div  align="center"><form action="<?php <span>$_SERVER</span>['PHP_SELF'];?>" method="post"><input type="submit" name="sell" value="智慧销售" />     &<span>nbsp;
</span><input type="submit" name="manager" value="经营管理"/>      <input type="submit" name="serve" value="智慧客服" 

/>      <input type="submit" name="newemployee" value="智慧新员工" />      <<span>input 

type</span>="submit" name="development" value="个人发展" /></form>





<?<span>php
</span><span>if</span>(!<span>empty</span>(<span>$_POST</span>['sell'<span>])){

</span><span>$conn</span>=<span>mysql_connect</span>("localhost","root","root"<span>);
</span><span>if</span>(!<span>$conn</span><span>){
</span><span>die</span>('Could not connect the database!'<span>);
}
</span><span>mysql_query</span>("SET NAMES UTF8"<span>);
</span><span>mysql_query</span>("set character_set_client=utf8"<span>); 
</span><span>mysql_query</span>("set character_set_results=utf8"<span>);
</span><span>mysql_select_db</span>("test",<span>$conn</span><span>);
</span><span>$sql</span>="select * from ts1 where name like '%智慧销售%' "<span>;
</span><span>$result</span>=<span>mysql_query</span>(<span>$sql</span><span>);
</span><span>echo</span> '<table height="60%"  width="60%" border="1"  align="center">'<span>;
</span><span>while</span>(<span>$row</span>=<span>mysql_fetch_assoc</span>(<span>$result</span><span>)){
</span><span>echo</span> '<tr  height="45px">'<span>;
</span><span>echo</span> '<td>'.<span>$row</span>['id'].'</td>'.'<td>'.<span>$row</span>['name'].'</td>'.'<td>'.<span>$row</span>['image'].'</td>'<span>;
</span><span>echo</span> '</tr>'<span>;
}
</span><span>echo</span> '</table>'<span>;
</span><span>mysql_close</span>(<span>$conn</span><span>);
}

/ / http://www.pprar.com 
</span>?>
<?<span>php
</span><span>if</span>(!<span>empty</span>(<span>$_POST</span>['serve'<span>])){

</span><span>$conn</span>=<span>mysql_connect</span>("localhost","root","root"<span>);
</span><span>if</span>(!<span>$conn</span><span>){
</span><span>die</span>('Could not connect the database!'<span>);
}
</span><span>mysql_query</span>("SET NAMES UTF8"<span>);
</span><span>mysql_query</span>("set character_set_client=utf8"<span>); 
</span><span>mysql_query</span>("set character_set_results=utf8"<span>);
</span><span>mysql_select_db</span>("test",<span>$conn</span><span>);
</span><span>$sql</span>="select * from ts1 where name like '%智慧客服%' "<span>;
</span><span>$result</span>=<span>mysql_query</span>(<span>$sql</span><span>);
</span><span>echo</span> '<table height="60%"  width="60%" border="1"  align="center">'<span>;
</span><span>while</span>(<span>$row</span>=<span>mysql_fetch_assoc</span>(<span>$result</span><span>)){
</span><span>echo</span> '<tr  height="45px">'<span>;
</span><span>echo</span> '<td>'.<span>$row</span>['id'].'</td>'.'<td>'.<span>$row</span>['name'].'</td>'.'<td>'.<span>$row</span>['image'].'</td>'<span>;
</span><span>echo</span> '</tr>'<span>;
}
</span><span>echo</span> '</table>'<span>;
</span><span>mysql_close</span>(<span>$conn</span><span>);
}

</span>?>


<?<span>php
</span><span>if</span>(!<span>empty</span>(<span>$_POST</span>['manager'<span>])){

</span><span>$conn</span>=<span>mysql_connect</span>("localhost","root","root"<span>);
</span><span>if</span>(!<span>$conn</span><span>){
</span><span>die</span>('Could not connect the database!'<span>);
}
</span><span>mysql_query</span>("SET NAMES UTF8"<span>);
</span><span>mysql_query</span>("set character_set_client=utf8"<span>); 
</span><span>mysql_query</span>("set character_set_results=utf8"<span>);
</span><span>mysql_select_db</span>("test",<span>$conn</span><span>);
</span><span>$sql</span>="select * from ts1 where name like '%经营管理%' "<span>;
</span><span>$result</span>=<span>mysql_query</span>(<span>$sql</span><span>);
</span><span>echo</span> '<table height="60%"  width="60%" border="1"  align="center">'<span>;
</span><span>while</span>(<span>$row</span>=<span>mysql_fetch_assoc</span>(<span>$result</span><span>)){
</span><span>echo</span> '<tr  height="45px">'<span>;
</span><span>echo</span> '<td>'.<span>$row</span>['id'].'</td>'.'<td>'.<span>$row</span>['name'].'</td>'.'<td>'.<span>$row</span>['image'].'</td>'<span>;
</span><span>echo</span> '</tr>'<span>;
}
</span><span>echo</span> '</table>'<span>;
</span><span>mysql_close</span>(<span>$conn</span><span>);
}

</span>?>




<?<span>php
</span><span>if</span>(!<span>empty</span>(<span>$_POST</span>['newemployee'<span>])){

</span><span>$conn</span>=<span>mysql_connect</span>("localhost","root","root"<span>);
</span><span>if</span>(!<span>$conn</span><span>){
</span><span>die</span>('Could not connect the database!'<span>);
}
</span><span>mysql_query</span>("SET NAMES UTF8"<span>);
</span><span>mysql_query</span>("set character_set_client=utf8"<span>); 
</span><span>mysql_query</span>("set character_set_results=utf8"<span>);
</span><span>mysql_select_db</span>("test",<span>$conn</span><span>);
</span><span>$sql</span>="select * from ts1 where name like '%智慧新员工%'"<span>;
</span><span>$result</span>=<span>mysql_query</span>(<span>$sql</span><span>);
</span><span>echo</span> '<table height="60%"  width="60%" border="1"  align="center">'<span>;
</span><span>while</span>(<span>$row</span>=<span>mysql_fetch_assoc</span>(<span>$result</span><span>)){
</span><span>echo</span> '<tr  height="45px">'<span>;
</span><span>echo</span> '<td>'.<span>$row</span>['id'].'</td>'.'<td>'.<span>$row</span>['name'].'</td>'.'<td>'.<span>$row</span>['image'].'</td>'<span>;
</span><span>echo</span> '</tr>'<span>;
}
</span><span>echo</span> '</table>'<span>;
</span><span>mysql_close</span>(<span>$conn</span><span>);
}

</span>?>



<?<span>php
</span><span>if</span>(!<span>empty</span>(<span>$_POST</span>['development'<span>])){

</span><span>$conn</span>=<span>mysql_connect</span>("localhost","root","root"<span>);
</span><span>if</span>(!<span>$conn</span><span>){
</span><span>die</span>('Could not connect the database!'<span>);
}
</span><span>mysql_query</span>("SET NAMES UTF8"<span>);
</span><span>mysql_query</span>("set character_set_client=utf8"<span>); 
</span><span>mysql_query</span>("set character_set_results=utf8"<span>);
</span><span>mysql_select_db</span>("test",<span>$conn</span><span>);
</span><span>$sql</span>="select * from ts1 where name like '%个人发展%' "<span>;
</span><span>$result</span>=<span>mysql_query</span>(<span>$sql</span><span>);
</span><span>echo</span> '<table  height="60%"  width="60%" border="1"  align="center">'<span>;
</span><span>while</span>(<span>$row</span>=<span>mysql_fetch_assoc</span>(<span>$result</span><span>)){
</span><span>echo</span> '<tr  height="45px">'<span>;
</span><span>echo</span> '<td>'.<span>$row</span>['id'].'</td>'.'<td>'.<span>$row</span>['name'].'</td>'.'<td>'.<span>$row</span>['image'].'</td>'<span>;
</span><span>echo</span> '</tr>'<span>;
}
</span><span>echo</span> '</table>'<span>;
</span><span>mysql_close</span>(<span>$conn</span><span>);
}

</span>?>
</div>
</body>
</html>
ログイン後にコピー

 

本人零基础 想学习写一个最简单的php程序 hello world但不知道怎从网上下载与安装并写出来?

先学PHP基础,再去百度查自己需要的功能的原理,然后去实验,实验成功后在网站上使用它。
走完这四步,你才算学会了这门技术的一个功能。
学不会PHP人绝大部分一直在重复第一步 !

w3school上的教程非常的基础,很容易懂,建议先看完它。然后可以看看php100的视频教程,这个讲得很细很易懂,而且讲知识点非常的多,我也是看这个学会的。
还是那句话,看教程只是在背乘法口诀,只会乘法口诀的学生从来都不会做应用题,只有使用它,那才是真正的学习!
 

本人零基础 想学习写一个最简单的php程序 hello world但不知道怎从网上下载与安装并写出来

最简单的程序就这样:
echo 'Hello, world!';
?>

下载PHP可以在www.php.net下载,选择windows下的二进制代码,可以下载安装包和ZIP包,我喜欢ZIP包,随便解压缩到一个文件夹就可以了,例如c:\php\下。双击上面保存的(我用记事本编辑)PHP文件,选择和你刚才解开的c:\php\php.exe关联就可以了。
 

関連ラベル:
php
ソース:php.cn
このウェブサイトの声明
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。
最新の問題
人気のおすすめ
人気のチュートリアル
詳細>
最新のダウンロード
詳細>
ウェブエフェクト
公式サイト
サイト素材
フロントエンドテンプレート