Fork me on GitHub

create new db entry help *SOLVED*  Bottom

  • I am posting my code for the pnadminapi and the pnadmin for creating a new entry into my database.

    When i go through the process the form displays fine. when i submit, it seems as though nothing happens. It redirects to the view function, which it should do, however, no message is displayed (error or successfull entry or no auth) and no entry is added to the DB.

    i know this is alot of code, but i need help. thanks

    phadmin.php:

    Code

    function roqFacilities_admin_main()
    {

        if (!pnSecAuthAction(0, 'roqFacilities::', '::', ACCESS_EDIT)) {
            return pnVarPrepHTMLDisplay(_MODULENOAUTH);
        }

        $pnRender =& new pnRender('roqFacilities');

        return $pnRender->fetch('roqFacilities_admin_main.htm');
    }

    function roqFacilities_admin_new()
    {
        if (!pnSecAuthAction(0, 'roqFacilities::', '::', ACCESS_ADD)) {
            return pnVarPrepHTMLDisplay(_MODULENOAUTH);
        }
       
        $pnRender =& new pnRender('roqFacilities');

        $pnRender->caching = false;
           
        return $pnRender->fetch('roqFacilities_admin_new.htm');
    }

    function roqFacilities_admin_create($args)
    {
        list($name
             ) = pnVarCleanFromInput('name');

        extract($args);

        if (!pnSecConfirmAuthKey()) {
            pnSessionSetVar('errormsg', pnVarPrepHTMLDisplay(_BADAUTHKEY));
            pnRedirect(pnModURL('roqFacilities', 'admin', 'view'));
            return true;
        }

        if (!pnModAPILoad('roqFacilities', 'admin')) {
            pnSessionSetVar('errormsg', pnVarPrepHTMLDisplay(_LOADFAILED));
            pnRedirect(pnModURL('roqFacilities', 'admin', 'view'));
            return true;
        }

        $fid = pnModAPIFunc('roqFacilities',
                            'admin',
                            'create',
                            array('name' => $name));

        if ($fid) {
            // Success
            pnSessionSetVar('statusmsg', pnVarPrepHTMLDisplay(_ROQFACILITIESCREATED));
        }

        pnRedirect(pnModURL('roqFacilities', 'admin', 'view'));

        return true;
    }



    pnadminapi.php

    Code

    function roqFacility_adminapi_create($args)
    {
        extract($args);

        if ((!isset($name) )) {
            pnSessionSetVar('errormsg', _MODARGSERROR);
            return false;
        }

        if (!pnSecAuthAction(0, 'roqFacilities::', "::", ACCESS_ADD)) {
            pnSessionSetVar('errormsg', _MODULENOAUTH);
            return false;
        }

        $dbconn =& pnDBGetConn(true);
        $pntable =& pnDBGetTables();

        $roqFacilitiestable  = &$pntable['roqFacilities'];
        $roqFacilitiescolumn = &$pntable['roqFacilities_column'];

        $nextId = $dbconn->GenId($roqFacilitiestable);

        list($name) = pnVarPrepForStore($name);

        $sql = "INSERT INTO $roqFacilitiestable (
                  $roqFacilitiescolumn[fid],
                  $roqFacilitiescolumn[name]
                  )
                VALUES (
                  '"
    .(int)$nextId."',
                  '"
    .$name."'
                  )"
    ;
        $dbconn->Execute($sql);

        if ($dbconn->ErrorNo() != 0) {
            pnSessionSetVar('errormsg', _ROQFACILITIESCREATEFAILED);
            return false;
        }

        $fid = $dbconn->PO_Insert_ID($roqFacilitiestable, $roqFacilitiescolumn['fid']);

        pnModCallHooks('item', 'create', $fid, 'fid');

        return $fid;
    }


    roqFacilities_admin_new.php

    Code

    <!--[*  $Id: roqFacilities_admin_new.htm,v 1.7 2004/04/05 19:47:51 markwest exp $  *]-->
    <!--[include file="roqFacilities_admin_menu.htm"]-->
    <br /><br />
    <div class="pn-title"><!--[pnml name="_ROQFACILITIESADD"]--></div>
    <form action="<!--[pnmodurl modname="roqFacilities" type="admin" func="create"]-->" method="post" enctype="application/x-www-form-urlencoded">
    <div>
      <input type="hidden" name="authid" value="<!--[pnsecgenauthkey module="roqFacilities"]-->" />
      <table width="506">
        <tr>
          <td width="124" align="right"><label for="roqFacilities_name"><!--[pnml name="_ROQFACILITIESNAME"]--></label></td>
          <td width="370"><input id="roqFacilities_name" name="name" type="text" size="32" maxlength="32" /></td>
        </tr>
      </table>
      <input name="submit" type="submit" value="<!--[pnml name="_ROQFACILITIESADD"]-->" />
    </div>
    </form>


    shouldn't i be getting SOME kind of message, error, success, or no auth?

    if not can anybody see what my problem might be?

    thanks
  • 0 users

This list is based on users active over the last 60 minutes.