Full Version: PHP TUtorial System
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.
Have fun:
http://www.pixel-designz.net/tutorials/vie..._CMS_Script_v1/
Its old, but it gets the job done. Might need a lil tweaking for newer severs.
http://www.pixel-designz.net/tutorials/vie..._CMS_Script_v1/
Its old, but it gets the job done. Might need a lil tweaking for newer severs.
i haven't looked at it yet, but does it have catagories also?
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
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>
";
}
?>
//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>
";
}
?>
Don't double post 
Answered in the help section.
Answered in the help section.
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
Do you want something like the site im coding now?
tuts.cwhnetworks.com ? I can give you the source or something.
Email Me: dementedfloppy@gmail.com
tuts.cwhnetworks.com ? I can give you the source or something.
Email Me: dementedfloppy@gmail.com
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.