umm question on php forms [Archive]

View Full Version : umm question on php forms

Jouninshinobi

08-26-2004, 11:51 AM

how can I creat a form in php that sends the information straight to a MySQL table I've created and sends a displays a message or confirmation email

thx,

stormraven

08-26-2004, 12:12 PM

Here's some references if you want to do it yourself..

PHP Communicating to mySQL:

http://us2.php.net/manual/en/ref.mysql.php

PHP Mail() function:

http://us2.php.net/manual/en/ref.mail.php

You could probably hire someone to do it cheap as well..

Crimson54

08-26-2004, 12:31 PM

Form:

<script LANGUAGE="JavaScript">

</script>

<style>
BODY
{
scrollbar-base-color: 313233;
scrollbar-arrow-color: 313233;
scrollbar-face-color: 000000;
scrollbar-track-color: 000000;
scrollbar-shadow-color: 313233;
scrollbar-highlight-color: 313233;
scrollbar-dark-shadow-color: 313233;
scrollbar-3d-light-color: 313233;
}
</style>
</head>

<body bgcolor="#000000" text="#FFFFFF" link="#FFCC00" vlink="#FFCC00" alink="#FFFFFF"
topmargin="4">

<form method="post" name="mainform" action="register.php"
onSubmit="return ValidateForm();">
<table border="0" cellspacing="0" width="510" cellpadding="3">
<tr>
<td nowrap><font color="#C0C0C0"><b><font face="Arial, Helvetica, sans-serif"><font
size="2">Username</font></font><font size="2" face="Arial, Helvetica, sans-serif">:</font></b>
</font></td>
<td colspan="1" nowrap><font color="#C0C0C0"><input type="text" name="user_alias"
size="20" maxlength="20"
style="font-weight: bold; background-color: rgb(0,0,0); color: rgb(192,192,192)"> <font
size="2">*</font> </font></td>
<td colspan="2" rownspan="2" nowrap><div align="left"><p><font color="#C0C0C0">Fields
marked * are required.</font></td>
</tr>
<tr>
<td nowrap><font color="#C0C0C0"><font size="2" face="Arial, Helvetica, sans-serif"><b>First
Name:</b></font> </font></td>
<td colspan="1"><font color="#C0C0C0"><input type="text" name="user_firstname" size="20"
maxlength="20"
style="background-color: rgb(0,0,0); color: rgb(192,192,192); font-weight: bold"> <font
size="2">*</font> </font></td>
<td colspan="2" rowspan="5" valign="middle"><font size="2" face="Arial,Helvetica"><font
color="#C0C0C0"><br>
You will receive a verification email to validate your account. We don't sell email
addresses or send SPAM.</font><p></font> </td>
</tr>
<tr>
<td nowrap><font color="#C0C0C0"><font size="2" face="Arial, Helvetica, sans-serif"><b>Last
Name:</b></font> </font></td>
<td colspan="3"><font color="#C0C0C0"><input type="text" name="user_lastname" size="20"
maxlength="20"
style="background-color: rgb(0,0,0); color: rgb(192,192,192); font-weight: bold"> <font
size="2">*</font> </font></td>
</tr>
<tr>
<td><font color="#C0C0C0"><font size="2" face="Arial, Helvetica, sans-serif"><b>Password:</b></font>
</font></td>
<td colspan="3"><font color="#C0C0C0"><input type="password" name="user_password"
size="19" maxlength="10"
style="background-color: rgb(0,0,0); color: rgb(192,192,192); font-weight: bolder"> <font
size="2">*</font> </font></td>
</tr>
<tr>
<td valign="top"><font color="#C0C0C0"><font size="2" face="Arial, Helvetica, sans-serif"><b>E-mail:</b></font>
</font></td>
<td colspan="1" nowrap><font color="#C0C0C0"><input type="text" name="user_email"
size="20" maxlength="50"
style="background-color: rgb(0,0,0); color: rgb(192,192,192); font-weight: bolder"> <font
size="2">*</font> </font></td>
</tr>
<tr>
<td valign="top" nowrap><font color="#C0C0C0"><font size="2"
face="Arial, Helvetica, sans-serif"><b>Confirm E-mail:</b></font> </font></td>
<td colspan="1" nowrap><font color="#C0C0C0"><input type="text" name="user_email2"
size="20" maxlength="50"
style="background-color: rgb(0,0,0); color: rgb(192,192,192); font-weight: bolder"> <font
size="2">*</font> </font></td>
</tr>
<tr>
<td></td>
<td colspan="3"><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="middle"><input type="checkbox" name="user_email_visible" CHECKED value="ON"
style="background-color: rgb(0,0,0); color: rgb(192,192,192); font-weight: bold"> </td>
<td>  </td>
<td><font size="1" face="Arial, Helvetica, sans-serif">E-mail Visible to Users</font> </td>
<td>  </td>
</tr>

</table>
</td>
</tr>

<tr>
<td><font size="2" face="Arial, Helvetica, sans-serif">Gender:</font> </td>
<td><select name="user_gender" size="1"
style="background-color: rgb(0,0,0); color: rgb(192,192,192); font-weight: bolder">
<option value="null">Select</option>
<option value="m">Male</option>
<option value="f">Female</option>
</select> </td>
</tr>

<tr>
<td colspan="4"></td>
</tr>
<tr>
<td colspan="1"></td>
<td colspan="2" valign="top"><input type="submit" name="Submit" value="Submit Information"
style="background-color: rgb(0,0,0); color: rgb(192,192,192); font-weight: bold"><br>
</td>
<td colspan="1" nowrap><font face="Arial, Helvetica, sans-serif" size="1" color="#C0C0C0"><strong>Please
press "submit" ONCE and wait</strong>.</font> </td>
</tr>
</table>
</form>

PHP:

<?
//replace username and password with your mysql name and password
$conn = mysql_connect("localhost","database_db","123");

//select the database
$db = mysql_select_db("database_home");

$username = $_POST["user_alias"];
$password = $_POST["user_password"];
$fname = $_POST["user_firstname"];
$lname = $_POST["user_lastname"];
$email = $_POST["user_email"];
$gender = $_POST["user_gender"];
$age = $_POST["user_age"];

//insert the values
$result= MYSQL_QUERY("INSERT INTO Users (id, username, fname, lname, password, email, gender, age)".
"VALUES ('NULL', '$username', '$fname', '$lname', '$password', '$email', '$gender', '$age')");

echo "Your name and password have been submitted into our database :)";
?>

need anymore help then pm me

armstrongecom

08-27-2004, 10:04 AM

Here's what I often use, but you have to make the form's field names exactly the same as your mysql table field names (ie case sensitive)....

<?

//set tablename to be inserted
$tablename = "users";

//list table fieldnames that do NOT require '' delimiters (ie numbers)
$no_delim_array = array("users_ID");

//collect info from form for inserting and mailing

$insertKeys = "";
$insertValues = "";
$mailinfo = "";

for(reset($HTTP_POST_VARS); $key = key($HTTP_POST_VARS); next($HTTP_POST_VARS))
{

$postValues[$key] = trim($HTTP_POST_VARS[$key]);

$mailinfo .= "$key = $postValues[$key] \n";

if (in_array($key, $no_delim_array)) {

if ($postValues[$key] != "")
{
$insertKeys .= "$key, ";
$insertValues .= "$postValues[$key], ";
}
}
else
{
$insertKeys .= "$key, ";
$insertValues .= "'$postValues[$key]', ";
}

}

//trim and set sql insert statement
$insertKeys = substr($insertKeys, 0, strlen($insertKeys)-2);
$insertValues = substr($insertValues, 0, strlen($insertValues)-2);

$insertQuery = "INSERT INTO $tablename ($insertKeys) VALUES ($insertValues)";

//insert info into db

//connect to db server
require("./inc/conn.inc");

$cResult = mysql_query($insertQuery, $dbLink);

//close connection
mysql_close($dbLink);

//EMAIL NOTIFICATION
//SET THESE MAIL VARs
$from = "\"From Name\" <fromaddr@domain.com>\n";

$subject = "New User Profile";

$body = "\nA new User has been submitted to the database.\n_____________________________________ \n\nThe following is a copy of the User Profile data that was submitted...\n\n".$mailinfo." \n";

$to = "<toaddr@domain.com>";

//ok mail it
mail($to, $subject, $body, $from);

?>

-Allen

Jouninshinobi

08-28-2004, 08:09 AM

I don't exactly understand this. I'm goin to insert my questions straight into the code. I you can answer any plz do.

<?

//set tablename to be inserted
//This is where my datatbase name goes right?
$tablename = "users";

//list table fieldnames that do NOT require '' delimiters (ie numbers)
//I don't understand this one at all and what are delimiters?
$no_delim_array = array("users_ID");

//collect info from form for inserting and mailing
//adding keys? adding values? and what is mail info?

$insertKeys = "";
$insertValues = "";
$mailinfo = "";

for(reset($HTTP_POST_VARS); $key = key($HTTP_POST_VARS); next($HTTP_POST_VARS))
{

$postValues[$key] = trim($HTTP_POST_VARS[$key]);

$mailinfo .= "$key = $postValues[$key] \n";

if (in_array($key, $no_delim_array)) {

if ($postValues[$key] != "")
{
$insertKeys .= "$key, ";
$insertValues .= "$postValues[$key], ";
}
}
else
{
$insertKeys .= "$key, ";
$insertValues .= "'$postValues[$key]', ";
}

}

//trim and set sql insert statement
$insertKeys = substr($insertKeys, 0, strlen($insertKeys)-2);
$insertValues = substr($insertValues, 0, strlen($insertValues)-2);

$insertQuery = "INSERT INTO $tablename ($insertKeys) VALUES ($insertValues)";

//insert info into db
//what information do I need to put in, so the database connects

//connect to db server
require("./inc/conn.inc");

$cResult = mysql_query($insertQuery, $dbLink);

//close connection
mysql_close($dbLink);
?>

armstrongecom

08-28-2004, 04:30 PM

First create a form that contains any or all of the fields from your mysql table, and be sure that the names of the form's fields match the names of your mysql table fields exactly.

Now use method="POST" and point the ACTION= statement to the code below on a separate page. This code will dynamically build an INSERT statement and insert the form's values into your table.

There are only four things you need to add to this code, and I've modified the original code and placed them in comments at the top so you can make the changes more easily. Look for them in the code below numbered 1 through 4, and let me know if you have any questions.

-Allen

<?

// 1) insert your database name here //
$dbName = "database";

// 2) insert your tablename here //
$tablename = "users";

// 3) insert your username and password for the DB //
$dbUsername = "username";
$dbPassword = "password";

// 4) modify this array so it contains any and all field //
//names that have a data type where the values //
//don't need to be surrounded by single-quotation //
//marks when they're inserted using a SQL statement //
//(usually number data types) //
$no_delim_array = array("users_ID", "other_ID");

// From this point on, this code doesn't need modification //
// However, if you use the mail function I included in the original //
// posting, you'd need to modify some of those variables too //

$insertKeys = "";
$insertValues = "";
$mailinfo = "";

for(reset($HTTP_POST_VARS); $key = key($HTTP_POST_VARS); next($HTTP_POST_VARS))
{

$postValues[$key] = trim($HTTP_POST_VARS[$key]);

$mailinfo .= "$key = $postValues[$key] \n";

if (in_array($key, $no_delim_array)) {

if ($postValues[$key] != "")
{
$insertKeys .= "$key, ";
$insertValues .= "$postValues[$key], ";
}
}
else
{
$insertKeys .= "$key, ";
$insertValues .= "'$postValues[$key]', ";
}

}

//trim and set sql insert statement
$insertKeys = substr($insertKeys, 0, strlen($insertKeys)-2);
$insertValues = substr($insertValues, 0, strlen($insertValues)-2);

$insertQuery = "INSERT INTO $tablename ($insertKeys) VALUES ($insertValues)";

$dbLink = mysql_connect("localhost", "$dbUsername", "$dbPassword");
mysql_select_db("$dbName", $dbLink);

$cResult = mysql_query($insertQuery, $dbLink);

//close connection
mysql_close($dbLink);
?>

Jouninshinobi

08-28-2004, 05:40 PM

ok I think I understand it now. BUt now that I have the users information in the MySQL database table, how can I get it out to post on the page and use for various other activities?

Thx alot + sorry if my questions seem pointless

armstrongecom

08-28-2004, 06:18 PM

To get the data back out again, you can use PHP to execute a SELECT query to select the user information you want, and then print it out on the page. However, creating pages like this on a custom basis is not a straight forward process, and usually requires a developer.

Depending on what you're trying to do with your website, you might want to explore some of the pre-packaged PHP scripts that use mySQL as a database backend. There are hundreds of them available for the most common applications, and many are free.

I suggest you check out a site such as http://www.hotscripts.com to see what's available for your needs before you try to custom code something from scratch.

Good luck... -Allen