PHP - How Come My Post Method Search Box Works Only Once?

hello,
   I was wondering if it is possible to get all the data sent by a html form via post/get method and use it somehow.
   it is difficult to explain what i mean, i don't mean to say how to get data normally i.e.. by using variables for example $data = $_POST['data']; that can only get only one field that is "data".
  The reason i am looking for this is because i have many forms that will have to use the mail() function, the problem is creating variables for each from then use the mail() function to send it will be time consuming. and the fields are different in different forms.
I have noticed the similar technology used by mailmyform . com, they capture the data in any html form posted to their php page and mail it to the given email.

Hi there, I wrote a pretty simple html form that inputs data into my database. I've included a truncated version of it, There are a lot more fields. Basically when i hit the submit it processes input.php but after its been successful the page is still at input.php in the browser Is there anyway to take the page back to the page i was using to input data
Code: [Select]
<form action="insert.php" method="post">
  <p>Adornment Name: <br>
    <input type="text" name="name">
    <br>
    <br>
    Quality: <br>
    <select name="quality">
      <option value="Other">Other Not Listed</option>
      <option value="Superior">Superior</option>
      <option value="Greater">Greater</option>
      <option value="Lesser">Lesser</option>
      <option value="Raid">Raid</option>
      <option value="Faction">Faction</option>
    </select>
</form>
Code: [Select]
include 'db_connect.php';

$sql="INSERT INTO $db_table (name, quality)
VALUES
(
  '$_POST[name]', 
'$_POST[quality]')";



if (!mysql_query($sql,$db))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($db)
?>

Hello

I am working in moodle and its code base is in PHP. I am a novice to moodle as well as PHP and not quite familiar with PHP syntax.

Right now I have built a Web page in moodle, and its view.php file I need to implement a fuctionality on click of a button.

On click of submit button, I am trying to implement a functionality and I have written the code for that under if(isset($_POST['submit]))
{ ...my code...}

Also while creating the form I have set the attributes as follows:
echo "<form method='post' action='" . $_SERVER['PHP_SELF']."?inpopup=". $_GET['inpopup']."&amp;id=" . $_GET['id'] . "'>";

But irrespective of whether or not I click the button, whenevr the page loads for the first time, it perform the code written in IF loop as well.

So Am i going wrong in implementing a functionality on click of button in PHP or is it something related to moodle, if anyone knows?
Any help or suggestions would be appreciated. As I am stuck with this logic since last three days.

Regards

i created an array like this

while{
$ir = 0;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['id_sub']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['seminar_topic']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['seminar_mark']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['attendance']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['internal_mark']; $ir++;
$stud[$row_mrk['id_sub']][$ir]=$row_mrk['external_mark']; $ir++;
}

echo "<input type='hidden' name='ar_std' id='ar_std' value='$stud' /> </table>" ;

and it is able to print in the same page using

foreach ($stud as $v1) {
echo "$v1\n<br>";
foreach ($v1 as $v2) {
echo "$v2\n<br>";
}
}

and in the next page

$ar_stud[]=$_POST["ar_std"];

I'm getting an error
PHP Warning:  Invalid argument supplied for foreach() in save.php on line 25
PHP Stack trace:

I'm trying to figure out something that's quite a bit beyond my meager knowledge of PHP, and not sure exactly what's the best way. Kind of confused and lost in the woods without a map.

I have a paginated PHP results page that builds its query based on $_GET variables from a previous search page. Then I'm putting down one side of the page, a form full of options to refine the search results.

What I want to happen is, when somebody selects something on the "refine search" form, it autosubmits and adds that variable to the URL as "&variable="chosenItem" - but also to say in which table to search for that variable. Then I want the page to reload, change the PHP query to include the tables to join and search variables. Holy cow this is alot to figure out in my head!

I've gotten as far as turning most of the query into variables, but not sure if there's a more sensible way to do this or what. Something like this:

$select = 'Select Maintable.*, table2.*, table4.*'
 //this would change based on which tables were in the url $_GET
$from = 'from Maintable.field1'
$on = 'on table1.id=table.2'
$where = 'WHERE x=x AND y=y AND z=z
//this also would change based on the url $_GET
//then

$query = ($SELECT $FROM $WHERE)


Beyond this, I have no idea how to get the variables into the url to begin with, nor if this will work. Maybe I'm trying too hard. Maybe there's some simple ways to do this that somebody can explain.

Hi, I have a form for news articles.  It has a title and a body which is fine.  I also have a search box that allows the user to search for a memeber and click their name when it appears.  This moves a div with a data-id into another div.  The purpose of this is to tag them in the article.

I am able to post all of the simple stuff but how would i post these value.  I am assuming that i would need to create an array of said values but i am struggling to get them showing in post at all.

Here is the code i have so far

<?php

function searchForPeople($searchVal, $exclude = '0'){

	$sv1 = $searchVal;
	$sv2 = $searchVal;

	include 'includes/dbconn.php';
	$out ="";

	$stmt = $conn -> prepare("
	                         SELECT fname, lname, id
	                         FROM person 
	                         WHERE id NOT IN (".implode(',', array_map('intval', $exclude)).") 
	                         AND (fname LIKE CONCAT('%',?,'%') OR lname LIKE CONCAT('%',?,'%'))
	                         ");
	$stmt -> bind_param('ss', $sv1, $sv2);
	$stmt -> execute();
	$stmt -> bind_result($fn, $ln, $pid);

	while($stmt -> fetch()){
		$out .= "<div class='btn btn-primary m-1 tagInArticle' name='taggedPerson[]' data-id='$pid'>$fn $ln</div>";
	}

	return $out;
}

?>

		......
							<div id="searchResultsHere">
								<!-- ajax content here -->
							</div>
							<hr>
							<div id="taggedInArticleContainer">
								<!-- ajax content here -->
							</div>
		.......


						<div class="col-lg-2">
							<button type="submit" name="PublishNewNews" class="btn btn-primary w-100 mb-3">Publish</button>
							<button class="btn btn-primary w-100">Save</button>
							<hr>
							<div class="btn btn-warning w-100 mb-3">Private</div>
							<input type="hidden" name="howVisible" value="Private">
							<hr>
							<p class="text-justify">Private news articles will only be avilable to logged in users</p>
						</div>

		.......



<script>

	$('#searchResultsHere').on('click', '.tagInArticle', function tagInArticle(){
		var tagButton = $(this);
		tagButton.appendTo('#taggedInArticleContainer')
	});

	$('#searchForPeopleBox').keyup(function(){
		var searchVal = $(this).val()
		var tagged = '0'
		var tagged = $('#taggedInArticleContainer').find('.tagInArticle').map(function(){
		 return $(this).data('id');
  		}).get();
		$.ajax({
			type: 'post',
			data: {"ajax" : 'one', "val" : searchVal, "exclude" : tagged},
			success: function(resp){
				$('#searchResultsHere').html(resp)
			}
		})
	});

	


</script>

I hope this is enough to go on.

I am sure it is simple but i just cant get it.

Thanks all in advance.

Hello

I have this code that searches multiple tables. running this query in the phpmyadmin page works fine and gives correct results.
I echo-ed the $kw and noticed that it is lost (empty) when I click on Next (when moving to the second page or so..)
How do I save the $kw for all search results?

Thank you so much


$kw = trim($_POST['keyword']);
$kw = mysql_real_escape_string($kw);

//Nomber of rows to display per page
$page_rows=20;

//This checks to see if there is a page number. If not, it will set it to page 1 
 if (!(isset($pagenum)))
 {
 $pagenum = 1;
 }

echo "$kw of $pagenum";

//Count we count the number of results
$data = mysql_query("
SELECT `id`,`title`, `body`, 'condoms_en' as REF FROM `condoms_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'discr_en' as REF FROM `discr_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'diseases_en' as REF FROM `diseases_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'express_en' as REF FROM `express_en` where `title` like '%$kw%' OR `body` like '%$kw%' ") or die(mysql_error());
$rows = mysql_num_rows($data);

if ($rows ==1 || $rows > 1)
{
//echo "Number of rows $rows <br/>";

//This tells us the page number of our last page 
$last = ceil($rows/$page_rows);

//this makes sure the page number isn't below one, or more than our maximum pages
if ($pagenum < 1) 
 { 
 $pagenum = 1; 
 } 
 elseif ($pagenum > $last) 
 { 
 $pagenum = $last; 
 } 

//echo "<h4>".$pagenum."-20 of ".$total."results</h4> <br />";
// This shows the user what page they are on, and the total number of pages
 echo " ===> Page $pagenum of $last <br/><br/>";

//This sets the range to display in our query 
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;

//This is your query again, the same one... the only difference is we add $max into it
$data_p = mysql_query("
SELECT `id`,`title`, `body`, 'condoms_en' as REF FROM `condoms_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'discr_en' as REF FROM `discr_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'diseases_en' as REF FROM `diseases_en` where `title` like '%$kw%' OR `body` like '%$kw%'
UNION
SELECT `id`,`title`, `body`, 'express_en' as REF FROM `express_en` where `title` like '%$kw%' OR `body` like '%$kw%' $max") or die(mysql_error());

//This is where you display your query results
 while($info = mysql_fetch_array( $data_p ))
 {
 
 print $info['title']; //print $info['REF'];
 echo "<br>";
 }
 echo "<p><br/>";

 // First we check if we are on page one. If we are then we don't need a link to the previous page 
 //or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.

 if ($pagenum == 1) 
 {
 } 
 else 
 {
 echo " <a style=\"color: #FF0000\" href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";
 echo " ";
 $previous = $pagenum-1;
 echo " <a style=\"color: #FF0000\" href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";
 }
 //just a spacer
 echo " ---- ";

 //This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
 if ($pagenum == $last) 
 {
 } 
 else {
 $next = $pagenum+1;
 echo " <a style=\"color: #FF0000\" href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";
 echo " ";
 echo " <a style=\"color: #FF0000\" href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";
 } 


} //results was found
else
{
echo "No results FOUND";
}

Hi,

I'm trying to setup a quick PHP script that will grab the email from the url (see below) and after inserting into MySQL db - which is working fine - the script will complete two additional tasks:

1. send that same captured email out to a external db as in shown via http://domain1.com/insert.php?email=$lead (example), but then send to a DIFFERENT source - the originator of the lead - a portback acknowledgement using Header (sending the status and email to http://domain2.com/check.php?e=$lead&s=$status for their records).

See the code below:
-------------------------

Code: [Select]

$lead = $_REQUEST['e_mail'];                // will grab email from posted url string and assign to local variable
$result = mysql_query($command);      // this is just to execute the MySQL insert which works just fine but included here to explain validation below

// Create API Call string to insert lead into iContact folder
$requestURL = "http://domain1.com/insert.php?email=$lead";

// Execute API Call to CAKE
$xml = simplexml_load_file($requestURL) or die("feed not loading");


if ($result) {
    $status = 1;       // mark lead as sucess

    // send postback on lead status
    header("Location: http://domain2.com/check.php?e=$lead&s=$status");
}

--------

Problem: I'm getting all sorts of errors with the simplexml_load_file() function and can't figure out why it won't work.
Any input appreciated as this the only way I know how to pass the lead onward and then inform/update the other party of receipt of information.

thanks!

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=346243.0

Hi, i'm currently building essentially an API for my URL shortener site so other sites can implement it. But i've hit a stumbling block on the last script of the lot(the others merely collate the data and store it)

In this last script, i need to find all this data, stored in cookies and inout it into the database, as the main site does(i'm confident this bit works, as it's the code from the main site just copied across, and i can see the data in the database). Importantly, i then need o look in another table for the callback URL to send the data back to


$urltoshorten = $_COOKIE["URLtoShorten"];
$alias = $_COOKIE["urlalias"];
$key = $_COOKIE["key"];
//connection details go in here
$alias =mysql_real_escape_string($alias);
$urltoshorten = mysql_real_escape_string($urltoshorten);
$base = "http://s-url.co.uk/i/?id=";
$url = $base . $alias ;
//this is the main bit, where the URL shortening occurs
mysql_query("INSERT INTO table (id, name) VALUES('$alias', '$urltoshorten')")or die( mysql_error());
//this is where the callback url is looked for
$result= mysql_query("SELECT apiaddress FROM apistuff WHERE apinumber='$key'")or die( mysql_error());
$row = mysql_fetch_array($result);
$new = $row[apiaddress]; 
//I then start a CURL session to POST data to the page in question, as found above
$Curl_Session = curl_init($new);
curl_setopt ($Curl_Session, CURLOPT_POST, 1);
curl_setopt ($Curl_Session, CURLOPT_POSTFIELDS, "shortenedurl=$url");
curl_exec ($Curl_Session); 
curl_close ($Curl_Session);

annoyingly, no errors get thrown, as far as i can see, i just end at a blank page without being returned to the callback page.

I'm rather stumped on this one, where am i likely to be going wrong/how do i go about correcting it.

Cheers
Joe

 

My script has 3 classes (that are relevant to this discussion): DB, User and Validate. They are all in independent files and loaded automatically, when required, by an autoloader.
Both the User class and the Validate class have a private variable $_db which is instantiated by their class constructor: $this->_db = DB::getInstance();
At the top of the script I declare new instances: $user = new User(); and $validate = new Validate();
I then call a method in $user: $found = $user->findInUsers ( .... )
From within the findInUsers method I then want to call the query method in the DB class. My problem is that I can't find a way to do this that works.
I have tried $this->_db->query( ... ), $_db->query( ... ), but neither works.

The error messages I am getting a
An error occurred in script '/srv/http/classes/User.php' on line 42: Undefined variable $_db
Uncaught Error: Call to a member function query() on null in /srv/http/classes/User.php:42

Any pointers as to what I am doing wrong, or what I should be doing, would be most welcome.

Hey Guys. I am working with a form that shows the grand total on the checkout page. The value of the grand total is inside a hidden field. When click on  submit, the _POST array doesn't get back the last value of the grand total. I need to hit the button twice to get the last value. The weird thing is when I  echo the value of the grand total it display the latest value, but not with the POST array   For example. If the grand total is $10.00 and I click on submit. It will show the POST['grand_total'] as empty. If I click on submit again it will show the grand total of $10.00. Below is my code that I am working with. Any help would be really appreciated.

if(isset($_POST['submit'])) {
/* Doesn't show if i put it after if($_POST['submit'] */
if(isset($_POST['grand_total'])) {
echo $_POST['grand_total'];
}

}

//A bunch of other html/php code. Another class calculates the subtotal assigns it the variable $subtotal



$cart_totals = new cartTotals($subtotal, $discounted_amount,$post_values->tip); // Cart class is shown below

/* Doesn't show if i put it before if($_POST['submit'] */
if(isset($_POST['grand_total'])) {
echo $_POST['grand_total'];
}
echo  "<input name='grand_total' type='hidden' value='$cart_totals->grand_total'  />"; // Shows the grand total after second from submission
echo "$cart_totals->grand_total"; // Shows grand total after the first submission

Cart Totals Class

class cartTotals  {

	public $subtotal;
	public $sales_tax;
        public $tip;
	public $grand_total;
        public $discount_amount;
	public $href_page;
	public $invalidCouponMessage;
	const  TEST_ENVIORMENT = FALSE;


	/**
	 * [ Function gets constructed in the order summary where the [$discount_amount= ""]  arg does need to be passed.
     * But does get passed in when called on the checkout.php page. Therefore we set the default value to an empty string.]
	 * @param [float] $subtotal   [subtotal get passed in from the parent class coreCartFunction]
	 * @param string $discount_amount [The class checkCouponCode calculates this discount amount based on the
     * subtotal and the discount amount. It gets instantiated on the clients side and passed is this construction function.
     * This is all done on the checkout page.]
	 */

    /*The way the construct function works is by invoking all the methods the passed arguments
    When the methods get invoked the do all the work and set the properties its values. The properties then get echoed out
    on the client side.  */
	
    function __construct($subtotal="", $discount_amount= "", $tip=""){
    
    $this->subTotal($subtotal, $discount_amount);//SubTotal method takes the discount amount and subtracts it from the subtotal.
    $this->salesTax($subtotal, $discount_amount);
    $this->tip = $tip;
    $this->grandTotal();
	}

    private function subTotal($subtotal,$discount_amount) {

            $rounded_subtotal = round($subtotal-$discount_amount,2);
            $money_format_subtotal =  money_format('%i',$rounded_subtotal);
            $this->subtotal = $money_format_subtotal;
    }


    private function salesTax($subtotal, $discount_amount =""){
	$sales_tax = (STORE_SALES_TAX)?(float)STORE_SALES_TAX:8.875;
	$sales_tax =(($this->subtotal)*$sales_tax)/100;
	$sales_tax = round($sales_tax,2);
	$this->sales_tax = $sales_tax;
	}


	public function Tip() {
    //global $post_values;
    //$last_tip_selected = $post_values->tip > 0 ? $post_values->tip : "" ;
	$tip_output = "<select id='tip' name='tip'>";
 	for($tip=0.00; $tip<=11.75; $tip+=0.25){
 	if( $tip == "2") {$selected = " selected";} else {$selected ="";}
       $formatted_tip =  money_format('%i',$tip);

	$tip_output .= "<option {$selected} id='selected_tip' value='$formatted_tip'>"."$".$formatted_tip ."</option>".PHP_EOL;
		}

		$tip_output .= "</select>";
		return $tip_output;

    }

    private function grandTotal(){
        $grand_total = round($this->sales_tax+$this->subtotal+$this->tip,2);
        $grand_total_formatted =  money_format('%i',$grand_total);
        $this->grand_total = $grand_total_formatted;

    }

 The result pages is supposed to have  pagination like google  help me please