I need a great tutorial on making a tutorial system with caragories. I need something like when they click the tutorials link, it takes them to a page where they can select a catagory, then when the select the caragory, it shows them tutorials, corresponding with that catagory. Thanks.
PHP TUtorial System
Started by
ShadowDeath01
, Jun 02 2006 10:48 PM
6 replies to this topic
#1
Posted 02 June 2006 - 10:48 PM
#2
Posted 02 June 2006 - 11:24 PM
Have fun:
http://www.pixel-des..._CMS_Script_v1/
Its old, but it gets the job done. Might need a lil tweaking for newer severs.
http://www.pixel-des..._CMS_Script_v1/
Its old, but it gets the job done. Might need a lil tweaking for newer severs.
#3
Posted 04 June 2006 - 07:13 AM
i haven't looked at it yet, but does it have catagories also?
#4
Posted 04 June 2006 - 11:06 AM
this tutorial is help ful, but when i go to admin, and click what i want to do, it dosen't do anything, it stays there. here is the code
<?php //Getting the file db.php which includes our database settings. include("dbconnect.php"); // Setting up some variables $request_id = $_REQUEST['id']; // Page: admin.php?act=addnew if ($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 ($_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 & #036;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 ($act == edit && $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 ($_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 ($act == delete && $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 ($_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 ($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 (!$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> "; } ?>
#5
Posted 04 June 2006 - 11:14 AM
Don't double post
Answered in the help section.
Answered in the help section.
#6
Posted 04 June 2006 - 03:46 PM
yeah man, i got it. i forgot i posted it here, well, i couldn't remember if i did, so i just say "hey i will post it anyway" lol
#7
Posted 04 June 2006 - 08:34 PM
Do you want something like the site im coding now?
tuts.cwhnetworks.com ? I can give you the source or something.
Email Me: [email protected]
tuts.cwhnetworks.com ? I can give you the source or something.
Email Me: [email protected]
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users