Bojan86 Posted August 28, 2009 Share Posted August 28, 2009 I need hel with this cms... I'm noob when it comes to PHP, so I really need help... Anyway, I would like to delete some parts of code in every file... I would like to delete AVATAR and DESCRIPTION fields... I'll attach files, so if someone could do that for me, that would be great! P.S. Instead of AVATAR I would like to put some link, like Click here to view tutorial... [attachment deleted by admin] Quote Link to comment https://forums.phpfreaks.com/topic/172318-help-with-cms-needed/ Share on other sites More sharing options...
Bojan86 Posted August 28, 2009 Author Share Posted August 28, 2009 <?php //Getting the file db.php which includes our database settings. define( 'DB_PATH' , "" ); require DB_PATH."db.php"; // Setting up some variables $request_id = isset($_REQUEST['id']) ? $_REQUEST['id'] : ''; // Page: admin.php?act=addnew if (isset($_GET['act']) && $_GET['act'] == 'addnew') { echo " <form name='form' method='post' action='admin.php?act=addnew'> <table width='80%' border='0' cellspacing='3' cellpadding='0'> <tr> <td width='20%'>Name:</td> <td width='79%'> <input name='name' type='text' id='name' size='40'></td> </tr> <tr> <td>Avatar:</td> <td> <input name='avatar' type='text' id='avatar' value='http//' size='40'></td> </tr> <tr> <td>Category:</td> <td> <input name='category' type='text' id='category' value='Automatically makes new category' size='40'> </td> </tr> <tr> <td>Description:</td> <td> <input name='description' type='text' id='description' size='40'></td> </tr> <tr> <td>Author:</td> <td> <input name='author' type='text' id='author' size='40'></td> </tr> <tr> <td>Email:</td> <td> <input name='email' type='text' id='email' size='40'></td> </tr> <tr> <td>Content</td> <td> <textarea name='content' cols='65' rows='10'></textarea></td> </tr> <tr> <td><input name='submit' type='submit' id='submit' value='Submit'> <input name='reset' type='reset' id='reset' value='Reset'></td> <td>If you mess up, a edit link will be available on submit. </td> </tr> </table> </form>"; if (isset($_POST['submit'])) { $name = $_POST['name']; $avatar = $_POST['avatar']; $category = $_POST['category']; $description = $_POST['description']; $author = $_POST['author']; $email = $_POST['email']; $content = $_POST['content']; $date = date('m-d-Y'); if (!$name || !$avatar || !$category || !$description || !$author || !$email || !$content) { die ('Sorry, a field was left blank. Check all fields again!'); } else { mysql_query("INSERT INTO $mysql_table(id, title, avatar, date, category, description, author, email, content, views) VALUES('', '$name', '$avatar', '$date', '$category', '$description', '$author', '$email', '$content', '' ) " ) or die('Sorry, it failed'); echo "Success! You have added the tutorial <strong>$name</strong> to the category <strong>$category.</strong><br>What would you like to do?<br> <a href='?act=addnew'>Add a new tutorial</a> ---- <a href='?act=view'>Edit / Delete a previous tutorial</a>"; } } } // Page: admin.php?act=edit&id=## if (isset($_GET['act']) && $_GET['act'] == 'edit' && $_GET['id'] == $request_id) { $result = mysql_query("SELECT * FROM $mysql_table WHERE id='$request_id'"); while($row = mysql_fetch_array($result)){ echo " <form name='form' method='post''> <table width='80%' border='0' cellspacing='3' cellpadding='0'> <tr> <td width='20%'>Name:</td> <td width='79%'> <input name='name' type='text' id='name' ] value='".$row['title']."' size='40'></td> </tr> <tr> <td>Avatar:</td> <td><input name='avatar' type='text' id='avatar' value='".$row['avatar']."' size='40'></td> </tr> <tr> <td>Category:</td> <td> <input name='category' type='text' id='category' value='".$row['category']."' size='40'> </td> </tr> <tr> <td>Description:</td> <td> <input name='description' type='text' id='description' value='".$row['description']."' size='40'></td> </tr> <tr> <td>Author:</td> <td><input name='author' type='text' id='author' value='".$row['author']."' size='40'></td> </tr> <tr> <td>Email:</td> <td><input name='email' type='text' id='email' value='".$row['email']."' size='40'></td> </tr> <tr> <td>Content</td> <td><textarea name='content' cols='65' rows='10'> ".$row['content']."</textarea></td> </tr> <tr> <td><input name='submit' type='submit' id='submit' value='Edit'></td> <td></td> </tr> </table> </form> "; if (isset($_POST['submit'])) { $name = $_POST['name']; $avatar = $_POST['avatar']; $category = $_POST['category']; $description = $_POST['description']; $author = $_POST['author']; $email = $_POST['email']; $content = $_POST['content']; mysql_query("UPDATE $mysql_table SET title='$name', avatar='$avatar', category='$category', description='$description', author='$author', email='$email', content='$content' WHERE id='$request_id'") or die('Sorry, it failed'); echo "Success! Your tutorial has been edited.<br> What would you like to do?<br><a href='?act=addnew'> Add a new tutorial</a> ---- <a href='?act=view'> Edit / Delete a previous tutorial</a>"; } } } // Page: admin.php?act=delete&id=## if (isset($_GET['act']) && $_GET['act'] == 'delete' && $_GET['id'] == $request_id) { $result = mysql_query("SELECT * FROM $mysql_table WHERE id='$request_id'"); while($row = mysql_fetch_array($result)){ echo " <form action='?act=delete&id=".$row['id']."' method='post' name='form1'> Are you sure you want to delete the tutorial: <strong>".$row['title']."<strong>? <br> <input name='yes' type='checkbox' id='yes' value='checkbox'> Yes<br> <input name='no' type='checkbox' id='no' value='checkbox'> No <br> <input name='submit' type='submit' id='submit' value='Submit'> </form>"; } if (isset($_POST['submit'])){ if ($_POST['yes'] && $_POST['no']){ die('Error! : Are you trying to confuse me?'); } if ($_POST['yes']){ $result = mysql_query("SELECT * FROM $mysql_table WHERE id='$request_id'"); while($row = mysql_fetch_array($result)){ mysql_query("DELETE FROM $mysql_table WHERE id='$request_id'"); echo " Thanks, the tutorial <strong>".$row['title'].".</strong> has been deleted. <a href='?'>Click here</a> to continue. "; } } if ($_POST['no']){ die('<a href="?">Click here</a> to continue.'); } if (!$_POST['yes'] && !$_POST['no']){ die('Oops, you forgot to respond to my question.'); } } } // Page: admin.php?act=view if (isset($_GET['act']) && $_GET['act'] == 'view') { echo " <table width='700' border='0' cellspacing='0' cellpadding='0'> <tr> <td><strong>ID</strong></td> <td><strong>Name</strong></td> <td><strong>Author</strong></td> <td><strong>Category</strong></td> <td><strong>Edit / Delete</strong></td> </tr> "; $result = mysql_query("SELECT * FROM $mysql_table ORDER BY ID ASC"); while($row = mysql_fetch_array($result)){ echo " <tr> <td>".$row['id']."</td> <td>".$row['title']."</td> <td><a href='mailto:".$row['email']."'>".$row['author']."</a></td> <td>".$row['category']."</td> <td><a href='admin.php?act=edit&id=".$row['id']."'>Edit</a> / <a href='admin.php?act=delete&id=".$row['id']."'>Delete</a></td> </tr> "; } echo "</table>"; } // Page: admin.php if (!isset($_GET['act'])) { echo " What would you like to do?<br><a href='?act=addnew'> Add a new tutorial</a> ---- <a href='?act=view'>Edit / Delete a previous tutorial </a> "; } ?> This is first file... <?php $mysql_host = "localhost"; $mysql_user = "root"; $mysql_pass = ""; $mysql_data = "crap_cms"; $mysql_table = "tutorials"; // Feel free to change this to your liking... /* --Working some magic-- */ mysql_connect($mysql_host,$mysql_user,$mysql_pass) or die("Error connecting to Database! Please Try again. " . mysql_error()); mysql_select_db($mysql_data) or die("Cannot select database! Please Try again. " . mysql_error()); // ---------------------- // ?> This is connection between admin.php and database <?php //Getting the file db.php which includes our database settings. define( 'DB_PATH' , "./" ); require DB_PATH."db.php"; //Setting up a variable to request the category which is in the URL $request_cat = isset($_REQUEST['category']) ? $_REQUEST['category'] : ''; //Displaying an actual tutorial if (isset($_GET['id'])) { // Updating the views, and grabbing a tutorial based on what id it has. $update = mysql_query("UPDATE $mysql_table SET views = views + 1 WHERE id='{$_GET['id']}'"); $result = mysql_query("SELECT * FROM $mysql_table WHERE id='{$_GET['id']}'"); while($row = mysql_fetch_array($result)){ // Template for the tutorial echo " <table width='400' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='400'> <table width='400' border='0' cellspacing='0' cellpadding='0'> <tr> <td><table width='400' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='275'><div align='left'><strong> <a href='tutorials.php?category=".$row['category']."&id=".$row['id']." '>".$row['title']."</a> </strong></div></td> <td width='125'><div align='right'> [ Views: ".$row['views']." ]</div></td> </tr> </table></td> </tr> <tr> <td><div align='left'>Description: ".$row['description']."</div></td> </tr> <tr> <td><div align='left'>".$row['content']."</div></td> </tr> <tr> <td><div align='left'> <table width='400' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='150'><div align='left'>Added: ".$row['date']."</div> </td> <td><div align='right'>Author: <a href='mailto:".$row['email']."' >".$row['author']."</a> </div></td> </tr> </table> </div></td> </tr> <tr> <td><div align='left'>Category: <a href='tutorials.php?category=".$row['category']." >".$row['category']."</a> </div></td> </tr> </table></td> </tr> </table> "; // End of template of tutorial } // End of grabbing data exit(); // Stopping anything below from interfearing with this sectiom } // End of Displaying an actual tutorial //Displaying tutorials in a cateogry. if (isset($_GET['category']) && $_GET['category'] == $request_cat) { //Grabbing information from the database. $result = mysql_query("SELECT * from $mysql_table where category = '{$_GET['category']}' ORDER BY ID DESC"); while($row = mysql_fetch_array($result)) { //Template for the tutorials in a category. echo " <table width='400' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='100' align='center' valign='middle'><div align='center'> <a href='tutorials.php?category=".$row['category']."&id=".$row['id']."'> <img src='".$row['avatar']."' alt='".$row['title']."' title='".$row['title']."' width='90' height='60' border='0'></a> </div></td> <td width='300'> <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td> <div align='center'><strong>".$row['title']."</strong></div></td> </tr> <tr> <td> <div align='left'>Description: ".$row['description']."</div></td> </tr> <tr> <td> <table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td><div align='left'>Added: ".$row['date']."</div></td> <td><div align='left'>Category: <a href='tutorials.php?category=".$row['category']." >".$row['category']."</a></div></td> </tr> </table></td> </tr> <tr> <td><table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='175'><div align='left'>Author: <a href='mailto:".$row['email']."'>".$row['author']."</a></div></td> <td width='100'><div align='left'>Views: ".$row['views']."</div></td> </tr> </table></td> </tr> </table></td> </tr> </table><br> "; // End of Template for the tutorials in a category. } // End of grabbing information from database. } // End of Displaying tutorials in a cateogry. // Main Tutorial page. This is where all your categories will be listed. if (!isset($_GET['category'])) { //This makes a list of all the cateogries that are in the database! No need to make the links yourself! $result = mysql_query("SELECT DISTINCT category from $mysql_table "); while($row = mysql_fetch_array($result)) { // Showing all the categories echo " <a href='tutorials.php?category=".$row['category']."' >".$row['category']."</a><br> "; // End of showing all the categories } // End of grabbing unique categories in database }// End of main tutorial page ?> And third file, tutorial.php Quote Link to comment https://forums.phpfreaks.com/topic/172318-help-with-cms-needed/#findComment-908578 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.