首頁 php教程 php手册 PHP操作数据库 动态创建字段

PHP操作数据库 动态创建字段

Jun 21, 2016 am 08:52 AM
gt lt nbsp option quot

PHP操作数据库时自动创建字段,如下代码:

<ol class="dp-xml">
<li class="alt"><span><span class="tag"><span class="tag-name">html</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span><span class="tag"><span class="tag-name">head</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span><span class="tag"><span class="tag-name">meta</span><span> </span><span class="attribute">http-equiv</span><span>=</span><span class="attribute-value">"Content-Type"</span><span> </span><span class="attribute">content</span><span>=</span><span class="attribute-value">"text/html; charset=gb2312"</span><span> </span><span class="tag">/&gt;</span><span> </span></span></span></li>
<li><span><span class="tag"><span class="tag-name">title</span><span class="tag">&gt;</span><span>动态创建字段 - www.cxybl.com</span><span class="tag"></span><span class="tag-name">title</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span><span class="tag"><span class="tag-name">style</span><span> </span><span class="attribute">type</span><span>=</span><span class="attribute-value">"text/css"</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span><span class="comments"><!--</span> </span></li><li class="alt"><span><span class="comments">.STYLE1 {font-size: 12px}</span> </span></li><li><span><span class="comments">--></span><span> </span></span></li>
<li class="alt"><span><span class="tag"></span><span class="tag-name">style</span><span class="tag">&gt;</span><span> </span></span></li>
<li><span><span class="tag"></span><span class="tag-name">head</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span> </span></li>
<li><span><span class="tag"><span class="tag-name">body</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span><span class="tag"><span class="tag-name">form</span><span> </span><span class="attribute">id</span><span>=</span><span class="attribute-value">"form1"</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"form1"</span><span> </span><span class="attribute">method</span><span>=</span><span class="attribute-value">"post"</span><span> </span><span class="attribute">action</span><span>=</span><span class="attribute-value">"index_ok.php"</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>  <span class="tag"><span class="tag-name">table</span><span> </span><span class="attribute">width</span><span>=</span><span class="attribute-value">"467"</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"289"</span><span> </span><span class="attribute">border</span><span>=</span><span class="attribute-value">"0"</span><span> </span><span class="attribute">cellpadding</span><span>=</span><span class="attribute-value">"0"</span><span> </span><span class="attribute">cellspacing</span><span>=</span><span class="attribute-value">"0"</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>    <span class="tag"><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">width</span><span>=</span><span class="attribute-value">"168"</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"89"</span><span class="tag">&gt;</span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">width</span><span>=</span><span class="attribute-value">"289"</span><span class="tag">&gt;</span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>    <span class="tag"></span><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span>    <span class="tag"><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"30"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"right"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">span</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span>选择表 </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li class="alt"><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">input</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"table"</span><span> </span><span class="attribute">type</span><span>=</span><span class="attribute-value">"text"</span><span> </span><span class="attribute">id</span><span>=</span><span class="attribute-value">"table"</span><span> </span><span class="attribute">size</span><span>=</span><span class="attribute-value">"20"</span><span> </span><span class="tag">/&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li><span>    <span class="tag"></span><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span>    <span class="tag"><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"30"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"right"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">span</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span>字段 </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li class="alt"><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">input</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"field"</span><span> </span><span class="attribute">type</span><span>=</span><span class="attribute-value">"text"</span><span> </span><span class="attribute">id</span><span>=</span><span class="attribute-value">"field"</span><span> </span><span class="attribute">size</span><span>=</span><span class="attribute-value">"20"</span><span class="tag">&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li><span>    <span class="tag"></span><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span>    <span class="tag"><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"30"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"right"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">span</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span>类型 </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li class="alt"><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">select</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"type"</span><span> </span><span class="attribute">id</span><span>=</span><span class="attribute-value">"type"</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li><span>        <span class="tag"><span class="tag-name">option</span><span class="tag">&gt;</span><span>int</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>        <span class="tag"><span class="tag-name">option</span><span class="tag">&gt;</span><span>text</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>        <span class="tag"><span class="tag-name">option</span><span class="tag">&gt;</span><span>date</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>        <span class="tag"><span class="tag-name">option</span><span class="tag">&gt;</span><span>double</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>        <span class="tag"><span class="tag-name">option</span><span class="tag">&gt;</span><span>varchar</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>        <span class="tag"><span class="tag-name">option</span><span class="tag">&gt;</span><span>datetime</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>        <span class="tag"><span class="tag-name">option</span><span class="tag">&gt;</span><span>blob</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>      <span class="tag"></span><span class="tag-name">select</span><span class="tag">&gt;</span><span>      </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></li>
<li><span>    <span class="tag"></span><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span>    <span class="tag"><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"30"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"right"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">span</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span>长度 </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li class="alt"><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">input</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"length"</span><span> </span><span class="attribute">type</span><span>=</span><span class="attribute-value">"text"</span><span> </span><span class="attribute">id</span><span>=</span><span class="attribute-value">"length"</span><span> </span><span class="attribute">size</span><span>=</span><span class="attribute-value">"15"</span><span class="tag">&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li><span>    <span class="tag"></span><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span>    <span class="tag"><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"30"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"right"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">span</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span>NULL </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li class="alt"><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">class</span><span>=</span><span class="attribute-value">"STYLE1"</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">input</span><span> </span><span class="attribute">type</span><span>=</span><span class="attribute-value">"radio"</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"null"</span><span> </span><span class="attribute">value</span><span>=</span><span class="attribute-value">"null"</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li><span>        null </span></li>
<li class="alt"><span>        <span class="tag"><span class="tag-name">input</span><span> </span><span class="attribute">type</span><span>=</span><span class="attribute-value">"radio"</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"null"</span><span> </span><span class="attribute">value</span><span>=</span><span class="attribute-value">"not null"</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>        not null <span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span>    <span class="tag"></span><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></li>
<li><span>    <span class="tag"><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"30"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"right"</span><span class="tag">&gt;</span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>      <span class="tag"><span class="tag-name">td</span><span class="tag">&gt;</span><span class="tag"><span class="tag-name">input</span><span> </span><span class="attribute">type</span><span>=</span><span class="attribute-value">"submit"</span><span> </span><span class="attribute">name</span><span>=</span><span class="attribute-value">"Submit"</span><span> </span><span class="attribute">value</span><span>=</span><span class="attribute-value">"提交"</span><span> </span><span class="tag">/&gt;</span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></span></li>
<li class="alt"><span>    <span class="tag"></span><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></li>
<li><span>    <span class="tag"><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>      <span class="tag"><span class="tag-name">td</span><span> </span><span class="attribute">height</span><span>=</span><span class="attribute-value">"20"</span><span> </span><span class="attribute">align</span><span>=</span><span class="attribute-value">"right"</span><span class="tag">&gt;</span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li><span>      <span class="tag"><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">&gt;</span><span> </span></span></span></li>
<li class="alt"><span>    <span class="tag"></span><span class="tag-name">tr</span><span class="tag">&gt;</span><span> </span></span></li>
<li><span>  <span class="tag"></span><span class="tag-name">table</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span><span class="tag"></span><span class="tag-name">form</span><span class="tag">&gt;</span><span> </span></span></li>
<li><span><span class="tag"></span><span class="tag-name">body</span><span class="tag">&gt;</span><span> </span></span></li>
<li class="alt"><span><span class="tag"></span><span class="tag-name">html</span><span class="tag">&gt;</span><span> </span></span></li>
</ol>
登入後複製

conn.php:

<ol class="dp-c">
<li class="alt"><span><span><?php   </span></span></span></li>
<li><span><span class="vars">$id</span><span>=mysql_connect(</span><span class="string">"localhost"</span><span>,</span><span class="string">"root"</span><span>,</span><span class="string">"mysql"</span><span>) </span><span class="keyword">or</span><span> </span><span class="keyword">die</span><span>(</span><span class="string">'连接失败:'</span><span> . mysql_error()); </span></span></li>
<li class="alt"><span><span class="keyword">if</span><span>(mysql_select_db(</span><span class="string">"phpjcdb"</span><span>,</span><span class="vars">$id</span><span>))  </span><span class="comment">//说明:phpjcdb 是数据库名称</span><span> </span></span></li>
<li><span>  <span class="func">echo</span><span> </span><span class="string">""</span><span>; </span></span></li>
<li class="alt"><span>  <span class="keyword">else</span><span> </span></span></li>
<li><span>  <span class="func">echo</span><span> (</span><span class="string">'数据库选择失败:'</span><span> . mysql_error()); </span></span></li>
<li class="alt"><span>mysql_query(<span class="string">"set names gb2312"</span><span>);  </span><span class="comment">//设置为简体中文</span><span> </span></span></li>
<li><span>?&gt; </span></li>
</ol>
登入後複製

index_ok.php:

<ol class="dp-c">
<li class="alt"><span><span><?php   </span></span></span></li>
<li><span>session_start();  </span></li>
<li class="alt"><span><span class="keyword">include</span><span>(</span><span class="string">"conn.php"</span><span>); </span></span></li>
<li><span><span class="keyword">if</span><span>(</span><span class="vars">$_POST</span><span>[</span><span class="string">'Submit'</span><span>]==true){ </span></span></li>
<li class="alt"><span>  <span class="vars">$null</span><span>=</span><span class="vars">$_POST</span><span>[null]; </span></span></li>
<li><span>  <span class="vars">$table</span><span> = </span><span class="vars">$_POST</span><span>[</span><span class="string">'table'</span><span>]; </span></span></li>
<li class="alt"><span>  <span class="vars">$field</span><span> = </span><span class="vars">$_POST</span><span>[</span><span class="string">'field'</span><span>]; </span></span></li>
<li><span>  <span class="vars">$type</span><span> = </span><span class="vars">$_POST</span><span>[</span><span class="string">'type'</span><span>]; </span></span></li>
<li class="alt"><span>  <span class="vars">$length</span><span> = </span><span class="vars">$_POST</span><span>[</span><span class="string">'length'</span><span>]; </span></span></li>
<li><span>  <span class="vars">$mysql</span><span>=mysql_query(</span><span class="string">"alter table $table add $field $type($length) $null"</span><span>); </span></span></li>
<li class="alt"><span>    <span class="func">echo</span><span> mysql_error(); </span></span></li>
<li><span>  <span class="keyword">if</span><span>(</span><span class="vars">$mysql</span><span>==true){ </span></span></li>
<li class="alt"><span>    <span class="func">echo</span><span> </span><span class="string">"字段添加成功!"</span><span>; </span></span></li>
<li><span>  }<span class="keyword">else</span><span>{</span><span class="func">echo</span><span> </span><span class="string">"添加失败!"</span><span>;} </span></span></li>
<li class="alt"><span>} </span></li>
<li><span>?&gt; </span></li>
</ol>
登入後複製



本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn

熱門文章

R.E.P.O.能量晶體解釋及其做什麼(黃色晶體)
2 週前 By 尊渡假赌尊渡假赌尊渡假赌
倉庫:如何復興隊友
4 週前 By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒險:如何獲得巨型種子
3 週前 By 尊渡假赌尊渡假赌尊渡假赌

熱門文章

R.E.P.O.能量晶體解釋及其做什麼(黃色晶體)
2 週前 By 尊渡假赌尊渡假赌尊渡假赌
倉庫:如何復興隊友
4 週前 By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒險:如何獲得巨型種子
3 週前 By 尊渡假赌尊渡假赌尊渡假赌

熱門文章標籤

記事本++7.3.1

記事本++7.3.1

好用且免費的程式碼編輯器

SublimeText3漢化版

SublimeText3漢化版

中文版,非常好用

禪工作室 13.0.1

禪工作室 13.0.1

強大的PHP整合開發環境

Dreamweaver CS6

Dreamweaver CS6

視覺化網頁開發工具

SublimeText3 Mac版

SublimeText3 Mac版

神級程式碼編輯軟體(SublimeText3)

解決方法:您的組織要求您更改 PIN 碼 解決方法:您的組織要求您更改 PIN 碼 Oct 04, 2023 pm 05:45 PM

解決方法:您的組織要求您更改 PIN 碼

Windows 11 上調整視窗邊框設定的方法:變更顏色和大小 Windows 11 上調整視窗邊框設定的方法:變更顏色和大小 Sep 22, 2023 am 11:37 AM

Windows 11 上調整視窗邊框設定的方法:變更顏色和大小

如何在 Windows 11 上變更標題列顏色? 如何在 Windows 11 上變更標題列顏色? Sep 14, 2023 pm 03:33 PM

如何在 Windows 11 上變更標題列顏色?

OOBELANGUAGE錯誤Windows 11 / 10修復中出現問題的問題 OOBELANGUAGE錯誤Windows 11 / 10修復中出現問題的問題 Jul 16, 2023 pm 03:29 PM

OOBELANGUAGE錯誤Windows 11 / 10修復中出現問題的問題

Windows 11 上啟用或停用工作列縮圖預覽的方法 Windows 11 上啟用或停用工作列縮圖預覽的方法 Sep 15, 2023 pm 03:57 PM

Windows 11 上啟用或停用工作列縮圖預覽的方法

華為GT3 Pro和GT4的差異是什麼? 華為GT3 Pro和GT4的差異是什麼? Dec 29, 2023 pm 02:27 PM

華為GT3 Pro和GT4的差異是什麼?

Windows 11 上的顯示縮放比例調整指南 Windows 11 上的顯示縮放比例調整指南 Sep 19, 2023 pm 06:45 PM

Windows 11 上的顯示縮放比例調整指南

10種在 Windows 11 上調整亮度的方法 10種在 Windows 11 上調整亮度的方法 Dec 18, 2023 pm 02:21 PM

10種在 Windows 11 上調整亮度的方法

See all articles