Help With editting and deleting form
Posted on
16th Feb 2014 07:03 pm by
admin
Hallo !!
So look at this image :
http://img194.imageshack.us/img194/8272/snapshot5f.png
This table prints the titles of entries from a table in a database.. The code that i use for this table is this :
Code: <!--Table For Deleting and Updating -->
<p align="center"><font color="#1569C7">DeleteOrEdit(</font><font color="red">Security Projects & Thoughts Section</font><font color="#1569C7">);</font></p>
<table align="center" border="2" bordercolor="green" cellspacing="0">
<!--First row with title delete and edit-->
<tr>
<td><font color="#F87217">Title:</td>
<td><font color="#F87217">Delete();</font></td>
<td><font color="#F87217">Edit();</font></td>
</tr>
<?php
$query = 'SELECT title FROM site_entries ORDER BY date_entered DESC';
if ($r = mysql_query($query)){
while ($row = mysql_fetch_array($r)){
print "<tr>
<td><font color="#8BB381">{$row['title']}</td>
<td><form method="post" name="sub_del"><input type="submit" value="Delete();"></form></td>
<td><form method="post" name="sub_edt"><input type="submit" value="Edit();"></form></td>
</tr> ";
}
}else{
die('<p>Could not retrive the data brcause:<b>' . mysql_error .'</b> The query was $query.</p>');
}
mysql_close();
?>
</table>
Its simple...till here...
Now i stack on how to make the script that will delete the registers of the database...I can think something with id column but i can't make it true...:s I want you to help me giving me ideas on how to make this or any other idea on how to create an delete/edit page...If you think that i start it with a wrong way please tell me
Your Answer:
Login to answer
99
44
Other forums
PHP SUBMIT
Code: <input name="doLogin" type="image" src="images/loginsubmit.jpg
Open browser page depending on XML results
Hello,
I have some PHP code that sends webbased from data to an external url ( in the form of
How to generate a random array of integers subject to a certain constraint
I am writing a program that asks the user to enter an integer N and then generates a random array of
Extracting URL pointer within XML tag
Hi.
I'm trying to extract text between two quotation marks in XML. For example, I want to ex
issues verifying if user is logged in
I am having issues when a user logs in via asp Login control, the IsAuthenticated still seems to com
Production Order Enterprise Service to Manufacturing Exctn Sys (MES) ???
Hello Experts,
In our current landscape SAP ECC 5.0 is integrated to MES system via PI 7.
reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos
multipart emiail forms
Hi All,
I am new to the boards and I've been working on a form (which is rather massive, imo
Creating Images from images in PHP
Okay well I am trying to make a 'dynamic' calender image with PHP.
I have images like this:
Selecting an "empty" date formated field
How do you select an "empty" date field? I've tried the few ways I can think.
SQL> select