PHP - Not Pulling Information From One Page To Another <form>

Hiya peeps,

I have been sent this today;

select company_map.*, map.*,addresses.address,addresses.nomitative,addresses.number, c.postcode from company_map join map on map.id=company_map.map_id join company c on c.company_id=company_map.company_id join addresses on addresses.address_id=c.address_id where company_map.company_id='79' and company_map.ui_shell_id <> 0 and language_id='en'

when I print all the results from this I get a postcode, I was wondering if anyone could read this code and simplify it for me, I really need to know what table this query is pulling the postcode from.

Many many thanks,

James.

Hey all!. I was wondering if there was a way to process information from major websites using php? It seems I am running into issues.

Here is what I am trying to do:

I need to pull the full list of companies from pinksheets.com that are listed on the exchanges. I can download the list via XLS format, but I need to do this for all the exchange websites such as nasdaq etc.

Is there a way to do this where I can comb for the information such as CEO name, ticker , company name and any companies that get taken off or added to the list? The lists I am already talking about are on the sites I mentioned and you can look them up but I am adding 40,000+ companies to my site it manually entering them would be a huge issue,.

Do any of you have any fixes? Sorry if this is in the wrong section.

Thanks!.

Smash.

I am pulling an youtube embedded code from a database however when I have the homepage pull it from the database it will not show anything after the video....

EXAMPLE...(this is what it should look like)

1.) Title By: Author
     Youtube Video
     Message
     Posted By:

(however this is what it looks like)

1.) Title By: Author
     Youtube Video
 
*The "message" and "Posted By:" just do not show up*

The code is below can someone help me with this problem., it would be greatly appreciated.


Code: [Select]
<?php
//open database
$connect = mysql_connect("Database","name","password") or die("Not connected");
mysql_select_db("database") or die("could not log in");

$query = "SELECT * FROM boox ORDER BY date DESC";
$result = mysql_query($query);

 // Get the page number, if none is set - it is 0
if( isset($_GET['page']) )
{ 
$page =$_GET['page']; 
}
else
{
$page  = 0;
}

$resultsPerPage = 15;
$num = mysql_num_rows($result); // amount of rows
$loops = $page*$resultsPerPage; // starting loops at..

while ($loops < $num && $loops <  ($page+1)*$resultsPerPage )
{
$link = mysql_result($result,$loops,"link"); // get result from the 'link' field in the table
$username = mysql_result($result,$loops,"username"); // get result from the 'username' field in the table
$messsage = mysql_result($result,$loops,"message");
$author = mysql_result($result,$loops,"author");
$title = mysql_result($result,$loops,"title");
$date = mysql_result($result,$loops,"date");
if ($pagelimit == 0)
{
$pagelimit == 1;
}
if ($pagelimit <= 15)
// echo stuff here
$loopz = $loops + 1;
 echo "&nbsp;&nbsp;&nbsp
 </br><align='left'><table width='297' height='900' border='1' align='center' bgcolor='#111'>
  <tr>
    <td>$loopz.)&nbsp;$title By: $author
</br>
$link
</br>
$message
</br>
Posted By: $username $date
</td>
  </tr>
</table></br><br>";
 $count++ ;
 $pagelimit++;
 $loops++;
}

if ( $page!=0 ) // Show 'Previous' link
{
$page--;
$prevpage = ($page +  1);
echo "<br><br><br><a href='index.php?page=$page'>Previous  $prevpage &nbsp;&nbsp;&nbsp;&nbsp;</a>";
$page++;
}
if ($loops > 5&&($page+1)*$resultPerPage < $num ) // Show 'next' link
{
$page++;
$nextpage = ($page + 1);
echo "<a href='index.php?page=$page'>   Next $nextpage</a>";
}
 
?>

Good afternoon,   I was wondering if you could help me out with a few things.  I have created a registration page and it stores the information into my database.  A success page then appears with some of the details they entered as a confirmation page.  Unfortunately I cannot get the information to appear on the page.  I have included some code, any help would be greatly appreciated.   <?php

Hello all,
Would anyone know how to fix this code to work so that when a user fills out a simple form it update a row in my database? The code below doesn't get the parameters from the form. 
The $sql = 'UPDATE services SET `Description` = "$description1" WHERE ID=1'; line works perfect only its putting in the $description literally no form parameters??
I have a feeling I need to handle this a different way but other trys with different code were not successful. 
Using Myphpadmin and mysql 5.1
Thanks in advanced. 
Code:

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<?php

$con = mysql_connect('localhost', 'DATA_BASE', 'test123');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("DATA_BASE", $con);

$sql = 'UPDATE services SET `Description` = "$description1" WHERE ID=1';
mysql_query($sql, $con);

if($_POST['Submit']){

$description1=$description1=$_POST['description1'];
$price1=$_POST['price1'];

mysql_error();

header("location:updates.php");
exit;
}

mysql_close();
?>

<html>
<head>
<title>Updates Page</title>
</head>

<body bgcolor="#A55125">
<div align="center">

<form method="post" action="<? echo $PHP_SELF; ?>">
<span class="forms">Description:</span><br />

<textarea name="description1" cols="40" rows="5" >
</textarea><br>
<span class="forms">Price:<br />
</span>

<input name="price1" type="text" id="price1"><br />

<input type="submit" value="Submit" />

</form>
</div>

</body>
</html>

MOD EDIT: [code] . . . [/code] tags added.

Hello-

I have a social network that has a blogs and questions section. There are community pages for each one ( blogs/questions ) On each of those pages. the first ten blogs/questions are displayed. To the right of those are a list of clickable categories that sort the pages according to their category.

I have pagination implemented after each ten. I am doing a mod_rewrite for pretty urls on my dev and have everything working correctly. The problem is, after hitting next the first time 'page=' is blank and just reloads the first (defaulted page) but after a second click it becomes 'page=10' as it should and then the third click 'page=20" as it should.

So basically I am trying to get it to go to 'page=10" after one click, not two. Here is the code for the pagination:

Code: [Select]
<div id="all_page_turn">
                         <ul>

                            <?php if($totalBlogs > 10 && $_GET['page'] >= 10) { ?>
                             <li class="PreviousPageBlog round_10px">
                                 <a href="/blogs/?cat=<?php if(isset($_GET['cat'])) { echo $_GET['cat'];} ?>&sort=<?php if(isset($_GET['sort'])) { echo $_GET['sort'];} ?>&page=<?php if(isset($_GET['page'])) { echo ($_GET['page'] - 10);} ?>">Previous Page</a>
                             </li>
                             <?php } ?>

                               <?php if($totalBlogs > 10 && $_GET['page'] < ($totalBlogs-10)) { ?>
                             <li class="NextPageBlog round_10px">
                                 <a href="/blogs/?cat=<?php if(isset($_GET['cat'])) { echo $_GET['cat'];} ?>&sort=<?php if(isset($_GET['sort'])) { echo $_GET['sort'];} ?>&page=<?php if(isset($_GET['page'])) { echo ($_GET['page'] + 10);} ?>">Next Page</a>
                             </li>
                             <?php } ?>



                         </ul>
        </div>

</div>and here is the defaulted category link:

Code: [Select]
<div id="RightBlogs">
        <div id="search_blogs_future" class="round_10px">
        <form name="searchBlogs" action="/blogs" method="get">
            <input type="text" name="BlogSearch" class="text" value="<?php if(empty($_GET['BlogSearch'])) { echo "Search Blogs"; }else{ echo $_GET['BlogSearch'];} ?>" onclick="clearify(this);" />
             <input type="submit" name="subBlogSearch" value="Search" />
         </form>
     </div>
     <div class='<?php if(empty($_GET['cat']) || $_GET['cat'] == "All") { echo "all_blog_cats_Highlighted"; }else{ echo "all_blog_cats_unHighlighted"; } ?> round_10px'>
         <a href='/blogs/?cat=All'>
                 All
                 </a>
          </div>Here is a screen shot of the page, as I'm on my dev so I can't provide a link. you can't see the "next" button, but it's there on the bottom, and then the categories are on the right.

[attachment deleted by admin]

index.php?page=1 that link style but there is not hard files it is all to be stored in the DB

here is what i have got so far

Code: [Select]
<?

$result = mysql_query("SELECT * FROM page") or die(mysql_error());
$row = mysql_fetch_array( $result );

if(isset($_GET['page'])) {
echo $row['text'];
} else {
$result = mysql_query("SELECT * FROM page
 WHERE id='1'") or die(mysql_error());
$row = mysql_fetch_array( $result );
echo $row['text'];
}
?>
but always shows page ID 1 (home page) so i no i am missing something just not sure what hehe

DB structu
Code: [Select]
menu
----id (auto increase)
----name (home, about etc)
----id2 (page weight)
pages
----id (auto increase)
----name (page name home, about etc)
----text (page text)


link structure from the menu

Code: [Select]
<?

$result = mysql_query("SELECT * FROM menu ORDER BY id2") or die(mysql_error()); 


?>
<table>
<?
while($row = mysql_fetch_array( $result )) { ?>

<tr><td>
<a href="index.php?page=<? echo $row['id'];?>"><? echo $row['name']; ?></a>
</td></tr> <?
}
?>
</table>


dont think i have missed any info that i have on file but not sure why it will not link so thought of you guys hehe

Thanx in advance

Hi,

So I am currently making a real estate site for my class at school but I am having a tiny issue with the listing display page.

So what I want to do is show a bunch of listing that the agent owns on their dashboard which I have already done. Now I have two links one to update the listing and one to view the listing. Now what I am trying to do is when the view listing link is clicked it will take the user to the listing-display page and then I want it to display all the information for the listing that the link was clicked under. But i cannot for the life of me figure out how to do that!

 

This is currently the code for the dashboard where you only view the listing headline

<?php

// If the session was never set with a user id
$output = '';
$conn = db_connect();
if($_SESSION['userType'] != AGENT)
{
    $_SESSION['RedirectError'] = "You were not logged in as an Agent<br/>";
    header("Location:login.php");
}
if (isset($_GET["page"])) {
    $page  = $_GET["page"];
    $index = ($page -1) * IMAGE_LIMIT;
}
else {
    $page=1;
    $index = 0;
 }


?>
  <!-- start of main page content -->
  <div class="container" style="margin-top: 2em;">
    <h2>Dashboard</h2>

      <p>Welcome back <?php echo $_SESSION['userId']; ?> you last logged in on <?php echo $_SESSION['last_access']; ?></p>
      <h4>Your Listings</h4>
      <?php
          $sql = "SELECT listing_id FROM listings WHERE user_id = '".$_SESSION['userId']."' AND status = 'o' ORDER BY listing_id";
          $result = pg_query($conn, $sql);
          $listings = pg_fetch_all($result);
          for($index; $index < pg_num_rows($result); $index++)
          {
              $sql = "SELECT * FROM listings WHERE listing_id = '".$listings[$index]['listing_id']."'";
              $listing_result = pg_query($conn, $sql);
              $arrayRow = pg_fetch_assoc($listing_result);
              echo (build_listing_card($arrayRow));
              if($index !=0 && ($index +1) % IMAGE_LIMIT ==0){
                  break;
              }
          }
      ?>
          </div>
          <br/>
          <?php
          $total_pages = ceil(count($listings) / IMAGE_LIMIT);
          $pageLink = "<div class='pagination'>";
          for ($i=1; $i<=$total_pages; $i++) {
                       if($i == $page)
                       {
                          $pageLink .= "<a class='active' href='dashboard.php?page=".$i."'>".$i."</a>";
                       }
                       else {
                           $pageLink .= "<a href='dashboard.php?page=".$i."'>".$i."</a>";
                       }
          };
           ?>
       </div>
       <br/>

and this is the code for the listing-display page where I want all the listing information to be displayed
 

<?php

if (isset($_GET['listing_id']))
    {
        $_SESSION['listing_id'] = $_GET['listing_id'];
    }
    else
    {
        $_SESSION['listing_id'] = 0;
        echo "ERROR: listing information was not find";
    }

    $sql = 'SELECT * FROM listings WHERE listing_id = ' . $_SESSION['listing_id'];
    echo "<BR>".$sql;
    $result = pg_query(db_connect(), $sql);
    $records = pg_num_rows($result);

    echo "<BR>".pg_fetch_result($result, 0, "listing_id");
    echo "<BR>".pg_fetch_result($result, 0, "user_id");
    echo "<BR>".pg_fetch_result($result, 0, "status");
    echo "<BR>".pg_fetch_result($result, 0, "price");
    echo "<BR>".pg_fetch_result($result, 0, "headline");
    echo "<BR>".pg_fetch_result($result, 0, "description");
    echo "<BR>".pg_fetch_result($result, 0, "postal_code");
    echo "<BR>".pg_fetch_result($result, 0, "images");
    echo "<BR>".pg_fetch_result($result, 0, "city");
    echo "<BR>".pg_fetch_result($result, 0, "property_options");
    echo "<BR>".pg_fetch_result($result, 0, "bedrooms");
    echo "<BR>".pg_fetch_result($result, 0, "bathrooms");
    echo "<BR>".pg_fetch_result($result, 0, "garage");
    echo "<BR>".pg_fetch_result($result, 0, "purchase_type");
    echo "<BR>".pg_fetch_result($result, 0, "property_type");
    echo "<BR>".pg_fetch_result($result, 0, "finished_basement");
    echo "<BR>".pg_fetch_result($result, 0, "open_house");
    echo "<BR>".pg_fetch_result($result, 0, "schools");
?>
<h1> Listing Display </h1>
<hr/>
<table style="width:50%" border="1px solid black">
    <tr>
        <th>Listing Image</th>
        <th>Listing Description</th>
    </tr>
    <tr>
        <th rowspan="2">
            <img src="" alt="Oshawa House" width="300px" height="200px"/>
        </th>

        <td align="left" valign="top">
        <h3><?php echo pg_fetch_result($result, 0, "headline")  ?></h3>
        <ul>
        <li>Open house?: <?php echo get_property('open_house', pg_fetch_result($result, 0, "open_house"))?> </li>
        <li>Finished Basement?: <?php echo get_property('finished_basement', pg_fetch_result($result, 0, "finished_basement"))?></li>
        <li><?php echo get_property('purchase_type', pg_fetch_result($result, 0, "purchase_type"))?></li>
        <li>Garage Type: <?php echo get_property('garage_type', pg_fetch_result($result, 0, "garage"))?></li>
        <li>Near school?: <?php echo get_property('schools', pg_fetch_result($result, 0, "schools"))?></li>
        <li>Status: <?php echo get_property('listing_status', strtolower(pg_fetch_result($result, 0, "status"))) ?></li>
        <li>Washrooms: <?php echo get_property('washrooms',pg_fetch_result($result, 0, "bathrooms"))  ?></li>
        <li>Bedrooms: <?php echo get_property('bedrooms',pg_fetch_result($result, 0, "bedrooms"))  ?></li>
        <li>Description: <?php echo pg_fetch_result($result, 0, "description")  ?></li>
        </ul>
        </td>

    </tr>
    <tr>
        <td align="left" valign="top"><ul>
            <li>Location: <?php echo get_property('cities',pg_fetch_result($result, 0, "city"))  ?></li>
            <li>Postal Code: <?php echo pg_fetch_result($result, 0, "postal_code") ?></li>
            <li>Price: <?php echo pg_fetch_result($result, 0, "price") ?></li>
            </ul>
        </td>
    </tr>

</table>
<form action="listing-matches.php">
<p>
<input type="submit" name="submit" value="Back"/></p>
</form>

 

 

here's my html form:
<form action="contact2.php" method="post" target="_self" id="contactform">
                <ol>
                  <li>
                    <label for="name2">Your Name <span class="red">*</span></label>
                    <input id="name2" name="name2" class="text" />
                  </li>
                  <li>
                    <label for="youremail">Your email <span class="red">*</span></label>
                    <input id="youremail" name="youremail" class="text" />
                  </li>
                  <li>
                    <label for="company2">Company</label>
                    <input id="company2" name="company2" class="text" />
                  </li>
                  <li>
                    <label for="subject2">Subject</label>
                    <input id="subject2" name="subject2" class="text" />
                  </li>
                  <li>
                    <label for="message2">Message <span class="red">*</span></label>
                    <textarea id="message2" name="message2" rows="6" cols="50"></textarea>
                  </li>
                  <li class="buttons">
                    <input type="image" name="imageField" id="imageField" src="images/send.gif" />
                  </li>
                </ol>
              </form>

Here's my php code:

<?PHP
global $_POST;
$name = $_POST["name2"];
$youremail = $_POST["youremail"];
$company = $_POST["company2"];
$subject = $_POST["subject2"];
$message = $_POST["message2"];

$to = "ldemotts@market-johnson.com";
$subject = "Form Submission";
$headers = "From: $youremail\n";

$message = "A visitor to your site has filled out the following information.\n
Name: $name2
Email Address: $youremail
Company: $company2
Subject: $subject2
Message: $message2";

if (preg_match(' /[\r\n,;\'"]/ ', $_POST['youremail'])) {
  exit('Invalid Email Address');
}
else {
mail($to,$subject,$message,$headers);
}


?>

Ok what I am trying to do it make a simple form. Once the user has eneter all the details and clicked submit I want this information to be sent to me in an email.

So far I have got the email sending but i am just having trouble getting the information to be displayed correctly in the email that is sent.

For the subject I want first name last name <email>.

And then for the main message of the email I want the information from the form to displayed something like the following.

First  Name : '$fname'
Last Name : '$lname'


and so on for all the variables i have collected from the online form.

Here is what I have got so far and I would appreciate any help you can give me thanks.



<?php
                    if ($_SERVER['REQUEST_METHOD']=="POST"){
                                                
                    // Recipent Email
                    $to="andrew@peppermintdigital.com";
                                                        
                    $subject="Reply to Peppermint Invitation";
                    
                    $title = $_POST['title'];
                    $fname = stripslashes($_POST['fname']);
                    $sname = stripslashes($_POST['sname']);
                    $add1 = stripslashes($_POST['add1']);
                    $add2 = stripslashes($_POST['add2']);
                    $add3 = stripslashes($_POST['add3']);
                    $add4 = stripslashes($_POST['add4']);
                    $postcode = stripslashes($_POST['postcode']);
                    $number = stripslashes($_POST['number']);
                    $email = stripslashes($_POST['email']);
                    $time = $_POST['time'];
                    
                                                        
                    $from = stripslashes($_POST['fname']) ."<".stripslashes($_POST['email']).">";
                                                        
                    // Email Message
                    $message = $_POST['postcode'];
$body = "hello";
                                                        
                                                        
                    // Validation Begins 

                    // Add Erros To Array
                    $errors = array();
                     
                    // Check Form
                    if (!$_POST['title'])
                    $errors[] = "Title Required";
        
                    if (!$_POST['fname'])
                    $errors[] = "Forename Required";
                    
                    if (!$_POST['sname'])
                    $errors[] = "Surnname Required";
                    
                    if (!$_POST['add1'])
                    $errors[] = "Address Required";

if (!$_POST['add4'])
                    $errors[] = "City Required";
                    
                    if (!$_POST['postcode'])
                    $errors[] = "Postcode Required";
                    
                    if (!$_POST['number'])
                    $errors[] = "Number Required";
                    
                    if (!$_POST['email'])
                    $errors[] = "Email Required";
                    
                    if (!$_POST['time'])
                    $errors[] = "Time Required";
                    
                    
                    // Display Errors
                    
                    if (count($errors)>0)
                    
                    {
                    echo"<h1 class='fail'>";
                    foreach($errors as $err)
                    echo "$err.\n";
                    echo"</h1>";
                    }
                    
                    else {                    
                                                        
                                                        
                    // Build message headers
                    $headers = "From: $from\r\n" .
                    "MIME-Version: 1.0\r\n" .
                    "Content-Type: multipart/mixed;\r\n" .
                    " boundary=\"{$mime_boundary}\"";
                                                        
                    // Build message body
                    // Insert two dashes in front of the MIME boundary when we use it
                    $message = "This is a multi-part message in MIME format.\n\n" .
                    "--{$mime_boundary}\n" .
                    "Content-Type: text/plain; charset=\"iso-8859-1\"\n" .
                    "Content-Transfer-Encoding: 7bit\n\n" .
                    $message . "\n\n";
                                                        
                    // Start of attachment
                    $message .= "--{$mime_boundary}\n" .
                    "Content-Type: {$type};\n" .
                    " name=\"{$name}\"\n" .
                    "Content-Transfer-Encoding: base64\n\n" .
                    $data . "\n\n" .
                    "--{$mime_boundary}--\n";
                                                        
                    // Send message
                        if (@mail($to, $subject, $message, $headers))
                        echo "<h1 class='success'>Your message has been sent.</h1>";
                        
                        else
                        echo "<h1 class='fail'>Your message was not sent at this time.</h1>";
                        }
                     }
                    else { } 
                    ?>                 

Hi Guys,

I need a bit of help. I need to post a value to a second page, but I want the button to have the same name.

The page is to show registered users and then allows a user to send a friend request 'to put it in simple terms'.

Username submitbutton username submitbutton And then i do the following

<?php
foreach ($_POST['username') as $user
{
echo $user;
}
?>
How could i go about doing this or would I have to use a 'Hidden' Field.

I am writing an email form for my site with some simple validation. I have the error messages working just fine. They do what they are supposed to do.

However, when the form is brought back up to have the errors fixed. It puts a "1" in the field box. I looked at the code and I do not see where the "1" is coming from.

I am also in the process of trying to figure out how to send email through my mail account using smtp. I want to see if it is going to send me the information that I ask for or the "1". Currently all of my work is being done on my localhost server

Here is the code that I am using

Code: [Select]
<?php

$email_form = "<form action='' target='' id='contactform' method='post'>\n";
$email_form .="<p class='form_header'>Contact us</p>\n";
$email_form .= "<fieldset>\n";
$email_form .= "<P>\n";
$email_form .= "<label for='name'><em>*</em> Your Name:</label>\n";
$email_form .= "<input type='text' name='name' id='name' value=".(isset($_POST['name']))." />\n";
$email_form .= "</p>\n";
$email_form .= "<p>\n";
$email_form .= "<label for='email'><em>*</em> E-mail:</label>\n";
$email_form .= "<input type='text'  name='email' id='email' value=".(isset($_POST['email']))." />\n";
$email_form .= "</p>\n";
$email_form .= "<p>\n";
$email_form .= "<label for='subject'>Subject:</label>\n";
$email_form .= "<input type='text' name='subject' id='subject' value=".(isset($_POST['subject']))." />\n";
$email_form .= "</p>\n";
$email_form .= "<p>\n";
$email_form .= "<label for='message'><em>*</em> Message:</label>\n";
$email_form .= "<textarea name='message' id='message'>".(isset($_POST['message']))."</textarea>\n";
$email_form .= "</p>\n";
$email_form .= "<input type='submit' id='submit' value='Submit!' name='submitted' /><br />\n";
$email_form .= "<p class='required'>Fields marked with an asterik(*) are required</p>\n";
$email_form .= "</fieldset>\n";

if (!isset($_POST['submitted'])) {
    echo "$email_form";
}
else {
    $name = (isset($_POST['name']));
    $email = (isset($_POST['email']));
    $to = "your@email.co.uk";
    $subject = (isset($_POST['subject']));
    $body = (isset($_POST['message']));

    if ($subject == "") {
        $subject = "Email from website";
    }
    else {
        $subject == $subject;
    }

    if ($_POST['name'] != "") {
        $_POST['name'] = filter_var($_POST['name'], FILTER_SANITIZE_STRING);
        if ($_POST['name'] == "") {
            $errors .= 'Please enter a valid name.<br/><br/>';
        }
    }
    else {
        $errors .= 'Please enter your name.<br/>';
    }

    if ($_POST['email'] != "") {
        $email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);
        if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
            $errors .= "$email is <strong>NOT</strong> a valid email address.<br/>";
        }
    }
    else {
        $errors .= 'Please enter your email address.<br/>';
    }

    if ($_POST['message'] != "") {
        $_POST['message'] = filter_var($_POST['message'], FILTER_SANITIZE_STRING);
        if ($_POST['message'] == "") {
            $errors .= 'Please enter a message to send.<br/>';
        }
    }
    else {
        $errors .= 'Please enter a message to send.<br/>';
    }

    if (empty($errors)) {

        $headers = 'MIME-Version: 1.0' . "\r\n";
        $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
        $headers .= "From: " . $email . "\r\n";

        $success = mail($to, $subject, $body, $headers);
    }

    if ($success) {

        echo "<p>The following email has been sent</p>\n";
        echo "<p>Name: $name</p>\n";
        echo "<p>E-mail: $email</p>";
        echo "<p>Subject: $subject</p>\n";
        echo "<p><em>*</em> Message: $body</p>\n";
        echo "<p>While you are waiting for a response from one of our staff members. Feel free to look at some of the following sections</p>\n";
        echo "<a href='../waiting.php'>In The Mail</a>";
        echo "Thank you for visiting Michael48060.</p>\n";
    }

    else
        echo "$email_form";
}

if (!empty($errors)) {
    echo "<div class='error_div'>
<span class='errors'>" . $errors . "</span>
</div>";
}
?>

On an HTML Form, I have several Text boxes called "base1, base2...base13"
Another text box I have is called "base_quantity"

In my PHP routine: This is part of my code: Code: [Select]
$selected_base = $_POST['base1'];
if ($selected_base == 'yes') {
$base_value = $base_value + 1;
$base_status = 'Yes';   }
else if ($selected_base == 'no') {
$base_value = $base_value - 1;
$base_status = 'No';   }Later on in the PHP routine I want to pass back to the Form the value of $base_status and place it in the "base_quantity" text box. Something like this: base_quantity = $base_value.

Can someone tell me how information is passed back to the FORM.

Thank You,
Sam

hi everyone,
Im trying to make a checkout page, where if the user is logged in, the address information is called from the database and fills the form automatically, my problem is i don't know how to fill the php variables with the result of my sql query..sorry to be a complete noob but can someone explain how i would do this?
<?php
if (!defined('WEB_ROOT')
    || !isset($_GET['step']) || (int)$_GET['step'] != 1) {
exit;
}
require_once 'loginfunctions.php';
checkCustomerLogin();
$errorMessage = '&nbsp;';
?>

<?php
// get the customer id from the session.
$cu_id = $_SESSION['cu_id']
?>
<?php
//connect to server
$mysqli = mysqli_connect("localhost", "root", "", "onlinestore");
//get default shipping and payment address
$mysql = "SELECT cu_id,od_shipping_first_name,od_shipping_last_name,od_shipping_address1,od_shipping_address2,od_shipping_phone,od_shipping_city,od_shipping_state,od_shipping_postal_code FROM tbl_customer WHERE $cu_id = cu_id";
$result = mysqli_query($mysql,$mysqli);
$row = mysql_fetch_assoc($result);
//populate form with values ?
$txtShippingFirstName = 'test';
$txtShippingLastName = 'test';
$txtShippingAddress1 = 'test';
$txtShippingAddress2 = 'test';
$txtShippingPhone = 'test';
$txtShippingState = 'test';
$txtShippingCity = 'test';
$txtShippingPostalCode = 'test';
?>

<script language="JavaScript" type="text/javascript" src="library/checkout.js"></script>
<table width="550" border="0" align="center" cellpadding="10" cellspacing="0">
    <tr> 
        <td>Step 1 Of 3 : Please Confirm Shipping And Payment Information </td>
    </tr>
</table>
<p id="errorMessage"><?php echo $errorMessage; ?></p>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>?step=2" method="post" name="frmCheckout" id="frmCheckout" onSubmit="return checkShippingAndPaymentInfo();">
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
        <tr class="entryTableHeader"> 
            <td colspan="2">Shipping Information</td>
        </tr>
        <tr> 
            <td width="150" class="label">First Name</td>
            <td class="content"><input name="txtShippingFirstName" type="text" class="box" id="txtShippingFirstName" value="<?php echo $txtShippingFirstName ?>" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Last Name</td>
            <td class="content"><input name="txtShippingLastName" type="text" class="box" id="txtShippingLastName" value="<?php echo $txtShippingLastName ?>" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address1</td>
            <td class="content"><input name="txtShippingAddress1" type="text" class="box" id="txtShippingAddress1" value="<?php echo $txtShippingAddress1 ?>" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address2</td>
            <td class="content"><input name="txtShippingAddress2" type="text" class="box" id="txtShippingAddress2" value="<?php echo $txtShippingAddress2 ?>" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Phone Number</td>
            <td class="content"><input name="txtShippingPhone" type="text" class="box" id="txtShippingPhone" value="<?php echo $txtShippingPhone ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Province / State</td>
            <td class="content"><input name="txtShippingState" type="text" class="box" id="txtShippingState" value="<?php echo $txtShippingState ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">City</td>
            <td class="content"><input name="txtShippingCity" type="text" class="box" id="txtShippingCity" value="<?php echo $txtShippingCity ?>" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Postal / Zip Code</td>
            <td class="content"><input name="txtShippingPostalCode" type="text" class="box" id="txtShippingPostalCode" value="<?php echo $txtShippingPostalCode ?>" size="10" maxlength="10"></td>
        </tr>
    </table>
    <p>&nbsp;</p>
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
        <tr class="entryTableHeader"> 
            <td width="150">Payment Information</td>
            <td><input type="checkbox" name="chkSame" id="chkSame" value="checkbox" onClick="setPaymentInfo(this.checked);"> 
                <label for="chkSame" style="cursor:pointer">Same as shipping information</label></td>
        </tr>
        <tr> 
            <td width="150" class="label">First Name</td>
            <td class="content"><input name="txtPaymentFirstName" type="text" class="box" id="txtPaymentFirstName" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Last Name</td>
            <td class="content"><input name="txtPaymentLastName" type="text" class="box" id="txtPaymentLastName" size="30" maxlength="50"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address1</td>
            <td class="content"><input name="txtPaymentAddress1" type="text" class="box" id="txtPaymentAddress1" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Address2</td>
            <td class="content"><input name="txtPaymentAddress2" type="text" class="box" id="txtPaymentAddress2" size="50" maxlength="100"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Phone Number</td>
            <td class="content"><input name="txtPaymentPhone" type="text" class="box" id="txtPaymentPhone" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Province / State</td>
            <td class="content"><input name="txtPaymentState" type="text" class="box" id="txtPaymentState" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">City</td>
            <td class="content"><input name="txtPaymentCity" type="text" class="box" id="txtPaymentCity" size="30" maxlength="32"></td>
        </tr>
        <tr> 
            <td width="150" class="label">Postal / Zip Code</td>
            <td class="content"><input name="txtPaymentPostalCode" type="text" class="box" id="txtPaymentPostalCode" size="10" maxlength="10"></td>
        </tr>
    </table>
    <p>&nbsp;</p>
    <table width="550" border="0" align="center" cellpadding="5" cellspacing="1" class="entryTable">
      <tr>
        <td width="150" class="entryTableHeader">Payment Method </td>
        <td class="content">
        <input name="optPayment" type="radio" id="optPaypal" value="paypal" checked="checked" />
        <label for="optPaypal" style="cursor:pointer">Paypal</label>
        <input name="optPayment" type="radio" value="cod" id="optCod" />
        <label for="optCod" style="cursor:pointer">Cash on Delivery</label></td>
      </tr>
    </table>
    <p>&nbsp;</p>
    <p align="center"> 
        <input class="box" name="btnStep1" type="submit" id="btnStep1" value="Proceed &gt;&gt;">
    </p>
</form>

Have never done this before, but I'm sure many of you have. What I am trying to do is take the information that the user fills out in this form and when they hit submit, it will be displayed into a html table on the next page. I don't need someone to do the entire table for me, just looking for some help to get started and a general idea of what to do.


Here is my code for my form that I have created...




Code: [Select]
<!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>Lab 4</title>
   
</head>


<body>
    <?php



?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="radiobutton" name="male" />
<label for="male">Male</label>

<input id="female" type="radio" value="radiobutton" name="female" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="heart" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="blood" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="lung" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="lab4form.php">Unemployed
<OPTION VALUE="lab4form.php">Full-Time
<OPTION VALUE="lab4form.php">Part-Time
<OPTION VALUE="lab4form.php">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>