저번에 올렸던 db의 테이블을 검색하여 컬럼명과 데이터를 뽑아 왔던 것의 수정본으로써 검색된 table에 insert/update/delete 를 바로 할 수 있도록 만들어 놨다.
dbsearch.php
<meta charset="utf-8">
<?
include "../include/dbcon.php";
include "../include/script.php";
$search=$_POST[search];
$tn=$_GET[tn];
if($search){
$column_name=array();
$ret=mysql_query("desc $search");
while($rows=mysql_fetch_array($ret)){
$column_name[]=$rows[0];
}
$column_data=array();
$ret=mysql_query("select * from $search");
while($rows=mysql_fetch_array($ret)){
for($i=0;$i<count($column_name);$i++){
$column_data[]=$rows[$i];
}
}
}
?>
<script>
function fn_s(){
var f=document.frm;
f.gab.value=f.search.value;
f.action="dbsearch.php";
f.submit();
}
function fn_change(){
var f=document.frm;
if(f.query.value=="i"){
f.querySet.value="insert into "+f.tn.value+"( ) values ( );";
}else if(f.query.value=="u"){
f.querySet.value="update "+f.tn.value+" set"+" where ;";
}else if(f.query.value=="d"){
f.querySet.value="delete from "+f.tn.value+" where ;";
}
}
function fn_queryExe(){
var f=document.frm;
f.queryExe.value=f.querySet.value;
f.action="dbsearch_query.php";
f.submit();
}
</script>
<body>
<table>
<form name="frm" method="post" action="">
<input type="hidden" name="gab" value="">
<input type="hidden" name="queryExe" value="">
<tr>
<td>table search</td>
<td>
<input type="text" name="search">
<input type="button" value="search" onClick="fn_s()">
</td>
</tr>
<tr>
<td>query</td>
</tr>
<tr>
<td><input type="text" name="tn" value="<?=$search?>"></td>
<td><select name="query" onChange="fn_change()">
<option value="">==choice==</option>
<option value="i">insert</option>
<option value="u">update</option>
<option value="d">delete</option>
<option value=""></option>
</select>
</td>
<td ><input type="text" name="querySet" size="50">
<input type="button" value="query apply" onClick="fn_queryExe()">
</td>
</tr>
</table>
<hr/>
<table border="1">
<tr>
<?for($i=0;$i<count($column_name);$i++){?>
<td bgcolor="#ffcc00" align="center">
<?=$column_name[$i]?>
</td>
<?}?>
</tr>
<tr>
<?for($j=1;$j<=count($column_data);$j++){?>
<td><?=$column_data[$j-1]?></td>
<?if($j%(count($column_name))==0){
?>
</tr><tr>
<?}}?>
</tr>
</table>
</form>
</body>
dbsearch_query.php
<?
include "../include/dbcon.php";
include "../include/script.php";
$sql=$_POST[queryExe];
$ret=mysql_query($sql);
if($ret){
?>
<script>
alert('query apply!!.');
location.href='dbsearch.php';
</script>
<?}else{
error_msg('query fail T T');
exit;
}
?>
'IT > 개발' 카테고리의 다른 글
| 프레임워크 어떻게 돌아가는가? (2) | 2015.10.27 |
|---|---|
| 전자정부프레임워크 설치/설정 방법 (0) | 2015.10.26 |
| JAVA 돌아라..돌아라..for문/반복문(두뇌 풀가동! 구구단) (0) | 2015.10.23 |
| JAVA 만약에..내가...if문. 선택해!!! 나를 선택라고!! switch문 (0) | 2015.10.23 |
| JAVA 1차원 배열/2차원 배열 간단한 예제 (0) | 2015.10.23 |
댓글