PHP网络开发详解：文章类别管理页面的实现[3]-php-IT落伍者

——此文章摘自《完全手册PHP网络开发详解》定价￥特价￥详细>>http://tracklinktechcn/?m_id=dangdang&a_id=A&l=&l_type= width= height= border= nosave>

//同时删除articles表中的相应记录

$deleteSQL = sprintf(DELETE FROM articles WHERE type_id=%s

GetSQLValueString($_GET[MM_delete] int));

mysql_select_db($database_conn $conn);

$Result = mysql_query($deleteSQL $conn) or die(mysql_error());

echo <script>alert(类别删除成功！);</script>;

}

//定义用于记录更新的结果集

if (isset($_GET[type_id]))

{

mysql_select_db($database_conn $conn);

$query_rs_upt_type = sprintf(SELECT * FROM types WHERE type_id = %s

$_GET[type_id]);

$rs_upt_type = mysql_query($query_rs_upt_type $conn) or die(mysql_error());

$row_rs_upt_type = mysql_fetch_assoc($rs_upt_type);

$totalRows_rs_upt_type = mysql_num_rows($rs_upt_type);

$row_rs_upt_type_id = $row_rs_upt_type[type_id];

$row_rs_upt_type_name = $row_rs_upt_type[type_name];

}

//定义用于类别列表的结果集

mysql_select_db($database_conn $conn);

$query_rs_all_types = SELECT * FROM types ORDER BY type_id ASC;

$rs_all_types = mysql_query($query_rs_all_types $conn) or die(mysql_error());

$row_rs_all_types = mysql_fetch_assoc($rs_all_types);

$totalRows_rs_all_types = mysql_num_rows($rs_all_types);

<!DOCTYPE HTML PUBLIC //WC//DTD HTML Transitional//EN http://

wwwworg/TR/html/loosedtd>

<html>

<head>

<title>Untitled Document</title>

style {

fontsize: px;

fontweight: bold;

}

style {fontsize: px}

</style>

</head>

[http://developcsaicn/web/htm>] [http://developcsaicn/web/htm>] [] [http://developcsaicn/web/htm>] [http://developcsaicn/web/htm>]