VOTING POWER100.00%
DOWNVOTE POWER100.00%
RESOURCE CREDITS100.00%
REPUTATION PROGRESS0.00%
Net Worth
0.018USD
STEEM
0.000STEEM
SBD
0.023SBD
Effective Power
5.007SP
├── Own SP
0.125SP
└── Incoming DelegationsDeleg
+4.881SP
Detailed Balance
| STEEM | ||
| balance | 0.000STEEM | STEEM |
| market_balance | 0.000STEEM | STEEM |
| savings_balance | 0.000STEEM | STEEM |
| reward_steem_balance | 0.000STEEM | STEEM |
| STEEM POWER | ||
| Own SP | 0.125SP | SP |
| Delegated Out | 0.000SP | SP |
| Delegation In | 4.881SP | SP |
| Effective Power | 5.007SP | SP |
| Reward SP (pending) | 0.006SP | SP |
| SBD | ||
| sbd_balance | 0.000SBD | SBD |
| sbd_conversions | 0.000SBD | SBD |
| sbd_market_balance | 0.000SBD | SBD |
| savings_sbd_balance | 0.000SBD | SBD |
| reward_sbd_balance | 0.023SBD | SBD |
{
"balance": "0.000 STEEM",
"savings_balance": "0.000 STEEM",
"reward_steem_balance": "0.000 STEEM",
"vesting_shares": "203.858848 VESTS",
"delegated_vesting_shares": "0.000000 VESTS",
"received_vesting_shares": "7939.800958 VESTS",
"sbd_balance": "0.000 SBD",
"savings_sbd_balance": "0.000 SBD",
"reward_sbd_balance": "0.023 SBD",
"conversions": []
}Account Info
| name | instink |
| id | 934617 |
| rank | 405,473 |
| reputation | 154683086 |
| created | 2018-04-11T10:12:09 |
| recovery_account | steem |
| proxy | None |
| post_count | 3 |
| comment_count | 0 |
| lifetime_vote_count | 0 |
| witnesses_voted_for | 0 |
| last_post | 2018-05-24T21:55:24 |
| last_root_post | 2018-05-24T21:55:24 |
| last_vote_time | 1970-01-01T00:00:00 |
| proxied_vsf_votes | 0, 0, 0, 0 |
| can_vote | 1 |
| voting_power | 0 |
| delayed_votes | 0 |
| balance | 0.000 STEEM |
| savings_balance | 0.000 STEEM |
| sbd_balance | 0.000 SBD |
| savings_sbd_balance | 0.000 SBD |
| vesting_shares | 203.858848 VESTS |
| delegated_vesting_shares | 0.000000 VESTS |
| received_vesting_shares | 7939.800958 VESTS |
| reward_vesting_balance | 12.216174 VESTS |
| vesting_balance | 0.000 STEEM |
| vesting_withdraw_rate | 0.000000 VESTS |
| next_vesting_withdrawal | 1969-12-31T23:59:59 |
| withdrawn | 0 |
| to_withdraw | 0 |
| withdraw_routes | 0 |
| savings_withdraw_requests | 0 |
| last_account_recovery | 1970-01-01T00:00:00 |
| reset_account | null |
| last_owner_update | 1970-01-01T00:00:00 |
| last_account_update | 2018-05-24T19:57:27 |
| mined | No |
| sbd_seconds | 0 |
| sbd_last_interest_payment | 1970-01-01T00:00:00 |
| savings_sbd_last_interest_payment | 1970-01-01T00:00:00 |
{
"active": {
"account_auths": [],
"key_auths": [
[
"STM7YPNGUhS6QJe2icvUcBMwKLXMUjurJwvNiZEBsnZDUnw5336V6",
1
]
],
"weight_threshold": 1
},
"balance": "0.000 STEEM",
"can_vote": true,
"comment_count": 0,
"created": "2018-04-11T10:12:09",
"curation_rewards": 0,
"delegated_vesting_shares": "0.000000 VESTS",
"downvote_manabar": {
"current_mana": 2035914951,
"last_update_time": 1779067707
},
"guest_bloggers": [],
"id": 934617,
"json_metadata": "{\"profile\":{\"profile_image\":\"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg\",\"name\":\"Instink\",\"about\":\"Im Web Developer\",\"location\":\"Takengon\"}}",
"last_account_recovery": "1970-01-01T00:00:00",
"last_account_update": "2018-05-24T19:57:27",
"last_owner_update": "1970-01-01T00:00:00",
"last_post": "2018-05-24T21:55:24",
"last_root_post": "2018-05-24T21:55:24",
"last_vote_time": "1970-01-01T00:00:00",
"lifetime_vote_count": 0,
"market_history": [],
"memo_key": "STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R",
"mined": false,
"name": "instink",
"next_vesting_withdrawal": "1969-12-31T23:59:59",
"other_history": [],
"owner": {
"account_auths": [],
"key_auths": [
[
"STM5SYxtaCMLiqwr4xnBr5kYiMajr1LhiQmfVxjidtUfNNC992aHY",
1
]
],
"weight_threshold": 1
},
"pending_claimed_accounts": 0,
"post_bandwidth": 0,
"post_count": 3,
"post_history": [],
"posting": {
"account_auths": [
[
"dlive.app",
1
],
[
"utopian.app",
1
]
],
"key_auths": [
[
"STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",
1
]
],
"weight_threshold": 1
},
"posting_json_metadata": "{\"profile\":{\"profile_image\":\"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg\",\"name\":\"Instink\",\"about\":\"Im Web Developer\",\"location\":\"Takengon\"}}",
"posting_rewards": 12,
"proxied_vsf_votes": [
0,
0,
0,
0
],
"proxy": "",
"received_vesting_shares": "7939.800958 VESTS",
"recovery_account": "steem",
"reputation": 154683086,
"reset_account": "null",
"reward_sbd_balance": "0.023 SBD",
"reward_steem_balance": "0.000 STEEM",
"reward_vesting_balance": "12.216174 VESTS",
"reward_vesting_steem": "0.006 STEEM",
"savings_balance": "0.000 STEEM",
"savings_sbd_balance": "0.000 SBD",
"savings_sbd_last_interest_payment": "1970-01-01T00:00:00",
"savings_sbd_seconds": "0",
"savings_sbd_seconds_last_update": "1970-01-01T00:00:00",
"savings_withdraw_requests": 0,
"sbd_balance": "0.000 SBD",
"sbd_last_interest_payment": "1970-01-01T00:00:00",
"sbd_seconds": "0",
"sbd_seconds_last_update": "1970-01-01T00:00:00",
"tags_usage": [],
"to_withdraw": 0,
"transfer_history": [],
"vesting_balance": "0.000 STEEM",
"vesting_shares": "203.858848 VESTS",
"vesting_withdraw_rate": "0.000000 VESTS",
"vote_history": [],
"voting_manabar": {
"current_mana": "8143659806",
"last_update_time": 1779067707
},
"voting_power": 0,
"withdraw_routes": 0,
"withdrawn": 0,
"witness_votes": [],
"witnesses_voted_for": 0,
"rank": 405473
}Withdraw Routes
| Incoming | Outgoing |
|---|---|
Empty | Empty |
{
"incoming": [],
"outgoing": []
}From Date
To Date
2026/05/18 01:28:27
2026/05/18 01:28:27
| delegatee | instink |
| delegator | steem |
| vesting shares | 7939.800958 VESTS |
| Transaction Info | Block #106144905/Trx 9aae193ea1f5c7710a010e6416310be4fac2a668 |
View Raw JSON Data
{
"block": 106144905,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "7939.800958 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2026-05-18T01:28:27",
"trx_id": "9aae193ea1f5c7710a010e6416310be4fac2a668",
"trx_in_block": 3,
"virtual_op": 0
}2026/05/12 08:47:45
2026/05/12 08:47:45
| delegatee | instink |
| delegator | steem |
| vesting shares | 5227.590553 VESTS |
| Transaction Info | Block #105981645/Trx 1ce029822ec6e9570772ce07033693a1ac18fef1 |
View Raw JSON Data
{
"block": 105981645,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "5227.590553 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2026-05-12T08:47:45",
"trx_id": "1ce029822ec6e9570772ce07033693a1ac18fef1",
"trx_in_block": 0,
"virtual_op": 0
}2026/04/26 00:47:21
2026/04/26 00:47:21
| delegatee | instink |
| delegator | steem |
| vesting shares | 7952.316714 VESTS |
| Transaction Info | Block #105512523/Trx c021203e7320a88e06d1a97e8c18568587138f33 |
View Raw JSON Data
{
"block": 105512523,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "7952.316714 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2026-04-26T00:47:21",
"trx_id": "c021203e7320a88e06d1a97e8c18568587138f33",
"trx_in_block": 2,
"virtual_op": 0
}2026/01/23 11:05:27
2026/01/23 11:05:27
| delegatee | instink |
| delegator | steem |
| vesting shares | 5269.137372 VESTS |
| Transaction Info | Block #102855754/Trx 92f483852d383ccd0a3d7bba7dbbae9fc083a88d |
View Raw JSON Data
{
"block": 102855754,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "5269.137372 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2026-01-23T11:05:27",
"trx_id": "92f483852d383ccd0a3d7bba7dbbae9fc083a88d",
"trx_in_block": 0,
"virtual_op": 0
}2024/12/17 06:22:33
2024/12/17 06:22:33
| delegatee | instink |
| delegator | steem |
| vesting shares | 5433.356569 VESTS |
| Transaction Info | Block #91302111/Trx c92c09894cf7c190a9d6f39b3f730f7d0ff0d578 |
View Raw JSON Data
{
"block": 91302111,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "5433.356569 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2024-12-17T06:22:33",
"trx_id": "c92c09894cf7c190a9d6f39b3f730f7d0ff0d578",
"trx_in_block": 0,
"virtual_op": 0
}2023/11/13 22:04:33
2023/11/13 22:04:33
| delegatee | instink |
| delegator | steem |
| vesting shares | 5602.490101 VESTS |
| Transaction Info | Block #79856296/Trx 5d3c635cd3e31f487d6c618e573c09b85c143ea9 |
View Raw JSON Data
{
"block": 79856296,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "5602.490101 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2023-11-13T22:04:33",
"trx_id": "5d3c635cd3e31f487d6c618e573c09b85c143ea9",
"trx_in_block": 0,
"virtual_op": 0
}2023/09/21 23:16:30
2023/09/21 23:16:30
| delegatee | instink |
| delegator | steem |
| vesting shares | 8539.768887 VESTS |
| Transaction Info | Block #78349559/Trx 38f8420ae4301150f36089c3dbed3300b88d2c5b |
View Raw JSON Data
{
"block": 78349559,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "8539.768887 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2023-09-21T23:16:30",
"trx_id": "38f8420ae4301150f36089c3dbed3300b88d2c5b",
"trx_in_block": 1,
"virtual_op": 0
}2022/11/03 12:52:36
2022/11/03 12:52:36
| delegatee | instink |
| delegator | steem |
| vesting shares | 8761.450325 VESTS |
| Transaction Info | Block #69114662/Trx 694d46890ec9a30febd29e7d29afcbaef98ddc48 |
View Raw JSON Data
{
"block": 69114662,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "8761.450325 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2022-11-03T12:52:36",
"trx_id": "694d46890ec9a30febd29e7d29afcbaef98ddc48",
"trx_in_block": 6,
"virtual_op": 0
}2022/01/17 12:02:39
2022/01/17 12:02:39
| delegatee | instink |
| delegator | steem |
| vesting shares | 8981.983556 VESTS |
| Transaction Info | Block #60810714/Trx ce6d7fb2e936eba785c188d3d9b6adb2284f85fc |
View Raw JSON Data
{
"block": 60810714,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "8981.983556 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2022-01-17T12:02:39",
"trx_id": "ce6d7fb2e936eba785c188d3d9b6adb2284f85fc",
"trx_in_block": 39,
"virtual_op": 0
}2021/06/14 01:54:57
2021/06/14 01:54:57
| delegatee | instink |
| delegator | steem |
| vesting shares | 9165.752214 VESTS |
| Transaction Info | Block #54609037/Trx 22db6dc73660cfc2936c1f88d7cb49af74b023dd |
View Raw JSON Data
{
"block": 54609037,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "9165.752214 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2021-06-14T01:54:57",
"trx_id": "22db6dc73660cfc2936c1f88d7cb49af74b023dd",
"trx_in_block": 3,
"virtual_op": 0
}2020/12/11 12:12:06
2020/12/11 12:12:06
| delegatee | instink |
| delegator | steem |
| vesting shares | 9353.174188 VESTS |
| Transaction Info | Block #49356447/Trx 6db6ecb5729e2f2f682c6ac2583c9462a47fa2f9 |
View Raw JSON Data
{
"block": 49356447,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "9353.174188 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2020-12-11T12:12:06",
"trx_id": "6db6ecb5729e2f2f682c6ac2583c9462a47fa2f9",
"trx_in_block": 2,
"virtual_op": 0
}2020/12/06 05:49:03
2020/12/06 05:49:03
| delegatee | instink |
| delegator | steem |
| vesting shares | 1912.543513 VESTS |
| Transaction Info | Block #49208006/Trx 94fe175fef1b9df322fc3a2223ed82fddbff6358 |
View Raw JSON Data
{
"block": 49208006,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "1912.543513 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2020-12-06T05:49:03",
"trx_id": "94fe175fef1b9df322fc3a2223ed82fddbff6358",
"trx_in_block": 3,
"virtual_op": 0
}2020/12/05 15:50:00
2020/12/05 15:50:00
| delegatee | instink |
| delegator | steem |
| vesting shares | 9359.382042 VESTS |
| Transaction Info | Block #49191541/Trx cabf8f7d4a22f175e7b787d10ae1c93e94d4b315 |
View Raw JSON Data
{
"block": 49191541,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "9359.382042 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2020-12-05T15:50:00",
"trx_id": "cabf8f7d4a22f175e7b787d10ae1c93e94d4b315",
"trx_in_block": 1,
"virtual_op": 0
}2020/11/02 17:53:33
2020/11/02 17:53:33
| delegatee | instink |
| delegator | steem |
| vesting shares | 1920.017158 VESTS |
| Transaction Info | Block #48260456/Trx e222eef204e7667ae62cead2fce2b7bab9cf3908 |
View Raw JSON Data
{
"block": 48260456,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "1920.017158 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2020-11-02T17:53:33",
"trx_id": "e222eef204e7667ae62cead2fce2b7bab9cf3908",
"trx_in_block": 1,
"virtual_op": 0
}2020/05/09 06:47:27
2020/05/09 06:47:27
| delegatee | instink |
| delegator | steem |
| vesting shares | 9562.187401 VESTS |
| Transaction Info | Block #43218270/Trx 1d72dd24d822dbd90963e6b3f060e8a8a4750a35 |
View Raw JSON Data
{
"block": 43218270,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "9562.187401 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2020-05-09T06:47:27",
"trx_id": "1d72dd24d822dbd90963e6b3f060e8a8a4750a35",
"trx_in_block": 12,
"virtual_op": 0
}2020/05/08 10:33:21
2020/05/08 10:33:21
| delegatee | instink |
| delegator | steem |
| vesting shares | 1953.311140 VESTS |
| Transaction Info | Block #43194556/Trx f39c1ea6ee117df5d44386c95642d0ab73cbf23d |
View Raw JSON Data
{
"block": 43194556,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "1953.311140 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2020-05-08T10:33:21",
"trx_id": "f39c1ea6ee117df5d44386c95642d0ab73cbf23d",
"trx_in_block": 9,
"virtual_op": 0
}2019/08/08 19:08:48
2019/08/08 19:08:48
| delegatee | instink |
| delegator | steem |
| vesting shares | 9718.898359 VESTS |
| Transaction Info | Block #35380496/Trx 65374f8f7f38cb76aab6a1b44a48a42007ab9dc5 |
View Raw JSON Data
{
"block": 35380496,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "9718.898359 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2019-08-08T19:08:48",
"trx_id": "65374f8f7f38cb76aab6a1b44a48a42007ab9dc5",
"trx_in_block": 28,
"virtual_op": 0
}2019/04/11 10:44:00
2019/04/11 10:44:00
| author | steemitboard |
| body | Congratulations @instink! You received a personal award! <table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@instink/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table> <sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@instink) and compare to others on the [Steem Ranking](http://steemitboard.com/ranking/index.php?name=instink)_</sub> ###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes! |
| json metadata | {"image":["https://steemitboard.com/img/notify.png"]} |
| parent author | instink |
| parent permlink | 27f6e475-5f9d-11e8-82ff-0242ac110002 |
| permlink | steemitboard-notify-instink-20190411t104400000z |
| title | |
| Transaction Info | Block #31949394/Trx f8e790afbdb52661945f3f2fde62a56fc8ea4325 |
View Raw JSON Data
{
"block": 31949394,
"op": [
"comment",
{
"author": "steemitboard",
"body": "Congratulations @instink! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@instink/birthday1.png</td><td>Happy Birthday! - You are on the Steem blockchain for 1 year!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@instink) and compare to others on the [Steem Ranking](http://steemitboard.com/ranking/index.php?name=instink)_</sub>\n\n\n###### [Vote for @Steemitboard as a witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1) to get one more award and increased upvotes!",
"json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
"parent_author": "instink",
"parent_permlink": "27f6e475-5f9d-11e8-82ff-0242ac110002",
"permlink": "steemitboard-notify-instink-20190411t104400000z",
"title": ""
}
],
"op_in_trx": 0,
"timestamp": "2019-04-11T10:44:00",
"trx_id": "f8e790afbdb52661945f3f2fde62a56fc8ea4325",
"trx_in_block": 8,
"virtual_op": 0
}2018/08/23 22:20:15
2018/08/23 22:20:15
| delegatee | instink |
| delegator | steem |
| vesting shares | 9917.374753 VESTS |
| Transaction Info | Block #25331232/Trx 0698421378cf01c097a69d5568781c644233236c |
View Raw JSON Data
{
"block": 25331232,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "9917.374753 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2018-08-23T22:20:15",
"trx_id": "0698421378cf01c097a69d5568781c644233236c",
"trx_in_block": 39,
"virtual_op": 0
}2018/08/16 07:04:45
2018/08/16 07:04:45
| delegatee | instink |
| delegator | steem |
| vesting shares | 30172.369299 VESTS |
| Transaction Info | Block #25111398/Trx b241770825a10c3db2a0611561ae5ddc9e2b0291 |
View Raw JSON Data
{
"block": 25111398,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "30172.369299 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2018-08-16T07:04:45",
"trx_id": "b241770825a10c3db2a0611561ae5ddc9e2b0291",
"trx_in_block": 3,
"virtual_op": 0
}instinkpublished a new post: 27f6e475-5f9d-11e8-82ff-0242ac1100022018/05/24 21:55:24
instinkpublished a new post: 27f6e475-5f9d-11e8-82ff-0242ac110002
2018/05/24 21:55:24
| author | instink |
| body | [](https://dlive.io/livestream/instink/27f6e475-5f9d-11e8-82ff-0242ac110002) Let's Play Mobile Lagend With Us My live stream is at [DLive](https://dlive.io/livestream/instink/27f6e475-5f9d-11e8-82ff-0242ac110002) |
| json metadata | {"tags":["dlive","dlive-broadcast","game","mobilelagend gaming"],"app":"dlive/0.1","format":"markdown","language":"en","thumbnail":"https://dlive.biz:8080/QmUpNaux2QsezvfRhu15rTQNbr4yzweXiFw8mKYKvkqPsK"} |
| parent author | |
| parent permlink | dlive |
| permlink | 27f6e475-5f9d-11e8-82ff-0242ac110002 |
| title | Mobile Lagend Streaming |
| Transaction Info | Block #22721798/Trx 7721abaf6579301dd118db3c3a0be5024bdd79cc |
View Raw JSON Data
{
"block": 22721798,
"op": [
"comment",
{
"author": "instink",
"body": "[](https://dlive.io/livestream/instink/27f6e475-5f9d-11e8-82ff-0242ac110002)\n\nLet's Play Mobile Lagend With Us\n\nMy live stream is at [DLive](https://dlive.io/livestream/instink/27f6e475-5f9d-11e8-82ff-0242ac110002)",
"json_metadata": "{\"tags\":[\"dlive\",\"dlive-broadcast\",\"game\",\"mobilelagend gaming\"],\"app\":\"dlive/0.1\",\"format\":\"markdown\",\"language\":\"en\",\"thumbnail\":\"https://dlive.biz:8080/QmUpNaux2QsezvfRhu15rTQNbr4yzweXiFw8mKYKvkqPsK\"}",
"parent_author": "",
"parent_permlink": "dlive",
"permlink": "27f6e475-5f9d-11e8-82ff-0242ac110002",
"title": "Mobile Lagend Streaming"
}
],
"op_in_trx": 0,
"timestamp": "2018-05-24T21:55:24",
"trx_id": "7721abaf6579301dd118db3c3a0be5024bdd79cc",
"trx_in_block": 22,
"virtual_op": 0
}instinkupdated their account properties2018/05/24 19:57:27
instinkupdated their account properties
2018/05/24 19:57:27
| account | instink |
| json metadata | {"profile":{"profile_image":"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg","name":"Instink","about":"Im Web Developer","location":"Takengon"}} |
| memo key | STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R |
| posting | {"account_auths":[["dlive.app",1],["utopian.app",1]],"key_auths":[["STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",1]],"weight_threshold":1} |
| Transaction Info | Block #22719441/Trx d57b31bf6af886ab18438b1bd879f8eee039a5f9 |
View Raw JSON Data
{
"block": 22719441,
"op": [
"account_update",
{
"account": "instink",
"json_metadata": "{\"profile\":{\"profile_image\":\"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg\",\"name\":\"Instink\",\"about\":\"Im Web Developer\",\"location\":\"Takengon\"}}",
"memo_key": "STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R",
"posting": {
"account_auths": [
[
"dlive.app",
1
],
[
"utopian.app",
1
]
],
"key_auths": [
[
"STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",
1
]
],
"weight_threshold": 1
}
}
],
"op_in_trx": 0,
"timestamp": "2018-05-24T19:57:27",
"trx_id": "d57b31bf6af886ab18438b1bd879f8eee039a5f9",
"trx_in_block": 63,
"virtual_op": 0
}instinkreceived 0.023 SBD, 0.008 SP author reward for @instink / how-to-create-login-page-using-php-function-and-mysql-database2018/05/05 17:29:36
instinkreceived 0.023 SBD, 0.008 SP author reward for @instink / how-to-create-login-page-using-php-function-and-mysql-database
2018/05/05 17:29:36
| author | instink |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| sbd payout | 0.023 SBD |
| steem payout | 0.000 STEEM |
| vesting payout | 12.216174 VESTS |
| Transaction Info | Block #22169743/Virtual Operation #20 |
View Raw JSON Data
{
"block": 22169743,
"op": [
"author_reward",
{
"author": "instink",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"sbd_payout": "0.023 SBD",
"steem_payout": "0.000 STEEM",
"vesting_payout": "12.216174 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2018-05-05T17:29:36",
"trx_id": "0000000000000000000000000000000000000000",
"trx_in_block": 4294967295,
"virtual_op": 20
}utopian.payreceived 0.003 SP benefactor reward from @instink2018/05/05 17:29:36
utopian.payreceived 0.003 SP benefactor reward from @instink
2018/05/05 17:29:36
| author | instink |
| benefactor | utopian.pay |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| sbd payout | 0.000 SBD |
| steem payout | 0.000 STEEM |
| vesting payout | 4.072058 VESTS |
| Transaction Info | Block #22169743/Virtual Operation #19 |
View Raw JSON Data
{
"block": 22169743,
"op": [
"comment_benefactor_reward",
{
"author": "instink",
"benefactor": "utopian.pay",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"sbd_payout": "0.000 SBD",
"steem_payout": "0.000 STEEM",
"vesting_payout": "4.072058 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2018-05-05T17:29:36",
"trx_id": "0000000000000000000000000000000000000000",
"trx_in_block": 4294967295,
"virtual_op": 19
}marilovichupvoted (100.00%) @instink / how-to-build-some-website-using-codeigniter-framework-or-php-or2018/04/30 02:08:00
marilovichupvoted (100.00%) @instink / how-to-build-some-website-using-codeigniter-framework-or-php-or
2018/04/30 02:08:00
| author | instink |
| permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| voter | marilovich |
| weight | 10000 (100.00%) |
| Transaction Info | Block #22007360/Trx fed2985b1ed6be6e5d48d08fcfed5053f0547881 |
View Raw JSON Data
{
"block": 22007360,
"op": [
"vote",
{
"author": "instink",
"permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or",
"voter": "marilovich",
"weight": 10000
}
],
"op_in_trx": 0,
"timestamp": "2018-04-30T02:08:00",
"trx_id": "fed2985b1ed6be6e5d48d08fcfed5053f0547881",
"trx_in_block": 2,
"virtual_op": 0
}lidchishanupvoted (100.00%) @instink / how-to-build-some-website-using-codeigniter-framework-or-php-or2018/04/30 02:07:57
lidchishanupvoted (100.00%) @instink / how-to-build-some-website-using-codeigniter-framework-or-php-or
2018/04/30 02:07:57
| author | instink |
| permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| voter | lidchishan |
| weight | 10000 (100.00%) |
| Transaction Info | Block #22007359/Trx e064d83818e03eee48c99a86670ef9f9747cd43c |
View Raw JSON Data
{
"block": 22007359,
"op": [
"vote",
{
"author": "instink",
"permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or",
"voter": "lidchishan",
"weight": 10000
}
],
"op_in_trx": 0,
"timestamp": "2018-04-30T02:07:57",
"trx_id": "e064d83818e03eee48c99a86670ef9f9747cd43c",
"trx_in_block": 35,
"virtual_op": 0
}2018/04/29 18:42:45
2018/04/29 18:42:45
| author | mcfarhat |
| body | Thank you for your contribution. While I liked the simplicity of your tutorial, yet it cannot be accepted due to the following reasons: * The idea of setting up codeigniter is too basic, and can be found elsewhere on the web. * With that in mind, your tutorial made a very simple function call to highlight the display of some info on the page, that is also too basic * You had many typos all across your tutorial, please pay more attention to your formal language. * If and when you use information from the web (for example the definition, and the image you used the source of which is not clear), please make sure to cite resources * And finally you also picked an incorrect repository. You should have chosen PHP, and the code you created would need to just be referenced with a link inside your post. ---------------------------------------------------------------------- Need help? Write a ticket on https://support.utopian.io. Chat with us on [Discord](https://discord.gg/uTyJkNm). **[[utopian-moderator]](https://utopian.io/moderators)** |
| json metadata | {"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"} |
| parent author | instink |
| parent permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| permlink | re-instink-how-to-build-some-website-using-codeigniter-framework-or-php-or-20180429t184221863z |
| title | |
| Transaction Info | Block #21998458/Trx d0be6c5f2bdcc7a508190d67fa9a69d5d902e640 |
View Raw JSON Data
{
"block": 21998458,
"op": [
"comment",
{
"author": "mcfarhat",
"body": "Thank you for your contribution.\nWhile I liked the simplicity of your tutorial, yet it cannot be accepted due to the following reasons:\n* The idea of setting up codeigniter is too basic, and can be found elsewhere on the web.\n* With that in mind, your tutorial made a very simple function call to highlight the display of some info on the page, that is also too basic\n* You had many typos all across your tutorial, please pay more attention to your formal language.\n* If and when you use information from the web (for example the definition, and the image you used the source of which is not clear), please make sure to cite resources\n* And finally you also picked an incorrect repository. You should have chosen PHP, and the code you created would need to just be referenced with a link inside your post.\n----------------------------------------------------------------------\nNeed help? Write a ticket on https://support.utopian.io.\nChat with us on [Discord](https://discord.gg/uTyJkNm).\n\n**[[utopian-moderator]](https://utopian.io/moderators)**",
"json_metadata": "{\"tags\":[\"utopian-io\"],\"community\":\"utopian\",\"app\":\"utopian/1.0.0\"}",
"parent_author": "instink",
"parent_permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or",
"permlink": "re-instink-how-to-build-some-website-using-codeigniter-framework-or-php-or-20180429t184221863z",
"title": ""
}
],
"op_in_trx": 0,
"timestamp": "2018-04-29T18:42:45",
"trx_id": "d0be6c5f2bdcc7a508190d67fa9a69d5d902e640",
"trx_in_block": 17,
"virtual_op": 0
}instinkpublished a new post: how-to-build-some-website-using-codeigniter-framework-or-php-or2018/04/29 18:38:06
instinkpublished a new post: how-to-build-some-website-using-codeigniter-framework-or-php-or
2018/04/29 18:38:06
| author | instink |
| body | #### What Will I Learn? - You will learn How to install codeigniter in your pc - You will learn How codeigniter structure work - You will learn How to use codeigniter #### Requirements - XAMPP - You Must Understand Basic of PHP - You Must Understand Basic of MYSQL - Code Editor Like Sublime Text Or Notepad ++, And Browser #### Difficulty - Basic #### Tutorial Contents Before i start this tutorial, first let's find out what is that codeigniter.  CodeIgniter is an open source application in the form of PHP framework with MVC model (Model, View, Controller) to build dynamic website using PHP. CodeIgniter makes it easy for developers to create web apps quickly and easy compared to making them from scratch. CodeIgniter was first released on February 28, 2006. The last stable version is version 3.0.4. What is that Framework? Frameworks can simply be defined as a collection of functions / procedures and classes for a particular purpose that is ready to be used so that it can simplify and speed up the work of a programmer, without having to create a function or class from scratch. And what is that MVC (Model, View, Controller)? **Model** Model, usually directly related to the database to manipulate data (insert, update, delete, search), handle validation from the controller section, but can not be directly related to the view. **View** View, is the part that handles presentation logic. In a web application this section is usually an HTML template file, which is controlled by the controller. View functions to receive and represent data to the user. This section does not have direct access to the model section. **Controller** Controller, is the part that manage the relationship between the model part and the view, the controller functions to receive requests and data from the user and then determine what will be processed by the application. Oke ... Lets see this image represent what is that Model, View, And Controller First your need to download codeigniter from codeigniter official website https://codeigniter.com and download it... after that put it into your htdocs folder and you will see two main folder and one main file just we need ... oke what is that ?  - Aplication Folder : this is where the application we will build is put. - Config Folder : where to store all the configuration files that are in the application, starting from the **database**, **router** and **autoload** applications. - Controllers Folder : Whre to store all the controller files. - Errors Folder : where to store all application error templates. - Helpers Folder : where the helper is not come from Codeigniter. - Hooks Folder : where the hook is used to change the function flow of Codeigniter cores. - Language Folder : where the languages will be stored. - Libraries Folder : where to keep all our own library. - Models Folder : where to store all models. - Views Folder : where to store all app view files. - System Folder : save all the files both the application file created and its core framework. - Cache Folder : where to store all cache created by caching library. - Codeigniter Folder : where to store all Codeigniter internals files. - Database Folder : where all database drivers and classes will be stored. - Fonts Folder : where to store all the fonts used image manipulation library. - Helpers Folder : where all Codeigniter helper cores are stored. -Language Folder : where all Codeigniter core languages are stored. - Libraries Folder : where to store all Codeigniter core libraries. - Logs Folder : where to store all logs generated by Codeigniter. - Plugins Folder : where to store all Codeigniter core plugins. - Scaffolding Folder : where to store all files that serve as scaffolding. - Index.php File : file that will be handle all requestsfrom the client. after that lets type localhost/website at your browser search bar, and you will see like this  thats mean you have been successfully install codeigniter on your computer In general, the arrangement of the url on CodeIgniter is: localhost/website/index.php/[controller-class]/[controller-method]/[arguments] So, before we just call Controller-Class only. While Controller-method and Arguments we have not used. Now we will create a new method in the Wellcome Controller. Open the Welcome.php file in application / controllers / Welcome.php folder. Then add the myapp method, like the following.  If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following.  To add a parameter, we only need to edit a few of the methods we have been created before:  If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp/myparameter. The result will look like the following.  but we should do it by displaying the result is not inside the controller file, we display it on the view page ... to display on the view page we will only add a bit to our myapp method like this  and we need to create some file in view folder i caled myapp.php  Copy this code into that file ``` <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>This is Myapp view</title> </head> <body> the result from controller wil be here: <?php echo $content; $param; ?> </body> </html> ``` If we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page we have created before  if we also want to add a model on our application we just need to edit a little more on our controller and send it to the view as we did before... open welcome contorller again and edit the code like this  oke... lets create some file in model folder i callded mymodel.php  and copy this code into mymodel.php file ``` class Mymodel extends CI_Model { public function datamodel() { echo 'this data form mymodel file'; } } ``` and lets edit our myapp.php file in view folder to display data from model like this  If we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page and will be desplay data from model file too  oke ... we are have been successfully created some website using codeigniter framework ... <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@instink/how-to-build-some-website-using-codeigniter-framework-or-php-or">Utopian.io - Rewarding Open Source Contributors</a></em><hr/> |
| json metadata | {"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":131513121,"name":"CI_Site","full_name":"naluri/CI_Site","html_url":"https://github.com/naluri/CI_Site","fork":false,"owner":{"login":"naluri"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","codeigniter","php","website","framework"],"links":["https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png","https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png","https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg","https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg","https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg","https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg","https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg","https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg","https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg","https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg","https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg","https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg","https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg","https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg","https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg"],"image":["https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png","https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png","https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg","https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg","https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg","https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg","https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg","https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg","https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg","https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg","https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg","https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg","https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg","https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg","https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg"],"moderator":{"account":"mcfarhat","time":"2018-04-29T18:38:04.167Z","pending":false,"reviewed":false,"flagged":true},"questions":null,"score":null,"total_influence":null,"staff_pick":null,"staff_pick_by":null,"config":{"questions":[{"question":"How many substantial concepts does this tutorial address?","question_id":"tuts-1","answers":[{"answer":"4-5 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-1","value":10},{"answer":"2-3 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-2","value":7},{"answer":"1 substantial concept covered in the tutorial.","answer_id":"tuts-1-a-3","value":3},{"answer":"More than 5 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-4","value":0}]},{"question":"Does the title and the outline of the tutorial properly reflect the content?","question_id":"tuts-2","answers":[{"answer":"Yes, it is very clear.","answer_id":"tuts-2-a-1","value":15},{"answer":"To some extent.","answer_id":"tuts-2-a-2","value":11.5},{"answer":"The title is somewhat misleading and/or the outline is not detailed or informative enough.","answer_id":"tuts-2-a-3","value":4.5},{"answer":"Title and outline are of little or no relevance to the content of the tutorial.","answer_id":"tuts-2-a-4","value":0}]},{"question":"Did the contributor provide supplementary resources, such as code and sample files in the contribution post or a linked GitHub repository?","question_id":"tuts-3","answers":[{"answer":"Yes, exceptional supplementary resources are provided including a relevant github repo/gist.","answer_id":"tuts-3-a-1","value":15},{"answer":"Supplementary resources provided are of high relevance.","answer_id":"tuts-3-a-2","value":12},{"answer":"Contributor provides minimal supplementary resources.","answer_id":"tuts-3-a-3","value":6},{"answer":"No supplementary resources were provided.","answer_id":"tuts-3-a-4","value":0}]},{"question":"Is the tutorial part of a series?","question_id":"tuts-4","answers":[{"answer":"Yes.","answer_id":"tuts-4-a-1","value":10},{"answer":"Yes, but it is the first entry in the series.","answer_id":"tuts-4-a-2","value":7},{"answer":"No, but it works just fine as a stand-alone tutorial.","answer_id":"tuts-4-a-3","value":5},{"answer":"No.","answer_id":"tuts-4-a-4","value":0}]},{"question":"Does the tutorial contain sufficient explanatory visuals?","question_id":"tuts-5","answers":[{"answer":"Yes, the visual components of the post were adequate in quality and quantity.","answer_id":"tuts-5-a-1","value":10},{"answer":"The volume of visual components included was unnecessarily large.","answer_id":"tuts-5-a-2","value":7},{"answer":"The post lacked sufficient visualization to easily learn from the content.","answer_id":"tuts-5-a-3","value":3},{"answer":"No visualization was presented in this contribution.","answer_id":"tuts-5-a-4","value":0}]},{"question":"How unique and/or innovative are the concepts covered in the tutorial?","question_id":"tuts-6","answers":[{"answer":"This was the first time I read about the concepts covered.","answer_id":"tuts-6-a-1","value":10},{"answer":"The concepts covered were innovative and offer some usefulness.","answer_id":"tuts-6-a-2","value":7},{"answer":"I have read several similar ideas and thoughts elsewhere, but this one was of higher quality.","answer_id":"tuts-6-a-3","value":5},{"answer":"Such tutorials can be found online with great ease and the contribution add no value to the open source community.","answer_id":"tuts-6-a-4","value":0}]},{"question":"How would you describe the formatting, language and overall presentation of the post?","question_id":"c-1","answers":[{"answer":"The post is of very high quality.","answer_id":"c-1-a-1","value":10},{"answer":"The post is of decent quality, but not spectacular in any way.","answer_id":"c-1-a-2","value":7},{"answer":"The post is poorly written and/or formatted, but readable.","answer_id":"c-1-a-3","value":3},{"answer":"The post is really hard to read and the content is barely understandable.","answer_id":"c-1-a-4","value":0}]},{"question":"How would you rate the overall value of this contribution on the open source community and ecosystem?","question_id":"c-2","answers":[{"answer":"This contribution brings great and impactful value, and can be used for applications outside the specific project.","answer_id":"c-2-a-1","value":20},{"answer":"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.","answer_id":"c-2-a-2","value":16},{"answer":"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.","answer_id":"c-2-a-3","value":8},{"answer":"This contribution adds no value to the open source community and ecosystem or the specific project.","answer_id":"c-2-a-4","value":0}]}]}} |
| parent author | |
| parent permlink | utopian-io |
| permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| title | How to build some website using codeigniter framework |PHP| |
| Transaction Info | Block #21998365/Trx 993d8c21967e3496eb7f6b87da3b1fbde78e7f83 |
View Raw JSON Data
{
"block": 21998365,
"op": [
"comment",
{
"author": "instink",
"body": "#### What Will I Learn?\n- You will learn How to install codeigniter in your pc\n- You will learn How codeigniter structure work\n- You will learn How to use codeigniter\n\n#### Requirements\n- XAMPP\n- You Must Understand Basic of PHP\n- You Must Understand Basic of MYSQL\n- Code Editor Like Sublime Text Or Notepad ++, And Browser\n\n#### Difficulty\n- Basic\n\n#### Tutorial Contents\nBefore i start this tutorial, first let's find out what is that codeigniter.\n\n\n\nCodeIgniter is an open source application in the form of PHP framework with MVC model (Model, View, Controller) to build dynamic website using PHP. CodeIgniter makes it easy for developers to create web apps quickly and easy compared to making them from scratch. CodeIgniter was first released on February 28, 2006. The last stable version is version 3.0.4. \n\nWhat is that Framework?\nFrameworks can simply be defined as a collection of functions / procedures and classes for a particular purpose that is ready to be used so that it can simplify and speed up the work of a programmer, without having to create a function or class from scratch.\n\nAnd what is that MVC (Model, View, Controller)?\n\n**Model**\n\nModel, usually directly related to the database to manipulate data (insert, update, delete, search), handle validation from the controller section, but can not be directly related to the view.\n\n**View**\n\nView, is the part that handles presentation logic. In a web application this section is usually an HTML template file, which is controlled by the controller. View functions to receive and represent data to the user. This section does not have direct access to the model section.\n\n**Controller**\n\nController, is the part that manage the relationship between the model part and the view, the controller functions to receive requests and data from the user and then determine what will be processed by the application.\n\nOke ... Lets see this image represent what is that Model, View, And Controller\n\nFirst your need to download codeigniter from codeigniter official website https://codeigniter.com\nand download it... \nafter that put it into your htdocs folder and you will see two main folder and one main file just we need ... oke what is that ?\n\n\n\n- Aplication Folder : this is where the application we will build is put.\n - Config Folder : where to store all the configuration files that are in the application, starting from \n the **database**, **router** and **autoload** applications.\n - Controllers Folder : Whre to store all the controller files.\n - Errors Folder : where to store all application error templates.\n - Helpers Folder : where the helper is not come from Codeigniter.\n - Hooks Folder : where the hook is used to change the function flow of Codeigniter cores.\n - Language Folder : where the languages will be stored.\n - Libraries Folder : where to keep all our own library.\n - Models Folder : where to store all models.\n - Views Folder : where to store all app view files.\n- System Folder : save all the files both the application file created and its core framework.\n - Cache Folder : where to store all cache created by caching library.\n - Codeigniter Folder : where to store all Codeigniter internals files.\n - Database Folder : where all database drivers and classes will be stored.\n - Fonts Folder : where to store all the fonts used image manipulation library.\n - Helpers Folder : where all Codeigniter helper cores are stored.\n -Language Folder : where all Codeigniter core languages are stored.\n - Libraries Folder : where to store all Codeigniter core libraries.\n - Logs Folder : where to store all logs generated by Codeigniter.\n - Plugins Folder : where to store all Codeigniter core plugins.\n - Scaffolding Folder : where to store all files that serve as scaffolding.\n- Index.php File : file that will be handle all requestsfrom the client.\n\nafter that lets type localhost/website at your browser search bar, and you will see like this\n\nthats mean you have been successfully install codeigniter on your computer \n \nIn general, the arrangement of the url on CodeIgniter is:\nlocalhost/website/index.php/[controller-class]/[controller-method]/[arguments]\n\nSo, before we just call Controller-Class only. While Controller-method and Arguments we have not used.\n\nNow we will create a new method in the Wellcome Controller. Open the Welcome.php file in application / controllers / Welcome.php folder. Then add the myapp method, like the following.\n\nIf we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following.\n\nTo add a parameter, we only need to edit a few of the methods we have been created before:\n\nIf we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp/myparameter. The result will look like the following.\n\n\nbut we should do it by displaying the result is not inside the controller file, we display it on the view page ...\nto display on the view page we will only add a bit to our myapp method like this\n\n\nand we need to create some file in view folder i caled myapp.php\n\n \nCopy this code into that file\n``` \n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n\t<meta charset=\"UTF-8\">\n\t<title>This is Myapp view</title>\n</head>\n<body>\n\tthe result from controller wil be here:\n\t<?php echo $content; $param; ?>\n</body>\n</html>\n```\nIf we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse \nbut in this case the result will be run on the view page we have created before\n\n\nif we also want to add a model on our application we just need to edit a little more on our controller and send it to the view as we did before...\nopen welcome contorller again and edit the code like this\n\n\noke... lets create some file in model folder i callded mymodel.php\n\nand copy this code into mymodel.php file\n``` \nclass Mymodel extends CI_Model {\n\n\tpublic function datamodel()\n\t{\n\t\techo 'this data form mymodel file';\n\t}\n}\n```\nand lets edit our myapp.php file in view folder to display data from model like this\n\n\nIf we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page and will be desplay data from model file too\n\n\n\noke ... we are have been successfully created some website using codeigniter framework ...\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@instink/how-to-build-some-website-using-codeigniter-framework-or-php-or\">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>",
"json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":131513121,\"name\":\"CI_Site\",\"full_name\":\"naluri/CI_Site\",\"html_url\":\"https://github.com/naluri/CI_Site\",\"fork\":false,\"owner\":{\"login\":\"naluri\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"codeigniter\",\"php\",\"website\",\"framework\"],\"links\":[\"https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png\",\"https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png\",\"https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg\",\"https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg\",\"https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg\",\"https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg\",\"https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg\",\"https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg\",\"https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg\",\"https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg\",\"https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg\",\"https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg\",\"https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg\",\"https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg\",\"https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg\"],\"image\":[\"https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png\",\"https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png\",\"https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg\",\"https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg\",\"https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg\",\"https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg\",\"https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg\",\"https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg\",\"https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg\",\"https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg\",\"https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg\",\"https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg\",\"https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg\",\"https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg\",\"https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg\"],\"moderator\":{\"account\":\"mcfarhat\",\"time\":\"2018-04-29T18:38:04.167Z\",\"pending\":false,\"reviewed\":false,\"flagged\":true},\"questions\":null,\"score\":null,\"total_influence\":null,\"staff_pick\":null,\"staff_pick_by\":null,\"config\":{\"questions\":[{\"question\":\"How many substantial concepts does this tutorial address?\",\"question_id\":\"tuts-1\",\"answers\":[{\"answer\":\"4-5 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-1\",\"value\":10},{\"answer\":\"2-3 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-2\",\"value\":7},{\"answer\":\"1 substantial concept covered in the tutorial.\",\"answer_id\":\"tuts-1-a-3\",\"value\":3},{\"answer\":\"More than 5 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-4\",\"value\":0}]},{\"question\":\"Does the title and the outline of the tutorial properly reflect the content?\",\"question_id\":\"tuts-2\",\"answers\":[{\"answer\":\"Yes, it is very clear.\",\"answer_id\":\"tuts-2-a-1\",\"value\":15},{\"answer\":\"To some extent.\",\"answer_id\":\"tuts-2-a-2\",\"value\":11.5},{\"answer\":\"The title is somewhat misleading and/or the outline is not detailed or informative enough.\",\"answer_id\":\"tuts-2-a-3\",\"value\":4.5},{\"answer\":\"Title and outline are of little or no relevance to the content of the tutorial.\",\"answer_id\":\"tuts-2-a-4\",\"value\":0}]},{\"question\":\"Did the contributor provide supplementary resources, such as code and sample files in the contribution post or a linked GitHub repository?\",\"question_id\":\"tuts-3\",\"answers\":[{\"answer\":\"Yes, exceptional supplementary resources are provided including a relevant github repo/gist.\",\"answer_id\":\"tuts-3-a-1\",\"value\":15},{\"answer\":\"Supplementary resources provided are of high relevance.\",\"answer_id\":\"tuts-3-a-2\",\"value\":12},{\"answer\":\"Contributor provides minimal supplementary resources.\",\"answer_id\":\"tuts-3-a-3\",\"value\":6},{\"answer\":\"No supplementary resources were provided.\",\"answer_id\":\"tuts-3-a-4\",\"value\":0}]},{\"question\":\"Is the tutorial part of a series?\",\"question_id\":\"tuts-4\",\"answers\":[{\"answer\":\"Yes.\",\"answer_id\":\"tuts-4-a-1\",\"value\":10},{\"answer\":\"Yes, but it is the first entry in the series.\",\"answer_id\":\"tuts-4-a-2\",\"value\":7},{\"answer\":\"No, but it works just fine as a stand-alone tutorial.\",\"answer_id\":\"tuts-4-a-3\",\"value\":5},{\"answer\":\"No.\",\"answer_id\":\"tuts-4-a-4\",\"value\":0}]},{\"question\":\"Does the tutorial contain sufficient explanatory visuals?\",\"question_id\":\"tuts-5\",\"answers\":[{\"answer\":\"Yes, the visual components of the post were adequate in quality and quantity.\",\"answer_id\":\"tuts-5-a-1\",\"value\":10},{\"answer\":\"The volume of visual components included was unnecessarily large.\",\"answer_id\":\"tuts-5-a-2\",\"value\":7},{\"answer\":\"The post lacked sufficient visualization to easily learn from the content.\",\"answer_id\":\"tuts-5-a-3\",\"value\":3},{\"answer\":\"No visualization was presented in this contribution.\",\"answer_id\":\"tuts-5-a-4\",\"value\":0}]},{\"question\":\"How unique and/or innovative are the concepts covered in the tutorial?\",\"question_id\":\"tuts-6\",\"answers\":[{\"answer\":\"This was the first time I read about the concepts covered.\",\"answer_id\":\"tuts-6-a-1\",\"value\":10},{\"answer\":\"The concepts covered were innovative and offer some usefulness.\",\"answer_id\":\"tuts-6-a-2\",\"value\":7},{\"answer\":\"I have read several similar ideas and thoughts elsewhere, but this one was of higher quality.\",\"answer_id\":\"tuts-6-a-3\",\"value\":5},{\"answer\":\"Such tutorials can be found online with great ease and the contribution add no value to the open source community.\",\"answer_id\":\"tuts-6-a-4\",\"value\":0}]},{\"question\":\"How would you describe the formatting, language and overall presentation of the post?\",\"question_id\":\"c-1\",\"answers\":[{\"answer\":\"The post is of very high quality.\",\"answer_id\":\"c-1-a-1\",\"value\":10},{\"answer\":\"The post is of decent quality, but not spectacular in any way.\",\"answer_id\":\"c-1-a-2\",\"value\":7},{\"answer\":\"The post is poorly written and/or formatted, but readable.\",\"answer_id\":\"c-1-a-3\",\"value\":3},{\"answer\":\"The post is really hard to read and the content is barely understandable.\",\"answer_id\":\"c-1-a-4\",\"value\":0}]},{\"question\":\"How would you rate the overall value of this contribution on the open source community and ecosystem?\",\"question_id\":\"c-2\",\"answers\":[{\"answer\":\"This contribution brings great and impactful value, and can be used for applications outside the specific project.\",\"answer_id\":\"c-2-a-1\",\"value\":20},{\"answer\":\"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.\",\"answer_id\":\"c-2-a-2\",\"value\":16},{\"answer\":\"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.\",\"answer_id\":\"c-2-a-3\",\"value\":8},{\"answer\":\"This contribution adds no value to the open source community and ecosystem or the specific project.\",\"answer_id\":\"c-2-a-4\",\"value\":0}]}]}}",
"parent_author": "",
"parent_permlink": "utopian-io",
"permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or",
"title": "How to build some website using codeigniter framework |PHP|"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-29T18:38:06",
"trx_id": "993d8c21967e3496eb7f6b87da3b1fbde78e7f83",
"trx_in_block": 10,
"virtual_op": 0
}instinkpublished a new post: how-to-build-some-website-using-codeigniter-framework-or-php-or2018/04/29 18:21:36
instinkpublished a new post: how-to-build-some-website-using-codeigniter-framework-or-php-or
2018/04/29 18:21:36
| author | instink |
| body | #### What Will I Learn? - You will learn How to install codeigniter in your pc - You will learn How codeigniter structure work - You will learn How to use codeigniter #### Requirements - XAMPP - You Must Understand Basic of PHP - You Must Understand Basic of MYSQL - Code Editor Like Sublime Text Or Notepad ++, And Browser #### Difficulty - Basic #### Tutorial Contents Before i start this tutorial, first let's find out what is that codeigniter.  CodeIgniter is an open source application in the form of PHP framework with MVC model (Model, View, Controller) to build dynamic website using PHP. CodeIgniter makes it easy for developers to create web apps quickly and easy compared to making them from scratch. CodeIgniter was first released on February 28, 2006. The last stable version is version 3.0.4. What is that Framework? Frameworks can simply be defined as a collection of functions / procedures and classes for a particular purpose that is ready to be used so that it can simplify and speed up the work of a programmer, without having to create a function or class from scratch. And what is that MVC (Model, View, Controller)? **Model** Model, usually directly related to the database to manipulate data (insert, update, delete, search), handle validation from the controller section, but can not be directly related to the view. **View** View, is the part that handles presentation logic. In a web application this section is usually an HTML template file, which is controlled by the controller. View functions to receive and represent data to the user. This section does not have direct access to the model section. **Controller** Controller, is the part that manage the relationship between the model part and the view, the controller functions to receive requests and data from the user and then determine what will be processed by the application. Oke ... Lets see this image represent what is that Model, View, And Controller First your need to download codeigniter from codeigniter official website https://codeigniter.com and download it... after that put it into your htdocs folder and you will see two main folder and one main file just we need ... oke what is that ?  - Aplication Folder : this is where the application we will build is put. - Config Folder : where to store all the configuration files that are in the application, starting from the **database**, **router** and **autoload** applications. - Controllers Folder : Whre to store all the controller files. - Errors Folder : where to store all application error templates. - Helpers Folder : where the helper is not come from Codeigniter. - Hooks Folder : where the hook is used to change the function flow of Codeigniter cores. - Language Folder : where the languages will be stored. - Libraries Folder : where to keep all our own library. - Models Folder : where to store all models. - Views Folder : where to store all app view files. - System Folder : save all the files both the application file created and its core framework. - Cache Folder : where to store all cache created by caching library. - Codeigniter Folder : where to store all Codeigniter internals files. - Database Folder : where all database drivers and classes will be stored. - Fonts Folder : where to store all the fonts used image manipulation library. - Helpers Folder : where all Codeigniter helper cores are stored. -Language Folder : where all Codeigniter core languages are stored. - Libraries Folder : where to store all Codeigniter core libraries. - Logs Folder : where to store all logs generated by Codeigniter. - Plugins Folder : where to store all Codeigniter core plugins. - Scaffolding Folder : where to store all files that serve as scaffolding. - Index.php File : file that will be handle all requestsfrom the client. after that lets type localhost/website at your browser search bar, and you will see like this  thats mean you have been successfully install codeigniter on your computer In general, the arrangement of the url on CodeIgniter is: localhost/website/index.php/[controller-class]/[controller-method]/[arguments] So, before we just call Controller-Class only. While Controller-method and Arguments we have not used. Now we will create a new method in the Wellcome Controller. Open the Welcome.php file in application / controllers / Welcome.php folder. Then add the myapp method, like the following.  If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following.  To add a parameter, we only need to edit a few of the methods we have been created before:  If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp/myparameter. The result will look like the following.  but we should do it by displaying the result is not inside the controller file, we display it on the view page ... to display on the view page we will only add a bit to our myapp method like this  and we need to create some file in view folder i caled myapp.php  Copy this code into that file ``` <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>This is Myapp view</title> </head> <body> the result from controller wil be here: <?php echo $content; $param; ?> </body> </html> ``` If we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page we have created before  if we also want to add a model on our application we just need to edit a little more on our controller and send it to the view as we did before... open welcome contorller again and edit the code like this  oke... lets create some file in model folder i callded mymodel.php  and copy this code into mymodel.php file ``` class Mymodel extends CI_Model { public function datamodel() { echo 'this data form mymodel file'; } } ``` and lets edit our myapp.php file in view folder to display data from model like this  If we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page and will be desplay data from model file too  oke ... we are have been successfully created some website using codeigniter framework ... <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@instink/how-to-build-some-website-using-codeigniter-framework-or-php-or">Utopian.io - Rewarding Open Source Contributors</a></em><hr/> |
| json metadata | {"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":131513121,"name":"CI_Site","full_name":"naluri/CI_Site","html_url":"https://github.com/naluri/CI_Site","fork":false,"owner":{"login":"naluri"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","codeigniter","php","website","framework"],"links":["https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png","https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png","https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg","https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg","https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg","https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg","https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg","https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg","https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg","https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg","https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg","https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg","https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg","https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg","https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg"],"image":["https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png","https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png","https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg","https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg","https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg","https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg","https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg","https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg","https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg","https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg","https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg","https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg","https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg","https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg","https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg"],"moderator":{"account":"mcfarhat","time":"2018-04-29T18:21:34.850Z","pending":true,"reviewed":false,"flagged":false},"questions":null,"score":null,"total_influence":null,"staff_pick":null,"staff_pick_by":null,"config":{"questions":[{"question":"How many substantial concepts does this tutorial address?","question_id":"tuts-1","answers":[{"answer":"4-5 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-1","value":10},{"answer":"2-3 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-2","value":7},{"answer":"1 substantial concept covered in the tutorial.","answer_id":"tuts-1-a-3","value":3},{"answer":"More than 5 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-4","value":0}]},{"question":"Does the title and the outline of the tutorial properly reflect the content?","question_id":"tuts-2","answers":[{"answer":"Yes, it is very clear.","answer_id":"tuts-2-a-1","value":15},{"answer":"To some extent.","answer_id":"tuts-2-a-2","value":11.5},{"answer":"The title is somewhat misleading and/or the outline is not detailed or informative enough.","answer_id":"tuts-2-a-3","value":4.5},{"answer":"Title and outline are of little or no relevance to the content of the tutorial.","answer_id":"tuts-2-a-4","value":0}]},{"question":"Did the contributor provide supplementary resources, such as code and sample files in the contribution post or a linked GitHub repository?","question_id":"tuts-3","answers":[{"answer":"Yes, exceptional supplementary resources are provided including a relevant github repo/gist.","answer_id":"tuts-3-a-1","value":15},{"answer":"Supplementary resources provided are of high relevance.","answer_id":"tuts-3-a-2","value":12},{"answer":"Contributor provides minimal supplementary resources.","answer_id":"tuts-3-a-3","value":6},{"answer":"No supplementary resources were provided.","answer_id":"tuts-3-a-4","value":0}]},{"question":"Is the tutorial part of a series?","question_id":"tuts-4","answers":[{"answer":"Yes.","answer_id":"tuts-4-a-1","value":10},{"answer":"Yes, but it is the first entry in the series.","answer_id":"tuts-4-a-2","value":7},{"answer":"No, but it works just fine as a stand-alone tutorial.","answer_id":"tuts-4-a-3","value":5},{"answer":"No.","answer_id":"tuts-4-a-4","value":0}]},{"question":"Does the tutorial contain sufficient explanatory visuals?","question_id":"tuts-5","answers":[{"answer":"Yes, the visual components of the post were adequate in quality and quantity.","answer_id":"tuts-5-a-1","value":10},{"answer":"The volume of visual components included was unnecessarily large.","answer_id":"tuts-5-a-2","value":7},{"answer":"The post lacked sufficient visualization to easily learn from the content.","answer_id":"tuts-5-a-3","value":3},{"answer":"No visualization was presented in this contribution.","answer_id":"tuts-5-a-4","value":0}]},{"question":"How unique and/or innovative are the concepts covered in the tutorial?","question_id":"tuts-6","answers":[{"answer":"This was the first time I read about the concepts covered.","answer_id":"tuts-6-a-1","value":10},{"answer":"The concepts covered were innovative and offer some usefulness.","answer_id":"tuts-6-a-2","value":7},{"answer":"I have read several similar ideas and thoughts elsewhere, but this one was of higher quality.","answer_id":"tuts-6-a-3","value":5},{"answer":"Such tutorials can be found online with great ease and the contribution add no value to the open source community.","answer_id":"tuts-6-a-4","value":0}]},{"question":"How would you describe the formatting, language and overall presentation of the post?","question_id":"c-1","answers":[{"answer":"The post is of very high quality.","answer_id":"c-1-a-1","value":10},{"answer":"The post is of decent quality, but not spectacular in any way.","answer_id":"c-1-a-2","value":7},{"answer":"The post is poorly written and/or formatted, but readable.","answer_id":"c-1-a-3","value":3},{"answer":"The post is really hard to read and the content is barely understandable.","answer_id":"c-1-a-4","value":0}]},{"question":"How would you rate the overall value of this contribution on the open source community and ecosystem?","question_id":"c-2","answers":[{"answer":"This contribution brings great and impactful value, and can be used for applications outside the specific project.","answer_id":"c-2-a-1","value":20},{"answer":"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.","answer_id":"c-2-a-2","value":16},{"answer":"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.","answer_id":"c-2-a-3","value":8},{"answer":"This contribution adds no value to the open source community and ecosystem or the specific project.","answer_id":"c-2-a-4","value":0}]}]}} |
| parent author | |
| parent permlink | utopian-io |
| permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| title | How to build some website using codeigniter framework |PHP| |
| Transaction Info | Block #21998035/Trx 73151cde89575c31fe45a21ad9278e2e2cc10010 |
View Raw JSON Data
{
"block": 21998035,
"op": [
"comment",
{
"author": "instink",
"body": "#### What Will I Learn?\n- You will learn How to install codeigniter in your pc\n- You will learn How codeigniter structure work\n- You will learn How to use codeigniter\n\n#### Requirements\n- XAMPP\n- You Must Understand Basic of PHP\n- You Must Understand Basic of MYSQL\n- Code Editor Like Sublime Text Or Notepad ++, And Browser\n\n#### Difficulty\n- Basic\n\n#### Tutorial Contents\nBefore i start this tutorial, first let's find out what is that codeigniter.\n\n\n\nCodeIgniter is an open source application in the form of PHP framework with MVC model (Model, View, Controller) to build dynamic website using PHP. CodeIgniter makes it easy for developers to create web apps quickly and easy compared to making them from scratch. CodeIgniter was first released on February 28, 2006. The last stable version is version 3.0.4. \n\nWhat is that Framework?\nFrameworks can simply be defined as a collection of functions / procedures and classes for a particular purpose that is ready to be used so that it can simplify and speed up the work of a programmer, without having to create a function or class from scratch.\n\nAnd what is that MVC (Model, View, Controller)?\n\n**Model**\n\nModel, usually directly related to the database to manipulate data (insert, update, delete, search), handle validation from the controller section, but can not be directly related to the view.\n\n**View**\n\nView, is the part that handles presentation logic. In a web application this section is usually an HTML template file, which is controlled by the controller. View functions to receive and represent data to the user. This section does not have direct access to the model section.\n\n**Controller**\n\nController, is the part that manage the relationship between the model part and the view, the controller functions to receive requests and data from the user and then determine what will be processed by the application.\n\nOke ... Lets see this image represent what is that Model, View, And Controller\n\nFirst your need to download codeigniter from codeigniter official website https://codeigniter.com\nand download it... \nafter that put it into your htdocs folder and you will see two main folder and one main file just we need ... oke what is that ?\n\n\n\n- Aplication Folder : this is where the application we will build is put.\n - Config Folder : where to store all the configuration files that are in the application, starting from \n the **database**, **router** and **autoload** applications.\n - Controllers Folder : Whre to store all the controller files.\n - Errors Folder : where to store all application error templates.\n - Helpers Folder : where the helper is not come from Codeigniter.\n - Hooks Folder : where the hook is used to change the function flow of Codeigniter cores.\n - Language Folder : where the languages will be stored.\n - Libraries Folder : where to keep all our own library.\n - Models Folder : where to store all models.\n - Views Folder : where to store all app view files.\n- System Folder : save all the files both the application file created and its core framework.\n - Cache Folder : where to store all cache created by caching library.\n - Codeigniter Folder : where to store all Codeigniter internals files.\n - Database Folder : where all database drivers and classes will be stored.\n - Fonts Folder : where to store all the fonts used image manipulation library.\n - Helpers Folder : where all Codeigniter helper cores are stored.\n -Language Folder : where all Codeigniter core languages are stored.\n - Libraries Folder : where to store all Codeigniter core libraries.\n - Logs Folder : where to store all logs generated by Codeigniter.\n - Plugins Folder : where to store all Codeigniter core plugins.\n - Scaffolding Folder : where to store all files that serve as scaffolding.\n- Index.php File : file that will be handle all requestsfrom the client.\n\nafter that lets type localhost/website at your browser search bar, and you will see like this\n\nthats mean you have been successfully install codeigniter on your computer \n \nIn general, the arrangement of the url on CodeIgniter is:\nlocalhost/website/index.php/[controller-class]/[controller-method]/[arguments]\n\nSo, before we just call Controller-Class only. While Controller-method and Arguments we have not used.\n\nNow we will create a new method in the Wellcome Controller. Open the Welcome.php file in application / controllers / Welcome.php folder. Then add the myapp method, like the following.\n\nIf we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following.\n\nTo add a parameter, we only need to edit a few of the methods we have been created before:\n\nIf we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp/myparameter. The result will look like the following.\n\n\nbut we should do it by displaying the result is not inside the controller file, we display it on the view page ...\nto display on the view page we will only add a bit to our myapp method like this\n\n\nand we need to create some file in view folder i caled myapp.php\n\n \nCopy this code into that file\n``` \n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n\t<meta charset=\"UTF-8\">\n\t<title>This is Myapp view</title>\n</head>\n<body>\n\tthe result from controller wil be here:\n\t<?php echo $content; $param; ?>\n</body>\n</html>\n```\nIf we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse \nbut in this case the result will be run on the view page we have created before\n\n\nif we also want to add a model on our application we just need to edit a little more on our controller and send it to the view as we did before...\nopen welcome contorller again and edit the code like this\n\n\noke... lets create some file in model folder i callded mymodel.php\n\nand copy this code into mymodel.php file\n``` \nclass Mymodel extends CI_Model {\n\n\tpublic function datamodel()\n\t{\n\t\techo 'this data form mymodel file';\n\t}\n}\n```\nand lets edit our myapp.php file in view folder to display data from model like this\n\n\nIf we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page and will be desplay data from model file too\n\n\n\noke ... we are have been successfully created some website using codeigniter framework ...\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@instink/how-to-build-some-website-using-codeigniter-framework-or-php-or\">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>",
"json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":131513121,\"name\":\"CI_Site\",\"full_name\":\"naluri/CI_Site\",\"html_url\":\"https://github.com/naluri/CI_Site\",\"fork\":false,\"owner\":{\"login\":\"naluri\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"codeigniter\",\"php\",\"website\",\"framework\"],\"links\":[\"https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png\",\"https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png\",\"https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg\",\"https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg\",\"https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg\",\"https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg\",\"https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg\",\"https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg\",\"https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg\",\"https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg\",\"https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg\",\"https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg\",\"https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg\",\"https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg\",\"https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg\"],\"image\":[\"https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png\",\"https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png\",\"https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg\",\"https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg\",\"https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg\",\"https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg\",\"https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg\",\"https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg\",\"https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg\",\"https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg\",\"https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg\",\"https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg\",\"https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg\",\"https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg\",\"https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg\"],\"moderator\":{\"account\":\"mcfarhat\",\"time\":\"2018-04-29T18:21:34.850Z\",\"pending\":true,\"reviewed\":false,\"flagged\":false},\"questions\":null,\"score\":null,\"total_influence\":null,\"staff_pick\":null,\"staff_pick_by\":null,\"config\":{\"questions\":[{\"question\":\"How many substantial concepts does this tutorial address?\",\"question_id\":\"tuts-1\",\"answers\":[{\"answer\":\"4-5 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-1\",\"value\":10},{\"answer\":\"2-3 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-2\",\"value\":7},{\"answer\":\"1 substantial concept covered in the tutorial.\",\"answer_id\":\"tuts-1-a-3\",\"value\":3},{\"answer\":\"More than 5 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-4\",\"value\":0}]},{\"question\":\"Does the title and the outline of the tutorial properly reflect the content?\",\"question_id\":\"tuts-2\",\"answers\":[{\"answer\":\"Yes, it is very clear.\",\"answer_id\":\"tuts-2-a-1\",\"value\":15},{\"answer\":\"To some extent.\",\"answer_id\":\"tuts-2-a-2\",\"value\":11.5},{\"answer\":\"The title is somewhat misleading and/or the outline is not detailed or informative enough.\",\"answer_id\":\"tuts-2-a-3\",\"value\":4.5},{\"answer\":\"Title and outline are of little or no relevance to the content of the tutorial.\",\"answer_id\":\"tuts-2-a-4\",\"value\":0}]},{\"question\":\"Did the contributor provide supplementary resources, such as code and sample files in the contribution post or a linked GitHub repository?\",\"question_id\":\"tuts-3\",\"answers\":[{\"answer\":\"Yes, exceptional supplementary resources are provided including a relevant github repo/gist.\",\"answer_id\":\"tuts-3-a-1\",\"value\":15},{\"answer\":\"Supplementary resources provided are of high relevance.\",\"answer_id\":\"tuts-3-a-2\",\"value\":12},{\"answer\":\"Contributor provides minimal supplementary resources.\",\"answer_id\":\"tuts-3-a-3\",\"value\":6},{\"answer\":\"No supplementary resources were provided.\",\"answer_id\":\"tuts-3-a-4\",\"value\":0}]},{\"question\":\"Is the tutorial part of a series?\",\"question_id\":\"tuts-4\",\"answers\":[{\"answer\":\"Yes.\",\"answer_id\":\"tuts-4-a-1\",\"value\":10},{\"answer\":\"Yes, but it is the first entry in the series.\",\"answer_id\":\"tuts-4-a-2\",\"value\":7},{\"answer\":\"No, but it works just fine as a stand-alone tutorial.\",\"answer_id\":\"tuts-4-a-3\",\"value\":5},{\"answer\":\"No.\",\"answer_id\":\"tuts-4-a-4\",\"value\":0}]},{\"question\":\"Does the tutorial contain sufficient explanatory visuals?\",\"question_id\":\"tuts-5\",\"answers\":[{\"answer\":\"Yes, the visual components of the post were adequate in quality and quantity.\",\"answer_id\":\"tuts-5-a-1\",\"value\":10},{\"answer\":\"The volume of visual components included was unnecessarily large.\",\"answer_id\":\"tuts-5-a-2\",\"value\":7},{\"answer\":\"The post lacked sufficient visualization to easily learn from the content.\",\"answer_id\":\"tuts-5-a-3\",\"value\":3},{\"answer\":\"No visualization was presented in this contribution.\",\"answer_id\":\"tuts-5-a-4\",\"value\":0}]},{\"question\":\"How unique and/or innovative are the concepts covered in the tutorial?\",\"question_id\":\"tuts-6\",\"answers\":[{\"answer\":\"This was the first time I read about the concepts covered.\",\"answer_id\":\"tuts-6-a-1\",\"value\":10},{\"answer\":\"The concepts covered were innovative and offer some usefulness.\",\"answer_id\":\"tuts-6-a-2\",\"value\":7},{\"answer\":\"I have read several similar ideas and thoughts elsewhere, but this one was of higher quality.\",\"answer_id\":\"tuts-6-a-3\",\"value\":5},{\"answer\":\"Such tutorials can be found online with great ease and the contribution add no value to the open source community.\",\"answer_id\":\"tuts-6-a-4\",\"value\":0}]},{\"question\":\"How would you describe the formatting, language and overall presentation of the post?\",\"question_id\":\"c-1\",\"answers\":[{\"answer\":\"The post is of very high quality.\",\"answer_id\":\"c-1-a-1\",\"value\":10},{\"answer\":\"The post is of decent quality, but not spectacular in any way.\",\"answer_id\":\"c-1-a-2\",\"value\":7},{\"answer\":\"The post is poorly written and/or formatted, but readable.\",\"answer_id\":\"c-1-a-3\",\"value\":3},{\"answer\":\"The post is really hard to read and the content is barely understandable.\",\"answer_id\":\"c-1-a-4\",\"value\":0}]},{\"question\":\"How would you rate the overall value of this contribution on the open source community and ecosystem?\",\"question_id\":\"c-2\",\"answers\":[{\"answer\":\"This contribution brings great and impactful value, and can be used for applications outside the specific project.\",\"answer_id\":\"c-2-a-1\",\"value\":20},{\"answer\":\"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.\",\"answer_id\":\"c-2-a-2\",\"value\":16},{\"answer\":\"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.\",\"answer_id\":\"c-2-a-3\",\"value\":8},{\"answer\":\"This contribution adds no value to the open source community and ecosystem or the specific project.\",\"answer_id\":\"c-2-a-4\",\"value\":0}]}]}}",
"parent_author": "",
"parent_permlink": "utopian-io",
"permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or",
"title": "How to build some website using codeigniter framework |PHP|"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-29T18:21:36",
"trx_id": "73151cde89575c31fe45a21ad9278e2e2cc10010",
"trx_in_block": 11,
"virtual_op": 0
}moby-dickupvoted (100.00%) @instink / how-to-build-some-website-using-codeigniter-framework-or-php-or2018/04/29 17:44:33
moby-dickupvoted (100.00%) @instink / how-to-build-some-website-using-codeigniter-framework-or-php-or
2018/04/29 17:44:33
| author | instink |
| permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| voter | moby-dick |
| weight | 10000 (100.00%) |
| Transaction Info | Block #21997294/Trx 19044df1d14c2e43d00d66728eb07e352827d5d3 |
View Raw JSON Data
{
"block": 21997294,
"op": [
"vote",
{
"author": "instink",
"permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or",
"voter": "moby-dick",
"weight": 10000
}
],
"op_in_trx": 0,
"timestamp": "2018-04-29T17:44:33",
"trx_id": "19044df1d14c2e43d00d66728eb07e352827d5d3",
"trx_in_block": 33,
"virtual_op": 0
}2018/04/29 17:10:54
2018/04/29 17:10:54
| author | instink |
| permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| voter | shibleehossain |
| weight | 10000 (100.00%) |
| Transaction Info | Block #21996621/Trx 802d08653a95a5321544ceaa59aa496a8b64978a |
View Raw JSON Data
{
"block": 21996621,
"op": [
"vote",
{
"author": "instink",
"permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or",
"voter": "shibleehossain",
"weight": 10000
}
],
"op_in_trx": 0,
"timestamp": "2018-04-29T17:10:54",
"trx_id": "802d08653a95a5321544ceaa59aa496a8b64978a",
"trx_in_block": 8,
"virtual_op": 0
}instinkupdated options for how-to-build-some-website-using-codeigniter-framework-or-php-or2018/04/29 17:08:30
instinkupdated options for how-to-build-some-website-using-codeigniter-framework-or-php-or
2018/04/29 17:08:30
| allow curation rewards | true |
| allow votes | true |
| author | instink |
| extensions | [[0,{"beneficiaries":[{"account":"utopian.pay","weight":1500}]}]] |
| max accepted payout | 1000000.000 SBD |
| percent steem dollars | 10000 |
| permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| Transaction Info | Block #21996573/Trx 8e0f8a5379c3d5fac4b482f37f0ee7519fb0f8bc |
View Raw JSON Data
{
"block": 21996573,
"op": [
"comment_options",
{
"allow_curation_rewards": true,
"allow_votes": true,
"author": "instink",
"extensions": [
[
0,
{
"beneficiaries": [
{
"account": "utopian.pay",
"weight": 1500
}
]
}
]
],
"max_accepted_payout": "1000000.000 SBD",
"percent_steem_dollars": 10000,
"permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-29T17:08:30",
"trx_id": "8e0f8a5379c3d5fac4b482f37f0ee7519fb0f8bc",
"trx_in_block": 6,
"virtual_op": 0
}instinkpublished a new post: how-to-build-some-website-using-codeigniter-framework-or-php-or2018/04/29 17:08:30
instinkpublished a new post: how-to-build-some-website-using-codeigniter-framework-or-php-or
2018/04/29 17:08:30
| author | instink |
| body | #### What Will I Learn? - You will learn How to install codeigniter in your pc - You will learn How codeigniter structure work - You will learn How to use codeigniter #### Requirements - XAMPP - You Must Understand Basic of PHP - You Must Understand Basic of MYSQL - Code Editor Like Sublime Text Or Notepad ++, And Browser #### Difficulty - Basic #### Tutorial Contents Before i start this tutorial, first let's find out what is that codeigniter.  CodeIgniter is an open source application in the form of PHP framework with MVC model (Model, View, Controller) to build dynamic website using PHP. CodeIgniter makes it easy for developers to create web apps quickly and easy compared to making them from scratch. CodeIgniter was first released on February 28, 2006. The last stable version is version 3.0.4. What is that Framework? Frameworks can simply be defined as a collection of functions / procedures and classes for a particular purpose that is ready to be used so that it can simplify and speed up the work of a programmer, without having to create a function or class from scratch. And what is that MVC (Model, View, Controller)? **Model** Model, usually directly related to the database to manipulate data (insert, update, delete, search), handle validation from the controller section, but can not be directly related to the view. **View** View, is the part that handles presentation logic. In a web application this section is usually an HTML template file, which is controlled by the controller. View functions to receive and represent data to the user. This section does not have direct access to the model section. **Controller** Controller, is the part that manage the relationship between the model part and the view, the controller functions to receive requests and data from the user and then determine what will be processed by the application. Oke ... Lets see this image represent what is that Model, View, And Controller First your need to download codeigniter from codeigniter official website https://codeigniter.com and download it... after that put it into your htdocs folder and you will see two main folder and one main file just we need ... oke what is that ?  - Aplication Folder : this is where the application we will build is put. - Config Folder : where to store all the configuration files that are in the application, starting from the **database**, **router** and **autoload** applications. - Controllers Folder : Whre to store all the controller files. - Errors Folder : where to store all application error templates. - Helpers Folder : where the helper is not come from Codeigniter. - Hooks Folder : where the hook is used to change the function flow of Codeigniter cores. - Language Folder : where the languages will be stored. - Libraries Folder : where to keep all our own library. - Models Folder : where to store all models. - Views Folder : where to store all app view files. - System Folder : save all the files both the application file created and its core framework. - Cache Folder : where to store all cache created by caching library. - Codeigniter Folder : where to store all Codeigniter internals files. - Database Folder : where all database drivers and classes will be stored. - Fonts Folder : where to store all the fonts used image manipulation library. - Helpers Folder : where all Codeigniter helper cores are stored. -Language Folder : where all Codeigniter core languages are stored. - Libraries Folder : where to store all Codeigniter core libraries. - Logs Folder : where to store all logs generated by Codeigniter. - Plugins Folder : where to store all Codeigniter core plugins. - Scaffolding Folder : where to store all files that serve as scaffolding. - Index.php File : file that will be handle all requestsfrom the client. after that lets type localhost/website at your browser search bar, and you will see like this  thats mean you have been successfully install codeigniter on your computer In general, the arrangement of the url on CodeIgniter is: localhost/website/index.php/[controller-class]/[controller-method]/[arguments] So, before we just call Controller-Class only. While Controller-method and Arguments we have not used. Now we will create a new method in the Wellcome Controller. Open the Welcome.php file in application / controllers / Welcome.php folder. Then add the myapp method, like the following.  If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following.  To add a parameter, we only need to edit a few of the methods we have been created before:  If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp/myparameter. The result will look like the following.  but we should do it by displaying the result is not inside the controller file, we display it on the view page ... to display on the view page we will only add a bit to our myapp method like this  and we need to create some file in view folder i caled myapp.php  Copy this code into that file ``` <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>This is Myapp view</title> </head> <body> the result from controller wil be here: <?php echo $content; $param; ?> </body> </html> ``` If we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page we have created before  if we also want to add a model on our application we just need to edit a little more on our controller and send it to the view as we did before... open welcome contorller again and edit the code like this  oke... lets create some file in model folder i callded mymodel.php  and copy this code into mymodel.php file ``` class Mymodel extends CI_Model { public function datamodel() { echo 'this data form mymodel file'; } } ``` and lets edit our myapp.php file in view folder to display data from model like this  If we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page and will be desplay data from model file too  oke ... we are have been successfully created some website using codeigniter framework ... <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@instink/how-to-build-some-website-using-codeigniter-framework-or-php-or">Utopian.io - Rewarding Open Source Contributors</a></em><hr/> |
| json metadata | {"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":131513121,"name":"CI_Site","full_name":"naluri/CI_Site","html_url":"https://github.com/naluri/CI_Site","fork":false,"owner":{"login":"naluri"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","codeigniter","php","website","framework"],"links":["https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png","https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png","https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg","https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg","https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg","https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg","https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg","https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg","https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg","https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg","https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg","https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg","https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg","https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg","https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg"],"image":["https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png","https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png","https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg","https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg","https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg","https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg","https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg","https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg","https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg","https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg","https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg","https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg","https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg","https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg","https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg"]} |
| parent author | |
| parent permlink | utopian-io |
| permlink | how-to-build-some-website-using-codeigniter-framework-or-php-or |
| title | How to build some website using codeigniter framework |PHP| |
| Transaction Info | Block #21996573/Trx 8e0f8a5379c3d5fac4b482f37f0ee7519fb0f8bc |
View Raw JSON Data
{
"block": 21996573,
"op": [
"comment",
{
"author": "instink",
"body": "#### What Will I Learn?\n- You will learn How to install codeigniter in your pc\n- You will learn How codeigniter structure work\n- You will learn How to use codeigniter\n\n#### Requirements\n- XAMPP\n- You Must Understand Basic of PHP\n- You Must Understand Basic of MYSQL\n- Code Editor Like Sublime Text Or Notepad ++, And Browser\n\n#### Difficulty\n- Basic\n\n#### Tutorial Contents\nBefore i start this tutorial, first let's find out what is that codeigniter.\n\n\n\nCodeIgniter is an open source application in the form of PHP framework with MVC model (Model, View, Controller) to build dynamic website using PHP. CodeIgniter makes it easy for developers to create web apps quickly and easy compared to making them from scratch. CodeIgniter was first released on February 28, 2006. The last stable version is version 3.0.4. \n\nWhat is that Framework?\nFrameworks can simply be defined as a collection of functions / procedures and classes for a particular purpose that is ready to be used so that it can simplify and speed up the work of a programmer, without having to create a function or class from scratch.\n\nAnd what is that MVC (Model, View, Controller)?\n\n**Model**\n\nModel, usually directly related to the database to manipulate data (insert, update, delete, search), handle validation from the controller section, but can not be directly related to the view.\n\n**View**\n\nView, is the part that handles presentation logic. In a web application this section is usually an HTML template file, which is controlled by the controller. View functions to receive and represent data to the user. This section does not have direct access to the model section.\n\n**Controller**\n\nController, is the part that manage the relationship between the model part and the view, the controller functions to receive requests and data from the user and then determine what will be processed by the application.\n\nOke ... Lets see this image represent what is that Model, View, And Controller\n\nFirst your need to download codeigniter from codeigniter official website https://codeigniter.com\nand download it... \nafter that put it into your htdocs folder and you will see two main folder and one main file just we need ... oke what is that ?\n\n\n\n- Aplication Folder : this is where the application we will build is put.\n - Config Folder : where to store all the configuration files that are in the application, starting from \n the **database**, **router** and **autoload** applications.\n - Controllers Folder : Whre to store all the controller files.\n - Errors Folder : where to store all application error templates.\n - Helpers Folder : where the helper is not come from Codeigniter.\n - Hooks Folder : where the hook is used to change the function flow of Codeigniter cores.\n - Language Folder : where the languages will be stored.\n - Libraries Folder : where to keep all our own library.\n - Models Folder : where to store all models.\n - Views Folder : where to store all app view files.\n- System Folder : save all the files both the application file created and its core framework.\n - Cache Folder : where to store all cache created by caching library.\n - Codeigniter Folder : where to store all Codeigniter internals files.\n - Database Folder : where all database drivers and classes will be stored.\n - Fonts Folder : where to store all the fonts used image manipulation library.\n - Helpers Folder : where all Codeigniter helper cores are stored.\n -Language Folder : where all Codeigniter core languages are stored.\n - Libraries Folder : where to store all Codeigniter core libraries.\n - Logs Folder : where to store all logs generated by Codeigniter.\n - Plugins Folder : where to store all Codeigniter core plugins.\n - Scaffolding Folder : where to store all files that serve as scaffolding.\n- Index.php File : file that will be handle all requestsfrom the client.\n\nafter that lets type localhost/website at your browser search bar, and you will see like this\n\nthats mean you have been successfully install codeigniter on your computer \n \nIn general, the arrangement of the url on CodeIgniter is:\nlocalhost/website/index.php/[controller-class]/[controller-method]/[arguments]\n\nSo, before we just call Controller-Class only. While Controller-method and Arguments we have not used.\n\nNow we will create a new method in the Wellcome Controller. Open the Welcome.php file in application / controllers / Welcome.php folder. Then add the myapp method, like the following.\n\nIf we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following.\n\nTo add a parameter, we only need to edit a few of the methods we have been created before:\n\nIf we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp/myparameter. The result will look like the following.\n\n\nbut we should do it by displaying the result is not inside the controller file, we display it on the view page ...\nto display on the view page we will only add a bit to our myapp method like this\n\n\nand we need to create some file in view folder i caled myapp.php\n\n \nCopy this code into that file\n``` \n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n\t<meta charset=\"UTF-8\">\n\t<title>This is Myapp view</title>\n</head>\n<body>\n\tthe result from controller wil be here:\n\t<?php echo $content; $param; ?>\n</body>\n</html>\n```\nIf we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse \nbut in this case the result will be run on the view page we have created before\n\n\nif we also want to add a model on our application we just need to edit a little more on our controller and send it to the view as we did before...\nopen welcome contorller again and edit the code like this\n\n\noke... lets create some file in model folder i callded mymodel.php\n\nand copy this code into mymodel.php file\n``` \nclass Mymodel extends CI_Model {\n\n\tpublic function datamodel()\n\t{\n\t\techo 'this data form mymodel file';\n\t}\n}\n```\nand lets edit our myapp.php file in view folder to display data from model like this\n\n\nIf we want to run it, we have to access url: http://localhost/website/index.php/welcome/myapp/myparameter like before we have been accesse but in this case the result will be run on the view page and will be desplay data from model file too\n\n\n\noke ... we are have been successfully created some website using codeigniter framework ...\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@instink/how-to-build-some-website-using-codeigniter-framework-or-php-or\">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>",
"json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":131513121,\"name\":\"CI_Site\",\"full_name\":\"naluri/CI_Site\",\"html_url\":\"https://github.com/naluri/CI_Site\",\"fork\":false,\"owner\":{\"login\":\"naluri\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"codeigniter\",\"php\",\"website\",\"framework\"],\"links\":[\"https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png\",\"https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png\",\"https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg\",\"https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg\",\"https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg\",\"https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg\",\"https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg\",\"https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg\",\"https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg\",\"https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg\",\"https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg\",\"https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg\",\"https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg\",\"https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg\",\"https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg\"],\"image\":[\"https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png\",\"https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png\",\"https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg\",\"https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg\",\"https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg\",\"https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg\",\"https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg\",\"https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg\",\"https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg\",\"https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg\",\"https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg\",\"https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg\",\"https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg\",\"https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg\",\"https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg\"]}",
"parent_author": "",
"parent_permlink": "utopian-io",
"permlink": "how-to-build-some-website-using-codeigniter-framework-or-php-or",
"title": "How to build some website using codeigniter framework |PHP|"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-29T17:08:30",
"trx_id": "8e0f8a5379c3d5fac4b482f37f0ee7519fb0f8bc",
"trx_in_block": 6,
"virtual_op": 0
}2018/04/29 01:10:06
2018/04/29 01:10:06
| author | steemitboard |
| body | Congratulations @instink! You have completed some achievement on Steemit and have been rewarded with new badge(s) : [](http://steemitboard.com/@instink) You published your First Post [](http://steemitboard.com/@instink) You got a First Vote Click on any badge to view your own Board of Honor on SteemitBoard. For more information about SteemitBoard, click [here](https://steemit.com/@steemitboard) If you no longer want to receive notifications, reply to this comment with the word `STOP` > Upvote this notification to help all Steemit users. Learn why [here](https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png)! |
| json metadata | {"image":["https://steemitboard.com/img/notifications.png"]} |
| parent author | instink |
| parent permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| permlink | steemitboard-notify-instink-20180429t011008000z |
| title | |
| Transaction Info | Block #21977407/Trx 7155850b0d5cbcb197185c1a9df1d945c884d4e2 |
View Raw JSON Data
{
"block": 21977407,
"op": [
"comment",
{
"author": "steemitboard",
"body": "Congratulations @instink! You have completed some achievement on Steemit and have been rewarded with new badge(s) :\n\n[](http://steemitboard.com/@instink) You published your First Post\n[](http://steemitboard.com/@instink) You got a First Vote\n\nClick on any badge to view your own Board of Honor on SteemitBoard.\nFor more information about SteemitBoard, click [here](https://steemit.com/@steemitboard)\n\nIf you no longer want to receive notifications, reply to this comment with the word `STOP`\n\n> Upvote this notification to help all Steemit users. Learn why [here](https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png)!",
"json_metadata": "{\"image\":[\"https://steemitboard.com/img/notifications.png\"]}",
"parent_author": "instink",
"parent_permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"permlink": "steemitboard-notify-instink-20180429t011008000z",
"title": ""
}
],
"op_in_trx": 0,
"timestamp": "2018-04-29T01:10:06",
"trx_id": "7155850b0d5cbcb197185c1a9df1d945c884d4e2",
"trx_in_block": 52,
"virtual_op": 0
}2018/04/28 18:57:03
2018/04/28 18:57:03
| author | portugalcoin |
| body | Your contribution cannot be approved because it does not follow the Utopian Rules. - Simple and easy to find tutorial on the internet on this subject. ---------------------------------------------------------------------- Need help? Write a ticket on https://support.utopian.io. Chat with us on [Discord](https://discord.gg/uTyJkNm). **[[utopian-moderator]](https://utopian.io/moderators)** |
| json metadata | {"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"} |
| parent author | instink |
| parent permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| permlink | re-instink-how-to-create-login-page-using-php-function-and-mysql-database-20180428t185701137z |
| title | |
| Transaction Info | Block #21969950/Trx 36c4a99f0f6e2d196e648f16bf1723838efe0a3c |
View Raw JSON Data
{
"block": 21969950,
"op": [
"comment",
{
"author": "portugalcoin",
"body": "Your contribution cannot be approved because it does not follow the Utopian Rules. \n- Simple and easy to find tutorial on the internet on this subject.\n\n----------------------------------------------------------------------\nNeed help? Write a ticket on https://support.utopian.io.\nChat with us on [Discord](https://discord.gg/uTyJkNm).\n\n**[[utopian-moderator]](https://utopian.io/moderators)**",
"json_metadata": "{\"tags\":[\"utopian-io\"],\"community\":\"utopian\",\"app\":\"utopian/1.0.0\"}",
"parent_author": "instink",
"parent_permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"permlink": "re-instink-how-to-create-login-page-using-php-function-and-mysql-database-20180428t185701137z",
"title": ""
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T18:57:03",
"trx_id": "36c4a99f0f6e2d196e648f16bf1723838efe0a3c",
"trx_in_block": 31,
"virtual_op": 0
}instinkpublished a new post: how-to-create-login-page-using-php-function-and-mysql-database2018/04/28 18:55:51
instinkpublished a new post: how-to-create-login-page-using-php-function-and-mysql-database
2018/04/28 18:55:51
| author | instink |
| body | What Will I Learn? Because in this tutorial i will create login system using php code and mysql as database, you will be learn both of that in one package ... Let's see what we got after learn this tutorial You will learn how to create table in mysql database using phpmyadmin, <br> You will learn how to connect your php to database, <br> You will learn how to create function using php code, <br> You will learn how to validate your login system using php Requirements You need to understand basic of XAMPP and Phpmyadmin, <br> You need to understand basic of PHP programming language, <br> You need to understand basic of HTML language, <br> You need to understand basic of SQL language Difficulty - Basic Tutorial Contents I think every websites must have a login system, because that's why this login system is very important not only the website using login system ... but smartphone too have a login system to keep the content still safe from people who are not have access on it ... This time I will try to share how to make system login in website using php as programming language and mysql as database ... But everyone have their own way to make login system ... this time I will create the login system using function in php ... First we need to create a database using phpmyadmin, let's type localhost/phpmyadmin in the search bar of your browser... before that you need to start your xampp first or you canot access that url.  Next it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ...  after that let's create your databse name... here i use **login_db** as my databse name... then clik the **buat** button or **create** in english...  after that let's create your table name... here i use **uses** as my table name... and specify the number of columns in your table ... here i create 4 for my column number, because i will create users_id for column one , users_fullname for column two, user_username for column three, users_password for coloumn four, if you not understand ... just follow first... after that just click **go** button at the bottom right  after that just follow this image, make sure auto increment (A_I) checked for auto fill that column, after that just click **simpan** button or **save** in english  until here we have finished creating the database and table that we will use to create our login system let's create one folder called login on your htdocs(xampp), inside that's folder create three files... first file i called connection.php second file i called function.php three file i called login.php .... as you can see this image showing what we have created on tree structure...  to connect our login system using php programming language let's copy this code into connection .php file where we have been created ``` <?php $connection = mysqli_connect('localhost', 'root', '', 'login_db'); if (!$connection) { echo 'connection failed'; } ``` mysql_connect(); is function for connection our aplication to our mysql database. in mysql_connect(); we have three parameters first is 'localhost' for our host, second 'root' is our username of mysql database, third '' is empty value for our password database, because my database have no password i just create like this '' fourth 'login_db' is the name of our database where we have been created... in the login.php file lets copy this code ``` <?php include "function.php"; $loginSuccess = ""; $loginFail = ""; if (isset($_POST['login'])) { if(login_process($_POST['username'], $_POST['password'])){ $loginSuccess = 'Login Success'; }else{ $loginFail = 'Login Failed'; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>login Page</title> <style> body { background: #2d343d; } .login { margin: 20px auto; width: 300px; padding: 30px 25px; background: white; border: 1px solid #c4c4c4; } h1.login-title { margin: -28px -25px 25px; padding: 15px 25px; line-height: 30px; font-size: 25px; font-weight: 300; color: #ADADAD; text-align:center; background: #f7f7f7; } .login-input { width: 285px; height: 50px; margin-bottom: 25px; padding-left:10px; font-size: 15px; background: #fff; border: 1px solid #ccc; border-radius: 4px; } .login-input:focus { border-color:#6e8095; outline: none; } .login-button { width: 100%; height: 50px; padding: 0; font-size: 20px; color: #fff; text-align: center; background: #f0776c; border: 0; border-radius: 5px; cursor: pointer; outline:0; } .login-lost { text-align:center; margin-bottom:0px; } .login-lost a { color:#666; text-decoration:none; font-size:13px; } </style> </head> <body> <form class="login" action="" method="post"> <h1 class="login-title">Login</h1> <?php if ($loginSuccess != '') { echo '<h4 style="color:green">'.$loginSuccess.'</h4>'; }elseif($loginFail != ''){ echo '<h4 style="color:red">'.$loginFail.'</h4>'; } ?> <input type="text" class="login-input" name="username" placeholder="Username" autofocus> <input type="password" class="login-input" name="password" placeholder="Password"> <input type="submit" name="login" value="Login" class="login-button"> </form> </body> </html> ``` and in the function.php file lets copy this code ``` <?php include "connection.php"; function login_process($username,$password){ $username = escape($username); $password = escape($password); global $connection; $query = "SELECT * FROM users WHERE users_username = '$username' AND users_password = '$password'"; $result = mysqli_query($connection, $query); if (mysqli_num_rows($result) > 0) { return true; } } function escape($data){ global $connection; $data = trim($data); $data = mysqli_real_escape_string($connection, $data); $data = htmlspecialchars($data, ENT_QUOTES); $data = strip_tags($data); return $data; } ?> ``` lets insert our data into our database first, open our phpmyadmin and click **tambahkan** or **insert **in english...  after you fill the form, just click **go** button  after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this: type your usernmae and password at the form and click login button  <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@instink/how-to-create-login-page-using-php-function-and-mysql-database">Utopian.io - Rewarding Open Source Contributors</a></em><hr/> |
| json metadata | {"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":51740069,"name":"fuck-login","full_name":"xchaoinfo/fuck-login","html_url":"https://github.com/xchaoinfo/fuck-login","fork":false,"owner":{"login":"xchaoinfo"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","php","programming","mysql","database"],"links":["https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg","https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg","https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg","https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg","https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg","https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg","https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg","https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg","https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg","https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg"],"image":["https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg","https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg","https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg","https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg","https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg","https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg","https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg","https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg","https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg","https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg"],"moderator":{"account":"portugalcoin","time":"2018-04-28T18:55:50.215Z","pending":false,"reviewed":false,"flagged":true},"questions":null,"score":null,"total_influence":null,"staff_pick":null,"staff_pick_by":null,"config":{"questions":[{"question":"How many substantial concepts does this tutorial address?","question_id":"tuts-1","answers":[{"answer":"4-5 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-1","value":10},{"answer":"2-3 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-2","value":7},{"answer":"1 substantial concept covered in the tutorial.","answer_id":"tuts-1-a-3","value":3},{"answer":"More than 5 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-4","value":0}]},{"question":"Does the title and the outline of the tutorial properly reflect the content?","question_id":"tuts-2","answers":[{"answer":"Yes, it is very clear.","answer_id":"tuts-2-a-1","value":15},{"answer":"To some extent.","answer_id":"tuts-2-a-2","value":11.5},{"answer":"The title is somewhat misleading and/or the outline is not detailed or informative enough.","answer_id":"tuts-2-a-3","value":4.5},{"answer":"Title and outline are of little or no relevance to the content of the tutorial.","answer_id":"tuts-2-a-4","value":0}]},{"question":"Did the contributor provide supplementary resources, such as code and sample files in the contribution post or a linked GitHub repository?","question_id":"tuts-3","answers":[{"answer":"Yes, exceptional supplementary resources are provided including a relevant github repo/gist.","answer_id":"tuts-3-a-1","value":15},{"answer":"Supplementary resources provided are of high relevance.","answer_id":"tuts-3-a-2","value":12},{"answer":"Contributor provides minimal supplementary resources.","answer_id":"tuts-3-a-3","value":6},{"answer":"No supplementary resources were provided.","answer_id":"tuts-3-a-4","value":0}]},{"question":"Is the tutorial part of a series?","question_id":"tuts-4","answers":[{"answer":"Yes.","answer_id":"tuts-4-a-1","value":10},{"answer":"Yes, but it is the first entry in the series.","answer_id":"tuts-4-a-2","value":7},{"answer":"No, but it works just fine as a stand-alone tutorial.","answer_id":"tuts-4-a-3","value":5},{"answer":"No.","answer_id":"tuts-4-a-4","value":0}]},{"question":"Does the tutorial contain sufficient explanatory visuals?","question_id":"tuts-5","answers":[{"answer":"Yes, the visual components of the post were adequate in quality and quantity.","answer_id":"tuts-5-a-1","value":10},{"answer":"The volume of visual components included was unnecessarily large.","answer_id":"tuts-5-a-2","value":7},{"answer":"The post lacked sufficient visualization to easily learn from the content.","answer_id":"tuts-5-a-3","value":3},{"answer":"No visualization was presented in this contribution.","answer_id":"tuts-5-a-4","value":0}]},{"question":"How unique and/or innovative are the concepts covered in the tutorial?","question_id":"tuts-6","answers":[{"answer":"This was the first time I read about the concepts covered.","answer_id":"tuts-6-a-1","value":10},{"answer":"The concepts covered were innovative and offer some usefulness.","answer_id":"tuts-6-a-2","value":7},{"answer":"I have read several similar ideas and thoughts elsewhere, but this one was of higher quality.","answer_id":"tuts-6-a-3","value":5},{"answer":"Such tutorials can be found online with great ease and the contribution add no value to the open source community.","answer_id":"tuts-6-a-4","value":0}]},{"question":"How would you describe the formatting, language and overall presentation of the post?","question_id":"c-1","answers":[{"answer":"The post is of very high quality.","answer_id":"c-1-a-1","value":10},{"answer":"The post is of decent quality, but not spectacular in any way.","answer_id":"c-1-a-2","value":7},{"answer":"The post is poorly written and/or formatted, but readable.","answer_id":"c-1-a-3","value":3},{"answer":"The post is really hard to read and the content is barely understandable.","answer_id":"c-1-a-4","value":0}]},{"question":"How would you rate the overall value of this contribution on the open source community and ecosystem?","question_id":"c-2","answers":[{"answer":"This contribution brings great and impactful value, and can be used for applications outside the specific project.","answer_id":"c-2-a-1","value":20},{"answer":"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.","answer_id":"c-2-a-2","value":16},{"answer":"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.","answer_id":"c-2-a-3","value":8},{"answer":"This contribution adds no value to the open source community and ecosystem or the specific project.","answer_id":"c-2-a-4","value":0}]}]}} |
| parent author | |
| parent permlink | utopian-io |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| title | how to create login page using php function and mysql database |
| Transaction Info | Block #21969926/Trx 5490e434331ee97f4bc120caae2a333341e9bf04 |
View Raw JSON Data
{
"block": 21969926,
"op": [
"comment",
{
"author": "instink",
"body": "What Will I Learn?\n\nBecause in this tutorial i will create login system using php code and mysql as database, you will be learn both of that in one package ... Let's see what we got after learn this tutorial \n\nYou will learn how to create table in mysql database using phpmyadmin, <br>\nYou will learn how to connect your php to database, <br>\nYou will learn how to create function using php code, <br>\nYou will learn how to validate your login system using php\n\nRequirements\n\nYou need to understand basic of XAMPP and Phpmyadmin, <br>\nYou need to understand basic of PHP programming language, <br>\nYou need to understand basic of HTML language, <br>\nYou need to understand basic of SQL language \n\nDifficulty\n- Basic\n\nTutorial Contents\n\nI think every websites must have a login system, because that's why this login system is very important not only the website using login system ... but smartphone too have a login system to keep the content still safe from people who are not have access on it ...\n\nThis time I will try to share how to make system login in website using php as programming language and mysql as database ...\n\nBut everyone have their own way to make login system ... this time I will create the login system using function in php ...\n\n\nFirst we need to create a database using phpmyadmin, let's type localhost/phpmyadmin in the search bar of your browser... before that you need to start your xampp first or you canot access that url.\n\n\n\nNext it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ...\n\n\nafter that let's create your databse name... here i use **login_db** as my databse name... then clik the **buat** button or **create** in english...\n\n\nafter that let's create your table name... here i use **uses** as my table name... and specify the number of columns in your table ... here i create 4 for my column number, because i will create \nusers_id for column one , users_fullname for column two, user_username for column three, users_password for coloumn four, if you not understand ... just follow first... \n after that just click **go** button at the bottom right\n\n\n\nafter that just follow this image, make sure auto increment (A_I) checked for auto fill that column, after that just click **simpan** button or **save** in english\n\n\nuntil here we have finished creating the database and table that we will use to create our login system\n\nlet's create one folder called login on your htdocs(xampp), inside that's folder create three files... first file i called connection.php second file i called function.php three file i called login.php .... as you can see this image showing what we have created on tree structure...\n\n\n\nto connect our login system using php programming language let's copy this code into connection .php file where we have been created \n\n``` \n<?php\n$connection = mysqli_connect('localhost', 'root', '', 'login_db');\nif (!$connection) {\n\techo 'connection failed';\n}\n```\nmysql_connect(); is function for connection our aplication to our mysql database.\nin mysql_connect(); we have three parameters first is 'localhost' for our host, second 'root' is our username of mysql database, third '' is empty value for our password database, because my database have no password i just create like this '' fourth 'login_db' is the name of our database where we have been created...\n\nin the login.php file lets copy this code\n``` \n<?php\ninclude \"function.php\";\n\t$loginSuccess = \"\";\n\t$loginFail = \"\";\n\tif (isset($_POST['login'])) {\n\t\tif(login_process($_POST['username'], $_POST['password'])){\n\t\t\t$loginSuccess = 'Login Success';\n\t\t}else{\n\t\t\t$loginFail = 'Login Failed';\n\t\t}\n\t}\n?>\n\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n\t<meta charset=\"UTF-8\">\n\t<title>login Page</title>\n\t<style>\n\t\tbody {\n background: #2d343d;\n}\n\n.login {\n margin: 20px auto;\n width: 300px;\n padding: 30px 25px;\n background: white;\n border: 1px solid #c4c4c4;\n}\n\nh1.login-title {\n margin: -28px -25px 25px;\n padding: 15px 25px;\n line-height: 30px;\n font-size: 25px;\n font-weight: 300;\n color: #ADADAD;\n text-align:center;\n background: #f7f7f7;\n \n}\n\n.login-input {\n width: 285px;\n height: 50px;\n margin-bottom: 25px;\n padding-left:10px;\n font-size: 15px;\n background: #fff;\n border: 1px solid #ccc;\n border-radius: 4px;\n}\n.login-input:focus {\n border-color:#6e8095;\n outline: none;\n }\n.login-button {\n width: 100%;\n height: 50px;\n padding: 0;\n font-size: 20px;\n color: #fff;\n text-align: center;\n background: #f0776c;\n border: 0;\n border-radius: 5px;\n cursor: pointer; \n outline:0;\n}\n\n.login-lost\n{\n text-align:center;\n margin-bottom:0px;\n}\n\n.login-lost a\n{\n color:#666;\n text-decoration:none;\n font-size:13px;\n}\n\n\t</style>\n</head>\n<body>\n\t<form class=\"login\" action=\"\" method=\"post\">\n <h1 class=\"login-title\">Login</h1>\n <?php if ($loginSuccess != '') {\n \techo '<h4 style=\"color:green\">'.$loginSuccess.'</h4>';\n }elseif($loginFail != ''){\n \techo '<h4 style=\"color:red\">'.$loginFail.'</h4>';\n } ?>\n <input type=\"text\" class=\"login-input\" name=\"username\" placeholder=\"Username\" autofocus>\n <input type=\"password\" class=\"login-input\" name=\"password\" placeholder=\"Password\">\n <input type=\"submit\" name=\"login\" value=\"Login\" class=\"login-button\">\n </form>\n</body>\n</html>\n```\nand in the function.php file lets copy this code\n``` \n<?php \ninclude \"connection.php\";\n\nfunction login_process($username,$password){\n\t$username = escape($username);\n\t$password = escape($password);\n\n\tglobal $connection;\n\t$query = \"SELECT * FROM users WHERE users_username = '$username' AND users_password = '$password'\";\n\t$result = mysqli_query($connection, $query);\n if (mysqli_num_rows($result) > 0) {\n return true;\n }\n}\n\nfunction escape($data){\n global $connection;\n $data = trim($data);\n $data = mysqli_real_escape_string($connection, $data);\n $data = htmlspecialchars($data, ENT_QUOTES);\n $data = strip_tags($data);\n return $data;\n}\n\n?>\n```\n\nlets insert our data into our database first, \nopen our phpmyadmin and click **tambahkan** or **insert **in english... \n\n\nafter you fill the form, just click **go** button\n\n\n after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this:\n\n type your usernmae and password at the form and click login button\n\n\n\n\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@instink/how-to-create-login-page-using-php-function-and-mysql-database\">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>",
"json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":51740069,\"name\":\"fuck-login\",\"full_name\":\"xchaoinfo/fuck-login\",\"html_url\":\"https://github.com/xchaoinfo/fuck-login\",\"fork\":false,\"owner\":{\"login\":\"xchaoinfo\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"php\",\"programming\",\"mysql\",\"database\"],\"links\":[\"https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg\",\"https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg\",\"https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg\",\"https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg\",\"https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg\",\"https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg\",\"https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg\",\"https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg\",\"https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg\",\"https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg\"],\"image\":[\"https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg\",\"https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg\",\"https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg\",\"https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg\",\"https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg\",\"https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg\",\"https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg\",\"https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg\",\"https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg\",\"https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg\"],\"moderator\":{\"account\":\"portugalcoin\",\"time\":\"2018-04-28T18:55:50.215Z\",\"pending\":false,\"reviewed\":false,\"flagged\":true},\"questions\":null,\"score\":null,\"total_influence\":null,\"staff_pick\":null,\"staff_pick_by\":null,\"config\":{\"questions\":[{\"question\":\"How many substantial concepts does this tutorial address?\",\"question_id\":\"tuts-1\",\"answers\":[{\"answer\":\"4-5 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-1\",\"value\":10},{\"answer\":\"2-3 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-2\",\"value\":7},{\"answer\":\"1 substantial concept covered in the tutorial.\",\"answer_id\":\"tuts-1-a-3\",\"value\":3},{\"answer\":\"More than 5 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-4\",\"value\":0}]},{\"question\":\"Does the title and the outline of the tutorial properly reflect the content?\",\"question_id\":\"tuts-2\",\"answers\":[{\"answer\":\"Yes, it is very clear.\",\"answer_id\":\"tuts-2-a-1\",\"value\":15},{\"answer\":\"To some extent.\",\"answer_id\":\"tuts-2-a-2\",\"value\":11.5},{\"answer\":\"The title is somewhat misleading and/or the outline is not detailed or informative enough.\",\"answer_id\":\"tuts-2-a-3\",\"value\":4.5},{\"answer\":\"Title and outline are of little or no relevance to the content of the tutorial.\",\"answer_id\":\"tuts-2-a-4\",\"value\":0}]},{\"question\":\"Did the contributor provide supplementary resources, such as code and sample files in the contribution post or a linked GitHub repository?\",\"question_id\":\"tuts-3\",\"answers\":[{\"answer\":\"Yes, exceptional supplementary resources are provided including a relevant github repo/gist.\",\"answer_id\":\"tuts-3-a-1\",\"value\":15},{\"answer\":\"Supplementary resources provided are of high relevance.\",\"answer_id\":\"tuts-3-a-2\",\"value\":12},{\"answer\":\"Contributor provides minimal supplementary resources.\",\"answer_id\":\"tuts-3-a-3\",\"value\":6},{\"answer\":\"No supplementary resources were provided.\",\"answer_id\":\"tuts-3-a-4\",\"value\":0}]},{\"question\":\"Is the tutorial part of a series?\",\"question_id\":\"tuts-4\",\"answers\":[{\"answer\":\"Yes.\",\"answer_id\":\"tuts-4-a-1\",\"value\":10},{\"answer\":\"Yes, but it is the first entry in the series.\",\"answer_id\":\"tuts-4-a-2\",\"value\":7},{\"answer\":\"No, but it works just fine as a stand-alone tutorial.\",\"answer_id\":\"tuts-4-a-3\",\"value\":5},{\"answer\":\"No.\",\"answer_id\":\"tuts-4-a-4\",\"value\":0}]},{\"question\":\"Does the tutorial contain sufficient explanatory visuals?\",\"question_id\":\"tuts-5\",\"answers\":[{\"answer\":\"Yes, the visual components of the post were adequate in quality and quantity.\",\"answer_id\":\"tuts-5-a-1\",\"value\":10},{\"answer\":\"The volume of visual components included was unnecessarily large.\",\"answer_id\":\"tuts-5-a-2\",\"value\":7},{\"answer\":\"The post lacked sufficient visualization to easily learn from the content.\",\"answer_id\":\"tuts-5-a-3\",\"value\":3},{\"answer\":\"No visualization was presented in this contribution.\",\"answer_id\":\"tuts-5-a-4\",\"value\":0}]},{\"question\":\"How unique and/or innovative are the concepts covered in the tutorial?\",\"question_id\":\"tuts-6\",\"answers\":[{\"answer\":\"This was the first time I read about the concepts covered.\",\"answer_id\":\"tuts-6-a-1\",\"value\":10},{\"answer\":\"The concepts covered were innovative and offer some usefulness.\",\"answer_id\":\"tuts-6-a-2\",\"value\":7},{\"answer\":\"I have read several similar ideas and thoughts elsewhere, but this one was of higher quality.\",\"answer_id\":\"tuts-6-a-3\",\"value\":5},{\"answer\":\"Such tutorials can be found online with great ease and the contribution add no value to the open source community.\",\"answer_id\":\"tuts-6-a-4\",\"value\":0}]},{\"question\":\"How would you describe the formatting, language and overall presentation of the post?\",\"question_id\":\"c-1\",\"answers\":[{\"answer\":\"The post is of very high quality.\",\"answer_id\":\"c-1-a-1\",\"value\":10},{\"answer\":\"The post is of decent quality, but not spectacular in any way.\",\"answer_id\":\"c-1-a-2\",\"value\":7},{\"answer\":\"The post is poorly written and/or formatted, but readable.\",\"answer_id\":\"c-1-a-3\",\"value\":3},{\"answer\":\"The post is really hard to read and the content is barely understandable.\",\"answer_id\":\"c-1-a-4\",\"value\":0}]},{\"question\":\"How would you rate the overall value of this contribution on the open source community and ecosystem?\",\"question_id\":\"c-2\",\"answers\":[{\"answer\":\"This contribution brings great and impactful value, and can be used for applications outside the specific project.\",\"answer_id\":\"c-2-a-1\",\"value\":20},{\"answer\":\"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.\",\"answer_id\":\"c-2-a-2\",\"value\":16},{\"answer\":\"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.\",\"answer_id\":\"c-2-a-3\",\"value\":8},{\"answer\":\"This contribution adds no value to the open source community and ecosystem or the specific project.\",\"answer_id\":\"c-2-a-4\",\"value\":0}]}]}}",
"parent_author": "",
"parent_permlink": "utopian-io",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"title": "how to create login page using php function and mysql database"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T18:55:51",
"trx_id": "5490e434331ee97f4bc120caae2a333341e9bf04",
"trx_in_block": 62,
"virtual_op": 0
}ax3upvoted (1.00%) @instink / how-to-create-login-page-using-php-function-and-mysql-database2018/04/28 18:49:15
ax3upvoted (1.00%) @instink / how-to-create-login-page-using-php-function-and-mysql-database
2018/04/28 18:49:15
| author | instink |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| voter | ax3 |
| weight | 100 (1.00%) |
| Transaction Info | Block #21969794/Trx 19d3816394671f2b4ef69314adc3e07c5983934f |
View Raw JSON Data
{
"block": 21969794,
"op": [
"vote",
{
"author": "instink",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"voter": "ax3",
"weight": 100
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T18:49:15",
"trx_id": "19d3816394671f2b4ef69314adc3e07c5983934f",
"trx_in_block": 132,
"virtual_op": 0
}2018/04/28 18:49:12
2018/04/28 18:49:12
| author | introduce.bot |
| body | ✅ @instink, congratulations on making your first post! **I gave you a $.05 vote!** <br>Will you give me a follow? I'll follow you back in return! |
| json metadata | |
| parent author | instink |
| parent permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| permlink | introduce-bot-re-instinkhow-to-create-login-page-using-php-function-and-mysql-database |
| title | |
| Transaction Info | Block #21969793/Trx 1595b1396118d42f1c27d1b7c596229ebf202d3b |
View Raw JSON Data
{
"block": 21969793,
"op": [
"comment",
{
"author": "introduce.bot",
"body": "✅ @instink, congratulations on making your first post! **I gave you a $.05 vote!** <br>Will you give me a follow? I'll follow you back in return!",
"json_metadata": "",
"parent_author": "instink",
"parent_permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"permlink": "introduce-bot-re-instinkhow-to-create-login-page-using-php-function-and-mysql-database",
"title": ""
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T18:49:12",
"trx_id": "1595b1396118d42f1c27d1b7c596229ebf202d3b",
"trx_in_block": 25,
"virtual_op": 0
}2018/04/28 18:49:12
2018/04/28 18:49:12
| author | instink |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| voter | introduce.bot |
| weight | 191 (1.91%) |
| Transaction Info | Block #21969793/Trx d4e3d56ccc416ddef5913455d299107838b7a9ea |
View Raw JSON Data
{
"block": 21969793,
"op": [
"vote",
{
"author": "instink",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"voter": "introduce.bot",
"weight": 191
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T18:49:12",
"trx_id": "d4e3d56ccc416ddef5913455d299107838b7a9ea",
"trx_in_block": 7,
"virtual_op": 0
}instinkpublished a new post: how-to-create-login-page-using-php-function-and-mysql-database2018/04/28 18:49:00
instinkpublished a new post: how-to-create-login-page-using-php-function-and-mysql-database
2018/04/28 18:49:00
| author | instink |
| body | What Will I Learn? Because in this tutorial i will create login system using php code and mysql as database, you will be learn both of that in one package ... Let's see what we got after learn this tutorial You will learn how to create table in mysql database using phpmyadmin, <br> You will learn how to connect your php to database, <br> You will learn how to create function using php code, <br> You will learn how to validate your login system using php Requirements You need to understand basic of XAMPP and Phpmyadmin, <br> You need to understand basic of PHP programming language, <br> You need to understand basic of HTML language, <br> You need to understand basic of SQL language Difficulty - Basic Tutorial Contents I think every websites must have a login system, because that's why this login system is very important not only the website using login system ... but smartphone too have a login system to keep the content still safe from people who are not have access on it ... This time I will try to share how to make system login in website using php as programming language and mysql as database ... But everyone have their own way to make login system ... this time I will create the login system using function in php ... First we need to create a database using phpmyadmin, let's type localhost/phpmyadmin in the search bar of your browser... before that you need to start your xampp first or you canot access that url.  Next it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ...  after that let's create your databse name... here i use **login_db** as my databse name... then clik the **buat** button or **create** in english...  after that let's create your table name... here i use **uses** as my table name... and specify the number of columns in your table ... here i create 4 for my column number, because i will create users_id for column one , users_fullname for column two, user_username for column three, users_password for coloumn four, if you not understand ... just follow first... after that just click **go** button at the bottom right  after that just follow this image, make sure auto increment (A_I) checked for auto fill that column, after that just click **simpan** button or **save** in english  until here we have finished creating the database and table that we will use to create our login system let's create one folder called login on your htdocs(xampp), inside that's folder create three files... first file i called connection.php second file i called function.php three file i called login.php .... as you can see this image showing what we have created on tree structure...  to connect our login system using php programming language let's copy this code into connection .php file where we have been created ``` <?php $connection = mysqli_connect('localhost', 'root', '', 'login_db'); if (!$connection) { echo 'connection failed'; } ``` mysql_connect(); is function for connection our aplication to our mysql database. in mysql_connect(); we have three parameters first is 'localhost' for our host, second 'root' is our username of mysql database, third '' is empty value for our password database, because my database have no password i just create like this '' fourth 'login_db' is the name of our database where we have been created... in the login.php file lets copy this code ``` <?php include "function.php"; $loginSuccess = ""; $loginFail = ""; if (isset($_POST['login'])) { if(login_process($_POST['username'], $_POST['password'])){ $loginSuccess = 'Login Success'; }else{ $loginFail = 'Login Failed'; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>login Page</title> <style> body { background: #2d343d; } .login { margin: 20px auto; width: 300px; padding: 30px 25px; background: white; border: 1px solid #c4c4c4; } h1.login-title { margin: -28px -25px 25px; padding: 15px 25px; line-height: 30px; font-size: 25px; font-weight: 300; color: #ADADAD; text-align:center; background: #f7f7f7; } .login-input { width: 285px; height: 50px; margin-bottom: 25px; padding-left:10px; font-size: 15px; background: #fff; border: 1px solid #ccc; border-radius: 4px; } .login-input:focus { border-color:#6e8095; outline: none; } .login-button { width: 100%; height: 50px; padding: 0; font-size: 20px; color: #fff; text-align: center; background: #f0776c; border: 0; border-radius: 5px; cursor: pointer; outline:0; } .login-lost { text-align:center; margin-bottom:0px; } .login-lost a { color:#666; text-decoration:none; font-size:13px; } </style> </head> <body> <form class="login" action="" method="post"> <h1 class="login-title">Login</h1> <?php if ($loginSuccess != '') { echo '<h4 style="color:green">'.$loginSuccess.'</h4>'; }elseif($loginFail != ''){ echo '<h4 style="color:red">'.$loginFail.'</h4>'; } ?> <input type="text" class="login-input" name="username" placeholder="Username" autofocus> <input type="password" class="login-input" name="password" placeholder="Password"> <input type="submit" name="login" value="Login" class="login-button"> </form> </body> </html> ``` and in the function.php file lets copy this code ``` <?php include "connection.php"; function login_process($username,$password){ $username = escape($username); $password = escape($password); global $connection; $query = "SELECT * FROM users WHERE users_username = '$username' AND users_password = '$password'"; $result = mysqli_query($connection, $query); if (mysqli_num_rows($result) > 0) { return true; } } function escape($data){ global $connection; $data = trim($data); $data = mysqli_real_escape_string($connection, $data); $data = htmlspecialchars($data, ENT_QUOTES); $data = strip_tags($data); return $data; } ?> ``` lets insert our data into our database first, open our phpmyadmin and click **tambahkan** or **insert **in english...  after you fill the form, just click **go** button  after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this: type your usernmae and password at the form and click login button  <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@instink/how-to-create-login-page-using-php-function-and-mysql-database">Utopian.io - Rewarding Open Source Contributors</a></em><hr/> |
| json metadata | {"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":51740069,"name":"fuck-login","full_name":"xchaoinfo/fuck-login","html_url":"https://github.com/xchaoinfo/fuck-login","fork":false,"owner":{"login":"xchaoinfo"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","php","programming","mysql","database"],"links":["https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg","https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg","https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg","https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg","https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg","https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg","https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg","https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg","https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg","https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg"],"image":["https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg","https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg","https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg","https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg","https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg","https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg","https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg","https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg","https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg","https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg"],"moderator":{"account":"portugalcoin","time":"2018-04-28T18:49:00.402Z","pending":true,"reviewed":false,"flagged":false},"questions":null,"score":null,"total_influence":null,"staff_pick":null,"staff_pick_by":null,"config":{"questions":[{"question":"How many substantial concepts does this tutorial address?","question_id":"tuts-1","answers":[{"answer":"4-5 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-1","value":10},{"answer":"2-3 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-2","value":7},{"answer":"1 substantial concept covered in the tutorial.","answer_id":"tuts-1-a-3","value":3},{"answer":"More than 5 substantial concepts covered in the tutorial.","answer_id":"tuts-1-a-4","value":0}]},{"question":"Does the title and the outline of the tutorial properly reflect the content?","question_id":"tuts-2","answers":[{"answer":"Yes, it is very clear.","answer_id":"tuts-2-a-1","value":15},{"answer":"To some extent.","answer_id":"tuts-2-a-2","value":11.5},{"answer":"The title is somewhat misleading and/or the outline is not detailed or informative enough.","answer_id":"tuts-2-a-3","value":4.5},{"answer":"Title and outline are of little or no relevance to the content of the tutorial.","answer_id":"tuts-2-a-4","value":0}]},{"question":"Did the contributor provide supplementary resources, such as code and sample files in the contribution post or a linked GitHub repository?","question_id":"tuts-3","answers":[{"answer":"Yes, exceptional supplementary resources are provided including a relevant github repo/gist.","answer_id":"tuts-3-a-1","value":15},{"answer":"Supplementary resources provided are of high relevance.","answer_id":"tuts-3-a-2","value":12},{"answer":"Contributor provides minimal supplementary resources.","answer_id":"tuts-3-a-3","value":6},{"answer":"No supplementary resources were provided.","answer_id":"tuts-3-a-4","value":0}]},{"question":"Is the tutorial part of a series?","question_id":"tuts-4","answers":[{"answer":"Yes.","answer_id":"tuts-4-a-1","value":10},{"answer":"Yes, but it is the first entry in the series.","answer_id":"tuts-4-a-2","value":7},{"answer":"No, but it works just fine as a stand-alone tutorial.","answer_id":"tuts-4-a-3","value":5},{"answer":"No.","answer_id":"tuts-4-a-4","value":0}]},{"question":"Does the tutorial contain sufficient explanatory visuals?","question_id":"tuts-5","answers":[{"answer":"Yes, the visual components of the post were adequate in quality and quantity.","answer_id":"tuts-5-a-1","value":10},{"answer":"The volume of visual components included was unnecessarily large.","answer_id":"tuts-5-a-2","value":7},{"answer":"The post lacked sufficient visualization to easily learn from the content.","answer_id":"tuts-5-a-3","value":3},{"answer":"No visualization was presented in this contribution.","answer_id":"tuts-5-a-4","value":0}]},{"question":"How unique and/or innovative are the concepts covered in the tutorial?","question_id":"tuts-6","answers":[{"answer":"This was the first time I read about the concepts covered.","answer_id":"tuts-6-a-1","value":10},{"answer":"The concepts covered were innovative and offer some usefulness.","answer_id":"tuts-6-a-2","value":7},{"answer":"I have read several similar ideas and thoughts elsewhere, but this one was of higher quality.","answer_id":"tuts-6-a-3","value":5},{"answer":"Such tutorials can be found online with great ease and the contribution add no value to the open source community.","answer_id":"tuts-6-a-4","value":0}]},{"question":"How would you describe the formatting, language and overall presentation of the post?","question_id":"c-1","answers":[{"answer":"The post is of very high quality.","answer_id":"c-1-a-1","value":10},{"answer":"The post is of decent quality, but not spectacular in any way.","answer_id":"c-1-a-2","value":7},{"answer":"The post is poorly written and/or formatted, but readable.","answer_id":"c-1-a-3","value":3},{"answer":"The post is really hard to read and the content is barely understandable.","answer_id":"c-1-a-4","value":0}]},{"question":"How would you rate the overall value of this contribution on the open source community and ecosystem?","question_id":"c-2","answers":[{"answer":"This contribution brings great and impactful value, and can be used for applications outside the specific project.","answer_id":"c-2-a-1","value":20},{"answer":"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.","answer_id":"c-2-a-2","value":16},{"answer":"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.","answer_id":"c-2-a-3","value":8},{"answer":"This contribution adds no value to the open source community and ecosystem or the specific project.","answer_id":"c-2-a-4","value":0}]}]}} |
| parent author | |
| parent permlink | utopian-io |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| title | how to create login page using php function and mysql database |
| Transaction Info | Block #21969789/Trx 823d95b6a1c1450ed3535d40be3bb808306c1be8 |
View Raw JSON Data
{
"block": 21969789,
"op": [
"comment",
{
"author": "instink",
"body": "What Will I Learn?\n\nBecause in this tutorial i will create login system using php code and mysql as database, you will be learn both of that in one package ... Let's see what we got after learn this tutorial \n\nYou will learn how to create table in mysql database using phpmyadmin, <br>\nYou will learn how to connect your php to database, <br>\nYou will learn how to create function using php code, <br>\nYou will learn how to validate your login system using php\n\nRequirements\n\nYou need to understand basic of XAMPP and Phpmyadmin, <br>\nYou need to understand basic of PHP programming language, <br>\nYou need to understand basic of HTML language, <br>\nYou need to understand basic of SQL language \n\nDifficulty\n- Basic\n\nTutorial Contents\n\nI think every websites must have a login system, because that's why this login system is very important not only the website using login system ... but smartphone too have a login system to keep the content still safe from people who are not have access on it ...\n\nThis time I will try to share how to make system login in website using php as programming language and mysql as database ...\n\nBut everyone have their own way to make login system ... this time I will create the login system using function in php ...\n\n\nFirst we need to create a database using phpmyadmin, let's type localhost/phpmyadmin in the search bar of your browser... before that you need to start your xampp first or you canot access that url.\n\n\n\nNext it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ...\n\n\nafter that let's create your databse name... here i use **login_db** as my databse name... then clik the **buat** button or **create** in english...\n\n\nafter that let's create your table name... here i use **uses** as my table name... and specify the number of columns in your table ... here i create 4 for my column number, because i will create \nusers_id for column one , users_fullname for column two, user_username for column three, users_password for coloumn four, if you not understand ... just follow first... \n after that just click **go** button at the bottom right\n\n\n\nafter that just follow this image, make sure auto increment (A_I) checked for auto fill that column, after that just click **simpan** button or **save** in english\n\n\nuntil here we have finished creating the database and table that we will use to create our login system\n\nlet's create one folder called login on your htdocs(xampp), inside that's folder create three files... first file i called connection.php second file i called function.php three file i called login.php .... as you can see this image showing what we have created on tree structure...\n\n\n\nto connect our login system using php programming language let's copy this code into connection .php file where we have been created \n\n``` \n<?php\n$connection = mysqli_connect('localhost', 'root', '', 'login_db');\nif (!$connection) {\n\techo 'connection failed';\n}\n```\nmysql_connect(); is function for connection our aplication to our mysql database.\nin mysql_connect(); we have three parameters first is 'localhost' for our host, second 'root' is our username of mysql database, third '' is empty value for our password database, because my database have no password i just create like this '' fourth 'login_db' is the name of our database where we have been created...\n\nin the login.php file lets copy this code\n``` \n<?php\ninclude \"function.php\";\n\t$loginSuccess = \"\";\n\t$loginFail = \"\";\n\tif (isset($_POST['login'])) {\n\t\tif(login_process($_POST['username'], $_POST['password'])){\n\t\t\t$loginSuccess = 'Login Success';\n\t\t}else{\n\t\t\t$loginFail = 'Login Failed';\n\t\t}\n\t}\n?>\n\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n\t<meta charset=\"UTF-8\">\n\t<title>login Page</title>\n\t<style>\n\t\tbody {\n background: #2d343d;\n}\n\n.login {\n margin: 20px auto;\n width: 300px;\n padding: 30px 25px;\n background: white;\n border: 1px solid #c4c4c4;\n}\n\nh1.login-title {\n margin: -28px -25px 25px;\n padding: 15px 25px;\n line-height: 30px;\n font-size: 25px;\n font-weight: 300;\n color: #ADADAD;\n text-align:center;\n background: #f7f7f7;\n \n}\n\n.login-input {\n width: 285px;\n height: 50px;\n margin-bottom: 25px;\n padding-left:10px;\n font-size: 15px;\n background: #fff;\n border: 1px solid #ccc;\n border-radius: 4px;\n}\n.login-input:focus {\n border-color:#6e8095;\n outline: none;\n }\n.login-button {\n width: 100%;\n height: 50px;\n padding: 0;\n font-size: 20px;\n color: #fff;\n text-align: center;\n background: #f0776c;\n border: 0;\n border-radius: 5px;\n cursor: pointer; \n outline:0;\n}\n\n.login-lost\n{\n text-align:center;\n margin-bottom:0px;\n}\n\n.login-lost a\n{\n color:#666;\n text-decoration:none;\n font-size:13px;\n}\n\n\t</style>\n</head>\n<body>\n\t<form class=\"login\" action=\"\" method=\"post\">\n <h1 class=\"login-title\">Login</h1>\n <?php if ($loginSuccess != '') {\n \techo '<h4 style=\"color:green\">'.$loginSuccess.'</h4>';\n }elseif($loginFail != ''){\n \techo '<h4 style=\"color:red\">'.$loginFail.'</h4>';\n } ?>\n <input type=\"text\" class=\"login-input\" name=\"username\" placeholder=\"Username\" autofocus>\n <input type=\"password\" class=\"login-input\" name=\"password\" placeholder=\"Password\">\n <input type=\"submit\" name=\"login\" value=\"Login\" class=\"login-button\">\n </form>\n</body>\n</html>\n```\nand in the function.php file lets copy this code\n``` \n<?php \ninclude \"connection.php\";\n\nfunction login_process($username,$password){\n\t$username = escape($username);\n\t$password = escape($password);\n\n\tglobal $connection;\n\t$query = \"SELECT * FROM users WHERE users_username = '$username' AND users_password = '$password'\";\n\t$result = mysqli_query($connection, $query);\n if (mysqli_num_rows($result) > 0) {\n return true;\n }\n}\n\nfunction escape($data){\n global $connection;\n $data = trim($data);\n $data = mysqli_real_escape_string($connection, $data);\n $data = htmlspecialchars($data, ENT_QUOTES);\n $data = strip_tags($data);\n return $data;\n}\n\n?>\n```\n\nlets insert our data into our database first, \nopen our phpmyadmin and click **tambahkan** or **insert **in english... \n\n\nafter you fill the form, just click **go** button\n\n\n after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this:\n\n type your usernmae and password at the form and click login button\n\n\n\n\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@instink/how-to-create-login-page-using-php-function-and-mysql-database\">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>",
"json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":51740069,\"name\":\"fuck-login\",\"full_name\":\"xchaoinfo/fuck-login\",\"html_url\":\"https://github.com/xchaoinfo/fuck-login\",\"fork\":false,\"owner\":{\"login\":\"xchaoinfo\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"php\",\"programming\",\"mysql\",\"database\"],\"links\":[\"https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg\",\"https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg\",\"https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg\",\"https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg\",\"https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg\",\"https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg\",\"https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg\",\"https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg\",\"https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg\",\"https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg\"],\"image\":[\"https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg\",\"https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg\",\"https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg\",\"https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg\",\"https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg\",\"https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg\",\"https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg\",\"https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg\",\"https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg\",\"https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg\"],\"moderator\":{\"account\":\"portugalcoin\",\"time\":\"2018-04-28T18:49:00.402Z\",\"pending\":true,\"reviewed\":false,\"flagged\":false},\"questions\":null,\"score\":null,\"total_influence\":null,\"staff_pick\":null,\"staff_pick_by\":null,\"config\":{\"questions\":[{\"question\":\"How many substantial concepts does this tutorial address?\",\"question_id\":\"tuts-1\",\"answers\":[{\"answer\":\"4-5 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-1\",\"value\":10},{\"answer\":\"2-3 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-2\",\"value\":7},{\"answer\":\"1 substantial concept covered in the tutorial.\",\"answer_id\":\"tuts-1-a-3\",\"value\":3},{\"answer\":\"More than 5 substantial concepts covered in the tutorial.\",\"answer_id\":\"tuts-1-a-4\",\"value\":0}]},{\"question\":\"Does the title and the outline of the tutorial properly reflect the content?\",\"question_id\":\"tuts-2\",\"answers\":[{\"answer\":\"Yes, it is very clear.\",\"answer_id\":\"tuts-2-a-1\",\"value\":15},{\"answer\":\"To some extent.\",\"answer_id\":\"tuts-2-a-2\",\"value\":11.5},{\"answer\":\"The title is somewhat misleading and/or the outline is not detailed or informative enough.\",\"answer_id\":\"tuts-2-a-3\",\"value\":4.5},{\"answer\":\"Title and outline are of little or no relevance to the content of the tutorial.\",\"answer_id\":\"tuts-2-a-4\",\"value\":0}]},{\"question\":\"Did the contributor provide supplementary resources, such as code and sample files in the contribution post or a linked GitHub repository?\",\"question_id\":\"tuts-3\",\"answers\":[{\"answer\":\"Yes, exceptional supplementary resources are provided including a relevant github repo/gist.\",\"answer_id\":\"tuts-3-a-1\",\"value\":15},{\"answer\":\"Supplementary resources provided are of high relevance.\",\"answer_id\":\"tuts-3-a-2\",\"value\":12},{\"answer\":\"Contributor provides minimal supplementary resources.\",\"answer_id\":\"tuts-3-a-3\",\"value\":6},{\"answer\":\"No supplementary resources were provided.\",\"answer_id\":\"tuts-3-a-4\",\"value\":0}]},{\"question\":\"Is the tutorial part of a series?\",\"question_id\":\"tuts-4\",\"answers\":[{\"answer\":\"Yes.\",\"answer_id\":\"tuts-4-a-1\",\"value\":10},{\"answer\":\"Yes, but it is the first entry in the series.\",\"answer_id\":\"tuts-4-a-2\",\"value\":7},{\"answer\":\"No, but it works just fine as a stand-alone tutorial.\",\"answer_id\":\"tuts-4-a-3\",\"value\":5},{\"answer\":\"No.\",\"answer_id\":\"tuts-4-a-4\",\"value\":0}]},{\"question\":\"Does the tutorial contain sufficient explanatory visuals?\",\"question_id\":\"tuts-5\",\"answers\":[{\"answer\":\"Yes, the visual components of the post were adequate in quality and quantity.\",\"answer_id\":\"tuts-5-a-1\",\"value\":10},{\"answer\":\"The volume of visual components included was unnecessarily large.\",\"answer_id\":\"tuts-5-a-2\",\"value\":7},{\"answer\":\"The post lacked sufficient visualization to easily learn from the content.\",\"answer_id\":\"tuts-5-a-3\",\"value\":3},{\"answer\":\"No visualization was presented in this contribution.\",\"answer_id\":\"tuts-5-a-4\",\"value\":0}]},{\"question\":\"How unique and/or innovative are the concepts covered in the tutorial?\",\"question_id\":\"tuts-6\",\"answers\":[{\"answer\":\"This was the first time I read about the concepts covered.\",\"answer_id\":\"tuts-6-a-1\",\"value\":10},{\"answer\":\"The concepts covered were innovative and offer some usefulness.\",\"answer_id\":\"tuts-6-a-2\",\"value\":7},{\"answer\":\"I have read several similar ideas and thoughts elsewhere, but this one was of higher quality.\",\"answer_id\":\"tuts-6-a-3\",\"value\":5},{\"answer\":\"Such tutorials can be found online with great ease and the contribution add no value to the open source community.\",\"answer_id\":\"tuts-6-a-4\",\"value\":0}]},{\"question\":\"How would you describe the formatting, language and overall presentation of the post?\",\"question_id\":\"c-1\",\"answers\":[{\"answer\":\"The post is of very high quality.\",\"answer_id\":\"c-1-a-1\",\"value\":10},{\"answer\":\"The post is of decent quality, but not spectacular in any way.\",\"answer_id\":\"c-1-a-2\",\"value\":7},{\"answer\":\"The post is poorly written and/or formatted, but readable.\",\"answer_id\":\"c-1-a-3\",\"value\":3},{\"answer\":\"The post is really hard to read and the content is barely understandable.\",\"answer_id\":\"c-1-a-4\",\"value\":0}]},{\"question\":\"How would you rate the overall value of this contribution on the open source community and ecosystem?\",\"question_id\":\"c-2\",\"answers\":[{\"answer\":\"This contribution brings great and impactful value, and can be used for applications outside the specific project.\",\"answer_id\":\"c-2-a-1\",\"value\":20},{\"answer\":\"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.\",\"answer_id\":\"c-2-a-2\",\"value\":16},{\"answer\":\"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.\",\"answer_id\":\"c-2-a-3\",\"value\":8},{\"answer\":\"This contribution adds no value to the open source community and ecosystem or the specific project.\",\"answer_id\":\"c-2-a-4\",\"value\":0}]}]}}",
"parent_author": "",
"parent_permlink": "utopian-io",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"title": "how to create login page using php function and mysql database"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T18:49:00",
"trx_id": "823d95b6a1c1450ed3535d40be3bb808306c1be8",
"trx_in_block": 57,
"virtual_op": 0
}2018/04/28 18:06:27
2018/04/28 18:06:27
| id | follow |
| json | ["follow",{"follower":"instink","following":"naufal","what":["blog"]}] |
| required auths | [] |
| required posting auths | ["instink"] |
| Transaction Info | Block #21968938/Trx 6b55b84a3366805d23bd815add44c5c1fda48541 |
View Raw JSON Data
{
"block": 21968938,
"op": [
"custom_json",
{
"id": "follow",
"json": "[\"follow\",{\"follower\":\"instink\",\"following\":\"naufal\",\"what\":[\"blog\"]}]",
"required_auths": [],
"required_posting_auths": [
"instink"
]
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T18:06:27",
"trx_id": "6b55b84a3366805d23bd815add44c5c1fda48541",
"trx_in_block": 7,
"virtual_op": 0
}2018/04/28 18:04:30
2018/04/28 18:04:30
| author | instink |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| voter | st3llar |
| weight | 300 (3.00%) |
| Transaction Info | Block #21968899/Trx d1b91d17c11f9422a77eda44328b027e0a64ec9e |
View Raw JSON Data
{
"block": 21968899,
"op": [
"vote",
{
"author": "instink",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"voter": "st3llar",
"weight": 300
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T18:04:30",
"trx_id": "d1b91d17c11f9422a77eda44328b027e0a64ec9e",
"trx_in_block": 22,
"virtual_op": 0
}instinkupdated their account properties2018/04/28 17:35:33
instinkupdated their account properties
2018/04/28 17:35:33
| account | instink |
| json metadata | {"profile":{"profile_image":"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg","name":"Instink","about":"Im Web Developer","location":"Takengon"}} |
| memo key | STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R |
| Transaction Info | Block #21968320/Trx 360fa928facd5813343547b6bee697bac1af57b3 |
View Raw JSON Data
{
"block": 21968320,
"op": [
"account_update",
{
"account": "instink",
"json_metadata": "{\"profile\":{\"profile_image\":\"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg\",\"name\":\"Instink\",\"about\":\"Im Web Developer\",\"location\":\"Takengon\"}}",
"memo_key": "STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T17:35:33",
"trx_id": "360fa928facd5813343547b6bee697bac1af57b3",
"trx_in_block": 44,
"virtual_op": 0
}elektr1kerupvoted (100.00%) @instink / how-to-create-login-page-using-php-function-and-mysql-database2018/04/28 17:34:00
elektr1kerupvoted (100.00%) @instink / how-to-create-login-page-using-php-function-and-mysql-database
2018/04/28 17:34:00
| author | instink |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| voter | elektr1ker |
| weight | 10000 (100.00%) |
| Transaction Info | Block #21968289/Trx fbf7f20295f89ac08bde6da647d2a144e3421f16 |
View Raw JSON Data
{
"block": 21968289,
"op": [
"vote",
{
"author": "instink",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"voter": "elektr1ker",
"weight": 10000
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T17:34:00",
"trx_id": "fbf7f20295f89ac08bde6da647d2a144e3421f16",
"trx_in_block": 44,
"virtual_op": 0
}instinkupdated options for how-to-create-login-page-using-php-function-and-mysql-database2018/04/28 17:29:36
instinkupdated options for how-to-create-login-page-using-php-function-and-mysql-database
2018/04/28 17:29:36
| allow curation rewards | true |
| allow votes | true |
| author | instink |
| extensions | [[0,{"beneficiaries":[{"account":"utopian.pay","weight":1500}]}]] |
| max accepted payout | 1000000.000 SBD |
| percent steem dollars | 10000 |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| Transaction Info | Block #21968201/Trx 1f81f9a27517c5da1280e82e60d1ec33df492ca5 |
View Raw JSON Data
{
"block": 21968201,
"op": [
"comment_options",
{
"allow_curation_rewards": true,
"allow_votes": true,
"author": "instink",
"extensions": [
[
0,
{
"beneficiaries": [
{
"account": "utopian.pay",
"weight": 1500
}
]
}
]
],
"max_accepted_payout": "1000000.000 SBD",
"percent_steem_dollars": 10000,
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T17:29:36",
"trx_id": "1f81f9a27517c5da1280e82e60d1ec33df492ca5",
"trx_in_block": 65,
"virtual_op": 0
}instinkpublished a new post: how-to-create-login-page-using-php-function-and-mysql-database2018/04/28 17:29:36
instinkpublished a new post: how-to-create-login-page-using-php-function-and-mysql-database
2018/04/28 17:29:36
| author | instink |
| body | What Will I Learn? Because in this tutorial i will create login system using php code and mysql as database, you will be learn both of that in one package ... Let's see what we got after learn this tutorial You will learn how to create table in mysql database using phpmyadmin, <br> You will learn how to connect your php to database, <br> You will learn how to create function using php code, <br> You will learn how to validate your login system using php Requirements You need to understand basic of XAMPP and Phpmyadmin, <br> You need to understand basic of PHP programming language, <br> You need to understand basic of HTML language, <br> You need to understand basic of SQL language Difficulty - Basic Tutorial Contents I think every websites must have a login system, because that's why this login system is very important not only the website using login system ... but smartphone too have a login system to keep the content still safe from people who are not have access on it ... This time I will try to share how to make system login in website using php as programming language and mysql as database ... But everyone have their own way to make login system ... this time I will create the login system using function in php ... First we need to create a database using phpmyadmin, let's type localhost/phpmyadmin in the search bar of your browser... before that you need to start your xampp first or you canot access that url.  Next it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ...  after that let's create your databse name... here i use **login_db** as my databse name... then clik the **buat** button or **create** in english...  after that let's create your table name... here i use **uses** as my table name... and specify the number of columns in your table ... here i create 4 for my column number, because i will create users_id for column one , users_fullname for column two, user_username for column three, users_password for coloumn four, if you not understand ... just follow first... after that just click **go** button at the bottom right  after that just follow this image, make sure auto increment (A_I) checked for auto fill that column, after that just click **simpan** button or **save** in english  until here we have finished creating the database and table that we will use to create our login system let's create one folder called login on your htdocs(xampp), inside that's folder create three files... first file i called connection.php second file i called function.php three file i called login.php .... as you can see this image showing what we have created on tree structure...  to connect our login system using php programming language let's copy this code into connection .php file where we have been created ``` <?php $connection = mysqli_connect('localhost', 'root', '', 'login_db'); if (!$connection) { echo 'connection failed'; } ``` mysql_connect(); is function for connection our aplication to our mysql database. in mysql_connect(); we have three parameters first is 'localhost' for our host, second 'root' is our username of mysql database, third '' is empty value for our password database, because my database have no password i just create like this '' fourth 'login_db' is the name of our database where we have been created... in the login.php file lets copy this code ``` <?php include "function.php"; $loginSuccess = ""; $loginFail = ""; if (isset($_POST['login'])) { if(login_process($_POST['username'], $_POST['password'])){ $loginSuccess = 'Login Success'; }else{ $loginFail = 'Login Failed'; } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>login Page</title> <style> body { background: #2d343d; } .login { margin: 20px auto; width: 300px; padding: 30px 25px; background: white; border: 1px solid #c4c4c4; } h1.login-title { margin: -28px -25px 25px; padding: 15px 25px; line-height: 30px; font-size: 25px; font-weight: 300; color: #ADADAD; text-align:center; background: #f7f7f7; } .login-input { width: 285px; height: 50px; margin-bottom: 25px; padding-left:10px; font-size: 15px; background: #fff; border: 1px solid #ccc; border-radius: 4px; } .login-input:focus { border-color:#6e8095; outline: none; } .login-button { width: 100%; height: 50px; padding: 0; font-size: 20px; color: #fff; text-align: center; background: #f0776c; border: 0; border-radius: 5px; cursor: pointer; outline:0; } .login-lost { text-align:center; margin-bottom:0px; } .login-lost a { color:#666; text-decoration:none; font-size:13px; } </style> </head> <body> <form class="login" action="" method="post"> <h1 class="login-title">Login</h1> <?php if ($loginSuccess != '') { echo '<h4 style="color:green">'.$loginSuccess.'</h4>'; }elseif($loginFail != ''){ echo '<h4 style="color:red">'.$loginFail.'</h4>'; } ?> <input type="text" class="login-input" name="username" placeholder="Username" autofocus> <input type="password" class="login-input" name="password" placeholder="Password"> <input type="submit" name="login" value="Login" class="login-button"> </form> </body> </html> ``` and in the function.php file lets copy this code ``` <?php include "connection.php"; function login_process($username,$password){ $username = escape($username); $password = escape($password); global $connection; $query = "SELECT * FROM users WHERE users_username = '$username' AND users_password = '$password'"; $result = mysqli_query($connection, $query); if (mysqli_num_rows($result) > 0) { return true; } } function escape($data){ global $connection; $data = trim($data); $data = mysqli_real_escape_string($connection, $data); $data = htmlspecialchars($data, ENT_QUOTES); $data = strip_tags($data); return $data; } ?> ``` lets insert our data into our database first, open our phpmyadmin and click **tambahkan** or **insert **in english...  after you fill the form, just click **go** button  after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this: type your usernmae and password at the form and click login button  <br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@instink/how-to-create-login-page-using-php-function-and-mysql-database">Utopian.io - Rewarding Open Source Contributors</a></em><hr/> |
| json metadata | {"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":51740069,"name":"fuck-login","full_name":"xchaoinfo/fuck-login","html_url":"https://github.com/xchaoinfo/fuck-login","fork":false,"owner":{"login":"xchaoinfo"}},"pullRequests":[],"platform":"github","type":"tutorials","tags":["utopian-io","php","programming","mysql","database"],"links":["https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg","https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg","https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg","https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg","https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg","https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg","https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg","https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg","https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg","https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg"],"image":["https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg","https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg","https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg","https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg","https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg","https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg","https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg","https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg","https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg","https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg"]} |
| parent author | |
| parent permlink | utopian-io |
| permlink | how-to-create-login-page-using-php-function-and-mysql-database |
| title | how to create login page using php function and mysql database |
| Transaction Info | Block #21968201/Trx 1f81f9a27517c5da1280e82e60d1ec33df492ca5 |
View Raw JSON Data
{
"block": 21968201,
"op": [
"comment",
{
"author": "instink",
"body": "What Will I Learn?\n\nBecause in this tutorial i will create login system using php code and mysql as database, you will be learn both of that in one package ... Let's see what we got after learn this tutorial \n\nYou will learn how to create table in mysql database using phpmyadmin, <br>\nYou will learn how to connect your php to database, <br>\nYou will learn how to create function using php code, <br>\nYou will learn how to validate your login system using php\n\nRequirements\n\nYou need to understand basic of XAMPP and Phpmyadmin, <br>\nYou need to understand basic of PHP programming language, <br>\nYou need to understand basic of HTML language, <br>\nYou need to understand basic of SQL language \n\nDifficulty\n- Basic\n\nTutorial Contents\n\nI think every websites must have a login system, because that's why this login system is very important not only the website using login system ... but smartphone too have a login system to keep the content still safe from people who are not have access on it ...\n\nThis time I will try to share how to make system login in website using php as programming language and mysql as database ...\n\nBut everyone have their own way to make login system ... this time I will create the login system using function in php ...\n\n\nFirst we need to create a database using phpmyadmin, let's type localhost/phpmyadmin in the search bar of your browser... before that you need to start your xampp first or you canot access that url.\n\n\n\nNext it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ...\n\n\nafter that let's create your databse name... here i use **login_db** as my databse name... then clik the **buat** button or **create** in english...\n\n\nafter that let's create your table name... here i use **uses** as my table name... and specify the number of columns in your table ... here i create 4 for my column number, because i will create \nusers_id for column one , users_fullname for column two, user_username for column three, users_password for coloumn four, if you not understand ... just follow first... \n after that just click **go** button at the bottom right\n\n\n\nafter that just follow this image, make sure auto increment (A_I) checked for auto fill that column, after that just click **simpan** button or **save** in english\n\n\nuntil here we have finished creating the database and table that we will use to create our login system\n\nlet's create one folder called login on your htdocs(xampp), inside that's folder create three files... first file i called connection.php second file i called function.php three file i called login.php .... as you can see this image showing what we have created on tree structure...\n\n\n\nto connect our login system using php programming language let's copy this code into connection .php file where we have been created \n\n``` \n<?php\n$connection = mysqli_connect('localhost', 'root', '', 'login_db');\nif (!$connection) {\n\techo 'connection failed';\n}\n```\nmysql_connect(); is function for connection our aplication to our mysql database.\nin mysql_connect(); we have three parameters first is 'localhost' for our host, second 'root' is our username of mysql database, third '' is empty value for our password database, because my database have no password i just create like this '' fourth 'login_db' is the name of our database where we have been created...\n\nin the login.php file lets copy this code\n``` \n<?php\ninclude \"function.php\";\n\t$loginSuccess = \"\";\n\t$loginFail = \"\";\n\tif (isset($_POST['login'])) {\n\t\tif(login_process($_POST['username'], $_POST['password'])){\n\t\t\t$loginSuccess = 'Login Success';\n\t\t}else{\n\t\t\t$loginFail = 'Login Failed';\n\t\t}\n\t}\n?>\n\n<!DOCTYPE html>\n<html lang=\"en\">\n<head>\n\t<meta charset=\"UTF-8\">\n\t<title>login Page</title>\n\t<style>\n\t\tbody {\n background: #2d343d;\n}\n\n.login {\n margin: 20px auto;\n width: 300px;\n padding: 30px 25px;\n background: white;\n border: 1px solid #c4c4c4;\n}\n\nh1.login-title {\n margin: -28px -25px 25px;\n padding: 15px 25px;\n line-height: 30px;\n font-size: 25px;\n font-weight: 300;\n color: #ADADAD;\n text-align:center;\n background: #f7f7f7;\n \n}\n\n.login-input {\n width: 285px;\n height: 50px;\n margin-bottom: 25px;\n padding-left:10px;\n font-size: 15px;\n background: #fff;\n border: 1px solid #ccc;\n border-radius: 4px;\n}\n.login-input:focus {\n border-color:#6e8095;\n outline: none;\n }\n.login-button {\n width: 100%;\n height: 50px;\n padding: 0;\n font-size: 20px;\n color: #fff;\n text-align: center;\n background: #f0776c;\n border: 0;\n border-radius: 5px;\n cursor: pointer; \n outline:0;\n}\n\n.login-lost\n{\n text-align:center;\n margin-bottom:0px;\n}\n\n.login-lost a\n{\n color:#666;\n text-decoration:none;\n font-size:13px;\n}\n\n\t</style>\n</head>\n<body>\n\t<form class=\"login\" action=\"\" method=\"post\">\n <h1 class=\"login-title\">Login</h1>\n <?php if ($loginSuccess != '') {\n \techo '<h4 style=\"color:green\">'.$loginSuccess.'</h4>';\n }elseif($loginFail != ''){\n \techo '<h4 style=\"color:red\">'.$loginFail.'</h4>';\n } ?>\n <input type=\"text\" class=\"login-input\" name=\"username\" placeholder=\"Username\" autofocus>\n <input type=\"password\" class=\"login-input\" name=\"password\" placeholder=\"Password\">\n <input type=\"submit\" name=\"login\" value=\"Login\" class=\"login-button\">\n </form>\n</body>\n</html>\n```\nand in the function.php file lets copy this code\n``` \n<?php \ninclude \"connection.php\";\n\nfunction login_process($username,$password){\n\t$username = escape($username);\n\t$password = escape($password);\n\n\tglobal $connection;\n\t$query = \"SELECT * FROM users WHERE users_username = '$username' AND users_password = '$password'\";\n\t$result = mysqli_query($connection, $query);\n if (mysqli_num_rows($result) > 0) {\n return true;\n }\n}\n\nfunction escape($data){\n global $connection;\n $data = trim($data);\n $data = mysqli_real_escape_string($connection, $data);\n $data = htmlspecialchars($data, ENT_QUOTES);\n $data = strip_tags($data);\n return $data;\n}\n\n?>\n```\n\nlets insert our data into our database first, \nopen our phpmyadmin and click **tambahkan** or **insert **in english... \n\n\nafter you fill the form, just click **go** button\n\n\n after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this:\n\n type your usernmae and password at the form and click login button\n\n\n\n\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@instink/how-to-create-login-page-using-php-function-and-mysql-database\">Utopian.io - Rewarding Open Source Contributors</a></em><hr/>",
"json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":51740069,\"name\":\"fuck-login\",\"full_name\":\"xchaoinfo/fuck-login\",\"html_url\":\"https://github.com/xchaoinfo/fuck-login\",\"fork\":false,\"owner\":{\"login\":\"xchaoinfo\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"php\",\"programming\",\"mysql\",\"database\"],\"links\":[\"https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg\",\"https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg\",\"https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg\",\"https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg\",\"https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg\",\"https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg\",\"https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg\",\"https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg\",\"https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg\",\"https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg\"],\"image\":[\"https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg\",\"https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg\",\"https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg\",\"https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg\",\"https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg\",\"https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg\",\"https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg\",\"https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg\",\"https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg\",\"https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg\"]}",
"parent_author": "",
"parent_permlink": "utopian-io",
"permlink": "how-to-create-login-page-using-php-function-and-mysql-database",
"title": "how to create login page using php function and mysql database"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T17:29:36",
"trx_id": "1f81f9a27517c5da1280e82e60d1ec33df492ca5",
"trx_in_block": 65,
"virtual_op": 0
}instinkupdated their account properties2018/04/28 14:13:21
instinkupdated their account properties
2018/04/28 14:13:21
| account | instink |
| json metadata | {"profile":{"profile_image":"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg","name":"Instink","about":"Im Web Developer"}} |
| memo key | STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R |
| Transaction Info | Block #21964276/Trx 052de04fee2adf47151e55a896168d91c6c352ee |
View Raw JSON Data
{
"block": 21964276,
"op": [
"account_update",
{
"account": "instink",
"json_metadata": "{\"profile\":{\"profile_image\":\"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg\",\"name\":\"Instink\",\"about\":\"Im Web Developer\"}}",
"memo_key": "STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-28T14:13:21",
"trx_id": "052de04fee2adf47151e55a896168d91c6c352ee",
"trx_in_block": 10,
"virtual_op": 0
}2018/04/11 11:28:06
2018/04/11 11:28:06
| delegatee | instink |
| delegator | steem |
| vesting shares | 30374.889833 VESTS |
| Transaction Info | Block #21472102/Trx ed6cdae17db19e72e1ab33a7dcd21841a131556f |
View Raw JSON Data
{
"block": 21472102,
"op": [
"delegate_vesting_shares",
{
"delegatee": "instink",
"delegator": "steem",
"vesting_shares": "30374.889833 VESTS"
}
],
"op_in_trx": 0,
"timestamp": "2018-04-11T11:28:06",
"trx_id": "ed6cdae17db19e72e1ab33a7dcd21841a131556f",
"trx_in_block": 31,
"virtual_op": 0
}instinkupdated their account properties2018/04/11 10:15:51
instinkupdated their account properties
2018/04/11 10:15:51
| account | instink |
| json metadata | {} |
| memo key | STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R |
| posting | {"account_auths":[["utopian.app",1]],"key_auths":[["STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",1]],"weight_threshold":1} |
| Transaction Info | Block #21470658/Trx 3c433d6505bb0d732b9ff3cb7d4e89e71125e8d8 |
View Raw JSON Data
{
"block": 21470658,
"op": [
"account_update",
{
"account": "instink",
"json_metadata": "{}",
"memo_key": "STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R",
"posting": {
"account_auths": [
[
"utopian.app",
1
]
],
"key_auths": [
[
"STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",
1
]
],
"weight_threshold": 1
}
}
],
"op_in_trx": 0,
"timestamp": "2018-04-11T10:15:51",
"trx_id": "3c433d6505bb0d732b9ff3cb7d4e89e71125e8d8",
"trx_in_block": 35,
"virtual_op": 0
}2018/04/11 10:12:09
2018/04/11 10:12:09
| active | {"account_auths":[],"key_auths":[["STM7YPNGUhS6QJe2icvUcBMwKLXMUjurJwvNiZEBsnZDUnw5336V6",1]],"weight_threshold":1} |
| creator | steem |
| delegation | 30690.000000 VESTS |
| extensions | [] |
| fee | 0.100 STEEM |
| json metadata | {} |
| memo key | STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R |
| new account name | instink |
| owner | {"account_auths":[],"key_auths":[["STM5SYxtaCMLiqwr4xnBr5kYiMajr1LhiQmfVxjidtUfNNC992aHY",1]],"weight_threshold":1} |
| posting | {"account_auths":[],"key_auths":[["STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",1]],"weight_threshold":1} |
| Transaction Info | Block #21470584/Trx e979ac332deca68da90a5b292101c6b37ff01eb7 |
View Raw JSON Data
{
"block": 21470584,
"op": [
"account_create_with_delegation",
{
"active": {
"account_auths": [],
"key_auths": [
[
"STM7YPNGUhS6QJe2icvUcBMwKLXMUjurJwvNiZEBsnZDUnw5336V6",
1
]
],
"weight_threshold": 1
},
"creator": "steem",
"delegation": "30690.000000 VESTS",
"extensions": [],
"fee": "0.100 STEEM",
"json_metadata": "{}",
"memo_key": "STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R",
"new_account_name": "instink",
"owner": {
"account_auths": [],
"key_auths": [
[
"STM5SYxtaCMLiqwr4xnBr5kYiMajr1LhiQmfVxjidtUfNNC992aHY",
1
]
],
"weight_threshold": 1
},
"posting": {
"account_auths": [],
"key_auths": [
[
"STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",
1
]
],
"weight_threshold": 1
}
}
],
"op_in_trx": 0,
"timestamp": "2018-04-11T10:12:09",
"trx_id": "e979ac332deca68da90a5b292101c6b37ff01eb7",
"trx_in_block": 2,
"virtual_op": 0
}Manabar
Voting Power100.00%
Downvote Power100.00%
Resource Credits100.00%
Reputation Progress0.00%
{
"voting_manabar": {
"current_mana": "8143659806",
"last_update_time": 1779067707
},
"downvote_manabar": {
"current_mana": 2035914951,
"last_update_time": 1779067707
},
"rc_account": {
"account": "instink",
"max_rc": "10164408779",
"max_rc_creation_adjustment": {
"amount": "2020748973",
"nai": "@@000000037",
"precision": 6
},
"rc_manabar": {
"current_mana": "10164408779",
"last_update_time": 1779067707
}
}
}Account Metadata
| POSTING JSON METADATA | |
| profile | {"profile_image":"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg","name":"Instink","about":"Im Web Developer","location":"Takengon"} |
| JSON METADATA | |
| profile | {"profile_image":"https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg","name":"Instink","about":"Im Web Developer","location":"Takengon"} |
{
"posting_json_metadata": {
"profile": {
"profile_image": "https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg",
"name": "Instink",
"about": "Im Web Developer",
"location": "Takengon"
}
},
"json_metadata": {
"profile": {
"profile_image": "https://lh3.googleusercontent.com/-EaGsCOKWdWU/AAAAAAAAAAI/AAAAAAAAABQ/YZZhu_P3vfY/s60-p-rw-no/photo.jpg",
"name": "Instink",
"about": "Im Web Developer",
"location": "Takengon"
}
}
}Auth Keys
Owner
Single Signature
Public Keys
STM5SYxtaCMLiqwr4xnBr5kYiMajr1LhiQmfVxjidtUfNNC992aHY1/1
Active
Single Signature
Public Keys
STM7YPNGUhS6QJe2icvUcBMwKLXMUjurJwvNiZEBsnZDUnw5336V61/1
Posting
Single Signature
Public Keys
STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c1/1
Memo
STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R
{
"owner": {
"account_auths": [],
"key_auths": [
[
"STM5SYxtaCMLiqwr4xnBr5kYiMajr1LhiQmfVxjidtUfNNC992aHY",
1
]
],
"weight_threshold": 1
},
"active": {
"account_auths": [],
"key_auths": [
[
"STM7YPNGUhS6QJe2icvUcBMwKLXMUjurJwvNiZEBsnZDUnw5336V6",
1
]
],
"weight_threshold": 1
},
"posting": {
"account_auths": [
[
"dlive.app",
1
],
[
"utopian.app",
1
]
],
"key_auths": [
[
"STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",
1
]
],
"weight_threshold": 1
},
"memo": "STM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R"
}Witness Votes
0 / 30
No active witness votes.
[]