Solved

retrieve for data

Posted on 2006-06-17
2
258 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.   (CODE) (CODE) Then you just need to pass your date to the function. If i…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

803 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