Home >php教程 >php手册 >最基础的PHP分类查询程序，php分类查询程序

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

WBOYOriginal: 2016-06-13 09:24:241023browse

最基础的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关联就可以了。

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：PHP图像操作：3D图、缩放、旋转、裁剪、添加水印（三）Next article：前端工程师应该具备的三种思维

See more

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