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

Insert Failing.
Hey,
I am making a Sign up page for a website, but the insert query into the Database does not se

my sql select id and then update problem.
I need to select some auto incremented ids out of a database and then use those id in a where statem

same querie, or a new one??
Hi guys,

I'm still working on this drop down list. I've got the actual drop down list to wor

Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in th

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

array_map() probably obvious mistake
The code below is part of a class to escape strings, but should also accept an array, using array_ma

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Conditions of info record - Error
When i created GR (901) and PO create automatic my PBXX is obtain the net price of info record but

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Simple code help with redirects
I am trying to figure out a redirect script that detects if the browser is IE 7 and if it does, redi