PHP loop

Posted on 16th Feb 2014 07:03 pm by admin

Okay so I have several "articles" stored in a mysql database and am attempting to echo those onto a PHP page.
so on index.php I have
Code: <?php article_layout();?> (yes there is a require one to get the function but that works)

then page_layout is this
Code: <?php
function article_layout(){
$uri = $_GET['uri'];
if($uri == ""){
$uri = "home";
} else {
$uri = $uri;
};
$mysqli = db_connect();
$qry = "SELECT * FROM `articles` WHERE `uri`='$uri'";
$result = $mysqli->query($qry, MYSQLI_STORE_RESULT);
while ($row = mysqli_fetch_array($result)){
$layout = $row['layout'];
require_once('http://'.$_SERVER['HTTP_HOST'].'/themes/default/layouts/'.$layout.'.php?uri='.$uri.'');
};
};?>
which calls the relevant layout page (so the contents it layed out correctly)
now my problem is how to make this cope with more than one article, so far it is only display one article even if it should be display two. Any ideas?

Your Answer:

Login to answer

Other forums

Unifying logins of two different scripts
I have two different game scripts which I want to embed on my own site. The problem is I don't want

Help a newbee save my job !
Hey guys i am dying here i am new to php and would like for someone to help me with this problem

Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

dynamic table with forms
I have a table that is populated with mysql data and in teh first column there is a raido button tha

Email/MMS to Site
Hey guys. I'm looking for a way for a user to upload images and/or text via their cell phones. It

how to make database item unique
Hey guys,

is it possible to do this:

I have the database item $title being pulled for

timed header image rotation
I have a joomla site and I was trying to setup a rotating image based on timing NOT just refreshing

help removing unwanted graphic
How do I remove the small elongated rectangular shape between the "Latest post" and "

Performance impact of cookies
Hi, I was just wondering what impact there would be in terms of performance if you where to set then