{
  "block": 106140399,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "5891.921991 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-17T21:42:06",
  "trx_id": "09fd8a58eea8e1304436893b5ee1b004372efc02",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 105964575,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "3179.711586 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-05-11T18:31:57",
  "trx_id": "05676da2fde49e1f4d91521528bbb6873c56836b",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 105508125,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "5904.437747 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-04-25T21:07:03",
  "trx_id": "c4cd2981a7d9c4a52f8c82604b6c76f73ba3712d",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 102843742,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "3221.258405 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2026-01-23T01:03:39",
  "trx_id": "336b42a4161a077daa11a38f0555d8ea1bb0cfca",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 91290161,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "3385.477602 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2024-12-16T20:23:33",
  "trx_id": "5ff068c68a6702a9f7d3ecbbee4d9c152d4a182b",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 79844442,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "3554.611134 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-11-13T12:09:33",
  "trx_id": "db4f8ee9f85d2d02cb897f3aa95eddc5c0e5e955",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 78344280,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "6491.889920 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2023-09-21T18:51:36",
  "trx_id": "2dc6ee24c782405ee5acc993d41759338a849b52",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 69110019,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "6713.571358 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-11-03T08:59:27",
  "trx_id": "e41c78038ba35738e1f0eef96a8af8da74ee54a0",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 60806460,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "6934.104589 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2022-01-17T08:28:45",
  "trx_id": "a166765755364e44a913d88a2e6de784d447961f",
  "trx_in_block": 8,
  "virtual_op": 0
}

{
  "block": 54604973,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "7117.873247 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2021-06-13T22:30:12",
  "trx_id": "d89e019fb658c6a230db002fbb5f25a038facab2",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 49352530,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "7305.295221 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-11T08:52:30",
  "trx_id": "94a1b61c8ec04b5e5ce773ba9f2f287095b1cf4a",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 49204099,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "1912.543513 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-12-06T02:30:03",
  "trx_id": "7f2e5c8f64d3c562666a6d0689d16c44698efb3b",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 48908419,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "7322.421838 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-11-25T16:25:06",
  "trx_id": "6ec4fa18af1caa158695c165be270f5d6e786c2a",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 43214310,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "7514.308434 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-09T03:24:51",
  "trx_id": "41408919e06d476038ffd1dcd816e6929b4d8ae1",
  "trx_in_block": 6,
  "virtual_op": 0
}

{
  "block": 43190001,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "1953.311140 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-05-08T06:40:15",
  "trx_id": "31b9182453433fb53ec52809f013f92c8e9718ba",
  "trx_in_block": 4,
  "virtual_op": 0
}

{
  "block": 42560843,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "7527.285853 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2020-04-15T20:08:18",
  "trx_id": "a78e71cd561d5c3da95bdc7e46749a459b376214",
  "trx_in_block": 11,
  "virtual_op": 0
}

{
  "block": 35405182,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @atan26! You received a personal award!\n\n<table><tr><td>https://steemitimages.com/70x70/http://steemitboard.com/@atan26/birthday2.png</td><td>Happy Birthday! - You are on the Steem blockchain for 2 years!</td></tr></table>\n\n<sub>_You can view [your badges on your Steem Board](https://steemitboard.com/@atan26) and compare to others on the [Steem Ranking](https://steemitboard.com/ranking/index.php?name=atan26)_</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": "atan26",
      "parent_permlink": "wonderful-of-aceh-north-salak-mountain-tour",
      "permlink": "steemitboard-notify-atan26-20190809t154553000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-08-09T15:45:54",
  "trx_id": "874bd2ddbda3e4453854f2063c479e95d7676feb",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 32843663,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "7722.908658 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2019-05-12T13:23:00",
  "trx_id": "4977bed72a7b06695d76a11faa28853306b01d57",
  "trx_in_block": 16,
  "virtual_op": 0
}

{
  "block": 24922130,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @atan26! You have received a personal award!\n\n[![](https://steemitimages.com/70x70/http://steemitboard.com/@atan26/birthday1.png)](http://steemitboard.com/@atan26)  1 Year on Steemit\n<sub>_Click on the badge to view your Board of Honor._</sub>\n\n\n> Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notify.png\"]}",
      "parent_author": "atan26",
      "parent_permlink": "wonderful-of-aceh-north-salak-mountain-tour",
      "permlink": "steemitboard-notify-atan26-20180809t171824000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-08-09T17:18:24",
  "trx_id": "d69a735027b384c8ab273311587f29e4ff80153c",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 22489638,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "7922.461093 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-05-16T20:06:51",
  "trx_id": "4a794b028062731f18001c33f323cc9b866e6563",
  "trx_in_block": 28,
  "virtual_op": 0
}

{
  "block": 21771063,
  "op": [
    "delegate_vesting_shares",
    {
      "delegatee": "atan26",
      "delegator": "steem",
      "vesting_shares": "28310.430133 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-04-21T20:38:45",
  "trx_id": "c39f97b713ef233a2eaa01cd49c1b1b69bee1725",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 19950341,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "wonderful-of-aceh-north-salak-mountain-tour",
      "voter": "dongkrak",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-17T13:53:45",
  "trx_id": "8beab3b0a22cc02ffb43b90b453a6192cf89d22f",
  "trx_in_block": 23,
  "virtual_op": 0
}

{
  "block": 19518818,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"steemcleaners\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-02T13:45:30",
  "trx_id": "d54a0dc1546ce89770a6cc69e3e18e70bd5cb91c",
  "trx_in_block": 30,
  "virtual_op": 0
}

{
  "block": 19518818,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"acidyo\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-02T13:45:30",
  "trx_id": "6d328f4c1cff28355664f244a0970922e508f5b1",
  "trx_in_block": 18,
  "virtual_op": 0
}

{
  "block": 19518818,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"gardenofeden\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-02T13:45:30",
  "trx_id": "847fb3ff3eb985cd9886e7710fedfa5facdaf66a",
  "trx_in_block": 5,
  "virtual_op": 0
}

{
  "block": 19483050,
  "op": [
    "author_reward",
    {
      "author": "atan26",
      "permlink": "how-to-split-or-retrieve-string-using-substr-php-function",
      "sbd_payout": "0.057 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "22.505935 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-01T07:54:00",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 37
}

{
  "block": 19483050,
  "op": [
    "comment_benefactor_reward",
    {
      "author": "atan26",
      "benefactor": "utopian.pay",
      "permlink": "how-to-split-or-retrieve-string-using-substr-php-function",
      "sbd_payout": "0.000 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "14.321958 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-02-01T07:54:00",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 36
}

{
  "block": 19465043,
  "op": [
    "comment",
    {
      "author": "andioeng",
      "body": "Postingan yang sangat bagus",
      "json_metadata": "{\"tags\":[\"story\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "atan26",
      "parent_permlink": "wonderful-of-aceh-north-salak-mountain-tour",
      "permlink": "re-atan26-wonderful-of-aceh-north-salak-mountain-tour-20180131t165223391z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-31T16:52:24",
  "trx_id": "00a1d246aa902704bfacbc13a8ce563a69b5cd9b",
  "trx_in_block": 66,
  "virtual_op": 0
}

{
  "block": 19465033,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "wonderful-of-aceh-north-salak-mountain-tour",
      "voter": "andioeng",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-31T16:51:54",
  "trx_id": "a26807b89b18bd7f5a87a7679161aed93e07c852",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 19461516,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "wonderful-of-aceh-north-salak-mountain-tour",
      "voter": "atan26",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-31T13:56:03",
  "trx_id": "d625536626e169ae2704cac4003093a937458321",
  "trx_in_block": 35,
  "virtual_op": 0
}

{
  "block": 19461516,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "![13597.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517406627/ix3jp7wczwqhj8bt4dek.jpg)\n\nThe semester break has arrived, it's time for us to choose a refreshing place, this time me with my friends choose one of the places known as the cold area of ​​course that is close to the north aceh you know, well this time we chose our holiday object that is, MOUNTAIN WEATHER SALAK, \n![13591.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517406712/trx2saf7nfjwbukdzp7u.jpg)\n\nBeing in the hilly area between North Aceh Regency and Bener Meriah Regency, beautiful natural scenery makes this new attraction become the center of attention for us to be the center of refreshing, this is our condition at lunch, and stop at one of the cafe in that area , ![13576.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517406805/gxzjzouiolyp3iypotul.jpg)\nfor you explorers and holiday enthusiasts you can come to this area, various places of attractions in provide, ranging from, swing of the request, coffee lovers and umbrellas hanging on a pine tree that is longing, and the place can say is the place some of the beauty world, north aceh, steemian greeting, busy, explorers story.",
      "json_metadata": "{\"community\":\"busy\",\"app\":\"busy/2.3.0\",\"format\":\"markdown\",\"image\":[\"https://steemitimages.com/0x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1517406627/ix3jp7wczwqhj8bt4dek.jpg\",\"https://steemitimages.com/0x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1517406712/trx2saf7nfjwbukdzp7u.jpg\",\"https://steemitimages.com/0x0/https://res.cloudinary.com/hpiynhbhq/image/upload/v1517406805/gxzjzouiolyp3iypotul.jpg\"],\"tags\":[\"story\",\"gunungsalak\",\"northaceh\",\"busy\"]}",
      "parent_author": "",
      "parent_permlink": "story",
      "permlink": "wonderful-of-aceh-north-salak-mountain-tour",
      "title": "Wonderful of aceh north salak mountain tour"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-31T13:56:03",
  "trx_id": "d625536626e169ae2704cac4003093a937458321",
  "trx_in_block": 35,
  "virtual_op": 0
}

{
  "block": 19413745,
  "op": [
    "comment",
    {
      "author": "amosbastian",
      "body": "Your contribution cannot be approved because it does not follow the [Utopian Rules](https://utopian.io/rules), and is considered as **plagiarism**. Plagiarism is not allowed on Utopian, and posts that engage in plagiarism will be flagged and hidden forever.\n\nYou plagiarised from https://www.sourcecodester.com/php/11539/simple-sign-form-validation-phpmysql.html.\n\nYou can contact us on [Discord](https://discord.gg/uTyJkNm).\n**[[utopian-moderator]](https://utopian.io/moderators)**",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"community\":\"utopian\",\"app\":\"utopian/1.0.0\"}",
      "parent_author": "atan26",
      "parent_permlink": "how-to-make-simple-sign-up-form-with-validation-php-mysqli",
      "permlink": "re-atan26-how-to-make-simple-sign-up-form-with-validation-php-mysqli-20180129t220446908z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-29T22:04:48",
  "trx_id": "ce9a5e6cb36362a758532f51fc874039b110d12a",
  "trx_in_block": 16,
  "virtual_op": 0
}

{
  "block": 19413738,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "\n#### What Will I Learn?\n\n\n- You will learn How to create database\n- You will learn How to create a table in the database\n- You will learn How to make connection to database with php file\n- You will learn How to create a simple Sign Up form\n\n#### Requirements\n - You have basic about HTML\n - You have basic about PHP\n - You have basic about MySQL\n - To practice this tutorial you must have a webserver, text editor and browser. In this tutorial I use (XAMPP) for webserver, (Notepad ++) for text editor and (Google Crome) for browser.\n#### Difficulty\nEither choose between the following options:\n- Intermediate\n#### Tutorial Contents\n![f3.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517160055/g43mlwkxbvkgmnsurbsb.jpg)\nThis tutorial will show you how to create a simple sign up form with validation using PHP/MySQLi. This tutorial does not include a good design but will give you an idea on how to create a simple Sign Up form using PHP/MySQLi.\n - **How to create database ?**\n - First, we're going to create a database that will store our data.\n1. Open phpMyAdmin.\n2. Click databases, create a database and name it as sign_up.\n3. Click Button Create \n - Example, See image below for detailed instruction;\n![f1.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517152799/dciul5fiszopfmwwgzta.jpg)\n - **How to create a table in the database?**\n - Secondly, after creating a database,\n4.Click the SQL.\n5.Paste the below code.\n6.Click Button Go\n - Example, See image below for detailed instruction;\n![f2.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517155558/tjecggta2tfuv4go9del.jpg)\n - **Insert Query**\n```\nCREATE TABLE `user` (\n  `userid` INT(11) NOT NULL AUTO_INCREMENT,\n  `username` VARCHAR(30) NOT NULL,\n  `password` VARCHAR(30) NOT NULL,\n  `email_add` VARCHAR(100) NOT NULL,\n  `fullname` VARCHAR(100) NOT NULL,\n   PRIMARY KEY (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;\n```\n - **How to make connection to database with php file?**\n - After create a table in the database, Next, we create a database connection and save it as \"conn.php\". This file will serve as our bridge between our form and our database.\n- Script file (conn.php)\n```\n<?php\n$con = mysqli_connect(\"localhost\",\"root\",\"\",\"sign_up\");\n// Check connection\nif (mysqli_connect_errno())\n  {\n  echo \"Failed to connect to MySQL: \" . mysqli_connect_error();\n  }\n?>\n```\n -  **Lastly, How to create a simple Sign Up form ?**\nFinaly, we create our sign up form with the save script and save it as \"index.php\". In this form, the inputted data will be saved upon user submission if there are no errors in the input. To create the form, open your HTML code editor and paste the code below after the tag.\n - Script file (index.php)\n```\n<!DOCTYPE HTML>  \n<html>\n<head>\n<title>Register and Login Form with Validation PHP, MySQLi</title>\n<style>\n.error {color: #FF0000;}\n</style>\n</head>\n<body>  \n<?php\n// define variables and set to empty values\n$Message = $ErrorUname = $ErrorPass = $ErrorEmail = $ErrorName = \"\";\n$username = $password = $email = $fullname = \"\";\nif ($_SERVER[\"REQUEST_METHOD\"] == \"POST\") {\n  if (empty($_POST[\"username\"])) {\n    $ErrorUname = \"Userame is required\";\n  } else {\n    $username = check_input($_POST[\"username\"]);\n    // check if name only contains letters and whitespace\n    if (!preg_match(\"/^[a-zA-Z0-9_]*$/\",$username)) {\n      $ErrorUname = \"Space and special characters not allowed but you can use underscore(_).\"; \n    }\n\telse{\n\t\t$fusername=$username;\n\t}\n  }\n  if (empty($_POST[\"password\"])) {\n    $ErrorPass = \"Password is required\";\n  } else {\n    $fpassword = check_input($_POST[\"password\"]);\n  }\n  if (empty($_POST[\"email\"])) {\n    $ErrorEmail = \"Email is required\";\n  } else {\n    $email = check_input($_POST[\"email\"]);\n    // check if e-mail address is well-formed\n    if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {\n      $ErrorEmail = \"Invalid email format\"; \n    }\n\telse{\n\t\t$femail=$email;\n\t}\n  }\n if (empty($_POST[\"fullname\"])) {\n    $ErrorName = \"Full name is required\";\n  } else {\n    $fullname = check_input($_POST[\"fullname\"]);\n    // check if name only contains letters and whitespace\n    if (!preg_match(\"/^[a-zA-Z ]*$/\",$fullname)) {\n      $ErrorName = \"Only letters and white space allowed\"; \n    }\n\telse{\n\t\t$ffullname=$fullname;\n\t}\n  }\n  if ($ErrorUname!=\"\" OR $ErrorPass!=\"\" OR $ErrorEmail!=\"\" OR $ErrorName!=\"\"){\n\t$Message = \"Registration failed! Errors found\";\n  }\n  else{\n  include('conn.php');\n  mysqli_query($conn,\"insert into `user` (username,password,email_add,fullname) values ('$fusername','$fpassword','$femail','$ffullname')\");\n  $Message = \"Registration Successful!\";\n  }\n}\nfunction check_input($data) {\n  $data = trim($data);\n  $data = stripslashes($data);\n  $data = htmlspecialchars($data);\n  return $data;\n}\n?>\n<h2>Sign Up Form</h2>\n<p><span class=\"error\">* required field.</span></p>\n<form method=\"post\" action=\"<?php echo htmlspecialchars($_SERVER[\"PHP_SELF\"]);?>\">  \n  Username: <input type=\"text\" name=\"username\">\n  <span class=\"error\">* <?php echo $ErrorUname;?></span>\n  <br><br>\n  Password: <input type=\"password\" name=\"password\">\n  <span class=\"error\">* <?php echo $ErrorPass;?></span>\n  <br><br>\n  Email: <input type=\"text\" name=\"email\">\n  <span class=\"error\">* <?php echo $ErrorEmail;?></span>\n  <br><br>\n  Name: <input type=\"text\" name=\"fullname\">\n  <span class=\"error\">* <?php echo $ErrorName;?></span>\n  <br><br>\n  <input type=\"submit\" name=\"submit\" value=\"Submit\">\n  <br><br>\n  <span class=\"error\"><?php echo $Message;?></span>\n</form>\n</body>\n</html>\n```\n - Have a great time doing it..Good Luck \n#### Curriculum\n- [How to Split or Retrieve String using substr() php function]\n- [How to Display the Number of MySQL Table Rows (mysql_num_rows)]\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@atan26/how-to-make-simple-sign-up-form-with-validation-php-mysqli\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":1017748,\"name\":\"PHP-MySQLi-Database-Class\",\"full_name\":\"ThingEngineer/PHP-MySQLi-Database-Class\",\"html_url\":\"https://github.com/ThingEngineer/PHP-MySQLi-Database-Class\",\"fork\":false,\"owner\":{\"login\":\"ThingEngineer\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"tutorials\",\"opensource\",\"php\",\"aceh\"],\"links\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517160055/g43mlwkxbvkgmnsurbsb.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517152799/dciul5fiszopfmwwgzta.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517155558/tjecggta2tfuv4go9del.jpg\"],\"image\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517160055/g43mlwkxbvkgmnsurbsb.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517152799/dciul5fiszopfmwwgzta.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517155558/tjecggta2tfuv4go9del.jpg\"],\"moderator\":{\"account\":\"amosbastian\",\"time\":\"2018-01-29T22:04:26.207Z\",\"flagged\":true,\"reviewed\":false,\"pending\":false}}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "how-to-make-simple-sign-up-form-with-validation-php-mysqli",
      "title": "How To Make Simple Sign Up Form with Validation PHP/MySQLi"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-29T22:04:27",
  "trx_id": "fb95561a8dd5b4e3409f6ebf418cc3e9db98916d",
  "trx_in_block": 2,
  "virtual_op": 0
}

{
  "block": 19379562,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "how-to-make-simple-sign-up-form-with-validation-php-mysqli",
      "voter": "lachmankukreja",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-28T17:34:54",
  "trx_id": "f455990d29998bbea21b8364592c0e9cac0ee1b6",
  "trx_in_block": 33,
  "virtual_op": 0
}

{
  "block": 19379540,
  "op": [
    "comment_options",
    {
      "allow_curation_rewards": true,
      "allow_votes": true,
      "author": "atan26",
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "utopian.pay",
                "weight": 2500
              }
            ]
          }
        ]
      ],
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "permlink": "how-to-make-simple-sign-up-form-with-validation-php-mysqli"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-28T17:33:48",
  "trx_id": "06096dafb77e40c383694cf11aaba9a8d93d50df",
  "trx_in_block": 36,
  "virtual_op": 0
}

{
  "block": 19379540,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "\n#### What Will I Learn?\n\n\n- You will learn How to create database\n- You will learn How to create a table in the database\n- You will learn How to make connection to database with php file\n- You will learn How to create a simple Sign Up form\n\n#### Requirements\n - You have basic about HTML\n - You have basic about PHP\n - You have basic about MySQL\n - To practice this tutorial you must have a webserver, text editor and browser. In this tutorial I use (XAMPP) for webserver, (Notepad ++) for text editor and (Google Crome) for browser.\n#### Difficulty\nEither choose between the following options:\n- Intermediate\n#### Tutorial Contents\n![f3.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517160055/g43mlwkxbvkgmnsurbsb.jpg)\nThis tutorial will show you how to create a simple sign up form with validation using PHP/MySQLi. This tutorial does not include a good design but will give you an idea on how to create a simple Sign Up form using PHP/MySQLi.\n - **How to create database ?**\n - First, we're going to create a database that will store our data.\n1. Open phpMyAdmin.\n2. Click databases, create a database and name it as sign_up.\n3. Click Button Create \n - Example, See image below for detailed instruction;\n![f1.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517152799/dciul5fiszopfmwwgzta.jpg)\n - **How to create a table in the database?**\n - Secondly, after creating a database,\n4.Click the SQL.\n5.Paste the below code.\n6.Click Button Go\n - Example, See image below for detailed instruction;\n![f2.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1517155558/tjecggta2tfuv4go9del.jpg)\n - **Insert Query**\n```\nCREATE TABLE `user` (\n  `userid` INT(11) NOT NULL AUTO_INCREMENT,\n  `username` VARCHAR(30) NOT NULL,\n  `password` VARCHAR(30) NOT NULL,\n  `email_add` VARCHAR(100) NOT NULL,\n  `fullname` VARCHAR(100) NOT NULL,\n   PRIMARY KEY (`userid`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;\n```\n - **How to make connection to database with php file?**\n - After create a table in the database, Next, we create a database connection and save it as \"conn.php\". This file will serve as our bridge between our form and our database.\n- Script file (conn.php)\n```\n<?php\n$con = mysqli_connect(\"localhost\",\"root\",\"\",\"sign_up\");\n// Check connection\nif (mysqli_connect_errno())\n  {\n  echo \"Failed to connect to MySQL: \" . mysqli_connect_error();\n  }\n?>\n```\n -  **Lastly, How to create a simple Sign Up form ?**\nFinaly, we create our sign up form with the save script and save it as \"index.php\". In this form, the inputted data will be saved upon user submission if there are no errors in the input. To create the form, open your HTML code editor and paste the code below after the tag.\n - Script file (index.php)\n```\n<!DOCTYPE HTML>  \n<html>\n<head>\n<title>Register and Login Form with Validation PHP, MySQLi</title>\n<style>\n.error {color: #FF0000;}\n</style>\n</head>\n<body>  \n<?php\n// define variables and set to empty values\n$Message = $ErrorUname = $ErrorPass = $ErrorEmail = $ErrorName = \"\";\n$username = $password = $email = $fullname = \"\";\nif ($_SERVER[\"REQUEST_METHOD\"] == \"POST\") {\n  if (empty($_POST[\"username\"])) {\n    $ErrorUname = \"Userame is required\";\n  } else {\n    $username = check_input($_POST[\"username\"]);\n    // check if name only contains letters and whitespace\n    if (!preg_match(\"/^[a-zA-Z0-9_]*$/\",$username)) {\n      $ErrorUname = \"Space and special characters not allowed but you can use underscore(_).\"; \n    }\n\telse{\n\t\t$fusername=$username;\n\t}\n  }\n  if (empty($_POST[\"password\"])) {\n    $ErrorPass = \"Password is required\";\n  } else {\n    $fpassword = check_input($_POST[\"password\"]);\n  }\n  if (empty($_POST[\"email\"])) {\n    $ErrorEmail = \"Email is required\";\n  } else {\n    $email = check_input($_POST[\"email\"]);\n    // check if e-mail address is well-formed\n    if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {\n      $ErrorEmail = \"Invalid email format\"; \n    }\n\telse{\n\t\t$femail=$email;\n\t}\n  }\n if (empty($_POST[\"fullname\"])) {\n    $ErrorName = \"Full name is required\";\n  } else {\n    $fullname = check_input($_POST[\"fullname\"]);\n    // check if name only contains letters and whitespace\n    if (!preg_match(\"/^[a-zA-Z ]*$/\",$fullname)) {\n      $ErrorName = \"Only letters and white space allowed\"; \n    }\n\telse{\n\t\t$ffullname=$fullname;\n\t}\n  }\n  if ($ErrorUname!=\"\" OR $ErrorPass!=\"\" OR $ErrorEmail!=\"\" OR $ErrorName!=\"\"){\n\t$Message = \"Registration failed! Errors found\";\n  }\n  else{\n  include('conn.php');\n  mysqli_query($conn,\"insert into `user` (username,password,email_add,fullname) values ('$fusername','$fpassword','$femail','$ffullname')\");\n  $Message = \"Registration Successful!\";\n  }\n}\nfunction check_input($data) {\n  $data = trim($data);\n  $data = stripslashes($data);\n  $data = htmlspecialchars($data);\n  return $data;\n}\n?>\n<h2>Sign Up Form</h2>\n<p><span class=\"error\">* required field.</span></p>\n<form method=\"post\" action=\"<?php echo htmlspecialchars($_SERVER[\"PHP_SELF\"]);?>\">  \n  Username: <input type=\"text\" name=\"username\">\n  <span class=\"error\">* <?php echo $ErrorUname;?></span>\n  <br><br>\n  Password: <input type=\"password\" name=\"password\">\n  <span class=\"error\">* <?php echo $ErrorPass;?></span>\n  <br><br>\n  Email: <input type=\"text\" name=\"email\">\n  <span class=\"error\">* <?php echo $ErrorEmail;?></span>\n  <br><br>\n  Name: <input type=\"text\" name=\"fullname\">\n  <span class=\"error\">* <?php echo $ErrorName;?></span>\n  <br><br>\n  <input type=\"submit\" name=\"submit\" value=\"Submit\">\n  <br><br>\n  <span class=\"error\"><?php echo $Message;?></span>\n</form>\n</body>\n</html>\n```\n - Have a great time doing it..Good Luck \n#### Curriculum\n- [How to Split or Retrieve String using substr() php function]\n- [How to Display the Number of MySQL Table Rows (mysql_num_rows)]\n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@atan26/how-to-make-simple-sign-up-form-with-validation-php-mysqli\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":1017748,\"name\":\"PHP-MySQLi-Database-Class\",\"full_name\":\"ThingEngineer/PHP-MySQLi-Database-Class\",\"html_url\":\"https://github.com/ThingEngineer/PHP-MySQLi-Database-Class\",\"fork\":false,\"owner\":{\"login\":\"ThingEngineer\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"tutorials\",\"opensource\",\"php\",\"aceh\"],\"links\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517160055/g43mlwkxbvkgmnsurbsb.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517152799/dciul5fiszopfmwwgzta.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517155558/tjecggta2tfuv4go9del.jpg\"],\"image\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517160055/g43mlwkxbvkgmnsurbsb.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517152799/dciul5fiszopfmwwgzta.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1517155558/tjecggta2tfuv4go9del.jpg\"]}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "how-to-make-simple-sign-up-form-with-validation-php-mysqli",
      "title": "How To Make Simple Sign Up Form with Validation PHP/MySQLi"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-28T17:33:48",
  "trx_id": "06096dafb77e40c383694cf11aaba9a8d93d50df",
  "trx_in_block": 36,
  "virtual_op": 0
}

{
  "block": 19379430,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"lapulga\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-28T17:28:18",
  "trx_id": "b4d732a89e23ff8523f9e29a895a1adbbd460216",
  "trx_in_block": 21,
  "virtual_op": 0
}

{
  "block": 19349396,
  "op": [
    "comment",
    {
      "author": "amosbastian",
      "body": "Your contribution cannot be approved because it does not follow the [Utopian Rules](https://utopian.io/rules).\n\nThis tutorial is very basic and holds little to no value, anyone can find out how to use this function without the help of a tutorial.\n\nYou can contact us on [Discord](https://discord.gg/uTyJkNm).\n**[[utopian-moderator]](https://utopian.io/moderators)**",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"community\":\"utopian\",\"app\":\"utopian/1.0.0\"}",
      "parent_author": "atan26",
      "parent_permlink": "how-to-display-the-number-of-mysql-table-rows-mysqlnumrows",
      "permlink": "re-atan26-how-to-display-the-number-of-mysql-table-rows-mysqlnumrows-20180127t162611246z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-27T16:26:12",
  "trx_id": "cf413ca3d2ef8765614eb4976a7374e61a766ed7",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 19349354,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "\n#### What Will I Learn?\n\n\n- You will learn How to display the number of rows from the MySQL Table\n- You will learn How to use the mysql_num_rows function\n- You will learn How to Use the mysql_affected_rows Function\n\n#### Requirements\n - You should be able to program basic php and HTML\n - You have to have text editor,media (CMD), browser, and web server to run it, then in this tutorial I use text editor that is (Notepad ++), and using chrome browser, and its web server is XAMPP Control Pane v3.2.2.\n\n\n\n#### Difficulty\nEither choose between the following options:\n\n- Basic\n\n\n#### Tutorial Contents\nIn this PHP MySQL tutorial this time I will discuss 2 functions, PHP used to display the number of rows of MySQL Table. The functions we will discuss are mysql_num_rows and mysql_affected_rows.\n - **How to use the mysql_num_rows function**\n - explanation\nThe mysql_num_rows () function is used to find out how many number of rows mysql_query function calls (). This function requires 1 argument, the resource variable resulted from the mysql_query () function.\n - **examples of its use:**\n \n||\n <?php\n//buat koneksi dengan MySQL\n$link=mysql_connect('localhost','root','');\n \n//jika koneksi gagal, langsung get out from PHP\nif (!$link)\n{\n   die(\"Koneksi dengan MySQL gagal\");\n}\n \n//gunakan database politeknik\n$result=mysql_query('USE politeknik');\nif (!$result)\n{\n   die(\"Database mahasiswa gagal digunakan\");\n} \n//jalankan query\n$result=mysql_query(\"SELECT * FROM mahasiswa\");\necho \"Total mahasiswa berjumlah \".mysql_num_rows($result).\" orang.\";\n?>\n||\n \n -  **if the above code is executed, then the results obtained are as follows:**\n | Total mahasiswa berjumlah 5 orang |\n - explanation\n The mysql_num_rows () function is suitable if we only want confirmation about whether or not a data is in the database.\n -  **How to Use the mysql_affected_rows Function ?**\nThe mysql_affected_rows () function is used to determine the number of rows of tables that are processed by MySQL queries. These results are usually necessary if we want to know in more detail about the ongoing process.\n\nFor example, we want to do a DELETE operation to a table. This can be done with the mysql_query function. But we can not know how many rows have been deleted.\n\nIf using MySQL, this information immediately after the query:\n![c2.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516981024/tgx2h43nbe6cs7ww3ija.jpg)\n\n - Then To retrieve this information from PHP, I use the mysql_affected_rows () function. Here is an example of its use:\n||\n<?php\n//buat koneksi dengan MySQL\n$link=mysql_connect('localhost','root','');\n \n//jika koneksi gagal, langsung get outi from PHP\nif (!$link)\n   {\n   die(\"Koneksi dengan MySQL gagal\");\n   }\n \n//gunakan database politeknik\n$result=mysql_query('USE politeknik');\nif (!$result)\n{\n   die(\"Database mahasiswa gagal digunakan\");\n}\n \n//jalankan query\n$result=mysql_query(\"DELETE FROM mahasiswa_ilkom WHERE umur='22'\");\necho \"Data yang di hapus sebanyak: \".mysql_affected_rows().\" orang.\";\n?>\n||\n|Data yang di hapus sebanyak: 2 orang.\nBoth mysql_num_rows and mysql_affected_rows functions are often used in situations where we need information about MySQL queries that are executed. Both of these functions complement the other functions we have learned in this MySQL PHP tutorial\n\n#### Curriculum\nHow to Split or Retrieve String using substr() php function\n\n\n\n    \n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@atan26/how-to-display-the-number-of-mysql-table-rows-mysqlnumrows\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":1903522,\"name\":\"php-src\",\"full_name\":\"php/php-src\",\"html_url\":\"https://github.com/php/php-src\",\"fork\":false,\"owner\":{\"login\":\"php\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"tutorials\",\"opensource\",\"php\",\"utopian-io\"],\"links\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516981024/tgx2h43nbe6cs7ww3ija.jpg\"],\"image\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516981024/tgx2h43nbe6cs7ww3ija.jpg\"],\"moderator\":{\"account\":\"amosbastian\",\"time\":\"2018-01-27T16:24:07.651Z\",\"flagged\":true,\"reviewed\":false,\"pending\":false}}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "how-to-display-the-number-of-mysql-table-rows-mysqlnumrows",
      "title": "How to Display the Number of MySQL Table Rows (mysql_num_rows)"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-27T16:24:06",
  "trx_id": "1c61dab3cbde5ee591b84b13b6596636f9658818",
  "trx_in_block": 48,
  "virtual_op": 0
}

{
  "block": 19321071,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "how-to-display-the-number-of-mysql-table-rows-mysqlnumrows",
      "voter": "ubg",
      "weight": 100
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-26T16:48:27",
  "trx_id": "74dc2d5d7321078f1e85ae89cdd9113d8198102e",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 19320693,
  "op": [
    "comment_options",
    {
      "allow_curation_rewards": true,
      "allow_votes": true,
      "author": "atan26",
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "utopian.pay",
                "weight": 2500
              }
            ]
          }
        ]
      ],
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "permlink": "how-to-display-the-number-of-mysql-table-rows-mysqlnumrows"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-26T16:29:30",
  "trx_id": "b69e11d431e7f594dc6c623bbb98372ca61364f0",
  "trx_in_block": 13,
  "virtual_op": 0
}

{
  "block": 19320693,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "\n#### What Will I Learn?\n\n\n- You will learn How to display the number of rows from the MySQL Table\n- You will learn How to use the mysql_num_rows function\n- You will learn How to Use the mysql_affected_rows Function\n\n#### Requirements\n - You should be able to program basic php and HTML\n - You have to have text editor,media (CMD), browser, and web server to run it, then in this tutorial I use text editor that is (Notepad ++), and using chrome browser, and its web server is XAMPP Control Pane v3.2.2.\n\n\n\n#### Difficulty\nEither choose between the following options:\n\n- Basic\n\n\n#### Tutorial Contents\nIn this PHP MySQL tutorial this time I will discuss 2 functions, PHP used to display the number of rows of MySQL Table. The functions we will discuss are mysql_num_rows and mysql_affected_rows.\n - **How to use the mysql_num_rows function**\n - explanation\nThe mysql_num_rows () function is used to find out how many number of rows mysql_query function calls (). This function requires 1 argument, the resource variable resulted from the mysql_query () function.\n - **examples of its use:**\n \n||\n <?php\n//buat koneksi dengan MySQL\n$link=mysql_connect('localhost','root','');\n \n//jika koneksi gagal, langsung get out from PHP\nif (!$link)\n{\n   die(\"Koneksi dengan MySQL gagal\");\n}\n \n//gunakan database politeknik\n$result=mysql_query('USE politeknik');\nif (!$result)\n{\n   die(\"Database mahasiswa gagal digunakan\");\n} \n//jalankan query\n$result=mysql_query(\"SELECT * FROM mahasiswa\");\necho \"Total mahasiswa berjumlah \".mysql_num_rows($result).\" orang.\";\n?>\n||\n \n -  **if the above code is executed, then the results obtained are as follows:**\n | Total mahasiswa berjumlah 5 orang |\n - explanation\n The mysql_num_rows () function is suitable if we only want confirmation about whether or not a data is in the database.\n -  **How to Use the mysql_affected_rows Function ?**\nThe mysql_affected_rows () function is used to determine the number of rows of tables that are processed by MySQL queries. These results are usually necessary if we want to know in more detail about the ongoing process.\n\nFor example, we want to do a DELETE operation to a table. This can be done with the mysql_query function. But we can not know how many rows have been deleted.\n\nIf using MySQL, this information immediately after the query:\n![c2.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516981024/tgx2h43nbe6cs7ww3ija.jpg)\n\n - Then To retrieve this information from PHP, I use the mysql_affected_rows () function. Here is an example of its use:\n||\n<?php\n//buat koneksi dengan MySQL\n$link=mysql_connect('localhost','root','');\n \n//jika koneksi gagal, langsung get outi from PHP\nif (!$link)\n   {\n   die(\"Koneksi dengan MySQL gagal\");\n   }\n \n//gunakan database politeknik\n$result=mysql_query('USE politeknik');\nif (!$result)\n{\n   die(\"Database mahasiswa gagal digunakan\");\n}\n \n//jalankan query\n$result=mysql_query(\"DELETE FROM mahasiswa_ilkom WHERE umur='22'\");\necho \"Data yang di hapus sebanyak: \".mysql_affected_rows().\" orang.\";\n?>\n||\n|Data yang di hapus sebanyak: 2 orang.\nBoth mysql_num_rows and mysql_affected_rows functions are often used in situations where we need information about MySQL queries that are executed. Both of these functions complement the other functions we have learned in this MySQL PHP tutorial\n\n#### Curriculum\nHow to Split or Retrieve String using substr() php function\n\n\n\n    \n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@atan26/how-to-display-the-number-of-mysql-table-rows-mysqlnumrows\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":1903522,\"name\":\"php-src\",\"full_name\":\"php/php-src\",\"html_url\":\"https://github.com/php/php-src\",\"fork\":false,\"owner\":{\"login\":\"php\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"tutorials\",\"opensource\",\"php\",\"utopian-io\"],\"links\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516981024/tgx2h43nbe6cs7ww3ija.jpg\"],\"image\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516981024/tgx2h43nbe6cs7ww3ija.jpg\"]}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "how-to-display-the-number-of-mysql-table-rows-mysqlnumrows",
      "title": "How to Display the Number of MySQL Table Rows (mysql_num_rows)"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-26T16:29:30",
  "trx_id": "b69e11d431e7f594dc6c623bbb98372ca61364f0",
  "trx_in_block": 13,
  "virtual_op": 0
}

{
  "block": 19319767,
  "op": [
    "comment",
    {
      "author": "amosbastian",
      "body": "Your contribution cannot be approved because it is not as informative as other contributions. See the [Utopian Rules](https://utopian.io/rules). \n\n>Contributions need to be informative and descriptive in order to help readers and developers understand them.\n\n>End-user focused tutorials must address a minimum of three substantial concepts that are unique to the Open Source project and essential learning requirements for end-users.\n\nJust using the `substr()` function isn't complex enough to write a tutorial about. In the future I would recommend finding something to write about that isn't as straightforward.\n\nYou can contact us on [Discord](https://discord.gg/uTyJkNm).\n**[[utopian-moderator]](https://utopian.io/moderators)**",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"community\":\"utopian\",\"app\":\"utopian/1.0.0\"}",
      "parent_author": "atan26",
      "parent_permlink": "how-to-split-or-retrieve-string-using-substr-php-function",
      "permlink": "re-atan26-how-to-split-or-retrieve-string-using-substr-php-function-20180126t154049077z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-26T15:43:12",
  "trx_id": "657d50befc2ad549cb5b9135e1c00031c4cac132",
  "trx_in_block": 17,
  "virtual_op": 0
}

{
  "block": 19319620,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "\n#### What Will I Learn?\n\n- You will learn  How to Take Character From Early String\n- You will learn How to Take Character From Middle String\n- You will learn How to Take Characters From the last String\n\n#### Requirements\n\n- You should be able to program basic php and HTML\n- You have to have text editor, browser, and web server to run it, then in this tutorial I use text editor that is (Notepad ++), and using chrome browser, and its web server is XAMPP Control Pane v3.2.2.\n\n#### Difficulty\n- Basic\n\n\n#### Tutorial Contents\n   In PHP tutorial tutorial this time I will discuss a simple function that is quite often used, namely substr () function. The substr () function is used to bypass a string or to extract some value from a string inside PHP.\nGetting to know the substr () function\nThe function substr () is a PHP function to bypass a string, or to extract some value from a string. This feature is quite often used in the process of creating PHP programs, especially those that require string manipulation.\n\nFor example, suppose we have a date-shaped string: \"26-06-2016\". How to retrieve the month value of the string, the \"06\" character?\n\nAnother example, say a student's NIM consists of 10 digits: 1557301058 \". The first two digits are the year of student entry, the next two digits of the department code, and the last four digits are the serial number of the student. How do I separate these digits?\nand the following below I will explain one by one how to use this subtr () function.\n\n- first turn on XAMPP as its web server\n![1.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516859688/uqcka0sjeg3muztoskng.jpg)\n - then open notepad as text editor, then input program script like in picture below\n![2.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516860240/egkwduokhn1xfwyrxr2n.jpg)\n - then open the chrome browser to display the results of the notepad coding that has been typed in the example;\n```\n<?php\n$meuruno = \"Belajar PHP Notepad Bek ka eh\";\n$sub_meuruno = substr($meuruno,0);\necho $sub_meuruno;\n// meuruno PHP bek ehh\n?>\n```\n - then the results on its browser are as below;\n![3.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516861329/fvoiuhhrjwwyvwyzwh3o.jpg)\n - **Now ,How to Take Character From Early String ?**\nThe first use of the substr () function that we will discuss is how to take a character that starts from the beginning of the string. Here is an example of its use:\n```\n<?php\n$meuruno = \"You And I \";\n$sub_meuruno = substr($meuruno,1);\necho $sub_meuruno;\n// How to Make Character from Early String \n?>\n```\n - Output\n![4.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516862611/nlygtjjzt3msidpdouqw.jpg)\n - explanation\nIn the code above, I took the string $ meuruno starting from the index to-1. If the substr () function is written with 2 arguments like this, and the second argument is positive, then the substr () function returns the string value $ meuruno starting from the 2nd letter, the letter \"O\" to the end of the string.\n - **Then, How to Take Character From Middle String ?**\nHere is an example of its use:\n```\n<?php\n$meuruno = \"You And I \";\n$sub_meuruno = substr($meuruno,4,-2);\necho $sub_meuruno;\n// How to Make Character from middle String \n?>\n```\n - Output\n![5.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516865134/x4qucpjl2dpju9irmjtx.jpg)\n\n - explanation\nThe function substr () also has arguments (4, -2) which are optional (may be filled or emptied). If we add a fourth argument, this value serves as a determinant of 'how many characters to extract'\n - **Last, How to Take Characters From the last String?**\nApart from the start of the string, we can also take characters starting from the end of the string. The trick is to assign a negative value to the second argument of the substr () function. Immediately we see examples of its use:\n```\n<?php\n$meuruno = \"You And I \";\n$sub_meuruno = substr($meuruno,7);\necho $sub_meuruno;\n// How to Make Character from last String \n?>\n```\n - Output\n![6.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516866317/fnwbehtokxn968kdwg4x.jpg)\n\n - explanation\nPartial retrieval of string values ​​is quite often used. PHP provides substr () functions for this purpose. the substr () function is very practical for cutting a string or taking some value from a string inside PHP.\n\n\n#### Curriculum\nThis is my first contributions \n    \n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@atan26/how-to-split-or-retrieve-string-using-substr-php-function\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":1903522,\"name\":\"php-src\",\"full_name\":\"php/php-src\",\"html_url\":\"https://github.com/php/php-src\",\"fork\":false,\"owner\":{\"login\":\"php\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"tutorials\",\"opensource\",\"php\",\"aceh\"],\"links\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516859688/uqcka0sjeg3muztoskng.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516860240/egkwduokhn1xfwyrxr2n.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516861329/fvoiuhhrjwwyvwyzwh3o.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516862611/nlygtjjzt3msidpdouqw.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516865134/x4qucpjl2dpju9irmjtx.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516866317/fnwbehtokxn968kdwg4x.jpg\"],\"image\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516859688/uqcka0sjeg3muztoskng.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516860240/egkwduokhn1xfwyrxr2n.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516861329/fvoiuhhrjwwyvwyzwh3o.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516862611/nlygtjjzt3msidpdouqw.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516865134/x4qucpjl2dpju9irmjtx.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516866317/fnwbehtokxn968kdwg4x.jpg\"],\"moderator\":{\"account\":\"amosbastian\",\"time\":\"2018-01-26T15:35:50.365Z\",\"flagged\":true,\"reviewed\":false,\"pending\":false}}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "how-to-split-or-retrieve-string-using-substr-php-function",
      "title": "How to Split or Retrieve  String  using substr() php function"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-26T15:35:51",
  "trx_id": "8142410a5d6714d3f0175b107669170961dc0bb7",
  "trx_in_block": 32,
  "virtual_op": 0
}

{
  "block": 19293767,
  "op": [
    "comment",
    {
      "author": "ybreza",
      "body": "Wkwkwkwkwk ek pundong :v @atan26",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"users\":[\"atan26\"],\"app\":\"steemit/0.1\"}",
      "parent_author": "atan26",
      "parent_permlink": "re-ybreza-new-logo-design-for-healthybattery-opensource-apps-20180125t092233723z",
      "permlink": "re-atan26-re-ybreza-new-logo-design-for-healthybattery-opensource-apps-20180125t180228371z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T18:02:33",
  "trx_id": "75ab8ce12c6092220fc883cfb23f52bc1e1875df",
  "trx_in_block": 3,
  "virtual_op": 0
}

{
  "block": 19283373,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "hayak bg, lagak ajunah",
      "json_metadata": "{\"tags\":[\"utopian-io\"],\"community\":\"utopian\",\"app\":\"utopian/1.0.0\"}",
      "parent_author": "ybreza",
      "parent_permlink": "new-logo-design-for-healthybattery-opensource-apps",
      "permlink": "re-ybreza-new-logo-design-for-healthybattery-opensource-apps-20180125t092233723z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:22:36",
  "trx_id": "d360b47cb42a7e8ca35073d78b7340967ea770ae",
  "trx_in_block": 50,
  "virtual_op": 0
}

{
  "block": 19283318,
  "op": [
    "comment_options",
    {
      "allow_curation_rewards": false,
      "allow_votes": true,
      "author": "atan26",
      "extensions": [],
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "permlink": "re-kalemandra-b-and-w-photo-contest-nature-abstracts-my-first-entry-20180125t091948321z"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:19:51",
  "trx_id": "a950d4e0304c283660d28b70b531ae3b6c64c8b3",
  "trx_in_block": 60,
  "virtual_op": 0
}

{
  "block": 19283318,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "blend of nature and macro, like :)",
      "json_metadata": "{\"tags\":[\"bwphotocontest\"],\"community\":\"busy\",\"app\":\"busy/2.3.0\"}",
      "parent_author": "kalemandra",
      "parent_permlink": "b-and-w-photo-contest-nature-abstracts-my-first-entry",
      "permlink": "re-kalemandra-b-and-w-photo-contest-nature-abstracts-my-first-entry-20180125t091948321z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:19:51",
  "trx_id": "a950d4e0304c283660d28b70b531ae3b6c64c8b3",
  "trx_in_block": 60,
  "virtual_op": 0
}

{
  "block": 19283290,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "how-to-split-or-retrieve-string-using-substr-php-function",
      "voter": "messwir",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:18:27",
  "trx_id": "881e3d9f6247af23e8bb4fc5eaed898f16986119",
  "trx_in_block": 40,
  "virtual_op": 0
}

{
  "block": 19283244,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"kalemandra\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:16:09",
  "trx_id": "22df4cec8ff51f42766ef5b49ea33d8b1f0957b2",
  "trx_in_block": 40,
  "virtual_op": 0
}

{
  "block": 19283216,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"daveks\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:14:45",
  "trx_id": "a86b1f0fca4c3bcafa3ecdacc8766aa4f1d38b38",
  "trx_in_block": 30,
  "virtual_op": 0
}

{
  "block": 19283216,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"gargon\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:14:45",
  "trx_id": "2f81080a8594c4c22d8535ca6ac2f02f67eeea08",
  "trx_in_block": 24,
  "virtual_op": 0
}

{
  "block": 19283216,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"gringalicious\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:14:45",
  "trx_id": "08a8e4bec7c5061ce8f79fb2013b44d169a0c83b",
  "trx_in_block": 1,
  "virtual_op": 0
}

{
  "block": 19283215,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"terrycraft\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:14:42",
  "trx_id": "a36012dad5f3477a045e5f6430183b5cc3bf1a36",
  "trx_in_block": 39,
  "virtual_op": 0
}

{
  "block": 19283115,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "how-to-split-or-retrieve-string-using-substr-php-function",
      "voter": "atan26",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T09:09:42",
  "trx_id": "4b73dde41c247f81093ceff4bff7a542ca73508c",
  "trx_in_block": 13,
  "virtual_op": 0
}

{
  "block": 19282073,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "how-to-split-or-retrieve-string-using-substr-php-function",
      "voter": "sogata",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T08:17:36",
  "trx_id": "9cbf5745aea1e8053cc85cc5d4e806a7d3ebc395",
  "trx_in_block": 46,
  "virtual_op": 0
}

{
  "block": 19281601,
  "op": [
    "comment_options",
    {
      "allow_curation_rewards": true,
      "allow_votes": true,
      "author": "atan26",
      "extensions": [
        [
          0,
          {
            "beneficiaries": [
              {
                "account": "utopian.pay",
                "weight": 2500
              }
            ]
          }
        ]
      ],
      "max_accepted_payout": "1000000.000 SBD",
      "percent_steem_dollars": 10000,
      "permlink": "how-to-split-or-retrieve-string-using-substr-php-function"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T07:54:00",
  "trx_id": "47da07e0ee721322c6204a7ff6a270e60e9e61d9",
  "trx_in_block": 31,
  "virtual_op": 0
}

{
  "block": 19281601,
  "op": [
    "comment",
    {
      "author": "atan26",
      "body": "\n#### What Will I Learn?\n\n- You will learn  How to Take Character From Early String\n- You will learn How to Take Character From Middle String\n- You will learn How to Take Characters From the last String\n\n#### Requirements\n\n- You should be able to program basic php and HTML\n- You have to have text editor, browser, and web server to run it, then in this tutorial I use text editor that is (Notepad ++), and using chrome browser, and its web server is XAMPP Control Pane v3.2.2.\n\n#### Difficulty\n- Basic\n\n\n#### Tutorial Contents\n   In PHP tutorial tutorial this time I will discuss a simple function that is quite often used, namely substr () function. The substr () function is used to bypass a string or to extract some value from a string inside PHP.\nGetting to know the substr () function\nThe function substr () is a PHP function to bypass a string, or to extract some value from a string. This feature is quite often used in the process of creating PHP programs, especially those that require string manipulation.\n\nFor example, suppose we have a date-shaped string: \"26-06-2016\". How to retrieve the month value of the string, the \"06\" character?\n\nAnother example, say a student's NIM consists of 10 digits: 1557301058 \". The first two digits are the year of student entry, the next two digits of the department code, and the last four digits are the serial number of the student. How do I separate these digits?\nand the following below I will explain one by one how to use this subtr () function.\n\n- first turn on XAMPP as its web server\n![1.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516859688/uqcka0sjeg3muztoskng.jpg)\n - then open notepad as text editor, then input program script like in picture below\n![2.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516860240/egkwduokhn1xfwyrxr2n.jpg)\n - then open the chrome browser to display the results of the notepad coding that has been typed in the example;\n```\n<?php\n$meuruno = \"Belajar PHP Notepad Bek ka eh\";\n$sub_meuruno = substr($meuruno,0);\necho $sub_meuruno;\n// meuruno PHP bek ehh\n?>\n```\n - then the results on its browser are as below;\n![3.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516861329/fvoiuhhrjwwyvwyzwh3o.jpg)\n - **Now ,How to Take Character From Early String ?**\nThe first use of the substr () function that we will discuss is how to take a character that starts from the beginning of the string. Here is an example of its use:\n```\n<?php\n$meuruno = \"You And I \";\n$sub_meuruno = substr($meuruno,1);\necho $sub_meuruno;\n// How to Make Character from Early String \n?>\n```\n - Output\n![4.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516862611/nlygtjjzt3msidpdouqw.jpg)\n - explanation\nIn the code above, I took the string $ meuruno starting from the index to-1. If the substr () function is written with 2 arguments like this, and the second argument is positive, then the substr () function returns the string value $ meuruno starting from the 2nd letter, the letter \"O\" to the end of the string.\n - **Then, How to Take Character From Middle String ?**\nHere is an example of its use:\n```\n<?php\n$meuruno = \"You And I \";\n$sub_meuruno = substr($meuruno,4,-2);\necho $sub_meuruno;\n// How to Make Character from middle String \n?>\n```\n - Output\n![5.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516865134/x4qucpjl2dpju9irmjtx.jpg)\n\n - explanation\nThe function substr () also has arguments (4, -2) which are optional (may be filled or emptied). If we add a fourth argument, this value serves as a determinant of 'how many characters to extract'\n - **Last, How to Take Characters From the last String?**\nApart from the start of the string, we can also take characters starting from the end of the string. The trick is to assign a negative value to the second argument of the substr () function. Immediately we see examples of its use:\n```\n<?php\n$meuruno = \"You And I \";\n$sub_meuruno = substr($meuruno,7);\necho $sub_meuruno;\n// How to Make Character from last String \n?>\n```\n - Output\n![6.jpg](https://res.cloudinary.com/hpiynhbhq/image/upload/v1516866317/fnwbehtokxn968kdwg4x.jpg)\n\n - explanation\nPartial retrieval of string values ​​is quite often used. PHP provides substr () functions for this purpose. the substr () function is very practical for cutting a string or taking some value from a string inside PHP.\n\n\n#### Curriculum\nThis is my first contributions \n    \n\n<br /><hr/><em>Posted on <a href=\"https://utopian.io/utopian-io/@atan26/how-to-split-or-retrieve-string-using-substr-php-function\">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>",
      "json_metadata": "{\"community\":\"utopian\",\"app\":\"utopian/1.0.0\",\"format\":\"markdown\",\"repository\":{\"id\":1903522,\"name\":\"php-src\",\"full_name\":\"php/php-src\",\"html_url\":\"https://github.com/php/php-src\",\"fork\":false,\"owner\":{\"login\":\"php\"}},\"pullRequests\":[],\"platform\":\"github\",\"type\":\"tutorials\",\"tags\":[\"utopian-io\",\"tutorials\",\"opensource\",\"php\",\"aceh\"],\"links\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516859688/uqcka0sjeg3muztoskng.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516860240/egkwduokhn1xfwyrxr2n.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516861329/fvoiuhhrjwwyvwyzwh3o.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516862611/nlygtjjzt3msidpdouqw.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516865134/x4qucpjl2dpju9irmjtx.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516866317/fnwbehtokxn968kdwg4x.jpg\"],\"image\":[\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516859688/uqcka0sjeg3muztoskng.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516860240/egkwduokhn1xfwyrxr2n.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516861329/fvoiuhhrjwwyvwyzwh3o.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516862611/nlygtjjzt3msidpdouqw.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516865134/x4qucpjl2dpju9irmjtx.jpg\",\"https://res.cloudinary.com/hpiynhbhq/image/upload/v1516866317/fnwbehtokxn968kdwg4x.jpg\"]}",
      "parent_author": "",
      "parent_permlink": "utopian-io",
      "permlink": "how-to-split-or-retrieve-string-using-substr-php-function",
      "title": "How to Split or Retrieve  String  using substr() php function"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-25T07:54:00",
  "trx_id": "47da07e0ee721322c6204a7ff6a270e60e9e61d9",
  "trx_in_block": 31,
  "virtual_op": 0
}

{
  "block": 19204017,
  "op": [
    "author_reward",
    {
      "author": "atan26",
      "permlink": "hand-made-1-flower-vase-from-used-bottle",
      "sbd_payout": "0.253 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "106.444293 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-22T15:13:18",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 13
}

{
  "block": 19119661,
  "op": [
    "author_reward",
    {
      "author": "atan26",
      "permlink": "re-sogata-spongedocs-indonesian-translation-1204-words-translated-20180112t165313356z",
      "sbd_payout": "0.066 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "34.804140 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T16:53:12",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 2
}

{
  "block": 19118876,
  "op": [
    "author_reward",
    {
      "author": "atan26",
      "permlink": "a-meaningful-afternoon-with-friend",
      "sbd_payout": "0.070 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "36.851492 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T16:13:51",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 4
}

{
  "block": 19118373,
  "op": [
    "curation_reward",
    {
      "comment_author": "sogata",
      "comment_permlink": "spongedocs-indonesian-translation-1204-words-translated",
      "curator": "atan26",
      "reward": "18.425762 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T15:48:42",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 10
}

{
  "block": 19104779,
  "op": [
    "account_update",
    {
      "account": "atan26",
      "json_metadata": "{\"profile\":{\"profile_image\":\"https://image.ibb.co/ma2Ugv/486d172318b34f393fa6dc3e2058a003_takahiro_morita_one_ok_rock.jpg\",\"cover_image\":\"https://preview.ibb.co/hCkt8a/bn12.jpg\"}}",
      "memo_key": "STM5uc67N8KQs34tiCvmSjSXf1TjZVJAfWHQXfvzps9VTgYJrzupv",
      "posting": {
        "account_auths": [
          [
            "busy.app",
            1
          ],
          [
            "utopian.app",
            1
          ]
        ],
        "key_auths": [
          [
            "STM6CG2VTULEi6DKuoYDwzLQfpKrXkoa9ZSgtMzg9qgJPTANbSLqq",
            1
          ]
        ],
        "weight_threshold": 1
      }
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T04:28:48",
  "trx_id": "6da6ce4f69c457d57be96df62b7c5da78052b91a",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 19104546,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"halo\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T04:17:09",
  "trx_id": "5c86eb8efd21ac0cf06b54e62580d061f6764653",
  "trx_in_block": 46,
  "virtual_op": 0
}

{
  "block": 19104546,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"lukestokes\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T04:17:09",
  "trx_id": "5f18982b78de72873f177a18626e87e5ecd2c14b",
  "trx_in_block": 33,
  "virtual_op": 0
}

{
  "block": 19104546,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"penguinpablo\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T04:17:09",
  "trx_id": "ce03ee935d2aae515336a9863d26c517d107b635",
  "trx_in_block": 26,
  "virtual_op": 0
}

{
  "block": 19104546,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"everittdmickey\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T04:17:09",
  "trx_id": "a550363e933833de40687a70ea7aad844217f671",
  "trx_in_block": 7,
  "virtual_op": 0
}

{
  "block": 19104545,
  "op": [
    "custom_json",
    {
      "id": "follow",
      "json": "[\"follow\",{\"follower\":\"atan26\",\"following\":\"mynameisbrian\",\"what\":[\"blog\"]}]",
      "required_auths": [],
      "required_posting_auths": [
        "atan26"
      ]
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T04:17:06",
  "trx_id": "ed3eaaf17fe6751a30029ce866439f77d1b6a27e",
  "trx_in_block": 24,
  "virtual_op": 0
}

{
  "block": 19104185,
  "op": [
    "comment",
    {
      "author": "steemitboard",
      "body": "Congratulations @atan26! 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/voted.png)](http://steemitboard.com/@atan26) Award for the number of upvotes received\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> By upvoting this notification, you can help all Steemit users. Learn how [here](https://steemit.com/steemitboard/@steemitboard/http-i-cubeupload-com-7ciqeo-png)!",
      "json_metadata": "{\"image\":[\"https://steemitboard.com/img/notifications.png\"]}",
      "parent_author": "atan26",
      "parent_permlink": "hand-made-1-flower-vase-from-used-bottle",
      "permlink": "steemitboard-notify-atan26-20180119t035908000z",
      "title": ""
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-19T03:59:06",
  "trx_id": "35a702d75ca8ce07b92a53cecc2fca595599d5e9",
  "trx_in_block": 32,
  "virtual_op": 0
}

{
  "block": 19059712,
  "op": [
    "author_reward",
    {
      "author": "atan26",
      "permlink": "birthday-party-mr-aan",
      "sbd_payout": "0.273 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "100.328151 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-17T14:54:33",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 8
}

{
  "block": 19047406,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "hand-made-1-flower-vase-from-used-bottle",
      "voter": "sogata",
      "weight": 10000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-17T04:39:06",
  "trx_id": "abcca67a6398f6b753af69d02dcad5e7e37aadbd",
  "trx_in_block": 50,
  "virtual_op": 0
}

{
  "block": 19044195,
  "op": [
    "vote",
    {
      "author": "atan26",
      "permlink": "re-sogata-spongedocs-indonesian-translation-1204-words-translated-20180112t165313356z",
      "voter": "hackbot",
      "weight": 1000
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-17T01:58:30",
  "trx_id": "01abb8a4adbf9f4108cf51edb409e774adb390bc",
  "trx_in_block": 0,
  "virtual_op": 0
}

{
  "block": 19020948,
  "op": [
    "author_reward",
    {
      "author": "atan26",
      "permlink": "go-home",
      "sbd_payout": "0.087 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "30.714757 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-16T06:36:03",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 695
}

{
  "block": 19020626,
  "op": [
    "curation_reward",
    {
      "comment_author": "lemonchum",
      "comment_permlink": "four-ideal-characteristics-of-a-friend",
      "curator": "atan26",
      "reward": "2.047651 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-16T06:19:57",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 12
}

{
  "block": 19005957,
  "op": [
    "author_reward",
    {
      "author": "atan26",
      "permlink": "old-twilight-in-the-city-forest",
      "sbd_payout": "0.261 SBD",
      "steem_payout": "0.000 STEEM",
      "vesting_payout": "94.194329 VESTS"
    }
  ],
  "op_in_trx": 0,
  "timestamp": "2018-01-15T18:06:21",
  "trx_id": "0000000000000000000000000000000000000000",
  "trx_in_block": 4294967295,
  "virtual_op": 12
}