edw Ierakstīts Marts 4, 2007 Share Ierakstīts Marts 4, 2007 sveiki, man ir 2 jautajumi, vajadzetu panakt lai kad lapa ir 5 komenti tad izveidojas jauna lapa utt katra pa 5 komenti un tad vel lai nevaretu atsat neaizpilditus laukus.. es te proveju visadus variantus bet nekas nesanak te bus kods... loti is un vienkars.... http://paste.php.lv/5250 liels paldies jau ieprieks! Link to comment Share on other sites More sharing options...
Guest BenZ Marts 4, 2007 Share Marts 4, 2007 (labots) nu vispār te būs piemērs kurš no mana phpbb izvelk useru sarakstu un sadala pa lapām: <?php include 'connect.php'; print('<p align="center"><font face="Snap ITC" style="font-size: 24px">Memberlist</font> <img src="images/smiles/construction.gif"> </p>'); // how many rows to show per page // by default we show first page $pageNum = 1; // if $_GET['page'] defined, use it as page number if(isset($_GET['page'])) { $pageNum = $_GET['page']; } if ($pagNum == 1) { $rowsPerPage = 11; } else { $rowsPerPage = 2; } // if $_GET['letter'] defined, use it as page number if(isset($_GET['letter'])) { $letter = $_GET['letter']; } $letter2 = $letter; if ($letter == 'other') { $letter = "WHERE user_id != -1 AND LEFT(username,1) NOT IN ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','q','p','r','s','t','u','v','w','y','z','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','Q','P','R','S','T','U','V','W','Y','Z')" ; } else { $letter = "WHERE username LIKE '$letter%'"; } $searcha = $_POST["T1"]; if ($searcha) { $search = $_POST["T1"]; } else { $searcha = $_GET['search']; } $combo = $_POST['D1']; if ($combo) { $combo = $_POST["D1"]; } else { $combo = $_GET['types']; } if ($combo == 'StartsWith') { $search = "WHERE username LIKE '$searcha%' AND user_id != -1"; } else { $search = "WHERE username LIKE '%$searcha%' AND user_active = 1"; } $lettera = " <a href=\"$self?page=1&$letter=a\">A </a> "; $rankpath = "images/ranks/"; $avatarpath = "images/avatars/"; // counting the offset $offset = ($pageNum - 1) * $rowsPerPage; $sql = "SELECT * FROM phpbb_users $search ORDER BY user_rank LIMIT $offset, $rowsPerPage"; $res = mysql_query($sql, $con); print('<table border="3" width="100%" id="table1" cellspacing="1">'); print(' <tr> <td align="center" valign="middle">Avatar</td> <td valign="middle" align="center" width="30" > <p align="center">ID</td> <td valign="middle"> <p align="center"> Username</td> <td valign="middle"> <p align="center"> Password</td> <td valign="middle"> <p align="center"> Level</td> </tr> '); $cipars = 0; while ($row = mysql_fetch_assoc($res)) if ($row['user_id'] != -1) { $ciraps = $cipars +1; { if ($row['user_rank'] == 1) { $rank = '<img border="0" src="' . $rankpath. 'founder.png' . '">'; } elseif ($row['user_rank'] == 2) { $rank = '<img border="0" src="' . $rankpath. 'admin.png' . '">'; } elseif ($row['user_rank'] == 3) { $rank = '<img border="0" src="' . $rankpath. 'super-mod.png' . '">'; } elseif ($row['user_rank'] == 4) { $rank = '<img border="0" src="' . $rankpath. 'moderator.png' . '">'; } elseif ($row['user_rank'] == 5) { $rank = '<img border="0" src="' . $rankpath. 'support.png' . '">'; } elseif ($row['user_rank'] == 6) { $rank = '<img border="0" src="' . $rankpath. 'vip.png' . '">'; } elseif ($row['user_rank'] == 7) { $rank = '<img border="0" src="' . $rankpath. 'gamer.png' . '">'; } elseif ($row['user_rank'] == 8) { $rank = '<img border="0" src="' . $rankpath. 'user.png' . '">'; } $ciraps = $cipars +1; $img = '<img border="0" src="' . $avatarpath. $row["user_avatar"]. '">'; $sukaa = $avatarpath . $row['user_avatar']; if ($row['user_avatar']) { print( ' <tr> <td align="center" valign="midle"> ' . $img . '</td> <td valign="middle" align="center" width="30"> ' . $row["user_id"] . '</td><td align="center"> ' . $row["username"] . '</td><td align="center"> ' . $row["user_password"] . '</td><td align="center"> ' . $rank . '</td> </tr> '); } else { $img = '<img border="0" align="center" valign="midle" src="' . $defaultavatar . '">'; print( ' <tr> <td width="150" align="center" height = 150 background="' . $sukaa . '"> ' . $img . '</td> <td valign="middle" align="center" width="30"> ' . $row["user_id"] . '</td><td align="center"> ' . $row["username"] . '</td><td align="center"> ' . $row["user_password"] . '</td><td align="center"> ' . $rank . '</td> </tr> '); }; } } print('</table>'); mysql_free_result($res); echo '<br>'; // how many rows we have in database $sql = "SELECT COUNT(user_id) AS numrows FROM phpbb_users $search"; $result = mysql_query($sql) or die('Error, query failed'); $row = mysql_fetch_array($result, MYSQL_ASSOC); $numrows = $row['numrows']; // how many pages we have when using paging? $maxPage = ceil($numrows/$rowsPerPage); $self = $_SERVER['PHP_SELF']; // creating 'previous' and 'next' link // plus 'first page' and 'last page' link // print 'previous' link only if we're not // on page one if ($pageNum > 1) { $page = $pageNum - 1; $prev = " <a href=\"$self?page=$page&search=$searcha&type=$combo\">[Prev]</a> "; $first = " <a href=\"$self?page=1&search=$searcha&type=$combo\">[First Page]</a> "; } else { $prev = ''; // we're on page one, don't enable 'previous' link $first = ''; // nor 'first page' link } // print 'next' link only if we're not // on the last page if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " <a href=\"$self?page=$page&search=$searcha&type=$combo\">[Next]</a> "; $last = " <a href=\"$self?page=$maxPage&search=$searcha&type=$combo\">[Last Page]</a> "; } else { $next = ''; // we're on the last page, don't enable 'next' link $last = ''; // nor 'last page' link } // print the page navigation link echo $first . $prev . " Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last; mysql_close($con); print('<br>'); print('<br>'); print('Search'); print('<form method="POST" action="' . $self . '"> <select size="1" name="D1"> <option value="StartsWith">Username Starts With</option> <option selected value="Contains">Username Contains</option> </select> <p><input type="text" name="T1" size="20"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p> </form>'); print('<br>'); print('<br>'); print('<p align="center">Made by <br> <img src="img/benz.png"></p>') ?> </body> </html> nu principaa panem no mana koda offsetu maxpage rowsperpage utt. un pēc tam paķer kautko tādu queryjaaa $query = "SELECT id, name, message, DATE_FORMAT(date, '%e/%d/%Y %H:%i') as newdate FROM guests ORDER BY id DESC LIMIT $offset, $rowsperpage"; Labots Marts 4, 2007 - BenZ Link to comment Share on other sites More sharing options...
edw Marts 4, 2007 Author Share Marts 4, 2007 emmm... biski ta ka pa garu.... :? kadam nav kads isaks risinajums??? Link to comment Share on other sites More sharing options...
Val Marts 4, 2007 Share Marts 4, 2007 tā vienkāršoti: zb.php - lapa, kura tev rādīs tos komentāru zb.php?page=1 zb.php?page=2 utt. 1. nosaki patreiz esošo komentāru skaitu 2. nosaki cik lapas sanāk, ja izdala ar to tavu 5 (kom. skaits lapā) 3. dabū no url'a lapas numuru, kas jāparāda. 4. uzcep attiecīgu sql pieprasījumu: select * from komentaari limit 0 , 5; utt. 5. izpildi un drukā ārā 6. izdrukā arī saites uz citām komentāru lapām 1 | 2 | 3 | 4 | bla bla bla Link to comment Share on other sites More sharing options...
edw Marts 4, 2007 Author Share Marts 4, 2007 nja... meginaju, bet nesanaca... tapec veros te... es nezinu kapec bet sis kods man kka nepadodas... vienkārši nesanak nekas... Link to comment Share on other sites More sharing options...
Val Marts 4, 2007 Share Marts 4, 2007 Prasi, kura vieta neskaidra... Link to comment Share on other sites More sharing options...
edw Marts 4, 2007 Author Share Marts 4, 2007 varbut vienkārši kads var iedot linku google??? veletos pat to vus saprast... bet nevaru atrast neko google.. Link to comment Share on other sites More sharing options...
Val Marts 4, 2007 Share Marts 4, 2007 http://lv.php.net/manual/en/ http://php.lv/f/index.php?showtopic=2935 (ctrl+f: ierakstu dalīšana pa lappusēm) Link to comment Share on other sites More sharing options...
edw Marts 4, 2007 Author Share Marts 4, 2007 emm kka neredzu... atradu.. nu psc nekas neizdodas... tikk errori pec kartas nak ara.. Link to comment Share on other sites More sharing options...
Val Marts 4, 2007 Share Marts 4, 2007 taisi palēnām pa soļiem. nav jau viss uzreiz jāuztaisi. Link to comment Share on other sites More sharing options...
edw Marts 4, 2007 Author Share Marts 4, 2007 es jau palenam esmu ticis lidz sim... bet tagad esmu iesprudis.. Link to comment Share on other sites More sharing options...
Val Marts 5, 2007 Share Marts 5, 2007 izdrukā starprezultātus. Link to comment Share on other sites More sharing options...
edw Marts 5, 2007 Author Share Marts 5, 2007 nu un talak? :? Link to comment Share on other sites More sharing options...
Val Marts 5, 2007 Share Marts 5, 2007 un tālāk tu zināsi, vai tik tālu vispār ir pareizi. :shock: Link to comment Share on other sites More sharing options...
edw Marts 7, 2007 Author Share Marts 7, 2007 nu es saku error pec errora... tikko izlaboju vienu ta otrs jau prieksa utt,... varbut kads var palidzet? :? Link to comment Share on other sites More sharing options...
Guest BenZ Marts 8, 2007 Share Marts 8, 2007 (labots) she maacies mazuliit <html> <head> <title>Implementing Paging with next and prev</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php include '../library/config.php'; include '../library/opendb.php'; // how many rows to show per page $rowsPerPage = 20; // by default we show first page $pageNum = 1; // if $_GET['page'] defined, use it as page number if(isset($_GET['page'])) { $pageNum = $_GET['page']; } // counting the offset $offset = ($pageNum - 1) * $rowsPerPage; $query = "SELECT val FROM randoms LIMIT $offset, $rowsPerPage"; $result = mysql_query($query) or die('Error, query failed'); // print the random numbers while(list($val) = mysql_fetch_array($result)) { echo "$val <br>"; } echo '<br>'; // how many rows we have in database $query = "SELECT COUNT(val) AS numrows FROM randoms"; $result = mysql_query($query) or die('Error, query failed'); $row = mysql_fetch_array($result, MYSQL_ASSOC); $numrows = $row['numrows']; // how many pages we have when using paging? $maxPage = ceil($numrows/$rowsPerPage); $self = $_SERVER['PHP_SELF']; // creating 'previous' and 'next' link // plus 'first page' and 'last page' link // print 'previous' link only if we're not // on page one if ($pageNum > 1) { $page = $pageNum - 1; $prev = " <a href=\"$self?page=$page\">[Prev]</a> "; $first = " <a href=\"$self?page=1\">[First Page]</a> "; } else { $prev = ' [Prev] '; // we're on page one, don't enable 'previous' link $first = ' [First Page] '; // nor 'first page' link } // print 'next' link only if we're not // on the last page if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " <a href=\"$self?page=$page\">[Next]</a> "; $last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> "; } else { $next = ' [Next] '; // we're on the last page, don't enable 'next' link $last = ' [Last Page] '; // nor 'last page' link } // print the page navigation link echo $first . $prev . " Showing page <strong>$pageNum</strong> of <strong>$maxPage</strong> pages " . $next . $last; include '../library/closedb.php'; ?> </body> </html> Centies kodu likt tagos.[/color] to garo kodu es izspiedu no shitaamans tur ir daudz daudz sarazgiitaakstur ir viss mekleetaajs avatari raki utt to tev visu neviag cik noprotustarpcitu ja tev vaig mekleetaaju taisiit tad izmanto LIKE $_POST['mekleejamaa vaarda textbox']un tici man nekad nesaki ka kods pa garu. dazreiz pat elementaaras lietas var buut loti sarezgiitas un gruuti saprotamas kodaa Labots Marts 11, 2007 - ADEX Link to comment Share on other sites More sharing options...
edw Marts 9, 2007 Author Share Marts 9, 2007 ka vienmer error.... iestradajot kodu Error, query failed! :@ Link to comment Share on other sites More sharing options...
Val Marts 9, 2007 Share Marts 9, 2007 Žēloties jau visi mākam... Kristāla bumba pateica priekšā, ka kļūda ir te: $query = "SELECT val FROM randoms LIMIT $offset, $rowsPerPage";$result = mysql_query($query) or die('Error, query failed'); 1. izdrukā $query saturu un paskaties, ko izvada. 2. tev tabula "randoms" vispār ir?? Link to comment Share on other sites More sharing options...
QueenZ Marts 11, 2007 Share Marts 11, 2007 nu nav tak vinam. tas ir vienk no vienas vietas skripts nokopeets. Link to comment Share on other sites More sharing options...
edw Marts 11, 2007 Author Share Marts 11, 2007 1. izdrukā $query saturu un paskaties, ko izvada.2. tev tabula "randoms" vispār ir?? meginaju visu bet nekas nesanak.. Link to comment Share on other sites More sharing options...
Val Marts 11, 2007 Share Marts 11, 2007 1. echo esi redzējis? 2. kā tu datubāzi vispār uztaisīji? :shock: Link to comment Share on other sites More sharing options...
edw Marts 12, 2007 Author Share Marts 12, 2007 ka ka uztaisiju???? : Link to comment Share on other sites More sharing options...
Val Marts 13, 2007 Share Marts 13, 2007 jautājums manuprāt diezgan vienkāršs... Link to comment Share on other sites More sharing options...
edw Marts 13, 2007 Author Share Marts 13, 2007 nu ja saprotu, nu ka var uztaisit DB?? atvr mysql un uztaisi... vai to tu domaji? Link to comment Share on other sites More sharing options...
Val Marts 13, 2007 Share Marts 13, 2007 Tad tev tāda tabula "randoms" ar vajadzīgajām kolonnām ir, kur glabāt komentārus? Link to comment Share on other sites More sharing options...
edw Marts 13, 2007 Author Share Marts 13, 2007 nu tabula tada ir tik neviens nav paskaidrojis kadams kolonam jabut! Link to comment Share on other sites More sharing options...
Val Marts 13, 2007 Share Marts 13, 2007 Tajā pēdējā BenZ kodā pats pieliec klāt komentāru nolasīšanu, parādīšanu. Viņam doma bija parādīt, kā sadalīt pa vairākām lapām. Lai ir droši, taisi pats, kā arī visu pārējo, kas _man_ nebija svarīgi. <?php /* (c) Val table kom: id name message ip //datumu liec pats klāt. man slinkums */ $host='localhost'; $user='blabla'; $pass='blabla'; $db='blabla'; mysql_connect($host, $user, $pass) or die ("Nevar pieslēgties serverim."); mysql_select_db($db) or die("Nevar pieslēgties DB."); mysql_query("SET NAMES 'utf8'"); mysql_query("SET CHARACTER SET 'utf8'"); if(isset($_POST['name']) && isset($_POST['message'])) { $name = mysql_real_escape_string($_POST['name']); $message = mysql_real_escape_string(nl2br($_POST['message'])); $ip = $_SERVER['REMOTE_ADDR']; }; if(isset($name) && isset($message) && !empty($name) && !empty($message)) { $query = "insert into kom(name, message, ip) values ('$name', '$message', '$ip');"; $result = mysql_query($query); }; ?> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <p><input type="text" name="name" value="" /></p> <p><textarea name="message" rows="5" cols="20"></textarea></p> <p><input type="submit" value="piev" /></p> </form> <?php if(isset($_GET['page'])) { $page=$_GET['page']; if(!is_numeric($page)) { $page=1; }; if($page<=0) { $page=1; }; } else { $page=1; }; $komentaari_lapaa = 2; $page=$page-1; $start=$page*$komentaari_lapaa; $sql = "select * from kom order by id desc limit $start,$komentaari_lapaa;"; $x = mysql_query($sql) or die(mysql_error); while ($row = mysql_fetch_array ($x)) { $name=$row['name']; $message=$row['message']; $ip=$row['ip']; echo "<p>$name - $message - $ip</p>"; }; $zb = 'select id from kom;'; $z=mysql_query($zb); $kom_skaits=mysql_num_rows($z); $lapu_skaits = ceil($kom_skaits/$komentaari_lapaa); if($kom_skaits==0) { echo 'Tu vari buut pirmais...'; }; for($i=1; $i<=$lapu_skaits; $i++) { if($lapu_skaits==1) { //nekas } else { echo '<a href="'.$_SERVER['PHP_SELF']."?page=$i\">$i</a> | "; }; }; A to pusmēnesis pagājis, bet reāli neko neesi tā arī uztaisījis. :| Link to comment Share on other sites More sharing options...
Guest BenZ Marts 13, 2007 Share Marts 13, 2007 aciimredzot vinu dievs nav apveltiijis ar smadzeneem Link to comment Share on other sites More sharing options...
edw Marts 15, 2007 Author Share Marts 15, 2007 varbut kads pateiks kur kluda? http://paste.php.lv/5303 Link to comment Share on other sites More sharing options...
Val Marts 15, 2007 Share Marts 15, 2007 aizverošā iekava pa daudz Link to comment Share on other sites More sharing options...
DJ_BioniX Marts 15, 2007 Share Marts 15, 2007 (labots) varbut kads pateiks kur kluda? http://paste.php.lv/5303 zini ko es ieteiktu nopērc grāmatu "PHP soli pa solim" jaa un es ceru ka tu maaki lasiit un konstatēt patiesāš kļūdas, nu es nedomaaju par smadzenēm, bet gan par tavu kodu ja lasiit maaki un arii debugot. ta jautaajumi ir lieki Labots Marts 15, 2007 - DJ_BioniX Link to comment Share on other sites More sharing options...
Val Marts 15, 2007 Share Marts 15, 2007 Vispār kāda jēga bija taisīt dalīšanu pa lapām, ja tu savu(?) kodu bāz iekšā galīgi ne tajā vietā. Ko mēģini nolasīt no guests tabulas? [Ja komentāru tabula ir cita...] Komentāra pievienošanas forma jau ir Kom. drukāšana arī. utt... Headeris pašās beigās nenostrādās Link to comment Share on other sites More sharing options...
Guest BenZ Marts 15, 2007 Share Marts 15, 2007 jaaizmanto ob_start() vai arii hederis jaaliek koda augshaa. jo pirms hedera nedriikst neko izvadiit piem nekaadi print vai echo vai kas taads nedriikst buut Link to comment Share on other sites More sharing options...
Val Marts 15, 2007 Share Marts 15, 2007 Rakstīju par pēdējo variantu, nevis par to, kas varētu būt pēc pusgada Link to comment Share on other sites More sharing options...
Recommended Posts
Izveido kontu, vai pieraksties esošajā, lai komentētu
Jums ir jābūt šī foruma biedram, lai varētu komentēt tēmas
Izveidot jaunu kontu
Piereģistrējies un izveido jaunu kontu, tas būs viegli!
Reģistrēt jaunu kontuPierakstīties
Jums jau ir konts? Pierakstieties tajā šeit!
Pierakstīties tagad!