Online-Bookmarks Forum
Talk about Online-Bookmarks
Back to Homepage
You are not logged in.
Announcement
#1 2010-04-02 16:44:28
- webgid
- Member
- Registered: 2010-01-13
- Posts: 21
help make bookmarks by page
help make sql query
to display bookmarks by page
I found a library http://www.tigir.com/scripts/paging.inc.php
and explain to her http://www.tigir.com/paging.htm#php_paging_class
but was unable to understand
Last edited by webgid (2010-04-02 16:46:05)
Offline
#3 2010-04-05 20:10:14
- webgid
- Member
- Registered: 2010-01-13
- Posts: 21
Re: help make bookmarks by page
I wanted to ask to withdraw as a page at a bookmark. For example, 10 bookmarks per page: 1 2 3 4 ... 20
And as an example, led a class in php URL.
Maybe you where you have such a function to break down the information on the page, but only in its simplest form, that I was able to use it?
Example,
Code:
$cid=@mysql_connect($dsn['hostspec'], $dsn['username'], $dsn['password']) or die (mysql_error ());
mysql_select_db($dsn['database']) or die (mysql_error ());
$query = "SELECT * FROM bookmark WHERE UPPER(title) LIKE '%".strtoupper($_POST['q'])."%'";
$result = mysql_query($query) or die("error");
print "<table style=\"margin:8px; padding:5px;\">\n";
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
print "\t<tr>\n";
for ($i=1;$i<=4;$i++) { print "\t\t<td>$line[$i]</td>\n"; }
print "\t</tr>\n";
}
print "</table>\n";
mysql_free_result($result);everything is fine, displays bookmarks in a simple form ..
but there are too many and the page opens a very long time ..
so I want to ask how you can split (divided)
them on the page ..
Not sure that you understand me .. 
Offline