21,886
社区成员
发帖
与我相关
我的任务
分享
function display_user_urls($url_array)
{
if(is_array($url_array) && count($url_array) > 0)
{
echo "<p>我的所有收藏</p>";
echo "<form>";// name='bm_table' action='../delete_bms.php' method='post'>";
echo "<table ><tr><th>收藏名称</th><th>收 藏</th><th>操作</th><th>选 择</th></tr>";
foreach($url_array as $url)
{
//$db = db_connect( );
@$db = new mysqli('localhost', 'ellizzu', '1234', 'bookmark');
if(mysqli_connect_errno())
{
echo "数据库连接失败";
exit;
}
$query = "select name from bookmark where username='".addslashes($_SESSION['current_user'])."' and url='".addslashes($url)."'";
$result = $db->query($query);
if(!$result)
{
echo "向数据库查询名称失败";
exit;
}
$row = $result->fetch_array( );
$bm_name = stripslashes($row[0]);
echo "<tr><td align='center'>".$bm_name."</td>";
echo "<td><a href='".htmlspecialchars($url)."'>".$url."</a></td>";
echo "<td><a href='../modify_bm.php?bm_name=".$bm_name."&url=".$url."'>修改</a></td>";
echo "<td align='center'><input type='checkbox' name='del[]' value='".$bm_name."' /></td></tr>";//checkbox部分
}
echo "<tr><td><input type='submit' value='删除所选' onClick='delBm()'/></td></tr>";//调用js
echo "</table></form>";
echo "<div id='delresult'></div>";
}
else
{
echo "<p>您还未添加任何书签</p>";
}
}
function delBm() {
var url = "../delete_bms.php";
url = url+ "?del=" + document.getElementsByName('del[]').value;
myReq = getXMLHTTPRequest();
myReq.onreadystatechange = showDelResponse;
myReq.open("GET",url,true)
myReq.send(null);
}
function showDelResponse( )
{
if (myReq.readyState == 4 || myReq.readyState=="complete")
{
result = myReq.responseText;
document.getElementById('delresult').innerHTML = result;
}
}