Fork me on GitHub

Watch

GitHub Core

Show your support for Zikula! Sign up at Github account and watch the Core project!




GitHub Modules

Forum Activity

Forum feed

» Visit forum | » View latest posts

Maximising the database PHP within MySQL and Postnuke  Bottom

  • Down to the nitty gritty of hard coding
    I'm searching for a comprehensive reference list of commands that can be used to retrieve and send data to and from the postnuke database.
    There is a need for a technical manual for PostNuke where we can reference code for a particular function. Let me explain further, I like to build a module or even a simple data retrieve. The PHP manual is a bit daunting for the beginner and since there is no PostNuke technical manual yet.

    In this example helps us to understand the How! behind PHP and MYSQL

    For example to read data from a table in PHP

    $Query="SELECT * from$TableName";

    The asterisk is the equivalent of saying everything (so this query states "select everything from $TableName"). This four-word statement will frequently be used for data retrieval.

    However, you could limit the query by writing SELECT FirstName, Comments from $TableName. This query requests two columns (FirstNames and Comments) be gathered.

    Then to asign the results of the query to a variable

    $Result=mysql_db_query($DBName, $Query, $Link);

    This variable now knows what the result of the query is. In order to access multiple rows of information retrieved, you should run the $Result variable through a loop.

    while($Row=mysql_fetch_array($Result)){
    statements;
    }

    And so on......


    Back to PostNuke there is a need for this approach where we can customise and retrieve data and place the results in a block, page or module. But my request is to provide this simular information available so PostNuke is seen to be flexable. This will also help us explain How Postnuke works.

    What are the other options in Postnuke and can they be made available.
    I think there is need for reference notes even if we study one module example this will help us to learn and develop the coding behind Postnuke.




    PHPNUKES.CO.UK
    Web site that is working towards crystal clear notes for Postnuke commentaries and tutors.
  • Have you tried http://noc.postnuke.com? There you can get answers about hardcode and development of modules and pnAPI docs.

    Also, you can always use the search tool of this forums, to get help about the PN official module development guide (pnMDG) , and the docs for pnAPI.

    And one more alternative is to visit here:

    http://support.postnuke.com/modules.php?op=modload&name=News&file=article&sid=103

    I find it through a simple search in pnSUPPORT postnuke.com portal, on the main page, on the yellow section :)

    Hope this helps.

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