저번에 올렸던 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;
}
?>
'개발 > html,Thymeleaf' 카테고리의 다른 글
| 자바스크립트 이벤트 바인딩 (1) | 2016.05.30 |
|---|---|
| javascript 함수-1 (0) | 2016.01.14 |
| php mysql 테이블을 검색/컬럼 및 데이터 출력 (0) | 2015.10.22 |
| php maiil 전송/이메일 (0) | 2015.10.19 |
| php/html 회원가입 member.php (0) | 2015.10.16 |
댓글