PHP - Transferring Data To Another Page

Hi,

I am a curious fellow just beginning to use PHP. I understand the basics of what the $_GET and $_POST superglobals do, and how we can use them to retrieve data after form submission. I also know that since $_GET and $_POST are just associate arrays, we can create our own values in both $_GET and $_POST by writing statements like $_POST['variable'] = "value".

I am wondering if it is at all possible to send data beyond form data by adding new key/value pairs into $_GET and $_POST. So for example, if I had a form that transferred username/password through Post, would it be possible for me to include further data by just saying $_POST['formtype'] = "house_insurance_form"?

Basically what I'm getting at is trying to physically add your own data to $_POST or $_GET that you could pull from the next page where the form redirects to. In other words, can I send data beyond form data using these superglobals? I know I can do this with $_SESSION, but could I do it through $_POST or $_GET? I haven't been able to accomplish this, and I was just wondering if someone could give me an in-depth explanation of how this might work or how this is not possible. I would really really really appreciate it.

Best Regards,
-Sky

Im trying to create a page that collects personal info from users and registers them.  I have a page that contains the registration form which i will call page 1.  A second page which I will call page 2, processes the form.   A simplified version of page 2 looks like this Code: [Select]

<?php

if (isset($_POST['submitted'])) {
 
    $errors = array();


// Connect to the database.

        require_once ('config.php');


//Check for errors.


//Check to ensure that the password is long enough and is of the right format.

if (eregi ("^[[:alnum:]]{8,16}$" , $_POST['password'])) {

      $b = TRUE;

    } else {
     
      $b = FALSE;

     $errors[] = 'Please enter a password that consists only of letters and numbers between 8 and 16 characters long.';

    }     


//Check to make sure the password matches the confirmed password.

if ($_POST['password'] == $_POST['password2']) {

     $c = TRUE;

     $password =  $_POST['password']; //Encrypt the password.

    } else {

        $c = FALSE;

     $errors[] = 'The password you entered did not match the confirmed password.';

    }




//Check to make sure they entered their first name and it's of the right format.

if (eregi ("^([[:alpha:]]|-|')+$", $_POST['firstname'])) {

        $d = TRUE;

    } else {

        $d = FALSE;

        $errors[] = 'Please enter a valid first name.';


   }



//Check to make sure they entered their last name and it's of the right format.

if (eregi ("^([[:alpha:]]|-|')+$", $_POST['lastname'])) {

        $e = TRUE;

    } else {

        $e = FALSE;

        $errors[] = 'Please enter a valid last name.';


   }




    

//Insert data into database.

if (empty($errors)) {
//query the database.  for the sake of simplicity, I wont include the code
                                       
 // Show thank you message
            echo "<h3>Thank You!</h3>
            You have been registered";
        } else {
            echo '<font color="red">You could not be registered, please contact us about the problem and we will fix it as soon as we can.</font>';

        }


//Display error messages.


} else {// if errors array is not empty


header("Location: page1.php?message=$errors");//Trying to pass the errors array into the url for page1 

        
    }
}

?>



So the idea is to create an array that contains all the errors.  Upon querying the database, if the user completed the fields as required, a thank you message is printed. If not, he is redirected to the page containing the form (page 1) and the array containing the errors is transferred to page 1. Now I will include the relevant section of page 1 whihc is supposed to print the error messages.
Code: [Select]
<?php   if(isset($_GET['message'])  {
                
echo '<h3>Error!</h3>
         The following error(s) occured:<br />';

       
         foreach ($errors as $msg) {
             echo "$msg<br/>\n";
         }

  }

?>


 I get the following error message when I submit the registration forms with deliberate errors:



Error!

The following error(s) occured:

PHP Error Message

Warning: Invalid argument supplied for foreach() in /home/a4993450/public_html/register_page_content.php on line 66

Free Web Hosting
 
Can anyone point out why this error occurs?

Transferring data from sub-domain.site.com
Reading sub-domain.site.com

What is this all about?
I'm going to put all .. images into a separate sub-domain eg: images.site.com.
This would create a folder inside my public_HTML called "images"

Now when sites have that Transferring data, and Reading... is this .. something relating to what I want. Facebook also does it, and they get their images for the site from a sub domain, how is it all done?

I'm not sure if its entirely PHP, but I hope someone can help.

Thanks

hello friends 

I'm dealing with this problem for two days. I put here the screenshot for easier understanding.Sorry about my bad english.

Here is the ss

http://i61.tinypic.com/2rz5q55.jpg

I don't want to inner join or table join. All image links  which same sku should displayed in single row where products.resimler colon
I can join the tables but i want to one table.Because i can import single csv file for e-commerce script.How can I use a update query for list multiple images in table products.
Edited by nogai, 10 October 2014 - 07:01 AM.

hello,
i am transferring the post number from a forum page, to a non-forum page via url variables.. 

how do i stop someone editing the url variable and viewing the posts concerned? i thought i could possibly use cookies/or a kind of auto-post form..

please help if you can.. just what to google would be appreciated

This topic has been moved to mod_rewrite.

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

Is it possible to have a link like this, http://www.somesite.com/?id=243 and transfer the "id" (or another query string) into the website from the link but at the same time, not affect the website (since "id" isn't a query string originally used in the website's URL)? I hope that makes sense..

I'm using PHP and MySQL to display images on the first page.    When the image is clicked on I'm passing an ID to a new page.   I want that ID to display the ID data that's associated with  that ID.    For example:    ID 1 should display - Title - title1,  Details - details1, image - image1    and ID 2   ID 1 should dislay - Title - title2,  Details - details2, image - image2   But only displaying ID 1 data not matter if the URL is - website.com/thedetials.php?id=1  or  website.com/thedetials.php?id=2   In other words, it displays the same data even though the id in the URL is different.        Page 1

$sql="SELECT * FROM thetable";
	  
$result = mysqli_query($con,$sql);
  
 echo " <ul>";
	
  while($row = mysqli_fetch_array($result) {
  echo "<li'>";

  echo "<a href='page2.php?id=$row[id]'><img src=$row[image]></a>";
	                                          
  echo "</li>";
    
 }
  
  echo "</ul>";  
           
 ?> 
     
     

<?php
// End while loop.


mysqli_close($con);

?>

Page 2

$id = $_GET['id']; 

$sql="SELECT id, title, details, image, FROM thetable";
	  
$result = mysqli_query($con,$sql);


$row = mysqli_fetch_array($result);
?>


   <?php echo $row['title'] ?> 
   <?php echo $row['details'] ?>
   <img class='projectItem-pic' src="<?php echo $row['image']?>">

If I use below - No data displays, not sure why.

$sql="SELECT * FROM thetable WHERE id = $id";  

Can someone tell me what I'm doing wrong? 
Edited by patmon, 08 June 2014 - 09:22 PM.

Hi there. I have a page(portfolio.php) that shows all the pictures from my db. Now what i want is: when i click on the picture to send me to a page(portfolio_single.php) where other datas are shown but those datas that are related to that picture.
ex: when i click first picture it will open (portfolio_single.php) showing the infos of that picture, then when i click to the secon picture it will open same page with different datas (retreiving them from db).
Anyone have any idea how to do that?

here is my portfolio.php:
Code: [Select]
<?php require_once('Connections/ecommerce_dbcon.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_ecommerce_dbcon, $ecommerce_dbcon);
$query_portofolioPicRec = "SELECT picture FROM `form` ORDER BY formid DESC";
$portofolioPicRec = mysql_query($query_portofolioPicRec, $ecommerce_dbcon) or die(mysql_error());
$row_portofolioPicRec = mysql_fetch_assoc($portofolioPicRec);
$totalRows_portofolioPicRec = mysql_num_rows($portofolioPicRec);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title> Portfolio</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<!-- Stylesheets -->
<link rel="stylesheet" href="css/reset.css" />
<link rel="stylesheet" href="css/styles.css" />

<!-- Scripts -->
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.1/jquery.min.js"></script>
<!--[if IE 6]>
<script src="js/DD_belatedPNG_0.0.8a-min.js"></script>
<script>
  /* EXAMPLE */
  DD_belatedPNG.fix('.button');
 
  /* string argument can be any CSS selector */
  /* .png_bg example is unnecessary */
  /* change it to what suits you! */
</script>
<![endif]-->

</head>

<body class="portfolio">

<div id="wrapper" class="container_12 clearfix">

<!-- Admin Login -->
<h1 id="login" class="grid_4">
        <form id='login' action="checkAdminLogin.php" method='POST' accept-charset='UTF-8'>
        <fieldset >
        <legend class="meta">Admin Login</legend>
        <input type='hidden' name='submitted' id='submitted' value='1'/>
        <table>
        <tr><th>
        <label for='username'>Name:</label> </th>
      <td><input type='text' name='username' id='username'  maxlength="50" /> </td></tr>
        <tr><th>
        <label for='password'>Password:</label></th>
        <td><input type='password' name='password' id='password' maxlength="50" /> </td>
        <th><input type='submit' name='Submit' value='Login' /> </th></tr>
        </table>
        </fieldset>
        </form>
        </h1>

<!-- Navigation Menu -->
<ul id="navigation" class="grid_8">
<li><a href="contact.php"><span class="meta">Get in touch</span><br />Contact Us</a></li>
<li><a href="blog.php"><span class="meta">Latest news</span><br />Blog</a></li>
<li><a href="portfolio.php" class="current"><span class="meta">Our latest work</span><br />Portfolio</a></li>
<li><a href="about.php"><span class="meta">Who are we?</span><br />About</a></li>
<li><a href="index.php"><span class="meta">Homepage</span><br />Home</a></li>
</ul>

<div class="hr grid_12 clearfix">&nbsp;</div>

<!-- Portfolio Items -->

<!-- Section 1 -->

<!-- Section 3 -->
<div class="catagory_1 clearfix">
<!-- Row 1 -->
<div class="grid_3 textright" >
<span class="meta">Our Latest and Greatest Work</span>
<h4 class="title ">Portfolio</h4>
<div class="hr clearfix dotted">&nbsp;</div>
<p>Here you can see all the cars that exist in our database. You can navigate through all of them.</p>
</div>
<div class="grid_9">
<table >
  <tr>
    <?php
$portofolioPicRec_endRow = 0;
$portofolioPicRec_columns = 3; // number of columns
$portofolioPicRec_hloopRow1 = 0; // first row flag
do {
    if($portofolioPicRec_endRow == 0  && $portofolioPicRec_hloopRow1++ != 0) echo "<tr>";
   ?>
    <td><a class="portfolio_item float alpha" href="portfolio_single.php"> <span>Read More</span> <img class="" src="adminform_images/<?php echo $row_portofolioPicRec['picture']; ?>"  alt=""/></a></td>
    <?php  $portofolioPicRec_endRow++;
if($portofolioPicRec_endRow >= $portofolioPicRec_columns) {
  ?>
      </tr>
  <?php
 $portofolioPicRec_endRow = 0;
  }
} while ($row_portofolioPicRec = mysql_fetch_assoc($portofolioPicRec));
if($portofolioPicRec_endRow != 0) {
while ($portofolioPicRec_endRow < $portofolioPicRec_columns) {
    echo("<td>&nbsp;</td>");
    $portofolioPicRec_endRow++;
}
echo("</tr>");
}?>
  </table>
            </div>
</div>


  <div class="hr grid_12 clearfix">&nbsp;</div>

<!-- Footer -->
<p class="grid_12 footer clearfix">
<span class="float"><b> EpokaUniversity || All Rights Reserved &copy; Copyright</b> || HarisKrasniqi, DiamantNeziri, HarisMemeti, KelmendTairi.</span>
<a class="float right button" href="#">top</a>
</p>

</div><!--end wrapper-->

</body>
</html>
<?php
mysql_free_result($portofolioPicRec);
?>


portofolio_single.php:

suppose it is a table that contains the:
 name: (it will echo out the name of the picture depending on which picture u click)
date:
path: etc of the photo

Is it possible to write a php script that would extract data from an external web page. I've been working with php for a few years as a hobby, but I've never seen this done or needed a reason to until now. Thanks in advance for any responses.

I'm trying to loop "Question" as a list of links (link is #id_number), and then later on the page loop "Question" and "Answer", anchored by the id_number tag.

It's looping "Question" just fine, but how do I then loop the same data again later in the same page?

Code: [Select]
<?php
$username="username";
$password="password";
$database="database_name";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM ft_form_17 WHERE Include='Include'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>

Header Goes here<br /><br /><br />

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"question"); //Question
$f2=mysql_result($result,$i,"answer"); //Answer
$f3=mysql_result($result,$i,"submission_id"); //id number
?>

<a href="#<?php echo $f3; ?>"><?php echo $f1; ?></a><br />

<?php
$i++;
}
?>
<br /><br /><br />

<strong><a name="<?php echo $f3; ?>"><?php echo $f1; ?></a></strong>
<?php echo $f2; ?>

I must be mixing apples and oranges here or something trying to get two columns/fields of MySQL data to display. The basic HTML page display OK and there are no MySQL Connection errors (finally resolved those).

<HTML snipped>

<?php

require '...<URL snipped>...';

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

$sql="SELECT `name`, `id` FROM `roster`";

$result = mysqli_query($con,$sql);
$num=mysqli_num_rows($result);
mysqli_close($con);
?>

<table border="0" cellspacing="2" cellpadding="2">
<tr>
<td>
<font face="Arial, Helvetica, sans-serif">NAME</font>
</td>
<td>
<font face="Arial, Helvetica, sans-serif">ID</font>
</td>
</tr>
<?php

function mysqli_result($res, $row, $field=0) {
    $res->data_seek($row);
    $datarow = $res->fetch_array();
    return $datarow[$field];
} 

$i=0;
while ($i < $num) {
	$f1=mysqli_result($result,$i,$datarow[$field]);
	$f2=mysqli_result($result,$i,$datarow[$field]);
?>

<tr>
<td>
<font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font>
</td>
<td>
<font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font>
</td>
</tr>

<?php
         $i++;
}
?>

</table>

<?php
?>

<HTML snipped>

Any assistance is appreciated.   Thanks very much.   - FreakingOUT  

I have been playing around with this. Thought I had it nailed, and then found that It was fubar when I started to add more entries to the database. I basically want to display 2 tables from my database on the page. One is called "players" the other is called "editlog".

The output with my current script came out as this:


and here is the dreaded code:
<html>
<body>

<u><h3>Performance Point Monitor (PPM): Knights of Shadow WoW Officers.</h3></u>
<?php
include('/home/a3269923/public_html/ppm/admin/config.php');
include('/home/a3269923/public_html/ppm/admin/dbopen.php');
$query="SELECT * FROM players";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<table border="1" style="position:absolute;width:500;height:10;left:0;top:70">
<tr>
<th><font face="Arial, Helvetica, sans-serif">PLAYER</font></th>
<th><font face="Arial, Helvetica, sans-serif">POINTS</font></th>
<th><font face="Arial, Helvetica, sans-serif">DATE</font></th>
</tr>
<?php
$i=0;
while ($i < $num) {
$f2=mysql_result($result,$i,"PLAYER_NAME");
$f3=mysql_result($result,$i,"ND_POINTS");
$f4=mysql_result($result,$i,"DATE ADDED");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
</tr>
</table>

<?php
$i++;
}
?>
<?php
include('/home/a3269923/public_html/ppm/admin/config.php');
include('/home/a3269923/public_html/ppm/admin/dbopen.php');

//USER LOG
$query="SELECT * FROM editlog";
$result=mysql_query($query);
$num=mysql_numrows($result);
?>
<table border="1" style="position:absolute;width:600;height:10;left:510;top:70">
<tr>
<th><font face="Arial, Helvetica, sans-serif">USER</font></th>
<th><font face="Arial, Helvetica, sans-serif">TYPE</font></th>
<th><font face="Arial, Helvetica, sans-serif">POINTS</font></th>
<th><font face="Arial, Helvetica, sans-serif">NOTES</font></th>
<th><font face="Arial, Helvetica, sans-serif">DATE</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"USER");
$f2=mysql_result($result,$i,"TYPE");
$f3=mysql_result($result,$i,"POINTS");
$f4=mysql_result($result,$i,"NOTE");
$f5=mysql_result($result,$i,"TIMESTAMP");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
</tr>
</table>

<?php
$i++;
}
?>


What am I doing wrong? Halp!

I'm new to PHP and I have an html page I would like to pull specific data into certain areas on the page that I will modified for php.

Here are some details. The page is a static html page that has the prices of 40+ products in a standard <li> list. When I update the prices in our database through our shopping cart, I have to change these prices manually in the html. https://www.novon.co...mic_mixers.html. It would be great if I could link the field for Base_Price in the products table to each affiliated <li> tag,

I am pulling all the data I need into ($results) and can display it all but I don't know how to get just the single products Base_Price in my <li> tag. <?=$row['Base_Price'] ?>

I know this code is not correct but to get the point across, can I create a variable that I define in each <li> tag with a statement like,,,, <?=$row['Base_Price with Product_Code=123456'] ?>

I could create a new SQL query for each <li> like "SELECT Base_Price from Products WHERE Product_Code='123456' ", but that's a lot of calls to the DB and a lot of code on the page.

And just so I weed out the hard core coders, I can not rebuild the entire page. This is too big of a project for me and my limited coding with PHP.

Can anyone help??
Thanks in advance
Michael