• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

for andriv

Send me your email and I'll send you the files.

I'm getting closer.

1.  I can get form to display form to MySql data
2.  I can get the form to "accept" the form data and open a new file
3.  The first form is also writing to the database, but it isn't picking up the correct "variable"
4.  Haven't even started on "mailing" a confirm to webmaster & customer.

I think it is an array problem.

Awaiting your email address.

You're my hero!

April
0
aprillougheed
Asked:
aprillougheed
  • 5
1 Solution
 
aprillougheedAuthor Commented:
p.s. - I'm ee@guider.com
0
 
aprillougheedAuthor Commented:
Names and table.

1.  Table one tblLiterature - List of literature that can be selected:

 LiteratureID
 LiteratureSKU  
 LiteratureDescription  
 TypeID

2. Table two tblLiteratueRequested - tracks how many of each LiteratureSKU are ordered and when.

 RequestID  
 LiteratureSKU  
 LiteratureDescription  
 Action  
 Date  

Later to add by who - will be setting up a "member" only function with member table and username/password table. -- more points for you!! -- hopefully I'll be able to figure some of it out :)
0
 
aprillougheedAuthor Commented:
Here is the where I'm at.

************File one***********
<html>
<head><title>Literature Request</title></head>
<body>
<?php
  $user="ag";
  $host="localhost";
  $password="";
  $database = "netafimusa_com";

  $connection = mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
  $db = mysql_select_db($database,$connection)
       or die ("Couldn't select database");

  /* Select all items from tblLiterature table */
  $query = "SELECT * FROM tblLiterature ORDER BY LiteratureDescription";        
  $result = mysql_query($query)                                
       or die ("Couldn't execute query.");

  /* Display text before form */
  echo "<div style='margin-left: .1in'>
  <h1 align='center'>Pet Catalog</h1>
  <h2 align='center'>The following animal friends are waiting for you.</h2>
   <p align='center'>Find just what you want and hurry in to the store to pick
      up your new friend.
  <p><h3>Which pet are you interested in?</h3>\n";

  /* Create form containing selection list */
  echo "<form action='AddPet.php3' method='post'>\n";        
  echo "<table cellpadding='5' border='1'>";
  $counter=1;                                                  
  while ($row = mysql_fetch_array($result))                    
  {
     extract($row);                                            
     echo "<tr><td valign='top' width='15%'>\n";
     echo "<input type='radio' name='interest'                
             value='$LiteratureSKU'\n";
     if ( $counter == 1 )                                      
     {
         echo "checked";
     }
     echo "><font size='+1'><b>$LiteratureSKU</b></font>            
          </td>
          <td>$LiteratureDescription</td>                            
          </tr>";
     $counter++;                                                
  }
  echo "</table>";
  echo "<p><input type='submit' value='Select Pet Type'>        
        </form>\n";                                            
?>
</div>
</body>
</html>

*********File2*************
<html>
<head>
<title>Add Pet</title>
</head>
<body>
Catalog:<br>
<ul>

<?php
  $user="ag";
  $host="localhost";
  $password="";
  $database = "netafimusa_com";

  $connection = mysql_connect($host,$user,$password)
       or die ("couldn't connect to server");
  $db = mysql_select_db($database,$connection)
       or die ("Couldn't select database");

// Trim the incoming data.
$Array["LiteratureSKU"] = trim ($Array["LiteratureSKU"]);
$Array["LiteratureDescription"] = trim ($Array["LiteratureDescription"]);



$label_array = array ("LiteratureDescription" => "Literature Description");

//Loop through the values
foreach ($HTTP_POST_VARS as $key => $value)

//missing curly bracket

{

     
$query = "INSERT INTO tblLiteratureRequested
(LiteratureDescription) VALUES ('{$label_array["LiteratureDescription"]}')" ;

                             

$result = mysql_query($query)
     or die ("Couldn't execute query.");



}
//Close the loop
?>
  <!-- Close your list and html -->
</ul>
</body>
</html>


0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
andrivCommented:
On page two your form is not creating the array called $Array, so in the following line you are not trimming anything:

// Trim the incoming data.
$Array["LiteratureSKU"] = trim ($Array["LiteratureSKU"]);
$Array["LiteratureDescription"] = trim ($Array["LiteratureDescription"]);

Also, by using 'radio' buttons you are submitting only one value so you do not need to use a loop:

foreach ($HTTP_POST_VARS as $key => $value)

//missing curly bracket

{

Let me know if you want to allow multiple selections and I will give you code using checkboxes instead.

However you are creating a variable called $interest. As you have the form now you can use the following to add it to database:

First change File 1 to pass the Id numb:

  echo "<input type='radio' name='interest'  value='$LiteratureID'";


*********File2*************
<html>
<head>
<title>Add Pet</title>
</head>
<body>
Catalog:<br>
<ul>

<?php
 $user="ag";
 $host="localhost";
 $password="";
 $database = "netafimusa_com";

 $connection = mysql_connect($host,$user,$password)
      or die ("couldn't connect to server");
 $db = mysql_select_db($database,$connection)
      or die ("Couldn't select database");

//Get requested information
$Query = "Select * from tblLiterature where LiteratureID = $interest";

//Query DB or return error message
if(!($result = mysql_query($Query)))
{
echo mysql_error();
exit;
}

//Get values of result
$row = mysql_fetch_array($result);

//Get date, format and store in variable
$thedate = date("Y-d-m");

//Create query for Adding record to DB

//Note, I do not know what action represents so it is not being populated.

$query = "INSERT INTO tblLiteratureRequested
(LiteratureSKU,LiteratureDescription,Date ) VALUES ('" . $row['LiteratureSKU'] . "','" . $row['LiteratureDescription'] . "','$thedate')" ;

//Add to DB or print error and exit
if(!(mysql_query($query)))
{
echo mysql_error();
exit;
}

//Display conformation

echo row['LiteratureSKU'] . " " . $row['LiteratureDescription'] . " was added to DB on $thedate";
?>

</body>
</html>

Let me know what you want to do next.
0
 
aprillougheedAuthor Commented:
Yes, Andy -- Sorry I wanted to use Checkboxes for multiple select -- But I'll keep this first one as a reference.

0
 
aprillougheedAuthor Commented:
YOU ARE AMAZING!!!

Andy - the comments you put in your answer are so helpful.

You are the best expert I've ever worked with.

Anyway I can sing your praises with EE?

April
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now