can we use mysql(DELETE...) query in the same page while having anchor tags?

Question

Kavitha Butchi 0 Junior Poster in Training

15 Years Ago

Hi all,

Instead of passing the variables to the other page and coding mysql queries there.. Is it possible that we can use the mysql(DELETE...) query within the anchor tags in the same page?

<a href >... to delete a particular row in mysql table?
Like having a link called delete and by clicking on that , a particular row must be deleted in the table.

eg:- <a href = " .... some mysql query....">DELETE</a>
(or)
eg:- <a href="<?php //delete this row ?>">delete</a>
(or)

eg:-

<?php
 //db connections..

$result = mysql_query("SELECT commentid FROM comments") 
or die(mysql_error());  
 
while($row = mysql_fetch_array( $result )) {
?>
 	<a href="<?php //delete this row ?>">delete</a>
<?php } ?>

Instead of passing the variables to the other page and coding mysql queries there.. Is it possible that we can use the mysql(DELETE...) query in the same page?
I was wondering if there is some possibility like this in PHP .
Please let me know if there are any such methods .

Thankyou all in Advance.

php

4 Contributors
10 Replies
529 Views
16 Hours Discussion Span
Latest Post 15 Years Ago Latest Post by Kavitha Butchi

All 10 Replies

ryan_vietnow 13 Posting Pro

15 Years Ago

<?php
 //db connections..

$result = mysql_query("SELECT commentid FROM comments") 
or die(mysql_error()); 
 
while($row = mysql_fetch_array( $result )) {
?>
 	<a href="<?php //delete this row ?>">delete</a>
<?php } ?>
Instead of passing the variables to the other page and coding mysql queries there.. Is it possible that we can use the mysql(DELETE...) query in the same page?
I was wondering if there is some possibility like this in PHP .
Please let me know if there are any such methods .
Thankyou all in Advance.

sure,you can,get the id of that you want to delete then perform the delete query in the same page.for example:
(this is your page,e.g. sample.php)

<?php
 //db connections..

$result = mysql_query("SELECT commentid FROM comments") 
or die(mysql_error());  
 
while($row = mysql_fetch_array( $result )) {
?>
 	<a href="sample.php?delete_id=<?=$row['id']?>">delete</a>
<?php } ?>

put your delete statement above...
(sample.php)

//db connections..

if ($_GET['delete_id']!="")
{
//delete statement goes here....
}

$result = mysql_query("SELECT commentid FROM comments") 
or die(mysql_error());  
 
while($row = mysql_fetch_array( $result )) {
?>
 	<a href="sample.php?delete_id=<?=$row['id']?>">delete</a>
<?php } ?>

Kavitha Butchi commented: thank you fr your time +1

Shanti C 106 Posting Virtuoso

15 Years Ago

Hello kavitha try this...

<?
/...database connections...
if(!empty($_GET['delid'])){  
	mysql_query("delete from category WHERE id='".$_GET['delid']."'");
	if(!empty($_GET['start']))
    {
	header("location:add_subcategory.php?msg=del&start=".$_GET['start']."");
	}else{
	header("location:samepage.php?msg=del");
	}
}
?>
//This is in your designing table...
 <td height="22" align="center" ><a href="javascript:del('<? echo $frow['id'];?>')">Delete</a> </td>
//and this can be anyware in your page

            <script language="javascript">
var d = document.frmmngmall;						
	function del(x)
	{
				
				if(confirm("You want to delete this record"))
					{
					d.action="samepage.php?delid="+x;
					d.submit();
					}
				
			return;
	}
        </script>

And your a href must be in form tag...

This is working finely...try this...

Thanks.
Shanti

Shanti C 106 Posting Virtuoso

15 Years Ago

Hello kavitha try this...

<?
/...database connections...
if(!empty($_GET['delid'])){  
	mysql_query("delete from category WHERE id='".$_GET['delid']."'");
	
	header("location:samepage.php?msg=del");
	
}
?>
//This is in your designing table...
 <td height="22" align="center" ><a href="javascript:del('<? echo $frow['id'];?>')">Delete</a> </td>
//and this can be anyware in your page

            <script language="javascript">
var d = document.frmmngmall;						
	function del(x)
	{
				
				if(confirm("You want to delete this record"))
					{
					d.action="samepage.php?delid="+x;
					d.submit();
					}
				
			return;
	}
        </script>
 

<? /...database connections... if(!empty($_GET['delid'])){ mysql_query("delete from category WHERE id='".$_GET['delid']."'"); if(!empty($_GET['start'])) { header("location:add_subcategory.php?msg=del&start=".$_GET['start'].""); }else{ header("location:samepage.php?msg=del"); } } ?> //This is in your designing table... <td height="22" align="center" ><a href="javascript<b></b>:del('<? echo $frow['id'];?>')">Delete</a> </td> //and this can be anyware in your page <script language="javascript"> var d = document.frmmngmall; function del(x) { if(confirm("You want to delete this record")) { d.action="samepage.php?delid="+x; d.submit(); } return; } </script>

And your a href must be in form tag...

This is working finely...try this...

Thanks.
Shanti

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Kavitha Butchi 0 Junior Poster in Training · Answer 1 · 2008-07-08T09:15:13+00:00

Thankyou for your time ryan_vietnow
Passing it to the next page is what we are doing here too ....other than this method..

cant we simply run the query in the same page where the anchor tag is present instead of passing it over to next page?

Kavitha Butchi 0 Junior Poster in Training · Answer 2 · 2008-07-08T09:20:28+00:00

like

//...database connections...
<a href=mysql_query("DELETE FROM example WHERE age='15'")>delete</a>

something like that which works..where everything is coded in a single page rather than passing it over to the other page.

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 3 · 2008-07-08T10:11:57+00:00

like
//...database connections...
<a href=mysql_query("DELETE FROM example WHERE age='15'")>delete</a>
something like that which works..where everything is coded in a single page rather than passing it over to the other page.

AFAIK, Its not possible.

Kavitha Butchi 0 Junior Poster in Training · Answer 4 · 2008-07-08T18:23:23+00:00

Thankyou shanthi chepuru.
I shall consider giving it a shot ...am little concerned as it involves Javascript.
I appreciate fr your time :)

Kavitha Butchi 0 Junior Poster in Training · Answer 5 · 2008-07-08T18:35:56+00:00

AFAIK, Its not possible.

Hello nav33n,

thank you fr the response.

While googling fr this info I found out these broken strings..dont exactly if this is relevant or not.. thought I could ask it here...

You are not an employee of Warning: mysql_connect() [[B][U]<a href='function.mysql-connect'>function.mysql-connect</a>[/U][/B]]: Access denied for user ...

So I thought there might be something like this function.mysql-query....:icon_exclaim:

Please Let me know if nothing as such exists.

complete search result:
 Warning: mysql_connect() [<a href='function.mysql ...
11) You are not an employee of Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user ...
www.myrandomblogs.org/register.php - 25k - Cached - Similar pages - Note this

googled with search term as : <a href=function mysql(delete from

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 6 · 2008-07-08T19:15:18+00:00

mysql_connect error is because the user gave wrong credentials to connect to the database.
Its not possible to call a php function or a mysql query with "onclick" event. As others have mentioned already, you can use ajax or pass the id of the record in the anchor tag and then do relevant operation.

Kavitha Butchi 0 Junior Poster in Training · Answer 7 · 2008-07-08T19:17:45+00:00

Kavitha Butchi 0 Junior Poster in Training

15 Years Ago

OK nav33n, :) thankyou for your time.
Appreciate it.

can we use mysql(DELETE...) query in the same page while having anchor tags?

Recommended Answers Collapse Answers

All 10 Replies

Recommended Answers