DaniWeb Forum Index > Web Development > PHP

insert into multiple tables based on checkbox

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Aug 2008

Posts: 42

Reputation: AON07 is an unknown quantity at this point

Solved Threads: 0

AON07

Offline

Light Poster

insert into multiple tables based on checkbox

Apr 24th, 2009

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

 Help with Code Tags 
 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:

 Help with Code Tags 
 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.

"I am the Master Piece of my own life, Everything i'm thinking is creating my future."

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: insert into multiple tables based on checkbox

Apr 24th, 2009

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.,

 Help with Code Tags 
 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,

 Help with Code Tags 
 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....
 ?>

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Aug 2008

Posts: 42

Reputation: AON07 is an unknown quantity at this point

Solved Threads: 0

AON07

Offline

Light Poster

Re: insert into multiple tables based on checkbox

Apr 24th, 2009

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.

 Help with Code Tags 
 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 />";
}
?>

"I am the Master Piece of my own life, Everything i'm thinking is creating my future."

•

Join Date: Nov 2007

Posts: 3,761

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: insert into multiple tables based on checkbox

Apr 25th, 2009

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

 Help with Code Tags 
 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.