Maison >développement back-end >tutoriel 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关联就可以了。