Ecoer Logo

@instink

25

Im Web Developer

steemit.com/@instink
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 Deleg
+4.881SP

Detailed Balance

STEEM
balance
0.000STEEM
market_balance
0.000STEEM
savings_balance
0.000STEEM
reward_steem_balance
0.000STEEM
STEEM POWER
Own SP
0.125SP
Delegated Out
0.000SP
Delegation In
4.881SP
Effective Power
5.007SP
Reward SP (pending)
0.006SP
SBD
sbd_balance
0.000SBD
sbd_conversions
0.000SBD
sbd_market_balance
0.000SBD
savings_sbd_balance
0.000SBD
reward_sbd_balance
0.023SBD
{
  "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

nameinstink
id934617
rank405,473
reputation154683086
created2018-04-11T10:12:09
recovery_accountsteem
proxyNone
post_count3
comment_count0
lifetime_vote_count0
witnesses_voted_for0
last_post2018-05-24T21:55:24
last_root_post2018-05-24T21:55:24
last_vote_time1970-01-01T00:00:00
proxied_vsf_votes0, 0, 0, 0
can_vote1
voting_power0
delayed_votes0
balance0.000 STEEM
savings_balance0.000 STEEM
sbd_balance0.000 SBD
savings_sbd_balance0.000 SBD
vesting_shares203.858848 VESTS
delegated_vesting_shares0.000000 VESTS
received_vesting_shares7939.800958 VESTS
reward_vesting_balance12.216174 VESTS
vesting_balance0.000 STEEM
vesting_withdraw_rate0.000000 VESTS
next_vesting_withdrawal1969-12-31T23:59:59
withdrawn0
to_withdraw0
withdraw_routes0
savings_withdraw_requests0
last_account_recovery1970-01-01T00:00:00
reset_accountnull
last_owner_update1970-01-01T00:00:00
last_account_update2018-05-24T19:57:27
minedNo
sbd_seconds0
sbd_last_interest_payment1970-01-01T00:00:00
savings_sbd_last_interest_payment1970-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

IncomingOutgoing
Empty
Empty
{
  "incoming": [],
  "outgoing": []
}
From Date
To Date
steemdelegated 4.881 SP to @instink
2026/05/18 01:28:27
delegateeinstink
delegatorsteem
vesting shares7939.800958 VESTS
Transaction InfoBlock #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
}
steemdelegated 3.214 SP to @instink
2026/05/12 08:47:45
delegateeinstink
delegatorsteem
vesting shares5227.590553 VESTS
Transaction InfoBlock #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
}
steemdelegated 4.889 SP to @instink
2026/04/26 00:47:21
delegateeinstink
delegatorsteem
vesting shares7952.316714 VESTS
Transaction InfoBlock #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
}
steemdelegated 3.239 SP to @instink
2026/01/23 11:05:27
delegateeinstink
delegatorsteem
vesting shares5269.137372 VESTS
Transaction InfoBlock #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
}
steemdelegated 3.340 SP to @instink
2024/12/17 06:22:33
delegateeinstink
delegatorsteem
vesting shares5433.356569 VESTS
Transaction InfoBlock #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
}
steemdelegated 3.444 SP to @instink
2023/11/13 22:04:33
delegateeinstink
delegatorsteem
vesting shares5602.490101 VESTS
Transaction InfoBlock #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
}
steemdelegated 5.250 SP to @instink
2023/09/21 23:16:30
delegateeinstink
delegatorsteem
vesting shares8539.768887 VESTS
Transaction InfoBlock #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
}
steemdelegated 5.386 SP to @instink
2022/11/03 12:52:36
delegateeinstink
delegatorsteem
vesting shares8761.450325 VESTS
Transaction InfoBlock #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
}
steemdelegated 5.522 SP to @instink
2022/01/17 12:02:39
delegateeinstink
delegatorsteem
vesting shares8981.983556 VESTS
Transaction InfoBlock #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
}
steemdelegated 5.635 SP to @instink
2021/06/14 01:54:57
delegateeinstink
delegatorsteem
vesting shares9165.752214 VESTS
Transaction InfoBlock #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
}
steemdelegated 5.750 SP to @instink
2020/12/11 12:12:06
delegateeinstink
delegatorsteem
vesting shares9353.174188 VESTS
Transaction InfoBlock #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
}
steemdelegated 1.176 SP to @instink
2020/12/06 05:49:03
delegateeinstink
delegatorsteem
vesting shares1912.543513 VESTS
Transaction InfoBlock #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
}
steemdelegated 5.754 SP to @instink
2020/12/05 15:50:00
delegateeinstink
delegatorsteem
vesting shares9359.382042 VESTS
Transaction InfoBlock #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
}
steemdelegated 1.180 SP to @instink
2020/11/02 17:53:33
delegateeinstink
delegatorsteem
vesting shares1920.017158 VESTS
Transaction InfoBlock #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
}
steemdelegated 5.879 SP to @instink
2020/05/09 06:47:27
delegateeinstink
delegatorsteem
vesting shares9562.187401 VESTS
Transaction InfoBlock #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
}
steemdelegated 1.201 SP to @instink
2020/05/08 10:33:21
delegateeinstink
delegatorsteem
vesting shares1953.311140 VESTS
Transaction InfoBlock #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
}
steemdelegated 5.975 SP to @instink
2019/08/08 19:08:48
delegateeinstink
delegatorsteem
vesting shares9718.898359 VESTS
Transaction InfoBlock #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
authorsteemitboard
bodyCongratulations @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 authorinstink
parent permlink27f6e475-5f9d-11e8-82ff-0242ac110002
permlinksteemitboard-notify-instink-20190411t104400000z
title
Transaction InfoBlock #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
}
steemdelegated 6.097 SP to @instink
2018/08/23 22:20:15
delegateeinstink
delegatorsteem
vesting shares9917.374753 VESTS
Transaction InfoBlock #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
}
steemdelegated 18.550 SP to @instink
2018/08/16 07:04:45
delegateeinstink
delegatorsteem
vesting shares30172.369299 VESTS
Transaction InfoBlock #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
}
2018/05/24 21:55:24
authorinstink
body[![Thumbnail](https://dlive.biz:8080/QmUpNaux2QsezvfRhu15rTQNbr4yzweXiFw8mKYKvkqPsK)](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 permlinkdlive
permlink27f6e475-5f9d-11e8-82ff-0242ac110002
titleMobile Lagend Streaming
Transaction InfoBlock #22721798/Trx 7721abaf6579301dd118db3c3a0be5024bdd79cc
View Raw JSON Data
{
  "block": 22721798,
  "op": [
    "comment",
    {
      "author": "instink",
      "body": "[![Thumbnail](https://dlive.biz:8080/QmUpNaux2QsezvfRhu15rTQNbr4yzweXiFw8mKYKvkqPsK)](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 properties
2018/05/24 19:57:27
accountinstink
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 keySTM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R
posting{"account_auths":[["dlive.app",1],["utopian.app",1]],"key_auths":[["STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",1]],"weight_threshold":1}
Transaction InfoBlock #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
}
2018/05/05 17:29:36
authorinstink
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
sbd payout0.023 SBD
steem payout0.000 STEEM
vesting payout12.216174 VESTS
Transaction InfoBlock #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 @instink
2018/05/05 17:29:36
authorinstink
benefactorutopian.pay
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
sbd payout0.000 SBD
steem payout0.000 STEEM
vesting payout4.072058 VESTS
Transaction InfoBlock #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
}
2018/04/30 02:08:00
authorinstink
permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
votermarilovich
weight10000 (100.00%)
Transaction InfoBlock #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
}
2018/04/30 02:07:57
authorinstink
permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
voterlidchishan
weight10000 (100.00%)
Transaction InfoBlock #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
authormcfarhat
bodyThank 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 authorinstink
parent permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
permlinkre-instink-how-to-build-some-website-using-codeigniter-framework-or-php-or-20180429t184221863z
title
Transaction InfoBlock #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
}
2018/04/29 18:38:06
authorinstink
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 logo.png](https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png) 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![gambar 1.png](https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png) 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 ? ![gambar 2.jpg](https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg) - 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 ![gambar 3.jpg](https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg) 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. ![gambar 4.jpg](https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg) If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following. ![gambar 5.jpg](https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg) To add a parameter, we only need to edit a few of the methods we have been created before: ![gambar 6.jpg](https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg) 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. ![gambar 7.jpg](https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg) 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 ![gambar 8.jpg](https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg) and we need to create some file in view folder i caled myapp.php ![gambar 9.jpg](https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg) 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 ![gambar 10.jpg](https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg) 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 ![gambar 12.jpg](https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg) oke... lets create some file in model folder i callded mymodel.php ![gambar 13.jpg](https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg) 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 ![gambar 14.jpg](https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg) 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 ![gambar 15.jpg](https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg) 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 permlinkutopian-io
permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
titleHow to build some website using codeigniter framework |PHP|
Transaction InfoBlock #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![codeigniter logo.png](https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png)\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![gambar 1.png](https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png)\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![gambar 2.jpg](https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg)\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![gambar 3.jpg](https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg)\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![gambar 4.jpg](https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg)\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![gambar 5.jpg](https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg)\nTo add a parameter, we only need to edit a few of the methods we have been created before:\n![gambar 6.jpg](https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg)\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![gambar 7.jpg](https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg)\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![gambar 8.jpg](https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg)\n\nand we need to create some file in view folder i caled myapp.php\n![gambar 9.jpg](https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg)\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![gambar 10.jpg](https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg)\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![gambar 12.jpg](https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg)\n\noke... lets create some file in model folder i callded mymodel.php\n![gambar 13.jpg](https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg)\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![gambar 14.jpg](https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg)\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![gambar 15.jpg](https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg)\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
}
2018/04/29 18:21:36
authorinstink
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 logo.png](https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png) 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![gambar 1.png](https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png) 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 ? ![gambar 2.jpg](https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg) - 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 ![gambar 3.jpg](https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg) 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. ![gambar 4.jpg](https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg) If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following. ![gambar 5.jpg](https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg) To add a parameter, we only need to edit a few of the methods we have been created before: ![gambar 6.jpg](https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg) 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. ![gambar 7.jpg](https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg) 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 ![gambar 8.jpg](https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg) and we need to create some file in view folder i caled myapp.php ![gambar 9.jpg](https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg) 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 ![gambar 10.jpg](https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg) 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 ![gambar 12.jpg](https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg) oke... lets create some file in model folder i callded mymodel.php ![gambar 13.jpg](https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg) 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 ![gambar 14.jpg](https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg) 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 ![gambar 15.jpg](https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg) 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 permlinkutopian-io
permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
titleHow to build some website using codeigniter framework |PHP|
Transaction InfoBlock #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![codeigniter logo.png](https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png)\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![gambar 1.png](https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png)\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![gambar 2.jpg](https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg)\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![gambar 3.jpg](https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg)\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![gambar 4.jpg](https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg)\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![gambar 5.jpg](https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg)\nTo add a parameter, we only need to edit a few of the methods we have been created before:\n![gambar 6.jpg](https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg)\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![gambar 7.jpg](https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg)\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![gambar 8.jpg](https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg)\n\nand we need to create some file in view folder i caled myapp.php\n![gambar 9.jpg](https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg)\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![gambar 10.jpg](https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg)\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![gambar 12.jpg](https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg)\n\noke... lets create some file in model folder i callded mymodel.php\n![gambar 13.jpg](https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg)\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![gambar 14.jpg](https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg)\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![gambar 15.jpg](https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg)\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
}
2018/04/29 17:44:33
authorinstink
permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
votermoby-dick
weight10000 (100.00%)
Transaction InfoBlock #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
authorinstink
permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
votershibleehossain
weight10000 (100.00%)
Transaction InfoBlock #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
}
2018/04/29 17:08:30
allow curation rewardstrue
allow votestrue
authorinstink
extensions[[0,{"beneficiaries":[{"account":"utopian.pay","weight":1500}]}]]
max accepted payout1000000.000 SBD
percent steem dollars10000
permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
Transaction InfoBlock #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
}
2018/04/29 17:08:30
authorinstink
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 logo.png](https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png) 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![gambar 1.png](https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png) 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 ? ![gambar 2.jpg](https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg) - 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 ![gambar 3.jpg](https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg) 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. ![gambar 4.jpg](https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg) If we want to run it, we have to access url: localhost /website/index.php /wellcome/myapp. The result will look like the following. ![gambar 5.jpg](https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg) To add a parameter, we only need to edit a few of the methods we have been created before: ![gambar 6.jpg](https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg) 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. ![gambar 7.jpg](https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg) 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 ![gambar 8.jpg](https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg) and we need to create some file in view folder i caled myapp.php ![gambar 9.jpg](https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg) 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 ![gambar 10.jpg](https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg) 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 ![gambar 12.jpg](https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg) oke... lets create some file in model folder i callded mymodel.php ![gambar 13.jpg](https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg) 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 ![gambar 14.jpg](https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg) 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 ![gambar 15.jpg](https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg) 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 permlinkutopian-io
permlinkhow-to-build-some-website-using-codeigniter-framework-or-php-or
titleHow to build some website using codeigniter framework |PHP|
Transaction InfoBlock #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![codeigniter logo.png](https://cdn.utopian.io/posts/e5684b798a77d79f42d42fe77c21d01092c8codeigniter_logo.png)\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![gambar 1.png](https://cdn.utopian.io/posts/286a824c070141618f3d12d29185477be480gambar_1.png)\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![gambar 2.jpg](https://cdn.utopian.io/posts/294111c5595d91d2bd259c023859c78cf989gambar_2.jpg)\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![gambar 3.jpg](https://cdn.utopian.io/posts/eb25e2c768c4546b6f6c8f27ce6d3dfb6e14gambar_3.jpg)\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![gambar 4.jpg](https://cdn.utopian.io/posts/0cc561b7ac4dcafe12faecbbafafebcf7f33gambar_4.jpg)\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![gambar 5.jpg](https://cdn.utopian.io/posts/f743e316f995c0df1d5ca1f77248a9b53a8bgambar_5.jpg)\nTo add a parameter, we only need to edit a few of the methods we have been created before:\n![gambar 6.jpg](https://cdn.utopian.io/posts/e80362bb62d78ee906b5b3bb67e0b8462c94gambar_6.jpg)\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![gambar 7.jpg](https://cdn.utopian.io/posts/355062d4a3b1a934e51f951d3596ff866197gambar_7.jpg)\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![gambar 8.jpg](https://cdn.utopian.io/posts/ff7c2b58594440341a18bce8b6dc41f541begambar_8.jpg)\n\nand we need to create some file in view folder i caled myapp.php\n![gambar 9.jpg](https://cdn.utopian.io/posts/0b62c0e35c88a862c6c4840cae76b3c39d71gambar_9.jpg)\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![gambar 10.jpg](https://cdn.utopian.io/posts/3ad82428a7d156837c3122019de610979ad7gambar_10.jpg)\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![gambar 12.jpg](https://cdn.utopian.io/posts/dce65d65222bf11e00ec0961136a27826bafgambar_12.jpg)\n\noke... lets create some file in model folder i callded mymodel.php\n![gambar 13.jpg](https://cdn.utopian.io/posts/13276c7ebed3b5b753853f8a167852f5b75bgambar_13.jpg)\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![gambar 14.jpg](https://cdn.utopian.io/posts/a4cb8d0f2da9fe163feecbfd0b36f7b56ab8gambar_14.jpg)\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![gambar 15.jpg](https://cdn.utopian.io/posts/6ef551219890d121855b8de01b50754e8a3agambar_15.jpg)\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
authorsteemitboard
bodyCongratulations @instink! You have completed some achievement on Steemit and have been rewarded with new badge(s) : [![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/firstpost.png)](http://steemitboard.com/@instink) You published your First Post [![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/firstvoted.png)](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 authorinstink
parent permlinkhow-to-create-login-page-using-php-function-and-mysql-database
permlinksteemitboard-notify-instink-20180429t011008000z
title
Transaction InfoBlock #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[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/firstpost.png)](http://steemitboard.com/@instink) You published your First Post\n[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/firstvoted.png)](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
authorportugalcoin
bodyYour 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 authorinstink
parent permlinkhow-to-create-login-page-using-php-function-and-mysql-database
permlinkre-instink-how-to-create-login-page-using-php-function-and-mysql-database-20180428t185701137z
title
Transaction InfoBlock #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
}
2018/04/28 18:55:51
authorinstink
bodyWhat 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. ![gambar 1.jpg](https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg) Next it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ... ![gambar 2.jpg](https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg) 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... ![gambar 3.jpg](https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg) 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 ![gambar 5.jpg](https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg) 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 ![gambar 6.jpg](https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg) 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... ![gambar 7.jpg](https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg) 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... ![gambar 9.jpg](https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg) after you fill the form, just click **go** button ![gambar 10.jpg](https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg) after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this:![gambar 8.jpg](https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg) type your usernmae and password at the form and click login button ![gambar 11.jpg](https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg) <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 permlinkutopian-io
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
titlehow to create login page using php function and mysql database
Transaction InfoBlock #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![gambar 1.jpg](https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg)\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![gambar 2.jpg](https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg)\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![gambar 3.jpg](https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg)\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![gambar 5.jpg](https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg)\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![gambar 6.jpg](https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg)\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![gambar 7.jpg](https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg)\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![gambar 9.jpg](https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg)\n\nafter you fill the form, just click **go** button\n![gambar 10.jpg](https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg)\n\n after that lets test our login system, type** localhost/login/login.php** at your browser  search bar like this:![gambar 8.jpg](https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg)\n\n type your usernmae and password at the form and click login button\n![gambar 11.jpg](https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg)\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
}
2018/04/28 18:49:15
authorinstink
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
voterax3
weight100 (1.00%)
Transaction InfoBlock #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
authorintroduce.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 authorinstink
parent permlinkhow-to-create-login-page-using-php-function-and-mysql-database
permlinkintroduce-bot-re-instinkhow-to-create-login-page-using-php-function-and-mysql-database
title
Transaction InfoBlock #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
authorinstink
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
voterintroduce.bot
weight191 (1.91%)
Transaction InfoBlock #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
}
2018/04/28 18:49:00
authorinstink
bodyWhat 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. ![gambar 1.jpg](https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg) Next it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ... ![gambar 2.jpg](https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg) 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... ![gambar 3.jpg](https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg) 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 ![gambar 5.jpg](https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg) 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 ![gambar 6.jpg](https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg) 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... ![gambar 7.jpg](https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg) 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... ![gambar 9.jpg](https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg) after you fill the form, just click **go** button ![gambar 10.jpg](https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg) after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this:![gambar 8.jpg](https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg) type your usernmae and password at the form and click login button ![gambar 11.jpg](https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg) <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 permlinkutopian-io
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
titlehow to create login page using php function and mysql database
Transaction InfoBlock #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![gambar 1.jpg](https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg)\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![gambar 2.jpg](https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg)\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![gambar 3.jpg](https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg)\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![gambar 5.jpg](https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg)\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![gambar 6.jpg](https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg)\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![gambar 7.jpg](https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg)\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![gambar 9.jpg](https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg)\n\nafter you fill the form, just click **go** button\n![gambar 10.jpg](https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg)\n\n after that lets test our login system, type** localhost/login/login.php** at your browser  search bar like this:![gambar 8.jpg](https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg)\n\n type your usernmae and password at the form and click login button\n![gambar 11.jpg](https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg)\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
idfollow
json["follow",{"follower":"instink","following":"naufal","what":["blog"]}]
required auths[]
required posting auths["instink"]
Transaction InfoBlock #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
authorinstink
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
voterst3llar
weight300 (3.00%)
Transaction InfoBlock #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 properties
2018/04/28 17:35:33
accountinstink
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 keySTM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R
Transaction InfoBlock #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
}
2018/04/28 17:34:00
authorinstink
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
voterelektr1ker
weight10000 (100.00%)
Transaction InfoBlock #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
}
2018/04/28 17:29:36
allow curation rewardstrue
allow votestrue
authorinstink
extensions[[0,{"beneficiaries":[{"account":"utopian.pay","weight":1500}]}]]
max accepted payout1000000.000 SBD
percent steem dollars10000
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
Transaction InfoBlock #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
}
2018/04/28 17:29:36
authorinstink
bodyWhat 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. ![gambar 1.jpg](https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg) Next it will open the main view of phpMyAdmin, please create a new database by clicking the **Baru** or **Create** in English ... ![gambar 2.jpg](https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg) 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... ![gambar 3.jpg](https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg) 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 ![gambar 5.jpg](https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg) 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 ![gambar 6.jpg](https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg) 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... ![gambar 7.jpg](https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg) 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... ![gambar 9.jpg](https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg) after you fill the form, just click **go** button ![gambar 10.jpg](https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg) after that lets test our login system, type** localhost/login/login.php** at your browser search bar like this:![gambar 8.jpg](https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg) type your usernmae and password at the form and click login button ![gambar 11.jpg](https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg) <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 permlinkutopian-io
permlinkhow-to-create-login-page-using-php-function-and-mysql-database
titlehow to create login page using php function and mysql database
Transaction InfoBlock #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![gambar 1.jpg](https://cdn.utopian.io/posts/e0c9f927c13816a128176aa2b80f285e47a7gambar_1.jpg)\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![gambar 2.jpg](https://cdn.utopian.io/posts/c950f2e8ca1f7e9c7d2671e272cf2c6ef51dgambar_2.jpg)\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![gambar 3.jpg](https://cdn.utopian.io/posts/3ce682344fec60d12902dcf4d0737dce3d1bgambar_3.jpg)\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![gambar 5.jpg](https://cdn.utopian.io/posts/563f982b55182417f41558999c0419603540gambar_5.jpg)\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![gambar 6.jpg](https://cdn.utopian.io/posts/223b1eb1484a8116b4e3347a7941eb089e6fgambar_6.jpg)\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![gambar 7.jpg](https://cdn.utopian.io/posts/9dc376e82b0cf36bde89d9b57c95d0dd086dgambar_7.jpg)\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![gambar 9.jpg](https://cdn.utopian.io/posts/d582bc47cc7d401caa57195cd0c88c4b5a11gambar_9.jpg)\n\nafter you fill the form, just click **go** button\n![gambar 10.jpg](https://cdn.utopian.io/posts/ae8d33a9f08d4eaf3d7ece50f2dd26ca1866gambar_10.jpg)\n\n after that lets test our login system, type** localhost/login/login.php** at your browser  search bar like this:![gambar 8.jpg](https://cdn.utopian.io/posts/b14fab61bb117bceba98f42ffe6157c4f600gambar_8.jpg)\n\n type your usernmae and password at the form and click login button\n![gambar 11.jpg](https://cdn.utopian.io/posts/d03416c82a21d9a79dbb420c4a0c7a2cf144gambar_11.jpg)\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 properties
2018/04/28 14:13:21
accountinstink
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 keySTM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R
Transaction InfoBlock #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
}
steemdelegated 18.674 SP to @instink
2018/04/11 11:28:06
delegateeinstink
delegatorsteem
vesting shares30374.889833 VESTS
Transaction InfoBlock #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 properties
2018/04/11 10:15:51
accountinstink
json metadata{}
memo keySTM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R
posting{"account_auths":[["utopian.app",1]],"key_auths":[["STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",1]],"weight_threshold":1}
Transaction InfoBlock #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
}
steemcreated a new account: @instink
2018/04/11 10:12:09
active{"account_auths":[],"key_auths":[["STM7YPNGUhS6QJe2icvUcBMwKLXMUjurJwvNiZEBsnZDUnw5336V6",1]],"weight_threshold":1}
creatorsteem
delegation30690.000000 VESTS
extensions[]
fee0.100 STEEM
json metadata{}
memo keySTM83Z9K39bB4t8TvrScE9MNNguMGcdiT5EhcvYCWE8ibXuNtXz7R
new account nameinstink
owner{"account_auths":[],"key_auths":[["STM5SYxtaCMLiqwr4xnBr5kYiMajr1LhiQmfVxjidtUfNNC992aHY",1]],"weight_threshold":1}
posting{"account_auths":[],"key_auths":[["STM86GGpjk2LWVGWStpFwxLkdztCm7LdXqc34CVnENBgrWwL7ZL3c",1]],"weight_threshold":1}
Transaction InfoBlock #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
}

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
App Permissions
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.
[]