need help with form and php stuff

**navaldesign** · 06-12-2007, 06:05 AM

Re: need help with form and php stuff

Exactly. "Flags" are just pointers set to "True" or "False" (or, which is the same, "1" or "O", "Sent" or "Not Sent", anything that indicates the fullfilment of a condition or not.

**horus** · 06-26-2007, 04:23 AM

Re: need help with form and php stuff

Hey, it's me again. I'm having challenges with making my code submit user input into the DB. I know that the insertion takes place in the function addNewUser() , but for some strange reason, after it tests the input (checkboxes) and echoes the proper response, I call the function and it refreshes the page, but does not submit the input fields to the DB.

Here's the code:

<?
session_start();
include("database.php");
$date = date("Y/m/d");

//see if name already exists in database
function Name_Exists($Name){
global $conn;
if(!get_magic_quotes_gpc()){
$Name = addslashes($Name);
}
$q = "select Name from members where Name = '$Name'";
$result = mysql_query($q,$conn);
return (mysql_numrows($result) > 0);
}

/**
* Inserts the given
* into the database. Returns true on success,
* false otherwise.
*/
function addNewUser($Name, $Phone, $Email, $State, $City, $Address, $Address2, $Referredby, $date){
global $conn;
$q = "INSERT INTO members VALUES ('$Name', '$Phone', '$Email' , '$State' , '$City' , '$Address' , '$Address2' , '$Referredby', '$date')";
return mysql_query($q,$conn);
}

/**
* Determines whether or not to show to sign-up form
* based on whether the form has been submitted, if it
* has, check the database for consistency and create
* the new account.
*/
if(isset($_POST['submit'])){
/* Make sure all fields were entered */
if(!$_POST['name'] || !$_POST['phone'] || !$_POST['email'] || !$_POST['state'] || !$_POST['city'] || !$_POST['address']){
die('You didn\'t fill in a required field.');
}

/* Spruce up username, check length */
$_POST['name'] = trim($_POST['name']);
$_POST['phone'] = trim($_POST['phone']);
$_POST['email'] = trim($_POST['email']);
$_POST['state'] = trim($_POST['state']);
$_POST['city'] = trim($_POST['city']);
$_POST['address'] = trim($_POST['address']);
$_POST['address2'] = trim($_POST['address2']);
$_POST['referredby'] = trim($_POST['referredby']);

if(Name_Exists($_POST['name'])){
$use = $_POST['name'];
die("Sorry, the name: $use already exists in our records.");
}

$OK = 0;
if(!$_POST['over_18'] || !$_POST['incomesource'] || !$_POST['checkingaccount'] || !$_POST['savingsaccount'] || !$_POST['legalservices'] || !$_POST['idt'] || !$_POST['compaccess'] || !$_POST['inetaccess'] || !$_POST['refer'] || !$_POST['oneyear'] || !$_POST['lessons'] || !$_POST['iagree']){
echo " 
 
 
<img src='coach2 update copy.jpg' align='top' border='0' width='71' height='88' style='position:absolute;left:20px;top:3px;width:7 1px;height:88px;z-index:'>
<div style='position:absolute;left:110px;top:12px;width :324px;height:55px;z-index:' align='left'>
CreditCoach™</div>
<div style='position:absolute;left:64px;top:56px;width: 409px;height:33px;z-index:' align='center'>
We help you reach financial success</div>";
$OK = 1;
}
else{
echo " 
 
 
<img src='coach2 update copy.jpg' align='top' border='0' width='71' height='88' style='position:absolute;left:20px;top:3px;width:7 1px;height:88px;z-index:'>
<div style='position:absolute;left:110px;top:12px;width :324px;height:55px;z-index:' align='left'>
CreditCoach™</div>
<div style='position:absolute;left:64px;top:56px;width: 409px;height:33px;z-index:' align='center'>
We help you reach financial success</div>
 
<a href='http://www.youronlinecreditcoach.com/register.php'>
Continue</a>  ";
$OK = 1;
}
if(!$_POST['over_18']){
echo " 
You must be a legal adult, over 18, to participate in our
programs. 
Please reapply when you are of legal age, 18 and over.";
}
if(!$_POST['incomesource']){
echo " 
You must be currently employed or have a reliable
source of income to participate in our programs. 
In order to maintain good financial health, you must have an income that will
enable you to keep up with your 
financial obligations.";
}
if(!$_POST['checkingaccount']){
echo "You must have an active checking account to
participate in our programs. When dealing with lenders, 
you must be able to prove that you can effectively handle your finances. A
checking account shows financial stability. You can open a free checking account with $20 or
less at Washington Mutual Bank. 
 ";
}
if(!$_POST['savingsaccount']){
echo "You must have an open savings account to
participate in our programs. 
A large part of our program is tailored towards strategic saving techniques.";
}
if(!$_POST['legalservices']){
echo "You must have a legal services plan to
participate in our programs. 
Because these programs deal with using your legal rights, it is very 
important to have your own attorney by your side.";
}
if(!$_POST['idt']){
echo "You must have an identity theft protection plan
to participate in our 
programs. It is important to have protection in place for your credit as 
well as your financial identity, as you go through this process.";
}

if(!$_POST['compaccess'] || !$_POST['inetaccess']){
echo "You must have access to a computer with internet
access to participate in 
our programs. These programs are website-based and require access to the
internet. 
Your local library may provide free computer usage for it�s members.";
}
if(!$_POST['refer']){
echo "In order to participate in these programs you
must agree to refer at least 3 
people into the program that also become members. The programs are FREE because
 
the CreditCoach� Team wants to help as many people as possible and we want our
 
participants to want to help others as well.";
}
if(!$_POST['oneyear']){
echo "Each member must commit to a one (1) year
membership in order to 
participate in our programs. The CreditCoach� system is made up of 
three distinct programs, which take some time to complete. This program 
may not be the right fit for those who want a quick fix. It is designed to 
assist those who are willing to make a commitment to developing a healthy
financial future.";
}
if(!$_POST['lessons']){
echo "In order to participate in these programs you
must commit to doing the 
tutorials, lessons and projects required. This program is designed to 
assist others, but only if they are willing to help themselves. If you 
are unwilling to do the work, this program is not for you.";
}
if(!$_POST['iagree']){
echo "You must agree to the terms and conditions to become a member.";
}

//Continue to registration
if((!$_POST['checkingaccount'] || !$_POST['savingsaccount'] || !$_POST['legalservices'] || !$_POST['idt'] || !$_POST['compaccess'] || !$_POST['inetaccess']) && ($_POST['over_18'] && $_POST['incomesource'] && $_POST['refer'] && $_POST['oneyear'] && $_POST['lessons'])){
echo "
<a href='http://www.youronlinecreditcoach.com/register.php'>
Continue</a>  ";
}
/* Add the new account to the database */

$_SESSION['reguname'] = $_POST['name'];
$_SESSION['regresult'] = addNewUser($_POST['name'], $_POST['phone'], $_POST['email'], $_POST['state'], $_POST['city'], $_POST['address'], $_POST['address2'], $_POST['referredby'], $date);
$_SESSION['registered'] = true;
echo "<meta http-equiv=\"Refresh\" url=$HTTP_SERVER_VARS[PHP_SELF]\">";
return;
}
?>

Thanx for your assistance. :)

**navaldesign** · 06-26-2007, 07:37 AM

Re: need help with form and php stuff

Which one is the form that submits to this script ? check field names to see if there is a problem with field naming.

**horus** · 06-26-2007, 04:56 PM

Re: need help with form and php stuff

The problem is not in the field names. All field names are correct.
Here's the link to the form.

404 Not Found

http://www.youronlinecreditcoach.com/QualifyingQuestionnaire2.php

It echoes the message, but does not submit.

**virize** · 11-20-2007, 09:21 AM

Re: need help with form and php stuff

Originally posted by horus View Post

The problem is not in the field names. All field names are correct.
Here's the link to the form.

404 Not Found

http://www.youronlinecreditcoach.com/QualifyingQuestionnaire2.php

It echoes the message, but does not submit.

hey horus!

i visited your site to check out what you were talking about. im currently building mine, however, im stuck on how to have a login page. Or better yet, i'd like to know how to create a form in which the only way they can get in is by a designated user/pass.

i noticed you have a member login page. can you please assist me in the process of creating one? thanks!

**navaldesign** · 11-20-2007, 09:38 AM

Re: need help with form and php stuff

A member login script is not easy to explain how to create. It requires at least 3 - 4 pages (Login, Register, Edit Profile, Forgot Password, confirmation pages, error pages, activation page, etc) , 3 - 4 backed scripts (the scripts that will validate and process all the user input during registration or login or editing profile or requiring forgotten details etc) as well as a Database interface for the site Administrator to be able to manage the users. Unless you have php/mysql coding experience, i would say that it is practically impossible to do this in a short (short = some days) time.

So you actually have two options: either find a script on the net (free or paid for) OR have one made for you. It really depends on what your needs for customization are.

Have a look at http://www.dbtechnosystems.com/logginexamples.php for a login script demo

**carpedeim** · 12-11-2007, 05:54 PM

Re: need help with form and php stuff

Hi I need help too I have constructed my form watched the tutorials more than twice - but when I come to cut and paste the php code in page html its not there - any idea what I am doing wrong?

thanks

**navaldesign** · 12-11-2007, 06:05 PM

Re: need help with form and php stuff

The code is in the Tutorial. Scroll down the tutorial, under the video, and you will find step by step instructions. Also you will find the necessary code. Copy it from there, edit it, and paste it in your page.

That's all.

**carpedeim** · 12-12-2007, 01:15 PM

Re: need help with form and php stuff

Thanks for this I will give that a try - as a complete novice its great to get this sort of support

many thanks again

need help with form and php stuff

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment