how to insert data into databse when a button is clicked

[chitrapu]

hiii everybody,

i have a little code that inserts the data into the databse. but the problem is the insertion should be peroformed only when a button is clicked. i have problems in this because i am not able to call the function when the button is clicked. hope anyone can help me out with a good code.

echo"Enter the name :";
echo"<input name='names' type='text'>";
echo"<input type='submit' value='ADD name' align=center><b r>";
$link = mysql_connect(" ","","");
mysql_select_db ("db");

/*the below statements must get executed only when the button is clicked*/
$query="insert into table value("");
mysql_query($qu ery);

[acoder]

Just use a simple submit button which posts the data to another page which should be specified in your form tag, e.g.
[HTML]<form action="youract ionpage.php" method="post" ...>
<input type="submit" ...>[/HTML]

[ronverdonk]

The easiest way to handle this is in one script. After you entered the name and clicked the 'ADD name' button, the script itself is invoked again and processes the entered value by inserting it into the database.
The script's process is the folllowing:

If form is submitted 
  Do
    get the value
    connect to server and db
    build insert stmt
    insert value into db
    issue message
  End-Do
End-If
Else
  Do
    show form
    enter data
    at click submit form
  End-Do
End-Else

[php]<?php
// check to see if form is submitted
if (isset($_POST['names'])) {
// get the POSTed value after cleansing
$names = stripslashes($_ POST['names']);
// setup the server and db connection
$link = mysql_connect(" ","","")
or die("Cannot connect to server: ".mysql_error() );
mysql_select_db ("db")
or die("Cannot connect to database: ".mysql_error() );
// build the MySQL query
$query="INSERT INTO table VALUES('$names' )";
// insert into db
$res = mysql_query($qu ery)
or die("INSERT error: ".mysql_error() );
// issue message
echo "Field succesfully added to database";
}
else {
echo '<form action="'.$_SER VER['PHP_SELF'].'" method="POST">' ;
echo "Enter the name :";
echo "<input name='names' type='text'>";
echo "<input type='submit' value='ADD name' align=center><b r>";
}
?>[/php]
Good luck.

Ronald :cool: