コード例 #1
0
ファイル: LinksDAO.php プロジェクト: Ethennoob/Web
 /**
 *Retorna um registro da tabela directories definido pelo campo directory_id
 *
 *@param Links
 */
 function getInHomeLinks($link)
 {
     $strsql = "SELECT * FROM user_links WHERE user_id = " . $link->getUser_id() . " and in_home=1 order by rate desc";
     $result = $this->_db->databaseQuery($strsql);
     $linkList = array();
     for ($i = 0; $i < count($result); $i++) {
         $link = new Links();
         $link->setLink_id($result[$i]['link_id']);
         $link->setUser_id($result[$i]['user_id']);
         $link->setName($result[$i]['name']);
         $link->setUrl($result[$i]['url']);
         $link->setDescription($result[$i]['description']);
         $link->setInHome($result[$i]['in_home']);
         $link->setRate($result[$i]['rate']);
         array_push($linkList, $link);
     }
     return $linkList;
 }
コード例 #2
0
        $linkList = $link->removeLink();
        header("Location: myLinks.php");
        break;
    case "addInHome":
        $link = new Links();
        $link->setLink_id($cgi["linkId"]);
        $link->setUser_id($_COOKIE['userID']);
        $link->setInHome(1);
        $linkList = $link->addInHome();
        header("Location: myLinks.php");
        break;
    case "deleteFromHome":
        $link = new Links();
        $link->setLink_id($cgi["linkId"]);
        $link->setUser_id($_COOKIE['userID']);
        $link->setInHome(0);
        $linkList = $link->deleteFromHome();
        header("Location: myLinks.php");
        break;
}
ob_start("ob_gzhandler");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
	<head>
		<title>
			<?php 
echo $site['title'];
?>
		</title>