6 replies to this topic

[ShadowDeath01]

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.

[Chaos King]

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.

[ShadowDeath01]

i haven't looked at it yet, but does it have catagories also?

[ShadowDeath01]

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> &nbsp; ----&nbsp; 
<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> &nbsp; ----&nbsp; <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> &nbsp; ----&nbsp; 
<a href='?act=view'>Edit / Delete a previous tutorial </a>
";
}
?>

[Matthew.]

Don't double post

Answered in the help section.

[ShadowDeath01]

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

[Nerve]

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