\uc5ec\uae30\ub85c \uc774\ub3d9<\/a><\/u>)<\/li>\n<\/ul>\n\uc6b0\ub9ac\uac00 \uad6c\ucd95\ud560 \uac83<\/h4>\n
\uc774 \uae00\uc5d0\uc11c\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc640\uc11c \ud398\uc774\uc9c0 \ubc88\ud638\ub97c \ub9e4\uae30\uace0 \ud45c\uc2dc\ud558\ub294 PHP \ud658\uacbd\uc744 \ube60\ub974\uac8c \uc124\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\ud658\uacbd \uc124\uc815<\/p>\n
1\ub2e8\uacc4: \uc0c8 \ubc84\ud0b7 \ub9cc\ub4e4\uae30<\/p>\n
Log in to your Couchbase admin area\u00a0and create a new bucket name `commenting`.<\/p>\n
![\"Screenshot](\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/09\/Screenshot-from-2017-08-20-21-25-56.png\")
<\/p>\n
Step 2: create an index for the new bucket: `commenting`<\/p>\n
\ucffc\ub9ac \ud0ed\uc744 \ud074\ub9ad\ud558\uace0 \uc544\ub798\uc5d0 \ub098\uc5f4\ub41c \ucffc\ub9ac\ub97c \uc785\ub825\ud55c \ud6c4 \uc2e4\ud589\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n
GI\ub97c \uc0ac\uc6a9\ud558\uc5ec '\ub313\uae00'\uc5d0 \uae30\ubcf8 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4;\r\n<\/pre>\n\ubaa8\ub4e0 \uac83\uc774 \uc21c\uc870\ub86d\uac8c \uc9c4\ud589\ub418\uba74 \ubb38\uc11c \uc791\uc131\uc744 \uc2dc\uc791\ud574\ub3c4 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n
3\ub2e8\uacc4: \ud504\ub85c\uc81d\ud2b8 \uc2a4\ud0c0\ud130 \ud30c\uc77c \ubcf5\uc81c\ud558\uae30<\/p>\n
\uc774 \ud29c\ud1a0\ub9ac\uc5bc\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ud30c\uc77c\uc758 \uae30\ubcf8 \ud30c\uc77c \uad6c\uc870\ub97c \ub9cc\ub4e4\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n
\uba85\ub839\uc904\uc744 \uc5f4\uace0 github\uc5d0\uc11c \ub9ac\ud3ec\uc9c0\ud1a0\ub9ac\ub97c \ubcf5\uc81c\ud569\ub2c8\ub2e4.<\/p>\n
$ git clone git@github.com:dongido001\/php-couchbase-pagination_complete.git\r\n<\/pre>\n\uc774\uc81c \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \ubc29\uae08 \ubcf5\uc81c\ud55c \ud30c\uc77c\uc744 \uc5fd\ub2c8\ub2e4. \ub2e4\uc74c \ud398\uc774\uc9c0\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4:<\/p>\n
![\"page\"](\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/09\/page.png\")
<\/p>\n
\ud30c\uc77c \uad6c\uc870<\/h2>\n
The repository you just cloned contains 3 PHP files: `config.php`, `db.php`, and `index.php`.<\/p>\n
The `config.php` file is where we define the information of our database:<\/p>\n
<?php\r\n\/\/\uc77c\ubd80 \uc124\uc815\r\ndefine("C_USERNAMAE", "\uad00\ub9ac\uc790");\r\ndefine("C_PASSWORD", "password");\r\ndefine("C_URL", "https:\/\/127.0.0.1:8091\/"); \/\/eg: localhost:8091\r\ndefine("DEFAULT_BUCKET", "\ub313\uae00");<\/pre>\nIn the `db.php`, \u00a0we connected to Couchbase and opened a bucket.You should change the details to correspond to your Couchbase information.<\/p>\n
cluster(C_USERNAMAE, C_PASSWORD);\r\n\r\n$cluster = new \\Couchbase\\Cluster(C_URL);\r\n\r\n$cluster->authenticate($authenticator);\r\n\r\n$\ubc84\ud0b7 = $cluster->openBucket(DEFAULT_BUCKET);\r\n\r\n'index.php'\uc5d0\ub294 \ud30c\uc77c \uc0c1\ub2e8\uc5d0 \uba87 \uac00\uc9c0 PHP \ucf54\ub4dc\uac00 \uc788\uace0 \ud558\ub2e8\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ucf54\ub4dc\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/pre>\nHTML \ucf54\ub4dc\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\/\/index.php\r\n\r\n $uid,\r\n\"name\" => $_POST[\"name\"],\r\n\"comment\" => $_POST[\"comment\"],\r\n\"created_at\" => date(\"Y-m-d H:i:s\")\r\n];\r\n\r\n$\ubc84\ud0b7->insert($uid, $comment);\r\n\r\n}\r\n\r\n?>\r\n\r\n...<\/pre>\nI included the two files, `config.php` and `db.php` then I wrote logic to insert some comments into the database when the form is submitted.<\/p>\n
\/\/index.php\r\n\r\n...\r\n\r\n<!DOCTYPE html>\r\n<html lang="en">\r\n<head>\r\n<!-- Required meta tags -->\r\n<meta charset="utf-8">\r\n<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">\r\n\r\n<!-- Bootstrap CSS -->\r\n<link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/4.0.0-beta\/css\/bootstrap.min.css" integrity="sha384-\/Y6pD6FV\/Vv2HJnA6t+vslU6fwYXjCFtcEpHbNJ0lyAFsXTsjBbfaDjzALeQsN6M" crossorigin="anonymous">\r\n<\/head>\r\n<body>\r\n\r\n<div class="container">\r\n\r\n<div class="container" style="margin-left: auto; margin-right: auto; width: 400px;">\r\n<h4 class="text-center">\ub313\uae00 \ucd94\uac00<\/h4>\r\n\r\n<form action="" method="POST">\r\n<div class="form-group">\r\n<label for="name">\uc774\ub984:<\/label>\r\n<input type="text" class="form-control" name="name" required>\r\n<\/div>\r\n\r\n<div class="form-group">\r\n<label for="comment">\ub313\uae00:<\/label>\r\n<textarea class="form-control" rows="5" name="comment" required> <\/textarea>\r\n<\/div>\r\n\r\n<button type="submit" class="btn btn-primary">\uc81c\ucd9c\ud558\uae30<\/button>\r\n<\/form> <br \/>\r\n\r\n<div >\r\n<h4 class="text-center">\ub313\uae00 \ub098\uc5f4<\/h4>\r\n\r\n<\/div>\r\n\r\n<div id="pagination">\r\n\r\n<\/div>\r\n\r\n<\/div>\r\n\r\n<\/div>\r\n\r\n<\/body>\r\n<\/html>\r\n\r\n<\/pre>\nHTML \ucf54\ub4dc\ub294 \ub313\uae00\uc744 \ucd94\uac00\ud558\uace0 \ub098\uc5f4\ud560 \uc218 \uc788\ub294 \uc591\uc2dd\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n
\uc774\uc81c \uc2dc\uc791\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4!<\/p>\n
\ud398\uc774\uc9c0\uc5d0\uc11c \uc6d0\ud558\ub294 \ub9cc\ud07c \ub313\uae00\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4. \uace7 \ud574\ub2f9 \ub370\uc774\ud130\uc5d0 \ud398\uc774\uc9c0 \ubc88\ud638\ub97c \ub9e4\uae38 \uc608\uc815\uc785\ub2c8\ub2e4.<\/p>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ud398\uc774\uc9c0 \ub9e4\uae40\ub41c \ucf58\ud150\uce20 \uac00\uc838\uc624\uae30<\/p>\n
Add the following to the header part of `index.php` that is below every PHP code at the top.<\/p>\n
\/\/\ucffc\ub9ac\uc5d0\uc11c \ubaa8\ub4e0 \ucf58\ud150\uce20 \uc120\ud0dd\r\n\r\n$no_per_page = 4; \/\/\ud398\uc774\uc9c0\ub2f9 \uc6d0\ud558\ub294 \ud56d\ubaa9 \uc218\uc785\ub2c8\ub2e4.\r\n\r\n $current_page = (isset($_GET['page_id'])) ? $_GET['page_id'] : 1; \/\/\ud604\uc7ac \ud398\uc774\uc9c0\ub97c \uac00\uc838\uc635\ub2c8\ub2e4, \uc124\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 \uae30\ubcf8\uac12\uc740 1\ud398\uc774\uc9c0\uc785\ub2c8\ub2e4.\r\n\r\n$skip = ($current_page - 1) * $no_per_page; \/\/\uc694\uccad \uc2dc \uac74\ub108\ub6f8 \ud398\uc774\uc9c0\uc758 \ucd1d \uac1c\uc218\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. 1\ud398\uc774\uc9c0\uc5d0 \uc788\uc744 \ub54c\ub294 \uc5b4\ub5a4 \ud56d\ubaa9\ub3c4 \uac74\ub108\ub6f8 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.\r\n\r\n$query = \\Couchbase\\N1qlQuery::fromString(\"SELECT * FROM `commenting` LIMIT $no_per_page OFFSET $skip\");\r\n\r\n$result = $\ubc84\ud0b7->query($\ucffc\ub9ac);\r\n\r\n\/\/\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ucd1d \uacb0\uacfc \uc218 \uacc4\uc0b0\r\n\r\n$total = $bucket->query(\\Couchbase\\N1qlQuery::fromString(\"SELECT COUNT(comment) total FROM `commenting`\"));\r\n\r\n$total = $total->rows[0]->total;\r\n\r\n$number_of_pages = ceil( $total\/$no_per_page ); \/\/\ud398\uc774\uc9c0 \uc218 \uacc4\uc0b0<\/pre>\nI’ve added comments to the code above, which describes what each does. Here we also used `LIMIT` AND `OFFSET` which enabled us to LIMIT the number of results each query is meant to return. The OFFSET was used to skip over an amount of data when querying depending on the page number we are currently accessing.<\/p>\n
`LIMIT`: The LIMIT clause specifies the maximum number of objects that can be returned in a result set by SELECT. A negative value or a value greater than 9223372036854775295 (result of 1\u00a0– 512) is considered as LIMIT 0.<\/p>\n
`OFFSET`: The OFFSET clause specifies a number of objects to be skipped. If a LIMIT clause is also present, the OFFSET is applied prior to the LIMIT. The OFFSET value must be a non-negative integer.<\/p>\n
\ucffc\ub9ac \uacb0\uacfc\ub97c \ud398\uc774\uc9c0\uc5d0 \ucc44\uc6b0\uae30<\/p>\n
Add the code below to `index.php` inside this tag, immediately after `<h4 class="”text-center”">\ub313\uae00 \ub098\uc5f4<\/h4> `.<\/p>\n
\u00a0 \u00a0 \u00a0 <?php foreach( $result->rows as $comment ):?>\r\n<div>\r\n<div class="alert alert-success" role="alert">\r\n<h5 class="alert-heading"> \uc791\uc131\uc790: commenting->name?>, \uc0dd\uc131\ub41c \ub0a0\uc9dc: commenting->created_at?> <\/h5><br>\r\n<p> <?=$comment->commenting->comment?><\/p>\r\n<hr>\r\n<\/div>\r\n\r\n<\/div>\r\n<?php endforeach; ?>\r\n\r\n<\/pre>\n\ud398\uc774\uc9c0 \ub9e4\uae40 \ub9c1\ud06c \ucd94\uac00<\/p>\n
Add the code below in between this html tag `<div id="”pagination”"> <\/div>` at the bottom part of index.php.<\/p>\n
![\"18485569](\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/09\/18485569_1371908909572883_6954592115736688669_n.jpg\")
<\/p>\n![\"Peek](\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/09\/Peek-2017-08-23-19-35.gif\")
<\/p>\n