[ Поиск ] - [ Пользователи ] - [ Календарь ]
Полная Версия: Вывод разных записей
Форум PHP программистов > PHP для начинающих
Страницы: 1, 2
inpost
13.04.2013 - 01:36
		$id = $row['id'];
		$title = $row['title'];
		$main = array("title" => $title,"id" => $id);

Великолепное решение. А ты не подозревал, что $row - этот же самый массив :)

_____________
Обучаю веб-программированию качественно и не дорого: http://school-php.com
Фрилансер, принимаю заказы: PHP, JS, AS (видео-чаты). Писать в ЛС (Личные сообщения на phpforum).
olimpset
13.04.2013 - 10:08
Да я знаю что то массив, нот я немного по-другому сделал и все равно работает.
olimpset
17.04.2013 - 22:23
Прошло много времени, я думал как сделать и додумался...
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta content="true" name="mssmarttagspreventparsing" />
	<meta http-equiv="imagetoolbar" content="no" />
	<meta http-equiv="Content-Type" content="text/html; charset=cp1251" />
	<title>Urbanism :: DryIcons Free Template</title>
	<link href="templates/urbanism/css/style.css" rel="stylesheet" type="text/css" />
	<!-- IE fixes -->
	<!--[if lte IE 6]>
	<style type="text/css">
		.side_link, .previous, .next {_height:25px;}
		span.next, span.previous {filter: alpha(opacity=50);}
		.urbanism_logo {margin:75px 0px 0 0px;}
		#title_home{margin-top:25px;}
		#title_graphics{margin-top:35px;}
		#title_articles{margin-top:20px;}
		#title_contact{margin-top:25px;}
		#title_rss{margin-top:17px;}
	</style>
	<![endif]-->
	<script type="text/javascript">
	// Javascript:
	// --= Value setter for the search input:
	function clS(t){
		var srch = document.getElementById('s'), val = srch.value.toString().toLowerCase(), re = /^\s+$/;
		if(t) {
			if(val == 'search...' || val == 'search'){
				srch.value = '';
			}
		} else {
			if(val == 'search...' || val == 'search' || val == '' || re.test(val)) {
				srch.value = 'Search...';
			}
		}
	}
	</script>
</head>
<body>
<!-- BEGIN Wrapper -->
<div id="cnt">
	<!-- BEGIN Header -->
	<div id="header">
		<div class="urbanism_logo"><a href="#"></a></div>
		<!-- BEGIN Main Menu -->
		<div id="menu">
			<!-- ::Main Menu Item -->
			<dl id="title_home" class="menu_home">
				<dt class="menu_tit"><span>Home</span></dt>
				<dd><a class="mlink" href="index.html"></a></dd>
			</dl>

			<!-- ::Main Menu Item -->
			<dl id="title_graphics" class="menu_graphics">

				<dt class="menu_tit"><span>Graphics</span></dt>
				<dd><a class="mlink" href="article.html"></a></dd>
			</dl>
			<dl id="title_articles" class="menu_articles">
				<dt class="menu_tit"><span>Articles</span></dt>
				<dd><a class="mlink" href="index.html"></a></dd>
			</dl>

			<!-- ::Main Menu Item -->
			<dl id="title_contact" class=menu_contact>

				<dt class="menu_tit"><span>Contact</span></dt>
				<dd><a class="mlink" href="contact.html"></a></dd>
			</dl>

			<!-- ::Main Menu Item RSS Feed -->
			<dl id="title_rss">
				<dd><a class="menu_rss" href="#"></a></dd>
			</dl>

			<!-- BEGIN Search Form -->
			<div id="search">
				<form id="search_form" action="" method="get">
					<input class="search_field" type="text" value="Search..."  name="s" id="s" onfocus="clS(1);" onblur="clS(0);" />
					<input class="search_button" type="submit"  value="" id="searchsubmit" />
				</form>
			</div>
			<!-- END Search Form -->
		</div>
		<!-- END Main Menu -->
	</div>
	<!-- END Header -->

	<!-- BEGIN Main Container -->
        <div id="content">

		<!-- BEGIN Left Column Container -->
		<div id="lcont">
		<?php all_zapisi() ?>
		<div class="post">
				<!-- BEGIN item's title -->
				<a href="post.php?id=<?=$id?>" class="post_title"><?php foreach($main as $arr)
		{
			if(mb_strlen($main['title']) > 100)
  {
  	global $title;
  	$title = mb_substr($main['title'],0,100);
  	echo $title.'<br/>';
  	}
  	else
  	{
  		global $title;
  		 $title = $main['title'];
  		 echo $title.'<br/>';
  		 break;
  		}
  		}
  		?></a>
				<!-- BEGIN item's info: date, author... -->
				<span class="date">February 28th, 2009 Posted by: designer, 20 comments</span>

				<!-- BEGIN item's content -->
				<p><a href="#"><img border="0" alt="Logo design tutorial by DryIcons" src="templates/urbanism/images/tutorial_index.jpg"/></a></p>

				<p><?php foreach($main as $arr)
  		{
  		if(mb_strlen($main['news']) > 350)
  		{
  			global $news;
  			$news = mb_substr($main['news'],0,350);
  			echo $news.'<br/>';
  			}
  			else
  			{
  				global $news;
  				$news = $main['news'];
  				echo $news.'<br />';
  				break;
  				}
				}?></p>
				<br class="clr"/>
				<!-- Read More button -->
				<div class="read_post"><a href="post.php?id=<?=$id?>">Подробнее...</a></div>
				<hr/>
			</div>
			<?php foreach($main as $arr)
			{
				$id = $main['id'];
				$sql = mysql_query("SELECT COUNT(*) FROM zapisi WHERE id <> '$id'");
				$row = mysql_fetch_row($sql);
				$sql_res = mysql_query("SELECT * FROM zapisi WHERE id <> '$id'");
				$row_res = mysql_fetch_array($sql_res);
				$total = $row[0];
				for($a=0; $a<$total; $a++)
				{
					$pr = mysql_query("SELECT * FROM zapisi WHERE id <> '$id'");
					while($pr_row = mysql_fetch_array($pr))
					{
					if(!empty($pr_row['id']))
					{
					global $id_1;
					$id_1 = $pr_row['id'];
					global $title_1;
					$title_1 = $pr_row['title'];
					global $news_1;
					$news_1 = $pr_row['news'];
					include 'add.php';
					}
						}
						break;
						}
						break;
						}
				 ?>

			<!-- BEGIN Pagination -->
			<div id="pagination">
				<span class="previous"> </span>
				<span class="pag_num_activ">1</span>
				<a href="#page-2-goes-here" class="pag_num">2</a>
				<a href="#page-3-goes-here" class="pag_num">3</a>
				<a href="#page-4-goes-here" class="pag_num">4</a>
				<a href="#page-5-goes-here" class="pag_num">5</a>
				<a href="#page-2-is-next" class="next"></a>
			</div>
			<!-- END Pagination -->
		</div>
		<!-- END Left Column Container -->

		<!-- BEGIN Right Column Container a.k.a. Sidebar -->
		<div id="rcont">
			<!-- BEGIN Sidebar Categories -->
			<h3 class="category">Categories</h3>
			<div id="categories">
				<a class="side_link" href="#">Free Icons</a>
				<a class="side_link" href="#">Custom Icons</a>
				<a class="side_link" href="#">Vector Graphics</a>
				<a class="side_link" href="#">Blog</a>
				<a class="side_link" href="#">Free Templates</a>
			</div>
			<!-- BEGIN Sidebar Categories -->

			<!-- BEGIN Sidebar Sponsors -->
			<h3 class="category">Our Sponsors</h3>
			<div class="sponsor">
				<a href="/advertise/"><img src="templates/urbanism/images/advertise_here.jpg" width="200" height="100" alt="Advertise here" /></a>
				<a href="/advertise/"><img src="templates/urbanism/images/advertise_here.jpg" width="200" height="100" alt="Advertise here" /></a>
			</div>
			<!-- END Sidebar Sponsors -->

			<!-- BEGIN Sidebar Recent Posts -->
			<h3 class="category">Recent Posts</h3>
			<div id="side_posts">
				<a class="side_link" href="#">Logo Design Process Tutorial</a>
				<a class="side_link" href="#">Great use of pop music in great films</a>
				<a class="side_link" href="#">Icon design tutorial: How to make a Calendar icon</a>
				<a class="side_link" href="#">DryIcons.com 2.0</a>
				<a class="side_link" href="#">1st Anniversary and Graphics Giveaway Winners</a>
			</div>
			<!-- END Sidebar Recent Posts -->


			<!-- BEGIN Sidebar Recent Comments -->
			<h3 class="category">Recent Comments</h3>
			<div id="side_comments">
				<a class="side_link" href="#">Coder Says:<br />No problem!</a>
				<a class="side_link" href="#">Designer Says:<br />Thanks Coder.</a>
				<a class="side_link" href="#">PF Says:<br />Keep talking!</a>
				<a class="side_link" href="#">RH Says:<br />Paranoid Android</a>
			</div>
			<!-- END Sidebar Recent Comments -->
		</div>
		<!-- END Right Column Container -->
	</div>
	<!-- END Main Container -->

	<!-- BEGIN Footer -->
	<div id="footer">
		<div id="lfoo">
			<div id="llfoo">
				<div id="about_photo"><div class="about_frame"></div></div>
			</div>

			<div id="rlfoo">
				<div id="about_text">
					<h3>About me</h3>
					<div class="about_hr"><hr /></div>
					<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer faucibus nunc vel orci. Proin ante quam, porta sit amet, semper eu, vulputate ut, quam. Nunc facilisis iaculis elit. Aliquam suscipit elit in urna. Aenean tellus mauris, vehicula vitae, lobortis nec, porttitor non, sapien. Donec metus pede, scelerisque in, sodales ac, viverra a, risus. Aliquam erat volutpat. Duis eget tellus vitae libero suscipit rutrum. Suspendisse lobortis.</p>
				</div>
			</div>
		</div>

		<div id="rfoo">
			<!-- BEGIN Twitter -->
			<div id="twitter_logo"></div>
			<div class="twitter_hr"><hr /></div>
			<div id="twitter_text">
				<p>
				<span>@ Mon 27 Apr 2009 20:15</span>
				Great day for freedom:
				<a class="twitter_link" href="http://dryicons.com/free-graphics/preview/thank-you-card/" target="_blank">Thank you card</a>
				</p>
				<p>
					<span>@ Sat 24 Apr 2009 08:43</span>
					Flowery background: Vector Graphic
					<a class="twitter_link" href="http://dryicons.com/free-graphics/preview/flowery-background/" target="_blank">Flowery background</a>
				</p>
			</div>
			<div id="twitter_follow"><a href="http://twitter.com/dryicons" target="_blank"></a></div>
			<!-- END Twitter -->
		</div>

		<!-- DryIcons credit: Do not remove the following code if you are using this template under the DryIcons Free License Terms of Use
		     If you'd like to use this theme without the obligatory back-link to http://dryicons.com/ please
		     consider using it under the DryIcons Commercial License Terms
		     For details see http://dryicons.com/terms/ -->
		<div id="bfoo">
			<div id="foo_copy"><p>©2009 Urbanism. All rights reserved.</p></div>
			<div id="foo_dry"><a href="http://dryicons.com" target="_blank">Free Template and Icons by DryIcons.com</a></div>
			<div id="foo_badge"><a href="http://dryicons.com" target="_blank"></a></div>
		</div>
	</div>
	<!-- END Footer -->
</div>
<!-- END Wrapper -->
</body>
</html>


function.php
function all_zapisi()
{
	$sql = mysql_query("SELECT * FROM zapisi");
	while($row = mysql_fetch_array($sql))
	{
		global $id;
		$id = $row['id'];
		$news = $row['news'];
		$title = $row['title'];
		global $main;
		$main = array('title' => $title,'id' => $id,'news' => $news);
		}
						}

Так мне получилось в HTML двумя переменными все записи выводить, а как теперь спрятать из HTML такой большой foreach ?
Быстрый ответ:
Powered by dgreen

 Графические смайлики |  Показывать подпись
Здесь расположена полная версия этой страницы.
Invision Power Board © 2001-2024 Invision Power Services, Inc.