简明现代魔法 -> PHP服务器脚本 -> 配合数据库索引的简单PHP使用代码

配合数据库索引的简单PHP使用代码

2010-05-19

article 表中的字段 article_favor 是索引字段，可以通过用户表中的 user 与之比较，如果相同，则将 article 表中的字段 article_favor 保存成数组。这是函数 getUserFavor($user) 的功能。

接下来调用 getUserFavor($user) 函数，生成的数组作为参数传入 dispalyUserFavor($array) 函数，生成最终需要显示给用户的数据。

<?php

$user = $_SESSION['nowamagic_user'];
$display = getUserFavor($user);
$display_name = dispalyUserFavor($display);
$display_id = dispalyUserFavorId($display);
//print_r($display2);

function getUserFavor($user) 
{
	require("./dbinfo.php");

	$connection = mysql_connect ($host, $username, $password);
	if (!$connection) 
	{
  		die('连接数据库失败 : ' . mysql_error());
	}
	
	$db_selected = mysql_select_db($database, $connection);
	if (!$db_selected) 
	{
  		die ('无法使用数据库: ' . mysql_error());
	}
	
	$query = "select article_favor from article where user_name = '".$user."'";
	//echo $query.'<br />';
	$result = mysql_query($query, $connection) or die(mysql_error());
	
	$favorArray = array();
	
	for($count = 1; $row = mysql_fetch_array($result); ++$count )
	{
		$favorArray[$count] = $row[0];
	}
	
	return $favorArray;
	
}

//$array = array('1', '2');
function dispalyUserFavor($array) 
{
	require("./dbinfo.php");
	$total = count($array);
	//echo $total;
	$favorArray = array();
	
	$connection = mysql_connect ($host, $username, $password);
	if (!$connection) 
	{
  		die('连接数据库失败 : ' . mysql_error());
	}
	
	$db_selected = mysql_select_db($database, $connection);
	if (!$db_selected) 
	{
  		die ('无法使用数据库: ' . mysql_error());
	}
	
	
	for($count = 1; $count <= $total; $count++ )
	{
		$query = "select nowamagic_name from nowamagic where nowamagic_id = '".$array[$count]."'";
		//echo $query.'<br />';
		$result = mysql_query($query, $connection) or die(mysql_error());
		$row = mysql_fetch_array($result);
		$favorArray[$count] = $row[0];
		//echo $favorArray[$count].'<br />';
	}
	
	
	return $favorArray;
}

function dispalyUserFavorId($array) 
{
	require("./dbinfo.php");
	$total = count($array);
	//echo $total;
	$favorArray = array();
	
	$connection = mysql_connect ($host, $username, $password);
	if (!$connection) 
	{
  		die('连接数据库失败 : ' . mysql_error());
	}
	
	$db_selected = mysql_select_db($database, $connection);
	if (!$db_selected) 
	{
  		die ('无法使用数据库: ' . mysql_error());
	}
	
	
	for($count = 1; $count <= $total; $count++ )
	{
		$query = "select nowamagic_id from nowamagic where nowamagic_id = '".$array[$count]."'";
		//echo $query.'<br />';
		$result = mysql_query($query, $connection) or die(mysql_error());
		$row = mysql_fetch_array($result);
		$favorArray[$count] = $row[0];
		//echo $favorArray[$count].'<br />';
	}
	
	
	return $favorArray;
}


?>

下面是通过循环输出结果数据：

<table width="95%" border="0" align="center" class="favortable"> 
  <tr>
    <th>收藏的商家</th>
    <th>删除</th>
  </tr>

<?php
//print_r($display2);
$long = count($display_name);
//echo $long.'<br />';
for ($i = 1; $i <= $long; $i++)
{
?>
	<tr>
    	<td><a href="companyDetail.php?im_id=<?=$display_id[$i]?>" target="_blank"><?=$display_name[$i]?></a></td>
    	<td><a href="#">删除</a></td>
  	</tr>
<?php
}
?>

</table>