|
|
Posted by Jerim79 on 11/08/06 14:42
Carl wrote:
> Jerim79 wrote:
> > I am no PHP programmer. At my current job I made it known that I was no
> > PHP programmer during the interview. Still they have given me a script
> > to write with the understanding that it will take me a while (This
> > information is just for general knowledge as I don't want anyone
> > thinking I am trying to be dishonest with my intentions. Also, I do not
> > portray myself as something I am not. I am a beginner.)
> >
> > Anyway, what the script needs to do is to take variables passed from an
> > HTML form and do two things. One is read it into a database. The other
> > is to send me an email with all of the customer's information.
> >
> > //Name of the script is test.php
> > <?php
> > //I am using this echo command to make sure that the variables where
> > passed correctly.
> > echo $_Post['FName']; //Never displays
> > //Here is where the script for the database connections starts
> > $username='username';
> > $password='password';
> > $hostname='localhost';
> > $databasename='database';
> > //Here is where the database connection is actually made
> > $conection = mysql_connect($hostname, $username, $password);
> > mysql_select_db($databasename) or die ("Cannot connect to
> > database");
> > //With the database connection open, I start to insert the data from
> > the HTML form.
> > $result = mysql_query("INSERT INTO table() VALUES($FName,
> > $LName, $Company, $Title, $Address, $Apt, $City, $State, $Zip, $Phone,
> > $Fax, $Email, $Var1, $Var2, $Var3, $Var4, $Var5)");
> > //After reading the information into the table, we close the database
> > connection
> > mysql_close();
> >8 Message Cut >8
>
> Hi Jerim,
>
> A couple of things;
> - $_Post is not the same as $_POST.
> - When a function returns a value (as is the case with mysql_query()),
> It is usually wise to check the value returned and make sure it is what
> you expected.
> - The mysql_error() function (http://php.net/mysql_error) is quite
> useful when debugging these sorts of problems.
>
> Hope that helps,
> Carl.
I tried out POST instead of Post. I even set the method to POST. It
still won't even display the top echo $_POST['FName'] so I don't think
the variables are getting passed.
However, I had a question about the mail script. I keep getting this
error:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE,
expecting T_STRING or T_VARIABLE or T_NUM_STRING in /(website)/test.php
on line 270
Line 270 is this:
$message = "First Name: $_POST['FName']";
I believe the problem is the way in which I am adding the variable
$_POST['FName] to the line. I saw this method used somewhere: "First
Name: \"$_POST['FName']\""; but it didn't seem to work for me. I
haven't been able to find anything on point.
[Back to original message]
|