rockon Posted October 28, 2009 Share Posted October 28, 2009 Hey guys, I'm running a lyrics website from a script I bought. There is an admin section where it lists all tracks that have been submitted by a user via the front end submit form. They are put in to a database called "pending lyrics". On the admin section I have to press 'approve' or 'decline' for each individual lyric (there's 300+ at the moment). I believe the lyrics are disseminated in to the correct tables when approved. I have attached a screenshot of what I describe above. Below is the page script for all of that functionality. What i'd like to be able to do is press a button that says "approve all". So it approves each individual track all together. <?php include_once("../config.inc.php"); include_once("../db_connect.php"); $ptitle = "Approve New Lyrics"; $meta_keys = ""; $meta_desc = ""; $selected = "ADMIN"; include("../header.php"); $approve = $_REQUEST['approve']; $decline = $_REQUEST['decline']; $item = $_REQUEST['item']; if($approve) { $get_info = mysql_query("SELECT * FROM pendinglyrics WHERE id = ".$item." LIMIT 1"); $artist = mysql_result($get_info, 0, artist); $track = mysql_result($get_info, 0, track); $album = mysql_result($get_info, 0, album); $lyrics = mysql_result($get_info, 0, lyrics); $dateadded = mysql_result($get_info, 0, dateadded); $insert = mysql_query("INSERT INTO tracks (artist, title, album, dateadded) VALUES ('".$artist."', '".$track."', '".$album."', '".$dateadded."')"); if($insert) { $trackid = mysql_insert_id(); $insert2 = mysql_query("INSERT INTO lyrics (trackid, lyrics) VALUES (".$trackid.", '".formatField($lyrics)."')"); if($insert2) $delete = mysql_query("DELETE FROM pendinglyrics WHERE id = ".$item." LIMIT 1"); } } elseif($decline) { $delete = mysql_query("DELETE FROM pendinglyrics WHERE id = ".$item." LIMIT 1"); } $pending = mysql_query("SELECT * FROM pendinglyrics ORDER BY dateadded LIMIT 300"); ?> <table width="100%" cellspacing="5" cellpadding="0"> <tr> <td valign="top"> <?php echo "<b>Approve New Lyrics:</b><br><br>"; echo "Listed below are all the pending lyrics on the system. Choose the relevant option next to each item to approve or remove the lyrics.<br><br>"; ?> </td> </tr> </table> <?php echo "<table width='100%' cellspacing='0' cellpadding='0'>"; if(mysql_numrows($pending) > 0) { $tracker = $start+1; while($row = mysql_fetch_array($pending)) { echo "<form method='POST' action='index.html'><input name='item' type='hidden' value='".$row[id]."'><tr><td width='40' align='right'><b>".$tracker.".</b> </td><td class='listingtitle'><b>".$row[track]."</b> by <b>".$row[artist]."</b></td><td rowspan='2' width='150'><input name='approve' value='approve' type='submit'> <input name='decline' value='decline' type='submit'></td></tr></form>"; echo "<tr><td></td><td>".trim(substr(stripslashes($row[lyrics]), 0, 120))."... <a href='viewitem.html?j=".$row[id]."' class='morelink'>view lyrics</a><br><br></td></tr>"; $tracker++; } } else echo "<tr><td><br> <b>There are currently no pending lyrics.</b><br><br></td></tr>"; echo "</table>"; ?> <?php include("../footer.php"); ?> Anyone got any ideas on whether this is possible? And if so, how to do it? Complete novice over here! Looking forward to your thoughts! Thanks, [attachment deleted by admin] Link to comment https://forums.phpfreaks.com/topic/179334-approve-all-button-for-lyrics-admin-script/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.