Deletting from a database with php

by otfromtot Posted: 14 years ago 6 replies

<?php
$username="user";
$password="pass";
$database="db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM table";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<td>Date Entered</td>
<td>Referring Site</td>
<td>Name</td>
<td>Email Address</td>
<td>Phone Number</td>
<td>Type of Vehicle</td>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"date");
$f2=mysql_result($result,$i,"referrer");
$f3=mysql_result($result,$i,"first_name");
$f4=mysql_result($result,$i,"email");
$f5=mysql_result($result,$i,"phone");
$f6=mysql_result($result,$i,"vehicle_type_id1");
?>

<tr>
<td><?php echo $f1; ?></td>
<td><?php echo $f2; ?></td>
<td><?php echo $f3; ?></td>
<td><?php echo $f4; ?></td>
<td><?php echo $f5; ?></td>
<td><?php echo $f6; ?></td>
</tr>

<?php
$i++;
}
?>
</table>

All I wanted to do was automatically add a delete button column at the end of each query for easy editing. What would need to be done for this?

#programming #database #posting

WebThinker 14 years ago

<?php
$username="user";
$password="pass";
$database="db";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM table";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<td>Date Entered</td>
<td>Referring Site</td>
<td>Name</td>
<td>Email Address</td>
<td>Phone Number</td>
<td>Type of Vehicle</td>
<td>Delete</td>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"date");
$f2=mysql_result($result,$i,"referrer");
$f3=mysql_result($result,$i,"first_name");
$f4=mysql_result($result,$i,"email");
$f5=mysql_result($result,$i,"phone");
$f6=mysql_result($result,$i,"vehicle_type_id1");
?>

<tr>
<td><?php echo $f1; ?></td>
<td><?php echo $f2; ?></td>
<td><?php echo $f3; ?></td>
<td><?php echo $f4; ?></td>
<td><?php echo $f5; ?></td>
<td><?php echo $f6; ?></td>
<td><a href="delete.php?email=<?php echo $email;?>">Delete</a></td>
</tr>

<?php
$i++;
}
?>
</table>

and then you write a delete.php which delete a row for a given email address. However, this can be done ONLY if you have a unique email... otherwise, you'll loose consistency.
Usually you should have an ID field in each table.

I would let somebody else to make it, as this way looks quite deprecated.
- [ 1 ] Thanks
otfromtot 14 years ago

this is only for admin use, it doesn't need to be anything special. I just wanted other admins to be able to delete things when needed so that it doesn't have to be done by logging in through mysql. I can set it to delete through id, since there is an auto-increment id.
thank you though
- [1] reply
- cgimaster 14 years ago
  
  TIP: stop using mysql_* as it is a deprecated method and move on to either PDO or mysqli as suggested http://www.php.net/manual/en/function.mysql-query.php at the top on the red box.
  
  Also PDO and mysqli offer extra security for querying the database to protect yourself against injection and other malicious actions that can occur.
  
  [ 1 ] Thanks
  
  [1] reply
otfromtot 14 years ago

cgimaster,
That's something I'll have to look in to, thank's for the tips. I hadn't seen anything on those until now, and hope to be able to implement it soon.

Join the discussion

Next Topics on Trending Feed

8

Deletting from a database with php

otfromtot • 14 years ago • 6 replies

<?php $username="user"; $password="pass";