最基础的PHP分类查询程序,php分类查询程序
最基础的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基础,再去百度查自己需要的功能的原理,然后去实验,实验成功后在网站上使用它。
走完这四步,你才算学会了这门技术的一个功能。
学不会PHP人绝大部分一直在重复第一步 !
w3school上的教程非常的基础,很容易懂,建议先看完它。然后可以看看php100的视频教程,这个讲得很细很易懂,而且讲知识点非常的多,我也是看这个学会的。
还是那句话,看教程只是在背乘法口诀,只会乘法口诀的学生从来都不会做应用题,只有使用它,那才是真正的学习!
最简单的程序就这样:
echo 'Hello, world!';
?>
下载PHP可以在www.php.net下载,选择windows下的二进制代码,可以下载安装包和ZIP包,我喜欢ZIP包,随便解压缩到一个文件夹就可以了,例如c:\php\下。双击上面保存的(我用记事本编辑)PHP文件,选择和你刚才解开的c:\php\php.exe关联就可以了。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



In this chapter, we will understand the Environment Variables, General Configuration, Database Configuration and Email Configuration in CakePHP.

PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati

To work with date and time in cakephp4, we are going to make use of the available FrozenTime class.

To work on file upload we are going to use the form helper. Here, is an example for file upload.

In this chapter, we are going to learn the following topics related to routing ?

CakePHP is an open-source framework for PHP. It is intended to make developing, deploying and maintaining applications much easier. CakePHP is based on a MVC-like architecture that is both powerful and easy to grasp. Models, Views, and Controllers gu

Working with database in CakePHP is very easy. We will understand the CRUD (Create, Read, Update, Delete) operations in this chapter.

Validator can be created by adding the following two lines in the controller.
