search

Home >Backend Development >PHP Tutorial >The most basic PHP classification query program, php classification query program_PHP tutorial

The most basic PHP classification query program, php classification query program_PHP tutorial

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-07-13 10:17:441137browse

The most basic PHP classification query program, php classification query program

<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>

I have zero basic knowledge and want to learn to write the simplest php program hello world but I don’t know how to download and install it from the Internet and write it?

First learn the basics of PHP, then go to Baidu to check the principles of the functions you need, and then experiment. After the experiment is successful, use it on the website.
After completing these four steps, you will have learned a function of this technology.
Most people who can’t learn PHP keep repeating the first step!

The tutorials on w3school are very basic and easy to understand. It is recommended to read it first. Then you can watch the video tutorial of php100. This video tutorial is very detailed and easy to understand, and it contains a lot of knowledge points. I also learned it by watching this.
Again, watching tutorials is just memorizing multiplication tables. Students who only know multiplication tables will never do word problems. Only by using it can real learning be achieved!

I have zero foundation and want to learn to write the simplest php program hello world but I don’t know how to download and install it from the Internet and write it

The simplest program is this:
echo 'Hello, world!';
?>

Download PHP can be downloaded at www.php.net , select the binary code under windows, you can download the installation package and ZIP package. I like ZIP package, just unzip it to a folder, such as c:\php\. Double-click the PHP file saved above (I edited it with Notepad) and select the link to c:\php\php.exe you just unlocked.

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/888533.htmlTechArticleThe most basic PHP classification query program, the most basic PHP classification query program! DOCTYPE html PUBLIC " -//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtm...
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：Three kinds of thinking that front-end engineers should have_PHP tutorialNext article：Three kinds of thinking that front-end engineers should have_PHP tutorial

Related articles

See more