Admin edit/delete

JackASmith

Hello,

I am quite new to php and I need to create an admin feature to edit and delete posts to this database:

http://xs.netdojo.com/viewdata.php

However, the only setback is I haven't a clue how to do this.

If anyone can help me, it would be very much appreciated.

Sxooter

Try this code (it's written for Postgresql, but should be easy enough to convert to MySQL if that's what you're using.)

<HTML><HEAD><TITLE>Simple Editor</TITLE>
<BODY bgcolor="white">
<?php
$table = "tablename";
$conn = pg_connect("dbname=dbname user=username host=hostname");
if (!isset($action)) $action="";

if ($action=="Change"){
        $query = "select * from $table limit 1";
        $res = pg_exec($conn,$query);
        $query = "update $table set ";
        $field_count = pg_numfields($res);
        for ($i=0;$i<$field_count;$i++){
                if ($i>0) $query.=", ";
                $fn = pg_fieldname($res,$i);
                $query.= "$fn='";
                $query.= $$fn;
                $query.= "'";
        }
        $query.= " where ";
        $key =  pg_fieldname($res,0);
        $query.= "$key = '";
        $query.= $$key;
        $query.="'";
        $res2 = pg_exec($conn,$query);
} else if ($action=="Delete"){
        $query = "select * from $table limit 1";
        $res = pg_exec($conn,$query);
        $key = pg_fieldname($res,0);
        $query = "delete from $table where $key='";
        $query.= $$key;
        $query.="'";
        pg_exec($conn,$query);
} else if ($action=="Add"){
        $query = "select * from $table limit 1";
        $res = pg_exec($conn,$query);
        $query = "insert into $table (";
        $field_count = pg_numfields($res);
        for ($i=0;$i<$field_count;$i++){
                if ($i>0) $query.=", ";
                $key = pg_fieldname($res,$i);
                $query.= $key;
        }
        $query.= ") values (";
        for ($i=0;$i<$field_count;$i++){
                if ($i>0) $query.=", ";
                $key = pg_fieldname($res,$i);
                $query.= "'".$$key."'";
        }
        $query.=")";
        pg_exec($conn,$query);
}
$query = "select * from $table order by 1";
$res = pg_exec($conn,$query);
print "<TABLE border=\"1\">\n<TR>";
$field_count = pg_numfields($res);
for ($i=0;$i<$field_count;$i++){
        print "<TH>";
        print pg_fieldname($res,$i);
        print "</TH>";
}
print "</TR>\n";
print "<TR>";
print "<form method=\"post\" name\"comp_edit\">\n";
for ($j=0;$j<$field_count;$j++){
        print "<TD><input type=\"text\" name=\"";
        print pg_fieldname($res,$j);
        print "\"></TD>\n";
}
print '<TD><input name="action" type="submit" value="Add"></TD>';
print "</form>\n";
$row_count = pg_numrows($res);
for ($i=0;$i<$row_count;$i++){
        print "<TR>\n";
        print "<form method=\"post\" name\"comp_edit\">\n";
        for ($j=0;$j<$field_count;$j++){
                print "<TD><input type=\"text\" name=\"";
                print pg_fieldname($res,$j);
                print "\" value=\"";
                print pg_result($res,$i,$j);
                print "\"></TD>\n";
        }
        print '<TD><input name="action" type="submit" value="Change"></TD>';
        print '<TD><input name="action" type="submit" value="Delete"></TD>';
        print '<input type="hidden" name="old_field0" value="';
        print pg_result($res,$i,0);
        print '">';
        print "</form>\n";
}
print "</TABLE>\n";
?>
</BODY></HTML>

JackASmith

I can't seem to convert it to MySQL....if anyone could help with that...

Sxooter

The only code you might need to add is a mysql_select_db() to pick your database. Other than that a search and replace of mysql_query for pg_exec etc... should do it. If I get a minute I might do the conversion this afternoon.

The basic code is a pretty good start, as it's completely abstract (i.e. it gets the name of each field from the database etc... doesn't store them locally.)

Sxooter

OK, here it is converted to MySQL:

<HTML><HEAD><TITLE>Simple Editor</TITLE>
<BODY bgcolor="white">
<?php
$table = "edit";
$conn = mysql_connect("localhost");
mysql_select_db("test");
if (!isset($action)) $action="";

if ($action=="Change"){
        $query = "select * from $table limit 1";
        $res = mysql_query($query);
        $query = "update $table set ";
        $field_count = mysql_num_fields($res);
        for ($i=0;$i<$field_count;$i++){
                if ($i>0) $query.=", ";
                $fn = mysql_field_name($res,$i);
                $query.= "$fn='";
                $query.= $$fn;
                $query.= "'";
        }
        $query.= " where ";
        $key =  mysql_field_name($res,0);
        $query.= "$key = '";
        $query.= $$key;
        $query.="'";
        $res2 = mysql_query($query);
} else if ($action=="Delete"){
        $query = "select * from $table limit 1";
        $res = mysql_query($query);
        $key = mysql_field_name($res,0);
        $query = "delete from $table where $key='";
        $query.= $$key;
        $query.="'";
        mysql_query($query);
} else if ($action=="Add"){
        $query = "select * from $table limit 1";
        $res = mysql_query($query);
        $query = "insert into $table (";
        $field_count = mysql_num_fields($res);
        for ($i=0;$i<$field_count;$i++){
                if ($i>0) $query.=", ";
                $key = mysql_field_name($res,$i);
                $query.= $key;
        }
        $query.= ") values (";
        for ($i=0;$i<$field_count;$i++){
                if ($i>0) $query.=", ";
                $key = mysql_field_name($res,$i);
                $query.= "'".$$key."'";
        }
        $query.=")";
        mysql_query($query);
}

$query = "select * from $table order by 1";
$res = mysql_query($query);
print "<TABLE border=\"1\">\n<TR>";
$field_count = mysql_num_fields($res);
for ($i=0;$i<$field_count;$i++){
        print "<TH>";
        print mysql_field_name($res,$i);
        print "</TH>";
}
print "</TR>\n";
print "<TR>";
print "<form method=\"post\" name\"comp_edit\">\n";
for ($j=0;$j<$field_count;$j++){
        print "<TD><input type=\"text\" name=\"";
        print mysql_field_name($res,$j);
        print "\"></TD>\n";
}
print '<TD><input name="action" type="submit" value="Add"></TD>';
print "</form>\n";
$row_count = mysql_num_rows($res);
for ($i=0;$i<$row_count;$i++){
        print "<TR>\n";
        print "<form method=\"post\" name\"comp_edit\">\n";
        for ($j=0;$j<$field_count;$j++){
                print "<TD><input type=\"text\" name=\"";
                print mysql_field_name($res,$j);
                print "\" value=\"";
                print mysql_result($res,$i,$j);
                print "\"></TD>\n";
        }
        print '<TD><input name="action" type="submit" value="Change"></TD>';
        print '<TD><input name="action" type="submit" value="Delete"></TD>';
        print '<input type="hidden" name="old_field0" value="';
        print mysql_result($res,$i,0);
        print '">';
        print "</form>\n";
}
print "</TABLE>\n";
?>
</BODY></HTML>

Sxooter

Did that fix work?

JackASmith

No.

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/x/s/xs/public_html/admin.php on line 61

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/x/s/xs/public_html/admin.php on line 77

Sxooter

Sounds like you're not connecting to your database. You need to read up on the mysql section of the manual, if you can't walk the last 6 feet to the fridge to get your milk you'll be eating dry cereal.