Results from the most recent live auction are here .
25 members in the live chat room. Join Chat !
· #1 Senior Member
Name: Ray
Location: iCue.mobi
Join Date: Jan 2006
Posts: 2,004
NP$: 31.90 (
Donate )
Php help needed I have a very basic directory site in which people submit their sites too.
I have a very simple backend (admin.php) in which I can approve submitted links and then they get installed in the mysql database. The backend does not have any way to delete the links that I do not want. I can only approve the links.
Currently I have to approve the unwanted links and then, I log into cpanel and access the database and find the unwanted link and delete it. I need to add some code to my admin.php but am lacking the expertise to do this. Do I need to hire a php coder or is their a couple lines of code I can add?
Heres the php code I currently have in my admin.php
PHP Code:
<?
();
?>
<style>
<?php
include( "config.php" );
$a = $_GET [ 'action' ];
$c = $_COOKIE [ 'xxxx' ];
$admin_pass = "xxxxxxxxxxxxxxx" ;
$c != "" ) {
"<b>Admin</b><p>" ;
"<a href='admin.php?action=approve'>Approve Links</a><p>" ;
"<a href='/'>HOME</a><p>" ;
$a == "" ) {
"Please choose a section from above!" ;
$a == "approve" ) {
"<table border=0 cellpadding=2 cellspacing=0 width=100%>
;
$sql = mysql_query ( "SELECT * FROM `directory` WHERE `approved`='0'" );
$row = mysql_fetch_array ( $sql )) {
extract ( $row );
$sql2 = mysql_query ( "SELECT * FROM `directory_cats` WHERE `id`='$category'" );
$row2 = mysql_fetch_array ( $sql2 )) {
$category_name = $row2 [ "category" ];
"<tr>
;
"</table>" ;
$a == "app" ) {
$id = $_GET [ 'id' ];
$id ) {
mysql_query ( "UPDATE `directory` SET `approved`='1' WHERE `id`='$id'" );
Header ( "Location: admin.php?action=approve" );
$p = $_POST [ 'password' ];
$p != "" ) {
$p == $admin_pass ) {
setcookie ( "xxxx" , "xxxx" , time ()+ 3600 )) {
Header ( "Location: admin.php" );
"Cant Set Cookie" ;
"Wrong Password" ;
?>
<form action="admin.php" method="post">
<?
}
?>
· #2 Stranger
Location: in a strange land
Join Date: Mar 2007
Posts: 1,304
NP$: 594.28 (
Donate )
Something like this should do the job:
( untested, please back up your database before using )
PHP Code:
<?
();
?>
<style>
<?php
include( "config.php" );
$a = $_GET [ 'action' ];
$c = $_COOKIE [ 'xxxx' ];
$admin_pass = "xxxxxxxxxxxxxxx" ;
$c != "" ) {
"<b>Admin</b><p>" ;
"<a href='admin.php?action=approve'>Approve Links</a><p>" ;
"<a href='/'>HOME</a><p>" ;
$a == "" ) {
"Please choose a section from above!" ;
$a == "delete" && isset( $_GET [ 'id' ]) )
$id = $_GET [ 'id' ];
is_numeric ( $id ) )
mysql_query ( "DELETE FROM `directory` WHERE `id`='$id' LIMIT 1" );
$a = "approve" ;
$a == "approve" ) {
"<table border=0 cellpadding=2 cellspacing=0 width=100%>
;
$sql = mysql_query ( "SELECT * FROM `directory` WHERE `approved`='0'" );
$row = mysql_fetch_array ( $sql )) {
extract ( $row );
$sql2 = mysql_query ( "SELECT * FROM `directory_cats` WHERE `id`='$category'" );
$row2 = mysql_fetch_array ( $sql2 )) {
$category_name = $row2 [ "category" ];
"<tr>
;
"</table>" ;
$a == "app" ) {
$id = $_GET [ 'id' ];
$id ) {
mysql_query ( "UPDATE `directory` SET `approved`='1' WHERE `id`='$id'" );
Header ( "Location: admin.php?action=approve" );
$p = $_POST [ 'password' ];
$p != "" ) {
$p == $admin_pass ) {
setcookie ( "xxxx" , "xxxx" , time ()+ 3600 )) {
Header ( "Location: admin.php" );
"Cant Set Cookie" ;
"Wrong Password" ;
?>
<form action="admin.php" method="post">
<?
}
?>
Last edited by -NC- : 05-12-2008 at 12:08 AM .
· #3 NamePros Regular
Join Date: Jun 2007
Posts: 609
NP$: 13.30 (
Donate )
That is very unsecure code...
All I would need to do is find out the name of the cookie and im in.
· #4 I'll do it
Name: Keral. Patel.
Location: India
Join Date: Dec 2005
Posts: 5,233
NP$: 9941.05 (
Donate )
Just delete the login stuff and put this admin.php into some folder called "admin"
· #5 Senior Member
Name: Ray
Location: iCue.mobi
Join Date: Jan 2006
Posts: 2,004
NP$: 31.90 (
Donate )
NC thanks for the help. I still can not get this to work. I really do appreciate your help tho.
The original developer, of the site, saw this thread and has contacted and offered assistance!
Nick, I took your advice and secured the admin.php file in a password protected folder.
I would have never thought about this - but its a great tip!
It may be oldhat too some, but tips like this are very helpful to us who are still learning...
· #6 I'll do it
Name: Keral. Patel.
Location: India
Join Date: Dec 2005
Posts: 5,233
NP$: 9941.05 (
Donate )
Originally Posted by texasgamer Nick, I took your advice and secured the admin.php file in a password protected folder.
I would have never thought about this - but its a great tip!
It may be oldhat too some, but tips like this are very helpful to us who are still learning...
Thanks. Happens to me all the time when I am only looking at the cream floating on the glass and assume its filled with milk. Without knowing it could be water on which the cream is floating
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
Php help needed 
All I would need to do is find out the name of the cookie and im in.
Thanks. Happens to me all the time when I am only looking at the cream floating on the glass and assume its filled with milk. Without knowing it could be water on which the cream is floating 
