Solved

retrieve for data

Posted on 2006-06-17
2
248 Views
Last Modified: 2008-03-04
Hi Experts

The below code takes the results of a form and saves it to a mysql database. Im pretty new to PHP and have used tutorials to create the below code. Save to mysql works fine but when I try to constuct a sting it fails on line 30

$part2 = echo $_POST["firstname"];

Im trying to retrieve the fistname field of the form.

Hows do I do this please.

Many Thanks

Lee


<?php
$con = mysql_connect("localhost","web17-ebayorder","testtest");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("web17-ebayorder", $con);

$sql="INSERT INTO test
(firstname,lastname,address_line_1,address_line_2,town,county,postcode,domain_name,email,code)
VALUES
('$_POST[firstname]','$_POST[lastname]','$_POST[address_line_1]','$_POST[address_line_2]','$_POST[town]','$_POST[county]','$_POST[postcode]','$_POST[domain_name]','$_POST[email]','$_POST[code]')";

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

//echo "Success!";
?>

<frameset rows="*,300" frameborder="no" border="0" framespacing="0">
  <frame src="http://www.internetrunner.com" name="mainFrame" id="mainFrame" title="mainFrame" />
 
  <frame src=
<?PHP  

$part1 = "https://customer.heartinternet.co.uk/addpack.cgi?authcode=58499-raYeewU%2B9X;email="
$part2 = echo $_POST["firstname"];
$part3 = ";M_domain="
$part4 = echo $_POST["domain_name"];
$part5 = ";M_typeid=12345;status=Y";
echo $part1 $part2 $part3 $part4 $part5
?>
  name="bottomFrame" scrolling="No" noresize="noresize" id="bottomFrame" title="bottomFrame" />

</frameset><noframes></noframes>
0
Comment
Question by:ljhodgett
  • 2
2 Comments
 
LVL 49

Expert Comment

by:Roonaan
ID: 16927423
You can use $part2 = $_POST['firstname'];

-r-
0
 
LVL 49

Accepted Solution

by:
Roonaan earned 125 total points
ID: 16927428
Same for $part4

Then change your echo $part1 $part2 $part4 $part5 either to:

echo htmlspecialchars("$part1 $part2 $part3 $part4 $part5");
or
echo htmlspecialchars($part1.$part2.$part3.$part4.$part5);

-r-

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now