Ad:

PHP Discussion Thread
Marked Solved
Views: 2956

Apr 24th, 2009

insert into multiple tables based on checkbox

Expand Post »

First off thanks in advance, everyone here has been a great help in the past and know you will be this time..

What i'm trying to achomplish is to submit data from a form into multipule tables in the Mysql DB. However I want the user to select which table the data gets inserted too by using check boxes..

I got the insert working but using the checkboxes are a little past my knowledge base.

Here is the insert code i have so far

PHP Syntax (Toggle Plain Text)
<?php
require('FC_DB_connection.php');
 
//check if form has been submited
if(isset($_POST['submit'])){
 
//new code sent from form
 $code=$_POST['code']; 
 
 //to protect from mysql injections
 $code = stripslashes($code);
 
 
 //inserting data order   
 $order = mysql_query("SELECT * FROM imob WHERE code='$code'");
 		if(mysql_num_rows($order) > 0 ){
 
		echo "code already in DB";
		}
		else if(mysql_query("INSERT INTO table1 (code, time)   
             VALUES ('$code', NOW())"));
 
 //declare in the order variable   
$result = mysql_query($order);  //order executes   
if($result){   
     echo("<br>New Code added");   
 } 
} 
 
 ?>
<?php
require('FC_DB_connection.php');

//check if form has been submited
if(isset($_POST['submit'])){

//new code sent from form
 $code=$_POST['code']; 
 
 //to protect from mysql injections
 $code = stripslashes($code);

   
 //inserting data order   
 $order = mysql_query("SELECT * FROM imob WHERE code='$code'");
 		if(mysql_num_rows($order) > 0 ){
		
		echo "code already in DB";
		}
		else if(mysql_query("INSERT INTO table1 (code, time)   
             VALUES ('$code', NOW())"));
		   
 //declare in the order variable   
$result = mysql_query($order);  //order executes   
if($result){   
     echo("<br>New Code added");   
 } 
} 

 ?>

Form code:

PHP Syntax (Toggle Plain Text)
<form name="addcode" action="<?php $_SERVER['PHP_SELF'];?>" method="POST">
 <br />
 <input name="code" type="text" value="Enter Code">
 <br />
 1:<input type="checkbox" name="1">
 2:<input type="checkbox"  name="2">
 3:<input type="checkbox" name="3">
 4:<input type="checkbox" name="4">
 <br />
 <input type="submit" name="submit" value="Add Code">
 </form>
<form name="addcode" action="<?php $_SERVER['PHP_SELF'];?>" method="POST">
 <br />
 <input name="code" type="text" value="Enter Code">
 <br />
 1:<input type="checkbox" name="1">
 2:<input type="checkbox"  name="2">
 3:<input type="checkbox" name="3">
 4:<input type="checkbox" name="4">
 <br />
 <input type="submit" name="submit" value="Add Code">
 </form>

so basically the data from the text box needs to be inserted into all the tables where a checkbox is checked.

AON07

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Aug 2008

Permalink

Apr 24th, 2009

Re: insert into multiple tables based on checkbox

Instead of having different names for your checkboxes, use a checkbox array and on submit, loop through all the selected checkbox and insert a record to the table.
For eg.,

php Syntax (Toggle Plain Text)
<form name="addcode" action="<?php $_SERVER['PHP_SELF'];?>" method="POST">
 <br />
 <input name="code" type="text" value="Enter Code">
 <br />
 1:<input type="checkbox" name="checkbox" value="table1">
 2:<input type="checkbox"  name="checkbox" value="table2">
 3:<input type="checkbox" name="checkbox" value="table3">
 4:<input type="checkbox" name="checkbox" value="table4">
 <br />
 <input type="submit" name="submit" value="Add Code">
 </form>
<form name="addcode" action="<?php $_SERVER['PHP_SELF'];?>" method="POST">
 <br />
 <input name="code" type="text" value="Enter Code">
 <br />
 1:<input type="checkbox" name="checkbox" value="table1">
 2:<input type="checkbox"  name="checkbox" value="table2">
 3:<input type="checkbox" name="checkbox" value="table3">
 4:<input type="checkbox" name="checkbox" value="table4">
 <br />
 <input type="submit" name="submit" value="Add Code">
 </form>

Then, On submit,

php Syntax (Toggle Plain Text)
<?php
require('FC_DB_connection.php');
 
//check if form has been submited
if(isset($_POST['submit'])){
//new code sent from form
$textbox_value = mysql_real_escape_string($_POST['code']);
foreach($_POST['checkbox'] as $tablename_value) {
$query = "insert into $tablename_value (col1) values ('$textbox_value')";
mysql_query($query);
}
..... etc....
 ?>
<?php
require('FC_DB_connection.php');

//check if form has been submited
if(isset($_POST['submit'])){
//new code sent from form
$textbox_value = mysql_real_escape_string($_POST['code']);
foreach($_POST['checkbox'] as $tablename_value) {
$query = "insert into $tablename_value (col1) values ('$textbox_value')";
mysql_query($query);
}
..... etc....
 ?>

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Apr 24th, 2009

Re: insert into multiple tables based on checkbox

I tried the following code, it will echo each variable from the loop just fine but it won't insert the data into the database. Everything looks fine but maybe I missed something.

php Syntax (Toggle Plain Text)
// sent from form
$textbox_value = ($_POST['code']);
$checkbox = ($_POST['checkbox']);
foreach($checkbox as $tablename) {
$query = "INSERT INTO $tablename (code, time) VALUES ('$textbox_value', NOW())";
 
$result = mysql_query($query);
if($result) {
     echo("code added to $tablename database <br />");
}
else
     echo "could not add code to $tablename database <br />";
}
?>
// sent from form
$textbox_value = ($_POST['code']);
$checkbox = ($_POST['checkbox']);
foreach($checkbox as $tablename) {
$query = "INSERT INTO $tablename (code, time) VALUES ('$textbox_value', NOW())";

$result = mysql_query($query);
if($result) {
     echo("code added to $tablename database <br />");
}
else
     echo "could not add code to $tablename database <br />";
}
?>

AON07

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Aug 2008

Permalink

Apr 25th, 2009

Re: insert into multiple tables based on checkbox

Print out the query, execute it in phpmyadmin, Or, simply add, or die(mysql_error()); ie.,

php Syntax (Toggle Plain Text)
// sent from form
$textbox_value = ($_POST['code']);
$checkbox = ($_POST['checkbox']);
foreach($checkbox as $tablename) {
$query = "INSERT INTO $tablename (code, time) VALUES ('$textbox_value', NOW())";
$result = mysql_query($query) or die(mysql_error());
if($result) {
     echo("code added to $tablename database <br />");
}
else
     echo "could not add code to $tablename database <br />";
}
?>
// sent from form
$textbox_value = ($_POST['code']);
$checkbox = ($_POST['checkbox']);
foreach($checkbox as $tablename) {
$query = "INSERT INTO $tablename (code, time) VALUES ('$textbox_value', NOW())";
$result = mysql_query($query) or die(mysql_error());
if($result) {
     echo("code added to $tablename database <br />");
}
else
     echo "could not add code to $tablename database <br />";
}
?>

This will make the code to print the error message on the screen if there is any.

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Apr 25th, 2009

Re: insert into multiple tables based on checkbox

My database connection was selecting the wrong DB. Its all working now Thanks for all your help.

AON07

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Aug 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Pull Data from External Website

Next Thread in PHP Forum Timeline: Please provide code Logic for a photo gallery

DaniWeb Message

Cancel Changes

User Name
Password