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.
Watch
GitHub Core
Show your support for Zikula! Sign up at Github account and watch the Core project!
GitHub Modules
- Paustian responded to »Short URL questions« 05:49 AM
- mesteele101 responded to »Problem in Database Connection« 02:25 AM
- mesteele101 created topic »Bug in the SMTP mail transfer protocol - Port 25 - Zikula 1.2.9« 20. May
- Herr.Vorragend responded to »Clip Documentation and Doubt« 19. May
- mazdev responded to »zikula 1.3.3. and IE9« 19. May
- mesteele101 responded to »How to install Zikula for MSSQL ??? - Part II« 19. May
- mesteele101 created topic »File packaging« 16. May
Zikula Blog
- Anatomy of Open Source Projects on Mar 07
- Continuous Review on Mar 01
- Not Invented Here on Feb 24
- How to Contribute Your Code at Github on Jan 13
- 10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
- Submitting Bug Report Tickets That Get Results on Aug 17
- Cozi Tricks #1: Syntax Highlighting on Aug 07
Login
Maximising the database PHP within MySQL and Postnuke
-
- Rank: Freshman
- Registered: Dec 31, 1969
- Last visit: Oct 21, 2009
- Posts: 93
-
**unknown user**
- Rank: Softmore
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 103
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.
- Moderated by:
- Support
