php script, dreamweaver form

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
slade powers
Forum Newbie
Posts: 8
Joined: Sat Nov 20, 2010 2:46 pm

php script, dreamweaver form

Post by slade powers »

Hello,my name is carlton.
i have a html form i created in dreamweaver.
i have the accompanying .php script to forward
user details to the server. i fill in the form,
hit the submit button and nothing appears in
the babiesnmovies database table i created (named "register"). the testing server has been
successfully configured. the database "babiesnmovies"
is recognized by dreamweaver.
PLS tell me what i'm missing.

Thank you so much.


//this is the HTML registration web form i created in dreamweaver//


<legend>Parents Contact Information</legend>
</h3>
<form id="form1" name="form1" method="PUT" action="babiesnmovies.php">
<p>
<label for="babiesnmovies.com/register">Your First Name</label>
<input type="text" name="yourfirstname" id="babiesnmovies.com/register" />
<label for="babiesnmovies.com/registered">Your Last Name</label>
<input type="text" name="yourlastname" id="babiesnmovies.com/registered" />
</p>
<label for="babiesnmovies.com/yourname">Your Phone Number</label>
<input type="text" name="yourphonenumber" id="babiesnmovies.com/yourname" />
<label for="babiesnmovies.com/email">Your E-mail</label>
<input type="text" name="youremail" id="babiesnmovies.com/email" />
</p>
</form>
<p>&nbsp;</p>
<h3>
<legend>Baby's Vitals</legend>
</h3>
<form id="form2" name="form2" method="PUT" action="babiesnmovies.php">
<p>
<label for="babiesnmovies.com/baby'slast">Baby's First Name</label>
<input type="text" name="babysfirstname" id="babiesnmovies.com/baby'sfirst" />
<label for="babiesnmovies.com/babies">Baby's Middle Name</label>
<input type="text" name="babysmiddlename" id="babiesnmovies.com/babies" />
</p>
<p>
<label for="babyslastname">Baby's Last Name</label>
<input type="text" name="babyslastname" id="babyslastname" />
</p>
<p>
<label for="babiesnmovies.com/babybday">Baby's Birthdate</label>
<input type="text" name="babysbirthdate" id="babiesnmovies.com/babybday" />
<label for="babiesnmovies.com/babyage">Baby's Age</label>
<input type="text" name="babysage" id="babiesnmovies.com/babyage" />

</p>
<p>
<label for="babiesnmovies.com/baby">Baby's Height</label>
<input type="text" name="babysheight" id="babiesnmovies.com/baby" />
<label for="babiesnmovies.com/babyweight">Baby's Weight</label>
<input type="text" name="babysweight" id="babiesnmovies.com/babyweight" />
</p>
<p>
<label for="babiesnmovies.com/babyeyes">Baby's Eye Color</label>
<input type="text" name="babyseyecolor" id="babiesnmovies.com/babyeyes" />
<label for="babiesnmovies.com/babyhair">Baby's Hair Color</label>
<input type="text" name="babyshaircolor" id="babiesnmovies.com/babyhair" />
</p>
<p>
<label for="babiesnmovies.com/babyrace">Baby's Ethnicity</label>
<input type="text" name="babysethnicity" id="babiesnmovies.com/babyrace" />
</p>
<p><input name="formsubmit" type="submit" value="Submit" />

Code: Select all

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_babiesnmovies = "XXX";
$database_babiesnmovies = "XXX";
$username_babiesnmovies = "XXX";
$password_babiesnmovies = "XXX";
$babiesnmovies = mysql_pconnect($hostname_babiesnmovies, $username_babiesnmovies, $password_babiesnmovies) or trigger_error(mysql_error(),E_USER_ERROR); 


mysql_select_db("db337879506", $con);
		 $sql="INSERT INTO register (id, YourFirstName, YourLastName, YourPhoneNumber, YourEmailAddress, BabysFirstName, BabysMiddleName,
		 BabysLastName, BabysBirthdate, BabysAge, BabysHeight, BabysWeight, BabysEyeColor, BabysHairColor, BabysEthnicity) values ( 'NULL','$yourfirstname',                  '$yourlastname', '$yourphonenumber', 'youremailaddress', '$babysfirstname', '$babysmiddlename', '$babyslastname', '$babysbirthdate', '$babysage', '$babysheight', '$babysweight', '$babyseyecolor', '$babyshaircolor', '$babysethnicity')";



$yourfirstname = $_POST ['YourFirstName'];
$yourlastname = $_POST ['YourLastName'];
$yourphonenumber = $_POST ['YourPhoneNumber'];
$youremailaddress = $_POST ['YourE-mailAddress'];
$babysfirstname = $_POST ['BabysFirstName'];
$babysmiddlename = $_POST ['BabysMiddleName'];
$babyslastname = $_POST ['BabysLastName'];
$babysbirthdate = $_POST ['BabysBirthdate'];
$babysage = $_POST ['BabysAge'];
$babysheight = $_POST ['BabysHeight'];
$babysweight = $_POST ['BabysWeight'];
$babyseyecolor = $_POST ['BabysEyeColor'];
$babyshaircolor = $_POST ['BabysHairColor'];
$babysethicity = $_POST ['Babys Ethnicity'];

?>
Neilos
Forum Contributor
Posts: 179
Joined: Fri Nov 19, 2010 2:07 am

Re: php script, dreamweaver form

Post by Neilos »

try

Code: Select all

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_babiesnmovies = "XXX";
$database_babiesnmovies = "XXX";
$username_babiesnmovies = "XXX";
$password_babiesnmovies = "XXX";
$babiesnmovies = mysql_pconnect($hostname_babiesnmovies, $username_babiesnmovies, $password_babiesnmovies) or trigger_error(mysql_error(),E_USER_ERROR); 

$yourfirstname = $_POST ['YourFirstName'];
$yourlastname = $_POST ['YourLastName'];
$yourphonenumber = $_POST ['YourPhoneNumber'];
$youremailaddress = $_POST ['YourE-mailAddress'];
$babysfirstname = $_POST ['BabysFirstName'];
$babysmiddlename = $_POST ['BabysMiddleName'];
$babyslastname = $_POST ['BabysLastName'];
$babysbirthdate = $_POST ['BabysBirthdate'];
$babysage = $_POST ['BabysAge'];
$babysheight = $_POST ['BabysHeight'];
$babysweight = $_POST ['BabysWeight'];
$babyseyecolor = $_POST ['BabysEyeColor'];
$babyshaircolor = $_POST ['BabysHairColor'];
$babysethicity = $_POST ['Babys Ethnicity'];

mysql_select_db("db337879506", $con);
                 $sql="INSERT INTO register (id, YourFirstName, YourLastName, YourPhoneNumber, YourEmailAddress, BabysFirstName, BabysMiddleName,
                 BabysLastName, BabysBirthdate, BabysAge, BabysHeight, BabysWeight, BabysEyeColor, BabysHairColor, BabysEthnicity) values ( 'NULL','$yourfirstname',                  '$yourlastname', '$yourphonenumber', 'youremailaddress', '$babysfirstname', '$babysmiddlename', '$babyslastname', '$babysbirthdate', '$babysage', '$babysheight', '$babysweight', '$babyseyecolor', '$babyshaircolor', '$babysethnicity')";

?>
Neilos
Forum Contributor
Posts: 179
Joined: Fri Nov 19, 2010 2:07 am

Re: php script, dreamweaver form

Post by Neilos »

You should also protect against SQL injections.

Escape the strings that you are inputting into the database.
http://php.net/manual/en/function.mysql ... string.php
Post Reply