stopping mysql entries

[11Tami]

Hello, is there an easy way to to stop entries to mysql? But also so the echo from the php still works on the page like it should when the form is submitted? Please let me know, thank you very much.

Here's the basic setup:

 

<?php
if ($_POST['softwareemail']==""){
<form method='POST' action='<?php echo $_SERVER["PHP_SELF"]; ?>
<input type='text' name='softwareemail' >
<input type='submit' value='submit'>
?>
<?php 
$con = mysql_connect("","","");
if (!$con)
{ die('Could not connect: ' . mysql_error());
}mysql_select_db("", $con);
$email = $_POST['softwareemail'] ;
$sql="INSERT INTO addsoftware (softwareemail)
VALUES ('" . $_POST['softwareemail']. "')";
if (mysql_query($sql,$con)) {echo "data submitted";}
?>

[revraz]

Remove this

 

$sql="INSERT INTO addsoftware (softwareemail)

VALUES ('" . $_POST['softwareemail']. "')";

if (mysql_query($sql,$con)) {echo "data submitted";}

 

add this in it's place

 

echo "data submitted";

 

I think that's what you mean.

 

If so, then you can also remove all of this

 

$con = mysql_connect("","","");

if (!$con)

{ die('Could not connect: ' . mysql_error());

}mysql_select_db("", $con);

 

 

[11Tami]

Thank you. Does anyone know if mysql has some sort of button where you can keep entries temporarily from being added? Please let me know, thank you very much.

[fenway]

Thank you. Does anyone know if mysql has some sort of button where you can keep entries temporarily from being added? Please let me know, thank you very much.

How do you mean?

[11Tami]

I mean so that if you don't want people to add something to your database from your web pages. You can temporarily do something to mysql to keep any data from being inserted.

[TimUSA]

rather than disabling your database, how about this??

<input disabled type='text' name='softwareemail' >