{"id":6207,"date":"2021-02-10T01:40:29","date_gmt":"2021-02-10T01:40:29","guid":{"rendered":"https:\/\/www.studygate.com\/blog-cn\/?p=6207"},"modified":"2021-02-10T01:40:29","modified_gmt":"2021-02-10T01:40:29","slug":"php-commands","status":"publish","type":"post","link":"https:\/\/www.studygate.com\/blog-cn\/php-commands\/","title":{"rendered":"\u5e38\u7528PHP\u4ee3\u7801\uff1a\u8d85\u5b9e\u7528\u7684PHP\u5e38\u7528\u4ee3\u7801\u6c47\u603b\uff0c\u8f7b\u677e\u5e2e\u4f60\u89e3\u51b3PHP\u4f5c\u4e1a\u96be\u9898"},"content":{"rendered":"
<\/p>\n
PHP\u662f\u4e00\u79cd\u901a\u7528\u5f00\u6e90\u811a\u672c\u8bed\u8a00\uff0cPHP \u6587\u4ef6\u53ef\u5305\u542b\u6587\u672c\u3001HTML\u3001JavaScript\u4ee3\u7801\u548c PHP \u4ee3\u7801\uff0c\u5176\u4ee3\u7801\u5728\u670d\u52a1\u5668\u4e0a\u6267\u884c\uff0c\u7ed3\u679c\u4ee5\u7eaf HTML \u5f62\u5f0f\u8fd4\u56de\u7ed9\u6d4f\u89c8\u5668\u3002PHP\u53ef\u4ee5\u751f\u6210\u52a8\u6001\u9875\u9762\u5185\u5bb9\uff0c\u4e5f\u53ef\u4ee5\u521b\u5efa\u3001\u6253\u5f00\u3001\u8bfb\u53d6\u3001\u5199\u5165\u3001\u5173\u95ed\u670d\u52a1\u5668\u4e0a\u7684\u6587\u4ef6\u3002\u540c\u65f6PHP \u53ef\u4ee5\u6536\u96c6\u8868\u5355\u6570\u636e\uff0c\u53d1\u9001\u548c\u63a5\u6536 cookies\u3002\u4e5f\u53ef\u4ee5\u6dfb\u52a0\u3001\u5220\u9664\u3001\u4fee\u6539\u6570\u636e\u5e93\u4e2d\u7684\u6570\u636e\u3002\u4e3b\u8981\u9002\u7528\u4e8e\u7f51\u7ad9\u5f00\u53d1\u3002<\/p>\n
<?php<\/p>\n
$connec=mysql_connect(“localhost”,”root”,”root”) or die(“\u4e0d\u80fd\u8fde\u63a5\u6570\u636e\u5e93\u670d\u52a1\u5668\uff1a “.mysql_error());<\/p>\n
mysql_select_db(“liuyanben”,$connec) or die (“\u4e0d\u80fd\u9009\u62e9\u6570\u636e\u5e93: “.mysql_error());<\/p>\n
mysql_query(“set names ‘gbk'”);<\/p>\n
?><\/p>\n
<?php<\/p>\n
$sql=”select * from liuyan order by ly_id desc”;<\/p>\n
$conn=mysql_query($sql,$connec);<\/p>\n
while($rs=mysql_fetch_array($conn)){<\/p>\n
?><\/p>\n
\u5faa\u73af\u7684\u5185\u5bb9………<\/p>\n
<?php<\/p>\n
}<\/p>\n
?><\/p>\n
1\uff09\u4e24\u4e2a\u51fd\u6570<\/p>\n
<?<\/p>\n
\/\/\u5206\u9875\u51fd\u6570<\/p>\n
function genpage(&$sql,$page_size=2)<\/p>\n
{<\/p>\n
global $prepage,$nextpage,$pages,$sums; \/\/out param<\/p>\n
$page = $_GET[“page”];<\/p>\n
$eachpage = $page_size;<\/p>\n
$pagesql = strstr($sql,” from “);<\/p>\n
$pagesql = “select count(*) as ids “.$pagesql;<\/p>\n
$conn = mysql_query($pagesql) or die(mysql_error());<\/p>\n
if($rs = mysql_fetch_array($conn)) $sums = $rs[0];<\/p>\n
$pages = ceil(($sums-0.5)\/$eachpage)-1;<\/p>\n
$pages = $pages>=0?$pages:0;<\/p>\n
$prepage = ($page>0)?$page-1:0;<\/p>\n
$nextpage = ($page<$pages)?$page+1:$pages;<\/p>\n
$startpos = $page*$eachpage;<\/p>\n
$sql .=” limit $startpos,$eachpage “;<\/p>\n
}<\/p>\n
\/\/ \u663e\u793a\u5206\u9875<\/p>\n
function showpage()<\/p>\n
{<\/p>\n
global $page,$pages,$prepage,$nextpage,$queryString; \/\/param from genpage function<\/p>\n
$shownum =10\/2;<\/p>\n
$startpage = ($page>=$shownum)?$page-$shownum:0;<\/p>\n
$endpage = ($page+$shownum<=$pages)?$page+$shownum:$pages;<\/p>\n
echo “\u5171”.($pages+1).”\u9875: “;<\/p>\n
if($page>0)echo “<a href=$PHP_SELF?page=0$queryString>\u9996\u9875<\/a>”;<\/p>\n
if($startpage>0)<\/p>\n
echo ” … <b><a href=$PHP_SELF?page=”.($page-$shownum*2).”$queryString>?<\/a><\/b>”;<\/p>\n
for($i=$startpage;$i<=$endpage;$i++)<\/p>\n
{<\/p>\n
if($i==$page) echo ” <b>[“.($i+1).”]<\/b> “;<\/p>\n
else echo ” <a href=$PHP_SELF?page=$i$queryString>”.($i+1).”<\/a> “;<\/p>\n
}<\/p>\n
if($endpage<$pages)<\/p>\n
echo “<b><a href=$PHP_SELF?page=”.($page+$shownum*2).”$queryString>?<\/a><\/b> … “;<\/p>\n
if($page<$pages)<\/p>\n
echo “<a href=$PHP_SELF?page=$pages$queryString>\u5c3e\u9875<\/a>”;<\/p>\n
}<\/p>\n
\/\/\u663e\u793a\u5e26\u5206\u7c7b\u7684\u5206\u9875<\/p>\n
function showpage1()<\/p>\n
{<\/p>\n
$fenlei=$_GET[“fenleiid”];<\/p>\n
global $page,$pages,$prepage,$nextpage,$queryString; \/\/param from genpage function<\/p>\n
$shownum =10\/2;<\/p>\n
$startpage = ($page>=$shownum)?$page-$shownum:0;<\/p>\n
$endpage = ($page+$shownum<=$pages)?$page+$shownum:$pages;<\/p>\n
echo “\u5171”.($pages+1).”\u9875: “;<\/p>\n
if($page>0)echo “<a href=$PHP_SELF?fenleiid=$fenlei&page=0$queryString>\u9996\u9875<\/a>”;<\/p>\n
if($startpage>0)<\/p>\n
echo ” … <b><a href=$PHP_SELF?fenleiid=$fenlei&page=”.($page-$shownum*2).”$queryString>?<\/a><\/b>”;<\/p>\n
for($i=$startpage;$i<=$endpage;$i++)<\/p>\n
{<\/p>\n
if($i==$page) echo ” <b>[“.($i+1).”]<\/b> “;<\/p>\n
else echo ” <a href=$PHP_SELF?fenleiid=$fenlei&page=$i$queryString>”.($i+1).”<\/a> “;<\/p>\n
}<\/p>\n
if($endpage<$pages)<\/p>\n
echo “<b><a href=$PHP_SELF?fenleiid=$fenlei&page=”.($page+$shownum*2).”$queryString>?<\/a><\/b> … “;<\/p>\n
if($page<$pages)<\/p>\n
echo “<a href=$PHP_SELF?fenleiid=$fenlei&page=$pages$queryString>\u5c3e\u9875<\/a& amp; gt;”;<\/p>\n
}<\/p>\n
?><\/p>\n
2\uff09\u4e24\u4e2a\u8c03\u7528<\/p>\n
\u7b2c\u4e00\u4e2a<\/p>\n
<?php<\/p>\n
$sql=”select * from liuyan order by ly_id desc”;<\/p>\n
genpage($sql); \/\/\u53ea\u9700\u8981\u6b63\u5e38\u4ee3\u7801\u52a0\u4e0a\u8fd9\u4e00\u884c\u5c31ok\u3002<\/p>\n
$conn=mysql_query($sql,$connec);<\/p>\n
while($rs=mysql_fetch_array($conn)){<\/p>\n
?><\/p>\n
\u7b2c\u4e8c\u4e2a<\/p>\n
<?php<\/p>\n
}<\/p>\n
?><\/p>\n
<?php<\/p>\n
showpage(); \/\/\u663e\u793a\u9875<\/p>\n
?><\/p>\n
<?php<\/p>\n
mysql_close();<\/p>\n
?><\/p>\n
<\/p>\n
<?php require_once(‘conn.php’); ?><\/p>\n
<?php<\/p>\n
$ly_title=$_POST[“ly_title”];<\/p>\n
$ly_content=$_POST[“ly_content”];<\/p>\n
$ly_time=$_POST[“ly_time”];<\/p>\n
$ly_author=$_POST[“ly_author”];<\/p>\n
$ly_email=$_POST[“ly_email”];<\/p>\n
$sql=”insert into liuyan(ly_title,ly_content,ly_time,ly_author,ly_email) values(‘”.$ly_title.”‘,'”.$ly_content.”‘,'”.$ly_time.”‘,'”.$ly_author.”‘,'”.$ly_email.”‘)”;<\/p>\n
mysql_query($sql,$connec);<\/p>\n
echo(“<script type=’text\/javascript’> alert(‘\u6dfb\u52a0\u6210\u529f\uff01’);location.href=’index.php’;<\/script>”);<\/p>\n
?><\/p>\n
<?php<\/p>\n
echo(“<script type=’text\/javascript’> alert(‘\u6dfb\u52a0\u6210\u529f\uff01’);location.href=’index.php’;<\/script>”);<\/p>\n
?><\/p>\n
1)\u6709\u6761\u4ef6\u8bfb\u53d6\u6570\u636e\u5e93<\/p>\n
<?php<\/p>\n
$sql=”select * from liuyan where ly_id=$_GET[id]”;<\/p>\n
$conn=mysql_query($sql,$connec);<\/p>\n
$rs=mysql_fetch_array($conn);<\/p>\n
?><\/p>\n
2\uff09 \u5c06\u67d0\u4e2a\u5b57\u6bb5\u8f93\u51fa<\/p>\n
<?=$rs[ly_title]?><\/p>\n
3\uff09\u5173\u95ed\u6570\u636e\u5e93<\/p>\n
<?php<\/p>\n
mysql_close();<\/p>\n
?><\/p>\n
<?php<\/p>\n
$ly_title=$_POST[“ly_title”];<\/p>\n
$ly_content=$_POST[“ly_content”];<\/p>\n
$ly_time=$_POST[“ly_time”];<\/p>\n
$ly_author=$_POST[“ly_author”];<\/p>\n
$ly_email=$_POST[“ly_email”];<\/p>\n
$sql=”update liuyan set ly_title=’$ly_title’,ly_content=’$ly_content’,ly_time=’$ly_time’,ly_author=’$ly_author’,ly_email=’$ly_email’ where ly_id=$_GET[id]”;<\/p>\n
mysql_query($sql,$connec);<\/p>\n
echo(“<script type=’text\/javascript’> alert(‘\u66f4\u65b0\u6210\u529f\uff01’);location.href=’..\/index.php’;<\/script>”);<\/p>\n
?><\/p>\n
<?php<\/p>\n
$sql=”delete from liuyan where ly_id=$_GET[id]”;<\/p>\n
mysql_query($sql,$connec);<\/p>\n
echo(“<script type=’text\/javascript’> alert(‘\u5220\u9664\u6210\u529f\uff01’);location.href=’..\/index.php’;<\/script>”);<\/p>\n
?><\/p>\n
<?php<\/p>\n
session_start();<\/p>\n
$username=$_POST[“username”];<\/p>\n
$password=$_POST[“password”];<\/p>\n
$sql=”select * from admin where username='”.$username.”‘ && password='”.$password.”‘”;<\/p>\n
$result=mysql_query($sql,$connec);<\/p>\n
if($row=mysql_fetch_array($result)){<\/p>\n
session_register(“admin”);<\/p>\n
$admin=$username;<\/p>\n
echo(“<script type=’text\/javascript’> alert(‘\u767b\u5f55\u6210\u529f\uff01’);location.href=’admin.php’;<\/script>”);}<\/p>\n
else<\/p>\n
{<\/p>\n
echo(“<script type=’text\/javascript’> alert(‘\u4f60\u8f93\u5165\u7684\u7528\u6237\u540d\u6216\u5bc6\u7801\u9519\u8bef\uff0c\u8bf7\u91cd\u65b0\u8f93\u5165\uff01’);location.href=’login.php’;<\/script& gt;”);<\/p>\n
}<\/p>\n
mysql_close();<\/p>\n
?><\/p>\n
\u603b\u7684\u6765\u8bf4\uff0cPHP\u7684\u5b66\u4e60\u4e0e\u5176\u4ed6\u8bed\u8a00\u662f\u76f8\u8f85\u76f8\u6210\u7684\uff0c\u4e5f\u53ef\u4ee5\u878d\u4f1a\u8d2f\u901a\u3002\u90a3\u4e48\u5982\u679c\u4f60\u5bf9PHP\u6216\u8005\u5176\u4ed6\u76f8\u5173\u7f16\u7a0b\u8bed\u8a00\u6709\u4efb\u4f55\u95ee\u9898\uff0c\u53ef\u4ee5\u76f4\u63a5\u9009\u62e9StudyGate\u5728\u7ebf\u8f85\u5bfc\u670d\u52a1\uff01\u5168\u5929\u5019\u5927\u795e\u5728\u7ebf\uff0c80\u5206\u4ee5\u4e0b\u5168\u989d\u9000\u6b3e\uff01\u51e0\u4e2a\u6b65\u9aa4\uff0c\u4f60\u4e5f\u53ef\u4ee5\u6210\u4e3aPHP\u5927\u795e\uff01<\/p>\n
<\/p>\n
Step 1\uff1a\u63d0\u4ea4\u4f5c\u4e1a\u8981\u6c42<\/p>\n
\u4e09\u5206\u949f\u5373\u53ef\u5b8c\u6210\u4e0b\u5355\uff0c\u4e0b\u5355\u65f6\u53ef\u4ee5\u9009\u62e9\u4f5c\u4e1a\u9700\u8981\u7684\u65f6\u95f4\u548c\u5177\u4f53\u8981\u6c42\u3002<\/p>\n
Step 2\uff1a\u9009\u62e9\u4e13\u4e1a\u5bfc\u5e08<\/p>\n
\u4f5c\u4e1a\u63d0\u4ea4\u6210\u529f\u4e4b\u540e\uff0c\u5bfc\u5e08\u5ba1\u6838\u8981\u6c42\uff0c\u786e\u8ba4\u4e4b\u540e\u4f1a\u8054\u7cfb\u62a5\u4ef7\uff0c\u53ef\u81ea\u7531\u9009\u62e9\u4e13\u4e1a\u5b66\u79d1\u76f8\u5173\u5bfc\u5e08\uff0c\u5e76\u4e14\u786e\u8ba4\u4f5c\u4e1a\u6700\u7ec8\u4ef7\u683c\u3002<\/p>\n
Step 3\uff1a\u5b8c\u6210\u8ba2\u5355, \u51c6\u65f6\u4ea4\u4ed8<\/p>\n
\u5bfc\u5e08\u5f00\u59cb\u5904\u7406\u8ba2\u5355\u3002\u5728\u6b64\u671f\u95f4\u6709\u4efb\u4f55\u95ee\u9898\uff0c\u90fd\u53ef\u4ee5\u767b\u5f55\u8d26\u53f7\u548c\u5bfc\u5e08\u968f\u65f6\u6c9f\u901a\u3002\u4f5c\u4e1a\u5b8c\u6210\u540e\uff0c\u7cfb\u7edf\u81ea\u52a8\u53d1\u9001\u81f3\u4f60\u7684\u90ae\u7bb1\uff0c\u6240\u6709\u4fe1\u606f\u5b89\u5168\u4fdd\u5bc6\u3002\u4f60\u4e5f\u53ef\u4ee5\u767b\u5f55\u8d26\u53f7\u76f4\u63a5\u4e0b\u8f7d\u3002<\/p>\n
Step 4\uff1a\u6536\u5230\u7b54\u684814\u5929\u4e4b\u5185\u786e\u8ba4\uff0c100%\u6ee1\u610f\u4fdd\u8bc1<\/p>\n
\u6536\u5230\u4f5c\u4e1a\u4e4b\u540e14\u5929\u4e4b\u5185\uff0c\u5982\u679c\u5bf9\u4f5c\u4e1a\u6709\u4efb\u4f55\u95ee\u9898\uff0c\u90fd\u53ef\u4ee5\u8054\u7cfb\u5bfc\u5e08\u8fdb\u884c\u4fee\u6539\u3002100%\u6ee1\u610f\u4fdd\u8bc1\uff0c\u53ea\u6709\u4f60\u9009\u62e9\u6ee1\u610f\u7b54\u6848\u4e4b\u540e\uff0c\u6211\u4eec\u624d\u4f1a\u6263\u6b3e\uff0c\u5b89\u5168\u6709\u4fdd\u969c\u3002<\/p>\n
Step 5\uff1a\u5bf9\u5bfc\u5e08\u63d0\u51fa\u8bc4\u4ef7<\/p>\n
\u6211\u4eec\u62e5\u6709\u4e25\u683c\u7684\u5bfc\u5e08\u8003\u6838\u8bc4\u4ef7\u673a\u5236\uff0c\u670d\u52a1\u597d\u4e0d\u597d\uff0c\u5168\u7531\u4f60\u8bf4\u4e86\u7b97\uff01\u4f60\u7684\u8ba4\u540c\u662f\u6211\u4eec\u524d\u8fdb\u7684\u52a8\u529b\u3002<\/p>\n
\u6211\u4eec\u7684\u670d\u52a1\u8303\u56f4\u5305\u62ec\u4f46\u4e0d\u9650\u4e8e\uff1a
\nC\uff0cC#\uff0cC++ <\/a>
\nComputer Science <\/a>
\nData structure\/Machine Learning <\/a>
\nDreamweaver
\nHTML \u4ee3\u5199
\nJava\/JavaScript\/JQuery
\nLinux\/Windows\/Mac socket Algorithm
\nMacintosh
\nMathematica (programming)
\nR\u8bed\u8a00<\/a>
\nNetworking (computer) <\/a>
\nOracle
\nPascal\/Perl\/PHP\/Python
\nRevit\/Rust\/Ruby
\nSAS<\/a>\/Sketchup\/Solidworks\/SQL<\/a>\/STATA\/Swift\/SPSS<\/a>
\nUNIX
\nVisual Basic
\nWeb Design\/Operating System<\/p>\n