How to PHP script run “post self”
-
Dear Friends,
I’d like to add an html page generate from php program. I need to make
a simple form with select and an action. All form and other html code are
inside PHP.To do that I’ve added a new shortcode in a child theme so to show it I just
put this shortcode in a new wordpress page but I’ve discovered the big problem !The value selected inside form must to be used to the same code to run query
sql and show the result.How can I run the same PHP program with POST_SELF ? Are there any other solutions ?
Any ideas about it ? Somebody can post an example ?
Thanks a lot !
Best Regards
Willy
-
Dear bcworkz,
I think post to self due to manage data passed through form because I’ve read some articles but I’m not sure about it.
If you more time for this question I’ll tell you others details.I need to create a page (html plus php) for showing two select.
In the first user choose the year and in the second choose en event,
after that there is button to confirm all data and run sql query on my
custom table.The result , for example un array , must to be show in a new or in the
same html page.Above I show you my script:
<?php
global $wpdb;
$gare_2016 = $wpdb->get_results(“SELECT id,nome,luogo,data FROM “.$wpdb->prefix.”gpaltvt_gare WHERE data like ‘2016%’ order by data”);
.. omissis…
$anni = $wpdb->get_results(“SELECT DISTINCT(date_format(data, ‘%Y’)) AS id FROM “.$wpdb->prefix.”gpaltvt_gare order by id”);
<!DOCTYPE html>
<html>
<head>
<script>
function populate(s1,s2){
var s1 = document.getElementById(s1);
var s2 = document.getElementById(s2);
s2.innerHTML = “”;
if(s1.value == “2016”){
var optionArray = [<?php foreach ( $gare_2016 as $gara ) { echo chr(34);echo $gara->id;echo chr(124);echo $gara->nome;
echo chr(34); } ?> ];
} else if(s1.value == “2017”){
var optionArray = [<?php foreach ( $gare_2017 as $gara ) { echo chr(34);echo $gara->id;echo chr(124);echo $gara->nome;
echo chr(34);echo chr(44); } ?>];
}
for(var option in optionArray){
var pair = optionArray[option].split(“|”);
var newOption = document.createElement(“option”);
newOption.value = pair[0];
newOption.innerHTML = pair[1];
s2.options.add(newOption);
}
}
</script>
</head>
<body>
<h2>Visualizza Classifica. Anno:
<select id=”slct1″ name=”slct1″ onchange=”populate(this.id,’slct2′)”>
<option value=””></option>
<?php
foreach ($anni as $anno)
{
$year=$anno->id;
echo “<option value=”.$year.”>”.$year.”</option>”;
}
?>
</select>
Gara:
<select id=”slct2″ name=”slct2″></select>
<input type=”submit” name=”submit” value=”Enter”>
<hr />
</body>
</html>I’m not so fluent with PHP and to realize my little project with wp-admin/admin-post.php
so you help is very very appreciate but think that this page can be used by non-logged users.Thank you so much for this suggestion.
Best RegardsDear bcworkz,
hello enrico,
if you are still interested in this post I would like to have your opinion on sanitization data.In my definitive php script there are two POST variable, race_id and name_athlete.
As you can imagne the first was choosed by user throught form (select on change
and so on) and is numeric value, the second variabile is a free text,
first and last name , and was choosed by user throught input area.To sanitize the first I think to use this code:
$race_id=$_REQUEST['slct2']; if ( !is_numeric($race_id) || $race_id ==0 ) { echo "ERROR RACE ID ."; exit(); }and to check the second variable I’m thinking to this code:
'$title = sanitize_text_field( $_POST['title'] ); update_post_meta( $post->ID, 'title', $title );sanitize_text_field isn’t so clear for me , Can you give
an example ?Are they secure ? What do you think about them ?
Thank you so much !
Best Regards
Willy
- The topic ‘How to PHP script run “post self”’ is closed to new replies.