inet_ntop not returning the correct value
I am at a loss here. I have inserted an IP address into a MySql table using inet_pton in a binary(16) column and when I try and retrieve it using inet_ntop I get a weird result
it displays: 23a6::
It should display: 35.166.0.0
$Results = $this->DB->GetResults( "SELECT * FROM {$this->Table} WHERE type = '{$this->BlockType['Network']}'" );
foreach($Results->Results as $Range)
{
echo inet_ntop($Range->RangeStart);
}
The hex value in the database is 0x23a60000000000000000000000000000
It seems like it should be working. Where am I going wrong?
mysql binary inet-ntop
asked Nov 20 '18 at 1:17
user3098629user3098629
2314
add a comment |
I am at a loss here. I have inserted an IP address into a MySql table using inet_pton in a binary(16) column and when I try and retrieve it using inet_ntop I get a weird result
it displays: 23a6::
It should display: 35.166.0.0
$Results = $this->DB->GetResults( "SELECT * FROM {$this->Table} WHERE type = '{$this->BlockType['Network']}'" );
foreach($Results->Results as $Range)
{
echo inet_ntop($Range->RangeStart);
}
The hex value in the database is 0x23a60000000000000000000000000000
It seems like it should be working. Where am I going wrong?
mysql binary inet-ntop
asked Nov 20 '18 at 1:17
user3098629user3098629
2314
How did you work out 0x23a60000000000000000000000000000 was 35.166.0.0? How was it inserted? Using MySQL it seems to be 0x353938303831353336 looking at inet_aton. You could use the inet_ntoa function like this example.
– danblack
Nov 20 '18 at 2:50
I used inet_pton to insert it into the database
– user3098629
Nov 20 '18 at 2:58
You might need pack/unpack like this answer
– danblack
Nov 20 '18 at 3:53
add a comment |
I am at a loss here. I have inserted an IP address into a MySql table using inet_pton in a binary(16) column and when I try and retrieve it using inet_ntop I get a weird result
it displays: 23a6::
It should display: 35.166.0.0
$Results = $this->DB->GetResults( "SELECT * FROM {$this->Table} WHERE type = '{$this->BlockType['Network']}'" );
foreach($Results->Results as $Range)
{
echo inet_ntop($Range->RangeStart);
}
The hex value in the database is 0x23a60000000000000000000000000000
It seems like it should be working. Where am I going wrong?
mysql binary inet-ntop
asked Nov 20 '18 at 1:17
user3098629user3098629
2314
I am at a loss here. I have inserted an IP address into a MySql table using inet_pton in a binary(16) column and when I try and retrieve it using inet_ntop I get a weird result
it displays: 23a6::
It should display: 35.166.0.0
$Results = $this->DB->GetResults( "SELECT * FROM {$this->Table} WHERE type = '{$this->BlockType['Network']}'" );
foreach($Results->Results as $Range)
{
echo inet_ntop($Range->RangeStart);
}
The hex value in the database is 0x23a60000000000000000000000000000
It seems like it should be working. Where am I going wrong?
mysql binary inet-ntop
mysql binary inet-ntop
asked Nov 20 '18 at 1:17
user3098629user3098629
2314
asked Nov 20 '18 at 1:17
user3098629user3098629
2314
asked Nov 20 '18 at 1:17
user3098629user3098629
2314
asked Nov 20 '18 at 1:17
user3098629user3098629
2314
asked Nov 20 '18 at 1:17
user3098629user3098629
2314
2314
How did you work out 0x23a60000000000000000000000000000 was 35.166.0.0? How was it inserted? Using MySQL it seems to be 0x353938303831353336 looking at inet_aton. You could use the inet_ntoa function like this example.
– danblack
Nov 20 '18 at 2:50
I used inet_pton to insert it into the database
– user3098629
Nov 20 '18 at 2:58
You might need pack/unpack like this answer
– danblack
Nov 20 '18 at 3:53
add a comment |
How did you work out 0x23a60000000000000000000000000000 was 35.166.0.0? How was it inserted? Using MySQL it seems to be 0x353938303831353336 looking at inet_aton. You could use the inet_ntoa function like this example.
– danblack
Nov 20 '18 at 2:50
I used inet_pton to insert it into the database
– user3098629
Nov 20 '18 at 2:58
You might need pack/unpack like this answer
– danblack
Nov 20 '18 at 3:53
How did you work out 0x23a60000000000000000000000000000 was 35.166.0.0? How was it inserted? Using MySQL it seems to be 0x353938303831353336 looking at inet_aton. You could use the inet_ntoa function like this example.
– danblack
Nov 20 '18 at 2:50
How did you work out 0x23a60000000000000000000000000000 was 35.166.0.0? How was it inserted? Using MySQL it seems to be 0x353938303831353336 looking at inet_aton. You could use the inet_ntoa function like this example.
– danblack
Nov 20 '18 at 2:50
I used inet_pton to insert it into the database
– user3098629
Nov 20 '18 at 2:58
I used inet_pton to insert it into the database
– user3098629
Nov 20 '18 at 2:58
You might need pack/unpack like this answer
– danblack
Nov 20 '18 at 3:53
You might need pack/unpack like this answer
– danblack
Nov 20 '18 at 3:53
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53384891%2finet-ntop-not-returning-the-correct-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53384891%2finet-ntop-not-returning-the-correct-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
How did you work out 0x23a60000000000000000000000000000 was 35.166.0.0? How was it inserted? Using MySQL it seems to be 0x353938303831353336 looking at inet_aton. You could use the inet_ntoa function like this example.
– danblack
Nov 20 '18 at 2:50
I used inet_pton to insert it into the database
– user3098629
Nov 20 '18 at 2:58
You might need pack/unpack like this answer
– danblack
Nov 20 '18 at 3:53