Help on touching up Admin

dannbkk Well-Known Member

Messages:: 1,403

Likes Received:: 19

Best Answers:: 0

Trophy Points:: 120

#1

I have put together this code from one of the tutorials found here http://www.php-mysql-tutorial.com/cms-admin-php-mysql.php
and so far have this working;

cms-admin.php

<?php
require_once('db.inc.php');
if(isset($_GET['del']))
{
// remove the article from the database
$query = "DELETE FROM news WHERE id = '{$_GET['del']}'";
mysql_query($query) or die('Error : ' . mysql_error());

// then remove the cached file
$cacheDir = dirname(__FILE__) . '/cache/';
$cacheFile = $cacheDir . '_' . $_GET['id'] . '.html';

@unlink($cacheFile);

// and remove the index.html too because the file list
// is changed
@unlink($cacheDir . 'index.html');

// redirect to current page so when the user refresh this page
// after deleting an article we won't go back to this code block
header('Location: ' . $_SERVER['PHP_SELF']);
exit;
}
?>
<html>
<head>
<title>Admin Page For Content Management System (CMS)</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
function delArticle(id, title)
{
if (confirm("Are you sure you want to delete '" + title + "'"))
{
window.location.href = 'cms-admin.php?del=' + id;
}
}
</script>
</head>

<body>
<?php
$query = "SELECT id, title FROM information ORDER BY id";
$result = mysql_query($query) or die('Error : ' . mysql_error());
?>
<table width="600" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#999999">
<tr align="center" bgcolor="#CCCCCC">
<td width="500"><strong>Title</strong></td>
<td width="150"><strong>Action</strong></td>
</tr>
<?php
while(list($id, $title) = mysql_fetch_array($result, MYSQL_NUM))
{

?>
<tr bgcolor="#FFFFFF">
<td width="500">
<?php echo $title;?>
</td>
<td width="150" align="center"><a href="article2.php?id=<?php echo $id;?>" target="_blank">view[/url]
| <a href="cms-edit.php?id=<?php echo $id;?>">edit[/url] | <a href="javascript:delArticle('<?php echo $id;?>', '<?php echo $title;?>');">delete[/url]</td>
</tr>
<?php
}

include 'library/closedb.php';
?>
</table>
<p align="center"><a href="cms-add.php">Add an article[/url]</p>
</body>
</html>
Click to expand...

I need to edit the code to suit my datasbe which has 3 tables 1 table has an image file, which will involve uploading images, how can I add this code to suit?

Kindly awaiting suggestions and possible help on code!

dannbkk, May 25, 2007 IP

projectshifter Peon

Messages:: 394

Likes Received:: 7

Best Answers:: 0

Trophy Points:: 0

#2

You need to be a little more specific with what you're wanting, I'm not really understanding.

projectshifter, May 25, 2007 IP

dannbkk Well-Known Member

Messages:: 1,403

Likes Received:: 19

Best Answers:: 0

Trophy Points:: 120

#3

Ok I have put together the code successfully from the tutorial link above, but I am stuck with adding image upload option to one of my tables in php.

This is what I have done so far but it doesnt seem to be uploading?

<html>
<head>
<title>Add An Article</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

</style>
</head>

<body>
<?php
require_once('db.inc.php');
if(isset($_POST['save']))
{
$title = $_POST['title'];
$content = $_POST['content'];
$images = $_POST['images'];

if(!get_magic_quotes_gpc())
{
$title = addslashes($title);
$content = addslashes($content);
$images = addslashes($images);
}

$query = "INSERT INTO events (title, content, images) VALUES ('$title', '$content', 'images')";
mysql_query($query) or die('Error ,query failed');

echo "Article '$title' added";
}
?>
<FORM ACTION="upload.php" METHOD="post" ENCTYPE="multipart/form-data">
<table width="700" border="0" cellpadding="2" cellspacing="1" class="box" align="center">
<tr>
<td width="100">Title</td>
<td><input name="title" type="text" class="box" id="title"></td>
</tr>
<tr>
<td width="100">Content</td>
<td><textarea name="content" cols="50" rows="10" class="box" id="content"></textarea></td>
</tr>
<tr>
<td width="100">Image</td>
<td><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0" WIDTH="34%" HEIGHT="75">

<TR>
<TD WIDTH="6%" HEIGHT="24" BGCOLOR="silver"> </TD>
<TD WIDTH="88%" HEIGHT="24" BGCOLOR="#FFFFFF"><P ALIGN="CENTER">
<INPUT TYPE="file" NAME="fileupload" SIZE="30">
</TD>
<TD WIDTH="6%" HEIGHT="24" BGCOLOR="#FFFFFF"> </TD>
</TR>
<TR>
<TD HEIGHT="24" COLSPAN="3" BGCOLOR="#FFFFFF"><CENTER>
<P>
<INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Upload File">
</CENTER></TD>
</TR>
</TABLE></td>
</tr>
<tr>
<td colspan="2" align="center"><input name="save" type="submit" class="box" id="save" value="Save Article"></td>
</tr>
</table>
</form>
</body>
</html>
Click to expand...

dannbkk, May 25, 2007 IP

Paris Holley Peon

Messages:: 27

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#4

here is a tutorial for you that should help

phpfreaks.com/tutorials/36/0.php

Paris Holley, May 25, 2007 IP

dannbkk Well-Known Member

Messages:: 1,403

Likes Received:: 19

Best Answers:: 0

Trophy Points:: 120

#5

Thanks, nice tutorial,

But now when i try to upload the file doesnt go inside the folder?

It gives me error message when I try to upload - "Could Not Copy, Wrong Filetype"

Any suggestions on alter of code here please....

<html>
<head>
<title>Add An Article</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

</style>
</head>

<body>
<?php
require_once('db.inc.php');
if(isset($_POST['save']))
{
$title = $_POST['title'];
$content = $_POST['content'];
$image = $_POST['image'];

if(!get_magic_quotes_gpc())
{
$title = addslashes($title);
$content = addslashes($content);
$image = addslashes($image);
}

$query = "INSERT INTO events (title, content, image) VALUES ('$title', '$content', '$image')";
mysql_query($query) or die('Error ,query failed');

echo "Article '$title' added";
}
?>
<form method="post">
<table width="700" border="0" cellpadding="2" cellspacing="1" class="box" align="center">
<tr>
<td width="100">Title</td>
<td><input name="title" type="text" class="box" id="title"></td>
</tr>
<tr>
<td width="100">Content</td>
<td><textarea name="content" cols="50" rows="10" class="box" id="content"></textarea></td>
</tr>
<tr>
<td width="100"> </td>
<td><input type="file" name="imagefile">
<br>
<input type="submit" name="Submit" value="Submit">
<?
if(isset( $Submit ))
{
//If the Submitbutton was pressed do:

if ($_FILES['imagefile']['type'] == "image/jpg"){
copy ($uploaddir.$_FILES['imagefile']['tmp_name'], "files/".$_FILES['imagefile']['name'])
or die ("Could not copy");
echo "";
echo "Name: ".$_FILES['imagefile']['name']."";
echo "Size: ".$_FILES['imagefile']['size']."";
echo "Type: ".$_FILES['imagefile']['type']."";
echo "Copy Done....";
}

else {
echo "<br><br>";
echo "Could Not Copy, Wrong Filetype (".$_FILES['imagefile']['name'].")<br>";
}
}

?></td>
</tr>
<tr>
<td colspan="2" align="center"><input name="save" type="submit" class="box" id="save" value="Save Article"></td>
</tr>
</table>
</form>
</body>
</html>
Click to expand...

dannbkk, May 25, 2007 IP

dannbkk Well-Known Member

Messages:: 1,403

Likes Received:: 19

Best Answers:: 0

Trophy Points:: 120

#6

any chance I could get someone to help me on this one...

dannbkk, May 26, 2007 IP

projectshifter Peon

Messages:: 394

Likes Received:: 7

Best Answers:: 0

Trophy Points:: 0

#7

If you can't get anyone to help you, feel free to hit me up on a messenger in about 12 hours (just about to go to bed) and I'll be glad to take a look. I have this bad inability to read large blocks of code unless it's in a notepad window lol.

projectshifter, May 26, 2007 IP

dannbkk Well-Known Member

Messages:: 1,403

Likes Received:: 19

Best Answers:: 0

Trophy Points:: 120

#8

Thankyou for your genourous offer, I have added you to my msn and have been quietly hoping you could get back to me? Your status has been set to away for the past 2 or so days.

Awaiting reply thankyou

dannbkk, May 28, 2007 IP

gandaliter Peon

Messages:: 64

Likes Received:: 0

Best Answers:: 0

Trophy Points:: 0

#9

Firstly, what is the code of db.inc.php, secondly, when it echos the error message, could you change $_FILES['imagefile']['name'] to $_FILES['imagefile']['type'] and post the results here

gandaliter, May 29, 2007 IP

dannbkk Well-Known Member

Messages:: 1,403

Likes Received:: 19

Best Answers:: 0

Trophy Points:: 120

#10

problem now solved thankyou all

dannbkk, Jun 5, 2007 IP

Log in or Sign up

Help on touching up Admin

dannbkk Well-Known Member

projectshifter Peon

dannbkk Well-Known Member

Paris Holley Peon

dannbkk Well-Known Member

dannbkk Well-Known Member

projectshifter Peon

dannbkk Well-Known Member

gandaliter Peon

dannbkk Well-Known Member

Useful Searches