You are here: Adding a DELETE/UPDATE option to my results « PHP SQL « IT news, forums, messages
Adding a DELETE/UPDATE option to my results

Posted by mpar612 on 08/07/06 16:34

Hi everyone,

My code is posted below. I am trying to add update and delete buttons
at the end of each row returned from the database. I understand the
use of the DELETE and UPDATE query, but I'm confused about how to
implement them in my code using PHP. I searched multiple forums and
made an attempt in lines 5 and 6 to try to implement the DELETE
feature, but I'm sort of lost. Any help or tips would be greatly
appreciated. Thanks in advance!

<?php

// Access the global variable $db inside this function
global $db;

$delete = 'DELETE FROM lounge WHERE isbn = $ROW[\'isbn\']';
$del_query = $db->($delete);


// build up the query
$sql = 'SELECT isbn, artist_name, album_title,
date_format(release_date, \'%M %d, %Y\') as release_date,
date_format(add_date, \'%M %d, %Y\') as add_date, description, price
FROM lounge';

// Send the query to the database program and get all the rows back
$results = $db->getAll($sql);

print '<table border=\'1\' cellspacing=\'0\'
cellpadding=\'0\'>';
print '<tr><th>ISBN</th><th>Artist Name</th><th>Album
Title</th><th>Release
Date</th><th>Description</th><th>Price</th><th>Date
Added</th><th>Update</th><td>Delete</th></tr>';
foreach ($results as $res) {
printf('<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>',
htmlentities($res->isbn),
htmlentities($res->artist_name),
htmlentities($res->album_title),
htmlentities($res->release_date),
htmlentities($res->description),
htmlentities($res->price),
$res->add_date,
)
;
}
?>

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация