[RESOLVED] Insert Form Data

gearbolt

I am not sure if I am doing this correctly. I have a form page called "index.php" which contains data that should be inserted into a MYSQL DB. When the user hits the submit button I want the "index.php" page call a function located in another php file called "manage_advert.php". Thanks

File - manage_advert.php

function insert_new_advertiser($advcontname,$advcompname,$advaddr,$advzip,$advstate,$advbilladdr,$advuname,$advpword)

{
$query - "INSERT INTO tbl_advertisers (advertisers_contact_name,advertisers_company_name,advertisers_address,advertisers_zipcode,
									   advertisers_state,advertisers_billing_address,advertisers_login_name,advertisers_password) VALUES
									   ($advcontname,$advcompname,$advaddr,$advzip,$advstate,
									   $advbilladdr,$advuname,$advpword)";

								   $result = @mysql_query ($query);
								   mysql_close();

}

File - index.php

<?php

?>

<html>
<head>

<title></title>
</head>
<body>
<form id="form1" name="form1" form action="" method="post">

<label>Contact Name</label><input name="advertisers_contact_name" type="text" size="50" maxlength="50" /><br>
<label>Company name</label><input name="Company Name" type="text" size="60" maxlength="60" /><br>
<label>Address</label><input name="Address" type="text" size="60" maxlength="60" /><br>
<label>Zipcode</label><input name="Zipcode" type="text" size="5" maxlength="5" /><br>
<label>State</label><input name="State" type="text" size="2" maxlength="2" /><br>
<label>Billing Address</label><input name="Billing Address" type="text" size="60" maxlength="60" /><br>
<label>Login Name</label><input name="Login Name" type="text" size="15" maxlength="15" /><br>
<label>Password</label><input name="Password" type="password" size="15" maxlength="15" /><br>

<input name="Submit" type="submit" value="Submit!" />

</form>

</body>
</html>

bpat1434

In your php section (above the form) put this:

<?php

if(isset($_POST['submit']) && $_POST['submit'] == 'Submit!')
{
  include('manage_advert.php');
  insert_new_advertiser($_POST['advertisers_contact_name']); // execute the function
}
else
{
?>
<!-- Show the HTML form -->
<?php
}
?>

One thing I'd suggest is some feedback from your function. Don't just run the query, give some feedback so you can debug errors and what not. Return TRUE or FALSE depending upon the insert, or what not... Do something, otherwise you're in for a headache later when something does go wrong.

~Brett

gearbolt

I could not get thisto work. After looking at my code I think I should rewrite it a make it a class module. Any ideas

bpat1434

What problems did you run into? If you can't get the basic function to work, a class is much more intricate and harder to work than a basic function.

Here's something that should work based upon your scenario:
index.php

<?php
// This should post back to itself
?>
<html>
<head>
<title></title>
</head>
<body>

<?php
if(@isset($_POST['submit']) && @$_POST['submit'] == 'Submit!')
{
  // Include the file, and run the function:
  include_once('manage_advert.php');
  if(insert_new_advertiser($_POST['advertisers_contact_name'], $_POST['Company_Name'], $_POST['Address'], $_POST['Zipcode'], $_POST['State'], $_POST['Billing_Address'], $_POST['Login_Name'], $_POST['Password']) == TRUE)
  {
    echo 'Successfully Added!!';
  }
  else
  {
    echo 'There was an error inserting your company into the database.';
  }
}
else
{
?>

<form id="form1" name="form1" form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<label>Contact Name</label><input name="advertisers_contact_name" type="text" size="50" maxlength="50" /><br>
<label>Company name</label><input name="Company_Name" type="text" size="60" maxlength="60" /><br>
<label>Address</label><input name="Address" type="text" size="60" maxlength="60" /><br>
<label>Zipcode</label><input name="Zipcode" type="text" size="5" maxlength="5" /><br>
<label>State</label><input name="State" type="text" size="2" maxlength="2" /><br>
<label>Billing Address</label><input name="Billing_Address" type="text" size="60" maxlength="60" /><br>
<label>Login Name</label><input name="Login_Name" type="text" size="15" maxlength="15" /><br>
<label>Password</label><input name="Password" type="password" size="15" maxlength="15" /><br>

<input name="Submit" type="submit" value="Submit!" />

</form>
<?
}
?>

</body>
</html>

manage_advert.php

insert_new_advertiser($advcontname,$advcompname,$advaddr,$advzip,$advstate,$advbilladdr,$advuname,$advpword)
{
  $query = "INSERT INTO tbl_advertisers (advertisers_contact_name,
  advertisers_company_name,
  advertisers_address,
  advertisers_zipcode,
  advertisers_state,
  advertisers_billing_address,
  advertisers_login_name,
  advertisers_password) 
  VALUES ('$advcontname',
  '$advcompname',
  '$advaddr',
  '$advzip',
  '$advstate',
  '$advbilladdr',
  '$advuname',
  '$advpword')";

  $result = @mysql_query($query);
  if(mysql_affected_rows($result) > 0)
  {
    mysql_close();
    return TRUE;
  }
  else
  {
    mysql_close();
    return FALSE;
  }
}

~Brett

gearbolt

Finally got this to work. Thanks