PHP - One Form For Inserts And Updates

Hi all.

Im trying to insert from one form 3 items of data into to different tables.  I will post the code as most of my notes are in there but first.......

What is happening is the form is filled in then the first part of the form where it updates my clubs table with category ID's works fine. Nothing in the
if ($result) {   }
seems to run.
I have create some fake groups so the drop down is populated with groups already created and I have tried to select one of these groups so it can be entered into the clubs table and nothing.  No errors just no answers.  Does anybody no what I am doing wrong?


first Ill post the form and the querys that make fields in the form... 

Querys

//gets
$validation = $_GET['new_club'];
//Querys
    $qGetClub = "SELECT * FROM clubs WHERE validationID = '$validation'"; 
$rGetClub = mysql_query($qGetClub);
$Club = mysql_fetch_array($rGetClub);
//Query for category by name
$qGetCat = "SELECT * FROM club_category WHERE catID = ".$Club['cat']."";
$rGetCat = mysql_query($qGetCat);
$CatName = mysql_fetch_array($rGetCat);
//query for related sub categorys.
$qGetSub = "SELECT * FROM sub_categorys WHERE catID =".$Club['cat']."";
$rSubCat = mysql_query($qGetSub);
// query for groups created
$Groupq = mysql_query("SELECT * FROM groups WHERE memberID = '".$User['memberID']."'");



  then we have the form


<form action="" method="post"  id="insert_clubfrm">
  
                        <tr valign="baseline">
                                <td colspan="2"  valign="top"><br/><p>Your Chosen category was <strong><?php echo $CatName['categorys'];?></strong> Please select a sub category.</p><br></td>
                              </tr>
                              
                              <tr valign="baseline">
                                <td width="132"  valign="top" >Club Sub Category:</td>
                                <td width="256"  valign="top"  ><select name='subcat'>
                            <option value="None">Please Select One</option>
<?php while ($New_SubCat = mysql_fetch_assoc($rSubCat)) { ?>

                                <option value="<?php echo $New_SubCat['subID']; ?>"><?php echo $New_SubCat['sub_categorys']; ?></option>"<?php  }  ?>

</select>
  </td>
                              </tr>
                              <tr valign="baseline">
                                 <td colspan="2"  valign="top" ><br/><p>If your sub category does not exist in the list please select "none" above and enter your new sub categroy below.</p><br></td>
                              </tr>
                              <tr valign="baseline">
                                <td  valign="top" class="left_padding">New Sub Category</td>
                                <td valign="top" class="left_padding"><input type="text" name="newSubCat" id="new_cat" value="" /></td>
                              </tr>
                              <tr valign="baseline">
                                <td colspan="2"  valign="top" class="left_padding"><br/>
                                 If you had/have more than one site and you had to give your group of companies a name what would that name be?
                                <br/></td>
                              </tr>
                              <tr valign="baseline">
                                <td  valign="top" class="left_padding">Group Name:</td>
                                <td  valign="top" class="left_padding"><label for="other_groups"></label>
                                  <select name="other_groups" id="other_groups">
                                  <option>None</option>
                                  <?php while ($group = mysql_fetch_assoc($Groupq)) { ?>
                                    <option value="<?php echo $group['groupID']; ?>"><?php echo $group['group']; ?></option>"<?php  }  ?>  
                                </select></td>
                              </tr>
                              <tr valign="baseline">
                                <td  valign="top" class="left_padding">Group Name:</td>
                                <td  valign="top" class="left_padding"><label for="new_groups"></label>
                                 <input type="text" name="new_group" value="">

  
</td>
                              </tr>
                                                        <tr valign="baseline">
                                <td valign="top" nowrap="nowrap">&nbsp;</td>
                                <td valign="top"><div align="left">
                                  <input type="submit" id="insert_clubbtn1" name="insert_clubbtn1" value="Insert record" />
                                </div></td>
                              </tr>
                            </table>
                            </form>






now the code to make the form work...



if(isset($_POST['insert_clubbtn1'])){ 
//Process data for validation     
$subcat     = trim($_POST['subcat']);  
$NewSubCat = trim($_POST['NewSubCat']); 

$otherg = trim($_POST['other_groups']);
$newg = trim($_POST['new_groups']);     
//Prepare data for db insertion      
$newg = mysql_real_escape_string($newg);  
$subcat = mysql_real_escape_string($subcat); 
//find the new category 
//insert
$result = mysql_query("UPDATE clubs  SET 
`sub_category` = '$subcat'
WHERE validationID ='$validation'") or die(mysql_error());
if ($result) {
//if an item other than none from the list is selected then update the club with an ID relating to the group it belongs to
if ($otherg !=='None') { $groupsq = mysql_query("UPDATE `clubs` SET groupID ='$otherg' WHERE validationID ='$validation')") or die (mysql_error()); }
// If none is selected then $newg must have a value so create a new group in the groups table and then on the next page I will add the group in the club table 
if ($otherg == 'None') {
$groupsq = mysql_query("INSERT INTO `groups` (memberID, group, clubID) VALUES ('".$User['memberID']."', '$newg', ''".$Club['clubID']."')");
} }


if ($NewSubCat !="") { mail("email","New Sub Category Request","Dear Owner,
\n\nThe club in the name of $name with a validation code of $validationID would like a new sub category called $new_cat\n\n  
\nTeam Me\n\n\n\n"); }

$url = "/create/create_clubp3.php?new_club=$validation";  
header("Location: $url");     

Hi,

I m doing some work for my self an because of that i been reading a lot arround about PHP, and theres something that i would like to ask a bit of enlightenment. So my question is as the title says about html form's using php to insert data into mysql, i been reading tutorials arround the interwebs and even made afew successful tests, but pretty much all tutorials use 2 files to accomplish this the html file with the form and an insert.php where the actual code is stored so this made me think is this how usually it's done? in over all you will have 1 file for the form, 1 for the insert, 1 for the edit php code and 1 for delete. How do you guys usually do it?

PS: one of the tests i did was making 1 single file with all these using an switch. My interest in making this question is solo to learn how other people do it to see if i m in the right way.

Thanks in advance.

Hi all,   Its been a long time since last help request from real professional from here but I'm again in trouble with a much more spectacular plan I'm working on.

For those who are interested in the plan then here it is:
My Idea was to make a new build starting from scratch and make it as dynamical as possible. So my goal is not to make almost anything fixed in the code. I have made a decision to make a one supper large table for multiple different entries so no more joining and no more views for me.! In this help request I'm having trouble with Posting values to a page processing page lets call it record_changer.php The sole purpose of this file is to get form posts and decide what to do. Either update, delete, or insert.

record_changer.php
 

<?php

include '../../config/config.inc.php';

if(is_ajax()){
# Checks if action value exists
  if(isset($_POST["action"]) && !empty($_POST["action"])){
    $action = $_POST["action"];
# Switch case for value of action
    switch($action){
			case "insert": datatable_insert_function();
			break;
			case "update": datatable_update_function();
			break;
			case "delete": datatable_delete_function();
			break;
    }
  }
}

# Function to check if the request is an AJAX request
function is_ajax(){ return isset($_SERVER['HTTP_X_REQUESTED_WITH']) && strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest'; }

function datatable_insert_function(){
}

function datatable_update_function(){
}

function datatable_delete_function(){
}

?>

The problem.

The problem is that the $insert places two entries to the DB. I cant seem to understand why.?

	# Test _POST values
	$_POST['UserID'] = '2';
	$_POST['WorkID'] = '22';
	$_POST['Status'] = '1';
	$_POST['Code'] = '1';
	$_POST['Title'] = '1';


	$columns = array();
	foreach(array_keys($_POST) as $name){
		# Exclude Action and ID
		if($name == 'Action' || $name == 'ID' || $name == 'submit' ){ continue; }
		$columns[] = $name;
	}

	print_r($columns);

	echo "<br>";

	$data = array_fill_keys($columns, 'NULL');

	print_r($data);

	foreach($data as $key => $value){
		$data[$key] = empty($_POST[$key]) ? 'NULL' : "'".mysql_real_escape_string($_POST[$key])."'";
	}

	echo "<br>";

	print_r($data);

	$insert = mysql_query('INSERT INTO datatable (ID, '.implode(', ',$columns).')VALUES (null, '.implode(',',$data).')') or die(mysql_error());

No errors no nothing. Just two entries of correct data. 
PS. Sorry for a lot of prints in the code it is work and idea in the progress. The posts at the moment are fixed in the code so it is easier to refresh and debug.

Please help if you spot the problem. Im really out of ideas. Some fresh eyes might make a difference.

And Please for those who want to say it is a bad idea and why and why and so on.. Move a long.!!! Im not interested in whinging i have a great use for this and just having trouble with the two entries.

Thanks.
Edited by ztimer, 14 January 2015 - 03:27 PM.

If one inserts acute letters, grave letters, ampersands and accented letters in xhtml they show perfectly on the page.
However if one uses insert or rss feed they show as � or a square.

How does one make them show correctly.

If I am running a query like this:

INSERT INTO `cam_locations` (`id`, `datacenter`, `address1`, `address2`, `city`, `state`, `zip`, `country`, `phone`) VALUES
(1, 'Austin Data Center', '', '', 'Austin', 'Texas', '', 'United States', ''),
(2, 'Sunnyvale Date Center', '', '', 'Sunnvale', 'California', '', 'United States', ''),
(4, 'BoxBorough Data Center', '', '', 'Boston', 'Massachusetts', '', 'United States', '')


It it possible to use mysql_insert_id() and get all the id's inserted? Maybe like an array of them or something? Thanks