Toon posts:

[PHP] Admin-page problem

Pagina: 1
Acties:
  • 41 views sinds 30-01-2008

maandag 26 mei 2003 15:49

Acties:

Verwijderd

Topicstarter
Goededag,

Sinds een tijdje ben ik bezig een site aan het maken in PHP. Ik wil doormiddel van een soor Content Management Systeem (Admin-page) nieuws, gebruikers, events, etc. kunnen toevoegen.

De bedoeling is als er op een van de links in het menu wordt geklikt:

Nieuws bewerken :
Add News
Edit News

Members bewerken:
Add Member
Edit Member

Events bewerken:
Add events
Edit events

Images
Upload

Dan behoort het bijhorende formulier op dezelfde pagina (harrie.php) waarop het menu staat weergegeven.

Echter dit gebeurt niet. Wanneer er op een van de links wordt geklikt verschijnt gewoon het menu wederom zonder een formulier. Er verschijnt wel een URL als volgt: \harrie.php?action=addnews bijvoorbeeld. Maar het scherm blijft dus hetzelfde.

Iemand een idee?

Hieronder heb ik de code geplaatst:
<? include "connect.inc" ?>
<? include "header.inc" ?>

<?

if ($action == "") {showmenu();}
elseif ($action == "addnews") {addnews();}
elseif ($action == "listnews") {listnews();}
elseif ($action == "editnews") {editnews($ne_ID);}
elseif ($action == "postnews") {postnews($ne_ID, $ne_title, $ne_text, $ne_user, $ne_valid);}
elseif ($action == "adduser") {adduser();}
elseif ($action == "listuser") {listuser();}
elseif ($action == "edituser") {edituser($us_ID);}
elseif ($action == "postuser") {postuser($us_ID, $us_Name, $us_Level, $us_Rank, $us_email, $us_icq, $us_age, $us_city, $us_text, $us_valid);}

elseif ($action == "addevent") {addevent();}
elseif ($action == "listevent") {listevent();}
elseif ($action == "editevent") {editevent($ev_ID);}
elseif ($action == "postevent") {postevent($ev_ID, $ev_type , $ev_desc, $ev_date, $ev_stime, $ev_etime, $ev_us, $ev_them, $ev_user, $ev_valid) ;}

elseif ($action == "addlink") {addnews();}
elseif ($action == "editlink") {editnews();}
elseif ($action == "postlink") {postnews();}
elseif ($action == "addquote") {addnews();}
elseif ($action == "editquote") {editnews();}
elseif ($action == "postquote") {postnews();}


//.---------------------------------------------------------------.
//| Nieuws acties: |
//| tabel = t_news |
//| acties: addnews() toevoegen nieuws |
//| listnews() select lijst met te bewerken nieuws |
//| editnews() bewerken nieuws |
//| postnews() verwerken nieuws |
//| Variabelen: ne_ID - News ID |
//| ne_title - News titel |
//| ne_text - News tekst |
//| ne_user - News user |
//| ne_date - News Datum waarop nieuws is gepost |
//| ne_valid - Zichtbaar? |
//°---------------------------------------------------------------°

function postnews($ne_ID, $ne_title, $ne_text, $ne_user, $ne_valid)
{
$ne_title = addslashes(htmlentities($ne_title));
$ne_text = addslashes(htmlentities($ne_text));
$ne_user = addslashes(htmlentities($ne_user));
if($ne_ID != 99999)
{ $query = mysql_query("UPDATE t_news SET ne_title ='$ne_title', ne_text = '$ne_text', ne_user = '$ne_user', ne_valid = '$ne_valid' WHERE ne_ID = '$ne_ID'") or die ("aaaahhh ".mysql_error());
print("News edited, <BR><a href=\"harrie.php?action=listnews\">Click here to edit more news</A>");
}
else
{ $query = mysql_query("INSERT INTO t_news (ne_ID, ne_title, ne_text, ne_user, ne_date, ne_valid) VALUES ('', '$ne_title', '$ne_text', '$ne_user', NOW(''), '$ne_valid')") or die("ahhhhh".wmysql_error());

print("News added, <BR><a href=\"harrie.php?action=editnews\">Click here to add more news</A>");

}
print("<BR><a href=\"harrie.php\">Click here to return to admin menu</A>");

}
function addnews(){
print("Add news");
?>
<form method="post" action="harrie.php">
<input type=hidden name=action value="postnews">
<input type=hidden name=ne_ID value=99999>
<U>Title </U><BR>
<input name="ne_title" size=255><br>
<U>Text </U><BR>
<textarea name="ne_text" cols=70 rows=10> </textarea><br>
<U> Auteur </U><BR>
<input type="radio" name="ne_user" value="1"> Naam1<BR>
<input type="radio" name="ne_user" value="3"> Naam2<BR>
<input type="radio" name="ne_user" value="2"> Naam3<BR>


<U> Visible </U><BR>
Should this message be visible on the front page?<BR>
<input type="radio" name="ne_valid" value="1"> Zichtbaar<BR>
<input type="radio" name="ne_valid" value="0"> Niet zichtbaar<BR>
<br>
<input type=submit value="Process">
</form>
<?
}

function listnews() {
$query=mysql_query("SELECT ne_ID,ne_title from t_news");
print("Select an item to edit en press process<BR>");
print("<form method=\"post\" action=harrie.php>");
print("<input type=hidden name=action value=\"editnews\">");

while ($row = mysql_fetch_array($query))
{
print("<BR><input type=\"radio\" name=\"ne_ID\" value=\"".$row[0]."\"> ".$row[1]);
}

print("<BR><input type=submit value=\"Process\">");
print("</form>");

}

function editnews($ne_ID){

print("Edit news");

$query = mysql_query("SELECT ne_ID, ne_title,ne_text, ne_user, ne_valid from t_news where ne_ID = '$ne_ID'") or die(mysql_error());;

$row = mysql_fetch_array($query);
$ntitle = $row[1];
$ntext = $row[2];
$nuser = $row[3];
$nvisible = $row[4];
?> <form method="post" action="harrie.php">
<input type=hidden name=action value="postnews">
<input type=hidden name=ne_ID value="<?=$ne_ID ?>">
<U>Title </U><BR>
<input name="ne_title" size=255 value="<?=$ntitle ?>"><br>
<U>Text </U><BR>
<textarea name="ne_text" cols=70 rows=10><?=$ntext?> </textarea><br>
<U> Auteur </U><BR>
<input type="radio" name="ne_user" value="1"> Naam1<BR>
<input type="radio" name="ne_user" value="3"> Naam2<BR>
<input type="radio" name="ne_user" value="2"> Naam3<BR>

<U> Visible </U><BR>
Should this message be visible on the front page?<BR>
<input type="radio" name="ne_valid" value="1"> Zichtbaar<BR>
<input type="radio" name="ne_valid" value="0"> Niet zichtbaar<BR>
<input type=submit value="Process">
</form>
<?
}

//.---------------------------------------------------------------.
//| Nieuws acties: |
//| tabel = t_news |
//| acties: adduser() toevoegen member |
//| listuser() select lijst met te bewerken nieuws |
//| edituser() bewerken nieuws |
//| postuser() verwerken nieuws |
//| Variabelen: ne_ID - News ID |
//| ne_title - News titel |
//| ne_text - News tekst |
//| ne_user - News user |
//| ne_date - News Datum waarop nieuws is gepost |
//| ne_valid - Zichtbaar? |
//°---------------------------------------------------------------°
//

function adduser(){

?>
User details<BR>
<form method=post>

<table>
<tr valign=top>
<td>
<B>User</B>
</td>
<td>
<input type=hidden name=action value="postuser">
<input type=hidden name=us_ID value="99999">
<input type=text name=us_Name value="<?=$us_Name ?>"></td></tr>
<tr>
<td>
Rank
</td>
<td>
<select name=us_Rank size=1>
<?
$query = mysql_query("select ra_ID, ra_rank FROM t_Ranks");
while($row = mysql_fetch_row($query))
{
print("<option value=\"".$row[0]."\">".$row[1]."</option>");
} ?>


</select></td></tr>

<tr>
<td>
Level
<td>
<select name=us_Level size=1>
<?php
$query = mysql_query("select le_ID, le_text FROM t_Level");
while($row = mysql_fetch_row($query))
{ print("<option value=\"".$row[0]."\">".$row[1]."</option>"); }
?>

</select></td></tr>


<tr>
<td>
Password
</td>
<td>
<input type=text name=us_Password></td></tr>
</table>

<BR><B>User info</p>


<table>
<tr>
<td>
E-Mail
</td>
<td>
<input type=text name=us_email size=80></td></tr>
<tr>
<td>
ICQ
</td>
<td>
<input type=text name=us_icq>
</td>
</tr>
<tr>
<td>
Age
</td>
<td>
<input type=text name=us_age size=80>
</td>
</tr>
<tr>
<td>
City
</td>
<td>
<input type=text name=us_city size=80>
</td>
</tr>
<tr>
<td>
Text
</td>
<td>
<textarea name=us_text wrap rows=3 cols=60></textarea>
</td>
</tr>
</table>

<BR><B>System</B>

<table>
<tr>
<td>
User Active
</td>
<td>
<input type="radio" name="us_valid" value="1"> Yes<BR>
<input type="radio" name="us_valid" value="0"> No<BR>

</td>
</tr>
<tr>
<td>
<input type=submit value="Process">
</td>
<td>
</td>
</tr>
</table>

</form>

<?
}
function edituser($us_ID){
$rq = mysql_query("SELECT us_ID,us_Name,us_Level,us_Rank,us_email,us_icq,us_age,us_city,us_text,us_valid,us_Password from t_user where us_ID = '$us_ID'");
$urow = mysql_fetch_array($rq);

?>
User details<BR>
<form method=post>

<table>
<tr valign=top>
<td>
<B>User</B>
</td>
<td>
<input type=hidden name=action value="postuser">
<input type=hidden name=us_ID value="<?=$urow[0] ?>">
<input type=text name=us_Name value="<?=$urow[1] ?>"></td></tr>
<tr>
<td>
Rank
</td>
<td>
<select name=us_Rank size=1>
<OPTION SELECTED VALUE=<?=$urow[3]?>>
<?
$query = mysql_query("select ra_ID, ra_rank FROM t_Ranks order by ra_order ASC");
while($row = mysql_fetch_row($query))
{
print("<option value=\"".$row[0]."\">".$row[1]."</option>");
} ?>


</select></td></tr>

<tr>
<td>
Level
<td>
<select name=us_Level size=1>
<OPTION SELECTED VALUE=<?=$urow[2]?>>
<?php
$query = mysql_query("select le_ID, le_text FROM t_Level");
while($row = mysql_fetch_row($query))
{ print("<option value=\"".$row[0]."\">".$row[1]."</option>"); }
?>

</select></td></tr>


<tr>
<td>
Password
</td>
<td>
<input type=text name=us_Password value="<?=$urow[10] ?>"></td></tr>
</table>

<BR><B>User info</p>


<table>
<tr>
<td>
E-Mail
</td>
<td>
<input type=text name=us_email size=80 value="<?=$urow[4] ?>"></td></tr>
<tr>
<td>
ICQ
</td>
<td>
<input type=text name=us_icq value="<?=$urow[5] ?>">
</td>
</tr>
<tr>
<td>
City
</td>
<td>
<input type=text name=us_city size=80 value="<?=$urow[7] ?>">
</td>
</tr>
<tr>
<td>
Age
</td>
<td>
<input type=text name=us_age size=2 value="<?=$urow[6] ?>">
</td>
</tr>
<tr>
<td>
Text
</td>
<td>
<textarea name=us_text wrap rows=3 cols=60><?=$urow[8] ?></textarea>
</td>
</tr>
</table>

<BR><B>System</B>

<table>
<tr>
<td>
User Active
</td>
<td>
<input type="radio" name="us_valid" value="1"> Yes<BR>
<input type="radio" name="us_valid" value="0"> No<BR>

</td>
</tr>
<tr>
<td>
<input type=submit value="Process">
</td>
<td>
</td>
</tr>
</table>
</form>

<?

}

function listuser() {
$query=mysql_query("SELECT us_ID,us_Name from t_user");
print("Select an user to edit en press process<BR>");
print("<form method=\"post\" action=harrie.php>");
print("<input type=hidden name=action value=\"edituser\">");

while ($row = mysql_fetch_array($query))
{
print("<BR><input type=\"radio\" name=\"us_ID\" value=\"".$row[0]."\"> ".$row[1]);
}

print("<BR><input type=submit value=\"Process\">");
print("</form>");

}
function postuser($us_ID, $us_Name, $us_Level, $us_Rank, $us_email, $us_icq, $us_age, $us_city, $us_text, $us_valid)
{
if ($us_ID != "99999") {
$query=mysql_query("UPDATE t_user SET us_Name = '$us_Name', us_Level = '$us_Level', us_Rank = '$us_Rank', us_email = '$us_email', us_icq = '$us_icq', us_age = '$us_age', us_city = '$us_city', us_text = '$us_text', us_valid = '$us_valid', us_Password = '$us_Password' WHERE us_ID = '$us_ID' ") or die(mysql_error());
print("User edited, <BR><a href=\"harrie.php?action=listuser\">Click here to edit another user</A>");
}else{
$query=mysql_query("INSERT INTO t_user (us_Name, us_Level, us_Rank, us_email, us_icq, us_age, us_city, us_text, us_valid, us_Password, filler2) VALUES ( '$us_Name', '$us_Level', '$us_Rank', '$us_email', '$us_icq', '$us_age', '$us_city', '$us_text', '$us_valid', '$us_Password', '') ") or die(mysql_error());
print("User added, <BR><a href=\"harrie.php?action=adduser\">Click here to add another user</A>");
print("<BR><a href=\"harrie.php\">Click here to return to admin menu</A>");
}

}

//.---------------------------------------------------------------.

function addevent(){

?>
Event details<BR>
<form method=post>

<table>
<tr valign=top>
<td>
<B>date</B>
</td>
<td>
<input type=hidden name=action value="postevent">
<input type=hidden name=ev_ID value="99999">
<input type=hidden name=ev_us value="0">
<input type=hidden name=ev_them value="0">
<input type=text name=ev_date value="<?=$us_Name ?>"></td></tr>
<tr>
<td>
Type
</td>
<td>
<select name=ev_type size=1>
<?
$query = mysql_query("select et_ID, et_text FROM t_event_type");
while($row = mysql_fetch_row($query))
{
print("<option value=\"".$row[0]."\">".$row[1]."</option>");
} ?>


</select></td></tr>
<tr>
<td>
Start tijd
</td>
<td>
<input type=text name=ev_stime></td></tr>
<tr>
<td>
Eind tijd
</td>
<td>
<input type=text name=ev_etime></td></tr>
<tr>
<td>
Beschrijving
</td>
<td>
<textarea name=ev_desc wrap rows=3 cols=60></textarea>
</td>
</tr>
<tr>
<td>
Author
</td>
<td>
<input type="radio" name="ev_user" value="1"> Naam1<BR>
<input type="radio" name="ev_user" value="3"> Naam2<BR>
<input type="radio" name="ev_user" value="2"> Naam3<BR>
</td>
</tr>


</table>

<table>
<tr>
<td>
<input type=submit value="Process">
</td>
<td>
</td>
</tr>
</table>

</form>

<?
}

//---------------------------------------------------------------
function postevent($ev_ID, $ev_type , $ev_desc, $ev_date, $ev_stime, $ev_etime, $ev_us, $ev_them, $ev_user, $ev_valid)
{
if ($ev_ID != "99999") {
$query=mysql_query("UPDATE t_event SET ev_type = '$ev_type', ev_desc= '$ev_desc', ev_date = '$ev_date', ev_stime = '$ev_stime', ev_etime = '$ev_etime', ev_user = '$ev_user', ev_valid = '$ev_valid', ev_us = '$ev_us', ev_them = '$ev_them' WHERE ev_ID = '$ev_ID' ") or die(mysql_error());
print("event edited, <BR><a href=\"harrie.php?action=listevent\">Click here to edit another event</A>");
}else{
$query=mysql_query("INSERT INTO t_event (ev_type, ev_desc, ev_date, ev_stime, ev_etime, ev_user, ev_valid, ev_us, ev_them) VALUES ( '$ev_type', '$ev_desc', '$ev_date', '$ev_stime', '$ev_etime', '$ev_user', '$ev_valid', '$ev_us', '$ev_them') ") or die(mysql_error());
print("event added, <BR><a href=\"harrie.php?action=addevent\">Click here to insert another event</A>"); }

print("<BR><a href=\"harrie.php\">Click here to return to admin menu</A>");
}

function listevent() {
$query=mysql_query("SELECT ev_ID,ev_date,ev_stime,et_text from t_event, t_event_type where ev_type = et_ID");
print("Select an event to edit en press process<BR>");
print("<form method=\"post\" action=harrie.php>");
print("<input type=hidden name=action value=\"editevent\">");

while ($row = mysql_fetch_array($query))
{
print("<BR><input type=\"radio\" name=\"ev_ID\" value=\"".$row[0]."\"> ".$row[1]." - ".$row[2]." - ".$row[3].".");
}

print("<BR><input type=submit value=\"Process\">");
print("</form>");

}

//.---------------------------------------------------------------.

function editevent($ev_ID){

$rq = mysql_query("SELECT ev_ID, ev_type, ev_desc, ev_date, ev_stime, ev_etime, ev_us, ev_them, ev_user, ev_valid from t_event where ev_ID = '$ev_ID'") or die(mysql_error());
print ("<BR> Event:".$ev_ID);
$urow = mysql_fetch_array($rq);


?>
<BR>
Event details<BR>
<form method=post>
<input type=hidden name=action value="postevent">
<input type=hidden name=ev_ID value="<?=$ev_ID ?>">
<table>
<tr valign=top>
<td>
<B>date</B>
</td>
<td>
<input type=text name=ev_date value="<?=$urow[3] ?>"></td></tr>
<tr>
<td>
Type
</td>
<td>
<select name=ev_type size=1>
<?
$query = mysql_query("select et_ID, et_text FROM t_event_type");
while($row = mysql_fetch_row($query))
{
print("<option value=\"".$row[0]."\">".$row[1]."</option>");
} ?>


</select></td></tr>
<tr>
<td>
Start tijd
</td>
<td>
<input type=text name=ev_stime value="<?=$urow[4] ?>"></td></tr>
<tr>
<td>
Eind tijd
</td>
<td>
<input type=text name=ev_etime value="<?=$urow[5] ?>"></td></tr>
<tr>
<td>
Beschrijving
</td>
<td>
<textarea name=ev_desc wrap rows=3 cols=60><?=$urow[2] ?></textarea>
</td>
</tr>
<tr>
<td>
Author
</td>
<td>
<input type="radio" name="ev_user" value="1"> Gertman<BR>
<input type="radio" name="ev_user" value="2"> DPhoenix<BR>
<input type="radio" name="ev_user" value="3"> Terror<BR>
</td>
</tr>


</table>
<br>
<table>
<tr>
<td>
<b><u>Only for wars</u></b>
</td>
<td>
</td>
</tr>
<tr>
<td>
Us
</td>
<td>
<input type=text name=ev_us value="<?=$urow[6] ?>"></td></tr>
</td>
</tr>
<tr>
<td>
them
</td>
<td>
<input type=text name=ev_them value="<?=$urow[7] ?>"></td></tr>
</td>
</tr>


</table>

<table>
<tr>
<td>
<input type=submit value="Process">
</td>
<td>
</td>
</tr>
</table>

</form>

<?
}

//.---------------------------------------------------------------.
//| Display admin menu |
//°---------------------------------------------------------------°
//

function showmenu()
{ print("<B>Nieuws bewerken : ");
print("<a href=\"harrie.php?action=addnews\">Add News</a> - ");
print("<a href=\"harrie.php?action=listnews\">Edit News</a>");

print("<BR>Members bewerken: ");
print("<a href=\"harrie.php?action=adduser\">Add Member</a> - ");
print("<a href=\"harrie.php?action=listuser\">Edit Member</a>");

print("<BR>Events bewerken: ");
print("<a href=\"harrie.php?action=addevent\">Add events</a> - ");
print("<a href=\"harrie.php?action=listevent\">Edit events</a>");

print("<BR>Images (hou de grootte in de gaten!): ");
print("<a href=\"upload.php\">Upload</a>");


}

?>
<?php


/* Ik heb de waarden hier ff gewist */
$mysql_username = "root"; /* vul hier je MySQL username bij je host in */
$mysql_password = ""; /* vul hier je MySQL password bij je host in */
$mysql_server = "localhost"; /* vul hier je MySQL server bij je host in */
$mysql_dbname = "SAsite"; /* vul hier je MySQL database bij je host in */

mysql_connect($mysql_server, $mysql_username, $mysql_password);
mysql_select_db("SAsite");
?>

maandag 26 mei 2003 15:52

Acties:
  • gorgi_19
  • Registratie: Mei 2002
  • Laatst online: 20-08 11:40

gorgi_19

Kruimeltjes zijn weer op :9

Erhm.. Gekke vraag.. Maar zo een enorme lap code met de opmerking: het werkt niet. Kunnen we hier weinig mee. Met andere woorden: ik ga iig niet voor jou debuggen.. Als je relevante code hebt, maakt het allemaal een stuk makkelijker.

In het kader van gokken: Een verhaaltje over superglobals

[ Voor 17% gewijzigd door gorgi_19 op 26-05-2003 15:52 ]

Digitaal onderwijsmateriaal, leermateriaal voor hbo

maandag 26 mei 2003 15:53

Acties:
  • Glimi
  • Registratie: Augustus 2000
  • Niet online

Glimi

Designer Drugs

(overleden)
Ja, denk je echt dat iemand dat hele stuk gaat doorlezen omdat jij het probleem niet wilt isoleren ;)
Ga eerst zelf eens debuggen, en vervang die ladingen HTML es door gewoon een print "Optie1"; oid. Daarmee gooi je een hele lap code weg waar het probleem niet in kan zitten.

Vervolgens ga je dat compacte stukje code analyseren en dan moet het lukken om je fout te vinden :)

Aan de slag dus jij! :)

edit:
owjah [ php] en [/php] om je code heen, maakt het mooi gehighlighted :)

[ Voor 10% gewijzigd door Glimi op 26-05-2003 15:54 ]

Dit topic is gesloten.