Много проста туториал система

Автор: SandPrince

Update: 24/Април/2007
От доста врме търся обикновенна и лесна за ползване система за уроци (туториали) и …. О,Боже най-накрая намерих. и тя е адски лесна и простичка!
Имаме само данаправим 3 таблици в БД и два php файла

Започваме с таблиците:

CREATE TABLE `tutorials` (
`id` INT(250) NOT NULL AUTO_INCREMENT,
`submitter` VARCHAR(250) NOT NULL,
`TEXT` TEXT NOT NULL,
`short_description` TEXT NOT NULL,
`title` VARCHAR(250) NOT NULL,
`cat_id` INT(25) NOT NULL,
`date_submitted` VARCHAR(250) NOT NULL,
`time_submitted` VARCHAR(250) NOT NULL,
`show_email` TINYINT(1) NOT NULL,
`email` VARCHAR(250) NOT NULL,
`views` INT(250) NOT NULL DEFAULT '0',
`is_validated` TINYINT(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `tutorials_categorys` (
`id` INT(25) NOT NULL AUTO_INCREMENT,
`category` VARCHAR(250) NOT NULL,
`description` TEXT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `tutorials_comments` (
`id` INT(250) NOT NULL AUTO_INCREMENT,
`tut_id` INT(250) NOT NULL,
`submitter` VARCHAR(250) NOT NULL,
`TEXT` TEXT NOT NULL,
`time_submitted` VARCHAR(250) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM ;

До тук добре!!!Сега да си направим и двата php файла:

tutorials.php – това е файла с който се пускат уроците

<?php
//------------------------------------------
//database connection
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
//end database connection
//------------------------------------------

//------------------------------------------
//echo out a navigation panel
echo "
<center><a href='tutorials.php'>View Categorys</a> | <a href='tutorials.php?action=addtutorial'>Add Tutorial</a></center>
";
//------------------------------------------

//------------------------------------------
//begin main navigation (tutorials.php?action=)

switch($_GET['action'])
{
//------------------------------------------
//this case adds a tutorial.
//pretty self-explanitory
//------------------------------------------
case "addtutorial":
//if the form to enter a new
//tutorial hasn't been submitted,
//show it
if(!isset($_POST['add_tutorial']))
{
echo "
<table border='0' cellpadding='0' cellspacing='0' width='500'>
<form action='$self?action=addtutorial' method='post'>
<tr>
<td>Name:</td>
<td><input type='text' name='name'></td>
</tr>
<tr>
<td>Title:</td>
<td><input type='text' name='title'></td>
</tr>
<tr>
<td>Category:</td>
<td>
<select name='category'>
";
//now what we are doing here is looping through
//the categorys table and getting all the
//categorys and putting them into a select
//so the user can select which category
//the tutorial is on
$query = mysql_query("SELECT * FROM tutorials_categorys ORDER BY id ASC") or die(mysql_error());
while($row = mysql_fetch_array($query))
{
echo "<option value='$row[id]'>$row[category]";
}
echo "
</select>
</td>
</tr>
<tr>
<td>Tutorial:</td>
<td><textarea name='tutorial' cols='40' rows='10'></textarea></td>
</tr>
</tr>
<tr>
<td>Short Description:</td>
<td><textarea name='short_description' cols='40' rows='2'></textarea></td>
</tr>
<tr>
<td>Email:</td>
<td><input type='text' name='email' maxlength='50'></td>
</tr>
<tr>
<td>Show Email?</td>
<td><input type='checkbox' name='show_email' value='1' checked></td>
</tr>
<tr>
<td colspan='2'><center><input type='submit' name='add_tutorial' value='Submit New Tutorial'></center></td>
</tr>
</form>
</table>
";
}
//else, error check, enter it
elseif(isset($_POST['add_tutorial']))
{
$name = mysql_real_escape_string(strip_tags($_POST['name']));
$title = mysql_real_escape_string(strip_tags($_POST['title']));
$category = mysql_real_escape_string(strip_tags($_POST['category']));
$tutorial = mysql_real_escape_string(strip_tags($_POST['tutorial']));
$short_description = mysql_real_escape_string(strip_tags($_POST['short_description']));
$email = mysql_real_escape_string(strip_tags($_POST['email']));
$show_email = mysql_real_escape_string($_POST['show_email']);
$date = date("m/d/Y");
$time = time();

//we begin error checking....
$error_msg = array();
if(empty($name))
{
$error_msg[] = "Please insert a name!<br />";
}
if(empty($title))
{
$error_msg[] = "Please insert a title!<br />";
}
if(empty($category))
{
$error_msg[] = "Please insert a category!<br />";
}
if(empty($tutorial))
{
$error_msg[] = "Please insert the tutorial text!<br />";
}
if(empty($short_description))
{
$error_msg[] = "Please insert a short description!<br />";
}
if(empty($email))
{
$error_msg[] = "Please insert an email!<br />";
}
//print the errors, if any
if(count($error_msg)>0)
{
echo "<strong>ERROR:</strong><br>n";
foreach($error_msg as $err)
echo "$err";
}
//everythings ok, insert it to the DB
else
{
$sql = "INSERT INTO tutorials (submitter, text, short_description, title, cat_id, date_submitted, time_submitted, show_email, email, is_validated) VALUES ('$name', '$tutorial', '$short_description', '$title', '$category', '$date', '$time', '$show_email', '$email', '0')";
mysql_query($sql) or die(mysql_error());
echo "Tutorial added for review!";
}
}
break;

//------------------------------------------
//this case gets the specified [ID] in the url
//(tutorials.php?action=viewcategory&id=[ID]
//and gets all the tutorials listed under that
//category ID (cat_id)
//------------------------------------------
case "viewcategory":
//if there is an ID given...
if($_GET['id'])
{
//get the id, put it into a variable, cast to an INT
//(for security purposes)
$id = (int)$_GET['id'];
$query = mysql_query("SELECT * FROM tutorials WHERE cat_id = '$id' AND is_validated = '1'") or die(mysql_error());

//if no results, show that there are no tutorials
//for that category
if(mysql_num_rows($query) == 0)
{
echo "No tutorials for this category yet!";
}
//else, there is..show em
else
{
echo "<h1>Tutorials</h1>";
//loop through the tutorials
//show all tutorials
echo "<table border='0' cellpadding='0' cellspacing='0' width='500'>";
while($row = mysql_fetch_array($query))
{
echo "
<tr>
<td>Title:</td>
<td><b>$row[title]</b></td>
</tr>
<tr>
<td>Date Submitted:</td>
<td><b>$row[date_submitted]</b></td>
</tr>
<tr>
<td>Views:</td>
<td>$row[views]</td>
</tr>
<tr>
<td>Short Description:</td>
<td>$row[short_description]</td>
</tr>
<tr>
<td>Submitter:</td>
<td>$row[submitter]</td>
</tr>
<tr>
<td colspan='2'><center><b><a href='$self?action=viewtutorial&id=$row[id]'>View</a></b></center></td>
</tr>
<tr>
<td colspan='2'><hr /></td>
</tr>
";
}
echo "</table>";
}
}
else
{
echo "Please give me a category ID!";
}
break;

//------------------------------------------
//this case gets the given [ID]
//action=viewtutorial&id=[ID]
//and gets that tutorial ID from the database
//and displays it!
//------------------------------------------
case "viewtutorial":
//if there is an ID given..
if($_GET['id'])
{
//set $id to the URL id, cast to an INT
//for security purposes
$id = (int)$_GET['id'];

//query the database
$query = mysql_query("SELECT * FROM tutorials WHERE id = '$id' LIMIT 1") or die (mysql_error());

//if no rows returned...
if(mysql_num_rows($query) == 0)
{
echo "That ID is not in the database!";
}
//else, show it!
else
{
//update the views for this tutorial!
$update_views = mysql_query("UPDATE tutorials SET views = views + 1 WHERE id = '$id'") or die(mysql_error());

//loop through the database
while($row = mysql_fetch_array($query))
{
echo "
<table border='0' cellpadding='0' cellspacing='0' width='500' style='border: 1px solid black; padding: 3px;'>
<tr>
<td colspan='2'>Tutorial: <b>$row[title]</b></td>
</tr>
<tr>
<td colspan='2' style='border: 1px solid black;'><center><b>Tutorial</b></center><br />$row[text]</td>
</tr>
<tr>
";
//----------------------------
//this part of the code
//checks to see if the submitter
//wants an email left for support
//----------------------------
if($row['show_email'] == 1)
{
echo "
<td colspan='2'>This tutorial was submitted by <b>$row[submitter]</b> with an email left for support questions. Contact this person <a href='mailto:$row[email]'>here</a></td>
";
}
echo "
</tr>
<tr>
<td><hr /></td>
</tr>
";
}
//--------------------------------
//this is where we loop through the
//comments table to show all the
//comments for this tutorial
//--------------------------------
$comments = mysql_query("SELECT * FROM tutorials_comments WHERE tut_id = '$id' ORDER BY id DESC") or die (mysql_error());

//if there are no comments..
if(mysql_num_rows($comments) == 0)
{
echo "
<tr>
<td colspan='2'>No comments for this tutorial yet!</td>
</tr>
";
}
//else, show them!
else
{
//loop through them
while($row = mysql_fetch_array($comments))
{
echo "
<tr>
<td colspan='2'>Comment by: <b>$row[submitter]</b></td>
</tr>
<tr>
<td colspan='2' style='border: 1px solid black; padding: 2px;' vAlign='top'>$row[text]</td>
</tr>
";
}
}
//show the form to enter comments
echo "
<tr>
<td colspan='2'><hr /></td>
</tr>
<form action='$self' method='post'>
<tr>
<td>Name:</td>
<td><input type='text' name='name' maxlength='25'></td>
</tr>
<tr>
<td>Comment:</td>
<td><textarea name='message' cols='40' rows='10'></textarea></td>
</tr>
<tr>
<td colspan='2'><center><input type='submit' name='add_comment' value='Add Comment'></center></td>
</tr>
</form>
";
//-----------------------------
//if the comment submit form
//HAS been submitted, enter info
//to the database.
//-----------------------------
if(isset($_POST['add_comment']))
{
//strip all HTML tags
//and get rid of any quotes to prevent
//SQL injection
$message = mysql_real_escape_string(strip_tags($_POST['message']));
$name = mysql_real_escape_string(strip_tags($_POST['name']));
$time = time();

//use an array to store all error messages
$error_msg = array();
if(empty($message))
{
$error_msg[] = "Please enter a message!<br />";
}
if(empty($name))
{
$error_msg[] = "Please enter a name!<br />";
}
//print the errors
if(count($error_msg)>0)
{
echo "<strong>ERROR:</strong><br>n";
foreach($error_msg as $err)
echo "$err";
}
//else, everything is ok, enter it in the DB
else
{
$query = mysql_query("INSERT INTO tutorials_comments VALUES (NULL,'$id','$name', '$message', '$time')") or die(mysql_error());
}
}
echo "</table>";
}
}
//if not..
else
{
echo "No ID specified!";
}
break;

//------------------------------------------
//default case, this is shown default
//in this instance, we are going to make the default case show
//all the categories that you can view tutorials on
//------------------------------------------
default:
$query = mysql_query("SELECT * FROM tutorials_categorys") or die(mysql_error());

//if the number of rows returned is 0, then say, no categories
if(mysql_num_rows($query) == 0)
{
echo "No tutorial categories currently!";
}
//if anything else, then there has to be categories. show em.
else
{
echo "<h1>Tutorial Categories:</h1> ";
//while loop to loop through the database and display results!
while($row = mysql_fetch_array($query))
{
echo "
<table border='0' cellpadding = '0' cellspacing='0' width='500'>
<tr>
<td>Category Name:</td>
<td>$row[category]</td>
</tr>
<tr>
<td>Description:</td>
<td>$row[description]</td>
</tr>
<tr>
<td><a href='$self?action=viewcategory&id=$row[id]'>Visit this category</a></td>
</tr>
<tr>
<td><hr /></td>
</tr>
</table>
";
}
}
break;
}
//end navigation
//------------------------------------------
?>

В реда

//------------------------------------------
//database connection
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
//end database connection
//------------------------------------------

си попълвате необходимите неща за да може да прави връзка с БД. това го има и в другия php файл така че и там трябва да направите същото.

tutorials_admin.php – това е файла за администрация на уроците

<?php
//------------------------------------------
//database connection
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
//end database connection
//------------------------------------------


//------------[IMPORTANT]-------------------
// I would suggest adding this file to part
// of a user system so it doesn't get viewed
// by just anyone
//------------[IMPORTANT]-------------------


//------------------------------------------
//echo out a navigation panel
echo "
<center><a href="tutorials.php">View Categorys</a> | <a href="tutorials.php?action=addtutorial">Add Tutorial</a> | <a href="tutorials_admin.php">Admin</a> | <a href="tutorials_admin.php?action=addcategory">Add Category</a></center>
";
//------------------------------------------

//------------------------------------------
//begin main navigation (tutorials.php?action=)
switch($_GET['action'])
{
//--------------------------
// case to add a tutorial category
//--------------------------
case "addcategory":
//if the form to add a new category
//isn't submitted, show one
if(!isset($_POST['new_category']))
{
echo "
<form action='tutorials_admin.php?action=addcategory' method='post'>
<table border='0' cellpadding='0' cellspacing='0' width='500'>
<tr>
<td>Category name:</td>
<td><input type='text' name='category' maxlength='25'></td>
</tr>
<tr>
<td>Description:</td>
<td><textarea name='description' cols='40' rows='10'></textarea></td>
</tr>
<tr>
<td colspan='2'><center><input type='submit' name='new_category' value='New Category!'></td>
</tr>
</table>
</form>
";
}
//else, error check and then insert data to database!
elseif(isset($_POST['new_category']))
{
$category = mysql_real_escape_string(strip_tags($_POST['category']));
$description = mysql_real_escape_string(strip_tags($_POST['description']));

//begin error reporting
$error_msg = array();
if(empty($category))
{
$error_msg[] = "No Category name entered!<br />";
}
if(empty($description))
{
$error_msg[] = "No description entered!<br />";
}
//print errors, if any
if(count($error_msg)>0)
{
echo "<strong>ERROR:</strong><br>n";
foreach($error_msg as $err)
echo "$err";
}
//else, no errors, insert to the DB!
else
{
$query = mysql_query("INSERT INTO tutorials_categorys (category, description) VALUES ('$category', '$description')") or die(mysql_error());
echo "Tutorial Category Added!";
}
}
break;

//--------------------------
//this case takes the submitted
//form data of the admin form.
//you can either validate, or delete
//--------------------------
case "handle":
//if nothing is submitted in the
//row[] array, then error!
if(empty($_POST['row']))
{
echo "Nothing to delete/validate!";
}
if(isset($_POST['delete_tutorials']))
{
$delete_array = $_POST['row'];

//loop through each individual
//item in the array

foreach($delete_array as $val)
{
//delete them!
$query = "DELETE FROM tutorials WHERE id = '$val'";
$result = mysql_query($query) or die(mysql_error());
}
echo "Tutorial(s) deleted";
}
elseif(isset($_POST['validate_tutorials']))
{
$validate_array = $_POST['row'];

//loop through each individual
//item in the array

foreach($validate_array as $val)
{
//update the status to 1 which means validated!
$query = "UPDATE tutorials SET is_validated = '1' WHERE id = '$val'";
$result = mysql_query($query) or die(mysql_error());
}
echo "Tutorial(s) validated!";
}
break;

//--------------------------
//default case, we show
//all tutorials with actions
//--------------------------
default:
$query = mysql_query("SELECT * FROM tutorials WHERE is_validated = '0' ORDER BY time_submitted DESC") or die(mysql_error());
echo "<h1>Unreviewed Tutorials</h1>";
if(mysql_num_rows($query) == 0)
{
echo "No tutorials unreviewed!";
}
//there are rows, show the tutorials to
//verify them
else
{
//echo the submit buttons
echo "
<form action='tutorials_admin.php?action=handle' method='post'>
<table border='0' cellpadding='0' cellspacing='0' width='500'>
<tr>
<td><center>With Selected</center></td>
</tr>
<tr>
<td colspan='2'><center><input type='submit' name='validate_tutorials' value='Validate'><input type='submit' name='delete_tutorials' value='Delete'></center></td>
</tr>
<tr>
<td colspan='2'><hr /></td>
</tr>
";
//loop throught it to show them all
while($row = mysql_fetch_array($query))
{
echo "
<tr>
<td>Title:</td>
<td>$row[title]</td>
</tr>
<tr>
<td>Submitter:</td>
<td>$row[submitter]</td>
</tr>
<tr>
<td>Short Description:</td>
<td>$row[short_description]</td>
</tr>
<tr>
<td>Tutorial Text:</td>
<td>$row[text]</td>
</tr>
<tr>
<td>Email:</td>
<td><a href='mailto:$row[email]'>$row[email]</a></td>
</tr>
<tr>
<td><b>Mark</b></td>
<td><input type='checkbox' name='row[]' value='$row[id]'></td>
</tr>
<tr>
<td colspan='2'><hr /></td>
</tr>
";
}
echo "
</table>
";
}
break;
}
?>

За да добавите категория на уроците ви трябва един много прост код който се добавя е БД.ето ви един примерен за няколко категории

INSERT INTO tutorials_categorys VALUES ('1', 'photoshop', '');
INSERT INTO tutorials_categorys VALUES ('2', 'php/mysql', '');
INSERT INTO tutorials_categorys VALUES ('3', 'html/css', '');
INSERT INTO tutorials_categorys VALUES ('4', 'javascript', '');
INSERT INTO tutorials_categorys VALUES ('5', 'phpBB/ipb tricks', '');
INSERT INTO tutorials_categorys VALUES ('6', 'flash & as', '');
INSERT INTO tutorials_categorys VALUES ('7', 'codes', '');
INSERT INTO tutorials_categorys VALUES ('8', 'Other', '');

Едно пояснение да добавя – когато е пуснат урок трябва да се влезне в админ панела на системата tutorials_admin.php и от там да се валидира(удостовери) урока за да може да се добави в списъка/категориите с уроци. от този админ панел можете да добавяте също и категории.
Това е!!! Системата за туториали (уроци) е готова!