By adman4054 on

I have a site that uses php to display information from the db on an article page. It displays the information just fine, but I have a non-techie that now needs to add and change the information. Is there some kind of gui that I can install that would make it easy for the person to perform the needed duties? Or maybe I'm missing something simple. When she goes to the story the body copy just has the php code in it, is there something else I can do to make it easy for her to input the info?
Thanks in advance.

⋅ Categories: Drupal 5.x

Comments

mikewheaton’s picture

mikewheaton commented

Could she be set up as a Drupal user and given access to modify the story directly through Drupal?

If she needs to change the data directly from the database, the simplest method I know of is phpMyAdmin. You'll need to create a new user and provide priveleges specifically for the table that is being used (to prevent her from damaging the rest of the site), but it is reasonably straightforward to use.

If you could provide a little more detail on the type of data in the database and why it can't be edited through Drupal that may help us come up with better ideas that would fit your situation.

adman4054’s picture

adman4054 commented

This is the code that appears on the "edit screen". I thought of PhpMyAdmin, but I'd like to leave that as a last resort, if at all possible I'd like her to be able to edit/add right form Drupal. Thanks again!:)

<? 
$id_topic = $_REQUEST['topic'];
if(isset($_REQUEST['topic'])){
$url="mysql://user:domain@localhost/use";
db_connect($url);
$query="SELECT * FROM `topics` WHERE IdTopic = ".$id_topic;
$result=db_query($query);
$topic=db_fetch_array($result);
$query="SELECT * FROM `states` ORDER BY State";
$result=db_query($query);
$result1=db_query($query);
$r = db_fetch_array($result);
$query="SELECT * FROM `comments_me` WHERE IdTopic = ".$id_topic;
$resultc=db_query($query);
if(db_num_rows($resultc)<>0){
echo '<p><font face="Arial" size="3"><strong>'.$topic['Topic']."</strong></font></p>";
?>
<p><font face="Arial" size="2">Choose your state:</font></p>
<p align="center"><font face="Arial" size="2">
<?
while($r){
?>
<a href="http://www.domain.com/index.php?q=node/76&state=<? echo $r['IdState'].'&topic='.$id_topic;?>"><? echo $r['State'];?></a>
<? 
$r = db_fetch_array($result);
if($r){
  echo " | ";
}
}
?>
</font></p> 
<?
$r = db_fetch_array($result1);
while($r){
?>
<p align="left"><font face="Arial" size="2"><font face="Arial" size="2"><font face="Arial" size="2"><font face="Arial" size="2"><font face="Arial" size="2">
<a href="http://www.doamain.com/index.php?q=node/76&state=<? echo $r['IdState'].'&topic='.$id_topic;?>"><? echo $r['State'];?></a></font></font></font></font></font></p> 
<? 
$r = db_fetch_array($result1);
}
}else{
  echo "Sorry, there are no comments for The Magic of Science.  Please check back later.";
}
}
?>