2017年1月20日 星期五

firebase刪除

hopetext  父節點
child(key) +-kal....子節點




刪除其中一筆資料
 db.child(key).remove();
<script src="https://cdn.firebase.com/js/client/2.4.2/firebase.js"></script>
<script language="javascript" src="jquery-3.1.1.min.js"></script>
<script language="javascript">
$(document).ready(function()
{
var str="";
var key="";
var f=false;
$("#qbt1").click(function()
{
var id=document.getElementById("t1").value;
if(id!="")
{
db=new Firebase( "https://hopetext-88e84.firebaseio.com");
db.on('value',function(data)
{
$.each(data.val(),function(k,v)
{
if (id==v.pid)
{
key=k;
str=str+v.pid+"&nbsp;&nbsp;"+v.pname+"&nbsp;&nbsp;"+v.pbirth+"&nbsp;&nbsp;"+v.pblood+"&nbsp;&nbsp;"+v.pschool+"<p>"
f=true;
}
})

  document.getElementById("dv1").innerHTML=str;
if (f==false)
{
alert("資料錯誤,請重新輸入");
document.getElementById("qbt1").focus();
}

});
}
else
{
alert("請輸入資料");
document.getElementById("qbt1").focus();
}

});
$("#dbt1").click(function()
{
if (key!="")
{
db=new Firebase( "https://hopetext-88e84.firebaseio.com");
db.child(key).remove;
alert("delete finished");
}
else
{
alert("確認資料是否正確?");
}
});
});
</script>
<body>
<center>
<form id="f1">
<table id="tb1" width="300" height="500" rules="none" background="bg7.jpg" >
<tr>
    <td width="300" align="right" >查詢編號
        <input type="text" id="t1" name="t1" size="20" /><br/>
        <input type="button" id="qbt1" name="qbt1"  value="查詢"  />
        </td>
    </tr>
<tr>
    <td ><div id="dv1" style="width:300px; height:500px; overflow:scroll; "></div></td>
    </tr>
    <tr>
    <td width="300" align="center" >
        <input type="button" id="dbt1" name="dbt1" value="刪除"  />
        </td>
    </tr>
  <tr>
    <td height="10" align="right" >
        <a href="dbpageform5.html">回首頁</a>
        </td>
    </tr>
</table>
</form>
</center>
</body>
</html>
=======================
修改

<script src="https://cdn.firebase.com/js/client/2.4.2/firebase.js"></script>
<script language="javascript" src="jquery-3.1.1.min.js"></script>
<script language="javascript">
$(document).ready(function()
{
var str="";
var id="";
var name="";
var birth="";
var blood="";
var school="";
var key="";
$("#qbt1").click(function()
{
var id=document.getElementById("t1").value;

db=new Firebase( "https://hopetext-88e84.firebaseio.com");
db.on('value',function(data)
{
$.each(data.val(),function(k,v)
{
if (id==v.pid)
{
key=k;
document.getElementById("t2").value=v.pid;
document.getElementById("t3").value=v.pname;
document.getElementById("t4").value=v.pbirth;
document.getElementById("t5").value=v.pblood;
document.getElementById("t6").value=v.pschool;
}

});
});

});
$("#mbt1").click(function()
{
//alert(key+id+name+birth+blood+schoo);
id=document.getElementById("t2").value;
name=document.getElementById("t3").value;
birth=document.getElementById("t4").value;
blood=document.getElementById("t5").value;
school=document.getElementById("t6").value;
if (key!=""&&id!=""&&name!=""&&birth!=""&&blood!=""&&school!="")
{
db=new Firebase( "https://hopetext-88e84.firebaseio.com");
db.child(key).set({pid:id,pname:name,pbirth:birth,pblood:blood,pschool:school});
alert("modify finished");
}
else
{
alert("資料錯誤");
}
})
});
</script>
<body>
<center>
<form id="f1">
<table id="tb1" width="300" height="500" rules="none" background="bg7.jpg" >
<tr>
    <td height="10" align="right" >查詢編號
        <input type="text" id="t1" name="t1" size="20" />
        <input type="button" id="qbt1" name="qbt1" value="查詢"  />
        </td>
    </tr>
<tr>
    <td >
        編號:<input type="text" id="t2" name="t2" size="30" /><p>
        姓名:<input type="text" id="t3" name="t3" size="30" /><p>
        生日:<input type="text" id="t4" name="t4" size="30" /><p>
        血型:<input type="text" id="t5" name="t5" size="30" /><p>
        學歷:<input type="text" id="t6" name="t6" size="30" /><p>
        </td>
    </tr>
    <tr>
    <td width="300" align="center" >
        <input type="button" id="mbt1" name="mbt1" style="width:300px" value="修改"  />
        </td>
    </tr>
  <tr>
    <td height="10" align="right" >
        <a href="dbpageform5.html">回首頁</a>
        </td>
    </tr>
</table>
</form>

沒有留言:

張貼留言