insert data using radio button

new_php85 · November 21, 2008

i... i want insert data using radio button but it not succes...im not familiar insert data using radio button.here some coding that i have made.

<?php
include 'includes/db_connect.php';
include 'includes/css.php';
if (isset($_POST['bttnAdd']))
{
$id = $_POST['id'];
$name = $_POST['name'];
$dest = $_POST['dest'];


$data = 1;
$query = "INSERT INTO artis(name, dest)
		  VALUES('$name','$dest')";
mysql_query($query) or die('Query failed. ' . mysql_error());

echo "<script language='JavaScript'> alert('The record is successfully added');</script>";
echo "<script language='JavaScript'> window.location ='add_dest.php';</script>";
}
?>

<html>
<head>
<title>MEC</title>

<script type="text/javascript">
function validDate(add_dest)
{
var prob=false;

if(add_dest.name.value=="")
{
	alert("Please enter name");
	prob=true;
}

if(add_dest.dest.value=="")
{
	alert("Please choose dest");
	prob=true;
}

if(prob)
{			
	return false;
}

else
{
	return true;
}
}
</script>
<body>
<form name="add_dest" action="rodiobttn.php" onSubmit="return validDate(this);">
Name: <input name = "name" maxlength = "100" size = "50"><br>


  <b>Destination</b> 
    <p>
      <input type="radio" name="dest" value="domestic" <?php if(isset($_POST['dest']) && ($_POST['dest'] == 'domestic') )echo ' checked="checked"'; ?>/>
      Domestic => 
    	  <select name="dest">
          <option value="" selected>Choose Destination 
          <option value="SZB">SZB-Shah Alam 
          <option value="MEL">MEL-Melaka 
          <option value="KCH">KCH-Kuching 
          <option value="KTN">KTN-Kuantan </select>
    </p>

<input type="radio" name="dest" value="international" <?php if(isset($_POST['dest']) && ($_POST['dest'] == 'international') )echo ' checked="checked"'; ?>/>
  International => 
  <select name="select">
    <option value="" selected>Choose Destination 
    <option value="JHB">JHB-Johor Bahru 
    <option value="BKI">BKI-Sabah 
    <option value="SBW">SBW-Sibu 
    <option value="MYY">MYY-Miri 
    <option value="KBR">KBR-Kota Bahru 
    <option value="IPH">IPH-Ipoh 
    <option value="AOR">AOR-Alor Setar 
    <option value="TGG">TGG-Terengganu 
    <option value="PEN">PEN-Pulau Pinang 
    <option value="BTL">BTL-Bintulu 
    <option value="SARIKEI">SARIKEI 
  </select>
  </p> 
  <input type="submit" name="bttnAdd" value="SUBMIT"/>
</form>
</body>
</html>

when i press button submit, it do not show error information but it not sucsess. why ??? plz help me..... ??? ???

phpSensei · November 21, 2008

Try this, it was a quick recode in your javascript

<?php
include 'includes/db_connect.php';
include 'includes/css.php';
if ($_POST['posted']=='go')
{
$id = $_POST['id'];
$name = $_POST['name'];
$dest = $_POST['dest'];


$data = 1;
$query = "INSERT INTO artis(name, dest)
		  VALUES('$name','$dest')";
mysql_query($query) or die('Query failed. ' . mysql_error());

echo "<script language='JavaScript'> alert('The record is successfully added');</script>";
echo "<script language='JavaScript'> window.location ='add_dest.php';</script>";
}
?>
<html>
<head>
<title>MEC</title>

<script type="text/javascript">
function validDate()
{
var prob=false;


if(add_dest.name.value=="")
{
	alert("Please enter name");
	prob=true;
}

if(add_dest.dest.value=="")
{
	alert("Please choose dest");
	prob=true;
}

if(prob)
{			
	return false;
}

else
{
	add_dest.submit();
}
}
</script>
<body>
<form name="add_dest" action="rodiobttn.php">
Name: <input name = "name" maxlength = "100" size = "50"><br>


  <b>Destination</b> 
    <p>
      <input type="radio" name="dest" value="domestic" <?php if(isset($_POST['dest']) && ($_POST['dest'] == 'domestic') )echo ' checked="checked"'; ?>/>
      Domestic => 
    	  <select name="dest">
          <option value="" selected>Choose Destination 
          <option value="SZB">SZB-Shah Alam 
          <option value="MEL">MEL-Melaka 
          <option value="KCH">KCH-Kuching 
          <option value="KTN">KTN-Kuantan </select>
    </p>

<input type="radio" name="dest" value="international" <?php if(isset($_POST['dest']) && ($_POST['dest'] == 'international') )echo ' checked="checked"'; ?>/>
  International => 
  <select name="select">
    <option value="" selected>Choose Destination 
    <option value="JHB">JHB-Johor Bahru 
    <option value="BKI">BKI-Sabah 
    <option value="SBW">SBW-Sibu 
    <option value="MYY">MYY-Miri 
    <option value="KBR">KBR-Kota Bahru 
    <option value="IPH">IPH-Ipoh 
    <option value="AOR">AOR-Alor Setar 
    <option value="TGG">TGG-Terengganu 
    <option value="PEN">PEN-Pulau Pinang 
    <option value="BTL">BTL-Bintulu 
    <option value="SARIKEI">SARIKEI 
  </select>
  </p> 
  <input type="button" name="bttnAdd" onClick='validDate();' value="Button"/>
  <input name="posted" type="hidden" id="posted" value="go">
</form>

new_php85 · November 25, 2008

i have modified my code like this.but it still not working.when i select destination which domestic. only name will insert in data base but not destination. but when i select destination for international it can b insert in database. why this happen???

<?php
include 'includes/db_connect.php';
include 'includes/css.php';
if (isset($_POST['bttnAdd']))
{
$id = $_POST['id'];
$name = $_POST['name'];
$dest = $_POST['dest'];

$data = 1;
$query = "INSERT INTO artis(name, dest)
		  VALUES('$name','$dest')";
mysql_query($query) or die('Query failed. ' . mysql_error());

echo "<script language='JavaScript'> alert('The record is successfully added');</script>";
echo "<script language='JavaScript'> window.location ='rodiobttn4.php';</script>";
}
?>

<html>
<head>
<title>MEC</title>

<script type="text/javascript">
function validDate(add_dest)
{
var prob=false;

if(add_dest.name.value=="")
{
	alert("Please enter name");
	prob=true;
}

if(prob)
{			
	return false;
}

else
{
	return true;
}
}
</script>
<body>
<form name="add_dest" action="rodiobttn4.php" method='post' onSubmit="return validDate(this);">
Name: <input name = "name" maxlength = "100" size = "50"><br>

  <b>Destination</b> 
    <p>
      <input type="radio" name="domestic" value="domestic" <?php if(isset($_POST['dest']) && ($_POST['dest'] == 'domestic') )echo ' checked="checked"'; ?>/>
      Domestic => 
    	  <select name="dest">
          <option value="" selected>Choose Destination</option> 
          <option value="SZB">SZB-Shah Alam</option>
          <option value="MEL">MEL-Melaka</option> 
          <option value="KCH">KCH-Kuching</option> 
          <option value="KTN">KTN-Kuantan</option> </select>
    </p>

  <input type="radio" name="international" value="international" <?php if(isset($_POST['dest']) && ($_POST['dest'] == 'international') )echo ' checked="checked"'; ?>/>
  International => 
  <select name="dest">
    <option value="" selected>Choose Destination</option> 
    <option value="JHB">JHB-Johor Bahru</option>
    <option value="BKI">BKI-Sabah</option>
    <option value="SBW">SBW-Sibu</option> 
    <option value="MYY">MYY-Miri</option>
    <option value="KBR">KBR-Kota Bahru</option>
    <option value="IPH">IPH-Ipoh</option>
    <option value="AOR">AOR-Alor Setar</option>
    <option value="TGG">TGG-Terengganu</option>
    <option value="PEN">PEN-Pulau Pinang</option>
    <option value="BTL">BTL-Bintulu</option>
    <option value="SARIKEI">SARIKEI</option>
  </select>
  </p> 
  <input type="submit" name="bttnAdd" value="SUBMIT"/>
</form>
</body>
</html>

plz help me ??? ??? ???

Sign In

insert data using radio button

Recommended Posts

new_php85

Link to comment

Share on other sites

phpSensei

Link to comment

Share on other sites

new_php85

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information