Disscussion about deletion of record from php form

[punitshrivastava]

Hi all,
I am Punit
I am working in php .i want to delete records from database from php form .
For this i code the code is:

<?php
 
$name = $_POST['firstname'];
 
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password="root"; // Mysql password 
$db_name="projectdb"; // Database name 
$tbl_name="person"; // Table name 
 
// Connect to server and select database.
$dbconnection = mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
 
// delete data in mysql database 
$sql="DELETE FROM person WHERE FirstName ='$name' ";
echo "$sql";
$result = mysql_query($sql,$dbconnection);
echo"$result";
 
// if successfully deleted. 
if($result == 1)
{
echo "Successful";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}
 
else 
{
echo "ERROR";
}
 
?>

it is not working
when i echo sql statement it shows:

DELETE FROM person WHERE FirstName ='' 1Successful
As i am beginners in php so please suggest me .
Thanks

[tarsem]

hi, i am Tarsem SIngh
Please read PHP help Tutorial -- http://www.php-mysql-tutorial.com/

[punitshrivastava]

Thanks Tarsem SIngh
I just go through the website which you refer to me.
Still i have a problem that value is not posting to another form.
As i use post for fetching the value:
$name = $_POST['firstname'];
in ane form i use table .In that table i use to create row and five col.
I want to fetch data from one col by the help of that data i delete the entire row from database.As if directly subsitute the value in query it perform the taskbut as i fetch the value from another form it is not working .
Then i use to create textbob in col.
by thismethod:

<td><input type = "text" name = "firstname" value="<? echo $rows['FirstName']; ?>" /></td> 

fetch the data in another form as previously i say.
but still it is not working.
please suggest me wht do.As i am beginner in php so please suggest me.
Thanks
punit

hi, i am Tarsem SIngh
Please read PHP help Tutorial -- http://www.php-mysql-tutorial.com/

[pbmods]

Heya, Punit.

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

[kovik]

I'd suggest you read more into the tutorial. Posted variables only exist *after* the form has been posted, and $rows would only exist after you've created it.

Also, some basic security can go a long way.

[ak1dnar]

Thanks Tarsem SIngh
I just go through the website which you refer to me.
Still i have a problem that value is not posting to another form.
As i use post for fetching the value:
$name = $_POST['firstname'];
in ane form i use table .In that table i use to create row and five col.
I want to fetch data from one col by the help of that data i delete the entire row from database.As if directly subsitute the value in query it perform the taskbut as i fetch the value from another form it is not working .
Then i use to create textbob in col.
by thismethod:

<td><input type = "text" name = "firstname" value="<? echo $rows['FirstName']; ?>" /></td> 

fetch the data in another form as previously i say.
but still it is not working.
please suggest me wht do.As i am beginner in php so please suggest me.
Thanks
punit

As I got, you are sending this form element to another script to deletion.

<td><input type = "text" name = "firstname" value="<? echo $rows['FirstName']; ?>" /></td> 

first try

<td><input type = "text" name = "firstname" value="pass_existing_firstname_here" /></td> 

If its is working,then the problem is with the script that you used to echo these lines.

<? echo $rows['FirstName']; ?>

double check it or post that script also.

[abertay]

Hi all,
I am Punit
I am working in php .i want to delete records from database from php form .
For this i code the code is:

<?php
 
$name = $_POST['firstname'];
 
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password="root"; // Mysql password 
$db_name="projectdb"; // Database name 
$tbl_name="person"; // Table name 
 
// Connect to server and select database.
$dbconnection = mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
 
// delete data in mysql database 
$sql="DELETE FROM person WHERE FirstName ='$name' ";
echo "$sql";
$result = mysql_query($sql,$dbconnection);
echo"$result";
 
// if successfully deleted. 
if($result == 1)
{
echo "Successful";
echo "<BR>";
echo "<a href='list_records.php'>View result</a>";
}
 
else 
{
echo "ERROR";
}
 
?>

it is not working
when i echo sql statement it shows:

DELETE FROM person WHERE FirstName ='' 1Successful
As i am beginners in php so please suggest me .
Thanks

Remove the double qoutes in your mysql_connect & mysql_select_db query.
Because $host="localhost" so you dont need them again

mysql_connect($host,$root,$password);
mysql_select_db($dbname);