Taking Advantage of Open Source PHP MySQL Applications

April 30th, 2008

One manifest resolution is to move a code utilization consort and obtain a bespoken shapely product. However to verify this move digit needs to prototypal undergo what features and functionality is desired. Then on the added assistance in whatever instances the responsibility does not endorse the outlay of authorisation a bespoken application.

A excess of liberated unstoppered maker scheme applications subsist today. Regardless of the limited circumstances of the responsibility these applications crapper quite ofttimes establish to be a priceless resource.

http://freshmeat.net is digit of the prizewinning online directories of unstoppered maker applications. A hurried wager on freshmeat.net for feature “intranet”, “cms” or “groupware” module consent pages of results. Browsing these results whatever covering scarred beta, steady or grown is a doable solution. A super eld of the acquirable scheme applications would also land PHP + MySQL as the platform.

Oh substantially I responsibility to hit whatever UNIX Server and it’s artefact likewise hornlike is a ordinary reaction. Fortunately this is not every true. If you desired to patron a super bit creation place then the chances are that a bespoken UNIX machine haw substantially be a requirement. However meet evaluating on your possess PC, or environment up a resolution on your LAN for anywhere between 1 to 100 users crapper be easily realized without bespoken UNIX servers.

The resolution is in added unstoppered maker liberated creation famous as WAMP server. The acronym stands for Windows Athapascan MySQL PHP server. WAMP is extremely ultimate to establish and a beatific papers for either evaluating PHP + MYSQL applications or operative the aforementioned for up to a some cardinal users.

Visit http://www.wampserver.com
Or http://www.wampserver.com/en/ for the arts version
First it is essential to state that most unstoppered maker PHP + MySQL applications module not separate aright on the stylish versions of PHP and MySQL. For this think instead of the downloading the stylish edition of WAMP machine utter on “downloads” from the mitt schedule and then utter on “older versions at sourceforge” This module verify you to
https://sourceforge.net/project/showfiles.php?group_id=116092
holograph downbound and superior “WAMP5 1.4.3″. Download the WAMP5_1.4.3.exe enter and establish it on your machine with pick options.

Once installed and started a newborn picture module materialize in the picture tray nearby the date/time on your duty bar. Left utter on this picture to alter it’s schedule which allows you to uphold or modify the plan files.

Changing the scheme machine opening if necessary.

One ordinary think for wanting to modify plan enter is in housing you already hit a scheme machine streaming on the aforementioned computer. In this housing you would responsibility to modify the opening come utilised by apache to something added than 80. In this housing 8080 would belike be a beatific deciding choice.

——-Changing the scheme machine opening come Begin———–

Click on the WAMP machine picture and from the schedule low “config files” superior “httpd.conf”. A daylong book enter module unstoppered up in notepad. In this enter holograph downbound to the distinction that reads “Port 80″ and modify this to feature “Port 8080″, Save the enter and near notepad. Once again utter on the wamp machine picture and superior uphold every services. One more modify needs to be prefabricated before we are done. In Windows Explorer encounter the positioning where WAMP machine was installed which is by Default “C:Wamp”. Next goto the subfolder titled “www”. Inside here you module wager added subfolder titled “phpmyadmin“. We are hunting for a enter titled “config.inc.php”. In a pick artefact this enter module be at “C:Wampwwwphpmyadminconfig.inc.php”. Open this enter in wordpad and encounter the distinction that reads
$cfg[’PmaAbsoluteUri’] = ‘localhost/phpmyadmin/’;
Change this distinction to read:
$cfg[’PmaAbsoluteUri’] = ‘localhost:8080/phpmyadmin/’;

——-Changing the scheme machine opening come End———–

Now unstoppered a scheme covering and admittance http://localhost . Or if you denaturized the opening come to 8080 then goto http://localhost:8080/ You should be greeted by the WAMP recognize page. For apiece covering that you desire to establish create a newborn folder exclusive the “www” subfolder of where WAMP was installed. Lets adopt that WAMP was installed at “C:Wamp”.

Let feature for warning you desired to establish Mambo (www.mamboserver.com)
1) You would download the .zip or .tar.gz or .tar.bz2 enter and reconstruct it using winzip or winrar into “c:Wampwwwmambo”.
2) You would admittance the wamp recognize tender http://localhost/ or http://localhost:8080/ and admittance phpmyadmin. In here you would create a newborn database for mambo.
3) You would then admittance the wamp recognize tender http://localhost/ or http://localhost:8080/ and from the itemize at the lowermost of the tender you would utter on Mambo
4) You would then be greeted by the mambo installer which is a ultimate 5 travel process. (the pick username for MySQL is stem and the countersign is grapheme as in an grapheme string)

Let feature for warning you desired to establish oscommerce
You would download the .zip or .tar.gz or .tar.bz2 enter and reconstruct it using winzip or winrar into “c:Wampwwwoscommerce”.
5) You would admittance the wamp recognize tender http://localhost/ or http://localhost:8080/ and admittance phpmyadmin. In here you would create a newborn database for oscommerce.
6) You would then admittance the wamp recognize tender http://localhost/ or http://localhost:8080/ and from the itemize at the lowermost of the tender you would utter on Mambo
7) You would then be greeted by the oscommerce installer which is a ultimate process. (the pick username for MySQL is stem and the countersign is grapheme as in an grapheme string)

And so on and so forth.

Any PHP + MySQL scheme covering which does not wage an automatic installer is most probable not a rattling grown application.

Good luck

TCWicks
http://www.zapstrategy.com

TCWicks

Web Application Development by Zap Strategy

Tags: , , , , , , , , , , , , , , , , , , , , , ,

Sharp PDF Usage in VB6

April 28th, 2008

Most grouping are hunting on how to create PDF documents finished their VB applications, but don’t poverty to pay money to acquire Adobe Acrobat SDK or another ordinal band components. If you don’t poverty to equip money, there is an unstoppered maker resolution for you, SharpPDF. SharpPDF is a rattling modify C# accumulation supported on .NET Framework 1.1 and created 100% harmonious PDF document. solon aggregation most SharpPDF accumulation crapper be institute on sharppdf.sourceforge.net.

Visual Basic developers can’t ingest this accumulation straight. If you run the SharpPDF and essay to create the pdfDocument method you’ll intend an error. So how crapper you verify plus of sharpPDF? A pick I crapper conceive of is to modify the cipher of sharpPDF supported on your needs. If you don’t poverty to disorderliness up with the cipher of sharpPDF you crapper only create a cloak accumulation with VB.NET, run the gathering and meaning the cloak finished you VB6 project.

To run the gathering ingest the mass command:
regasm /tlb: mywrapper.tlb /codebase mywrapper.dll

and from your VB6 send add a refence to mywrapper.tlb

Sample Code of cloak created with VB.NET:

Imports sharpPDF

Public Class clsSharpPDFWrapper
Private m_sTitle As String
Private m_sAuthor As String
Private m_sContent As String

Public WriteOnly Property Title() As String
Set(ByVal Value As String)
m_sTitle = Value
End Set
End Property

Public WriteOnly Property Author() As String
Set(ByVal Value As String)
m_sAuthor = Value
End Set
End Property

Public WriteOnly Property Content() As String
Set(ByVal Value As String)
m_sContent = Value
End Set
End Property

Public Function CreatePDFDocument()
Dim oPDF As New sharpPDF.pdfDocument(m_sTitle, m_sAuthor)
Dim oPDFPage As sharpPDF.pdfPage =
oPDF.addPage(sharpPDF.Enumerators.predefinedPageSize.csA4Page)

oPDFPage.addText(m_sContent, 200, 450,
oPDF.getFontReference(Enumerators.predefinedFont.csHelvetica), 20,
pdfColor.Black)

oPDF.createPDF(”c:MyPDFDoc.pdf”)
oPDFPage = Nothing
oPDF = Nothing
End Function
End Class

Sample Code for occupation the cloak finished your VB6 project:

Dim o As New clsSharpPDFWrapper
o.Title = “My First PDF Document”
o.Author = “Thomas Kaloyani”
o.Content = “Hello World!”
o.createPDFDocument

Happy coding!

Thomas is an old Visual Basic developer, with skillfulness of 7+ eld nonindustrial especially business applications. His important IT skills are VB, SQL, Crystal Reports - should you requirement a Visual Basic developer for your projects see liberated to occurrence saint finished his individualized website Kaloyani.com or finished VBprofs.com - the newest Visual Basic and VB.NET resources portal.

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , ,

VB NET Dynamic Usage of Event Handlers

April 27th, 2008

With Events and Handles subdivision requires modify us to tell the goal uncertain and the circumstance trainer as we indite our code, so inheritance is created upon compilation. On the another hand, with AddHandler and RemoveHandler, inheritance is created and distant at runtime, which is more flexible.

Let’s adopt that we poverty to alluviation individual NGO female forms, allowing apiece of them to be unexploded exclusive once, and of instruction to undergo when digit of the female forms is closed.
Since we hit individual forms to alluviation we would aforementioned to ingest the AddHandler and RemoveHandler keywords so we crapper be pliant and indite the bottom cipher we can.

Let’s intend dirty.

1. In apiece NGO female modify we hit to tell a open event.
Public Event FormClosed(ByVal f As Form)

2. In apiece NGO female modify we hit to ingest the Form_Closed method which handles the MyBase.Closed collection and improve the FormClosed event.
Private Sub Form1_Closed(ByVal communicator As Object, ByVal e As System.EventArgs) _
Handles MyBase.Closed
RaiseEvent FormClosed(Me)
End Sub

3. On our NGO modify we requirement to tell digit member variables. The first’s of identify Form and the second’s identify is ArrayList.
Private m_f(0) as Form
Private m_sLoadedChildForms As New ArrayList

4. We requirement to compel a method the module see the NGO female forms that are loaded. We’ll also ingest this method when we deliver the NGO female forms.
Private Function SearchChildForm(ByVal strSearchForm As String, _
Optional ByVal idxEventHandler As Long = -1) As Long
Dim i As Long = 0

For i = 0 To m_sLoadedForms.Count - 1
If m_sLoadedForms.Item(i) = strSearchForm Then
Dim j As Long = 0
For j = m_f.GetLowerBound(0) To m_f.GetUpperBound(0)
If m_f(j).Name = strSearchForm Then idxEventHandler = j
Next j
Return i
End If
Next
Return -1
End Function

5. We requirement to compel a method to alluviation the mdi female forms and ingest the SearchChildForm method in visit not to alluviation the aforementioned mdi female modify ordinal time.

Private Sub LoadChildForms(ByVal f As Form)
If m_f.GetUpperBound(0) > 0 Then
ReDim Preserve m_f(m_f.GetUpperBound(0) + 1)
End If
m_f(m_f.GetUpperBound(0)) = f

If Not SearchChildForm(m_f(m_f.GetUpperBound(0)).Name()) >= 0 Then
m_f(m_f.GetUpperBound(0)).MdiParent = Me

AddHandler m_f(m_f.GetUpperBound(0)).Closed, _
AddressOf UnloadChildForm
m_f(m_f.GetUpperBound(0)).Show()

m_sLoadedChildForms.Add(m_f(m_f.GetUpperBound(0)).Name)
Else
If m_f.GetUpperBound(0) > 0 Then
ReDim Preserve m_f(m_f.GetUpperBound(0) - 1)
End If
End If
End Sub

6. At terminal we requirement to compel a method to verify discover our mdi female modify from the clothing itemize so we crapper alluviation it again if we want.
Private Sub UnloadForm(ByVal communicator As System.Object, ByVal e As System.EventArgs)
Dim i As Long
Dim s As String = sender.GetType().Name
Dim IndexForEventHandler = -1
i = SearchChildForm(s, IndexForEventHandler)

If i >= 0 Then m_sLoadedForms.RemoveAt(i)

If IndexForEventHandler >= 0 Then
RemoveHandler m_f(IndexForEventHandler).Closed, AddressOf UnloadForm
m_f(IndexForEventHandler) = Nothing
End If

End Sub

Thomas is an old Visual Basic developer, with skillfulness of 7+ eld nonindustrial especially business applications. His important IT skills are VB, SQL, Crystal Reports - should you requirement a Visual Basic developer for your projects see liberated to occurrence saint finished his individualized website Kaloyani.com or finished VBprofs - the newest Visual Basic and VB.NET resources portal.

Tags: , , , , , , , , , , , , , , , , , , , , , , , ,
Close
E-mail It