Jump to content

Recommended Posts

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]

Link to comment
https://forums.phpfreaks.com/topic/172318-help-with-cms-needed/
Share on other sites

<?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

Link to comment
https://forums.phpfreaks.com/topic/172318-help-with-cms-needed/#findComment-908578
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.