最基础的PHP分类查询程序,php分类查询程序
最初级的PHP分类查询程序 <!DOCTYPE html PUBLIC "-//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 $_SERVER['PHP_SELF'];?>" method="post"><input type="submit" name="sell" value="智慧销售" /> <input type="submit" name="manager" value="经营管理"/> <input type="submit" name="serve" value="智慧客服" /> <input type="submit" name="newemployee" value="智慧新员工" /> <input type="submit" name="development" value="个人发展" /></form> <?php if(!empty($_POST['sell'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%智慧销售%' "; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } / / http://www.pprar.com ?> <?php if(!empty($_POST['serve'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%智慧客服%' "; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } ?> <?php if(!empty($_POST['manager'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%经营管理%' "; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } ?> <?php if(!empty($_POST['newemployee'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%智慧新员工%'"; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } ?> <?php if(!empty($_POST['development'])){ $conn=mysql_connect("localhost","root","root"); if(!$conn){ die('Could not connect the database!'); } mysql_query("SET NAMES UTF8"); mysql_query("set character_set_client=utf8"); mysql_query("set character_set_results=utf8"); mysql_select_db("test",$conn); $sql="select * from ts1 where name like '%个人发展%' "; $result=mysql_query($sql); echo '<table height="60%" width="60%" border="1" align="center">'; while($row=mysql_fetch_assoc($result)){ echo '<tr height="45px">'; echo '<td>'.$row['id'].'</td>'.'<td>'.$row['name'].'</td>'.'<td>'.$row['image'].'</td>'; echo '</tr>'; } echo '</table>'; mysql_close($conn); } ?> </div> </body> </html>
先学PHP基础,再去百度查自己需要的功能的原理,然后去实验,实验成功后在网站上使用它。
走完这四步,你才算学会了这门技术的一个功能。
学不会PHP人绝大部分一直在重复第一步 !
w3school上的教程非常的基础,很容易懂,建议先看完它。然后可以看看php100的视频教程,这个讲得很细很易懂,而且讲知识点非常的多,我也是看这个学会的。
还是那句话,看教程只是在背乘法口诀,只会乘法口诀的学生从来都不会做应用题,只有使用它,那才是真正的学习!
最简单的程序就这样:
<?php
echo 'Hello, world!';
?>
下载PHP可以在www.php.net下载,选择windows下的二进制代码,可以下载安装包和ZIP包,我喜欢ZIP包,随便解压缩到一个文件夹就可以了,例如c:\php\下。双击上面保存的(我用记事本编辑)PHP文件,选择和你刚才解开的c:\php\php.exe关联就可以了。
PHP之友评论