Help with CMS needed!!!

Bojan86 · August 8, 2009

This is not working... Can't connect link with form... Help please! :facewall:

<?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 = $_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>
";
}
?>

This would be first code... Second is for connecting to database.

<?php

$mysql_host = "localhost";

$mysql_user = "root";

$mysql_pass = "";

$mysql_data = "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());
// ---------------------- //
?>

And finally...

<?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 = $_REQUEST['category'];


//Displaying an actual tutorial
if (isset($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='$id'");
$result = mysql_query("SELECT * FROM $mysql_table
WHERE id='$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 ($category == $request_cat) {

//Grabbing information from the database.
$result = mysql_query("SELECT * from $mysql_table
where category = '$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 (!$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

?>

I found this tutorial here: http://www.pixel-designz.net/tutorials/view/4/Advanced_Tutorial_CMS_Script_v1/1/

wildteen88 · August 8, 2009

Looking at the first code block. You should change all instances of $act to $_GET['act']

For the third block the the variables $id and $category need to be $_GET['id'] and $_GET['category']

Sorry to rant but you can hardly call that a tutorial. All it teaches you is how to copy 'n paste, not how to code. Did you understand the code? If the author of the tutorial doesn't take the time to explain the code then I wouldn't read it. The code is poorly put together and insecure. I'm not surprised it doesn't work. Sorry to rant.

Bojan86 · August 8, 2009

Looking at the first code block. You should change all instances of $act to $_GET['act']

For the third block the the variables $id and $category need to be $_GET['id'] and $_GET['category']

Sorry to rant but you can hardly call that a tutorial. All it teaches you is how to copy 'n paste, not how to code. Did you understand the code? If the author of the tutorial doesn't take the time to explain the code then I wouldn't read it. The code is poorly put together and insecure. I'm not surprised it doesn't work. Sorry to rant.

That's OK... I need this as project for school so I don't bother much with learning... I work with Flash, so PHP is basics only...

Bojan86 · August 8, 2009

Um... This is not working... I can't save any of my data in database... Why? :'(

wildteen88 · August 8, 2009

Add the following two lines at the top of all your scripts (except db.php) after the <?php tag

error_reporting(E_ALL);
ini_set('display_errors', 'on');

Errors should display if there are any problems. Post the errors you get here.

Bojan86 · August 8, 2009

Notice: Undefined index: id in C:\wamp\www\cms\admin.php on line 9

Notice: Use of undefined constant addnew - assumed 'addnew' in C:\wamp\www\cms\admin.php on line 12

Notice: Undefined index: submit in C:\wamp\www\cms\admin.php on line 61

Notice: Use of undefined constant edit - assumed 'edit' in C:\wamp\www\cms\admin.php on line 93

Notice: Use of undefined constant delete - assumed 'delete' in C:\wamp\www\cms\admin.php on line 169

Notice: Use of undefined constant view - assumed 'view' in C:\wamp\www\cms\admin.php on line 220

Notice: Undefined variable: act in C:\wamp\www\cms\admin.php on line 248

wildteen88 · August 8, 2009

I have gone through the code and adjusted it so it works.

[attachment deleted by admin]

Bojan86 · August 8, 2009

I have gone through the code and adjusted it so it works.

Thanks man/woman... God bless you!

Sign In

Help with CMS needed!!!

Recommended Posts

Bojan86

Link to comment

Share on other sites

wildteen88

Link to comment

Share on other sites

Bojan86

Link to comment

Share on other sites

Bojan86

Link to comment

Share on other sites

wildteen88

Link to comment

Share on other sites

Bojan86

Link to comment

Share on other sites

wildteen88

Link to comment

Share on other sites

Bojan86

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information