俄罗斯兽交黑人又大又粗水汪汪,成人+在线播放

<option id="a2ecc"><table id="a2ecc"></table></option>

<td id="a2ecc"><center id="a2ecc"></center></td>

<small id="a2ecc"></small>

<nav id="a2ecc"><dd id="a2ecc"></dd></nav>

\n

注冊(cè)頁面<\/h3>\n
\n \n \n \n \n \n \n
用戶名<\/td>\n 以小寫字母開始，長度要求5~10<\/td>\n <\/tr>\n
密碼<\/td>\n 密碼不能為空<\/td>\n <\/tr>\n
郵箱<\/td>\n <\/td>\n <\/tr>\n
性別<\/td>\n \n 男\(zhòng)n 女\n 保密\n <\/td>\n <\/tr>\n
個(gè)人簡介<\/td>\n \n <\/textarea>\n <\/td>\n <\/tr>\n <tr>\n <td colspan='2'><input type=\"submit\" name='act' value='注冊(cè)' \/><\/td>\n <\/tr>\n <\/table>\n <\/form>\n\n<\/body>\n<\/html>\n\n<\/pre>\n\n<p style=\"text-align: center\"><img id=\"theimg\" alt=\"\" onclick=\"window.open(this.src)\" src=\"http:\/\/www.bkjia.com\/uploads\/allimg\/160329\/00594U4Q-0.jpg?2016227162735\" \/><\/p>\n<p style=\"text-align: left\">3. Display registration data in the database <br \/>\n<\/p>\n\n<pre class='brush:php;toolbar:false;'>\n\/\/往數(shù)據(jù)庫中添加數(shù)據(jù)\n\n<?php\nheader(\"Content-type:text\/html; charset=utf-8\");\n\/\/-----------------------連接數(shù)據(jù)庫---------------------------\ninclude_once \"connect.php\";\n\/\/-------------------------將數(shù)據(jù)連接到數(shù)據(jù)庫------------------\n$time=time();\n$sql=\"insert into user (username,password,email,sex,txt,`time`) value('{$_POST['username']}','{$_POST['password']}','{$_POST['email']}','{$_POST['sex']}','{$_POST['txt']}','{$time}')\";\n$res=mysql_query($sql);\nheader(\"location:hello.php\");\n?>\n\n<\/pre>\n\n<p style=\"text-align: center\"><img id=\"theimg\" alt=\"\" onclick=\"window.open(this.src)\" src=\"http:\/\/www.bkjia.com\/uploads\/allimg\/160329\/00594W301-1.jpg?2016227162810\" \/><\/p>\n<p>4. Return to the background interface<\/p>\n\n<pre class='brush:php;toolbar:false;'>\n<?php\nheader(\"Content-type:text\/html; charset=utf-8\");\n\/\/-----------------------連接數(shù)據(jù)庫------------------------------\ninclude_once \"connect.php\";\n\/\/--------------------查詢數(shù)據(jù)庫--------------------------------\n$query=\"select * from user\";\n$result=mysql_query($query);\nif(!$result)\n{\n die(\"could not to the database<br\/>\".mysql_error());\n}\n\/\/-------------------封裝函數(shù)-----------------------------\n\/\/該函數(shù)將數(shù)據(jù)庫的數(shù)據(jù)寫成數(shù)組形式\nfunction result2Arr($result){\n while($result_row=mysql_fetch_assoc($result)){\n $arr[] = $result_row;\n }\n return $arr;\n}\n$arr = result2Arr($result);\nforeach($arr as $key=>$value){\n echo \"<table border='1px'>\";\n echo \"<table border='1px' >\";\n echo \"<tr> \";\n echo \"<td width='100px'>\".$value['id'].\"<\/td>\";\n echo \"<td width='100px'>\".$value['username'].\"<\/td>\";\n echo \"<td width='100px'>\".$value['password'].\"<\/td>\";\n echo \"<td width='200px'>\".$value['email'].\"<\/td>\";\n echo \"<td width='100px'>\".$value['sex'].\"<\/td>\";\n echo \"<td width='100px'>\".$value['txt'].\"<\/td>\";\n echo \"<td width='100px'>\".date('Y-m-d H:i:s',$value['time']).\"<\/td>\";\n echo \"<td width='100px'><a href='update1.php?id=$value[id]'>修改<\/a> <a href='delete.php?id=$value[id]'>刪除<\/a><\/td>\";\n echo \"<tr\/>\";\n echo \"<\/table>\";\n}\n?>\n\n<\/pre>\n\n<p style=\"text-align: center\"><img id=\"theimg\" onclick=\"window.open(this.src)\" src=\"http:\/\/www.bkjia.com\/uploads\/allimg\/160329\/00594T620-2.jpg?2016227162938\" alt=\"\" \/><\/p>\n<p>5. Modify data <br \/>\n<\/p>\n\n<pre class='brush:php;toolbar:false;'>\n\/\/當(dāng)用戶要修改信息時(shí)，返回頁面，頁面中包含之前填寫的信息\n\n<!DOCTYPE html PUBLIC \"-\/\/W3C\/\/DTD XHTML 1.0 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/xhtml1\/DTD\/xhtml1-transitional.dtd\">\n<html xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\" xml:lang=\"en\">\n<head>\n <meta http-equiv=\"Content-Type\" content=\"text\/html;charset=UTF-8\" \/>\n <title>Document<\/title>\n<\/head>\n<body> <h1><a href="http://www.miracleart.cn/">国产av日韩一区二区三区精品,成人性爱视频在线观看,国产,欧美,日韩,一区,www.成色av久久成人,2222eeee成人天堂</a></h1>\n<div>\n\n<?php\n include_once \"connect.php\";\n $sql=\"select * from user where id='\".$_GET['id'].\"'\";\n \/\/echo \"sql:\".$sql;(顯示出修改哪一行)\n $result=mysql_query($sql,$link);\n $arr = result2Arr($result);\n \/\/print_r($arr);\n $row = $arr[0];\n\nfunction result2Arr($result){\n while($result_row=mysql_fetch_assoc($result)){\n $arr[] = $result_row;\n }\n return $arr;\n}\n?>\n <h3>注冊(cè)頁面<\/h3>\n <form action=\"update.php\" method='post'>\n <input type=\"hidden\" name=\"id\" id=\"\" value=\"<?php echo $row['id']?>\"\/>\n <table border='1' cellpadding='0' cellspacing='0' width='80%' bgcolor='#ABCDEF'>\n <tr>\n <td align='right'>用戶名<\/td>\n <td><input type=\"text\" name=\"username\" id=\"\" value=\"<?php echo $row['username']?>\"\/>以小寫字母開始，長度要求5~10<\/td>\n <\/tr>\n <tr>\n <td align='right'>密碼<\/td>\n <td><input type=\"password\" name=\"password\" id=\"\"value=\"<?php echo $row['password']?>\"\/>密碼不能為空<\/td>\n <\/tr>\n <tr>\n <td align='right'>郵箱<\/td>\n <td><input type=\"text\" name=\"email\" id=\"\" value=\"<?php echo $row['email']?>\"\/><\/td>\n <\/tr>\n <tr>\n <td align='right'>性別<\/td>\n <td>\n <input type=\"radio\" name=\"sex\" id=\"\" value='1' <?php if($row['sex']=='1'){ echo 'checked';}?>\/>男\(zhòng)n <input type=\"radio\" name=\"sex\" id=\"\" value='2' <?php if($row['sex']=='2'){ echo 'checked';}?>\/>女\n <input type=\"radio\" name=\"sex\" id=\"\" value='3' <?php if($row['sex']=='3'){ echo 'checked';}?>\/>保密\n <\/td>\n <\/tr>\n <tr>\n <td align='right'>個(gè)人簡介<\/td>\n <td>\n <textarea name=\"txt\" id=\"\" cols=\"50\" rows=\"10\"><?php echo $row['txt']?><\/textarea>\n <\/td>\n <\/tr>\n <tr>\n <td colspan='2'><input type=\"submit\" name='act' value='修改' \/><\/td>\n <\/tr>\n <\/table>\n <\/form>\n<\/div>\n<\/body>\n<\/html>\n\n<\/pre>\n\n<p style=\"text-align: center\"><img id=\"theimg\" onclick=\"window.open(this.src)\" src=\"http:\/\/www.bkjia.com\/uploads\/allimg\/160329\/00594WB3-3.jpg?2016227163010\" alt=\"\" \/><\/p>\n\n<pre class='brush:php;toolbar:false;'>\n\/\/將修改的信息存入數(shù)據(jù)庫\n\n<?php\nheader(\"Content-type:text\/html; charset=utf-8\");\n\/\/通過post獲取頁面提交數(shù)據(jù)信息\n$data = $_POST;\n\/\/print_r($data);\ninclude_once \"connect.php\";\n$sql = \"update `user` set username='{$data['username']}',password='{$data['password']}', email='{$data['email']}',sex='{$data['sex']}',txt='{$data['txt']}' where id='{$data['id']}'\";\necho $sql;\n$res = mysql_query($sql,$link);\nif($res){\n header(\"Location:hello.php\");\n \/\/echo \"alert('修改成功')\";\n}else{\n header(\"Location:update1.php?id=\".$data['id']);\n \/\/echo \"alert('修改失敗')\";\n}\n?>\n\n<\/pre>\n\n<p style=\"text-align: center\"><img id=\"theimg\" onclick=\"window.open(this.src)\" src=\"http:\/\/www.bkjia.com\/uploads\/allimg\/160329\/00594S544-4.jpg?2016227163031\" alt=\"\" \/><\/p>\n<p>6. Delete data <br \/>\n<\/p>\n\n<pre class='brush:php;toolbar:false;'>\n\/\/刪除數(shù)據(jù)庫里的數(shù)據(jù)\n\n<?php\nheader(\"Content-type:text\/html; charset=utf-8\");\ninclude_once 'connect.php';\n$sql = \"delete from user where id='\".$_GET['id'].\"'\";\n$sus=mysql_query($sql,$link);\nif($sus){\n header(\"location:hello.php\");\n}else{\n echo \"alert('刪除失敗')\";\n}\n?>\n\/\/若要?jiǎng)h除李四，點(diǎn)擊刪除后，會(huì)自動(dòng)跳轉(zhuǎn)到后臺(tái)頁面，數(shù)據(jù)庫里數(shù)據(jù)也刪除\n<\/pre>\n\n<p style=\"text-align: center\"><img id=\"theimg\" onclick=\"window.open(this.src)\" src=\"http:\/\/www.bkjia.com\/uploads\/allimg\/160329\/00594V4L-5.jpg?2016227163113\" alt=\"\"><\/p>\n<p>The above is the entire content of this article, I hope it will be helpful to everyone’s study. <\/p>\n\n\n\n\n<h4>Articles you may be interested in: <\/h4>\n<ul>\n<li>PHP code to verify the existence of the username before registering on the page<\/li>\n<li>Using Php to write example code for email activation verification after registration<\/li>\n<li>Specific example of using js for form verification on the PHP user registration page<\/li>\n<li>ThinkPHP complete example of user registration login message<\/li>\n<li>PHP Ajax detection of whether the user name or email already exists when registering<\/li> ??><li>Detailed explanation of the development of PHP jQuery registration module<\/li>\n<li>Improvements of PHP jQuery registration module (1): Verification code is stored in SESSION<\/li>\n<li>Improvements of PHP jQuery registration module (2): Email activation <\/li>\n<li>php mysql method to implement user registration and login<\/li>\n<li>php sends SMS verification code to complete the registration function<\/li>\n<\/ul>\n<p align=\"left\"><\/p>\n<div style=\"display:none;\">\n<span id=\"url\" itemprop=\"url\">http:\/\/www.bkjia.com\/PHPjc\/1114240.html<\/span><span id=\"indexUrl\" itemprop=\"indexUrl\">www.bkjia.com<\/span><span id=\"isOriginal\" itemprop=\"isOriginal\">true<\/span><span id=\"isBasedOnUrl\" itemprop=\"isBasedOnUrl\">http: \/\/www.bkjia.com\/PHPjc\/1114240.html<\/span><span id=\"genre\" itemprop=\"genre\">TechArticle<\/span><span id=\"description\" itemprop=\"description\">PHP connects to the database to implement the addition, deletion, modification and check operations of the registration page. The example of php addition and deletion in this article shares with everyone the implementation of PHP connection to the database. The method of adding, deleting, modifying and checking on the registration page is for your reference...<\/span>\n<\/div>\n<div id="377j5v51b" class=\"art_confoot\"><\/div>"} </script> <meta http-equiv="Cache-Control" content="no-transform" /> <meta http-equiv="Cache-Control" content="no-siteapp" /> <script>var V_PATH="/";window.onerror=function(){ return true; };</script> </head> <body data-commit-time="2023-12-28T14:50:12+08:00" class="editor_body body2_2"> <link rel="stylesheet" type="text/css" href="/static/csshw/stylehw.css"> <header> <div id="377j5v51b" class="head"> <div id="377j5v51b" class="haed_left"> <div id="377j5v51b" class="haed_logo"> <a href="http://www.miracleart.cn/" title="" class="haed_logo_a"> <img src="/static/imghw/logo.png" alt="" class="haed_logoimg"> </a> </div> <div id="377j5v51b" class="head_nav"> <div id="377j5v51b" class="head_navs"> <a href="javascript:;" title="Community" class="head_nava head_nava-template1">Community</a> <div class="377j5v51b" id="dropdown-template1" style="display: none;"> <div id="377j5v51b" class="languagechoose"> <a href="http://www.miracleart.cn/article.html" title="Articles" class="languagechoosea on">Articles</a> <a href="http://www.miracleart.cn/faq/zt" title="Topics" class="languagechoosea">Topics</a> <a href="http://www.miracleart.cn/wenda.html" title="Q&A" class="languagechoosea">Q&A</a> </div> </div> </div> <div id="377j5v51b" class="head_navs"> <a href="javascript:;" title="Learn" class="head_nava head_nava-template1_1">Learn</a> <div class="377j5v51b" id="dropdown-template1_1" style="display: none;"> <div id="377j5v51b" class="languagechoose"> <a href="http://www.miracleart.cn/course.html" title="Course" class="languagechoosea on">Course</a> <a href="http://www.miracleart.cn/dic/" title="Programming Dictionary" class="languagechoosea">Programming Dictionary</a> </div> </div> </div> <div id="377j5v51b" class="head_navs"> <a href="javascript:;" title="Tools Library" class="head_nava head_nava-template1_2">Tools Library</a> <div class="377j5v51b" id="dropdown-template1_2" style="display: none;"> <div id="377j5v51b" class="languagechoose"> <a href="http://www.miracleart.cn/toolset/development-tools" title="Development tools" class="languagechoosea on">Development tools</a> <a href="http://www.miracleart.cn/toolset/website-source-code" title="Website Source Code" class="languagechoosea">Website Source Code</a> <a href="http://www.miracleart.cn/toolset/php-libraries" title="PHP Libraries" class="languagechoosea">PHP Libraries</a> <a href="http://www.miracleart.cn/toolset/js-special-effects" title="JS special effects" class="languagechoosea on">JS special effects</a> <a href="http://www.miracleart.cn/toolset/website-materials" title="Website Materials" class="languagechoosea on">Website Materials</a> <a href="http://www.miracleart.cn/toolset/extension-plug-ins" title="Extension plug-ins" class="languagechoosea on">Extension plug-ins</a> </div> </div> </div> <div id="377j5v51b" class="head_navs"> <a href="http://www.miracleart.cn/ai" title="AI Tools" class="head_nava head_nava-template1_3">AI Tools</a> </div> <div id="377j5v51b" class="head_navs"> <a href="javascript:;" title="Leisure" class="head_nava head_nava-template1_3">Leisure</a> <div class="377j5v51b" id="dropdown-template1_3" style="display: none;"> <div id="377j5v51b" class="languagechoose"> <a href="http://www.miracleart.cn/game" title="Game Download" class="languagechoosea on">Game Download</a> <a href="http://www.miracleart.cn/mobile-game-tutorial/" title="Game Tutorials" class="languagechoosea">Game Tutorials</a> </div> </div> </div> </div> </div> <div id="377j5v51b" class="head_search"> <input id="key_words" onkeydown="if (event.keyCode == 13) searchs('en')" class="search-input" type="text" autocomplete="off" name="keywords" required="required" placeholder="Block,address,transaction,news" value=""> <a href="javascript:;" title="search" onclick="searchs('en')"><img src="/static/imghw/find.png" alt="search"></a> </div> <div id="377j5v51b" class="head_right"> <div id="377j5v51b" class="haed_language"> <a href="javascript:;" class="layui-btn haed_language_btn">English<i class="layui-icon layui-icon-triangle-d"></i></a> <div class="377j5v51b" id="dropdown-template" style="display: none;"> <div id="377j5v51b" class="languagechoose"> <a href="javascript:setlang('zh-cn');" title="簡體中文" class="languagechoosea">簡體中文</a> <a href="javascript:;" title="English" class="languagechoosea">English</a> <a href="javascript:setlang('zh-tw');" title="繁體中文" class="languagechoosea">繁體中文</a> <a href="javascript:setlang('ja');" title="日本語" class="languagechoosea">日本語</a> <a href="javascript:setlang('ko');" title="???" class="languagechoosea">???</a> <a href="javascript:setlang('ms');" title="Melayu" class="languagechoosea">Melayu</a> <a href="javascript:setlang('fr');" title="Fran?ais" class="languagechoosea">Fran?ais</a> <a href="javascript:setlang('de');" title="Deutsch" class="languagechoosea">Deutsch</a> </div> </div> </div> <span id="377j5v51b" class="head_right_line"></span> <div style="display: block;" id="login" class="haed_login "> <a href="javascript:;" title="Login" class="haed_logina ">Login</a> </div> <div style="display: block;" id="reg" class="head_signup login"> <a href="javascript:;" title="singup" class="head_signupa">singup</a> </div> </div> </div> </header> <main> <div id="377j5v51b" class="Article_Details_main"> <div id="377j5v51b" class="Article_Details_main1"> <div id="377j5v51b" class="Article_Details_main1L"> <div id="377j5v51b" class="Article_Details_main1Lmain" id="Article_Details_main1Lmain"> <div id="377j5v51b" class="Article_Details_main1L1">Table of Contents</div> <div id="377j5v51b" class="Article_Details_main1L2" id="Article_Details_main1L2">  <div id="377j5v51b" class="Article_Details_main1L2s "> <a href="#PHP-connects-to-the-database-to-implement-add-delete-modify-and-check-operations-on-the-registration-page-php-add-and-delete" title="PHP connects to the database to implement add, delete, modify and check operations on the registration page, php add and delete" >PHP connects to the database to implement add, delete, modify and check operations on the registration page, php add and delete</a> </div> <div id="377j5v51b" class="Article_Details_main1L2s "> <a href="#Articles-you-may-be-interested-in" title="Articles you may be interested in: " >Articles you may be interested in: </a> </div> </div> </div> </div> <div id="377j5v51b" class="Article_Details_main1M"> <div id="377j5v51b" class="phpgenera_Details_mainL1"> <a href="http://www.miracleart.cn/" title="Home" class="phpgenera_Details_mainL1a">Home</a> <img src="/static/imghw/top_right.png" alt="" /> <a href="http://www.miracleart.cn/be/" class="phpgenera_Details_mainL1a">Backend Development</a> <img src="/static/imghw/top_right.png" alt="" /> <a href="http://www.miracleart.cn/php-weizijiaocheng.html" class="phpgenera_Details_mainL1a">PHP Tutorial</a> <img src="/static/imghw/top_right.png" alt="" /> <span>PHP connects to the database to implement addition, deletion, modification and query operations on the registration page, php addition and deletion_PHP tutorial</span> </div> <div id="377j5v51b" class="Articlelist_txts"> <div id="377j5v51b" class="Articlelist_txts_info"> <h1 class="Articlelist_txts_title">PHP connects to the database to implement addition, deletion, modification and query operations on the registration page, php addition and deletion_PHP tutorial</h1> <div id="377j5v51b" class="Articlelist_txts_info_head"> <div id="377j5v51b" class="author_info"> <a href="http://www.miracleart.cn/member/887227.html" class="author_avatar"> <img class="lazy" data-src="https://img.php.cn/upload/avatar/000/887/227/63bb7851c9547215.jpg" src="/static/imghw/default1.png" alt="WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB"> </a> <div id="377j5v51b" class="author_detail"> <a href="http://www.miracleart.cn/member/887227.html" class="author_name">WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB</a> </div> </div> </div> <span id="377j5v51b" class="Articlelist_txts_time">Jul 12, 2016 am 08:56 AM</span> <div id="377j5v51b" class="Articlelist_txts_infos"> <span id="377j5v51b" class="Articlelist_txts_infoss on">mysql</span> <span id="377j5v51b" class="Articlelist_txts_infoss ">php</span> <span id="377j5v51b" class="Articlelist_txts_infoss ">database</span> <span id="377j5v51b" class="Articlelist_txts_infoss ">register</span> </div> </div> </div> <hr /> <div id="377j5v51b" class="article_main php-article"> <div id="377j5v51b" class="article-list-left detail-content-wrap content"> <ins class="adsbygoogle" style="display:block; text-align:center;" data-ad-layout="in-article" data-ad-format="fluid" data-ad-client="ca-pub-5902227090019525" data-ad-slot="3461856641"> </ins> <p></p> <h2 id="PHP-connects-to-the-database-to-implement-add-delete-modify-and-check-operations-on-the-registration-page-php-add-and-delete">PHP connects to the database to implement add, delete, modify and check operations on the registration page, php add and delete</h2> <p>This article shares an example of how to connect PHP to the database to implement add, delete, modify and check operations on the registration page. For your reference, the specific content is as follows</p> <p>1. Connect to database</p> <pre class='brush:php;toolbar:false;'> <?php //本地測試 $host = '127.0.0.1'; $port = 3306; $user = "root"; $pwd = ""; $link = @mysql_connect("{$host}:{$port}",$user,$pwd,true); if(!$link) { die("Connect Server Failed: " . mysql_error()); } //選擇連接的數(shù)據(jù)庫庫名 mysql_select_db("my"); //設(shè)置字符編碼utf8 mysql_set_charset('utf8'); ?> </pre> <p>2. Registration page (html page) <br /> </p> <pre class='brush:php;toolbar:false;'> <!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" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" /> <title>Document</title> </head> <body> <h3>注冊(cè)頁面</h3> <form action="add.php" method='post'> <table border='1' cellpadding='0' cellspacing='0' width='80%' bgcolor='#ABCDEF'> <tr> <td align='right'>用戶名</td> <td><input type="text" name="username" id=""/>以小寫字母開始，長度要求5~10</td> </tr> <tr> <td align='right'>密碼</td> <td><input type="password" name="password" id=""/>密碼不能為空</td> </tr> <tr> <td align='right'>郵箱</td> <td><input type="text" name="email" id="" /></td> </tr> <tr> <td align='right'>性別</td> <td> <input type="radio" name="sex" id="" value='1' />男 <input type="radio" name="sex" id="" value='2' />女 <input type="radio" name="sex" id="" value='3' />保密 </td> </tr> <tr> <td align='right'>個(gè)人簡介</td> <td> <textarea name="txt" id="" cols="50" rows="10"></textarea> </td> </tr> <tr> <td colspan='2'><input type="submit" name='act' value='注冊(cè)' /></td> </tr> </table> </form> </body> </html> </pre> <p style="text-align: center"><img src="/static/imghw/default1.png" data-src="http://www.bkjia.com/uploads/allimg/160329/00594U4Q-0.jpg?2016227162735" class="lazy" id="theimg" alt="" onclick="window.open(this.src)" /></p> <p style="text-align: left">3. Display registration data in the database <br /> </p> <pre class='brush:php;toolbar:false;'> //往數(shù)據(jù)庫中添加數(shù)據(jù) <?php header("Content-type:text/html; charset=utf-8"); //-----------------------連接數(shù)據(jù)庫--------------------------- include_once "connect.php"; //-------------------------將數(shù)據(jù)連接到數(shù)據(jù)庫------------------ $time=time(); $sql="insert into user (username,password,email,sex,txt,`time`) value('{$_POST['username']}','{$_POST['password']}','{$_POST['email']}','{$_POST['sex']}','{$_POST['txt']}','{$time}')"; $res=mysql_query($sql); header("location:hello.php"); ?> </pre> <p style="text-align: center"><img src="/static/imghw/default1.png" data-src="http://www.bkjia.com/uploads/allimg/160329/00594W301-1.jpg?2016227162810" class="lazy" id="theimg" alt="" onclick="window.open(this.src)" /></p> <p>4. Return to the background interface</p> <pre class='brush:php;toolbar:false;'> <?php header("Content-type:text/html; charset=utf-8"); //-----------------------連接數(shù)據(jù)庫------------------------------ include_once "connect.php"; //--------------------查詢數(shù)據(jù)庫-------------------------------- $query="select * from user"; $result=mysql_query($query); if(!$result) { die("could not to the database<br/>".mysql_error()); } //-------------------封裝函數(shù)----------------------------- //該函數(shù)將數(shù)據(jù)庫的數(shù)據(jù)寫成數(shù)組形式 function result2Arr($result){ while($result_row=mysql_fetch_assoc($result)){ $arr[] = $result_row; } return $arr; } $arr = result2Arr($result); foreach($arr as $key=>$value){ echo "<table border='1px'>"; echo "<table border='1px' >"; echo "<tr> "; echo "<td width='100px'>".$value['id']."</td>"; echo "<td width='100px'>".$value['username']."</td>"; echo "<td width='100px'>".$value['password']."</td>"; echo "<td width='200px'>".$value['email']."</td>"; echo "<td width='100px'>".$value['sex']."</td>"; echo "<td width='100px'>".$value['txt']."</td>"; echo "<td width='100px'>".date('Y-m-d H:i:s',$value['time'])."</td>"; echo "<td width='100px'><a href='update1.php?id=$value[id]'>修改</a> <a href='delete.php?id=$value[id]'>刪除</a></td>"; echo "<tr/>"; echo "</table>"; } ?> </pre> <p style="text-align: center"><img src="/static/imghw/default1.png" data-src="http://www.bkjia.com/uploads/allimg/160329/00594T620-2.jpg?2016227162938" class="lazy" id="theimg" onclick="window.open(this.src)" alt="" /></p> <p>5. Modify data <br /> </p> <pre class='brush:php;toolbar:false;'> //當(dāng)用戶要修改信息時(shí)，返回頁面，頁面中包含之前填寫的信息 <!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" xml:lang="en"> <head> <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" /> <title>Document</title> </head> <body> <div> <?php include_once "connect.php"; $sql="select * from user where id='".$_GET['id']."'"; //echo "sql:".$sql;(顯示出修改哪一行) $result=mysql_query($sql,$link); $arr = result2Arr($result); //print_r($arr); $row = $arr[0]; function result2Arr($result){ while($result_row=mysql_fetch_assoc($result)){ $arr[] = $result_row; } return $arr; } ?> <h3>注冊(cè)頁面</h3> <form action="update.php" method='post'> <input type="hidden" name="id" id="" value="<?php echo $row['id']?>"/> <table border='1' cellpadding='0' cellspacing='0' width='80%' bgcolor='#ABCDEF'> <tr> <td align='right'>用戶名</td> <td><input type="text" name="username" id="" value="<?php echo $row['username']?>"/>以小寫字母開始，長度要求5~10</td> </tr> <tr> <td align='right'>密碼</td> <td><input type="password" name="password" id=""value="<?php echo $row['password']?>"/>密碼不能為空</td> </tr> <tr> <td align='right'>郵箱</td> <td><input type="text" name="email" id="" value="<?php echo $row['email']?>"/></td> </tr> <tr> <td align='right'>性別</td> <td> <input type="radio" name="sex" id="" value='1' <?php if($row['sex']=='1'){ echo 'checked';}?>/>男 <input type="radio" name="sex" id="" value='2' <?php if($row['sex']=='2'){ echo 'checked';}?>/>女 <input type="radio" name="sex" id="" value='3' <?php if($row['sex']=='3'){ echo 'checked';}?>/>保密 </td> </tr> <tr> <td align='right'>個(gè)人簡介</td> <td> <textarea name="txt" id="" cols="50" rows="10"><?php echo $row['txt']?></textarea> </td> </tr> <tr> <td colspan='2'><input type="submit" name='act' value='修改' /></td> </tr> </table> </form> </div> </body> </html> </pre> <p style="text-align: center"><img src="/static/imghw/default1.png" data-src="http://www.bkjia.com/uploads/allimg/160329/00594WB3-3.jpg?2016227163010" class="lazy" id="theimg" onclick="window.open(this.src)" alt="" /></p> <pre class='brush:php;toolbar:false;'> //將修改的信息存入數(shù)據(jù)庫 <?php header("Content-type:text/html; charset=utf-8"); //通過post獲取頁面提交數(shù)據(jù)信息 $data = $_POST; //print_r($data); include_once "connect.php"; $sql = "update `user` set username='{$data['username']}',password='{$data['password']}', email='{$data['email']}',sex='{$data['sex']}',txt='{$data['txt']}' where id='{$data['id']}'"; echo $sql; $res = mysql_query($sql,$link); if($res){ header("Location:hello.php"); //echo "alert('修改成功')"; }else{ header("Location:update1.php?id=".$data['id']); //echo "alert('修改失敗')"; } ?> </pre> <p style="text-align: center"><img src="/static/imghw/default1.png" data-src="http://www.bkjia.com/uploads/allimg/160329/00594S544-4.jpg?2016227163031" class="lazy" id="theimg" onclick="window.open(this.src)" alt="" /></p> <p>6. Delete data <br /> </p> <pre class='brush:php;toolbar:false;'> //刪除數(shù)據(jù)庫里的數(shù)據(jù) <?php header("Content-type:text/html; charset=utf-8"); include_once 'connect.php'; $sql = "delete from user where id='".$_GET['id']."'"; $sus=mysql_query($sql,$link); if($sus){ header("location:hello.php"); }else{ echo "alert('刪除失敗')"; } ?> //若要?jiǎng)h除李四，點(diǎn)擊刪除后，會(huì)自動(dòng)跳轉(zhuǎn)到后臺(tái)頁面，數(shù)據(jù)庫里數(shù)據(jù)也刪除 </pre> <p style="text-align: center"><img src="/static/imghw/default1.png" data-src="http://www.bkjia.com/uploads/allimg/160329/00594V4L-5.jpg?2016227163113" class="lazy" id="theimg" onclick="window.open(this.src)" alt=""></p> <p>The above is the entire content of this article, I hope it will be helpful to everyone’s study. </p>  <h4 id="Articles-you-may-be-interested-in">Articles you may be interested in: </h4> <ul> <li>PHP code to verify the existence of the username before registering on the page</li> <li>Using Php to write example code for email activation verification after registration</li> <li>Specific example of using js for form verification on the PHP user registration page</li> <li>ThinkPHP complete example of user registration login message</li> <li>PHP Ajax detection of whether the user name or email already exists when registering</li> ??><li>Detailed explanation of the development of PHP jQuery registration module</li> <li>Improvements of PHP jQuery registration module (1): Verification code is stored in SESSION</li> <li>Improvements of PHP jQuery registration module (2): Email activation </li> <li>php mysql method to implement user registration and login</li> <li>php sends SMS verification code to complete the registration function</li> </ul> <p align="left"></p> <div style="display:none;"> <span id="url" itemprop="url">http://www.bkjia.com/PHPjc/1114240.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http: //www.bkjia.com/PHPjc/1114240.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description">PHP connects to the database to implement the addition, deletion, modification and check operations of the registration page. The example of php addition and deletion in this article shares with everyone the implementation of PHP connection to the database. The method of adding, deleting, modifying and checking on the registration page is for your reference...</span> </div> <div id="377j5v51b" class="art_confoot"></div> </div> </div> <div id="377j5v51b" class="wzconShengming_sp"> <div id="377j5v51b" class="bzsmdiv_sp">Statement of this Website</div> <div>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</div> </div> </div> <ins class="adsbygoogle" style="display:block" data-ad-format="autorelaxed" data-ad-client="ca-pub-5902227090019525" data-ad-slot="2507867629"></ins> <div id="377j5v51b" class="AI_ToolDetails_main4sR"> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-5902227090019525" data-ad-slot="3653428331" data-ad-format="auto" data-full-width-responsive="true"></ins>  <div id="377j5v51b" class="phpgenera_Details_mainR3"> <div id="377j5v51b" class="phpmain1_4R_readrank"> <div id="377j5v51b" class="phpmain1_4R_readrank_top"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/hottools2.png" alt="" /> <h2>Hot AI Tools</h2> </div> <div id="377j5v51b" class="phpgenera_Details_mainR3_bottom"> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/ai/undress-ai-tool" title="Undress AI Tool" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/ai_manual/001/246/273/173410641626608.jpg?x-oss-process=image/resize,m_fill,h_50,w_50" src="/static/imghw/default1.png" alt="Undress AI Tool" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/ai/undress-ai-tool" title="Undress AI Tool" class="phpmain_tab2_mids_title"> <h3>Undress AI Tool</h3> </a> <p>Undress images for free</p> </div> </div> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/ai/undresserai-undress" title="Undresser.AI Undress" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/ai_manual/001/246/273/173411540686492.jpg?x-oss-process=image/resize,m_fill,h_50,w_50" src="/static/imghw/default1.png" alt="Undresser.AI Undress" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/ai/undresserai-undress" title="Undresser.AI Undress" class="phpmain_tab2_mids_title"> <h3>Undresser.AI Undress</h3> </a> <p>AI-powered app for creating realistic nude photos</p> </div> </div> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/ai/ai-clothes-remover" title="AI Clothes Remover" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/ai_manual/001/246/273/173411552797167.jpg?x-oss-process=image/resize,m_fill,h_50,w_50" src="/static/imghw/default1.png" alt="AI Clothes Remover" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/ai/ai-clothes-remover" title="AI Clothes Remover" class="phpmain_tab2_mids_title"> <h3>AI Clothes Remover</h3> </a> <p>Online AI tool for removing clothes from photos.</p> </div> </div> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/ai/clothoffio" title="Clothoff.io" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/ai_manual/001/246/273/173411529149311.jpg?x-oss-process=image/resize,m_fill,h_50,w_50" src="/static/imghw/default1.png" alt="Clothoff.io" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/ai/clothoffio" title="Clothoff.io" class="phpmain_tab2_mids_title"> <h3>Clothoff.io</h3> </a> <p>AI clothes remover</p> </div> </div> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/ai/video-swap" title="Video Face Swap" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/ai_manual/001/246/273/173414504068133.jpg?x-oss-process=image/resize,m_fill,h_50,w_50" src="/static/imghw/default1.png" alt="Video Face Swap" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/ai/video-swap" title="Video Face Swap" class="phpmain_tab2_mids_title"> <h3>Video Face Swap</h3> </a> <p>Swap faces in any video effortlessly with our completely free AI face swap tool!</p> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR3_more"> <a href="http://www.miracleart.cn/ai">Show More</a> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4"> <div id="377j5v51b" class="phpmain1_4R_readrank"> <div id="377j5v51b" class="phpmain1_4R_readrank_top"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/hotarticle2.png" alt="" /> <h2>Hot Article</h2> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottom"> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/1796821119.html" title="Guide: Stellar Blade Save File Location/Save File Lost/Not Saving" class="phpgenera_Details_mainR4_bottom_title">Guide: Stellar Blade Save File Location/Save File Lost/Not Saving</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <span>4 weeks ago</span> <span>By DDD</span> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/1796827210.html" title="Oguri Cap Build Guide | A Pretty Derby Musume" class="phpgenera_Details_mainR4_bottom_title">Oguri Cap Build Guide | A Pretty Derby Musume</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <span>2 weeks ago</span> <span>By Jack chen</span> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/1796828723.html" title="Agnes Tachyon Build Guide | A Pretty Derby Musume" class="phpgenera_Details_mainR4_bottom_title">Agnes Tachyon Build Guide | A Pretty Derby Musume</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <span>1 weeks ago</span> <span>By Jack chen</span> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/1796821436.html" title="Dune: Awakening - Advanced Planetologist Quest Walkthrough" class="phpgenera_Details_mainR4_bottom_title">Dune: Awakening - Advanced Planetologist Quest Walkthrough</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <span>3 weeks ago</span> <span>By Jack chen</span> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/1796821278.html" title="Date Everything: Dirk And Harper Relationship Guide" class="phpgenera_Details_mainR4_bottom_title">Date Everything: Dirk And Harper Relationship Guide</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <span>4 weeks ago</span> <span>By Jack chen</span> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR3_more"> <a href="http://www.miracleart.cn/article.html">Show More</a> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR3"> <div id="377j5v51b" class="phpmain1_4R_readrank"> <div id="377j5v51b" class="phpmain1_4R_readrank_top"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/hottools2.png" alt="" /> <h2>Hot Tools</h2> </div> <div id="377j5v51b" class="phpgenera_Details_mainR3_bottom"> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/toolset/development-tools/92" title="Notepad++7.3.1" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/manual/000/000/001/58ab96f0f39f7357.jpg?x-oss-process=image/resize,m_fill,h_50,w_72" src="/static/imghw/default1.png" alt="Notepad++7.3.1" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/toolset/development-tools/92" title="Notepad++7.3.1" class="phpmain_tab2_mids_title"> <h3>Notepad++7.3.1</h3> </a> <p>Easy-to-use and free code editor</p> </div> </div> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/toolset/development-tools/93" title="SublimeText3 Chinese version" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/manual/000/000/001/58ab97a3baad9677.jpg?x-oss-process=image/resize,m_fill,h_50,w_72" src="/static/imghw/default1.png" alt="SublimeText3 Chinese version" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/toolset/development-tools/93" title="SublimeText3 Chinese version" class="phpmain_tab2_mids_title"> <h3>SublimeText3 Chinese version</h3> </a> <p>Chinese version, very easy to use</p> </div> </div> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/toolset/development-tools/121" title="Zend Studio 13.0.1" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/manual/000/000/001/58ab97ecd1ab2670.jpg?x-oss-process=image/resize,m_fill,h_50,w_72" src="/static/imghw/default1.png" alt="Zend Studio 13.0.1" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/toolset/development-tools/121" title="Zend Studio 13.0.1" class="phpmain_tab2_mids_title"> <h3>Zend Studio 13.0.1</h3> </a> <p>Powerful PHP integrated development environment</p> </div> </div> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/toolset/development-tools/469" title="Dreamweaver CS6" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/manual/000/000/001/58d0e0fc74683535.jpg?x-oss-process=image/resize,m_fill,h_50,w_72" src="/static/imghw/default1.png" alt="Dreamweaver CS6" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/toolset/development-tools/469" title="Dreamweaver CS6" class="phpmain_tab2_mids_title"> <h3>Dreamweaver CS6</h3> </a> <p>Visual web development tools</p> </div> </div> <div id="377j5v51b" class="phpmain_tab2_mids_top"> <a href="http://www.miracleart.cn/toolset/development-tools/500" title="SublimeText3 Mac version" class="phpmain_tab2_mids_top_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" class="lazy" data-src="https://img.php.cn/upload/manual/000/000/001/58d34035e2757995.png?x-oss-process=image/resize,m_fill,h_50,w_72" src="/static/imghw/default1.png" alt="SublimeText3 Mac version" /> </a> <div id="377j5v51b" class="phpmain_tab2_mids_info"> <a href="http://www.miracleart.cn/toolset/development-tools/500" title="SublimeText3 Mac version" class="phpmain_tab2_mids_title"> <h3>SublimeText3 Mac version</h3> </a> <p>God-level code editing software (SublimeText3)</p> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR3_more"> <a href="http://www.miracleart.cn/ai">Show More</a> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4"> <div id="377j5v51b" class="phpmain1_4R_readrank"> <div id="377j5v51b" class="phpmain1_4R_readrank_top"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/hotarticle2.png" alt="" /> <h2>Hot Topics</h2> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottom"> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/gmailyxdlrkzn" title="Where is the login entrance for gmail email?" class="phpgenera_Details_mainR4_bottom_title">Where is the login entrance for gmail email?</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/eyess.png" alt="" /> <span>8637</span> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/tiezi.png" alt="" /> <span>17</span> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/java-tutorial" title="Java Tutorial" class="phpgenera_Details_mainR4_bottom_title">Java Tutorial</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/eyess.png" alt="" /> <span>1783</span> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/tiezi.png" alt="" /> <span>16</span> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/cakephp-tutor" title="CakePHP Tutorial" class="phpgenera_Details_mainR4_bottom_title">CakePHP Tutorial</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/eyess.png" alt="" /> <span>1727</span> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/tiezi.png" alt="" /> <span>56</span> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/laravel-tutori" title="Laravel Tutorial" class="phpgenera_Details_mainR4_bottom_title">Laravel Tutorial</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/eyess.png" alt="" /> <span>1577</span> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/tiezi.png" alt="" /> <span>28</span> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms"> <a href="http://www.miracleart.cn/faq/php-tutorial" title="PHP Tutorial" class="phpgenera_Details_mainR4_bottom_title">PHP Tutorial</a> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_info"> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/eyess.png" alt="" /> <span>1442</span> </div> <div id="377j5v51b" class="phpgenera_Details_mainR4_bottoms_infos"> <img src="/static/imghw/tiezi.png" alt="" /> <span>31</span> </div> </div> </div> </div> <div id="377j5v51b" class="phpgenera_Details_mainR3_more"> <a href="http://www.miracleart.cn/faq/zt">Show More</a> </div> </div> </div> </div> </div> <div id="377j5v51b" class="Article_Details_main2"> <div id="377j5v51b" class="phpgenera_Details_mainL4"> <div id="377j5v51b" class="phpmain1_2_top"> <a href="javascript:void(0);" class="phpmain1_2_top_title">Related knowledge<img src="/static/imghw/index2_title2.png" alt="" /></a> </div> <div id="377j5v51b" class="phpgenera_Details_mainL4_info"> <div id="377j5v51b" class="phphistorical_Version2_mids"> <a href="http://www.miracleart.cn/faq/1796837310.html" title="Using std::chrono in C" class="phphistorical_Version2_mids_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/default1.png" class="lazy" data-src="https://img.php.cn/upload/article/001/253/068/175251423054720.jpg?x-oss-process=image/resize,m_fill,h_207,w_330" alt="Using std::chrono in C" /> </a> <a href="http://www.miracleart.cn/faq/1796837310.html" title="Using std::chrono in C" class="phphistorical_Version2_mids_title">Using std::chrono in C</a> <span id="377j5v51b" class="Articlelist_txts_time">Jul 15, 2025 am 01:30 AM</span> <p class="Articlelist_txts_p">std::chrono is used in C to process time, including obtaining the current time, measuring execution time, operation time point and duration, and formatting analysis time. 1. Use std::chrono::system_clock::now() to obtain the current time, which can be converted into a readable string, but the system clock may not be monotonous; 2. Use std::chrono::steady_clock to measure the execution time to ensure monotony, and convert it into milliseconds, seconds and other units through duration_cast; 3. Time point (time_point) and duration (duration) can be interoperable, but attention should be paid to unit compatibility and clock epoch (epoch)</p> </div> <div id="377j5v51b" class="phphistorical_Version2_mids"> <a href="http://www.miracleart.cn/faq/1796836980.html" title="How does PHP handle Environment Variables?" class="phphistorical_Version2_mids_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/default1.png" class="lazy" data-src="https://img.php.cn/upload/article/001/253/068/175243330086297.jpg?x-oss-process=image/resize,m_fill,h_207,w_330" alt="How does PHP handle Environment Variables?" /> </a> <a href="http://www.miracleart.cn/faq/1796836980.html" title="How does PHP handle Environment Variables?" class="phphistorical_Version2_mids_title">How does PHP handle Environment Variables?</a> <span id="377j5v51b" class="Articlelist_txts_time">Jul 14, 2025 am 03:01 AM</span> <p class="Articlelist_txts_p">ToaccessenvironmentvariablesinPHP,usegetenv()orthe$_ENVsuperglobal.1.getenv('VAR_NAME')retrievesaspecificvariable.2.$_ENV['VAR_NAME']accessesvariablesifvariables_orderinphp.iniincludes"E".SetvariablesviaCLIwithVAR=valuephpscript.php,inApach</p> </div> <div id="377j5v51b" class="phphistorical_Version2_mids"> <a href="http://www.miracleart.cn/faq/1796836881.html" title="mysql common table expression (cte) example" class="phphistorical_Version2_mids_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/default1.png" class="lazy" data-src="https://img.php.cn/upload/article/001/431/639/175243128160551.jpg?x-oss-process=image/resize,m_fill,h_207,w_330" alt="mysql common table expression (cte) example" /> </a> <a href="http://www.miracleart.cn/faq/1796836881.html" title="mysql common table expression (cte) example" class="phphistorical_Version2_mids_title">mysql common table expression (cte) example</a> <span id="377j5v51b" class="Articlelist_txts_time">Jul 14, 2025 am 02:28 AM</span> <p class="Articlelist_txts_p">CTE is a temporary result set in MySQL used to simplify complex queries. It can be referenced multiple times in the current query, improving code readability and maintenance. For example, when looking for the latest orders for each user in the orders table, you can first obtain the latest order date for each user through the CTE, and then associate it with the original table to obtain the complete record. Compared with subqueries, the CTE structure is clearer and the logic is easier to debug. Usage tips include explicit alias, concatenating multiple CTEs, and processing tree data with recursive CTEs. Mastering CTE can make SQL more elegant and efficient.</p> </div> <div id="377j5v51b" class="phphistorical_Version2_mids"> <a href="http://www.miracleart.cn/faq/1796837555.html" title="Why We Comment: A PHP Guide" class="phphistorical_Version2_mids_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/default1.png" class="lazy" data-src="https://img.php.cn/upload/article/001/253/068/175251888049018.jpg?x-oss-process=image/resize,m_fill,h_207,w_330" alt="Why We Comment: A PHP Guide" /> </a> <a href="http://www.miracleart.cn/faq/1796837555.html" title="Why We Comment: A PHP Guide" class="phphistorical_Version2_mids_title">Why We Comment: A PHP Guide</a> <span id="377j5v51b" class="Articlelist_txts_time">Jul 15, 2025 am 02:48 AM</span> <p class="Articlelist_txts_p">PHPhasthreecommentstyles://,#forsingle-lineand/.../formulti-line.Usecommentstoexplainwhycodeexists,notwhatitdoes.MarkTODO/FIXMEitemsanddisablecodetemporarilyduringdebugging.Avoidover-commentingsimplelogic.Writeconcise,grammaticallycorrectcommentsandu</p> </div> <div id="377j5v51b" class="phphistorical_Version2_mids"> <a href="http://www.miracleart.cn/faq/1796836966.html" title="PHP prepared statement with IN clause" class="phphistorical_Version2_mids_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/default1.png" class="lazy" data-src="https://img.php.cn/upload/article/001/431/639/175243301188388.jpg?x-oss-process=image/resize,m_fill,h_207,w_330" alt="PHP prepared statement with IN clause" /> </a> <a href="http://www.miracleart.cn/faq/1796836966.html" title="PHP prepared statement with IN clause" class="phphistorical_Version2_mids_title">PHP prepared statement with IN clause</a> <span id="377j5v51b" class="Articlelist_txts_time">Jul 14, 2025 am 02:56 AM</span> <p class="Articlelist_txts_p">When using PHP preprocessing statements to execute queries with IN clauses, 1. Dynamically generate placeholders according to the length of the array; 2. When using PDO, you can directly pass in the array, and use array_values to ensure continuous indexes; 3. When using mysqli, you need to construct type strings and bind parameters, pay attention to the way of expanding the array and version compatibility; 4. Avoid splicing SQL, processing empty arrays, and ensuring data types match. The specific method is: first use implode and array_fill to generate placeholders, and then bind parameters according to the extended characteristics to safely execute IN queries.</p> </div> <div id="377j5v51b" class="phphistorical_Version2_mids"> <a href="http://www.miracleart.cn/faq/1796836950.html" title="how to avoid undefined index error in PHP" class="phphistorical_Version2_mids_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/default1.png" class="lazy" data-src="https://img.php.cn/upload/article/001/431/639/175243268199523.jpg?x-oss-process=image/resize,m_fill,h_207,w_330" alt="how to avoid undefined index error in PHP" /> </a> <a href="http://www.miracleart.cn/faq/1796836950.html" title="how to avoid undefined index error in PHP" class="phphistorical_Version2_mids_title">how to avoid undefined index error in PHP</a> <span id="377j5v51b" class="Articlelist_txts_time">Jul 14, 2025 am 02:51 AM</span> <p class="Articlelist_txts_p">There are three key ways to avoid the "undefinedindex" error: First, use isset() to check whether the array key exists and ensure that the value is not null, which is suitable for most common scenarios; second, use array_key_exists() to only determine whether the key exists, which is suitable for situations where the key does not exist and the value is null; finally, use the empty merge operator?? (PHP7) to concisely set the default value, which is recommended for modern PHP projects, and pay attention to the spelling of form field names, use extract() carefully, and check the array is not empty before traversing to further avoid risks.</p> </div> <div id="377j5v51b" class="phphistorical_Version2_mids"> <a href="http://www.miracleart.cn/faq/1796837489.html" title="Choosing appropriate data types for columns in MySQL tables" class="phphistorical_Version2_mids_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/default1.png" class="lazy" data-src="https://img.php.cn/upload/article/001/253/068/175251755013422.jpg?x-oss-process=image/resize,m_fill,h_207,w_330" alt="Choosing appropriate data types for columns in MySQL tables" /> </a> <a href="http://www.miracleart.cn/faq/1796837489.html" title="Choosing appropriate data types for columns in MySQL tables" class="phphistorical_Version2_mids_title">Choosing appropriate data types for columns in MySQL tables</a> <span id="377j5v51b" class="Articlelist_txts_time">Jul 15, 2025 am 02:25 AM</span> <p class="Articlelist_txts_p">WhensettingupMySQLtables,choosingtherightdatatypesiscrucialforefficiencyandscalability.1)Understandthedataeachcolumnwillstore—numbers,text,dates,orflags—andchooseaccordingly.2)UseCHARforfixed-lengthdatalikecountrycodesandVARCHARforvariable-lengthdata</p> </div> <div id="377j5v51b" class="phphistorical_Version2_mids"> <a href="http://www.miracleart.cn/faq/1796836797.html" title="PHP header redirect not working" class="phphistorical_Version2_mids_img"> <img onerror="this.onerror=''; this.src='/static/imghw/default1.png'" src="/static/imghw/default1.png" class="lazy" data-src="https://img.php.cn/upload/article/001/431/639/175242958117031.jpg?x-oss-process=image/resize,m_fill,h_207,w_330" alt="PHP header redirect not working" /> </a> <a href="http://www.miracleart.cn/faq/1796836797.html" title="PHP header redirect not working" class="phphistorical_Version2_mids_title">PHP header redirect not working</a> <span id="377j5v51b" class="Articlelist_txts_time">Jul 14, 2025 am 01:59 AM</span> <p class="Articlelist_txts_p">Reasons and solutions for the header function jump failure: 1. There is output before the header, and all pre-outputs need to be checked and removed or ob_start() buffer is used; 2. The failure to add exit causes subsequent code interference, and exit or die should be added immediately after the jump; 3. The path error should be used to ensure correctness by using absolute paths or dynamic splicing; 4. Server configuration or cache interference can be tried to clear the cache or replace the environment test.</p> </div> </div> <a href="http://www.miracleart.cn/be/" class="phpgenera_Details_mainL4_botton"> <span>See all articles</span> <img src="/static/imghw/down_right.png" alt="" /> </a> </div> </div> </div> </main> <footer> <div id="377j5v51b" class="footer"> <div id="377j5v51b" class="footertop"> <img src="/static/imghw/logo.png" alt=""> <p>Public welfare online PHP training，Help PHP learners grow quickly！</p> </div> <div id="377j5v51b" class="footermid"> <a href="http://www.miracleart.cn/about/us.html">About us</a> <a href="http://www.miracleart.cn/about/disclaimer.html">Disclaimer</a> <a href="http://www.miracleart.cn/update/article_0_1.html">Sitemap</a> </div> <div id="377j5v51b" class="footerbottom"> <p> ? php.cn All rights reserved </p> </div> </div> </footer> <input type="hidden" id="verifycode" value="/captcha.html"> <link rel='stylesheet' id='_main-css' href='/static/css/viewer.min.css?2' type='text/css' media='all' /> <footer> <div class="friendship-link"> <p>感谢您访问我们的网站，您可能还对以下资源感兴趣：</p> <a href="http://www.miracleart.cn/" title="国产av日韩一区二区三区精品">国产av日韩一区二区三区精品</a> <div class="friend-links"> </div> </div> </footer> <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body><div id="w20wi" class="pl_css_ganrao" style="display: none;"><ul id="w20wi"><strong id="w20wi"><xmp id="w20wi"></xmp></strong></ul><abbr id="w20wi"></abbr><del id="w20wi"></del><bdo id="w20wi"><tr id="w20wi"><abbr id="w20wi"></abbr></tr></bdo><rt id="w20wi"><center id="w20wi"><abbr id="w20wi"></abbr></center></rt><kbd id="w20wi"></kbd><pre id="w20wi"><optgroup id="w20wi"><fieldset id="w20wi"></fieldset></optgroup></pre><pre id="w20wi"></pre><center id="w20wi"><xmp id="w20wi"><small id="w20wi"></small></xmp></center><xmp id="w20wi"></xmp><center id="w20wi"><nav id="w20wi"><blockquote id="w20wi"></blockquote></nav></center><tr id="w20wi"><menu id="w20wi"><tfoot id="w20wi"></tfoot></menu></tr><li id="w20wi"></li><th id="w20wi"></th><strong id="w20wi"><xmp id="w20wi"><samp id="w20wi"></samp></xmp></strong><abbr id="w20wi"></abbr><menu id="w20wi"></menu><pre id="w20wi"></pre><dfn id="w20wi"></dfn><bdo id="w20wi"><delect id="w20wi"><optgroup id="w20wi"></optgroup></delect></bdo><tbody id="w20wi"></tbody><delect id="w20wi"></delect><pre id="w20wi"><abbr id="w20wi"><s id="w20wi"></s></abbr></pre><s id="w20wi"></s><tbody id="w20wi"></tbody><del id="w20wi"></del><center id="w20wi"></center><delect id="w20wi"></delect><optgroup id="w20wi"></optgroup><rt id="w20wi"></rt><dfn id="w20wi"></dfn><li id="w20wi"><th id="w20wi"><button id="w20wi"></button></th></li><s id="w20wi"><tbody id="w20wi"><noframes id="w20wi"></noframes></tbody></s><wbr id="w20wi"></wbr><input id="w20wi"><tr id="w20wi"><ul id="w20wi"></ul></tr></input><li id="w20wi"></li><abbr id="w20wi"><s id="w20wi"><tbody id="w20wi"></tbody></s></abbr><dd id="w20wi"></dd><menu id="w20wi"><tbody id="w20wi"><small id="w20wi"></small></tbody></menu><tr id="w20wi"><abbr id="w20wi"><wbr id="w20wi"></wbr></abbr></tr><option id="w20wi"></option><rt id="w20wi"></rt><button id="w20wi"></button><bdo id="w20wi"></bdo><blockquote id="w20wi"></blockquote><sup id="w20wi"></sup><object id="w20wi"></object><code id="w20wi"></code><tbody id="w20wi"><ul id="w20wi"><li id="w20wi"></li></ul></tbody><menu id="w20wi"></menu><td id="w20wi"></td><blockquote id="w20wi"></blockquote><kbd id="w20wi"></kbd><fieldset id="w20wi"></fieldset><bdo id="w20wi"></bdo><source id="w20wi"></source><ul id="w20wi"><fieldset id="w20wi"><dd id="w20wi"></dd></fieldset></ul><option id="w20wi"><code id="w20wi"><td id="w20wi"></td></code></option><optgroup id="w20wi"><xmp id="w20wi"><option id="w20wi"></option></xmp></optgroup><pre id="w20wi"></pre><tfoot id="w20wi"></tfoot><dd id="w20wi"><em id="w20wi"><bdo id="w20wi"></bdo></em></dd><pre id="w20wi"></pre><small id="w20wi"></small><em id="w20wi"></em><cite id="w20wi"></cite><pre id="w20wi"></pre><optgroup id="w20wi"></optgroup><tbody id="w20wi"></tbody><li id="w20wi"><tbody id="w20wi"><tr id="w20wi"></tr></tbody></li><dd id="w20wi"><em id="w20wi"><rt id="w20wi"></rt></em></dd><optgroup id="w20wi"></optgroup><tbody id="w20wi"><wbr id="w20wi"><sup id="w20wi"></sup></wbr></tbody><s id="w20wi"><ul id="w20wi"><optgroup id="w20wi"></optgroup></ul></s><s id="w20wi"></s><dd id="w20wi"><delect id="w20wi"><bdo id="w20wi"></bdo></delect></dd><code id="w20wi"><dfn id="w20wi"><button id="w20wi"></button></dfn></code><object id="w20wi"><button id="w20wi"><table id="w20wi"></table></button></object><tfoot id="w20wi"></tfoot><blockquote id="w20wi"><abbr id="w20wi"><dl id="w20wi"></dl></abbr></blockquote><dfn id="w20wi"><table id="w20wi"><cite id="w20wi"></cite></table></dfn><strike id="w20wi"></strike><tr id="w20wi"></tr><center id="w20wi"><option id="w20wi"><s id="w20wi"></s></option></center><source id="w20wi"><sup id="w20wi"><li id="w20wi"></li></sup></source><delect id="w20wi"><small id="w20wi"><fieldset id="w20wi"></fieldset></small></delect><th id="w20wi"></th><input id="w20wi"></input><cite id="w20wi"></cite><pre id="w20wi"><bdo id="w20wi"><pre id="w20wi"></pre></bdo></pre><input id="w20wi"></input><nav id="w20wi"><input id="w20wi"><delect id="w20wi"></delect></input></nav><input id="w20wi"><tr id="w20wi"><noframes id="w20wi"></noframes></tr></input><xmp id="w20wi"></xmp><fieldset id="w20wi"></fieldset><ul id="w20wi"><optgroup id="w20wi"><xmp id="w20wi"></xmp></optgroup></ul><blockquote id="w20wi"></blockquote><menu id="w20wi"></menu><abbr id="w20wi"></abbr><pre id="w20wi"><li id="w20wi"><rt id="w20wi"></rt></li></pre><dfn id="w20wi"><table id="w20wi"><dfn id="w20wi"></dfn></table></dfn><tbody id="w20wi"></tbody><kbd id="w20wi"></kbd><wbr id="w20wi"><abbr id="w20wi"><dl id="w20wi"></dl></abbr></wbr><input id="w20wi"><tr id="w20wi"><ul id="w20wi"></ul></tr></input><noframes id="w20wi"></noframes><delect id="w20wi"></delect><tr id="w20wi"><abbr id="w20wi"><center id="w20wi"></center></abbr></tr><menu id="w20wi"></menu><nav id="w20wi"><tfoot id="w20wi"><del id="w20wi"></del></tfoot></nav><li id="w20wi"><bdo id="w20wi"><tr id="w20wi"></tr></bdo></li><em id="w20wi"></em><option id="w20wi"></option><del id="w20wi"><abbr id="w20wi"><dl id="w20wi"></dl></abbr></del><acronym id="w20wi"></acronym><center id="w20wi"><input id="w20wi"><s id="w20wi"></s></input></center><object id="w20wi"></object><th id="w20wi"></th><optgroup id="w20wi"></optgroup><strike id="w20wi"></strike><cite id="w20wi"></cite><abbr id="w20wi"></abbr><blockquote id="w20wi"></blockquote><fieldset id="w20wi"></fieldset><xmp id="w20wi"></xmp><ul id="w20wi"></ul><li id="w20wi"><th id="w20wi"><blockquote id="w20wi"></blockquote></th></li><s id="w20wi"></s><abbr id="w20wi"></abbr><cite id="w20wi"></cite><s id="w20wi"></s><tbody id="w20wi"><strong id="w20wi"><sup id="w20wi"></sup></strong></tbody><pre id="w20wi"></pre><em id="w20wi"></em><pre id="w20wi"></pre><noframes id="w20wi"><fieldset id="w20wi"><dd id="w20wi"></dd></fieldset></noframes><dl id="w20wi"></dl><tfoot id="w20wi"></tfoot><li id="w20wi"></li><center id="w20wi"><tbody id="w20wi"><tr id="w20wi"></tr></tbody></center><fieldset id="w20wi"></fieldset><cite id="w20wi"></cite><dfn id="w20wi"></dfn></div> </html>