phpMyViews - Tutorial

Example 4 : Complex Example

Here's one config file, which I use for managing a crew list. Have a look at the screenshots.


<?php
  # MySQL Parameters
  $pmv_db_host="mysql_host";
  $pmv_db_name="mysql_db_name";
  $pmv_db_user="mysql_user";
  $pmv_db_pass="mysql_password";
  if (file_exists('pmv_db_config.php')) {
    include('pmv_db_config.php');
  }

  # 
  # default
  #
  $pmv['default'][0]['sql']='SELECT groups.groupname,titel,name,vorname,mitarbeiter.id,zimmer,email,telefon FROM mitarbeiter, groups WHERE mitarbeiter.group = groups.id ORDER BY name';
  $pmv['default'][0]['pre']='
      <form action="'.$PHP_SELF.'" method="POST">
          <input type="hidden" name="pmv_action" value="neu_form" />
        <input type="submit" value="Neuer Mitarbeiter" />
      </form>
      <table class="fine" style="font-size:xx-small">
    <tr><th>ID</th><th>Titel</th><th>Name</th><th>Vorname</th><th>Telefon</th><th>Email</th><th>Zimmer</th>
      <th>Gruppe</th><th colspan="2"></th></tr>';
  $pmv['default'][0]['main']='<tr>
      <td>$id</td><td>$titel</td>
    <td>$name</td><td>$vorname</td>
    <td>$telefon</td><td>$email</td>
    <td>$zimmer</td><td>$groupname</td>
    <td><form action="'.$PHP_SELF.'" method="POST">
        <input type="hidden" name="id" value="$id" /><input type="submit" title="L�schen" value="X" />
        <input type="hidden" name="pmv_action" value="confirm_delete" />
    </form></td>
    <td><form action="'.$PHP_SELF.'" method="POST">
        <input type="hidden" name="id" value="$id" /><input type="submit" title="Eintrag editieren" value="edit" />
        <input type="hidden" name="pmv_action" value="edit_entry" />
    </form></td></tr>';
  $pmv['default'][0]['post']='</table>';


  #
  # confirm_delete
  #
  $pmv['confirm_delete'][0]['sql']='SELECT * FROM mitarbeiter WHERE id=$id';
  $pmv['confirm_delete'][0]['main']='Mitarbeiter "$vorname $name" wirklich l�schen ?
      <form action="'.$PHP_SELF.'" method="POST">
            <input type="hidden" name="id" value="$id" />
            <input type="hidden" name="name" value="$name" />
            <input type="hidden" name="vorname" value="$vorname" />
        <input type="submit" title="L�schen" value="Ja, wirklich l�schen" />
        <input type="hidden" name="pmv_action" value="really_delete" />
    </form>
      <form action="'.$PHP_SELF.'" method="POST">
        <input type="submit" value="Nein, zur�ck" />
    </form>';

  #
  # really delete
  #
  $pmv['really_delete'][0]['sql']='DELETE FROM mitarbeiter WHERE id=$id LIMIT 1';
  $pmv['really_delete'][0]['pre']='Mitarbeiter "$vorname $name" wurde aus der Datenbank gel�scht.<br />
    <a href="'.$PHP_SELF.'">Zur Liste</a>';

  #
  # add new member (formular)
  #
  $pmv['neu_form'][0]['sql']='SELECT * FROM groups';
  $pmv['neu_form'][0]['pre']='
      <form action="'.$PHP_SELF.'" method="POST">
        <table class="fine">
            <tr><th>Titel</th><td><input type="text" size="40" name="Titel" /></td></tr>
            <tr><th>Name</th><td><input type="text" size="40" name="Name" /></td></tr>
            <tr><th>Vorname</th><td><input type="text" size="40" name="Vorname" /></td></tr>
            <tr><th>Telefon</th><td><input type="text" size="40" name="Telefon" /></td></tr>
            <tr><th>Email</th><td><input type="text" size="40" name="Email" /></td></tr>
            <tr><th>Zimmer</th><td><input type="text" size="40" name="Zimmer" /></td></tr>
            <tr><th>URL zum Foto</th><td><input type="text" size="40" name="Foto" /></td></tr>
            <tr><th>Interessen</th><td><textarea cols="40" rows="5" name="Interessen"></textarea></td></tr>
            <tr><th>Lehre</th><td><textarea cols="40" rows="5" name="Lehre"></textarea></td></tr>
            <tr><th>Sonstiges</th><td><textarea cols="40" rows="5" name="Sonstiges"></textarea></td></tr>
            <tr><th>URL zur Homepage</th><td><input type="text" size="40" name="Homepage" /></td></tr>
            <tr><th>Generierte HP anzeigen?<br />(1=ja,0=nein)</th><td><input type="text" size="1" name="StandardHP" value="1" /></td></tr>
            <tr><th>Gruppe</th>
            <td><select name="Gruppe" size="1">';
  $pmv['neu_form'][0]['main']='
                <option value="$id">$groupname</option>';            
  $pmv['neu_form'][0]['post']='
              </select></td></tr>
        </table><br />
        <input type="submit" value="Eintragen" />
        <input type="hidden" name="pmv_action" value="insert_new" />
    </form>';        

  #
  # insert new member into the database
  #

  $pmv['insert_new'][0]['sql']='INSERT INTO mitarbeiter (titel,name,vorname,telefon,email,zimmer,foto,interessen,lehre,sonstiges,homepage,standardhp,`group`) VALUES ("$Titel","$Name","$Vorname","$Telefon","$Email","$Zimmer","$Foto","$Interessen","$Lehre","$Sonstiges","$Homepage","$StandardHP","$Gruppe")';
  $pmv['insert_new'][0]['pre']='Mitarbeiter "$Vorname $Name" wurde hinzugef�gt.<br />
      <a href="'.$PHP_SELF.'">Zur Liste</a>';

  #
  # edit member
  #
  $pmv['edit_entry'][0]['sql']='SELECT * FROM mitarbeiter WHERE id=$id';
  $pmv['edit_entry'][0]['main']='
        <form action="'.$PHP_SELF.'" method="POST">
                <table class="fine">
                        <tr><th>Titel</th><td><input type="text" size="40" name="Titel" value="$titel" /></td></tr>
                        <tr><th>Name</th><td><input type="text" size="40" name="Name" value="$name" /></td></tr>
                        <tr><th>Vorname</th><td><input type="text" size="40" name="Vorname" value="$vorname" /></td></tr>
                        <tr><th>Telefon</th><td><input type="text" size="40" name="Telefon" value="$telefon" /></td></tr>
                        <tr><th>Email</th><td><input type="text" size="40" name="Email" value="$email" /></td></tr>
                        <tr><th>Zimmer</th><td><input type="text" size="40" name="Zimmer" value="$zimmer" /></td></tr>
                        <tr><th>URL zum Foto</th><td><input type="text" size="40" name="Foto" value="$foto" /></td></tr>
                        <tr><th>Interessen</th><td><textarea cols="40" rows="5" name="Interessen">$interessen</textarea></td></tr>
                        <tr><th>Lehre</th><td><textarea cols="40" rows="5" name="Lehre">$lehre</textarea></td></tr>
                        <tr><th>Sonstiges</th><td><textarea cols="40" rows="5" name="Sonstiges">$sonstiges</textarea></td></tr>
                        <tr><th>URL zur Homepage</th><td><input type="text" size="40" name="Homepage" value="$homepage" /></td></tr>
                        <tr><th>Generierte HP anzeigen?<br />(1=ja,0=nein)</th><td><input type="text" size="1" name="StandardHP" value="$standardhp" /></td></tr>
                </table><br />
                <input type="submit" value="�ndern" />
                <input type="hidden" name="id" value="$id" />
                <input type="hidden" name="pmv_action" value="update_entry" />
        </form>';
  
  #
  # write updated entry into database
  #

  $pmv['update_entry'][0]['sql']='UPDATE mitarbeiter SET titel="$Titel", name="$Name", vorname="$Vorname", 
    telefon="$Telefon", email="$Email", zimmer="$Zimmer", foto="$Foto", 
    interessen="$Interessen", lehre="$Lehre", sonstiges="$Sonstiges", 
    homepage="$Homepage", standardhp="$StandardHP" WHERE id=$id';
  $pmv['update_entry'][0]['pre']='Mitarbeitereintrag "$Vorname $Name" wurde ge�ndert.<br />
      <a href="'.$PHP_SELF.'">Zur Liste</a>';

  # execute phpMyViews
  //$path_to_pmv=$_SERVER['DOCUMENT_ROOT']."/phpmyviews.php";
  $path_to_pmv="phpmyviews.php";
  include($path_to_pmv);
?>

I will not explain all different sections, but explain some of the important and interesting aspects of this PMV config.

the 'default' action simply lists all entries and prints small buttons in each line for editing and deleting the entry. at the beginning of the page, it creates a button for new users.
the delete process includes two steps: when the delete button is pressed, the pmv_action 'confirm_delete' is called which displays some information about the entry to be deleted. if then the delete button is pressed, the pmv_action 'really_delete' performs the database operation to delete the entry and displays a confirmation message.
the new member process also includes two steps, the first one displays an empty HTML form, the following step performs the real database insert.
as all good things are three, the update task consists also of two steps, the first one, which gets all data from the database and displays it in a HTML form for edit purpose, and the following one, to update the database entry.

Previous page Next page