PHP - Array Passing In $post Method . Error

//here is the code. For some reason it searches the first time, but the second search loads everything.
testing at: mnmotorsports.com

// searcha.php

<?php require("head.php");?>
<table width="800" border="1"><tr><td width="550"></td><td>
        <form  method="post" action="searcha.php?go"  id="searchform">
            <input  type="text" name="name">
            <input  type="submit" name="submit" value="Search">
        </form>
    </td></tr>
    <tr><td height ="300">
<?php
echo "searching";
    // connect to host
    require("connect.php");

    // retrieve data
    $name = $_POST['name'];
    echo " any card name matching: <b>'".$name."'</b>";
    $query = "SELECT * FROM ".$tname." WHERE name LIKE '%".$name."%'";
    $result = mysql_query($query) or die(mysql_error());
    $SearchCntr=0;
    while($row = mysql_fetch_array($result)){
        $SearchCntr++;
        echo "<table border='1' width='500'>";
        echo "<tr><td>".$row['edition']." | <a href='#'>".$row['name']."</a> | ".$row['manacost']." | ".$row['price']."</td></tr>";
        echo "</table>";
    }
    echo $SearchCntr." SEARCH RESULTS</body></html>";
?>

            </td><td></td>
    </tr>
</table>

<?php require("footer.php"); ?>

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

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)
?>

Hi, I'm new to PHP/MySQL and need some help getting my query to work for my selection list:

The selection list is built with:
<form action='processformmissing.php' method='POST'>
<fieldset>
<legend>Choose Department</legend>
<select name='depart'>
<option value=''></option>

<?php
while ($row = mysqli_fetch_array($result))
{
extract($row);
echo "<option value='$department'>$department</option>\n";
}
?>
</select>
<p><input type='submit' value='Select Department' /></p>
</fieldset>

</form>

The data is then sent to:

$depart = $_POST['depart'];
$deptlike = "%".$depart."%";

echo "<p>$depart</p>";
echo "<p>$deptlike</p>";

$query = "SELECT * FROM lifecerts INNER JOIN employees ON lifecerts.cid = employees.cid WHERE department LIKE '$deptlike' ORDER BY employees.name";



Hitting the submit button from my selection list form seems to be working fine because when I echo my data ($depart and $deptlike) it is giving me the correct value, but the query doesn't give me any results. However, if my post data comes from a text box instead of a selection list, my query works fine. Any thoughts on what I'm doing wrong???

Many thanks!

I have an hml page that uses option values and lets the user select values.  the values are php pages which when they submit pass the chosen value to the next page I show a snip below.  I wanted to have the form action grab the formVar passed to it- but I can't seem to get it going.  I figure I just may not be putting the post in correctly- any help appreciated


<head><title>page2</title></head>
<body>
<form action=="<?php  $_POST['formVar']; ?>" method="POST">

www.mywebpage.co.uk/page22

Is it possible  to produce a variable with the value =  page22 using only the url above,
I know that usually you would use get and post, but I was just curious to know if this had been done before.

i want to pass the information getting from the form and after storing in to the variables to a new php file ..how to pass all the value getting from the form

$post='{"cart_items":[{"configuration":{"price":100,"recharge_number":"9999999999"},"product_id":"999","qty":1}]}';

i try this n reslut was :There are no valid items in cart:   help me plz
Edited by ShivaGupta, 30 November 2014 - 01:11 AM.

Hi,

I'm trying to edit some database fields, I have text1, text2, text3, text4, text5, text6 etc..

They are displayed on the index.php page, with an edit link so the user can choose which set to edit

// Extract details from database
$sql = "SELECT * FROM data WHERE id=1";
$stmt = $db->prepare($sql);
$stmt->execute();
$e = $stmt->fetch();

<h1><?php  echo $e['text1']) ?></h1>
<p><?php echo ($e['text2']); ?></p>
<p><a href="edit.php">EDIT</a></p>

<h1><?php  echo $e['text3']) ?></h1>
<p><?php echo ($e['text4']); ?></p>
<p><a href="edit.php">EDIT</a></p>

<h1><?php  echo $e['text5']) ?></h1>
<p><?php echo ($e['text6']); ?></p>
<p><a href="edit.php">EDIT</a></p>

 

edit.php:

// Extract details from database
$sql = "SELECT * FROM data WHERE id=1";
$stmt = $db->prepare($sql);
$stmt->execute();
$e = $stmt->fetch();

<form method="post" action="process.php" enctype="multipart/form-data">

<label>Page Title
<input type="text" name="text1" maxlength="90" value="<?php echo $e['text1'] ?>" />
</label>
<br>
<label>Title Text</label>
<textarea name="text2"><?php echo $e['text2'] ?></textarea>

<input id="button" type="submit" name="submit" value="Save Changes" />

and then update them: process.php

	$sql = "UPDATE data SET text1=?, text2=? WHERE id=1 LIMIT 1";
	$stmt = $db->prepare($sql);
	$stmt->execute(
		array(
			  $_POST['text1'],
			  $_POST['text2']
			 )
	);
	$stmt->closeCursor();

Question:

How can I pass the form values dynamically from the index.php page so I don't have to hard code text1, text2 etc into the edit.php and process.php page and have a different update & process page for each set of data?

 

Thanks in advance.

I'm stuck at trying to figure out out to complete the 3 Step scripts to accomplish passing $variables between 2 different servers.  Since there will actually be 12 Non-POST $variables involved in the SERVER #1 to SERVER #2 transfer , it doesn't appear that trying to put these all in a URL string and going the 'GET' route is practical.    I'm just using 3 short test variables in the examples.  My eyeballs started rolling within I ran across something about 'CURL' that might be a necessary part of the solution?   The code I have been able to hammer out so far is below as STEP 1, STEP 2 and STEP 3.    STEP 1

<?php

// submit.php 

// STEP 1

// On (LOCAL) SERVER #1 TO relay $variables to 'process.php' on (REMOTE) SERVER #2

// To submit $variables to directly another destination server script
// NOTE: The $variable are NOT the result of Form Input !!!

// For login Authenticaion ALL 3 must match db entries on SERVER #2 
// NOTE: (Again) The $variables are NOT the result of Form Input !!! 

$userid = "adam";
$passwd = "eve";
$pscode = "peterpan";

// NOTE: (Again) The $variable are NOT the result of Form Input !!! 
// These $variables are needed for MySQL db INSERT on the destination URL server
// For testing simplicity (actual data will be 12 $variables)

$a = "apple";
$b = "banana";
$u = "1234567;

//
// Not sure if something called 'CURL' is needed here ???
//

$submit_to_url = http://www.blahblah.com/process.php";

?>

STEP 2

<?php

// processor.php

// STEP 2

// ON SERVER #2 TO RECEIVE DATA DIRECTLY FROM SERVER #1 'submit.php'

// To receive and process the $variables into a MySQL db on SERVER #2
// NOTE: The $variables are NOT the result of Form Input !!!

// First validate $userid, $passwd & $pscode against `verify` table MySQL records

require '/SERVER_2_securelocation_for_database_connection/secret_mysqli.php';

if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

//
// Not sure if something called 'CURL' is needed here ???
//

// These login $variables are from submit.php on SERVER #1

$userid 
$passwd 
$pscode

$sql="SELECT `userid`, `passwd`, `pscode` FROM `verify` 
WHERE `userid` = '$userid'" AND `passwd` = '$passwd` AND `pscode` = '$pscode';

$result = mysqli_query($con,$sql);

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}

//
// Then some Authentication code if ALL 3 components match
//

// If Authentication = true then $passed = "YES" must sent
// be sent back to the 'finalstep.php' script on SERVER #1
// If Authentication (or connection) = false ... $passed = "NO" 

$return_to_url = http://www.blahblah.com/finalstep.php";

// These $variables are from submit.php on SERVER #1

$a = "apple";
$b = "banana";
$u = "1234567";

$sql="INSERT INTO `data` (`a`, `b`, `u`) 
VALUES ('$a', '$b', '$u')"; 

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}

// If $SQL INSERT into `data` on SERVER #2 works ...
// $status = "Pending" must be sent back to the 'finalstep.php' 
// script on SERVER #1 for MySQL db Table insertion
// If $SQL INSERT into `data` = false, then $status = "Error"
// NOTE: The '$u' $variable also needs send back to finalstep.php !!!

$return_to_url = http://www.blahblah.com/finalstep.php";

mysqli_close($con);

?>

STEP 3

<?php

// finalstep.php 

// STEP 3

// ON SERVER #1 TO RECEIVE DATA DIRECTLY BACK FROM SERVER #2 process.php

// To receive the $passed, $status and $u $variables for final step action
// NOTE: The $variable are NOT the result of Form Input !!!

require '/SERVER_1_securelocation_for_database_connection/secret_mysqli.php';

if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// These $variables are from process.php on SERVER #2

$passed
$status
$u

$sql="UPDATE `tracking` 
SET `passed` = '$passed',
    `status` = '$status' 
WHERE `uniqueid` = '$u' ";

$result = mysqli_query($con,$sql);

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}

mysqli_close($con);

?>

Thanks very much for any assistance and guidance.   -freakingOUT  

Greetings...

I have been staring at my whiteboard pondering a new architecture for processing data in an application.  New for me anyways.  I want to create a more centralized and modular method of handling data.  For ease of explanation I will put it into the context of a login system which is where I first started thinking about this.  I know there are a lot of login systems out there but I wanted to create one from scratch which utilizes PDO although that specific thing is not germane to my main question.

Here we go...

Lets say that for my Registration, Login and Forgot Password pages the forms on each page were directed to "Process.php" 

The idea is that process.php will provide the centralized platform to deal with data, acting as a choke point in the application making it easier to secure. This will also provide the means to quickly develop new parts of an application knowing that my methods of dealing with data area already well defined and secure.  There is one hole in the idea that I can see though.  If the user data being submitted to the process.php page does not meet the security requirements then the user must be sent back to the previous page.  I dont' want to lose the data they have already entered into the forms. ie. I want to have it appear in the form fields... makes sense right.

Now here comes my question...  is there a way to pass POST data when using header("location: http://mySite/previousPage.php")

It seems from my experiments that the data is lost.  I do not use header(); often.  In previous designs I have usually created each part of a login system as seperate and self contained entities apart from using a common db object.  I know there are other ways around this, using session data for instance but this idea has been eating away at me for a little while and I feel its time to ask around for some advice.  It has become a matter of curiosity.

I have found some info on sending POST data using header but it did not seem to meet the requirement that the user and the POST data be sent to another page synchronously.

At first I thought that maybe I would just do validation on the frontend / view pages (not to be taken as clientside) and if it was valid, then submit it to process.php, validate it again the let it be handled appropriately to its particular end but then I run into the same problem plus there is the extra overhead of validating the data twice.

I guess thats it for now.  Sorry if that was a little long-winded... its part of my process, helps me to better understand what I really want to know.

Using header() on a receiving page from a form page... the redirecting header() with POST data, sending the user to a new/previous page.  Possible? 

I am retrieving a rowfrom a table and when I post the row variable it doesnt read it.
___
$query = "SELECT * FROM $tbl_name";
   
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
   echo $row['name'];
   echo "<br />";

$postinfo = 'p_doctor_name=' . $row .'&p_name_type=A&p_search_type=BEGINS';
__
This outputs p_entity_name=&p_name_type=A&p_search_type=BEGINS
Note that it is missing $row

Do I need to put it in an array?

<?php
class Post{
	private $user_obj;
	private $con;

	public function __construct($con, $user){
  	$this->con = $con; 
   	$this->user_obj =  new User($con,$user);
	}
	public function submitPost($body,$user_to){
	$body = strip_tags($body);////Removing HTML TAGS
	$body = mysqli_real_escape_string($this->con,$body);
	$check_empty = preg_replace('/\s+/', '', $body);//delte all spaces

	if($check_empty != ""){


	//Current Date and time
	$date_added = date("Y-m-d H:i:s");

	//get username
	$added_by = $this->user_obj->getUsername();

	//if user have not a profile send to the none
	if($user_to == $added_by){
	$user_to = "none";
	}
	////insert query
	$query = mysqli_query($this->con,"INSERT INTO posts VALUES('','$body','$added_by','$user_to','$date_added','no','no','0')");
	$retured_id = mysqli_insert_id($this->con);

	//insert notification

	//Update post count for user
	$num_post = $this->user_obj->getNumPosts();
	$num_post++;
	$update_query = mysqli_query($this->con,"UPDATE users SET num_post = '$num_post' WHERE username = '$added_by'" );
}
	public function loadPostsFriends(){
	$str = ""; //string to return
	$data = mysqli_query($this->con,"SELECT * FROM posts where deleted = 'no' ORDER by id DESC");
	while($row = mysqli_fetch_array($data))
	{
		$id = $row['id'];
		$body = $row['body'];
		$added_by = $row['added_by'];
		$date_time = $row['date_added'];

		/// Creating user post on other user profile
		if($row['user_to'] == "none"){
			user_to = "";
			else {
             $user_to_obj = new User($con,$row['user_to']);
             $user_to_name = $user_to_obj->getFirstandLastname();
             $user_to = "to <a href='" . $row['user_to'] . "'>" .$user_to_name . "</a>";
			}
			// check if user account was closed 
			$added_by_obj = new User($this->con,$added_by);
			if($added_by_obj ->isClosed()){
				continue;
			}
			$user_details_query = mysqli_query($this->con,"SELECT first_name,last_name,profile_pic FROM users where username = '$added_by'");
			$user_row = mysqli_fetch_array($user_details_query);
			$first_name = $user_row['first_name'];
			$last_name = $user_row['last_name'];
			$profile_pic= $user_row['profile_pic'];

			///time stamp
			$date_time_now = date("Y-m-d H:i:s");
			$start_date = new Date_Time($date_time);////Time_of_post
			$end_date = new Date_Time($date_time_now);///Current_time
			$intervel = $start_date->diff($end_date);
			if($intervel->y >< 1 ){
            if($intervel ==1 )
            	$time_message = $intervel->y . " year ago";/// 1 Year Ago
            else
            	$time_message = $intervel->y . " years ago"; //1+ year ago
			}
			else if($intervel-> m >= 1 ){
				if($intervel->d == 0){
					$days = " ago";
				}
				else if($intervel->d == 1){
					$days = $intervel->d."day ago";
				}
				else
				{
					$days = $intervel->d."day ago";
				}
				if($intervel->m == 1){
					$time_message = $intervel->m." month".$days;
				}
				else 
					$time_message = $intervel->m." months".$days;
			}
		}
		else if($intervel->d >= 1){
				if($intervel->d == 1){
					$days = "Yesterday";
				}
				else
				{
					$days = $intervel->d."days ago";

				}
		
			}
			else if($intervel->h >= 1){
				if($intervel->h == 1){
					$time_message = $intervel->h." hour ago";
				}
				else
				{
					$time_message = $intervel->h." hours ago";

				}

		}
		else if($intervel->i >= 1){
				if($intervel->i == 1){
					$time_message = $intervel->i." minute ago";
				}
				else
				{
					$time_message = $intervel->i." minutes ago";

				}
	}
			else{
				if($intervel->s < 30){
					$time_message = "Just Now";
				}
				else
				{
					$time_message = $intervel->s." seconds ago";

				}
				
			}
			$str .= "<div class='status_post'>
				         <div calss='post_profile_pic'>
				         <img src='$profile_pic' width='50'> 	
				        </div>
				        <div calss='posted_by' style='color#ACACAC;'>
				        <a href = '$added_by'> $first_name $last_name </a> $user_to &nbsp;&nbsp;;&nbsp;;&nbsp;$time_message
				        </div>
				        <div id = 'post_body'$body<br></div>
				         </div>
				"
			
		}
		echo $str;
	}
}
?>

When i run this code this show me the error Parse error: syntax error, unexpected 'public' (T_PUBLIC) in C:\xampp\htdocs\social\Classes\Post.php on line 39

the line 39 is public function loadPostsFriends()

I check the code again and again but i cant find the error please help in this error

on line 53.

Line 53
$ezdb->quick_insert('iid_ip', array('iid' => $_iid, 'ip' => $_ip));

The entire block of code
/* Update table `iid_ip`.

Between the dashed lines is the create statement used to create the image view count (iid_ip) table.

----------------------------------------
delimiter $$

CREATE TABLE `iid_ip` (
  `iid` int(11) unsigned NOT NULL COMMENT 'Image id from where the count is the number of unique views.',
  `ip` varchar(15) NOT NULL COMMENT 'The ip of the visitor.',
  PRIMARY KEY (`iid`),
  KEY `ip` (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Table for view count of image using unique ip''s.'$$
----------------------------------------

*/// Escape variables that are used in the query.
$_ip  = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
$_iid = mysql_real_escape_string($imageid);

// Count is 0 if ip has NOT seen the images, else count is 1
$_count = $ezdb->get_var("SELECT COUNT(*) FROM `iid_ip` WHERE `iid`='$_iid' AND `ip`='$_ip'");
if (!$_count) {
// Insert the unique combination of image id and visitor ip in `iid_ip`.
$ezdb->quick_insert('iid_ip', array('iid' => $_iid, 'ip' => $_ip));
}
// Get count of image views.
$_views = $ezdb->get_var("SELECT COUNT(*) FROM `iid_ip` WHERE `iid`='$_iid'");
// And format, thousands seperator is a comma, no decimals.
$_views = number_format($_views, 0, '', ',');

/////////////////////////////