inserting checkbox values in mysql +PHP

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 375,193 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,200 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 4983 | Replies: 66

Page 4 of 7

« First

Last »

•

Join Date: Feb 2008

Posts: 37

Reputation: asadalim1 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

asadalim1

Offline

Light Poster

Re: inserting checkbox values in mysql +PHP

#31

Feb 13th, 2008

Hi nav, I have already made a dynamic table where the checkbox values are stored in db table and printed on the screen see code below..

what i want to do is edit/delete the database values in a php form. so when it can change the data in the db and countries can be added or deleted on a form rather than making changes in MYPHPADMIN.

Cheers

<form id="form1" name="form1" method="post" action="page2.php">
<?php
$sql = 'SELECT * From Countries';

$con = mysql_connect("localhost","root","mariapa") or die;

$result = mysql_db_query(talk21, $sql);

while ($rec = mysql_fetch_array($result))
{
print "\n<input type='checkbox' name=Countries[]' value='".$rec['id']."' > ".$rec['Country']." </input>";
}

?><br />
<input type="submit" name="Submit" value="Register" />
</label>
</form>

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 3,057

Reputation: nav33n has a spectacular aura about

Rep Power: 8

Solved Threads: 229

nav33n

Offline

Posting Sensei

Re: inserting checkbox values in mysql +PHP

#32

Feb 13th, 2008

The second script lists all the teams in the table. Select the ones which you want to delete and click on submit! It ll delete all those teams from the table. I don't know how you can edit and what you mean by edit !

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*

•

Join Date: Feb 2008

Posts: 37

Reputation: asadalim1 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

asadalim1

Offline

Light Poster

Re: inserting checkbox values in mysql +PHP

#33

Feb 14th, 2008

By edit I mean to an existing record that has been added to the database e.g

if i have a record which i want to change

id| name|last_name|countries
1 priya rai BR, FR

Say i just wanted to change the record name from priya to rianah without changing anything else

id| name|last_name|countries
1 rianah rai BR, FR

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 3,057

Reputation: nav33n has a spectacular aura about

Rep Power: 8

Solved Threads: 229

nav33n

Offline

Posting Sensei

Re: inserting checkbox values in mysql +PHP

#34

Feb 14th, 2008

While listing the records, show previous name in a textbox and when submit is clicked, update it ?

•

Join Date: Feb 2008

Posts: 37

Reputation: asadalim1 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

asadalim1

Offline

Light Poster

Re: inserting checkbox values in mysql +PHP

#35

Feb 14th, 2008

•

Originally Posted by nav33n

While listing the records, show previous name in a textbox and when submit is clicked, update it ?

yes thats right i will have record set displaying all the user informtion on one big table. user can look at this table and and user can select onclick or by checking a checkbox and the record that is selected like e.g 2 kelle bria BR can be changed or deleted on another page.

id| name|last_name|countries
1 priya rai BR, FR
2 kelle bria BR
3 adam kel GB

•

Join Date: Feb 2008

Posts: 37

Reputation: asadalim1 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

asadalim1

Offline

Light Poster

Re: inserting checkbox values in mysql +PHP

#36

Feb 15th, 2008

While listing the records, show previous name in a textbox and when submit is clicked, update it ?

Naveen I am wondering if its possible to edit in the record set by checkbox and redirect user to change records like a textbox field?

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 3,057

Reputation: nav33n has a spectacular aura about

Rep Power: 8

Solved Threads: 229

nav33n

Offline

Posting Sensei

Re: inserting checkbox values in mysql +PHP

#37

Feb 15th, 2008

Hi, Sorry. I didn't get it. Could you please re-explain the whole thing to me ? Is it like this.
You have a textbox to enter the name, list of checkboxes to select the country and a submit button. You can add records to the table from this screen. You need another screen where you can edit the records in the table ? (change the name and checkbox values ?) Is this what you are asking ?

•

Join Date: Feb 2008

Posts: 37

Reputation: asadalim1 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

asadalim1

Offline

Light Poster

Re: inserting checkbox values in mysql +PHP

#38

Feb 15th, 2008

Yes exactly thats what i mean.

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 3,057

Reputation: nav33n has a spectacular aura about

Rep Power: 8

Solved Threads: 229

nav33n

Offline

Posting Sensei

Re: inserting checkbox values in mysql +PHP

#39

Feb 15th, 2008

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
$conn=mysql_connect("localhost","root");
mysql_select_db("test");
$operation=$_POST['operation'];
$id=$_POST['id'];
if(isset($_POST['submit'])) {
		$team=implode(",",$_POST['team']);
		$name=$_POST['name'];
		$q="insert into table1 (name, team) values ('$name','$team')";
		mysql_query($q);
}
if($operation=="delete"){
	$q="delete from table1 where counter='$id'";
	mysql_query($q);
}
if(isset($_POST['update'])){
	$name=$_POST['name'];
	$team=implode(",",$_POST['team']);
	$q="update table1 set name='$name', team='$team' where counter='$id'";
	mysql_query($q);
}
?>
<html>
<body>
<form method="post" name="insertform" action="checkbox1.php">
Enter name: <input type="text" name="name" /><br />
<input type="checkbox" name="team[]" value="AG">Argentina <br />
<input type="checkbox" name="team[]" value="BR">Brazil <br />
<input type="checkbox" name="team[]" value="GE">Germany <br />
<input type="checkbox" name="team[]" value="EN">England <br />
<input type="submit" name="submit" value="submit">
</form>
<hr>
<form method="post" name="editform" action="checkbox1.php">
<input type="hidden" name="id">
<input type="hidden" name="operation">
<?php
	$q="select counter,name from table1";
	$result=mysql_query($q);
	while($row=mysql_fetch_array($result)){
		$name=$row['name'];
		$id=$row['counter'];
		echo $name ."<input type=\"button\" name=\"edit\" value=\"edit\" onclick=\"javascript: document.editform.operation.value='edit';document.editform.id.value='$id';document.editform.submit();\"><input type=\"button\" name=\"delete\" value=\"Delete\" onclick=\"javascript: document.editform.operation.value='delete';document.editform.id.value='$id'; document.editform.submit();\"><br />";
	}
?>
</form>
<hr>
<?php
if($operation=="edit") {
	$id=$_POST['id'];
	?>
	<form method="post" name="updateform" action="checkbox1.php">
	<input type="hidden" name="id" value="<?php echo $id; ?>">
	<?php
	$q="select * from table1 where counter='$id'";
	$result=mysql_query($q);
	$row=mysql_fetch_array($result);
	$name=$row['name'];
	$team=$row['team'];
	$teamarray=explode(",",$team);
	echo "<input type=\"text\" name=\"name\" value=\"$name\"><br />";
?>
<input type="checkbox" name="team[]" value="AG" <?php if(in_array("AG",$teamarray)){ echo "checked"; } ?>>Argentina <br />
<input type="checkbox" name="team[]" value="BR" <?php if(in_array("BR",$teamarray)){ echo "checked"; } ?>>Brazil <br />
<input type="checkbox" name="team[]" value="GE" <?php if(in_array("GE",$teamarray)){ echo "checked"; } ?>>Germany <br />
<input type="checkbox" name="team[]" value="EN" <?php if(in_array("EN",$teamarray)){ echo "checked"; } ?>>England <br />
<input type="submit" name="update" value="update">
<?php
}
?>
</body>
</html>
<?php
$conn=mysql_connect("localhost","root");
mysql_select_db("test");
$operation=$_POST['operation'];
$id=$_POST['id'];
if(isset($_POST['submit'])) {
		$team=implode(",",$_POST['team']);
		$name=$_POST['name'];
		$q="insert into table1 (name, team) values ('$name','$team')";
		mysql_query($q);
}
if($operation=="delete"){
	$q="delete from table1 where counter='$id'";
	mysql_query($q);
}
if(isset($_POST['update'])){
	$name=$_POST['name'];
	$team=implode(",",$_POST['team']);
	$q="update table1 set name='$name', team='$team' where counter='$id'";
	mysql_query($q);
}
?>
<html>
<body>
<form method="post" name="insertform" action="checkbox1.php">
Enter name: <input type="text" name="name" /><br />
<input type="checkbox" name="team[]" value="AG">Argentina <br />
<input type="checkbox" name="team[]" value="BR">Brazil <br />
<input type="checkbox" name="team[]" value="GE">Germany <br />
<input type="checkbox" name="team[]" value="EN">England <br />
<input type="submit" name="submit" value="submit">
</form>
<hr>
<form method="post" name="editform" action="checkbox1.php">
<input type="hidden" name="id">
<input type="hidden" name="operation">
<?php
	$q="select counter,name from table1";
	$result=mysql_query($q);
	while($row=mysql_fetch_array($result)){
		$name=$row['name'];
		$id=$row['counter'];
		echo $name ."<input type=\"button\" name=\"edit\" value=\"edit\" onclick=\"javascript<b></b>: document.editform.operation.value='edit';document.editform.id.value='$id';document.editform.submit();\"><input type=\"button\" name=\"delete\" value=\"Delete\" onclick=\"javascript<b></b>: document.editform.operation.value='delete';document.editform.id.value='$id'; document.editform.submit();\"><br />";
	}
?>
</form>
<hr>
<?php
if($operation=="edit") {
	$id=$_POST['id'];
	?>
	<form method="post" name="updateform" action="checkbox1.php">
	<input type="hidden" name="id" value="<?php echo $id; ?>">
	<?php
	$q="select * from table1 where counter='$id'";
	$result=mysql_query($q);
	$row=mysql_fetch_array($result);
	$name=$row['name'];
	$team=$row['team'];
	$teamarray=explode(",",$team);
	echo "<input type=\"text\" name=\"name\" value=\"$name\"><br />";
?>
<input type="checkbox" name="team[]" value="AG" <?php if(in_array("AG",$teamarray)){ echo "checked"; } ?>>Argentina <br />
<input type="checkbox" name="team[]" value="BR" <?php if(in_array("BR",$teamarray)){ echo "checked"; } ?>>Brazil <br />
<input type="checkbox" name="team[]" value="GE" <?php if(in_array("GE",$teamarray)){ echo "checked"; } ?>>Germany <br />
<input type="checkbox" name="team[]" value="EN" <?php if(in_array("EN",$teamarray)){ echo "checked"; } ?>>England <br />
<input type="submit" name="update" value="update">
<?php
}
?>
</body>
</html>

Well, Here is the code. The code is lil confusing (and untidy) but I am in no mood to write any better code. I am doing everything in 1 page. You can insert, edit and delete a record. Hope this will fix your problem.

Cheers,
Naveen

•

Join Date: Oct 2007

Posts: 6

Reputation: amin007 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

amin007

Offline

Newbie Poster

Re: inserting checkbox values in mysql +PHP

#40

Feb 15th, 2008

Help with Code Tags

(Toggle Plain Text)

if(isset($_POST['team']))
{ 
	foreach($_POST['team'] as $value)
	{
	$insert="INSERT INTO team('team')VALUES ('$value')";
	echo "$insert<br>";
	}
}

are you want to do like this???

Page 4 of 7

« First

Last »

•

Only community members can participate in forum threads. You must register or log in to contribute.

•

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

•

DaniWeb PHP Marketplace

•

Thread Tools	Display Modes
Show Printable Version Email this Page	Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

•

Similar Threads

Variable passed to each() is not an array (PHP)
How to delete using checkboxes (PHP)
Storing dynamic form values in Arrays for display & insert (PHP)

Other Threads in the PHP Forum

Previous Thread: problem in deleting
Next Thread: Cookies problem - not working

DaniWeb Home > Forums > Web Development > PHP

inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP

Re: inserting checkbox values in mysql +PHP