PHP操作数据库时自动创建字段,如下代码:
<ol class="dp-xml"> <li class="alt"><span><span class="tag"><span class="tag-name">html</span><span class="tag">></span><span> </span></span></span></li> <li><span><span class="tag"><span class="tag-name">head</span><span class="tag">></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">/></span><span> </span></span></span></li> <li><span><span class="tag"><span class="tag-name">title</span><span class="tag">></span><span>动态创建字段 - www.cxybl.com</span><span class="tag"></span><span class="tag-name">title</span><span class="tag">></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">></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">></span><span> </span></span></li> <li><span><span class="tag"></span><span class="tag-name">head</span><span class="tag">></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">></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">></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">></span><span> </span></span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">tr</span><span class="tag">></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">></span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></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">></span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li><span> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">tr</span><span class="tag">></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">></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">></span><span>选择表 </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></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">></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">/></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></span></li> <li><span> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">tr</span><span class="tag">></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">></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">></span><span>字段 </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></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">></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">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></span></li> <li><span> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">tr</span><span class="tag">></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">></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">></span><span>类型 </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></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">></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">></span><span> </span></span></span></span></li> <li><span> <span class="tag"><span class="tag-name">option</span><span class="tag">></span><span>int</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">option</span><span class="tag">></span><span>text</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">></span><span> </span></span></span></li> <li><span> <span class="tag"><span class="tag-name">option</span><span class="tag">></span><span>date</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">option</span><span class="tag">></span><span>double</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">></span><span> </span></span></span></li> <li><span> <span class="tag"><span class="tag-name">option</span><span class="tag">></span><span>varchar</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">option</span><span class="tag">></span><span>datetime</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">></span><span> </span></span></span></li> <li><span> <span class="tag"><span class="tag-name">option</span><span class="tag">></span><span>blob</span><span class="tag"></span><span class="tag-name">option</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span> <span class="tag"></span><span class="tag-name">select</span><span class="tag">></span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></li> <li><span> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">tr</span><span class="tag">></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">></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">></span><span>长度 </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></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">></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">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></span></li> <li><span> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span> <span class="tag"><span class="tag-name">tr</span><span class="tag">></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">></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">></span><span>NULL </span><span class="tag"></span><span class="tag-name">span</span><span class="tag">></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></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">></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">></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">></span><span> </span></span></span></li> <li><span> not null <span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li><span> <span class="tag"><span class="tag-name">tr</span><span class="tag">></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">></span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li><span> <span class="tag"><span class="tag-name">td</span><span class="tag">></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">/></span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></span></li> <li class="alt"><span> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li><span> <span class="tag"><span class="tag-name">tr</span><span class="tag">></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">></span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li><span> <span class="tag"><span class="tag-name">td</span><span class="tag">></span><span> </span><span class="tag"></span><span class="tag-name">td</span><span class="tag">></span><span> </span></span></span></li> <li class="alt"><span> <span class="tag"></span><span class="tag-name">tr</span><span class="tag">></span><span> </span></span></li> <li><span> <span class="tag"></span><span class="tag-name">table</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span><span class="tag"></span><span class="tag-name">form</span><span class="tag">></span><span> </span></span></li> <li><span><span class="tag"></span><span class="tag-name">body</span><span class="tag">></span><span> </span></span></li> <li class="alt"><span><span class="tag"></span><span class="tag-name">html</span><span class="tag">></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>?> </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>?> </span></li> </ol>
성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.

핫 AI 도구

Undresser.AI Undress
사실적인 누드 사진을 만들기 위한 AI 기반 앱

AI Clothes Remover
사진에서 옷을 제거하는 온라인 AI 도구입니다.

Undress AI Tool
무료로 이미지를 벗다

Clothoff.io
AI 옷 제거제

AI Hentai Generator
AI Hentai를 무료로 생성하십시오.

인기 기사
R.E.P.O. 에너지 결정과 그들이하는 일 (노란색 크리스탈)
3 몇 주 전By尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. 최고의 그래픽 설정
3 몇 주 전By尊渡假赌尊渡假赌尊渡假赌
어 ass 신 크리드 그림자 : 조개 수수께끼 솔루션
2 몇 주 전ByDDD
R.E.P.O. 아무도들을 수없는 경우 오디오를 수정하는 방법
3 몇 주 전By尊渡假赌尊渡假赌尊渡假赌
WWE 2K25 : Myrise에서 모든 것을 잠금 해제하는 방법
4 몇 주 전By尊渡假赌尊渡假赌尊渡假赌

뜨거운 도구

Atom Editor Mac 버전 다운로드
가장 인기 있는 오픈 소스 편집기

ZendStudio 13.5.1 맥
강력한 PHP 통합 개발 환경

SublimeText3 중국어 버전
중국어 버전, 사용하기 매우 쉽습니다.

WebStorm Mac 버전
유용한 JavaScript 개발 도구

VSCode Windows 64비트 다운로드
Microsoft에서 출시한 강력한 무료 IDE 편집기
