🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 83 (from laksa130)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa083.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/\')), getAhrefsUnparsedNoserviceFromURL(\'https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/","crawl_time":1768517661,"first_indexed_time":1589298961,"http_code":200,"src_unparsed":"com,phpfreaks!forums,\/topic\/310755-how-to-save-data-in-mysql-database\/ s443","src_root_hash":"6912566579114601883","history_drop_reason":null,"meta_title":"How to save data in MYSQL database - MySQL Help - PHP Freaks","meta_descriptions":["Hi! So due to this pandemic I've decided to do some programming just for fun in preparation for school in september. I am currently focused on just creating a simple login and registration page. The registration page is supposed to add the users entered data into the MYSQL database and then redir..."],"attrs_boilerpipe_text":"Hi slotegraafd,\nI'm just a normal user here so you should wait for pros to help you. However, i would still like to offer my opinion about your posted code: pdo is a safer solution to interacting with a database. I recommend that you switch to pdo: https:\/\/phpdelusions.net\/pdo\nI've never understood error arrays and pushing data into them. a simple binary switch can be used to deal with error scenarios and a variable or array for error messages only:\n$error = 0; if (empty(bla_bla)) { $errors = 1; $message = 'bla_bla contains no usable data'; }\nif($errors) { \/\/code to handle errors }\n\/\/else continue or no else if header relocation exit is used if $errors\nif one of the required fields is empty or erroneous then just cut out completely and stop evaluating the rest of the data.\nyou should use password_verify to check the password. MAJOR security error here. Also, hashing passwords as a student testing login scripts is not necessary but it is absolutely necessary on live site. encryption is not a protection mechnism. Use hashes. skip for now but never forget to hash the passwords (which also requires a rehash if php changed something as the default encryption method.)\nyou use a header relocate without an exit:\nheader('location: home.php');\n\nchange this to:\nheader('location: home.php'); exit;\n\nto stop evaluation of the rest of the script.\ni wouldn't escape input. I recommend that you validate input then compare login values. In any event, just use htmlentities with ENT_QUOTES or html special chars before outputting post data or using it in anyway.\nyou have the following code:\nf (mysqli_num_rows($results) == 1)\nyou need to verify that the usernames match and that the passwords match:\nif ($username === $resultfromdb && password_verify()) { } else {}\npassword verify works like so:\nif (hash_equals($usernameFromDB, $username) && password_verify($password, $passwordFromDB)) { } else { }\nStart with pdo then try again. I'm sure that pro members will help you further.\nGood luck and i hope that you switch to pdo for security purposes. Learn proper coding early to save many headaches and problems.","attrs_markdown":"[Jump to content](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#ipsLayout_mainArea \"Go to main content on this page\")\n\n[![PHP Freaks](https:\/\/forums.phpfreaks.com\/uploads\/monthly_2022_04\/logo.png.dedab21429a20fe155ffac9188071184.png)](https:\/\/forums.phpfreaks.com\/)\n\n- [Existing user? Sign In](https:\/\/forums.phpfreaks.com\/login\/)\n- [Sign Up](https:\/\/forums.phpfreaks.com\/register\/)\n\n- [Browse](https:\/\/forums.phpfreaks.com\/)\n  - [Forums](https:\/\/forums.phpfreaks.com\/)\n  - [Staff](https:\/\/forums.phpfreaks.com\/staff\/)\n  - [Leaderboard](https:\/\/forums.phpfreaks.com\/leaderboard\/)\n  - [Guidelines](https:\/\/forums.phpfreaks.com\/guidelines\/)\n  - [Terms of Service](https:\/\/forums.phpfreaks.com\/terms\/)\n  - [More](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n- [Activity](https:\/\/forums.phpfreaks.com\/discover\/)\n  - [All Activity](https:\/\/forums.phpfreaks.com\/discover\/)\n  - [Search](https:\/\/forums.phpfreaks.com\/search\/)\n  - [More](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n- [Join our Discord\\!](https:\/\/discord.gg\/7Svm6kJB4d)\n- [More](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n  - [More](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n\n- [MySQL Help](https:\/\/forums.phpfreaks.com\/forum\/15-mysql-help\/)\n\n- [All Activity](https:\/\/forums.phpfreaks.com\/discover\/)\n\n- [Home](https:\/\/forums.phpfreaks.com\/ \"Home\")\n- [SQL \/ Database](https:\/\/forums.phpfreaks.com\/forum\/5-sql-database\/)\n- [MySQL Help](https:\/\/forums.phpfreaks.com\/forum\/15-mysql-help\/)\n- How to save data in MYSQL database\n\n# How to save data in MYSQL database\n***\n[![slotegraafd](data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201024%201024%22%20style%3D%22background%3A%2362c463%22%3E%3Cg%3E%3Ctext%20text-anchor%3D%22middle%22%20dy%3D%22.35em%22%20x%3D%22512%22%20y%3D%22512%22%20fill%3D%22%23ffffff%22%20font-size%3D%22700%22%20font-family%3D%22-apple-system%2C%20BlinkMacSystemFont%2C%20Roboto%2C%20Helvetica%2C%20Arial%2C%20sans-serif%22%3ES%3C%2Ftext%3E%3C%2Fg%3E%3C%2Fsvg%3E)](https:\/\/forums.phpfreaks.com\/profile\/209884-slotegraafd\/ \"Go to slotegraafd's profile\")\n\n**By [slotegraafd](https:\/\/forums.phpfreaks.com\/profile\/209884-slotegraafd\/ \"Go to slotegraafd's profile\")** May 12, 2020 in [MySQL Help](https:\/\/forums.phpfreaks.com\/forum\/15-mysql-help\/)\n\n[Share](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#elShareItem_954426944_menu)\n\n<https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/>\n***\nMore sharing options...\n\n[Followers 2](https:\/\/forums.phpfreaks.com\/login\/ \"Sign in to follow this\")\n\n- [Reply to this topic](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#replyForm)\n- [Start new topic](https:\/\/forums.phpfreaks.com\/forum\/15-mysql-help\/?do=add \"Start a new topic in this forum\")\n\n- [Prev](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#comments \"Previous page\")\n- [1](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#comments)\n- [2](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/page\/2\/#comments)\n- [Next](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/page\/2\/#comments \"Next page\")\n- [Page 1 of 2](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n## Recommended Posts\n- [Prev](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#comments \"Previous page\")\n- [1](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#comments)\n- [2](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/page\/2\/#comments)\n- [Next](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/page\/2\/#comments \"Next page\")\n- [Page 1 of 2](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n\nThis thread is more than a year old. Please don't revive it unless you have something important to add.\n\n## Join the conversation\nYou can post now and register later. If you have an account, [sign in now](https:\/\/forums.phpfreaks.com\/login\/) to post with your account.\n\n[Share](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#elShareItem_1285559971_menu)\n\n<https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/>\n***\nMore sharing options...\n\n[Followers 2](https:\/\/forums.phpfreaks.com\/login\/ \"Sign in to follow this\")\n\n[Go to topic listing](https:\/\/forums.phpfreaks.com\/forum\/15-mysql-help\/ \"Go to MySQL Help\")\n\n- [All Activity](https:\/\/forums.phpfreaks.com\/discover\/)\n\n- [Home](https:\/\/forums.phpfreaks.com\/ \"Home\")\n- [SQL \/ Database](https:\/\/forums.phpfreaks.com\/forum\/5-sql-database\/)\n- [MySQL Help](https:\/\/forums.phpfreaks.com\/forum\/15-mysql-help\/)\n- How to save data in MYSQL database\n\n- [Theme](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/#elNavTheme_menu)\n- [Contact Us](https:\/\/forums.phpfreaks.com\/contact\/)\n- [Cookies](https:\/\/forums.phpfreaks.com\/cookies\/)\n\nPHP Freaks [Powered by Invision Community](https:\/\/www.invisioncommunity.com\/ \"Invision Community\")\n\n[×](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n\n- [Existing user? Sign In](https:\/\/forums.phpfreaks.com\/login\/)\n- [Sign Up](https:\/\/forums.phpfreaks.com\/register\/)\n\n- #### [Browse](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n  - [Back](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n  - [Forums](https:\/\/forums.phpfreaks.com\/)\n  - [Staff](https:\/\/forums.phpfreaks.com\/staff\/)\n  - [Leaderboard](https:\/\/forums.phpfreaks.com\/leaderboard\/)\n  - [Guidelines](https:\/\/forums.phpfreaks.com\/guidelines\/)\n  - [Terms of Service](https:\/\/forums.phpfreaks.com\/terms\/)\n- #### [Activity](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n  - [Back](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n  - [All Activity](https:\/\/forums.phpfreaks.com\/discover\/)\n  - [Search](https:\/\/forums.phpfreaks.com\/search\/)\n- [Join our Discord\\!](https:\/\/discord.gg\/7Svm6kJB4d)\n\n[×](https:\/\/forums.phpfreaks.com\/topic\/310755-how-to-save-data-in-mysql-database\/)\n\n- Create New...\n\n## Important Information\nWe have placed [cookies](https:\/\/forums.phpfreaks.com\/cookies\/) on your device to help make this website better. You can [adjust your cookie settings](https:\/\/forums.phpfreaks.com\/cookies\/), otherwise we'll assume you're okay to continue.","attrs_readable_markdown":null,"meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

2 months ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	2.9 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/
Last Crawled	2026-01-15 22:54:21 (2 months ago)
First Indexed	2020-05-12 15:56:01 (5 years ago)
HTTP Status Code	200
Meta Title	How to save data in MYSQL database - MySQL Help - PHP Freaks
Meta Description	Hi! So due to this pandemic I've decided to do some programming just for fun in preparation for school in september. I am currently focused on just creating a simple login and registration page. The registration page is supposed to add the users entered data into the MYSQL database and then redir...
Meta Canonical	null
Boilerpipe Text	Hi slotegraafd, I'm just a normal user here so you should wait for pros to help you. However, i would still like to offer my opinion about your posted code: pdo is a safer solution to interacting with a database. I recommend that you switch to pdo: https://phpdelusions.net/pdo I've never understood error arrays and pushing data into them. a simple binary switch can be used to deal with error scenarios and a variable or array for error messages only: $error = 0; if (empty(bla_bla)) { $errors = 1; $message = 'bla_bla contains no usable data'; } if($errors) { //code to handle errors } //else continue or no else if header relocation exit is used if $errors if one of the required fields is empty or erroneous then just cut out completely and stop evaluating the rest of the data. you should use password_verify to check the password. MAJOR security error here. Also, hashing passwords as a student testing login scripts is not necessary but it is absolutely necessary on live site. encryption is not a protection mechnism. Use hashes. skip for now but never forget to hash the passwords (which also requires a rehash if php changed something as the default encryption method.) you use a header relocate without an exit: header('location: home.php'); change this to: header('location: home.php'); exit; to stop evaluation of the rest of the script. i wouldn't escape input. I recommend that you validate input then compare login values. In any event, just use htmlentities with ENT_QUOTES or html special chars before outputting post data or using it in anyway. you have the following code: f (mysqli_num_rows($results) == 1) you need to verify that the usernames match and that the passwords match: if ($username === $resultfromdb && password_verify()) { } else {} password verify works like so: if (hash_equals($usernameFromDB, $username) && password_verify($password, $passwordFromDB)) { } else { } Start with pdo then try again. I'm sure that pro members will help you further. Good luck and i hope that you switch to pdo for security purposes. Learn proper coding early to save many headaches and problems.
Markdown	[Jump to content](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#ipsLayout_mainArea "Go to main content on this page") [![PHP Freaks](https://forums.phpfreaks.com/uploads/monthly_2022_04/logo.png.dedab21429a20fe155ffac9188071184.png)](https://forums.phpfreaks.com/) - [Existing user? Sign In](https://forums.phpfreaks.com/login/) - [Sign Up](https://forums.phpfreaks.com/register/) - [Browse](https://forums.phpfreaks.com/) - [Forums](https://forums.phpfreaks.com/) - [Staff](https://forums.phpfreaks.com/staff/) - [Leaderboard](https://forums.phpfreaks.com/leaderboard/) - [Guidelines](https://forums.phpfreaks.com/guidelines/) - [Terms of Service](https://forums.phpfreaks.com/terms/) - [More](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [Activity](https://forums.phpfreaks.com/discover/) - [All Activity](https://forums.phpfreaks.com/discover/) - [Search](https://forums.phpfreaks.com/search/) - [More](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [Join our Discord\!](https://discord.gg/7Svm6kJB4d) - [More](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [More](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [MySQL Help](https://forums.phpfreaks.com/forum/15-mysql-help/) - [All Activity](https://forums.phpfreaks.com/discover/) - [Home](https://forums.phpfreaks.com/ "Home") - [SQL / Database](https://forums.phpfreaks.com/forum/5-sql-database/) - [MySQL Help](https://forums.phpfreaks.com/forum/15-mysql-help/) - How to save data in MYSQL database # How to save data in MYSQL database * [![slotegraafd](data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201024%201024%22%20style%3D%22background%3A%2362c463%22%3E%3Cg%3E%3Ctext%20text-anchor%3D%22middle%22%20dy%3D%22.35em%22%20x%3D%22512%22%20y%3D%22512%22%20fill%3D%22%23ffffff%22%20font-size%3D%22700%22%20font-family%3D%22-apple-system%2C%20BlinkMacSystemFont%2C%20Roboto%2C%20Helvetica%2C%20Arial%2C%20sans-serif%22%3ES%3C%2Ftext%3E%3C%2Fg%3E%3C%2Fsvg%3E)](https://forums.phpfreaks.com/profile/209884-slotegraafd/ "Go to slotegraafd's profile") By [slotegraafd](https://forums.phpfreaks.com/profile/209884-slotegraafd/ "Go to slotegraafd's profile") May 12, 2020 in [MySQL Help](https://forums.phpfreaks.com/forum/15-mysql-help/) [Share](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#elShareItem_954426944_menu) <https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/> * More sharing options... [Followers 2](https://forums.phpfreaks.com/login/ "Sign in to follow this") - [Reply to this topic](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#replyForm) - [Start new topic](https://forums.phpfreaks.com/forum/15-mysql-help/?do=add "Start a new topic in this forum") - [Prev](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#comments "Previous page") - [1](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#comments) - [2](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/page/2/#comments) - [Next](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/page/2/#comments "Next page") - [Page 1 of 2](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) ## Recommended Posts - [Prev](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#comments "Previous page") - [1](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#comments) - [2](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/page/2/#comments) - [Next](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/page/2/#comments "Next page") - [Page 1 of 2](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) This thread is more than a year old. Please don't revive it unless you have something important to add. ## Join the conversation You can post now and register later. If you have an account, [sign in now](https://forums.phpfreaks.com/login/) to post with your account. [Share](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#elShareItem_1285559971_menu) <https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/> *** More sharing options... [Followers 2](https://forums.phpfreaks.com/login/ "Sign in to follow this") [Go to topic listing](https://forums.phpfreaks.com/forum/15-mysql-help/ "Go to MySQL Help") - [All Activity](https://forums.phpfreaks.com/discover/) - [Home](https://forums.phpfreaks.com/ "Home") - [SQL / Database](https://forums.phpfreaks.com/forum/5-sql-database/) - [MySQL Help](https://forums.phpfreaks.com/forum/15-mysql-help/) - How to save data in MYSQL database - [Theme](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/#elNavTheme_menu) - [Contact Us](https://forums.phpfreaks.com/contact/) - [Cookies](https://forums.phpfreaks.com/cookies/) PHP Freaks [Powered by Invision Community](https://www.invisioncommunity.com/ "Invision Community") [×](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [Existing user? Sign In](https://forums.phpfreaks.com/login/) - [Sign Up](https://forums.phpfreaks.com/register/) - #### [Browse](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [Back](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [Forums](https://forums.phpfreaks.com/) - [Staff](https://forums.phpfreaks.com/staff/) - [Leaderboard](https://forums.phpfreaks.com/leaderboard/) - [Guidelines](https://forums.phpfreaks.com/guidelines/) - [Terms of Service](https://forums.phpfreaks.com/terms/) - #### [Activity](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [Back](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - [All Activity](https://forums.phpfreaks.com/discover/) - [Search](https://forums.phpfreaks.com/search/) - [Join our Discord\!](https://discord.gg/7Svm6kJB4d) [×](https://forums.phpfreaks.com/topic/310755-how-to-save-data-in-mysql-database/) - Create New... ## Important Information We have placed [cookies](https://forums.phpfreaks.com/cookies/) on your device to help make this website better. You can [adjust your cookie settings](https://forums.phpfreaks.com/cookies/), otherwise we'll assume you're okay to continue.
Readable Markdown	null
Shard	83 (laksa)
Root Hash	6912566579114601883
Unparsed URL	com,phpfreaks!forums,/topic/310755-how-to-save-data-in-mysql-database/ s443