Retrieve a database record using a value in url without $

Retrieve a database record using a value in url without $_POST

Dear whom that may be able to assist.

Link - https://develop.hangoutsdubai.ae/category-beach-entertainment.php

Currently I am using $_POST method for my listings to be able to retrieve the record in the database as a single page listing.

On the above link page, I will add the following to preview :

I am using below $dashedURL to remove %20 in URL and replace with '-'

//############# REPLACE URL %20 WITH DASH (-) #############//

$string = 'category-beach-entertainment-single-profile.php?'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'';

str_replace('%20', '-', $string);

$dashedURL = str_replace(' ', '-', rawurldecode($string));

//############# PART OF FORM BEING SUBMITTED #############//

<!-- CATEGORY BUTTON -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nmainCategory'].'" class="singleProfileDetailsCategory">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>



<!-- H3 VENUE TITLE -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <span class="name" style="display:none;">'.$venueName.'</span>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'" class="name singleProfileDetailsVenueName" itemprop="name">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>

//############# ON SINGLE PAGE #############//

$txtnid = $_POST['txtnid'];

$sql_BeachEntertainmentVenuesListing = "SELECT * FROM tblvenueListingsBeachEntertainment WHERE nid = $txtnid";



//CONNECT TO MYSQL SERVER

require('inc-conn.php');



//EXECUTE SQL STATEMENT

$rs_BeachEntertainmentVenuesListing = mysqli_query($vconn, $sql_BeachEntertainmentVenuesListing);



//CREATE AN ASSOCIATIVE ARRAY

$rs_BeachEntertainmentVenuesListing_rows = mysqli_fetch_assoc($rs_BeachEntertainmentVenuesListing);<br><br>

Currently my issue is when I copy the single page URL of the venue and would like to share it with someone, the record will display blank. So if I don't select the venue through the main listing page : https://develop.hangoutsdubai.ae/category-beach-entertainment.php it won't display because of $_POST.

For example : Copy this link of a venue and open in a new window or cognitive window and it will display a blank record : https://develop.hangoutsdubai.ae/category-beach-entertainment-single-profile.php?Venue-9-Name

Is it possible to use a different method in order to retrieve all the data from a record without using the main page with all the listings?

The reason is for in case some one would want to share the link of a specific venue but it will show no data. I have tried couple of things but getting stuck. According to my hypothesis there should be a variable that retrieves the name of the venue in the url and retrieve the unique id from that record, then display the data accordingly. Sort of struggling to figure this one out. Any help will be gladly appreciated.

asked Nov 12 '18 at 9:44

Dane

5

Um... use $_GET?
– Robby Cornelissen
Nov 12 '18 at 9:47

1

Robbie is correct. You could also use $_REQUEST (for HTTP GET, POST and COOKIE). One thing you need to note - if you are parameter passing in URI string you need to use name value key pairs (i.e. make sure to name the parameter you are passing with a key - e.g. ?venue=Your Venue Name)
– cherrysoft
Nov 12 '18 at 9:51

pass the post params in the url as a querystring, mysite.com/list.php?value=xyz&date=2018-11-20 etc
– Bsienn
Nov 12 '18 at 9:54

Thanks Robby and Cherry, I have replaced $_post in form that gets submitted with $_GET and tried it out, but its on the single page that displays the actual details where I am getting stuck. I have done some research about $_REQUEST and COOKIE but not 100% sure how to incorporate it with my code above, any chance for a small example please of what Cherry has mentioned.
– Dane
Nov 12 '18 at 9:56

Bsienn, thanks. Are you reffering to an example such as this : plus2net.com/php_tutorial/variables2.php
– Dane
Nov 12 '18 at 10:01

|
show 1 more comment

Dear whom that may be able to assist.

Link - https://develop.hangoutsdubai.ae/category-beach-entertainment.php

Currently I am using $_POST method for my listings to be able to retrieve the record in the database as a single page listing.

On the above link page, I will add the following to preview :

I am using below $dashedURL to remove %20 in URL and replace with '-'

//############# REPLACE URL %20 WITH DASH (-) #############//

$string = 'category-beach-entertainment-single-profile.php?'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'';

str_replace('%20', '-', $string);

$dashedURL = str_replace(' ', '-', rawurldecode($string));

//############# PART OF FORM BEING SUBMITTED #############//

<!-- CATEGORY BUTTON -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nmainCategory'].'" class="singleProfileDetailsCategory">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>



<!-- H3 VENUE TITLE -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <span class="name" style="display:none;">'.$venueName.'</span>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'" class="name singleProfileDetailsVenueName" itemprop="name">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>

//############# ON SINGLE PAGE #############//

$txtnid = $_POST['txtnid'];

$sql_BeachEntertainmentVenuesListing = "SELECT * FROM tblvenueListingsBeachEntertainment WHERE nid = $txtnid";



//CONNECT TO MYSQL SERVER

require('inc-conn.php');



//EXECUTE SQL STATEMENT

$rs_BeachEntertainmentVenuesListing = mysqli_query($vconn, $sql_BeachEntertainmentVenuesListing);



//CREATE AN ASSOCIATIVE ARRAY

$rs_BeachEntertainmentVenuesListing_rows = mysqli_fetch_assoc($rs_BeachEntertainmentVenuesListing);<br><br>

Is it possible to use a different method in order to retrieve all the data from a record without using the main page with all the listings?

asked Nov 12 '18 at 9:44

Dane

5

Um... use $_GET?
– Robby Cornelissen
Nov 12 '18 at 9:47

1

Robbie is correct. You could also use $_REQUEST (for HTTP GET, POST and COOKIE). One thing you need to note - if you are parameter passing in URI string you need to use name value key pairs (i.e. make sure to name the parameter you are passing with a key - e.g. ?venue=Your Venue Name)
– cherrysoft
Nov 12 '18 at 9:51

pass the post params in the url as a querystring, mysite.com/list.php?value=xyz&date=2018-11-20 etc
– Bsienn
Nov 12 '18 at 9:54

Thanks Robby and Cherry, I have replaced $_post in form that gets submitted with $_GET and tried it out, but its on the single page that displays the actual details where I am getting stuck. I have done some research about $_REQUEST and COOKIE but not 100% sure how to incorporate it with my code above, any chance for a small example please of what Cherry has mentioned.
– Dane
Nov 12 '18 at 9:56

Bsienn, thanks. Are you reffering to an example such as this : plus2net.com/php_tutorial/variables2.php
– Dane
Nov 12 '18 at 10:01

|
show 1 more comment

Dear whom that may be able to assist.

Link - https://develop.hangoutsdubai.ae/category-beach-entertainment.php

Currently I am using $_POST method for my listings to be able to retrieve the record in the database as a single page listing.

On the above link page, I will add the following to preview :

I am using below $dashedURL to remove %20 in URL and replace with '-'

//############# REPLACE URL %20 WITH DASH (-) #############//

$string = 'category-beach-entertainment-single-profile.php?'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'';

str_replace('%20', '-', $string);

$dashedURL = str_replace(' ', '-', rawurldecode($string));

//############# PART OF FORM BEING SUBMITTED #############//

<!-- CATEGORY BUTTON -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nmainCategory'].'" class="singleProfileDetailsCategory">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>



<!-- H3 VENUE TITLE -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <span class="name" style="display:none;">'.$venueName.'</span>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'" class="name singleProfileDetailsVenueName" itemprop="name">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>

//############# ON SINGLE PAGE #############//

$txtnid = $_POST['txtnid'];

$sql_BeachEntertainmentVenuesListing = "SELECT * FROM tblvenueListingsBeachEntertainment WHERE nid = $txtnid";



//CONNECT TO MYSQL SERVER

require('inc-conn.php');



//EXECUTE SQL STATEMENT

$rs_BeachEntertainmentVenuesListing = mysqli_query($vconn, $sql_BeachEntertainmentVenuesListing);



//CREATE AN ASSOCIATIVE ARRAY

$rs_BeachEntertainmentVenuesListing_rows = mysqli_fetch_assoc($rs_BeachEntertainmentVenuesListing);<br><br>

Is it possible to use a different method in order to retrieve all the data from a record without using the main page with all the listings?

asked Nov 12 '18 at 9:44

Dane

Dear whom that may be able to assist.

Link - https://develop.hangoutsdubai.ae/category-beach-entertainment.php

Currently I am using $_POST method for my listings to be able to retrieve the record in the database as a single page listing.

On the above link page, I will add the following to preview :

I am using below $dashedURL to remove %20 in URL and replace with '-'

//############# REPLACE URL %20 WITH DASH (-) #############//

$string = 'category-beach-entertainment-single-profile.php?'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'';

str_replace('%20', '-', $string);

$dashedURL = str_replace(' ', '-', rawurldecode($string));

//############# PART OF FORM BEING SUBMITTED #############//

<!-- CATEGORY BUTTON -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nmainCategory'].'" class="singleProfileDetailsCategory">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>



<!-- H3 VENUE TITLE -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <span class="name" style="display:none;">'.$venueName.'</span>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'" class="name singleProfileDetailsVenueName" itemprop="name">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>

//############# ON SINGLE PAGE #############//

$txtnid = $_POST['txtnid'];

$sql_BeachEntertainmentVenuesListing = "SELECT * FROM tblvenueListingsBeachEntertainment WHERE nid = $txtnid";



//CONNECT TO MYSQL SERVER

require('inc-conn.php');



//EXECUTE SQL STATEMENT

$rs_BeachEntertainmentVenuesListing = mysqli_query($vconn, $sql_BeachEntertainmentVenuesListing);



//CREATE AN ASSOCIATIVE ARRAY

$rs_BeachEntertainmentVenuesListing_rows = mysqli_fetch_assoc($rs_BeachEntertainmentVenuesListing);<br><br>

Is it possible to use a different method in order to retrieve all the data from a record without using the main page with all the listings?

$string = 'category-beach-entertainment-single-profile.php?'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'';

str_replace('%20', '-', $string);

$dashedURL = str_replace(' ', '-', rawurldecode($string));

$string = 'category-beach-entertainment-single-profile.php?'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'';

str_replace('%20', '-', $string);

$dashedURL = str_replace(' ', '-', rawurldecode($string));

<!-- CATEGORY BUTTON -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nmainCategory'].'" class="singleProfileDetailsCategory">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>



<!-- H3 VENUE TITLE -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <span class="name" style="display:none;">'.$venueName.'</span>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'" class="name singleProfileDetailsVenueName" itemprop="name">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>

<!-- CATEGORY BUTTON -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nmainCategory'].'" class="singleProfileDetailsCategory">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>



<!-- H3 VENUE TITLE -->

<form method="post" action="'.$dashedURL.'">

    <div>

      <span class="name" style="display:none;">'.$venueName.'</span>

      <input type="submit" value="'.$rs_BeachEntertainmentVenuesListing_rows['nvenueName'].'" class="name singleProfileDetailsVenueName" itemprop="name">

      <input type="hidden" name="txtnid" value="'.$rs_BeachEntertainmentVenuesListing_rows['nid'].'">

    </div>

</form>

$txtnid = $_POST['txtnid'];

$sql_BeachEntertainmentVenuesListing = "SELECT * FROM tblvenueListingsBeachEntertainment WHERE nid = $txtnid";



//CONNECT TO MYSQL SERVER

require('inc-conn.php');



//EXECUTE SQL STATEMENT

$rs_BeachEntertainmentVenuesListing = mysqli_query($vconn, $sql_BeachEntertainmentVenuesListing);



//CREATE AN ASSOCIATIVE ARRAY

$rs_BeachEntertainmentVenuesListing_rows = mysqli_fetch_assoc($rs_BeachEntertainmentVenuesListing);<br><br>

$txtnid = $_POST['txtnid'];

$sql_BeachEntertainmentVenuesListing = "SELECT * FROM tblvenueListingsBeachEntertainment WHERE nid = $txtnid";



//CONNECT TO MYSQL SERVER

require('inc-conn.php');



//EXECUTE SQL STATEMENT

$rs_BeachEntertainmentVenuesListing = mysqli_query($vconn, $sql_BeachEntertainmentVenuesListing);



//CREATE AN ASSOCIATIVE ARRAY

$rs_BeachEntertainmentVenuesListing_rows = mysqli_fetch_assoc($rs_BeachEntertainmentVenuesListing);<br><br>

php mysql

asked Nov 12 '18 at 9:44

Dane

asked Nov 12 '18 at 9:44

Dane

asked Nov 12 '18 at 9:44

Dane

asked Nov 12 '18 at 9:44

Dane

asked Nov 12 '18 at 9:44

Dane

5

Um... use $_GET?
– Robby Cornelissen
Nov 12 '18 at 9:47

1

Robbie is correct. You could also use $_REQUEST (for HTTP GET, POST and COOKIE). One thing you need to note - if you are parameter passing in URI string you need to use name value key pairs (i.e. make sure to name the parameter you are passing with a key - e.g. ?venue=Your Venue Name)
– cherrysoft
Nov 12 '18 at 9:51

pass the post params in the url as a querystring, mysite.com/list.php?value=xyz&date=2018-11-20 etc
– Bsienn
Nov 12 '18 at 9:54

Thanks Robby and Cherry, I have replaced $_post in form that gets submitted with $_GET and tried it out, but its on the single page that displays the actual details where I am getting stuck. I have done some research about $_REQUEST and COOKIE but not 100% sure how to incorporate it with my code above, any chance for a small example please of what Cherry has mentioned.
– Dane
Nov 12 '18 at 9:56

Bsienn, thanks. Are you reffering to an example such as this : plus2net.com/php_tutorial/variables2.php
– Dane
Nov 12 '18 at 10:01

|
show 1 more comment

5

Um... use $_GET?
– Robby Cornelissen
Nov 12 '18 at 9:47

1

Robbie is correct. You could also use $_REQUEST (for HTTP GET, POST and COOKIE). One thing you need to note - if you are parameter passing in URI string you need to use name value key pairs (i.e. make sure to name the parameter you are passing with a key - e.g. ?venue=Your Venue Name)
– cherrysoft
Nov 12 '18 at 9:51

pass the post params in the url as a querystring, mysite.com/list.php?value=xyz&date=2018-11-20 etc
– Bsienn
Nov 12 '18 at 9:54

Thanks Robby and Cherry, I have replaced $_post in form that gets submitted with $_GET and tried it out, but its on the single page that displays the actual details where I am getting stuck. I have done some research about $_REQUEST and COOKIE but not 100% sure how to incorporate it with my code above, any chance for a small example please of what Cherry has mentioned.
– Dane
Nov 12 '18 at 9:56

Bsienn, thanks. Are you reffering to an example such as this : plus2net.com/php_tutorial/variables2.php
– Dane
Nov 12 '18 at 10:01

Um... use $_GET?
– Robby Cornelissen
Nov 12 '18 at 9:47

Robbie is correct. You could also use $_REQUEST (for HTTP GET, POST and COOKIE). One thing you need to note - if you are parameter passing in URI string you need to use name value key pairs (i.e. make sure to name the parameter you are passing with a key - e.g. ?venue=Your Venue Name)
– cherrysoft
Nov 12 '18 at 9:51

pass the post params in the url as a querystring, mysite.com/list.php?value=xyz&date=2018-11-20 etc
– Bsienn
Nov 12 '18 at 9:54

Thanks Robby and Cherry, I have replaced $_post in form that gets submitted with $_GET and tried it out, but its on the single page that displays the actual details where I am getting stuck. I have done some research about $_REQUEST and COOKIE but not 100% sure how to incorporate it with my code above, any chance for a small example please of what Cherry has mentioned.
– Dane
Nov 12 '18 at 9:56

Bsienn, thanks. Are you reffering to an example such as this : plus2net.com/php_tutorial/variables2.php
– Dane
Nov 12 '18 at 10:01

|
show 1 more 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
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53259466%2fretrieve-a-database-record-using-a-value-in-url-without-post%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

0

active

oldest

votes

0

active

oldest

votes

draft saved

draft discarded

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.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

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.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Wsrtjtyk