Need Help With: mysql_query to delete *

Dev Shed Forums Sponsor:

May 5th, 2000, 02:31 AM

Yokhannan

Junior Member

Join Date: May 2000

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

Hi All.

First time poster at this forum!

Great to see the support here.

Well, my question is a newbie question, that I'm sure is pretty easy, but I just can't figure it out!

I've got a simple PHP & MySQL database script that I'm working with. I have figured out how to 'add' and 'view' the data in the database, but I can't figure out how to delete the data.

To get to the code here...

Here are my variables: (not real, just for example sake)

$hostname = "YourHostName";
$username = "YourUsername";
$password = "YourPassword";
$userstable = "LinksTable";
$dbName = "YourDatabaseName";

Here are my tables fields:

ID
LinkName
LinkURL
LinkDescription
email
UserName
UserPassword (which I don't use yet!)

Ok, with that stuff out of the way...

I am in need of the syntax code to be able to place within my admin.php3 file to be able to delete a line from within the database table.

Ok, now here is my complete admin.php3 code:

<BLOCKQUOTE>code:<HR><pre>
<html>
<head>
<title> Links Database - Admin Page </title>
</head>
<body text=black link=red vlink=red alink=yellow>

<?

/* declare variables */
$hostname = "YourHostName";
$username = "YourUsername";
$password = "YourPassword";
$userstable = "LinksTable";
$dbName = "YourDatabaseName";
$VLDir = "http://www.PathToYour/Diretory";
// set this to the directory where your main files are!
// DO NOT include a closing "/" on the $VLDir variable!

/* make connection to database */
MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");

@mysql_select_db( "$dbName") or die( "Unable to select database");

/* Select all from within database */
$query = "SELECT * FROM $userstable";

$result = MYSQL_QUERY($query);

/* How many users are there? */
$number = MYSQL_NUMROWS($result);

/* Print these results to the screen */
$i = 0;

IF ($number == 0) :
PRINT "<a href="$VLDir/insert.php3">Add A Link</a>";
PRINT " ";
PRINT "There Are Presently No Links!";
ELSEIF ($number > 0) :
PRINT "Total Number of Links: $number | <a href="$VLDir/insert.php3">Add Your Link</a>";
PRINT " <hr color=black width=60% align=left> ";
WHILE ($i < $number):
$LinkName = mysql_result($result,$i,"LinkName");
$LinkURL = mysql_result($result,$i,"LinkURL");
$LinkDescription = mysql_result($result,$i,"LinkDescription");
$email = mysql_result($result,$i,"email");
$UserName = mysql_result($result,$i,"UserName");
$UserPassword = mysql_result($result,$i,"UserPassword");
PRINT "Site Name: $LinkName ";
PRINT "Site URL: <a href="$LinkURL" target="_blank">$LinkURL</a> ";
PRINT "Site Description: $LinkDescription ";
PRINT "* User Name: $UserName ";
PRINT "* User Password: $UserPassword ";
PRINT "* Email address: <a href="mailto:$email">$email</a> ";
PRINT " ";
$i++;
ENDWHILE;
PRINT "</CENTER>";
ENDIF;
?>
 
<hr width=40% align=left color=black>
Copyright © 4CM, 1996-2000 - <a href="http://www.4cm.com" target="_blank">www.4cm.com</a> 
Links Database Powered By: <a href="http://www.4cm.com" target="_blank">www.4cm.com</a>
</body>
</html>
[/code]

Can anyone here help me with the next step of this admin page... I need a way to be able to "DELETE" a given entire.

I would be really grateful!

(sure hope all this makes sense!)

Later All.

------------------
--- -- -- --- -- -- ---
John B. Abela
Owner, 4CM
http://www.4cm.com/
URL

May 5th, 2000, 07:15 AM

Shiju Rajan

.Net Developer

Join Date: Feb 2000

Location: London

Posts: 987

Time spent in forums: 3 h 26 m 22 sec
Reputation Power: 14

i am writing a simple delete script.

just try in this way...

$deleteresult = mysql_query ("DELETE FROM tablename WHERE id = '$id'");

if (mysql_affected_rows($deleteresult) >= 1)
{ print "Successfully deletedn";
}
else
{
print "not deleted any rows";
exit;
}

------------------
SR -
shiju.dreamcenter.net

May 5th, 2000, 12:37 PM

Yokhannan

Junior Member

Join Date: May 2000

Posts: 2

Time spent in forums: < 1 sec
Reputation Power: 0

Thanks for the bit of code!

However, I'm still unsure what to do.

Should I place the code you wrote in a seperate file? (for instance: delete.php3)??

Or should I include it within the existing "admin.php3" file that I have?

And, either way, what would the html code be to call it?

Sorry for the real basic questions...

Later.

------------------
--- -- -- --- -- -- ---
John B. Abela
Owner, 4CM
http://www.4cm.com/
URL

May 6th, 2000, 01:53 AM

Shiju Rajan

.Net Developer

Join Date: Feb 2000

Location: London

Posts: 987

Time spent in forums: 3 h 26 m 22 sec
Reputation Power: 14

Yokhannan,

you can include that delete script inside the "admin.php3" or you can create a separate delete.php3.either way it should work fine.

include the following html tag in your admin.php3(or where ever you want to place it).

Delete a link:
<form action="delete.php3" method="post">
Link name<input type="text" name="link_name">
<input type="submit" name="delete" value="Remove Now">
</form>

In delete.php3:

if($delete=="Remove Now"){
$deleteresult = mysql_query ("DELETE FROM tablename WHERE linkname = '$link_name'");

if (mysql_affected_rows($deleteresult) >= 1)
{ print "Link has been removed successfullyn";
}
else
{
print "Error !! couldn't remove the link";
exit;
}
}

if you are using this delete script in admin.php3 then use the form html tag

<form action="admin.php3" method="post">
---
--

and use delete script inside the admin.php3.

(you can modify the above script according to your requirment)

Hope this may help you to finish your assainment successfully.

GOOD LUCK!!!!!

------------------
SR -
shiju.dreamcenter.net

Need Help With: mysql_query to delete *

Developer Shed Advertisers and Affiliates