Multiple pages...

Anon

Hey. Just for the record, I've searched all through the site for a solution to this, but nothing suited what I needed... 😉

This is the code that pulls the article out of MySQL and displays it:

<?
if (!$articleID) { # show the message
print "\nPlease select which article you want to view from the right";
} else { # show this article
$sql = "
SELECT
a.title as title,
a.uid as uid,
a.content as content,
a.date as date
FROM
articles a
LEFT OUTER JOIN
articleSections arts
ON
a.articleSectionID = arts.articleSectionID
WHERE
articleID = '" . $articleID . "'
AND
arts.name = '" . $article_type . "'";
$res = mysql_query($sql) or mysql_die();
while ($article = mysql_fetch_array($res)) {
print "\n" . stripslashes($article["title"]) . " ";
$user_deets = get_user_deets($article["uid"]);
print "\n Published on " . $article["date"] . " by <a class=\"link\" href=\"mailto:" . $user_deets["email"] . "\">" . $user_deets["display_name"] . "</a>";
print "\n" . stripslashes(nl2br($article["content"])) . "";

                    print "\n<span class=\"whiteheader\"><a class=\"whiteheader\" href=\"/\">Home</a> &gt;&gt; <a class=\"whiteheader\" href=\"/articles/\">Articles</a></span>";
            }
    }

    ?>

Now, I want it to be able to look in the text of the article it just pulled out, and look for this certain phrase(or some similar keyword): "[PAGEBREAK]" Everytime it finds that, it will split everything after it into a new page.(And link to it) I'm guessing it would have to divy up the article into an array or something. But I know absolutely no PHP... so I'm kinda lost.

If anyone could show me what the code should be to accomplish this, I'd be very grateful. Thanks!

Anon

for one example:

$limit = 30 ;
$query = "select * from $table desc limit $page,$limit";

it means 30 lines a page

Anon

Thanks. But I doubt that would be a good solution for me. Since I'm going to have quite a bit of HTML in the text... I guess it would count the HTML as lines, eh?

Anon

I got it to limit the results...
But now how do I get it to continue on the next page and display a link.... ex. page1, page2??

Thanks in advance

Anon

cool... figured it out... thanks

Anon

good

peprice

Care to share it with us? I'm tring to write a system like you're describing and some info on how you managed it would be great.

Thanks,
Peter.

Anon

what do you want to do with the system ,

alter,delete,add and others?

Anon

Heres a stripped down version of what I came up with and some added options.. and functions... Hope it helps.. It taught me alot

If anyone knows a more efficient way, please tell me

<?php

// create connection
$connection = mysql_connect(\"localhost\",\"user\",\"pass\")
or die(\"Couldn\'t make connection.\");

// select database
$db = mysql_select_db(\"your_db\", $connection)
or die(\"Couldn\'t select database.\");

// $search is your passed variable
$sql = \"SELECT * FROM table_name WHERE field_name LIKE \'%$search%\'\";

$sql_result = mysql_query($sql,$connection)
or die(\"Couldn\'t execute query.\");

$stmt = mysql_query (\"SELECT * FROM table_name WHERE field_name LIKE \'%$search%\'\");

$limit=5;

$numrows=mysql_num_rows($stmt);

// Format however
$countresults = (\"Current Search: $search Number of Results: $numrows. Page Results>> \");
echo \"$countresults\";

if (empty($offset) || $offset < 0)
{
$offset = 0;
}

$NumOfPages = intval($numrows/$limit);

if ($numrows%$limit)
{
$NumOfPages++;
}

$sql_result = mysql_query (\"SELECT * FROM table_name WHERE field_name LIKE \'%$search%\' LIMIT $offset,$limit\");

for ($pagenumber = 1; $pagenumber <= $NumOfPages; ++$pagenumber)
{
$offset = $limit * ($pagenumber - 1);

echo (\"<a href=\\"$PHP_SELF?offset=$offset\\">$pagenumber</a> \");
}

// results

echo \" \";

//color format for everyother row
$setcolor = 0;
while ($row = mysql_fetch_array($sql_result))
{
if($setcolor == 0)
{
$bgcolor = \"#ffffff\";
$setcolor = 1;
} else {
$bgcolor = \"#006699\";
$setcolor = 0;
}

$fields = $row[\"fields\"];
$lalalla = $row[\"lallala\"];

//option if pic1 = 0 then replace with default pic
if ($row[\"pic1\"] == \"\")
{
$thumbnail = \"default.jpg\";

}

// format however

echo \"$results

\";
}

// free resources and close connection
mysql_free_result($sql_result);
mysql_close($connection);